Hi everyone,
So far, I have a macro that creates a new file and renames according to a cell. However, I'd like to be able to copy the file I'm running the macro on, save as according to a cell (which it does already), add something after the cell name "e.g. 'Cell name Q315' (if I could have a pop up box to ask what quarter/year I'd like it to say, that would be even better!). This is what I have so far:
I couldn't figure out how to make it copy instead of creating a blank workbook... any help is appreciated!
Bookmarks