|
|
#2
02-06-2019, 07:51 AM
|
|||
|
|||
Copy cells with formula, and paste then into column which is 3rd one at right from original one - you must get the reference to column O in source sheets. Then select sells with copied formula, and drag the selection into next column at right from original column. Or simply delete empty columns between. (You must have enough empty columns to right from original column to start with.)
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Need help with dragging a formula and changing a reference column as I drag the formula. | LupeB | Excel | 1 | 10-22-2015 03:02 PM |
| Propagating a formula which references a named cell | Splint | Excel | 4 | 06-15-2015 04:55 AM |
 Globally changing formatting of in-text cross references
|
estube | Word | 1 | 07-08-2014 03:21 AM |
|
Changing text in cross-references
|
Richard B | Word | 3 | 09-11-2013 07:18 AM |
| Formula that references cell with text in different workbook | no1texan | Excel | 3 | 07-17-2012 05:58 AM |
Windows 8 
Office 2016
Threaded Mode