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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Export rows to new sheet based on value from list of cells
Hi EdwinZ
I have code here to import http://www.rondebruin.nl/accessexcel.htm You can replace the string with a cell value Instead of enter field values in the code you can also use a cell value "ShipVia", "=", Sheets("Sheet1").Range("A2").Value And you can use a function from this page to make a destination cell http://www.rondebruin.nl/last.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "EdwinZ" wrote in message oups.com... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Export rows to new sheet based on value from list of cells
Thanks Ron, However when I try to use your macro (simple version, test1) I get an error this error: Compile error: Sub or function not defined I copied your input and only modified the required part.. What am I doing wrong? Thank you for your help!! Regards Edwin *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
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 |