Copying consecutive row references to consecutive spreadsheets? (Excel)

[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

[DaveB]

Hi,
If I understand your post correctly, then the best low-tech solution I
know of is to set up your worksheets 2, 3, etc. beforehand, and then
have them reference the info in sheet1.

So what you have is a table of info in sheet1, and then references
throughout the workbook's other sheets to that table through simple
references. I always use this approach to spreadsheet modeling, where
one (rarely more) sheet has parameters that feed into the rest of the
workbook's sheets.

If it isn't clear how you set up references from the dependent sheets to
the original, then repost.

HTH
Dave Braden

Post by 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.
Co# Name Address
1 ABC DEF
2 GHI JKL
3 MNO PQR
Co# Name Address
1 ABC DEF
Co# Name Address
2 GHI JKL
Co# Name Address
3 MNO PQR
Thank you,
Enelra