In the days of Sinclair and Amstrad I could do For/Next Loops in my sleep. Unfortunately with the advent of the PC I never progressed beyond Basic and I find that at the age of 80 I don't pick things up so easily these days.



I am hoping that someone out there would kindly provide me with the full syntax I am looking for to do what I want to do.

I have a worksheet with several columns of info Column A is a date and Column be is a figure. Every so often Column B has a 0 value. What I am looking for is the syntax to step through the columns and select the 0 records and produce them as consecutive records either elsewhere on the sheet or on another sheet.

If this syntax is forthcoming could you also explain how/where this is entered in the spread sheet.

Thank you for reading.