Hi I'm trying to create a macro to help with my data.
I have a column "Rankw" on sheet "Data" that has values ranging from -1711 to 1815 ish.
On another sheet "Workings" i want to populate cells Min (B3) and Max (B4) with the values from column "Rankw". By changing the values of Min and Max i change the range of values my sumif formula uses to give me a value in H4 on "Workings"
I'd like to copy the value of H4 for each instance of changing Min and Max to a sheet called "Data2"
So my results would be something like:
Min -1711 Max 1815 H4= 0
Min -1711 Max 1669 H4= 3
Min -1711 Max 1618 H4= 3
.
.
.
.
.
.
Min 1815 Max 1618 H4= 1
Min 1815 Max 1669 H4= 1
Min 1815 Max 1815 H4= 2
For ease so far i have started by creating a grid with the values from column "Rankw" from -1711 to 1815 in column A on "Data2" and values -1711 to 1815 in row 1.
I've tried using solver using a loop that runs through the first column going down row by row and pasting the value of H4 into the cells B2:B806, but how do i get the loop to go onto the next column and starting again in row 2, then repeating until upto column ADZ (805 columns in total)?
Bookmarks