Copying value from down to top cell in between value change

[Murali Nair]

Been following ur post and help from quite sometimes, was much helpfull in managing inventory and Production related matters.

Have a query. There is a way to copy the top cell to the bottom, ie Cntrol G and then selecting blank cell and selecting the value, and press control and pasting the same, but it copies the top value to down and changes accordingly, i would like to do from bottom to top

but how do i copy a value which is down and replicate it till the top, there are values in between

Sample sheet


Row Sum of Debits Sum of Credits diff

1 4,965.29 4,954.12

2 0.0 7,109.50

----------------------------------------------

3 4,965.29 12,063.62 -7,098.33

--------------------------------------------------

4 325.56 310.60

5 0.00 32.65

----------------------------------------------------

6 325.56 343.25 -17.69

Have a huge file like this, want to copy 6 row diff coloumn value -17.69 to the above 2 value ie 4, and 5 row in the diff coloumn and then it gets changes when 3rd Row value -7098.33 comes and then this value is copied to 1, and 2 row


Can anybody help me, as its a v.huge file and manually to do it is a tasking work.

 

[SirJB7]

Hi, Murali Nair!


I'd recommend you to read the three first green sticky topics at this forums main page. There you'll find general guidelines about how this site and community operates (introducing yourself, posting files, netiquette rules, and so on).


Among them you're prompted to perform searches within this site before posting, because maybe your question had been answered yet.


Feel free to play with different keywords so as to be led thru a wide variety of articles and posts, and if you don't find anything that solves your problem or guides you towards a solution, well, come back here, tell us what you've done, consider uploading a sample file as recommended, and somebody surely will read your post and help you.


And about your question...


Could you please upload the mentioned sample file? Please provide a manual example for one case indicating cells before and after the involved operation. It'd be useful for people who might be helping you.


Regards!

 

[Montrey]

And the Grammar decipher begins on the poster's request.

This is one of the worst I've seen. MY HEAD asplode.


@Murali Nair

Select the column, press F5-->special---> blanks--->ok

Then go to formula bar and put =cellabove then press Ctrl+Enter.

 

[Murali Nair]

Thanks for your reply in my eagerness to post, i missed out reading the etiquette, and guidelines.


Montrey Thanks for ur help and guidance, the steps what you have shown copyies the data of the top cell and it replicated below, i need the bottom cell data copied to the top cell.


Am attaching the link of the sample file which i have loaded in the dropbox. Forgive me if my English is not up to correct or if there are grammatical mistakes.


http://dl.dropbox.com/u/78489807/Bottom%20to%20top%20cell%20copy.xlsx


Thanks for ur help

 

[Montrey]

@murali


Just start at the bottom then. select the blanks using F5, then scroll down to the bottom of your data, and in the last selected cell. Put in the formula bar:


=cellbelow

Then just press Ctrl+enter

 

[SirJB7]

Hi, Murali Nair!

Nice exercise. Get back to you soon, I hope.

Regards!

 

[Murali Nair]

Thanks Montrey , its working thanks v.much to all for helping me out, SirJB7

 

[Montrey]

Glad it worked. Thanks for the feedback. Feel free to ask more questions in a new post if needed.

 

[SirJB7]

Hi, Murali Nair!


Sorry for the delay, but better later than never. Give a look at this file:

http://dl.dropbox.com/u/60558749/Copying%20value%20from%20down%20to%20top%20cell%20in%20between%20value%20change%20-%20Bottom%20to%20top%20cell%20copy%20%28for%20Murali%20Nair%20at%20chandoo.org%29.xlsx


I think I replicated exactly your column G with this formula:

=SI(ESBLANCO(F3);G4;F3) -----> in english: =IF(ISBLANK(F3),G4,F3)


I noticed that green values in F column appear to be the difference between D and E cells, but that is correct only for the three first greens (F5, F8, F11), for the following greens it should be zero or am I wrong?


Regards!


PS: BTW, don't care about your English, it's not the native language for all people here (neither mine), just provide elements to be understood and it'll be enough.