Thread
:
Price Comparison Macro - This Is For An Excel MVP
View Single Post
#
2
Don Guillett
Posts: n/a
Gosh, if only I were an MVP, I could tell you.
--
Don Guillett
SalesAid Software
"Mr. Smiley" wrote in message
...
I have a workbook with four sheets in it. On each of the first three
sheets,
located in cells F33:F52 and N33:N52 are unit prices. The fourth sheet is
blank. I would like to know if (and how) a macro can be created that
would
look at the unit price in cell F33 of Sheet 1, then compare it to the unit
price in F33 of Sheet 2 and F33 of Sheet three, decide which is the
lowest,
and place it in the cell F33 of sheet 4. Then, look at the next cell
(F34)
and do the same thing, etc. I am an absolute novie with VBA, but really
need
this. It would make my life so much easier. Thanks.
Reply With Quote