LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Copying records from a date interval from one worksheet to another

I have one worksheet where I keep a running record of all my expenses
transactions for the year. My other worksheet is an expense form. I
prepare the expense form irregularly, so I want to find a way to list
a start and end date for an expense period on the expense form and
have all the records in that date range copied from the first
worksheet to the second. Any suggestions on a simple and/or efficient
way to accomplish this? The original worksheet is already arranged
with the column headers Date, Vendor, Amount, etc. and I need the
entire records copied into the second file (as opposed to just the
amounts, which I had previously been doing using a sumproduct)

 
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
Time interval worksheet function Zb Kornecki Excel Worksheet Functions 3 March 13th 07 07:33 PM
Date Interval Predictions [email protected] Excel Discussion (Misc queries) 1 October 31st 06 12:19 PM
Date Interval Predictions [email protected] Excel Worksheet Functions 1 October 31st 06 11:48 AM
Calculations with date time interval Todd F. Excel Worksheet Functions 6 September 22nd 05 07:43 PM
Counting datapoints/records in time interval [email protected] Charts and Charting in Excel 1 April 15th 05 05:46 AM


All times are GMT +1. The time now is 04:53 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"