How to copy group of cells from worksheet to worksheet?


Posted by LM on January 21, 2002 8:41 AM

Hello,

I need to have cells A1:A50 in worksheet 2 reference the same cells in worksheet 1 so that when the data in those cells in worksheet1 changes, worksheet 2 will also reflect those changes. Can I do this ALL AT ONCE, rather than for EACH cell starting in cell A1 in worksheet 2, enter an "=" sign, go to A1 in worksheet 1, hit enter and have the worksheet name and cell reference appear?

Thank you.

Posted by Mudface on January 21, 2002 11:24 AM

Probably the easiest way is to copy the cells you want from sheet 1, then Paste Special- Paste Links onto sheet 2. Hope that helps.

Posted by Marcellus on January 21, 2002 11:25 AM

I find it strange that no one has bothered to answer this one. The simple way is as you mentioned: Hit the = sign, switch to the desired workbook (or work sheet), select the cell and hit enter.

Now, if you hover your cursor over the bottom-left of the cell, you will see that it changes to a + sign. This is called the Copy Drag Handle (or something similar). Left-click on this handle and drag down.

One thing to note:
If the formula in your cell looks something like this: =Sheet1!$A$1, then remove the $ signs before dragging.


Posted by LM on January 22, 2002 6:39 AM

Thank you for answering a first time vistor to your message board. Now how do I copy a COLUMN of cells from worksheet 1 into a ROW of cells in worksheet 2. IE: what was going down in worksheet 1 now needs to go across in worksheet 2. When I try this the cell references don't come through as I need them to. The only way I have been successful so far is to use the "=" sign and go back and forth between worksheets for EACH cell. Not sure how to explanin this. Do you need further clarifcation?


Posted by LM on January 22, 2002 6:47 AM

Additional comment: It is not just copying I need to do, it is obtaining the cell data I need to get from the column to the row, so that when the column data in worksheet 1 changes, it also changes the row data in worksheet 2. Thank you for answering a first time vistor to your message board. Now how do I copy a COLUMN of cells from worksheet 1 into a ROW of cells in worksheet 2. IE: what was going down in worksheet 1 now needs to go across in worksheet 2. When I try this the cell references don't come through as I need them to. The only way I have been successful so far is to use the "=" sign and go back and forth between worksheets for EACH cell. Not sure how to explanin this. Do you need further clarifcation? : I find it strange that no one has bothered to answer this one. The simple way is as you mentioned: Hit the = sign, switch to the desired workbook (or work sheet), select the cell and hit enter. : Now, if you hover your cursor over the bottom-left of the cell, you will see that it changes to a + sign. This is called the Copy Drag Handle (or something similar). Left-click on this handle and drag down. : One thing to note:

Posted by Marcellus on January 22, 2002 11:21 AM

It's my pleasure

2. IE: what was going down in worksheet 1 now needs to go across in worksheet 2. When I try this the cell references don't come through as I need them to. The only way I have been successful so far is to use the "=" sign and go back and forth between worksheets for EACH cell. Not sure how to explanin this. Do you need further clarifcation?

Your explanation is perfect! I've done that before as well untill I got to grips with the basics of Visual Basic :)

I don’t think you can do that without the assistance of Visual Basic.

Excel allows you to copy a row of cells, select the sheet of your choice, Right-click, select “Paste Special” and hit the button at the bottom-left corner marked Paste Link.

It greys out the Paste Link button as soon as you select the transpose button though!

How is your knowledge on Visual Basic?



Posted by LM on January 25, 2002 5:12 AM

It's my pleasure 2. IE: what was going down in worksheet 1 now needs to go across in worksheet 2. When I try this the cell references don't come through as I need them to. The only way I have been successful so far is to use the "=" sign and go back and forth between worksheets for EACH cell. Not sure how to explanin this. Do you need further clarifcation? Your explanation is perfect! I've done that before as well untill I got to grips with the basics of Visual Basic :) I don’t think you can do that without the assistance of Visual Basic. Excel allows you to copy a row of cells, select the sheet of your choice, Right-click, select “Paste Special” and hit the button at the bottom-left corner marked Paste Link. It greys out the Paste Link button as soon as you select the transpose button though! How is your knowledge on Visual Basic?

Sorry, I don't know anything about Visual Basic. Is it something simplistic you can tell me here or do I need to pursue it as a training matter?