Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUP macro/VBA Code
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUP macro/VBA Code
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Slow code when used as VBA code instead of macro (copying visible columns) | Excel Programming | |||
Can I use code/macro to change code/macro in an existing file? | Excel Programming | |||
VLookup in Code | Excel Programming | |||
do anybody have a sample code for executing excel macro from vb code?<eom | Excel Programming | |||
what is the VBA code for VLOOKUP? | Excel Programming |