×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Extrq

Extrq

(OP)
I am using M$ Excel 2000.

I need to make a completly automated sheet that take datas from a matrix so like:

Description    DATE       Money
A goood one    01/01/2003 500 €
A bad one      01/01/2003  -5 €
An other day   05/06/2003  22 €
ect            ect        ect  


making a briefing where all the same date have summed the monay with no black lines and no user interaction needed.

I thought about make a sheet with all possible dates + a conditional sum, finally use a filter to hide "0 money" row. But the filter does not recalculate it self automatically.

Any clues?

RE: Extrq

Have you tried using a Pivot Table, with Date in the rows and the money as data (As Sum).
This would give the report as you request
Regards

RE: Extrq

(OP)
Unluckly not even the pivot table automatically recalculates, you have to click on the "!" icon, I'd have to find a way to do this without user iteraction.

My chief has very clear about this... :(

Is there a way to start a macro everytime the sheet is recalculated?

RE: Extrq

Make sure your pivot table is on a different worksheet (tab) than your data.  Then tell the pivot table (via VBA) to recalc everytime you click on the sheet.  (VERY trivial, just play around with it and you should be able to figure it out)

RE: Extrq

(OP)
Thanks Melone and everyone, it worked.

A small advice to everyone do not know VB, just make a macro and copy the line from there... ;)

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources