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
.
|