M
mandys
I realize this is pretty elementary, but I'm just not sure where to begin, if
I need a macro, or can use a formula. I have a worksheet full of data and
the first column has a brand number, the second, third and forth columns are
different descriptions of the number (color, size, weight). What I'd like to
do is create another worksheet where when I type in any brand number from the
first column of that data exactly, it recognizes it and updates the rest of
the cells with the rest of the data in column 2,3, and 4 in that same row to
the new worksheet.
Any ideas on the best way to go about this? Does this even make sense?
Thanks in advance!
Mand
I need a macro, or can use a formula. I have a worksheet full of data and
the first column has a brand number, the second, third and forth columns are
different descriptions of the number (color, size, weight). What I'd like to
do is create another worksheet where when I type in any brand number from the
first column of that data exactly, it recognizes it and updates the rest of
the cells with the rest of the data in column 2,3, and 4 in that same row to
the new worksheet.
Any ideas on the best way to go about this? Does this even make sense?
Thanks in advance!
Mand
100 on