Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel
Previous Topic Next Topic

Excell Macro Help Required

[Solved/Closed]
Report
-
Posts
233
Registration date
Tuesday November 18, 2008
Status
Member
Last seen
August 1, 2010
 -
Hello,

I have 3 Excell Workbooks, i need to create a master sheet, but when ever i update the master sheet the data updated shouls reflect in all the workbooks.

Please help

2 replies

Answer 1 / 2
Posts
31
Registration date
Monday December 29, 2008
Status
Member
Last seen
June 18, 2009
 3
you can try to create a Master sheet using a common column that is found in all the 3 spreadsheets
(just like setting a primary key under access)

To sort or modify items you can use thePivot Table(s) option ,modifications made in the any of the spreadsheets will be only reflected in master sheet (once you refresh the page).
Answer 2 / 2
Posts
233
Registration date
Tuesday November 18, 2008
Status
Member
Last seen
August 1, 2010
 31
He told you everything you wanted to know, i can't find a better explanation... gluck
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!