How do I merge data from one sheet in a workbook out into multiple sheets
I am using a workbook with data that changes monthly. I can easily create a spreadsheet that has my new monthly info in a list format on one sheet. My question is, can I somehow disseminate that information into the other 90 sheets.
For example, I would want the data in my first sheet A2 and B2 to go to certain cells in sheet 2. Then the data in A3 and B3 would go to designated cells in sheet 3, and so on for 90 different sheets?
Is this possible?
Thank you so much.
|