Hello,
Can anyone help in cranking out the VBA.
I have a "Master" sheet with 2 columns : "TYPE" and "NAME" and I have a command button (ActiveX Controls) created and named it "CREATE SHEET"
And, I have 2 other sheets namely "TEMPLATE A" & "TEMPLATE B".
What I would like to do is:
EXAMPLE:
TYPE NAME
A LP1
B DP1
So when I click, "CREATE SHEETS" button, I want Sheet LP1 to be created as per TEMPLATE A and Sheet DP1 created as per TEMPLATE B.
If I enter a new TYPE and NAME in after creating sheets, it should only create the NEW data it detects and create only that sheet.
Seems a lil complex. But i appreciate any help please.
Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #1 requires good titles. "Excel VBA" is not a good title. I have updated it for you this time because you are a new member. --6StringJazzer
Bookmarks