Hello all -

I have my report with many sheets. On one sheet, I have a list of about 30 values in COLUMN A. When I click on one of these values, it populates a cell on another sheet (D3).

I need to be able to click a button, run a macro that 1st chooses a value in column A on the one sheet to populate the cell in the other sheet, then SAVE to a specific location (just say C:\Samples for now). It will continue to run for the values in Column A. However, if the file already exists, it will not need to save it again, it could just skip over it. I would have the name be REPORT(value from column A that was clicked). ex: REPORT12345

I am crossing my fingers that this is someone is able to assist. Thanks so much.