push rather than pull cell data.

[BINZA@]

Is it possible with excel to push data from cells to another sheet in same
excel file rather than pull it from the cells you want populated each time
cell data is changed.

Thanks for any help with this.

 

[Dave Peterson]

Maybe you could use a macro.

Is it possible with excel to push data from cells to another sheet in same
excel file rather than pull it from the cells you want populated each time
cell data is changed.

Thanks for any help with this.

 

[Don Guillett]

sheets("sourcesht").range("a2:a22").copy sheets("destsht").range("a2")

or (note ranges must be the same size)

sheets("destsht").range("a2:a22").value= _
sheets("sourcesht").range("a4:a24").value

 

[Gord Dibben]

Maybe linking cells would work for you.

Enter =Sheet1!A1 in any cell on Sheet2 and that cell will update when Sheet1
A1 is changed.


Gord Dibben MS Excel MVP