Hello!

If I have a spreadsheet where the data in each row corresponds to a
unique company, what is the fastest and easiest way to copy each row
reference to its own spreadsheet?

If the data in Sheet1 is updated, I want the data in the other sheets
to update too.

I'm starting with:

Sheet1:
Co# Name Address
1 ABC DEF
2 GHI JKL
3 MNO PQR

And I want:

Sheet2:
Co# Name Address
1 ABC DEF

Sheet3:
Co# Name Address
2 GHI JKL

Sheet4:
Co# Name Address
3 MNO PQR

Thank you,
Enelra

--
Posted via a free Usenet account from http://www.teranews.com

Select all the cells in the row you're interested in,
Right click in the selection and choose "Copy",
Navigate to the new location in the new WS,
Right click in the left most cell in that new location,
Choose "Paste Special",
Click on "Paste Link",
And you're done.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"abc" <_abc@xyz.com_> wrote in message
news:b0clo3dqs8gkmfs743qg3tco0neda4mbfv@4ax.com...
> Hello!
>
> If I have a spreadsheet where the data in each row corresponds to a
> unique company, what is the fastest and easiest way to copy each row
> reference to its own spreadsheet?
>
> If the data in Sheet1 is updated, I want the data in the other sheets
> to update too.
>
> I'm starting with:
>
> Sheet1:
> Co# Name Address
> 1 ABC DEF
> 2 GHI JKL
> 3 MNO PQR
>
> And I want:
>
> Sheet2:
> Co# Name Address
> 1 ABC DEF
>
> Sheet3:
> Co# Name Address
> 2 GHI JKL
>
> Sheet4:
> Co# Name Address
> 3 MNO PQR
>
> Thank you,
> Enelra
>
> --
> Posted via a free Usenet account from http://www.teranews.com
>

Select all the cells in the row you're interested in,
Right click in the selection and choose "Copy",
Navigate to the new location in the new WS,
Right click in the left most cell in that new location,
Choose "Paste Special",
Click on "Paste Link",
And you're done.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"abc" <_abc@xyz.com_> wrote in message
news:b0clo3dqs8gkmfs743qg3tco0neda4mbfv@4ax.com...
> Hello!
>
> If I have a spreadsheet where the data in each row corresponds to a
> unique company, what is the fastest and easiest way to copy each row
> reference to its own spreadsheet?
>
> If the data in Sheet1 is updated, I want the data in the other sheets
> to update too.
>
> I'm starting with:
>
> Sheet1:
> Co# Name Address
> 1 ABC DEF
> 2 GHI JKL
> 3 MNO PQR
>
> And I want:
>
> Sheet2:
> Co# Name Address
> 1 ABC DEF
>
> Sheet3:
> Co# Name Address
> 2 GHI JKL
>
> Sheet4:
> Co# Name Address
> 3 MNO PQR
>
> Thank you,
> Enelra
>
> --
> Posted via a free Usenet account from http://www.teranews.com
>