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.
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.
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?
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:
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 dont 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?
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 dont 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?