Excel programming

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
Back
Top