Hi all,
I am new to this forum and would love some help.
I have a spreadsheet from work I have to fill in loads of data, some cells could be made easier as once I fill in the a column, it means I waould have to fill in a certain word in the c column.
My headings are
<tbody>
</tbody> So for eg if company was Zerox I would automatically need "fax" in column c......... if Microsoft was in column a I would need computing in column c etc etc etc
Is there a formula I could use for this?
I have tried lost of ideas from web sites but cannot find one to do this.
Thanks all in advance for any help!
David
I am new to this forum and would love some help.
I have a spreadsheet from work I have to fill in loads of data, some cells could be made easier as once I fill in the a column, it means I waould have to fill in a certain word in the c column.
My headings are
Company | Home | Discipline | Period | Invoice No. | Amount | Capex / PO | Column1 |
<tbody>
</tbody>
Is there a formula I could use for this?
I have tried lost of ideas from web sites but cannot find one to do this.
Thanks all in advance for any help!
David