Excell Macro Help Required

Solved/Closed
Crackinhunk - 24 Mar 2009 à 02:00
sarbel.vilo Posts 233 Registration date Tuesday 18 November 2008 Status Member Last seen 1 August 2010 - 24 Mar 2009 à 03:54
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
Related:

2 responses

provock Posts 31 Registration date Monday 29 December 2008 Status Member Last seen 18 June 2009 3
24 Mar 2009 à 02:34
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).
sarbel.vilo Posts 233 Registration date Tuesday 18 November 2008 Status Member Last seen 1 August 2010 31
24 Mar 2009 à 03:54
He told you everything you wanted to know, i can't find a better explanation... gluck