|
|
#1
04-15-2018, 09:24 AM
|
|||
|
|||
Formula Copy Row 2 Row But Next Column In Formula From Another Tab
I have a formula in a spreadsheet that references a cell from another tab. When I copy that formula to the next row of my spreadsheet, I want the new formula to reference the value from the cell in the next column of the spreadsheet in that other tab, not from the cell in the next row of the spreadsheet in that other tab. Can I do that and how? 
|
| Tags |
| column, formula, row |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| If text in column then formula in other | Grubermen | Excel | 1 | 09-06-2017 06:35 AM |
| Is it possible to put a formula in a table column header to define the name of the column? | JacquesW | Excel | 3 | 05-08-2017 08:00 AM |
| Help With Copy Formula Down Macro | npalmer610 | Excel Programming | 4 | 03-14-2016 01:15 PM |
| 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 |
| Excel copy formula | KMS | Excel | 1 | 08-16-2011 03:02 PM |
Windows 10 
Office 2016
Threaded Mode