![]() |
Linking changing data
I have 2 pages in a workbook.
Page 1 is my INPUT page. Page 2 is suppose to collect the data from the Input Page 1 Problem: Page 1 is cleared each time I need to recalculate the cheque (this is as I want it) Page 2, I would like Page 2 to retain the Page 1 data everytime I overwrite the Page 1 calculations. Example: Calculate Jan 15 Pay check (Page 1) - Put results in Cell B3 of Page 2 Calculate Jan 30 Pay Check (Page 1) - Put results in Cell C3 of Page 2 Page 1 would be a template Page 2 should be a summarizing data sheet. |
All times are GMT +1. The time now is 06:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com