fill empty cells with calcualtion

[johncena]

hi, here i have attached sample sheet & pls check it. first sheet is my normal data & second sheet is my expected results. my request is column "K" has some empty cells. that empty cells i want to fill doing some calculation. as a my sample sheet K5 cell is 13.8 & k6 cell is empty. L5 cell is 7.5, so what want to do is that L5 cell value should copy to K5. now K5 cell is 7.5, then K5 before value is 13.8 need to (-) minus 7.5 & balance should add to empty K6.( should be 6.3).

as per my next example is K10 cell 712 & bellow 3 cells are empty. here also as K10,k11,k12 cell need to fill from L10,L11,L12 (k10=225,k11=225,k12=225) & last empty cell(k13) should be ,(K10 before value)712 -(225+225+225)=37.

I don't no this is possible or not. i need macro for this. pls help me. thanks in advance..

[aydeegee]

Hi johncena

You can do it by macro, of course, but it is not necessary.

Highlight K6 to end of data in column K

Ctrl+g = (goto)
Alt+s = (special)
k =(blanks)
<enter>

You have now highlighted all the blank cells

Type

Please Login or Register  to view this content.

then press Ctrl+enter

All the blank cells will be filled with the formula that you want.

If you really want it by macro - let me know

Regards
Alastair

[johncena]

Hi johncena

You can do it by macro, of course, but it is not necessary.

Highlight K6 to end of data in column K

Ctrl+g = (goto)
Alt+s = (special)
k =(blanks)
<enter>

You have now highlighted all the blank cells

Type

Please Login or Register  to view this content.

then press Ctrl+enter

All the blank cells will be filled with the formula that you want.

If you really want it by macro - let me know

Regards
Alastair

thanks u very much for your reply. actually filling starting from above the blank cell. pls check my sample sheet. other thing is i need macro because this is part of other macro result.. thanks u..

[johncena]

bump.........................

[aydeegee]

Hi johncena

It is considered bad practice (and unnecessary!) to copy the entire text of a reply.
It is also a little premature to bump after less than 3 hours!

actually filling starting from above the blank cell

this would happen if you had not correctly selected blank cell only (see instructions in #2)

I attach your file with a macro included that will fill in the blank cells. Let me know if it works for you.

Regards
Alastair

[johncena]

Hi johncena

I attach your file with a macro included that will fill in the blank cells. Let me know if it works for you.

Regards
Alastair

thanks a lot for your macro. actually i have found the answer & here it is..

Please Login or Register  to view this content.

[aydeegee]

Hi johncena

Ok. Glad you found a solution

Regards
Alastair