Google spreadsheet Importrange - continuous formula Closed

Question

Hi,
I am finding out solution on how I can make the Importrange formula continuous on the google spreadsheet.  Currently, I am manually changing the cell reference whenever there are new property listed...
Spreadsheet B:
Address                Source1               
123 Main St          Trulia                    
235 Lucky Ave      ref - Jo Smith                            
888 Apex Dr         Zillow           
Using the Importrange and listing Sub-source when the Source1 is blank, I used this formula and it's perfect on Spreadsheet A.
=if(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1Bs6SbMkfAeETUifRRpieJPIyO4nskCwab6ZFtjdeoHs","PENDING 17!V14:V14")="", IMPORTRANGE("https://docs.google.com/spreadsheets/d/1Bs6SbMkfAeETUifRRpieJPIyO4nskCwab6ZFtjdeoHs","PENDING 17!U14:U14"), IMPORTRANGE("https://docs.google.com/spreadsheets/d/1Bs6SbMkfAeETUifRRpieJPIyO4nskCwab6ZFtjdeoHs","PENDING 17!V14:V14")
)
Spreadsheet A:
Address                Source1                Sub-source
123 Main St          Trulia                    
235 Lucky Ave                                   ref - Jo Smith
888 Apex Dr         Zillow           
My Question, how can I make the formula continuous whenever there are new properties added without manually changing the cell reference?
Thank you,
Jam

ac3mark · Answer

OH, you want an "easy" button? YOu logic would resmble this:
 With ActiveSheet
        LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row
    End With
\
And, it isn't a formula, but VBA code.
It's kind of fun to do the impossible! -Walter Elias Disney

Google spreadsheet Importrange - continuous formula

1 response

Similar discussions

Subscribe To Our Newsletter!