I'm fairly new to excel and completely new to the forum. I have a problem that surely must be a quite common one, but I've been searching high and low without finding what I'm after.
I have two spreadsheets.
Sheet 1 has two columns:
Date Incidents
02/11/06 200
02/18/06 360
02/24/06 240
Sheet 2 has two columns too:
Date Cost
02/11/06 436
02/12/06 229
02/13/06 610
02/14/06 374
02/15/06 450
02/16/06 56
02/17/06 450
02/18/06 450
02/19/06 436
02/20/06 450
02/21/06 341
02/22/06 654
02/23/06 782
02/24/06 336
02/25/06 742
02/26/06 582
I want to combine the two to get:
Date Cost Incidents
02/11/06 436 200
02/12/06 229
02/13/06 610
02/14/06 374
02/15/06 450
02/16/06 56
02/17/06 450
02/18/06 450 360
02/19/06 436
02/20/06 450
02/21/06 341
02/22/06 654
02/23/06 782
02/24/06 336 240
02/25/06 742
02/26/06 582
I'd be very grateful for any help. And when giving your answer keep in mind that I'm a bit of an excel newbieThanks!
Bookmarks