How to fill in a cell based on the last bold cell of another column?

Hi all,

I would like to write a code that would fill in cells in column A by the last bold cell/or numerical cell (both would work) that is in column B (if we are in cell A10, the VBA code should only look at values between B1 and B10, and take the last numberical or bold cell from that range).

I attached a quick example of what I would like to do with the code

Many thanks for the help!

Alen

What do you mean by

if we are in cell A10

and

and take the last numberical or bold cell from that range

what do you want to do after the "take"?

Hi Jindon,

I have a sheet of 9k rows. Therefore, what I would like to do is to populate all the cells from A1 to A9000.
The way we fill the cells from A1 to A9000 will depend on what is in column B.

An example:

We are at the 20th row, what needs to be filled in A20 is based on what is filled in the range of B1-B20. If B20 is not a number (or a cell that contains a bolded content), it should take a look at B19, B18, B17, until it finds a numerical cell (or bolded cell). Then, when it found it, the code should fill in A20 with that value.

I hope that this is a bit better now?

Many thanks for your time Jindon, highly appreciated!

Alen

So, Activecell...
See if this is how you wanted.

Please Login or Register  to view this content.

Hi Jindon,

Thanks for the reply. The code you provided seems to work only when the activated cell is on the same row that the bolded cell in column B.
Would you know how to fix that?

Thanks!

The code will copy the last Numeric value in Col.B to Col.A.

If activecell is A22, it copies B16 to A16, the last numeric value within B1:B22, that was how I read your problem.

Hi Jindon,

If activecell is A22, it should copy B16 (the last numeric value) to A22 ... Is this possible to do? And of course repeat that process for the 9k rows.

Again, many thanks!

Then change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Great, this works perfectly!
What should I add to the code in that way, it runs from A1 to A9000?

I don't understand what you are trying to say.

A1:A9000 instead of Col.B? or you just want to restrict the code to run only when active cell is in somewhere in A1:A9000?

I have to apply that code that you created to all the cells in column A (until the 9000th row):

For A1: run the code in order to have the last numerical cell in column B (in this case it's B1 since B1 contains a number)
For A2: run the code in order to have the last numerical cell in column B (B1 will be shown in A2 since B2 does not contain a numerical cell)
...
Until A9000

If you do not understand what I mean, you could check the Excel I uploaded in the beginning, this will definitely help you see what I mean ..

Thanks!!

Not clear though.
It will not run when ActiveCell is not in A1:A9000.

Please Login or Register  to view this content.

Ahh, is this what you wanted?

Please Login or Register  to view this content.

Hi Jindon,

Thanks for giving me a lot of your time (this code works the same as the previous one). Maybe I was not that clear ...
I just wanted the code to repeat itself (the same code to loop from A1 to A9000). Now when I run the code I have the correct answer but just for the cell that was active, while I would like to have the results for all the cells in column A ...

I guess a loop function has to be inserted somewhere in the code right?

Thanks!

Yessss thanks!!! It works perfectly now! Great, many thanks for your time! will take time to understand the code!

OK, took time to understand what you are trying to do.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.