Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import entire row of data to other worksheet based on one lookup v
I have a large set of data in one worksheet and I want to extract out specific rows into another tab based on an identified value for each row. The master worksheet is all customer orders from all over the USA. The rest of the tabs are by state. For the Michigan Tab i'd like to use a lookup statement that would copy the entire row of data for any orders from the master onto the Michigan tab which have "MI" in the state column. Thanks, Stephanie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Specify a row based on data from a cell to delete entire row..... | Excel Discussion (Misc queries) | |||
Move entire row to another worksheet based on drop list selection | Excel Worksheet Functions | |||
Conditional Formating based on data in an entire row | Setting up and Configuration of Excel | |||
import worksheet based on a selection | Excel Discussion (Misc queries) | |||
lookup single value in entire worksheet | Excel Worksheet Functions |