Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
changing thwe width of data labels? | Charts and Charting in Excel | |||
Linking multiple data into one worksheet. | Excel Worksheet Functions | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Changing entire column data | Excel Discussion (Misc queries) | |||
how do you prevent data from changing values when sorting linked . | Excel Discussion (Misc queries) |