Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am very new at VB and need to create a marco for excel
I have the following situation: A workbook with an unknown number of sheets. The first sheet is my summary table which has 2 columns and a variable number of rows. This table contains item# in column 1 and column 2 is for amounts (this column is blank). Sheet 2 onward has tables of varying sizes. Column 1 contains item # and 2 contains amounts. There a more columns but those are not important. Some rows contain no item #. The macro needs to: Look through all sheets starting with second one find item # matching the ones in the first sheet then copying over the amount to the first sheet next to the matching number. It is unknown on which sheet which item numbers will be present and the code needs to go through all the sheets. The tables are unsorted and can not be sorted. Can anyone help me with this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I Append excel data to a Access database table in a excel macro? | Excel Programming | |||
Append workbook into a "Master" workbook | Excel Discussion (Misc queries) | |||
append data to other workbook | Excel Programming | |||
Append Data to Table after Web Query | Excel Programming | |||
Append Data To Access Table | Excel Programming |