Stop Query from refreshing empty cells

Hi All,


I am a relative newbie to the Excel universe. Coming from Architecture I have had very little need until now where we are working on a monster hospital. Needless to a say a whole new world has been opened.

My dilemma:

I have linked a txt file that is a REVIT(3D modelling program) export via query into my Excel document.

Some of the cells are blank and I cannot change them in the REVIT because of the parameters used in the Schedule I am exporting.
I was hoping to manually input these fields in the Excel document which is all good and fine until I refresh and the Query at it re-imports the blank cells again.


Is there any way of forcing the Query to not import any cells that are blank, therefore not affecting the manual input information?

Thanks

Hi dflak,

I have attached the txt export from Revit and a a small piece of the sample schedule.

BEFORE is how the txt file queries to the Excel with out any changes in the excel. This shows the blank cells which I wish to manually override.
AFTER includes the manual input information that I wish to remain should I need to refresh the Query from the txt file.

As I mentioned previously the txt file is an export from our architectural program that we are using so I cannot manually adjust any of the contents here.

Thanks

Thanks dflak,


The Door Type column is unique so this solution will work.


I was really hoping to keep things simple as this schedule will ultimately be delivered to the client and if I build in too much complexity it could cause issues when they start working with it, which leads me to another question. Am I able to purge all background operations and hidden columns/rows before sending it off?


Excuse my ignorance but what exactly is vba?


The import is from an architectural program called Revit, one has the ability to schedule in the program however nothing close to the power of Excel, it is cumbersome and slow hence the transfer to Excel. The connection is not bidirectional, so it is a straight export to a txt file. If there are changes to door schedule, I just re save over the txt and it updates.


Regards

Hi dflak,


I have implemented your formula and it works perfectly.

As is the case I suppose with a lot of these things, one needs to be open to doing things slightly differently than one originally envisaged, as long as the end result is achieved.


Thanks a lot for this.