I'm useless with excel and was wondering if anyone has a solution to the below (hope I make sense)
I'm working with two datasets which need to be put next to each other on the same sheet and reconciled
I match line by line based on same amount and same department
If you refer to image (I've replaced with generic example data). I have table 1 columns A-D with actual confirmed card payments received. On the right table 2, columns F-K shows listing of card receipts manually recorded on sales system.
I normally sort and filter by amount for both sets of data and then manually match i.e. cut and paste the lines from my second dataset right next to my first. The end result is basically what the image shows - except I'll have to deal with hundreds of transactions and there's always discrepancies between the two lists which means nothing ever lines up neatly.
is there a much easier way where I can automate things and line up just the exact matches from table 2 straight away without this need for manual cut and paste? (as a start, then deal with the messier allocations later)
I'm working with two datasets which need to be put next to each other on the same sheet and reconciled
I match line by line based on same amount and same department
If you refer to image (I've replaced with generic example data). I have table 1 columns A-D with actual confirmed card payments received. On the right table 2, columns F-K shows listing of card receipts manually recorded on sales system.
I normally sort and filter by amount for both sets of data and then manually match i.e. cut and paste the lines from my second dataset right next to my first. The end result is basically what the image shows - except I'll have to deal with hundreds of transactions and there's always discrepancies between the two lists which means nothing ever lines up neatly.
is there a much easier way where I can automate things and line up just the exact matches from table 2 straight away without this need for manual cut and paste? (as a start, then deal with the messier allocations later)
