Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying line from one sheet to another based on given criteria
Hello!
I create a sales stack ranking for a sales force that has a main page with everyones numbers across the nation. I also have a worksheet that has each sales persons numbers broken out by region. I want to know of a way to have a worksheet for florida read the main stack ranking page and pull lines of data that have "florida" in column g. Is there a way to do this? Right now I am making 10 copies of the main page, for 10 different regions, and then deleting the information on each WS that isn't for the specific region. This is really time consuming! Anyone know how to do this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying data from one worksheet to another based on criteria | Excel Discussion (Misc queries) | |||
Lookup function and compare | Excel Discussion (Misc queries) | |||
copying sheet references that refer to a cell in the preceding she | Excel Worksheet Functions | |||
Returning Results Based on Two Criteria | Excel Worksheet Functions | |||
How do I get info from a cell based on criteria from another cell | Excel Worksheet Functions |