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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Macro to update a column in a work based on another work sheet
Hi,
I assume your case # in sheet1 is in column A, your status in sheet 1 in column B, then in sheet 2 you have your case # in column c so in column D enter =INDEX($B$1:$B$1000,MATCH(C1,$A$1:$A$1000)) change range to fit your needs "WickerMan" wrote: 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 . |
Reply |
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 |