Do Until loop or equivalent required

**Nonboff** · 04-09-2009, 03:48 PM

Hi

I need a loop function (i guess a do while or do until code) so whenever the word 'Non-Current' appears in colum A enter a 1 in colum E until the word 'Total Non-C' is reached at which point the loop must end.
Such as:
A B C D E
NON-CURRENT 6 4 5 1*
ABSA 4 5 2 1*
BARCLAYS 3 2 8 1*
NED 0 8 6 1*
TOTAL NON-C 4 6 7 0

Anyone got any ideas?

Thanks

**foxguy** · 04-09-2009, 04:41 PM

Please Login or Register  to view this content.

**stanleydgromjr** · 04-09-2009, 04:46 PM

Nonboff,

See the attached workbook "Update Data and Do Loop or equivalent required - Nonboff - SDG.xls".

Run the "UpdateData" macro.

Have a great day,
Stan

**Nonboff** · 04-11-2009, 05:54 AM

Thanks Stan and Foxguy...

Stan - I managed to get your method working. Only problem is that my data is not consistent. Sometimes the info i need is under current acc, sometimes non current, sometimes total local fixed interest. So i am not going to be able to use this method

Foxguy, your method i got a syntax error at this point:
a() = range(A:A).value

To get round this prob, i think what i will do is create a data table to find my accounts and then using an if function add a 1 in column E. I can handle this prob from here....

Thanks for all the help!!