Vlookup change all sheet references

[ECEUK]

Is there an easy way to change the sheet reference of all of my Vlookup worksheet references without having to go into every cell and paste the new sheet reference.

Sheet1 contains the data

Sheet2 contains edited data of Sheet1
Sheet3 contains edited data of Sheet1 etc etc

Sheet5 contains 50+ Vlookup references to Sheet2

I want to copy/paste Sheet5 and change ALL of the Vlookup references to Sheet3 without haveig to go into all of the cells and maually change them.

[Pete_UK]

You can use Find & replace (CTRL-H) to do this in one operation. On Sheet5 select the cells which have the VLOOKUP formulae, then CTRL-H, and:

Find What: Sheet2!
Replace With: Sheet3!
Click Replace All

Hope this helps.

Pete