Hi, I need to develope a macro for Excel to calculate desired profit margin depending on our cost. Here's the scenario.
A1: landing cost
If 0 <= A1 <= 2, then multiply 200% to A1 and write the target profit margin on B1
If 3 <= A1 <= 5, then multiply 150% to A1 and write the target profit...
Hi. I want to change the background color of "item" field on Aceess report to yellow, if it contains text "special editoin."-without case sensitivity. How would I do this? Conditoinal formatting only enables number values, not text. Thank you for your help.
Hi. I have a wireless router connected to our win 2003 network. Rough diagram is internet-> Linksys router -> wireless router & server -> switches
The wireless router's IP is setup as part of our network (given static IP, subnet, gateway, and DNS) It's...
Hello. I need to sort a column with combination of numbers(sales order#,) a space, and letters(category ID.) The current column is sorted by numbers and looks like this:
81000 WARRANTY
81001 WARRANTY
81002-A DLR
81003 DLR
81004 EXPORT
81005-A EXPORT
I need to sort the column in the following...
Hi. I have a database based on the structure of Northwind sample database, that is one price per product in the product table.
Recently the requirement has been changed, and I need to have multiple prices per product for different dealers. For example, product A sells for $10 to dealer A, but...
Hi. I have a tblorder and tbldetail, 1 to many relationship. tblorder has order A, B, C... and each order has detailed items in tbldetail for example CD1, CD2, CD3...
Each item has a number field named Qty for order quantity.
I'm wondering if I can add up the Qty field by items or get a total...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.