find duplicate data and copy to a third worksheet

[Arnfinn Hakkebo]

I have two files put together in two separate worksheets.
They have both a column with a unik userid.
I need to add data from a column next to userid in one worksheet to another
column in the first worksheet, does anyone have an easy solution?
PS Hope this made sense

regards
Arnfinn Hakkebo

 

[Tom Ogilvy]

use the vlookup function

=Vlookup(A2,'[Book2.xls]Sheet1'!$A$1:$F$100,2,False)

as an example.

 

[Arnfinn Hakkebo]

Im afraid that was a little short explanation from me, and maybe I did`nt
get it right?
worksheetA=7 columns 960 posts in each column, some are empty with 1 column
that have unik data
WorksheetB=5 columns with 15000 posts and 1 column that have unik data(this
aret the same as in A)
If id in WorksheetA corresponds with the one in B then 1 cell in B in a
column to the right of the corresponding cells shuld be copied and pasted to
the right of the same id in A.

hope this clarifies my desire, any help will be appreciated
thanks in advance
regards
Arnfinn

use the vlookup function

=Vlookup(A2,'[Book2.xls]Sheet1'!$A$1:$F$100,2,False)

as an example.
--
Regards,
Tom Ogilvy

I have two files put together in two separate worksheets.
They have both a column with a unik userid.
I need to add data from a column next to userid in one worksheet to another
column in the first worksheet, does anyone have an easy solution?
PS Hope this made sense

regards
Arnfinn Hakkebo

 

[Tom Ogilvy]

If you can't adapt the code yourself, then I can't guess where this unique
column might be on each sheet.

I also can't guess what to the right of the corresponding cell in A refers
to. You say A has 7 columns, so in column 8? Also, before we were pasting
both rows in the same row of a third sheet, but now one cell from the second
is pasted in the same row on the first sheet. To do this, you don't need a
macro. Look in Excel Help at the Vlookup function.



--
Regards,
Tom Ogilvy

Im afraid that was a little short explanation from me, and maybe I did`nt
get it right?
worksheetA=7 columns 960 posts in each column, some are empty with 1 column
that have unik data
WorksheetB=5 columns with 15000 posts and 1 column that have unik data(this
aret the same as in A)
If id in WorksheetA corresponds with the one in B then 1 cell in B in a
column to the right of the corresponding cells shuld be copied and pasted to
the right of the same id in A.

hope this clarifies my desire, any help will be appreciated
thanks in advance
regards
Arnfinn

use the vlookup function

=Vlookup(A2,'[Book2.xls]Sheet1'!$A$1:$F$100,2,False)

as an example.
--
Regards,
Tom Ogilvy

I have two files put together in two separate worksheets.
They have both a column with a unik userid.
I need to add data from a column next to userid in one worksheet to another
column in the first worksheet, does anyone have an easy solution?
PS Hope this made sense

regards
Arnfinn Hakkebo