Thread: Macro to copy row based on value into new sheet of same name
View Single Post
  #12   Report Post  
frankjh19701 frankjh19701 is offline
Member
  
Posts: 89
Post
Also,

I don't want to create duplicates or if I do - highlight the entire row that's been duplicated.

Thank you again

Quote:
Originally Posted by frankjh19701 View Post
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
Reply With QuoteReply With Quote