LinkBack URL
About LinkBacks
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
It's even harder to understandOriginally Posted by bjcowen9000
Especially without seeing your workbook...
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...)
Why don't you just upload the workbook as requested.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks