Finding specific cells adjacent value in formula

[eriocreese20]

Hello,

I am making a macro to find the percentage value of a larger number. So for example I have a value in cell C39. In the D column I want to take the value of C2, divided by $C$39, and display it in D2. I would drag that down all the way down to display all the percentages that add up to 100%.

This part is easy, the problem is that the amount of rows that can populate the sheet can vary so I can't just select $C$39. I would imagine I need to make the equation where I find the word "Total" in B39, then select the cell to the right of it C39 as my value to divide against.

Not sure if that made sense, is this feasable? I'm trying to make this sheet scalable so it works no matter how many rows there are.

[AliGW]

You’ve posted in the formula section and 3verything except the word macro suggests you’re using a formula. Which is it, please?

[eriocreese20]

I wasn't sure which section to put it in. I wasn't aware of any formula where I could add in a conditional statement like what I am describing which is why I was asking. Should a moderator move this to the macro/VBA section?

[Gregb11]

I think you can do that with a formula. Please read the yellow banner at the top of the page and attach a sample file.

[eriocreese20]

I can't attach the specific file due to company policy. After researching, I believe I need to do something with the range offset coding. This probably should be moved to the VBA forum. Anyway this is what I currently have.

Please Login or Register  to view this content.

The code selects B1-C1 range. I then do ctrl+shift + down to select everything in that column. What I then want to do is offset that selection by 1 and select everything but that last row. In this code it selects up to B32:C32 but i am trying to have it just offset, not have specific cells. I then sort those cells by largest to smallest. The very last cell is the "Total" of everything above it so that's why I want to offset everything

Does this make sense?