Can someone help with a macro that will pull data from multiple similarly-formatted tabs and combine into one tab in a specified format? Note, the macro would be used within the file itself (on a new worksheet), but would be used for mulitple similar files. Each tab in each file would have a different 3-number name. The goal is to create a single list containing all of the rows containing data from all of the tabs within the file.
Each of the source tabs/worksheets in the first file are titled "401", "410", "420", "430" "440", and "441". The macro should pull cell $C$5 into Column A (repeated for each relevant row from the worksheet); pull Cells D8:J8 into the destination sheet Column B thru G. This should be repeated for each row on the source sheet that has an account number (9-digit number) in column D. Note within possible rows on the source sheet, many of the rows of data (E-J) would only contain zeros. these rows would not need to be copied/returned to the destination sheet. That would be repeated for each tab within the file; and pasted below the pasted amounts copied from the tab before it. This would give me a single list containing all of the rows containing data from all of the tabs within the file.
Can anyone help?
Bookmarks