you'er correct, VLOOKUP and similar funcs only return values.
you'd need code to copy/pastespecial formats. If you're in learning mode,
switcj on the macro recorder when you do this to start to get familiar with
the code.




"Dwingfield" wrote:

I'm fairly new to this, so please bear with me...

I have a production planning spreadsheet that is updated every week from a
database to a new sheet. This sheet is 'Sheet1', last weeks update becomes
'Sheet2'.

Every day people annotate and colour cells for various orders, depending on
their place within the planning scheme.

It's really only the formats that I need to copy across, I could use the
VLOOKUP function for the values - So I suppose you could say I'm looking for
a VLOOKUP macro which keeps the original formatting (cell colour etc.)
Any help much appreciated...

--
Getting There...slowly