Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Auto update of cell information
Hi, I have a question. I am creating a spreadsheet (A) where all the numbers
inside will be updated weekly. These numbers will come from different other spreadsheets which would also be updated weekly. But the new data will be updated not in the same cell but in the subsequent cell, week after week. How can spreadsheet (A) read different/subsequent cell week after week? Is there a function I can use? Many thanks HM |
#2
|
|||
|
|||
Hi HM,
There is insufficient information as to your arrangement for someone to reliably answer your question. Do you know how to find the cells that are to be referenced, if you can then you are one step ahead of us.- --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "HM" wrote in message ... Hi, I have a question. I am creating a spreadsheet (A) where all the numbers inside will be updated weekly. These numbers will come from different other spreadsheets which would also be updated weekly. But the new data will be updated not in the same cell but in the subsequent cell, week after week. How can spreadsheet (A) read different/subsequent cell week after week? Is there a function I can use? Many thanks HM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
store some of the information from one cell into another | Excel Discussion (Misc queries) | |||
Auto update entire columns / rows??? | Excel Worksheet Functions | |||
Cell update??? | Excel Discussion (Misc queries) | |||
Timestamp cell to left after update | Excel Discussion (Misc queries) | |||
auto update an open excel sheet over network, with mutiple users | Excel Worksheet Functions |