Forum Discussion
Link cells to same location on multiple sheets
I need to paste data from 1 sheet to multiple sheets so, I have a list on sheet 1 each item on sheet 1 goes to the same location on different sheets. On sheet 1, cell A1 copies to sheet 2, cell A1 ...
Could you give a bigger picture of what it is you're doing?
That is, don't just repeat what you've said, but describe the context: what is the underlying goal or objective being served by your series of sheets?
The reason for asking that is that there are often multiple ways to accomplish things in Excel; what makes sense in a particular case will often depend on the bigger picture. What kind of information is it that you're working with? What's in the various rows on Sheet 1; what differentiates the data in cell A1 from the data in cell A2 and so forth?
If it's possible, without disclosing any confidential information, could you post a sample of your workbook?