I want to create a macro that has "save as" in it and automatically fills in the new file name by looking at the contents of a specific cell in the file.
Is this possible?