LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Member
 
Posts: 89
Post Use a MACRO to Merge two sheets of data

I have a report that's due very soon and I need help.

I have to combine two sheets of data into one based on a few criteria and sorted by date and these criteria.

I've uploaded a file to assist anyone who can help me.

What I have to do is merge the information based on date and vehicle from two separate sheets into a third. Then sort by date and vehicle.

The finished product should show the date, vehicle, mileage, and amount of fuel purchased.

Any/all help will be greatly appreciated.

Thank you
Attached Files
File Type: zip Mileage Report W.E 9.22.13 Sample.zip (42.4 KB, 20 views)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to merge two sheets kay Excel Discussion (Misc queries) 2 September 17th 08 09:29 PM
Can I merge data in 2 sheets matching rows of data by last name? Corb Excel Discussion (Misc queries) 1 March 18th 07 05:32 PM
I have 100 excel sheets how can I merge all data into one sheet Po Excel Worksheet Functions 1 December 7th 06 04:31 PM
merge data from many sheets to one jb Excel Worksheet Functions 1 March 20th 06 06:14 PM
is there an easy way to merge data/information on several sheets . Robin Excel Discussion (Misc queries) 1 February 10th 05 03:12 PM


All times are GMT +1. The time now is 03:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"