VBA | Save Worksheet As

[rachel06]

Hi!

I have a workbook that has sheets "Pharmacy Pricing" and "PDF2"

I'm trying to get a macro to work that'll "Save As" the "Pharmacy Pricing" sheet, using the naming convention this formula results in:

='PDF2'!C7&" "&'PDF2'!C8&"-"&'PDF2'!C9&" "&'PDF2'!C21&" Rate Sheet "&" "&TEXT('PDF2'!F12,"m-d-yyyy")

If I could do this as a loop for several worksheets in a folder, even better!

I've been looking up ways to accomplish this, but I'm just getting very confused.

Thanks so much!

Rachel

 

[rachel06]

Thank you! Was just coming to post that I figured everything out with this. Appreciate your quick help with this! It's going to help me a lot!!

 

[Sam_D_Ben]

Thank you! Was just coming to post that I figured everything out with this. Appreciate your quick help with this! It's going to help me a lot!!

No problem!