|I'm not understanding what you are asking. You need to give some more details, perhaps an example of the data from the 2 spreadsheets and how they are laid out.|
re: I need to be able to take his column C and import to my worksheet but keep the data in columns A and B in the
You've lost me here.
re: "Brown" in column A should always line up with "Amy" in column B and "123 Pinola Road" in column C.
What's causing them not to line up? You need to explain this in more detail.
Please follow this posting tip when you post your examples:
Above the comments box there is a little symbol that reads pre
If you click on that symbol it will insert the pre tags in your post. If you paste your data between the pre tags, you can arrange the data in columns and they will stay lined up. If you try to arrange the data by simply inserting spaces between the values - without using the pre tags - the extra spaces will be deleted.
Paste the data in between the pre tags and click the Preview Follow Up button. This will allow you see how the data lines up without actually submitting your post.
If you don't like how the data lines up, you can edit your post below the preview window.
To preview your post again, click in the box next to:
Check To Show Confirmation Page Again
and click either Confirm button. This will allow you keep checking your post until the data is lined up so that we can tell which column contains what.
Once you are satisfied that the data lines up correctly, just click either Confirm button.
Finally, if you include the sheet names and column letters, we might be able to provide a final solution. If not, we will have to assume sheet names and columns and you will have to modify the solution to match your workbook.
It should something like this when you are done:
A B C
1 Brown Amy 123 Pinola Road
2 Green Bob 456 Alonip Ave