copy existing code for another sheet

Hi,
Really need your advice.

1stly i never do vb macro before.
i have 1 excel with currently have 3 sheet coded with vb. This macro will call the excel source to display the filename accordingly in grouping.

Let say.
Sheet1 - will call the text having *OM4* and display in OM4 sheet
Sheet2 - will call the text having *OM5* and display in OM5 sheet
Sheet3 - will call the text having *OM6* and display in OM5 sheet

Now, company need me to add one more sheet called OM3 which will have in excel source soon.

Question :
Can i copy VB code from current OM4/OM5 sheet to the new sheet (OM3) and just rename the OM4 to OM3 in that code? Do i need to change anything else such as declaration and else? I tried to copy code from OM4 and paste into OM3 sheet using VB editor with just renamed OM4 to OM3.. but failed!. the ouput in OM3 is same as OM4 which i copied code from.

Please advice. Thanks in advance.


*Uploaded excel sheet in the question.
Not working sheet - SHEET1 and SUMMARY
Need to change SHEET1 to OM3 which will newly added.

Hi,

Difficult to say without seeing the workbook in question. But for starters I suggest you right click on one of the current sheet tab names, choose Move or Copy and then tick the 'Copy' box and then OK.

Change the sheet name to OM3 and check the VBA code for any references to the OM number of the sheet you copied and change to OM3.

Then try running your macros.

In that case upload the workbook in question as requested and add some notes explaining precisely what you expect to happen with reference to specific cells/sheets.

Just add another case to the Select Case statement in the Get Information procedure. e.g

Case "EFF"
SheetType = 'new sheet name
OMRType = "OM3" ' or whatever