Home |
Search |
Today's Posts |
#1
|
|||
|
|||
match cell from one worksheet to data in another
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
Repeat Cell Data | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel |