So this I believe is difficult. Difficult just to explain.
I'm looking to take a column and make each cell equal to values from throughout the workbook. (C1=worksheet.B1) etc...
Then this file will be saved, next week, the sheet is reopened and I want to copy the formulas to a new column... Column D, and it grabs new values of (D1=worksheet.B1)....
Each week the column moves and new values are saved in the corresponding column.
Add a column, grab values, save values permanently, then run it again, and it adds a column, gets the new values, saves them permanently.
Currently, I have two separate spreadsheets. I update the values, save as a unique sheet, then open the sheet which contains the below... I then copy and paste to the right, and edit the file name slightly to point to the new permanently saved file previously updated and saved.
Thanks in advance. I hope this can be done.
Initial Values
<tbody>
</tbody>
First Time Macro Runs
<tbody>
</tbody>
Second Time Macro Runs
<tbody>
</tbody>
****** id="cke_pastebin" style="position: absolute; top: 576px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
<tbody>
</tbody></body>
I'm looking to take a column and make each cell equal to values from throughout the workbook. (C1=worksheet.B1) etc...
Then this file will be saved, next week, the sheet is reopened and I want to copy the formulas to a new column... Column D, and it grabs new values of (D1=worksheet.B1)....
Each week the column moves and new values are saved in the corresponding column.
Add a column, grab values, save values permanently, then run it again, and it adds a column, gets the new values, saves them permanently.
Currently, I have two separate spreadsheets. I update the values, save as a unique sheet, then open the sheet which contains the below... I then copy and paste to the right, and edit the file name slightly to point to the new permanently saved file previously updated and saved.
Thanks in advance. I hope this can be done.
Initial Values
DATE of WEEK ONE | |
Bob | VALUE FROM WORKSHEET AS EQUALS FORMULA (WorksheetName.H4) |
Sue | VALUE FROM WORKSHEET AS EQUALS FORMULA (DifferentWorksheetName.H4) |
George | VALUE FROM WORKSHEET AS EQUALS FORMULA (CompletelyDifferentWorksheetName.H4) |
<tbody>
</tbody>
First Time Macro Runs
DATE OF WEEK ONE | DATE of WEEK Two (=B1+7) | |
Bob | VALUE OF WORKSHEET AS EQUALS FORMULA | NEW VALUE OF WORKSHEET FORMULA |
Sue | VALUE OF WORKSHEET AS EQUALS FORMULA | NEW VALUE OF WORKSHEET FORMULA |
George | VALUE OF WORKSHEET AS EQUALS FORMULA | NEW VALUE OF WORKSHEET FORMULA |
<tbody>
</tbody>
Second Time Macro Runs
DATE OF WEEK ONE | DATE of WEEK Two (=B1+7) | DATE OF WEEK Three (C1+7) | |
Bob | VALUE OF WORKSHEET AS EQUALS FORMULA | NEW VALUE OF WORKSHEET FORMULA | NEWEST VALUE OF WORKSHEET FORMULA |
Sue | VALUE OF WORKSHEET AS EQUALS FORMULA | NEW VALUE OF WORKSHEET FORMULA | NEWEST VALUE OF WORKSHEET FORMULA |
George | VALUE OF WORKSHEET AS EQUALS FORMULA | NEW VALUE OF WORKSHEET FORMULA | NEWEST VALUE OF WORKSHEET FORMULA |
<tbody>
</tbody>
****** id="cke_pastebin" style="position: absolute; top: 576px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
NEWEST VALUE OF WORKSHEET FORMULA |
<tbody>
</tbody>