Use worksheetfunctions in macro or alternative solution

Hi,

I'm looking for some help with the following problem:

I've included an excel file to make it more easy to understand.
The sheet is divided in three sections. The first two (Protime and DataTouch) are the data that need to be compared in the third section (DataTouch minimum and maximum values per day). At this moment, I use regular formulas of excel to fill in the third section.

I would like to create a macro that fills in the third section without me constantly filling in the formula's and dragging them in all the cells. This would be handy as I will need to do this process many, many, many times:p All the worksheets will have the same layout, so I guess this makes it more easy. I tried now for several days, but haven't succeeded in finding a good solution, let alone find one on the internet.

All help is welcome!!

Do you mean something like this?

Please Login or Register  to view this content.

Dear WasWodge,

Thanks for the fast reply! Your code is already relieving me of the workload:p At the moment, I will use this to speed up my analysis that is required.

However, what I'm looking for is a bit more complicated. Instead of typing the formulas in the first row (in this case: in M4,N4,O4,P4 and Q4) and than use your macro to expand this to the other cells, I would like to create a macro that also creates these formulas.

In other words: The goal would be that by activating the macro, the formulas are created and the cells in row M,N,O,P and Q are filled in. This would speed up my work even more, as I would not need to type in the min(if)-max(if)-abs formulas.

Regards

I will post something tonight if no-one steps in as I am on my phone at work

Try this

Please Login or Register  to view this content.