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.