Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking data that won't change when original formula changes
I have 2 worksheets.
On the first worksheet, there is 2 tabs. The first tab has data that changes daily. The 2nd tab links to the daily data and has every day of the year. So let say for today, on tab 2, July 30th will populate, which is great, my problem is, on July 31, July 31 will populate and July 30th will go blank again. Is there a way I can format the linked cell on tab 2 to hold that data from July 30th? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking data between sheets to change color of cell? | Excel Discussion (Misc queries) | |||
A copy of a chart doesn't change when the original has new range | Charts and Charting in Excel | |||
Switch to change data fields to 0's, then back to original data? | Excel Discussion (Misc queries) | |||
Linking chart data labels to cells whose contents change | Charts and Charting in Excel | |||
making copied cells change with change in original cell | Excel Worksheet Functions |