copy rows from one sheet to another based on criteria

gr8trthanu said:

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

Click to expand...

gr8trthanu said:

I need to copy the data in each column into seperate sheets based on the data in column "L" for each sheet. I have the sheets made up with headers in them already with summaries above using formulas and code. Therefore when the code copies the data into the other sheets it will start on row 19.

thanks for reponding
greatly appreciated cause I don't have much hair left to pull out

Click to expand...