Thanks Anne,
It was very kind of you to bear with me.
As you can see I am a newbie.
I will try to collate my difficulties first and then send you exactly what I
want.
Regards.
Anne Troy wrote:
|| This layout sounds horrible to maintain. If you like to send me your
|| file, perhaps I can come upw ith a friendly layout that won't be so
|| difficult to maintain. Why repeat your data? Perhaps you should be
|| using a database. ************
|| Anne Troy
||
www.OfficeArticles.com
||
||
|| ||| Hi,
||| I think I have not been able to explain my problem properly.
||| Let me put it in this way.
||| I have three worksheet with various inputs.
||| Now I want to summarize them in fourth worksheet.
||| The data which I have in A4 cell of first worksheet I want to put
||| in B5 cell
||| of fourth worksheet.
||| Similarly data in A6, A8 and A11 of fist worksheet has to go in
||| fourth worksheet in C7, D8 and E11 of fourth worksheet.
||| Similar data in other two worksheet will also go to the
||| corresponding cells
||| in fourth workshheet one below the other.
||| Now I am linking the cells of worksheets one at a time.
||| I want to link all of them in one go.
||| Can I do it?
||| If yes how do I do it?
||| Your guidance will be of great help to me.
||| Thanks & Regards.
|||
|||
||| Anne Troy wrote:
||||| Sure. You can copy a whole range of cells, then paste
||||| special-->paste link. OR, if the cells are all adjacent, you can
||||| copy one, then copy the cell down and/or across.
||||| ************
||||| Anne Troy
|||||
www.OfficeArticles.com
|||||
||||| |||||| HI Anne,
|||||| I visited the site you mentioned and also found "Easiest Way to
|||||| Link Cells in Microsoft Excel".and right now I am linking the
|||||| cells in that way . What I wanted, was how to link multiple
|||||| cells in one go instead of linking one at time.
|||||| Is there a way to link multiple cells at one got to another
|||||| worksheet? Regards.
||||||
||||||
||||||
||||||
||||||
||||||
||||||
|||||| Anne Troy wrote:
|||||||| Perhaps this will help:
||||||||
||||||
|||
http://www.officearticles.com/excel/sum_the_same_cell_in_multiple_microsoft_
|||||| excel_worksheets.htm
|||||||| ************
|||||||| Anne Troy
||||||||
www.OfficeArticles.com
||||||||
|||||||| ||||||||| Hi,
||||||||| I want to link cells of number of worksheet with a single
||||||||| worksheet which will be the summary of all the worksheet.
||||||||| Right now I am linking the sheets with one cell at a time .
||||||||| Is there a simple way to link all sheets at one go?
||||||||| Kindly guide me in the matter.
||||||||| Thanks.