Hello,
Ive started learning VBA for about two weeks now. The reason I started is because Im trying to create an easy way of filling out invoices at the company I work.
Im 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 its 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.
Id 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 isnt 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
Bookmarks