Data Form Collation?

**ASH2707** · 04-14-2010, 04:57 AM

Please excuse my ignorance, and once again I hope not to be duplicating another thread, however I have no idea of the correct key words to use to find another thread

My Question:

I have a worksheet with all my information on it, it names, address’s an other personal info, arranged in a line by line format.

I then have another worksheet which I’d like to be able to pull in the info from a specific line on the 1st sheet but the cells are dotted about the sheet and not line by line.

Is this possible, and if so can anyone enlighten me?

Thanks in advance

**deemo** · 04-14-2010, 06:48 AM

Hi ASH2707, perhaps worth uploading an example?

**royUK** · 04-14-2010, 07:13 AM

It would be a simple task with VLOOKUP if the data was arranged in a Table Format.

**ASH2707** · 04-14-2010, 09:04 AM

Roy,

Thanks for the reply. I must admit it seems I'm thinking far too much into this, and yes a Vlookup would work.

**royUK** · 04-14-2010, 11:51 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save