| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
formula with moving range
I have a workbook that updates daily. When it updates the new updated value goes in the top row of the column lets say A3 and moves the rest of the values in the column down one row. I want to link these values to another workbook named Games2. What formula can I use to copy these values? example The first day it copies A3:A212 the next day A3:A213. Can anyone help? -- sctroy ------------------------------------------------------------------------ sctroy's Profile: http://www.excelforum.com/member.php...o&userid=25928 View this thread: http://www.excelforum.com/showthread...hreadid=484163 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to reference external refereces from a list | Excel Worksheet Functions | |||
| Conditional Format - Formula to Colour Every 3rd Cell in Offset Range | Excel Discussion (Misc queries) | |||
| Formula to find first, second, third etc. value (range) | Excel Discussion (Misc queries) | |||
| Using the text from a cell as a range name in a formula | Excel Discussion (Misc queries) | |||
| how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
Threaded Mode
