• 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.

Need a formula to jump to next row if condition not met

S

s_psych

New Member
Hi, in the attached sample I have 4 sheets. The main data sheet and three bloodline sheets. Formulas have been added (VLOOKUP, IFERROR, IF) to separate the date on their respective sheets. However, what I want to do is have the data move up if the row above is blank. Can anyone help me with this?
 

Attachments

  • Sample.xlsx
    23.2 KB · Views: 3
Hi, thanks the reply airaldom, the formula had "nombrearchivo", which I replaced with "filetype". It seemed to work at first, however, when each sheet is refreshed, it changes the previous sheet to the data of the next. Why doesn't the data remain the same in the previous sheet?
 
You must log in or register to reply here.
Back
Top