Hello,
I’ve started learning VBA for about two weeks now. The reason I started is because I’m trying to create an easy way of filling out invoices at the company I work.
I’m curious if what I want is even possible. So,
at the store I work, a Cheese store, we use a form to fill out the weight of products restaurants order on a specific date
Something like

Product 01-01-2015 03-01-2015 08-01-2015 10-01-2015 11-01-2015
Cheese 1 0 2 1 3 0
Cheese 2 10 3 0 3 0
Cheese 3 0 7 6 3 10

I need to know if it’s possible to extract the data from this table and create a new row on a different worksheet where I can then use some standard VLOOKUP and HLOOKUP for the price to calculate the total.
I’d like it to look something like this:

Date Description Quantity Price
01-01-2015 Cheese 2 10 €€€€€
03-01-2015 Cheese 1 2 €€€€€
Cheese 2 3 €€€€€
Cheese 3 7 €€€€€
08-01-2015 Cheese 1 1 €€€€€
Cheese 3 6 €€€€€

So when a certain product isn’t ordered on a specific date, it skips that row for that date and checks the next cell.
Could this problem be solved through VBA or any other function within Excel

Kind Regards,
Finsent