I use a pivot table to assist in reconciling a large amount of data, up to 35,000 rows. Data is summarized by Object field. The unreconciled data in each Object is drilled down and some items reconciled, debits to credits. There could be 150 that can be reconciled from a drill down and need to be noted on data sheet. I currently do this manually which is tedious and wish to set up a macro to automate the operation.
New records are added to the data sheet from time to time, sorted by object and re-numbered as an ID to assist in locating records.
Fields for 'Reconciled' and 'today's date' are completed on the data sheet when a reconciliation has been completed.
I have tried loops but they don't complete. Also, I am unable to restrict the loop to the matching object field.
Please, can you help?
New records are added to the data sheet from time to time, sorted by object and re-numbered as an ID to assist in locating records.
Fields for 'Reconciled' and 'today's date' are completed on the data sheet when a reconciliation has been completed.
I have tried loops but they don't complete. Also, I am unable to restrict the loop to the matching object field.
Please, can you help?
