gr8trthanu
Board Regular
- Joined
- Nov 14, 2008
- Messages
- 103
I have a main summary sheet entitled "freight summary" with thousands of line items
I have 30 other sheets entitled "a1", "B1", etc.
In the main summary sheet in column "L", I have various data (IE:A1,B1)that is the same name as the 30 sheets.
This is the kicker and if anyone has any idea how this can be done, it would be greatly appreciated.
When I select a command button, I need to have the system look at each row in column "L", copy the entire row into the spreadsheet that is
entitled the same as the data in column "L"
So if a row has "A1" in column "L" then that entire row should be copied from the main sheet, hilited green to signify it has been copied then moved to the next available row in the Sheet entitled "A1"
The data in the 30 sheets would need to start on row 5 as I already have some work previously placed in this section
Long winded, I'm sorry!! Just trying to give as much detail as I can
being trying all day!!
Thanks
I have 30 other sheets entitled "a1", "B1", etc.
In the main summary sheet in column "L", I have various data (IE:A1,B1)that is the same name as the 30 sheets.
This is the kicker and if anyone has any idea how this can be done, it would be greatly appreciated.
When I select a command button, I need to have the system look at each row in column "L", copy the entire row into the spreadsheet that is
entitled the same as the data in column "L"
So if a row has "A1" in column "L" then that entire row should be copied from the main sheet, hilited green to signify it has been copied then moved to the next available row in the Sheet entitled "A1"
The data in the 30 sheets would need to start on row 5 as I already have some work previously placed in this section
Long winded, I'm sorry!! Just trying to give as much detail as I can
being trying all day!!
Thanks