I’ve inherited a spreadsheet and I don’t know how to make it do what I want to do, my excel skills pretty much end at filling in cells (not that bad but close).
One sheet of the workbook is almost like a DB, it has much customer information. Another sheet is for creating invoices, if one cell on the invoice sheet is filled with the customer number (from one column) from the first sheet, the invoice fills in all the needed information.
What I need to learn, is how to write a macro that will automatically change the customer number in the invoice page, and then print the invoice. Is this even possible? I assume that it is, but I don’t know for sure.
A shiny new donkey for whoever can help me…