So I have this:
Sheet1
1 a roy
2 b orange
3 c yellow
4 y green
5 z blue
Sheet2
1 a january
2 b february
3 c march
4 f april
5 g may
...and I want to merge to create this:
Sheet3
1 a roy january
2 b orange february
3 c yellow march
4 f (blank) april
5 g (blank) may
6 y green (blank)
7 z blue (blank)
Is there any way to merge these two spreadsheets without going
cross-eyed?
--
mandg
------------------------------------------------------------------------
mandg's Profile:
http://www.excelforum.com/member.php...o&userid=34986
View this thread:
http://www.excelforum.com/showthread...hreadid=548763