Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copy Rows if Lookup Criteria Match
I am trying to create sometype of template to pull data associated with a
specific office. I have a drop down list create on WorksheetB. I have another WorksheetA that contains a list of equipment (Office, Equipment, Lease End Date, Cost, etc..). I would like to be able to select the Office from the drop down list on WorksheetB and pull all of the rows that are associated with the Office in WorksheetA back over to Worksheet B. I know that I can do this using Access Queries, but is there a way to do this in Excel? If so, what are your recommendations? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to copy values in various rows automatically | Excel Discussion (Misc queries) | |||
Lookup then Match and insert value from next column | Excel Worksheet Functions | |||
Activate a macro to insert a row and copy the formuals from the rows above to the blank row | Excel Discussion (Misc queries) | |||
copy / paste selective rows | Excel Discussion (Misc queries) | |||
Count rows based on multiple criteria | Excel Worksheet Functions |