Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel programming
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? -- Ralphy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel programming
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 On May 14, 9:28 pm, Muddled wrote: 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? -- Ralphy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Or Excel Programming | Excel Worksheet Functions | |||
excel programming | Charts and Charting in Excel | |||
Excel Programming | Excel Programming | |||
Programming in .Net for Excel | Excel Programming | |||
Excel Programming | Excel Programming |