find duplicate data and copy to a third worksheet
 

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

find duplicate data and copy to a third worksheet
 

use the vlookup function

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

as an example.
--
Regards,
Tom Ogilvy

"Arnfinn Hakkebo" wrote in message
...
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

find duplicate data and copy to a third worksheet
 

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


"Tom Ogilvy" wrote in message
...
use the vlookup function

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

as an example.
--
Regards,
Tom Ogilvy

"Arnfinn Hakkebo" wrote in message
...
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

find duplicate data and copy to a third worksheet
 

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

"Arnfinn Hakkebo" wrote in message
...
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


"Tom Ogilvy" wrote in message
...
use the vlookup function

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

as an example.
--
Regards,
Tom Ogilvy

"Arnfinn Hakkebo" wrote in message
...
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