Enter formula if values present

[ali32j]

Hi All
I have a spreadsheet with list of contacts, i m looking to make it easier for clients to update spreadsheet, so after they paste contacts in i would like to add a command button that when pressed will add a formula in cell if the adjacent cell has a value, going down the spreadsheet until it reaches the last record at which point it stops

Can anyone help?

Thanks

Ali

 

[xlbo]

Yup - especially if you post in the VBA forum: Forum707

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question