macro to copy and paste data

I need to copy cells in A and paste it into sheet "Upload" in col A from the last used row down. However, I only need to copy the cells that begin with a 6 digit number. I also need to take E and copy to C on upload sheet.
For example: if A2 = "total revenue" then do nothing, if A3 = "163001.419"
Then copy It to A in upload and copy E to C in upload.
1 more thing...I need B in upload to =the sheet name that A and C came from plus the following text "Undistributed Stores Exp".
Is this possible? Would be a huge time saver.
thank you.

I can post a sample workbook if need be.

That's a wonderful site...thank you for the link.
It's unfortunate I come accross that way. It's not my intention. I feel bad. My questions are normally apart of a much bigger picture.

Is there a way to get all the results for this, but to exclude any that contain a "-"

Please Login or Register  to view this content.

With the help of Ron de Bruins site, VBA Noob, and the macro recorder, I completed this macro. It works perfect. It's long because it repeats for each sheet. I couldn't figure out how to set WS1 to the activesheet and have the macro cycle through my sheets activating them so as to only have on code that runs for everysheet. But it works.

Please Login or Register  to view this content.