sounds crazy but.
Can an expert help me out with vba code that will look into the sheets in my workbook and find GLOBAL RATES in cell A1
when it finds that I need to copy the sheet and copy it to a new sheet in a different workbook.
I am using the below code to do copy sheets to different workbooks
Sheets("Sheet Name").Copy After:=Workbooks("Weekly Metrics Template.xlsx").Sheets("Sheet Name")