ranges

[twinytwo]

very easy one here... i must apologise in advance.

i want the values in b to equal those in d only if d is blank, as part of a macro


Also can someone tell me how to add buttons

[Steffen Thomsen]

This assumes its sheet1 and your data doesnt have headers

Please Login or Register  to view this content.

[twinytwo]

This assumes its sheet1 and your data doesnt have headers

Please Login or Register  to view this content.

i changed the sheet to 1 and got rid of my headers and this dosent work.

What im trying to do is create a share sheet. So in A i have the share name and in B i have the price. These are copied in from another sheet.

In C i have the number of shares. In D i want it to equal the share price in B, assuming that the corresponding D cell is blank,

[Steffen Thomsen]

Then upload a dummy workbook with similar data and a sheet with the supposed outcome, then it's easier to help!