Shopping Podder - the Best of Computer Postings! :: View topic - Copying consecutive row references to consecutive spreadshee

abc · Guest

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

DaveB · Guest

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

abc wrote:


www.ShoppingPodder.com Leading Computer Shopping, News and information	Part of the Identityscape.com network... getxfactor.com jmoodmusic.com smartbusinesschoices.com mintdepot.com lowfaresalways.com evangelicalview.com shoppingpodder.com soproudlywehail.com webnews.ws currenthumor.com

Shopping Podder - the Best of Computer Postings! Forum Index -> Computer Applications - Spreadsheets
Page 1 of 1