• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Problem if cell is empty then not till last row paste formula

A

Abhijeet

Active Member
Hi

I have want till last row paste formula i have use this formula to one strock the paste formula but is cell is empty in column A then not paste formula till last row =OFFSET(Sheet1!$A$2,,,COUNTA(Sheet1!$A:$A)-1,3)

can you please tell me how to do this
 

Attachments

  • Hyperlink.xlsm
    14.1 KB · Views: 2
@Abhijeet
Term: Last Row ... do You mean row #9?
Could You name where/which cell do You want that formula?
You could fill yellow color it/those.
If I just now do something ...
I would paste that formula from [B9] to right as far as possible.
Not good idea!
Please, one sentence per line.
 
You must log in or register to reply here.
Back
Top