Ignoring rows with a blank cell in one column

Hello all,

this is my first time posting on the forum, but I have been helped many times in the past from all your posts. Thank you in advance for your future help!

I download a .csv file every week that has thousands of records (rows) with 15 columns of data. I take this data and paste it into a spreadsheet that does many various calculations on other pages within the spreadsheet. I'm trying to make the process "idiot-proof" (pardon the expression) so that once the process of pasting the data is complete, the report is complete.

I have all my calculations complete, and they work just fine (including a simple macro), but i have one more thing I'd like to do.

Some of the records (rows) have a blank in one of the columns, and some others have 99999 in a different column. Currently, I filter these rows out and delete them before I copy them over. I want anyone to be able to download this .csv and copy the data into an "import page" but have the sheet reject (delete) any rows that have that blank or the 99999 in the other column and allow the pasting of all other records. My question is, should I use data validation or some other method to automatically delete the row before it is pasted into the sheet?

Thank you again!
Tom

if is simpler to have a macro delete the rows that you don't need

Try this.

Please Login or Register  to view this content.

If you are pasting data into excel, there is no regular formula that will delete rows - based on anything. Could you modify your formulas to exclude the blanks and the 9999?

What formulas are you using?

Not sure about the sumsq(), but you could add more arguments to the SP to exclude the blanks and 9'?
Another option may be to add a helper to test for blanks and 9's, and pull in all but those - then base the calcs on that

Happy to help and thanks for the feedback