Excell Macro Help Required
Solved/Closed
Crackinhunk
-
Mar 24, 2009 at 02:00 AM
sarbel.vilo Posts 233 Registration date Tuesday November 18, 2008 Status Member Last seen August 1, 2010 - Mar 24, 2009 at 03:54 AM
sarbel.vilo Posts 233 Registration date Tuesday November 18, 2008 Status Member Last seen August 1, 2010 - Mar 24, 2009 at 03:54 AM
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
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:
- Excell Macro Help Required
- Spell number in excel without macro - Guide
- Macro excel download - Download - Spreadsheets
- Excel macro to create new sheet based on value in cells - Guide
- Run macro when cell value changes by formula ✓ - Excel Forum
- Excel run macro when opening workbook - Guide
2 responses
provock
Posts
31
Registration date
Monday December 29, 2008
Status
Member
Last seen
June 18, 2009
3
Mar 24, 2009 at 02:34 AM
Mar 24, 2009 at 02:34 AM
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).
(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 November 18, 2008
Status
Member
Last seen
August 1, 2010
31
Mar 24, 2009 at 03:54 AM
Mar 24, 2009 at 03:54 AM
He told you everything you wanted to know, i can't find a better explanation... gluck