Copying consecutive row references to consecutive spreadsheets?

  • Thread starter Thread starter abc
  • Start date Start date
A

abc

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
 
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.
 
Back
Top