Moving values from one sheet to another

Question

I'm looking for an Excel 2003 macro to solve this problem.

I have a sheet that holds financial information:

A1 holds client names and AI1,AK1,AM1 etc, hold months April, May, June (all string values) etc; with the rows below that holding the amount due for the corresponding month. The last row is the total.

What I need is to create a summary page that checks a named field called current month which holds the current month as a string value, and the balances for each month up to and including the current month.

If the total due is greater than 0, then place the month name and the total due into a new table on the summary page, so that I end up with a table that has only the months that we have money due to us on it.

Answer 1

You haven't laid out why you need it to be a macro. But anyway... to make sure I understand the request:

Effectively, create a summary table for each client.

If the sum of dues from January to CurrentMonth > 0 then copy the table.

Delete the column of each month where the amount due is zero.

Okay, since this is Excel 2003, I've been very cautious.

I decided to use a pivot table, then if you want to expand the detail to help identify the clients responsible you can easily do so.

Code

Screencaps at imgur.com: fO7zM.png eCWS2.png 7FBUV.png (I can't post more than one link yet per post)