Microsoft Excel Macro/Formula/Pivot Table??

jobby | 10:59 Mon 21st Jun 2010 | Computers

1 Answers

Hello,

I am trying to write a Macro or Formula in Excel and I can't remember what I am doing! It is on Excel 2007 on Vista.

It has been a while but I am sure I covered this at school.

I am trying to make an invoice easier and quicker to do. Currently all product codes and descriptions are entered manually.
I was trying to come up with a way of entering the product code and then the description coming up automatically. Is this possible?
I have all of the codes and descriptions on a spreadsheet and was going to make the invoice a spreadsheet as well.

Is it also possible for me to put an automatic date function in a cell where it would read the date the sheet was created/amended?

Thanks in advance for any input!