Hello Group!

New here, just posted an introduction called "Not-so-expert Excel Expert". Hope you read it and get to know me.

Now, I'm here to ask a question and find a solution to a problem I'm having.

I am currently working on an Access database for a real estate client. He daily downloads a text file then opens it in Excel. No problem, except that I have to re-organize fields and data in order for it to match the Access table fields. Again, no big problem there. I wrote a macro that re-organizes the fields.

I set up a 2nd worksheet to concatenate addresses so that duplicates can be found and deleted in Access. That's because the data may appear in any of these forms and cause duplicates:
123 Main Street
123 Main St.
123 Main ST

ETC, you get the picture. So, sheet two I pull over the street address and city from the original data (sheet 1), then have extensive formulas that will eventually (and do) that converts all of that to standards.

Next, I do a 3rd sheet (sheet 3) where I pull over ALL the information from the original data (sheet 1) EXCEPT Street Address and City. I pull those over from the Calculations sheet (sheet 2).

That all works wonderfully!!!! However, if today's data pulled in is say, 56 rows and is replaced tomorrow with data that is only, say, 26 rows, then anything beyond Row 26 will show a formula error. There's my problem. Is there a way to hide those errors (which really aren't errors, there are just no matching rows on other sheets for the data), when there is less data? There is no way of knowing how much data will be downloaded daily. It all depends on what's available on the download site. I plan on making my formulas, etc, work for 100 rows of data. Hopefully that will be enough, but again, when data is less than that I want to hide the error messages beyond the data rows.

Anybody ever run across this or have any ideas?

Thanks in advance for help! Lucy