Gary Croxford
asked on
Excel VBA Copy Worksheet Data and Cond. Formatting to Another Workbook/Worksheet
Thank you for looking at my question,
I started in on this and very quickly realised I was in over my head,
I have data in a worksheet, the Project is in Range("A2") and the Item is in Range("B2")
In the On-Click event of a userform button I need to :
1. Check Directory "Projects" to see if there is a workbook named with the value in Range("A2") - if it isn't there create it.
2. Create/Overwrite a worksheet in the target workbook named after the value in Range("B2") with the values and conditional formatting from the source worksheet.
Any help you can offer will be greatly appreciated.
I started in on this and very quickly realised I was in over my head,
I have data in a worksheet, the Project is in Range("A2") and the Item is in Range("B2")
In the On-Click event of a userform button I need to :
1. Check Directory "Projects" to see if there is a workbook named with the value in Range("A2") - if it isn't there create it.
2. Create/Overwrite a worksheet in the target workbook named after the value in Range("B2") with the values and conditional formatting from the source worksheet.
Any help you can offer will be greatly appreciated.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're welcome and I'm glad I was able to help.
In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2015, Experts-Exchange Top Expert Visual Basic Classic 2012 to 2014
In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2015, Experts-Exchange Top Expert Visual Basic Classic 2012 to 2014
ASKER
works fine - thank you for your help