New worksheet created when value entered

Hi all

Hoping for some help please, I am a total novice.

I need some code which will do the following please.

I need to create a spreadsheet which logs goods that are coming in and also going back out. On the front worksheet, it will be a brief snapshot of the goods (dates, brief description etc). When a reference number is entered in columnA, I want a new corresponding tab created which is named with the reference number (which someone can then input more details).

I think this is possible, but is it also possible for the new corresponding worksheet to have different column/table info to the first worksheet? The idea being that the corresponding sheets have much more detail in than the snapshot front worksheet. Hope that makes sense! Example of what I want is attached.

Many thanks in advance for any help!

Hi !

The easy way for an easy code is to create an 'empty' template worksheet which will be copied to create a new worksheet
for a new reference from the snapshot column A …

I tried to tag the code but couldn’t work out how to do it.

Still not sure how to action what you’ve said as I’m a novice but thanks anyway.

Can anyone help at all please? thanks.

At least :

Originally Posted by Marc L

So like in my previous post, just expecting a new attachment with this template worksheet …