Related:
- Excell macros
- Excel macro auto increment number - How-To - Excel
- Excel macro active sheet ✓ - Forum - Excel
- Excel macro create new workbook and copy data ✓ - Forum - Excel
- Excel macro to merge cells based on condition ✓ - Forum - Excel
- Excel macro compare two sheets and highlight differences ✓ - Forum - Excel
2 replies
provock
- Posts
- 31
- Registration date
- Monday December 29, 2008
- Status
- Member
- Last seen
- June 18, 2009
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
He told you everything you wanted to know, i can't find a better explanation... gluck
