Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 30th 05, 04:11 PM
Morgs
 
Posts: n/a
Default How can I retrieve multiple rows that match one criteria, i.e. a d

Hi, can anyone help please? I'm not sure which function I should be using
even!

If I have a list of people, address columns, postcode and a date in one
sheet so how can i return all the people (and all of their address and
postcode too) who are coming on a certain date to a different spreadsheet
(not using autofilter). There could be 10's or 100's that will match the
date criteria and I want all of them, not just one?

I hope that makes sense!

Morgs



  #2   Report Post  
Old August 30th 05, 05:15 PM
Duke Carey
 
Posts: n/a
Default

Somebody else will pop in with a formulaic solution, which I think is the
wrong tool for the task. I'd recommend you use Data-Import External
Data-New Database Query and let your first sheet act as a database. You can
set the date criteria in the query and return ALL the entries that match the
criteria to your spreadsheet. Plus, Excel will remember your query and allow
you to modify your criteria and update the data.



"Morgs" wrote:

Hi, can anyone help please? I'm not sure which function I should be using
even!

If I have a list of people, address columns, postcode and a date in one
sheet so how can i return all the people (and all of their address and
postcode too) who are coming on a certain date to a different spreadsheet
(not using autofilter). There could be 10's or 100's that will match the
date criteria and I want all of them, not just one?

I hope that makes sense!

Morgs


  #3   Report Post  
Old August 31st 05, 07:12 AM
Morgs
 
Posts: n/a
Default

That sounds like a great solution. Thanks Duke - I'll give it a try today
and let you know how I got on. Especially good if I don't end up writing
lots of formulae!

Cheers, Morgs

"Duke Carey" wrote:

Somebody else will pop in with a formulaic solution, which I think is the
wrong tool for the task. I'd recommend you use Data-Import External
Data-New Database Query and let your first sheet act as a database. You can
set the date criteria in the query and return ALL the entries that match the
criteria to your spreadsheet. Plus, Excel will remember your query and allow
you to modify your criteria and update the data.



"Morgs" wrote:

Hi, can anyone help please? I'm not sure which function I should be using
even!

If I have a list of people, address columns, postcode and a date in one
sheet so how can i return all the people (and all of their address and
postcode too) who are coming on a certain date to a different spreadsheet
(not using autofilter). There could be 10's or 100's that will match the
date criteria and I want all of them, not just one?

I hope that makes sense!

Morgs


  #4   Report Post  
Old September 1st 05, 03:19 PM
Morgs
 
Posts: n/a
Default

Worked a treat. Took me some time to sort my queries out but that was good.
Had more problems with the actual input for producing the query but found the
parameters section in excel and managed to setup 3 queries referencing the
same date to pull back the data from 3 different spreadsheets. Worked like a
charm.

Thanks for your help - brilliant.

"Duke Carey" wrote:

Somebody else will pop in with a formulaic solution, which I think is the
wrong tool for the task. I'd recommend you use Data-Import External
Data-New Database Query and let your first sheet act as a database. You can
set the date criteria in the query and return ALL the entries that match the
criteria to your spreadsheet. Plus, Excel will remember your query and allow
you to modify your criteria and update the data.



"Morgs" wrote:

Hi, can anyone help please? I'm not sure which function I should be using
even!

If I have a list of people, address columns, postcode and a date in one
sheet so how can i return all the people (and all of their address and
postcode too) who are coming on a certain date to a different spreadsheet
(not using autofilter). There could be 10's or 100's that will match the
date criteria and I want all of them, not just one?

I hope that makes sense!

Morgs




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
can i wrap rows to form multiple rows per row to fit on 1 sheet? Dave Excel Discussion (Misc queries) 2 October 9th 12 04:53 PM
Select rows of data in a worksheet on one criteria in multiple co MrSkoot99 Excel Worksheet Functions 5 July 11th 05 01:48 PM
Convert multiple columns to rows Lois Lane Excel Worksheet Functions 8 January 10th 05 12:47 AM
Multiple rows of data on a single axis (charting) ramseysgirl Charts and Charting in Excel 8 December 29th 04 06:00 PM
Counting rows based on criteria in multiple cells Margaret Excel Discussion (Misc queries) 11 December 2nd 04 11:04 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017