[aaddison]

Yeah....me too. I believe its because they aren't formatted the same. thanks for trying

[slurpee55]

Excel doesn't look at the formats in comparing, just the values. Well, if AJ wanders back, probably he can help. I would guess he is asleep right now, though.

[Aj_old]

I didn't get an answer which price should be the lowest, so I made it like this!

Let me know if you are looking for something like this!

[slurpee55]

Okay AJ, let me see if I am tracking your code .
I see where you compare the values to SpM and RpM (both equal to 99999999) on all sheets not named Master List.

When it looks at the first sheet it then resets, for instance, SpM to the new value using this:

If sh.Cells(r1, "D").Value < SpM Then SpM = sh.Cells(r1, "D").Value

and then looks at the next sheet and if it is smaller than the new value of SpM it takes that value?

Then it does the same for RpM...? Cool.

[Keebellah]

Hi aaddison,
I think that before you go too deep into all this, it will be necessary to state what is the starting point.
If the "master Workbook" is empty what doe you want to do, are alle the "child sheets" in one and the same folder? Is the layout identical? (Format can be checked on the fly) and what do you want to have is based upon?
I think using VBA and some programming time you can obtain a nice working sheet and if you even keep a log on a separate sheet in the Master Workbook.
Once you start it will probably develop into a serious project.
I don't mind giving it a shot but that the facts will have to be stated to know what to look for, the criteria, etc.

[slurpee55]

Hans, AJ has written some workable code with the assumption that it is all in the same workbook. Unfortunately, the OP doesn't seem to be responding to questions.

[Aj_old]

Originally Posted by slurpee55

Okay AJ, let me see if I am tracking your code .
I see where you compare the values to SpM and RpM (both equal to 99999999) on all sheets not named Master List.

When it looks at the first sheet it then resets, for instance, SpM to the new value using this:

If sh.Cells(r1, "D").Value < SpM Then SpM = sh.Cells(r1, "D").Value

and then looks at the next sheet and if it is smaller than the new value of SpM it takes that value?

Then it does the same for RpM...? Cool.

Yeah!

[slurpee55]

Slowly learning....

[Keebellah]

we're never too old to learn