| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Macro to update a column in a work based on another work sheet
My excel knowledge is enough to be dangerous.
I have two work sheets. Both have multiple columns and two of the columns are then same on both work sheets. Currently, I do all the updating by hand for these columns: case # and status. I really need a macro or a way to update the two columns on work sheet 2 based on what is in work sheet 1. It woudl compare a case #s and then update the status column on work sheet 2 to match the status in work sheet 1. I see alot with vlookup, never used it. Regards, Jeb |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| flash object dont work in my excel work sheet | Excel Discussion (Misc queries) | |||
| extracting totals from 1 work sheet to another work work sheet | Excel Discussion (Misc queries) | |||
| Allow custom update button to work while sheet is protected | Excel Discussion (Misc queries) | |||
| Populating work sheet combox with another work sheet values | Excel Discussion (Misc queries) | |||
| Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel | |||
Threaded Mode
