LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
dan dan is offline
external usenet poster
 
Posts: 866
Default Extracting data to another sheet using multiple criteria

I use an ongoing daily transaction list for cash collections. It has 3
columns "Date of receipt", "customer name" & "amount". I want each customer
to have their own sheet that pulls their data from the daily transaction
list. To easily print customer statements, I would like to have the
transaction history for a specific customer show up on their sheet based on
a date range I choose by typing in the begin and end date in 2 adjacent
cells. Is this possible? If so, I will yell for joy in my office.
 
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
Multiple Sheet, Multiple Criteria Look-Up Function Help Dan Oakes Excel Worksheet Functions 5 December 29th 06 01:37 PM
extracting data by a criteria ? IF this , then That? MikeR-Oz New Users to Excel 4 February 13th 06 12:37 PM
Please help. Extracting data from one sheet to another leeannemat New Users to Excel 2 February 11th 06 02:55 PM
help extracting data from an excel sheet Tina Jones Excel Worksheet Functions 4 April 25th 05 01:18 AM
Extracting data from multiple worksheets into a list mnirula Excel Worksheet Functions 16 February 25th 05 08:52 PM


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

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

About Us

"It's about Microsoft Excel"