I am in need of help. I have WB1 which contains a listing of data
2 15.00 30.23
3 14.37 32.00
4 38.00 67.00
I need to open WB2 and plug the data from WB1 into WB2 - the data needs to plug into the same cells on WB2 every time (so WB1 will need to loop, but go to the same place on WB2 every line).
WB1 A goes to WB2 F11
WB1 B goes to WB2 F6
Once A and B are plugged in, another cell on WB2 creates a percentage value (I have those formulas figured out). The result is on WB2 F26 . In the case of row 2 the value is 6%.
My final step is to get the percentage value from WB2 cell F26 back to WB1 column C as a value.
A B C
2 15.00 30.23 6%
3 14.37 32.00 7%
4 38.00 67.00 10%
I was able to accomplish what I wanted by recording a macro as I did the operation - however that is incredibly lengthy as each row is about 20 lines of copy paste code and since I might easily have 300 rows, that is not feasible. I need the macro to loop until WB1 A is blank.
Any help would be appreciated and if clarification is needed, let me know.