Question

Locked

How can I move data from 1 xls worksheet to a 2nd (records not all same)?

By mikef42 ·
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

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Multiple sheets in the same workbook

by oldbaritone In reply to How can I move data from ...

VLookup is a good way, but if the data is in different sheets as you mentioned, it will be much easier if you combine all of the sheets into the same workbook, or a summary workbook.

http://msdn.microsoft.com/en-us/library/cc837974(v=office.12).aspx

Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums