'To transfer data from one wksht to another where cell value = wksht name
I would like to use a macro to transfer data from worksheets in a workbook to a master page using a macro. On the Master page is a list of worksheet names and would like to pull the data from the worksheet to the corresponding row on the Master sheet(where A2 = wksht name). The data is not in 0ne row, it would be from multiple cells but across the row on the Master sheet. Any help with how to direct the Macro to do this would be greatly appreciated. Thank you in advance :) For example:
Master
Wksht1
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|


