Simple Excel Formula help..

[IamDavid]

I can't figure this out. I need Sheet2,3,4,5... to match sheet one and update when edited..

 

[MrBond]

Just put this formula in every cell you want to reference:

=Sheet1!A1

That will make that cell the same as the cell on Sheet 1 in A1

 

[IamDavid]

I have hundreds of cells filled.. That wouldn't work very well..

 

[iroast]

What MrBond said and fill down/across(?).

 

[theknight571]

If the cells to update are the same cells on the other spreadsheets as they are on Sheet1, then you can attach this code to Sheet1 and it will update the same cell on any other sheet specified.

Just add a line for each Sheet you need to update.

 

[IamDavid]

Thanks theknight571,
What do I need to agjust to have only specific colums inserted? Like colums 1,3,5,7???

 

[theknight571]

The formula works on a cell by cell basis.

So if you change A1 on Sheet1.. A1 on all subsequent sheets will change.

What are you trying to accomplish with inserting certain columns?

Or... do you only want to to be effective for certain columns... so not all changes are sent to the other sheets. (Which after taking a step back... might cause problems... hmmm.)

 

[IamDavid]

I need only certain colums.. It's a bascic hours spreadsheet for work...
Colums 1 3 5 7 are names that I need the smae one all sheets, editable by only sheet 1..
Colums 2 4 6 8 are worked hours that I need to be able to edit on a sheet by sheet basis without affecting anything else..

Thanks for all the help....

 

[theknight571]

Ok... to limit it to certain Columns only use the following code, changeing the Select statement to include the Column NUMBERS (not the letters. A=1, B=2, C=3, etc) that you want the formula to work on.

 

[IamDavid]

Your awsome. Where did you learn all this?

 

[theknight571]

When I first started this job (a long time ago) they had some apps written in Visual Basic...so I had to learn it.

Then MS moved it's Macro Language to Visual Basic for Applications. They a similar. 🙂

So that combined with programming training, and the help files. 🙂