Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
When date changes I lose my data
I have a simple spreadsheet that I want to use daily. Employee enters
numbers daily to make different batches of product. This page does the calulations for the differents percentages of materials used. I want those numbers to transfer to a second sheet, third sheet, and so on to keep a daily record through the year. My problem is I have used the "today function" to update the day the data is entered by itself. When the day changes the days entries are deleted and we move to the next day. I am linking the sheets together with the following: =if(Sheet2!$A9=Sheet1!$f$6,Sheet1!$F$10,0) . How can I keep my data as the date changes? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy/paste want to retain cell coloration but lose the conditional formatting source data | Excel Discussion (Misc queries) | |||
Why do I lose data in a shared workbook? | Excel Discussion (Misc queries) | |||
How not to lose data when working on the same shared document? | Excel Discussion (Misc queries) | |||
how do i clear data in excel and not lose the formula | Excel Worksheet Functions | |||
cells lose relativity to other WorkSheets after data sort? | Excel Worksheet Functions |