Excel programming

[Guest]

I have developed a multi tabbed workkbook. The master sheet sends info to the
other tabs. In the Price cells the destination sheet recieves the value from
a cell on the master sheet which isn,t always the price I want to use. If I
make another
column on the master sheet for a manually entered total, Is it possible to
make that new total override the one in the price column on the destination
sheet without deleting the linking between the master & destination?

 

[Carl Hartness]

By send, do you mean with formulas or with code?

formulas, try =if(Master!B1="",Master!A1,Master!B1)

code, try
With Sheets("Master")

Sheets("Destination").Range("A1")=IIF(.Range("B1")="",.Range("A1"),.Range("A1"))

Carl

End With