Excel Formulae related

0

Hi All. I have a dount related to excel. I have 2 spreadsheets. One spreadsheet has master data which has 28 columns. other spreadsheet is having formulae which gives me results based on the formulae mentioned in 2nd spreadsheet. Now , dure to some changes in my organistaion, master file contains 36 columns and i cannot get the same results when i copy master spreadsheet in formulae spreadsheet as columns have changed. Please suggest of there's a way i can set any function for that or do i need to write a fresh formulae for each and every column in the new spreadsheet. I hope you understood my doubt.

Answer
Discuss

Answers

0

It would be best to upload your sample data of both files AND how the results are supposed to look.

Discuss
0

It's a question of how you insert the extra columns. If you take the old 28-column sheet, with all formulas working, and insert one new column in between the 28 all the formulas will adapt automatically. So, if you insert all the 8 new columns one by one your formulas should continue to work. You can then paste data into the new columns in a final step.

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login