from different columns of spreadsheet in two tabs I need to compare all possible columns and reconcile the amounts
for example from concatenating column A, B and C in tab 1 (AR) and tab 2 (AP) if I find the amount to be zero those rows have to b copy pasted in new sheet,
that way I need to zero out all the amounts in both the sheets
the one which cannot be done have to be researched manually in an application
also if in the same tab if Jobid, Number and data date or same and my amounts sums up to zero that need to be put in a new sheet.
All the one which cannot be zeroed out have to be in one sheet.
Can a macro be built for this or is there a tool or formula where I can achieve this.
Please do let me know if I am not clear
for example from concatenating column A, B and C in tab 1 (AR) and tab 2 (AP) if I find the amount to be zero those rows have to b copy pasted in new sheet,
that way I need to zero out all the amounts in both the sheets
the one which cannot be done have to be researched manually in an application
also if in the same tab if Jobid, Number and data date or same and my amounts sums up to zero that need to be put in a new sheet.
All the one which cannot be zeroed out have to be in one sheet.
Can a macro be built for this or is there a tool or formula where I can achieve this.
Please do let me know if I am not clear
