When I open an Excel - by default I see 3 workseets. My question:
I have 3 separate excel files. How to create from 3 excel files one
file with 3 worksheets?

I have 3 excel woksheets - A1, A2, A3. Each of them have a column
called SSN. I want to add to a new column to A1 with the following
walues:
if SSN from A1 exist in A2 - the value will be "A2"
if SSN from A1 exist in A3 - the value will be "A3"
if SSN from A1 does not exist in A2 and A3 - the value will be "N"

Can you give me a hint how to do it?

Thanks,

Zalek

=IF(A2!A1="SSN","A2",IF(A3!A1="SSN","A3","N"))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"zalek" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> When I open an Excel - by default I see 3 workseets. My question:
> I have 3 separate excel files. How to create from 3 excel files one
> file with 3 worksheets?
>
> I have 3 excel woksheets - A1, A2, A3. Each of them have a column
> called SSN. I want to add to a new column to A1 with the following
> walues:
> if SSN from A1 exist in A2 - the value will be "A2"
> if SSN from A1 exist in A3 - the value will be "A3"
> if SSN from A1 does not exist in A2 and A3 - the value will be "N"
>
> Can you give me a hint how to do it?
>
> Thanks,
>
> Zalek
>

In new column drag down this formula:

=IF(COUNTIF('A2'!A1:A50,A1),"A2",IF(COUNTIF('A3'!A1:A50,A1),"A3","N"))

see Ron's site about Copy/paste from workbooks:
http://www.rondebruin.nl/tips.htm

Mike F
"zalek" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> When I open an Excel - by default I see 3 workseets. My question:
> I have 3 separate excel files. How to create from 3 excel files one
> file with 3 worksheets?
>
> I have 3 excel woksheets - A1, A2, A3. Each of them have a column
> called SSN. I want to add to a new column to A1 with the following
> walues:
> if SSN from A1 exist in A2 - the value will be "A2"
> if SSN from A1 exist in A3 - the value will be "A3"
> if SSN from A1 does not exist in A2 and A3 - the value will be "N"
>
> Can you give me a hint how to do it?
>
> Thanks,
>
> Zalek
>