Crosswords4 mins ago
Microsoft Excel Macro/Formula/Pivot Table??
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!
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!
Answers
Only 1 answer
Best Answer
No best answer has yet been selected by jobby. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.Only 1 answer
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.