Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
vdoubleu
 
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
recommendations?

Reply
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 06:09 PM
Lookup then Match and insert value from next column Tenacity Excel Worksheet Functions 3 March 4th 05 03: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 04:30 PM
copy / paste selective rows Kenny Kendrena via OfficeKB.com Excel Discussion (Misc queries) 5 February 7th 05 01: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 07:27 PM.

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

About Us

"It's about Microsoft Excel"