Hi all experts,
I need a help in consolidating line item data from multiple sheets into a Summary Worksheet within a single workbook.
The data needs to be copied from name specific sheets. e.g. Monday, Tuesday and so on. Because other than summary and data sheets, it also has someother sheets which not to be touched.
Copy range is unique across all data sheets.But the range to paste data has to be defined and not the same as the source range. That means if Data copy range is A2:Z51(e.g.50Line items) and the paste range in summary worksheet might be E2:AD51 from 1st data sheet and same ways data from the next worksheet needs to be pasted based on finding the last used row in column E and starts paste in next line.
Thanks
I need a help in consolidating line item data from multiple sheets into a Summary Worksheet within a single workbook.
The data needs to be copied from name specific sheets. e.g. Monday, Tuesday and so on. Because other than summary and data sheets, it also has someother sheets which not to be touched.
Copy range is unique across all data sheets.But the range to paste data has to be defined and not the same as the source range. That means if Data copy range is A2:Z51(e.g.50Line items) and the paste range in summary worksheet might be E2:AD51 from 1st data sheet and same ways data from the next worksheet needs to be pasted based on finding the last used row in column E and starts paste in next line.
Thanks