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
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