Newbie needs help with spreadsheet "form"

  • Thread starter Thread starter ISDPCMAN
  • Start date Start date
I

ISDPCMAN

I'm creating a spreadsheet with 3 tabs. I have a company info and user info
box with fields on the first sheet. I would like if changes I make in those
cells would automatically copy to the other tabs in the same spot (e.g.
value A1 on Tab1 is changed I want that change to be copied to A1 on Tab 2
and A1 on Tab 3)

Is that possible? If so, how do I do that?
 
Hi,

Easiest way is to move to another sheet and enter a formula of the form

=Sheet1!A1
 
Select Tab2 and Tab3 by CTRL + Click on sheet tabs.

Tab2 in A1 enter =IF(Tab1!A1="","",Tab1!A1)

Will be entered on both sheets.

Select Tab1 and type something in A1...........see it in A1 of Tab2 and Tab3

These formulas can be copied down and/or across as desired.


Gord Dibben MS Excel MVP
 
In Sheet2 enter this formula in cell A1

=Sheet1!A1

Ditto on Sheet 3

Substitute the names on your sheet tabs as appropriate.


Alternatively,
-Navigate to Sheet2 and click on cell A1.
-Enter an equal sign (=) in the formula bar.
-Click on the sheet 1 tab
-Click on cell A1
-Press [Enter]

The formula will drag or copy the same as other formulae.
 
This is a neat trick! I'll try that!

Thanks everyone for the quick responses. This will save me a TON of time :-)
 
That didn't work for me. When I tried that in my spreadsheet I get a popup
dialog "Update Values: Tab1" and it's showing me a list of folders to choose
from.
 
The Alternative Method worked. Didn't when I typed it in manually but the
formula looks exactly the same as what i typed. Odd.

This is Excel 2007, by the way. Don't know if that makes a difference or not
but his alternative method did do the trick :-)


AltaEgo said:
In Sheet2 enter this formula in cell A1

=Sheet1!A1

Ditto on Sheet 3

Substitute the names on your sheet tabs as appropriate.


Alternatively,
-Navigate to Sheet2 and click on cell A1.
-Enter an equal sign (=) in the formula bar.
-Click on the sheet 1 tab
-Click on cell A1
-Press [Enter]

The formula will drag or copy the same as other formulae.


--
Steve

ISDPCMAN said:
I'm creating a spreadsheet with 3 tabs. I have a company info and user
info box with fields on the first sheet. I would like if changes I make
in those cells would automatically copy to the other tabs in the same
spot (e.g. value A1 on Tab1 is changed I want that change to be copied to
A1 on Tab 2 and A1 on Tab 3)

Is that possible? If so, how do I do that?
Click to expand...
Click to expand...
 
Ok, i FINALLY got the formula's to work and that CTRL-Click on the tabs is
the balls. That worked great!

Here's one other problem i'm working with:
These sheets are primarily identical except they represent different
"grades" of offerings. So Tab1 is the top of the line, Tab2 is the
intermediate line and Tab3 is the Walmart version. The sales team wants to
be able to edit TAB1 values and have them replicate to the prospective spots
on tabs 2 and 3 (which you all have nicely helped me achieve.) It would be
GREAT if they can print all 3 sheets at one time (e.g. print tabs 1, 2, and
3 with one print command and get all 3 pages on separate pieces of paper.)

Is that something that can be scripted or configured in Excel 2007?
 
Ok, i FINALLY got the formula's to work and that CTRL-Click on the tabs is
the balls. That worked great!

Here's one other problem i'm working with:
These sheets are primarily identical except they represent different
"grades" of offerings. So Tab1 is the top of the line, Tab2 is the
intermediate line and Tab3 is the Walmart version. The sales team wants to
be able to edit TAB1 values and have them replicate to the prospective spots
on tabs 2 and 3 (which you all have nicely helped me achieve.) It would be
GREAT if they can print all 3 sheets at one time (e.g. print tabs 1, 2, and
3 with one print command and get all 3 pages on separate pieces of paper.)

Is that something that can be scripted or configured in Excel 2007?
Click to expand...

Yes. You should see an option to Print Entire Workbook when you select
File|Print.
 
If you have a space in name Tab 1, you must surround with single quotes.

'Tab 1'!


Gord
 
When you use the = and click>enter, Excel provides the single quotes
around the name if required.


Gord

The Alternative Method worked. Didn't when I typed it in manually but the
formula looks exactly the same as what i typed. Odd.

This is Excel 2007, by the way. Don't know if that makes a difference or not
but his alternative method did do the trick :-)


AltaEgo said:
In Sheet2 enter this formula in cell A1

=Sheet1!A1

Ditto on Sheet 3

Substitute the names on your sheet tabs as appropriate.


Alternatively,
-Navigate to Sheet2 and click on cell A1.
-Enter an equal sign (=) in the formula bar.
-Click on the sheet 1 tab
-Click on cell A1
-Press [Enter]

The formula will drag or copy the same as other formulae.


--
Steve

ISDPCMAN said:
I'm creating a spreadsheet with 3 tabs. I have a company info and user
info box with fields on the first sheet. I would like if changes I make
in those cells would automatically copy to the other tabs in the same
spot (e.g. value A1 on Tab1 is changed I want that change to be copied to
A1 on Tab 2 and A1 on Tab 3)

Is that possible? If so, how do I do that?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top