excel data gathering

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paul Hadidon - 01 Apr 2004 02:17 GMT

I have a spreadsheet that has columns for tracking information. I am
trying to track spending for the week. When the weekending date is
input. I need to pull from 3 columns. Date, code, and amount based on
the previous 7 days of the week ending date. I have racked my brain
trying to come up with a way to do this. email me if you need more
information. Thanks in advance for your help...

Reply to this Message

Debra Dalgleish - 01 Apr 2004 05:51 GMT

To summarize your data, and show the total for each week, you could use
a pivot table. There are instructions and links here:

http://www.peltiertech.com/Excel/Pivots/pivotstart.htm

When you create the pivot table, add Date and Code to the Row area, and
Amount to the data area, where it will become Sum of Amount.

Right-click on the Date field button
Choose Group and Show Detail> Group
Select to Group by Days, and set the number of Days to 7
Click OK

> I have a spreadsheet that has columns for tracking information. I am
> trying to track spending for the week. When the weekending date is
> input. I need to pull from 3 columns. Date, code, and amount based on
> the previous 7 days of the week ending date. I have racked my brain
> trying to come up with a way to do this. email me if you need more
> information. Thanks in advance for your help...

Signature

Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply to this Message

Dave Hawley - 01 Apr 2004 06:47 GMT

Hi Paul

A Pivot Table would be a good way to go. If you are not up to speed with
this great Excel feature. Go here:

http://www.ozgrid.com/Excel/excel-pivot-tables.htm

For the all important fundamentals, free online tutorial and free
Workbook examples

Reply to this Message