Macro Copy/Save active worksheet into a pre-existing workbook & rename sheet to cell data
I'm needing help with a macro. I'm looking to copy/save a worksheet called "Reservations" into an existing workbook called "Reservation". Before it does this I will need the sheet to rename itself to text form cell B5. But I will need to be able to do this over and over again, always putting the copy/save sheet into the "Reservation" workbook with a new name of course from the text in cell B5. Hope I've made since of this. Any help would be greatly appreciated. I've been stumped on this for days.
Re: Macro Copy/Save active worksheet into a pre-existing workbook & rename sheet to cell d
Both workbooks need to be opened
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1