How can I copy the cell F36 to Cells in range?
I have a loop with a lot going on. After calculations, I want to copy cell F36 to cell F15,then add 5 to cell A1, then copy F36 to F16 etc
Any help?
How can I copy the cell F36 to Cells in range?
I have a loop with a lot going on. After calculations, I want to copy cell F36 to cell F15,then add 5 to cell A1, then copy F36 to F16 etc
Any help?
Not sure how to help with "etc"...Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Any ideas why when I do goal seek by setting cell to 0 individually, cell gets set to 0. When I loop, it gets set to a number higher than 0 for different itereations.
Please Login or Register to view this content.
What's the formula in C31?
What are you trying to achieve?
It is hard to explain. I am trying to minimize differences between cells by changing a cell that they are dependent on. It seems like the accuracy of goal seek decreases as loop continues
Do you see a reason why the goal seeker only fully minimizes the first iteration and not the ones after?
Please Login or Register to view this content.
What's the formula in C31?
(Feel like we're going round in circles, here...)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks