Excel macro for consolidating workbooks
Now I have tried simply clicking in my master worksheet and putting = then clicking on the cell in the salespersons weekly summary cell, creating a link. My problem is when I click data/edit links.udate values some of the salespeoples workbooks wont update without opening the file.This in turn throws a 1004 error with a macro I write to update the data from the salespoeples sheet to my master sheet. I am happy to start from scratch with my master sheet to make this work.A consequence of organizing your data into different workbooks and worksheets is that you need ways to manage, combine, and summarize data from more than one Excel document.You can always copy data from one worksheet to another, but if the original value were to change, that change would not be reflected in the cell range to which you copied the data.You can also remove any worksheets you and your colleagues won’t need by right-clicking the tab of an unneeded worksheet and, on the shortcut menu that appears, clicking Delete.
From the list of available templates, you can click the template you want to use as the model for your workbook.After you decide on the type of data you want to store in a workbook and what that workbook should look like, you probably want to be able to create similar workbooks without adding all of the formatting and formulas again.For example, you might have established a design for your monthly sales-tracking workbook.One worksheet in each workbook has a colum with total sales points for the week.What I am trying to do is have my Master workbook pull the weekly points totals for each person so throughout the week I can see how my salespeople are tracking.