Excel and linking data between sheets

R

rlilley

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have a study that has 850 lines of data in the "Base Data" sheet. I use this as the basis for all other data sheets and subsequent analysis. Is there a way to, if you will, globally link each row of data (A-T) between the various sheets so that if I make a change on the Base Data sheet, it will migrate to all of the other sheets?

I would be happy to send an example if that would be helpful
Thanks,
Dick
 
C

CyberTaz

Well, if I understand your question you *can* - but are you really sure you
*want* to do this ? :) I don't pretend to know your requirements as well as
you do, but having all that same data appear on multiple sheets just seems
to be a redundancy that will do little more than create a bulky, complex
workbook - perhaps unnecessarily. It would require formula links on each
sheet for each field of each record. According to my calculations that
amounts to 17,850 formula links on *each* of the other sheets.

Before going that route there may be other approaches worthy of
consideration, but you'll need to provide more a specific description of
what your intended plan might be.

Regards |:>)
Bob Jones
[MVP] Office:Mac
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

update data between sheets 7
Embed the same Excel multiple times 0
Adding the content of multiple sheets to a consolidated sheet 2
Creating a summary chart using data from multiple sheets 1
View Data on Multiple Sheets 3
Data entry problem 0
Opening Excel Spread Sheets 1
multiply range of cells 3

Top