Excel Guru's

[bczoom]

Re: Excel Guru\'s

</font><font color="blue" class="small">( Unless you want worksheet 2 to update everytime worksheet one is changed, then use the instructions posted above)</font>

Yes, it'll update the target sheet if the from sheet is changed (which is what I assumed you wanted to do)

 

[thcri]

Re: Excel Guru\'s

Inspector,

For some reason that is not working for me. I just did it again using the value option and it does not work. If I copy using the formula value then it looks for the value of the formula on the wrong sheet. I can not get it to update the value only.

murph

 

[RoyJackson]

Re: Excel Guru\'s

If you right click the worksheet tab (bottom of the worksheet), you have an option to "Move or Copy".
Can you use that to move the worksheet data you need to the other workbook?

 

[thcri]

Re: Excel Guru\'s

Roy,

It looks like you can only move or copy the whole sheet. The formula above works just perfect. Problem is I won't use this function again for a couple of years so I will forget when I need it again. I just don't understand why that is not a question in Microsofts help section.

murph

 

[Spiffy]

Re: Excel Guru\'s

Looks like you did want the cell linked then.

I'm guessing Inspector was thinking the same as I. By using paste special and hitting the paste link button you should get the same "equation" as Brian provided. Nothing wrong with that at all, but I always find "paste special" easier to remember because I can then look at the options I want. BTW, in that equation, you will $ signs if you want to drag that exact value (or without if you want the drag to mimic the earlier page).

cwg

 

[Inspector507]

Re: Excel Guru\'s

I use Excel everyday at work to keep the guys overtime log correct. I copy/paste formulas, values and formats (any one of them or several) from one to the next when I fill a worksheet up.

 

[khd]

Re: Excel Guru\'s

Sorry but I'm slow, are you trying to get the formula in the 1st cell to do the same thing on a diff worksheet with the new worksheet's numbers or are you wanting the value of the original cell to show up in the new worksheet.

If the latter, BC gave it right but there is nothing you need to remember. In your new worksheet/cell type an "=" then just use you mouse to navigate back to the orig. worksheet and select the cell you want to reference and then hit "enter".. All done and nothing to remember. You can even do this for another workbook if you want to reference a cell in another file. After you do it each time you open the new worksheet it will ask if you want to update the reference to the other file.

If the former, copy and paste/paste special is the way to do it which now makes your new cell pull from the same cells on the new worksheet as the old cell did on it's worksheet but the two cells are not connected in anyway.

Regards,
Kevin

 

[thcri]

Re: Excel Guru\'s

Kevin,

That works and is what I am looking for. That makes it realy easy now if I just can remember it the next time. Thanks a bunch!!


murph