Good day to all!
My apologies on forehand if this question has been asked / solved in the past, I've searched through the forum but couldn't find any suitable solution.
Hence my question below. I've attached a file. It has all days of the year in column B (restricted to only January in example file) and a unit price in cell E1.
There is a macro which is doing a VLOOKUP on date from another file and places the units in the example file (in the cells highlighted in yellow).
What I would like to have in the yellow cells, is not the number of units pulled from the other file, but the total amount (so the number of units pulled from the other file, multiplied by cell E1).
How do I write that into a macro / formula?
Any help is highly appreciated!!
Kind regards,
Peter
Bookmarks