Hi
I have 5 excel files with the same header shared with 5 different users. I want the 6th excel file named consolidated to be automatically updated as and when any user enter data in the relevant field starting from row 2 as row 1 is the header. I am using excel 2010
Regards
Bookmarks