Hello Novice999,
Merged cells generally create havoc with VBA coding, however, try the following code and if it doesn't work, you'll need to unmerge the cells or even move the job number to a nearby cell.
The code is a Workbook_SheetChange event and needs to be placed into the workbook module so, to implement the code:-
- Press Alt + F11 which will take you to the VB Editor.
- Over to the left, double click on ThisWorkbook.
- In the big white field, paste the above code.
The code should now work in every sheet once you enter the job number and click away (or press enter).
I haven't tested the code but it includes unmerging and merging the range F5:U5.
I hope that this helps (and that it works!).
Cheerio,
vcoolio.
Bookmarks