Insert Copied sheet

[sikke]

Hi there,
I'm a newbe in excel programming and hope to get some help in this forum.
I'm trying to make a workbook, where each sheet are testequipment records.
Did find some codes but they need som minor rewriting.

I would like the "insert serial" macro to copy the "new sheet" instead of inserting a empty sheet after the "master"
(and still rename the copied sheet with value from inputbox")

Regarding the "search serial" macro, could this return a message if serial not found. like serial not found, would you insert a new one. (yes-No)

[sikke]

Sorry, forgot to upload the workbook....here it is

[stnkynts]

For your first question replace the similar code (module 9) with this new code:

Please Login or Register  to view this content.

For your second question replace the similar code (module 2) with:

Please Login or Register  to view this content.

[sikke]

Hi stnkynts,
First of all ... THANKS... the first one (module 9) .... excellent, works nice. Question, could i hide the "new sheet" and have the new copied one, visible?

In module 2, the message box pops up even if the serialnumber i'm searching for is already inserted, If i answer "No" the message box disappears and cursor then jumps to the correct sheet, if the sheet is named with letters then nothing happends !!!

regards
sikke

[stnkynts]

Sorry about the confusion. Try these in module 9 and 2 respectively:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[sikke]

Hi again,
Regarding module 2, When i'm searching for a serial no. where the name starts with a letter, nothing happends. Any clue

regards
Sikke