| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
please help save me some time!
Ok, I can't seem to figure this out. I have a large spreadsheet with 10
tabs. Tab 1 is for the entire company and tabs 2-10 are for each branch. I have data from A to AD. On tabs 2 to 10 I have vlookup formulas that refer back to tab 1 {=vlookup(A1,'totalcompany'!$1:!$6854,14,FALSE). My formulas go as far as 26. My problem is that if I want to add a column on tab 1 in column 4 (D) I then have to go to each column from D on for every other tab and redo my formulas. Without rebuilding my spreadsheet is there a way around this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| entering numbers to display a time format | Excel Discussion (Misc queries) | |||
| Excel 2002 crashing during "Save As" action. | Excel Discussion (Misc queries) | |||
| Save & Save As features in file menu of Excel | Excel Discussion (Misc queries) | |||
| Missing "Save" and "Save As" functions | Excel Discussion (Misc queries) | |||
| time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions | |||
Threaded Mode
