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.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Excel Formulae related
0
Answers
0
It would be best to upload your sample data of both files AND how the results are supposed to look.
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.