Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to auto Name a Range based on criteria
Hello,
This is somewhat complicated, so I will try to explain best I can. I have a data worksheet is a wb that is update weekly and new data is dumped on top of it. In the data, there are 250 rows with 6 columns. Column B has various departments and Column C has the positions that go with the department. For certain validation criteria, I need to name the range of only the positions (col C) that are in each department. So the data looks like this: Front Desk Agent Front Desk Supervisor Front Desk Asst Mgr Front Desk Mgr Housekeeping Housekeeper Housekeeping Houseman etc...etc...etc.. So, I would like to be able to run a macro and it would redefine the ranges for Front Desk and only use the positions. Then go on to housekeeping and so on. Any assistance would be gratefull. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summing a range of cells based on criteria in another range | Excel Worksheet Functions | |||
Summing based on a range of criteria | Excel Discussion (Misc queries) | |||
Sum based on Range Criteria | Excel Worksheet Functions | |||
MIN within range based on criteria | Excel Discussion (Misc queries) | |||
group rows in a range based on criteria from another range (vba) | Excel Programming |