Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy variable rows of data to new sheet
I have to populate two tables in an Access database using the data contained
in several workbooks. The workbooks contain a row of data that will populate one of the tables (Customers) and one or more adjacent rows that contain the customer number and at least one account number that will poplulate the AcctNumb table. Here's an example: CustName CustNumb Document AccountNumb Abigail L Smith 990682764 Non-Doc 990682764 100384733 990682764 173550511 The first row will populate the Customer table. The second and third rows (in this example) will populate the AccountNumb table. The customer numbers will be the keys in each table. After I have copied rows two and three to a new sheet I want to delete those rows in the original sheet . The number of rows of data I will need to copy for each customer could vary from 1 to 10 or possibly more. Therefore, I need to be able to vary the number. I am going to have 8 workbooks that will require a similar operation utilizing the copy-paste-delete row routine so would like to be able to modify the code to adapt to the various sheets. Your help is most appreciated! |
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) | |||
copy data from sheet2 to sheet1 when sheet2 has variable # of rows | Excel Discussion (Misc queries) | |||
copy down with variable number of rows | Excel Discussion (Misc queries) | |||
Referencing cells and copy rows of data back to summary sheet | Excel Discussion (Misc queries) | |||
Loop/copy rows variable times to new sheet | Excel Programming |