|
|
#1
08-21-2024, 02:29 AM
|
||||
|
||||
How to change the row references in a formula when copied
Hi. I work with a template with a start and end data in separate columns. The end data in the first week is the start data of the second week. Is there a way that when the previous template of the previous week is copied, the row references of the formula of start column are automatically adjusted when copied in the next week?
I have attached a sample for clarity. Thank you. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Copied Sheet adds to formula? | ShankedS | Excel | 4 | 10-28-2017 05:52 AM |
| Excel Office 365 Mac - Colour Change after copied to Workbook | Kenlyn | Excel | 0 | 03-30-2017 04:15 AM |
| Cell Ref does not automatically change when formula is copied because of data orientation | Kristinmc | Excel | 4 | 08-01-2016 10:57 AM |
 formula lost when copied between files
|
sandsoppa | Excel | 2 | 02-14-2012 10:38 AM |
| Formula not getting copied to entire column | theacegary | Excel | 1 | 11-29-2010 02:18 PM |
Windows 11 
Office 2021
Threaded Mode