Atomatting Worsheet Creation

[Guest]

I did a Google seach and came up empty so here is a question:

In Row 1, on the Vendor worksheet, I enter new vendor business names and
input some general info in their column. I then create a separte worksheet
for that vendor,the sheet is named for the vendor, and I put in the Text
lables and formulas to mimick the worksheets fror all the other vendors.
Is there a way to have this done automatically when ever a new vendor is
entered into the Vendor worksheet.

Please help.
Thank you
Kevin

 

[Tom Ogilvy]

Based on the vague information provided, the vague answer is yes, it should
be possible. You can write code and trigger it from the worksheet_change
event or perhaps better in this case, from a commandbutton (less automatic,
but easier to control).

See Chip Pearson's page on events http://www.cpearson.com/excel/events.htm
if you are not familiar with them.