Hi All,
I'm not sure if anyone can help me here. I have a weekly report and would usually use a VBA to break out the data per regions into separate worksheets. I would then manually match each worksheets name (Eg, Eastern, Southern, Canada, Gulf) to workbooks name in a folder, then manually copy and paste that the appropriate sheet.
I would like a VBA to say if the worksheet on the right, eg Canada matches a workbook named Canada, then copy and paste the sheet data on the right(Source) to workbook on left(Destination).
Is this possible? Thanks in advance for your help.
Imran
I'm not sure if anyone can help me here. I have a weekly report and would usually use a VBA to break out the data per regions into separate worksheets. I would then manually match each worksheets name (Eg, Eastern, Southern, Canada, Gulf) to workbooks name in a folder, then manually copy and paste that the appropriate sheet.
I would like a VBA to say if the worksheet on the right, eg Canada matches a workbook named Canada, then copy and paste the sheet data on the right(Source) to workbook on left(Destination).
Is this possible? Thanks in advance for your help.
Imran