View Single Post
  #1   Report Post  
Beverley Gill
 
Posts: n/a
Default 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.