Update two different spreadsheets from one ma Closed

Question

Hello,
I need to update two completely different spreadsheets from one master spreadsheet in Excel.  How do I accomplish this?  Please help.  Thanx in advance for your assistance!

rizvisa1 · Answer

Man put some meat to your question. Right now one can only answer in as broad-brush by saying that by either using macro or by having the "slave" workbook linked to the master one. I am sure that this is not the answer you are looking for. So a bit more detail of issue would help

Chill Mo · Answer

I need certain fields on different tabs in the "slave" spreadsheets to update the "master" spreadsheet.  I need a way to accomplish this.  All three "slave" spreadsheets are owned by different people; however, we all report to one boss that uses a "master" spreadsheet.  I want these "slave" spreadsheets to update the "master" one.  Thanks!

Chill Mo · Answer

Can someone please include a sample spreadsheet?

rizvisa1 · Answer

I am not sure what sort of updates is expected, but lets say you simply want a value from the a specific cell from the slave workbook to appear on a master workbook, then  one option you can try is that in the master workbook you can have links to individual. In the example below the cell in master workbook is to pick up the value from cell A1, sheet1 of the workbook slave1
 =[slave1.xls]Sheet1!$A$1

rizvisa1 · Answer

Basically what formula will do is what ever is the value on cell A1 in client book, it will make show that value there

so if you have three ppl, you would want to have three cells to show up each figure

on master 
A1   =[slave1.xls]Sheet1!$A$1
B1   =[slave2.xls]Sheet1!$A$1
C1   =[slave3.xls]Sheet1!$A$1

Basically this is an idea. Catch is that the three workbook should be available to the master when master opens. I have a little idea what you are trying to do but does she want every thing off your book into her (all details ) or just totals in which case, you add total on your book and let her book pull value from where the totals are on your book

Chill Mo · Answer

She doesn't need everything on my spreadsheet; however, I want her spreadsheet to contain a total from all three of us.  All three of us are using the same spreadsheet, which contain number of sales and their respective amounts.  Her spreadsheet should contain the total from all three (xls1 - 3, xls2 - 4, xls3 - 3...master should display 10).  Does this make sense?

rizvisa1 · Answer

sure
then what you can do is
have on master 
=[slave1.xls]Sheet1!$A$1 +  [slave2.xls]Sheet1!$A$1 + [slave3.xls]Sheet1!$A$1

hope it helps

Update two different spreadsheets from one ma

7 responses

Similar discussions

Subscribe To Our Newsletter!