LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 29th 05, 06:43 PM
Posts: n/a
Default 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

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to copy values in various rows automatically Me Excel Discussion (Misc queries) 5 March 7th 05 05:09 PM
Lookup then Match and insert value from next column Tenacity Excel Worksheet Functions 3 March 4th 05 02:49 AM
Activate a macro to insert a row and copy the formuals from the rows above to the blank row oil_driller Excel Discussion (Misc queries) 1 February 11th 05 03:30 PM
copy / paste selective rows Kenny Kendrena via Excel Discussion (Misc queries) 5 February 7th 05 12:55 PM
Count rows based on multiple criteria Murph Excel Worksheet Functions 1 October 28th 04 07:13 AM

All times are GMT +1. The time now is 05:05 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017