Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Export rows to new sheet based on value from list of cells
Hello All,
I have been browsing, but cannot find the solution.. Here is the case: I have an access database export, which I need devided up in parts, based on cell values in one of the rows of the db extract. These entire rows should be exported to a new sheet.. So: I have a small table on sheet 1: Netherlands Belgium Luxembourg and a big bad database with countries in column B, on sheet 2.. What I would like is to make a macro, which starts looking for the first value (Netherlands) in the database, and exporting the matching rows to a new sheet. And when done, starts to look for Belgium and copies those results under the Netherlands rows in the new sheet. And so on, and so on ;) Hope somebody can help me out on this one, it would really be a help! Regards Edwin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy rows from one Data sheet to another sheet based on cell conte | Excel Discussion (Misc queries) | |||
Search for rows in one sheet and copy into another sheet based on customer id | Excel Worksheet Functions | |||
Copy Rows to New Sheet based on User Selection in Drop-down List | Excel Programming | |||
List rows in an order based on a cells value | Excel Discussion (Misc queries) | |||
how to find and copy values on sheet 2, based on a list on sheet 1 | Excel Programming |