May 31 2021 03:27 PM
Hi
I’m looking for help to combine 2 files with approx 70-100 worksheets in each workbook but each worksheet must be combined with a specific match.
For example
File A has worksheets A to Z and continues
File B has worksheets 1 to 100
I need the data from worksheet A to be matched with worksheet 1, B=2, C=3 and so on.
They are 2 different types of data and formats and I want the data from worksheets 1-100 to sit below the data already on sheets A to Z.
I’m using Excel 2016 on Windows PC with no option to change either format.
Any help greatly appreciated