Create Separate Workbook and Move any previous versions

[cmore]

Hi,

I haven't taken a whack at this yet, as I don't have a tremendous idea of how to get started; but ultimately the following is what I'm trying to do, just wondering about any thoughts on how to approach this.

1. WorkbookZZZ.xlsx contains sheetX, I want to search if there's a preexisting sub workbook WorkbookZZZ.Sheetx.xlsx

2. If pre-existing then move to a Drafts folder (if there's one, if not then create and move)

3. Once moved or if no preexisting; Create WorkbookZZZ.Sheetx.Date.xlsx from Sheetx

I am still learning all the wonders of VBA, and I'm sure this is simple for a lot of folks, I just don't want to go the route of many of my tasks so far which take have take a lot more time than they should have from not understanding some of the syntax fully and limits fully. If you have thoughts on any major encumbrances on doing this swiftly please let me know. THANK YOU.

[millz]

Since you yourself have no exact idea how to start, this is also my assumption of how you want it. Should get you starting somewhere.

Please Login or Register  to view this content.

Edit: Currently it's only working if you use current workbook, and to check sheet name within current workbook. I don't know how you want it to work otherwise if not looking at current workbook, so I did not code that part.

[cmore]

Thanks Millz, I'm going to try this today and see what I can do.