G
Guest
I'm trying to create an an invoice/receipt worksheet, so that when I input a
number in a cell, the adjacent cells automatically fill using predefined
information.
For example:
If i input 1234(item no) into cell A1, I want a description to appear in
cell B1 and a Price in C1.
If anyone knows how to do this, please could you explain in Laymens terms as
Im new to all this.
Many thanks and any help is appreciated.
number in a cell, the adjacent cells automatically fill using predefined
information.
For example:
If i input 1234(item no) into cell A1, I want a description to appear in
cell B1 and a Price in C1.
If anyone knows how to do this, please could you explain in Laymens terms as
Im new to all this.
Many thanks and any help is appreciated.