Hi all
paid 3.50 usd to ozgrid
I have used the pay for hire many times and you are fantastic
I don’t know how easy or complicated this is so if 35 usd is not enough accept my apologies and if no one takes it up I will increase it.
I have a task that I wondered if you could do with a vba code
On attached spreadsheet there is 1.5 and 1.9 in the top left hand corner, A macro would need to constantly change these.
Firstly to 1 and 1.5 (this changes over 300k sets of data on previous sheet) so this takes about 5 seconds to update all the cells in the top grid with the new figures.
All The figures from the top grid need to be placed into the lower grid and the relevant to and from amount in the adjacent cell as shown in my example.
Then the macro needs to place 1.1 and 1.6 in the cells and when data appears if ANY amounts are higher than the amounts in the corresponding lower boxes then they need individually changing with the new relevant to and from amount in the adjacent cell.
The idea is that when the macro has finished after a few hours it will show me the highest outcomes of every individual square and the relevant to and from amounts adjacent
To start the difference will be 0.5 per time then 1 then 1.5 then keep adding 0.5 till we get to 10
Example
1.0 and 1.5 then 1.1 and 1.6, 1.2 and 1.7, 1.3 and 1.8 right up to 10 and 10.5
then we increase by 1 every time so
1.0 and 2.0 then 1.1 and 2.1 then 1.2 and 2.2 etc up to 10 and 11
then we increase by 1.5 every time so
1.0 and 2.5 then 1.1 and 2.6 then 1.2 and 2.7 etc up to 10 and 11.5
then we increase by 2.0 every time
etc etc
hope that makes sense
i cannot attach the original spreadsheet and also its over 400mb so huge.
I am not great with vba so would need a explanation when its done.
Many thanks in advance
ps if there is a better way that gets the same end result im happy to go with that.
Paul