ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Linking changing data (https://www.excelbanter.com/excel-discussion-misc-queries/40019-linking-changing-data.html)

Beverley Gill

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