Hi All,
Being new to the world of macros and VBA, seek guidance here.
There are multiple workbooks (one for each user saved at the same location/folder) with 5 worksheets within the workbook each. Data is entered by users into their respective workbook under various columns. This data needs to be then updated onto a Masterfile in the manner that:
1. Data for each respective worksheet gets copied into the same worksheet on the Masterfile.
2. Data from each of the users' sheets is copied one over other and then sorted chronologically per date of entry.
3. In case of any 'blank' row of information, the macro over-runs this row to reflect only 'filled' rows of information on the Masterfile.
4. Information from users' workbooks be updated only when the file has been saved.
Can we also have a macro-driven 'Refresh' option that helps refresh the data for any reference?
Let me know should there be requirement for a sample worksheet.
Thanks.
Praveen
Bookmarks