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
Quote:
Originally Posted by frankjh19701
Thanks Ben.
I got the code to work after I removed the DIM after the first one. I still need to figure out how to get teh macro to create a new sheet if a sheet with the name it searched for didn't exist.
After that, I would like to run a macro that would subtotal each worksheet by amount and location.
Any ideas?
Thank you again for Nathan and your assistance
|