save only relevant rows to a CSV 1

[mart1000]

I have an Excel workbook, te first sheet contains data I enter plus lookup and formula etc. I save this as a CSV and import to a system - all good. The issue is my formula and lookups go down to row 250 and my number of rows I enter data in is variable. I ONLY want to save to CSV the "full" rows. Is there a way to do do

 

[combo]

If you use structured table instead, formulas can refer to whole table columns (Formulas have to be rewritten to use different syntax and references). In this case you need only to monitor table size.

combo

 

[mart1000]

sorry, i dont understand your reply

 

[mart1000]

ah ok think i understand what you mean now, yes I jave reference the formula now and works fine

cheers

 

[Andrzejek]

mart1000, it is customary here on TT to award a STAR for a helpful post.

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson