|
|
#2
08-21-2024, 04:06 AM
|
|||
|
|||
P.e. into cell C26 enter the formula
=OFFSET($B26,-10,4) and copy down until C31. When the number of rows between top rows of all weekly tables remains same, the formula will work (of-course topmost table must be set up manually). 
|
|
|
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 8 
Office 2016
Threaded Mode