What if I want to calculate data from 2 sheets of workbook A (example)
I put the formulae in master workbook.
But, the sheets from the workbook is pasted from somewhere else. How can I keep the formulae in master workbook because when I pasted the data , it displayed #REF.
Try this trick. Create two empty tabs next to each other in the workbook: Start and Finish. Create a tab between them. This is the tab that will contain your data.
On a tab not between Start and Finish, enter in your formulas as 3-D formulas (https://bettersolutions.com/excel/fo...imensional.htm) encompassing Start to Finish. Now sheets can be added or deleted between Start and Finish and the formulas should not fail.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks