Hello everyone and thank your for exchanging ideas between all!
I have this Workbook that has 7 Sheets. Sheet 2 is named Geral, Sheet 3 is named Service 1, Sheet 4 is named Service 2, Sheet 5 is named Service 3, Sheet 6 is named Service 4.
On the Sheet2 I have a button linked to Macro to save to PDF the sheets I select:
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:\Desktop\Whatever " & ActiveSheet.Range("ad2").Value & " " & ActiveSheet.Range("ad6").Value & ".pdf"
The thing is. I have 90 stores and I have to manually select one by one from a list. Then it updates the information about the services that the store has. All the information per sheet is updated after I pick up the store. I only have to save as PDF the sheets that have the service (that has the option Yes) per store. Doing this 90 times is boring.
Is there a way that i can do simultaneously:
1. The name of the store based on the list changes automatically until its end
2. Only the sheets whose name have the info that the service exist must be selected (per store)
3. Save those selected sheets and start over to 1
THank you very much in advance.
MM
I have this Workbook that has 7 Sheets. Sheet 2 is named Geral, Sheet 3 is named Service 1, Sheet 4 is named Service 2, Sheet 5 is named Service 3, Sheet 6 is named Service 4.
On the Sheet2 I have a button linked to Macro to save to PDF the sheets I select:
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:\Desktop\Whatever " & ActiveSheet.Range("ad2").Value & " " & ActiveSheet.Range("ad6").Value & ".pdf"
The thing is. I have 90 stores and I have to manually select one by one from a list. Then it updates the information about the services that the store has. All the information per sheet is updated after I pick up the store. I only have to save as PDF the sheets that have the service (that has the option Yes) per store. Doing this 90 times is boring.
Is there a way that i can do simultaneously:
1. The name of the store based on the list changes automatically until its end
2. Only the sheets whose name have the info that the service exist must be selected (per store)
3. Save those selected sheets and start over to 1
THank you very much in advance.
MM