Macro to repeat task for every row (undetermined)

[shadolphus]

I have a statement and an payment report that i compare and from this i take the unmatched and enter into a sheet named combined. I also enter the total of the statement and the payment report. i then make the payment total a negative number and the statement unmatched values negatives. With this i create a pivot table this puts all my credits, claims, outstanding invoices, invoices on payment report and rebates in all seperate tabs. i can i create a macro that will do all of this for me no matter how many lines are in the statement and payment report.

[arlu1201]

Do you have a sample file that you can upload?

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[shadolphus]

This is the file.
1. Statement and ageing report - a vlookup is done with these sheets
2. Then all the none matching ones are added to the stt&age page and both the balance of the sheets as well
3. the age balance is turned into negative and also all the none matching invoices from the statement.
4. a pivot table is created, from there a sheet is created for each entry on the pivot table and the totals are added to the front sheet

[arlu1201]

You need to explain a little in detail. What is added where.

[shadolphus]

I have a statement and an payment report that i compare and do a vlookup to match off the invoices. both of these reports can have thousands of lines on them.

From this i take the unmatched invoices from both the statement and the payment report and enter into one sheet named combined.

I also enter the total of the statement and the payment report.

I then make the payment total a negative number and the statement unmatched values negatives.

With this i create a pivot table this puts all my credits, claims, outstanding invoices, invoices on payment report and rebates in all separate tabs.

i need a macro that will do all of this for me no matter how many lines are in the statement and payment report.

[arlu1201]

Ok, can you point out which columns in which sheets are involved in each of these actions?

For e.g.

I have a statement and an payment report that i compare and do a vlookup to match off the invoices. both of these reports can have thousands of lines on them.

Which sheets are you talking about and which columns...

etc...

[shadolphus]

Age sheet is the payment information
stt sheet is the statement sheet
we compare the data in these 2 sheets and then put the none matching data from both sheets and the totals of ea of these sheets in a new work book that we name age & stt. The total of the age is turned into a negative number, the stt stays the same.
When all this data is together we create a pivot(pvt) and from there we create the different sheets according to the data on the pivot table.