Good afternoon.
I have two sheets (attached) that share identical information (Name, Date, Amount), which represent individual purchases.
I need to bring in the matching data from Sheet 2 into Sheet 1 but I can't figure out how.
Usually I would just do a Vlookup but this won't work because there are no unique values in Sheet 2 to reference.
So I'm just pasting in all of the sorted data by name, date and amount but I would imagine that there is formula (or macro) that would allow the data to follow automatically?
Specifically I need the data from Sheet 2 B:D to flow into Sheet 1 G:I.
Any ideas?
Bookmarks