Thanks Narayan, I really have no idea how to use VBA but I'll attempt to be clearer in my explanation... no worries if you don't have a solution as I'm pretty sure it's my question asking that is the problem here! :)
I have a balanced equation with three input value and three output values. I...
I have a nitrogen mass balance (ins-outs=losses). I want to create a spreadsheet that will show the % error of the loss value when I change the one variable.
for example see inputs and outputs below:
a b c
1 "in values" "out values"
2 1 2
3 2...
Thank you SirJB7!
I had searched for the solution already but could only get it for rectangular ranges. Thanks again, this worked out perfectly and cut my workload immensely!
I am trying to transpose 100 years of daily data into a single column.
I have rows and columns of daily data I know you can transpose data row by row. I also saw a previous thread to transpose multiple rows into one column...