Need to Import Data from Multiple Sheets into a Master Sheet
Need Help in writing VB that will extract data from multiple tabs in to one master tab.
Here is my Dilemma. I have a workbook with multiple tabs; this could range from 1 to 20. They are all the same structure and view.
I need to pull from each tab, Column A, B, C, D, H, and AC. Once the data is pulled from the tab I need to it tag it with the TAB name on each data it retrieved. For example if the Tab name is Movie A. I need it to tab MoveA on a separate column next to each of the rows of data to tab MoveA on a separate column next to each of the rows of data it retrieved. .
The End result should something like this. However, once the first data is imported i need the data to be import next rate under it. A loop till all the tabs have been imported. PLEASE HELP
Need to Import Data from Multiple Sheets into a Master Sheet
Reply With Quote