I must be missing something. nothing happens at all when I hit f9. it is
already set to automatic. does it matter that sheet 1 have different
formulas? i just need the calculated values to transfer though.

"KC" wrote:

I think it should automatically update, else you can hit F9 to force update
the sheets, or
Tools Options Calculation tab select Automatic OK

-kc
*Click YES if this helps

"laurah" wrote:

okay, now that i have the formulas in place, how do i get sheet 2 to
automatically update when i change the values in sheet 1?

"KC" wrote:

no problem!
you're welcome.

-kc

"laurah" wrote:

I appologize, this did work, I wrote you back before it asked me for the next
step. thanks so much!

"KC" wrote:

Good!
now, once your done with first step.
i.e., A1 in Sheet2 has the formula =Sheet1!A1

place your cursor near the bottom right corner of the A1 cell, you will get
a small plus sign, click and hold onto it and drag it to as many columns you
want and the release the mouse (don't click anywhere else), again hold the
plus sign and drag it to as many rows you want.

this should copy the formulas across all the cells you have draggred.

-kc
*Click YES if this helps


"laurah" wrote:

Awesome, this worked. Now is there anyway I can do a column at a time, or
do I have to do each individual cell separately?

"KC" wrote:

say you want A1 in sheet2 to show the value of A1 from sheet1 then
use the below formula in Sheet2 A1
=Sheet1!A1

-kc
*Click YES if this helps


"laurah" wrote:

I have a spreadsheet with 2 tabs and I need the values from the first sheet
to automatically fill in on the 2nd sheet. what is the formula to share cell
values from one tab to another?