Hi. I have a workbook with many worksheets as follows:
Summary Calculations aapl goog msft....etc
The Calculations sheet does all the calculations but only on one stock at a time.
So I am hoping for a macro that does the following:
1. Calculations Sheet: Clears all data in columns A through E
2. 1st sheet to right of Calculations sheet: Copies all data in columns A through E and paste into Calculations Sheet (A through E).
3. Summary Sheet: Store results of calculations sheet (H1 through Q1) in (B2 through J2) of summary sheet.
4. Summary Sheet: Store Sheet name into first cell of row on summary sheet. (B1 for first run)
5. Loop through remaining sheets storing the calculations each time into the next open row on the summary sheet.
Thank you for any help you can give me.
Bookmarks