Hi All,
ok, here goes.. I am trying to create an excel file with multiple sheets within named Main / Section1 / Section2. Main Sheet will be the spreadsheet compiling all data from spreadsheets Section1 and Section2. Is there any way to do it so that whenever new data is entered into Section1 and Section2, new rows with the new data will be automatically inserted into Main Spreadsheet without overwriting the existing data? Would really really appreciate if someone could help me out on this.
Many thanks.
Bookmarks