Hello everyone,
Please this is very urgent, I shall need a quick result,
I have two sheets in excel (field 1 & 2), each of which contains, inter align , a column which contains number of bills, I need a tool (or formula with explanation or with macro explanation because I am not well experienced), which allows me to extract the number of bills that exists in sheet 1 but not in sheet 2 and put the information on this bill (line as a whole) in a 3rd leaf.
And the same approach for the invoice number in the sheet 2 but not in sheet 1 and put the result in a 4th leaf.
Thank you and please this is very urgent.
Bookmarks