[Excel] - Copy Value and Save As Macro [Closed]

Report
-
Hello,

I'm trying to write a macro to copy a single value (ID number) from column C in a table on Sheet1 into cell A2 in Sheet2, and save a copy of Sheet2 as a new workbook titled as the copied value (ID number). It then needs to copy the next ID number down in column C to the worksheet and repeat for the length of the column so I end up with a series of saved files titled as each ID number in column C in the original workbook. Can anyone help me?

Many thanks, Harriet.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!