Hi,
I would love some help with a spreadsheet I am trying to cleanup.
I would like to have a button in sheet1, that loops through all sheets in the workbook. (Sheets are added and deleted, so number of total sheets is dynamic)
As the macro loops through each sheet, if the letter "T" appears in cell AA1, then create a pdf copy of that sheet only, in current folder where workbook is saved, using cell A6 as the name.
If cell AA1 is empty do nothing and look for the next sheet.
Any help in achieving the above would be greatly appreciated.
Thank you
I would love some help with a spreadsheet I am trying to cleanup.
I would like to have a button in sheet1, that loops through all sheets in the workbook. (Sheets are added and deleted, so number of total sheets is dynamic)
As the macro loops through each sheet, if the letter "T" appears in cell AA1, then create a pdf copy of that sheet only, in current folder where workbook is saved, using cell A6 as the name.
If cell AA1 is empty do nothing and look for the next sheet.
Any help in achieving the above would be greatly appreciated.
Thank you