Combining two sheets of data into one and sorting by value - using macros
O.K. I'm working on it again.
This time I'm trying to configure a way to do the same outcome to two different sheets in the same workbook and copy the correct information into a third.
For example,
Miles driven, vehicle # , and Date are in one sheet (Sheet 2) and Date, vehicle #, and gallons of fuel purchased are in another sheet (Sheet 3).
What I need is in another sheet (Vehicle #) copy the appropriate information found in the two different sheets and paste it into the third (Vehicle #) sheet.
Basically, combining the information sorted by date into the vehicle's unique sheet in the same workbook.
Any/all assistance would be greatly appreciated.
Thank you
|