I have data on one spreadsheet, I’d like to add to another.
EXAMPLE:
Record ID’s
1
2
3
4
5
exist on one worksheet, with columns A thru D of misc. data.
Record
2 &
4
might exist on a 2nd worksheet, with a column “E” that I’d like to attach to the 1st worksheet. But records 1, 3, 5 don’t exist.
There are several HUNDRED records on each worksheet, so I can’t just link one column to the other, as I don’t know which #’s exist on both worksheets.
IS there a relatively SIMPLE way to do that in EXCEL 2007? or Excel 2003?
I don’t know Visual Basic.
If there’s an easy way to do it using MS Access 2003 or 2007, I’ll try that, but again, it can’t be too ‘fancy’ or I’ll get lost trying to do it.
I know this is going to be tough, but appreciate ANY and ALL help out there!
Thanks,
Michael
mikef42@gmail.com
