How can i synchronise worksheets in 2 different excel file...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a master price list containing different work sheets for different
brands and also I have different files with each brands prices o it. The
individual files are containing the same worksheet of the specefic brand in
the Master price list. So now I want to update only the master price list and
I want to get the different brand fils get updated automaticaly. How can i do
this work.
 
for the cell in your individual file for xlnt red widgets type = and then
click on the corresponding cell in the master price list...if you have the
items listed in exactly the same way on both sheets you can then copy the
formula down...your workbooks are now linked and when you open eaach
individual file you will be asked if you want to update the data....its easy
if you can have the two sheets open side by side
the formula in the cell should look something like this for cell b2 in the
xlnt book on the widgets sheet ='[master prices.xls]xlnt widgets'!$B$2 looks
at cell b2 on the master price book xlnt widgets sheet
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to combine 2 Worksheets 1
General lookup and cut and paste between 2 spreadsheets 1
Linking between 2 worksheets 3
Putting Charts into an organized menu 1
Accessing List Data 1
how do I update a column and create new rows for new column cells 1
Copying related information between worksheets 2
combining data multiple worksheets into one? 5

Back
Top