R
ricky
i am trying to do a bank rec where i match on:
check number (exact match)
deposit amount and date (both field need to match)
Column A = check #
column B = date
column C= amount
I may need to tell the macro if
check (c) or deposit (d)
if (c) match on column A
if (d) match on column B and C
i need to highlight the cells that match in both sheets.
thanks,
check number (exact match)
deposit amount and date (both field need to match)
Column A = check #
column B = date
column C= amount
I may need to tell the macro if
check (c) or deposit (d)
if (c) match on column A
if (d) match on column B and C
i need to highlight the cells that match in both sheets.
thanks,