Combine or merge multiple worksheets into one worksheet
I have a workbook with 10 worksheets. Each worksheet has identical field headings but rows have different data. Each worksheet represents different areas of the country. Originally each worksheet is in its own workbook downloaded as cvs file. I add each worksheet to single workbook then copy and paste each worksheet to a single worksheet, saving as xlsx file. Because fields are the same it’s a simple copy and paste but I have to do this at least 20 times a week. I am hoping there is a better way to do this but have not been able to find one. Is there a simpler way to combine worksheets?
|