daksh1981
Forum Contributor

I am trying to figure out how to complete a simple flat file computer issue log. the columns are service tag no.,etc.i am trying to figure out how to make it to where if one computer has multiple issues, instead of inputting another row with all of the information, i can just simply have a drop down underneath the row, to input the date, description, etc, right underneath the original service tag no.
Example:
Service Tag No. Computer Name Date Description Resolution
XRWRST1 AS2 11/29/2010 no power battery replace
CM2VMG3 BL2 12/01/2010 no boot replace ram
XRWRST1 AS2 12/01/2010 no boot replace ram

Hello Daksh, I've done some pretty easy spreadsheets in the past, but don't know how to use Macros. I want to create an Excel invoice with a macro that generates the next invoice number automatically. So whenever I save an invoice and re-open the invoice spreadsheet again, the next invoice number automatically loads. At the moment, I'm manually adding the next number, but sometimes I forget to change it and this is a real problem if you don't realise until after you've printed subsequent invoices. I'm using Excel Mac 2008. Do you know anywhere that I can get a template with the macro already loaded? I've seen the formula for doing what I want to do, but have no idea how to apply it.

Hello Daksh,
Thank you so much for your help. What you gave me is exactly what I need, but I do not know how to apply it. Would you be kind to explain how please?
Best regards,
Ktran

I am just a learner. I want to equip my VBA skills to advance level.