Method or VBA to get min reading for gridded data

[justin_n84]

Hi,

I have spreadsheets that have multiple readings in. The data can be 500 readings across (columns) by 500 down (rows). Basically a large square of thickness readings. Sometimes it can be even larger. I want to be able to get a minimum reading quickly from say every 25x25 grid of data and then these reading placed simultaneously in to a new sheet so that I now have a grid of minimum readings. At the moment the only way I can do this is manually and it takes rather a long time. Any help would be greatly appreciated.

 

[alansidman]

I want to be able to get a minimum reading

What does this entail. I think that more information is necessary to understand the issue better. Can you provide some examples of what is to happen.

 

[justin_n84]

I could give an example if I was able to attach

 

[justin_n84]

Image attached

 

[justin_n84]

[/URL][/IMG]

 

[justin_n84]

[/URL][/IMG]

 

[justin_n84]

[/URL][/IMG]

 

[justin_n84]

1st image is data as a whole.
2nd image is how I have had to grid manually to get min reding for every 20x20 in this example
3rd image is fanal grid of minimum readings