Copying information??

[Kimberly]

Is there a way to input information on one worksheet
within a workbook and have it go to another worksheet
within another workbook?

Please help!
Thanks

 

[Ron de Bruin]

Hi Kimberly

You can link to cell in a other workbook
=[Book2.xls]Sheet1!$A$1

With VBA you can do this
http://www.rondebruin.nl/copy1.htm

 

[Kimberly]

Thanks alot.
Can I copy an entire row or column at one time, or do I
have to do them individually?
Thanks again!

-----Original Message-----
Hi Kimberly

You can link to cell in a other workbook
=[Book2.xls]Sheet1!$A$1

With VBA you can do this
http://www.rondebruin.nl/copy1.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Kimberly" <[email protected]> wrote

in message news:[email protected]...

 

[Ron de Bruin]

Do you want to use Code?

--
Regards Ron de Bruin
http://www.rondebruin.nl

Thanks alot.
Can I copy an entire row or column at one time, or do I
have to do them individually?
Thanks again!

-----Original Message-----
Hi Kimberly

You can link to cell in a other workbook
=[Book2.xls]Sheet1!$A$1

With VBA you can do this
http://www.rondebruin.nl/copy1.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Kimberly" <[email protected]> wrote

in message news:[email protected]...

.

 

[Kimberly]

Yes please.
Also, what if at a later date I need to insert a row?
Does the formula carry over to an inserted line?
Thanks

-----Original Message-----
Do you want to use Code?

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Kimberly" <[email protected]> wrote

in message news:[email protected]...

Thanks alot.
Can I copy an entire row or column at one time, or do I
have to do them individually?
Thanks again!

-----Original Message-----
Hi Kimberly

You can link to cell in a other workbook
=[Book2.xls]Sheet1!$A$1

With VBA you can do this
http://www.rondebruin.nl/copy1.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Kimberly" <[email protected]> wrote

in message news:21de01c4a6f1$d9ca4ee0 [email protected]...

Is there a way to input information on one worksheet
within a workbook and have it go to another worksheet
within another workbook?

Please help!
Thanks


.

.

 

[Ron de Bruin]

Hi Kimberly

Try the example on my webpage first (it will copy values only)
http://www.rondebruin.nl/copy1.htm#workbook

http://www.mvps.org/dmcritchie/excel/getstarted.htm
See David McRitchie's site if you just started with VBA

--
Regards Ron de Bruin
http://www.rondebruin.nl

Yes please.
Also, what if at a later date I need to insert a row?
Does the formula carry over to an inserted line?
Thanks

-----Original Message-----
Do you want to use Code?

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Kimberly" <[email protected]> wrote

in message news:[email protected]...

Thanks alot.
Can I copy an entire row or column at one time, or do I
have to do them individually?
Thanks again!
-----Original Message-----
Hi Kimberly

You can link to cell in a other workbook
=[Book2.xls]Sheet1!$A$1

With VBA you can do this
http://www.rondebruin.nl/copy1.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


in message [email protected]...
Is there a way to input information on one worksheet
within a workbook and have it go to another worksheet
within another workbook?

Please help!
Thanks


.

.