VBA to EXTRACT & LOOP

[shahzeb123]

Guys I am Back !

I have tried CHATGPT to write the code but it is only stupid code that does not work.

Now, my query is i need a code that needs to go to cell A31 then find "F57A" then find BKCH when it finds this then start extracting from BKCH till 11 digits only.

Then skip to A68 and do the same thing and paste the data in column L

Meaning it needs to extract data from A31 then skip 37 rows and do the same thing then again again till there is no data

PLEASE HELP

 

[shahzeb123]

Hi
need one more help in the same query

From the same field i need to extract the highlighted points into column M and N

it is not definate that how much length will be there on every filed but it will be written in line

 

[Joe4]

Hi
need one more help in the same query

From the same field i need to extract the highlighted points into column M and N

it is not definate that how much length will be there on every filed but it will be written in line


View attachment 86482

It may be the same data set you are working with, but it is a new question (very different from the first).
As such, it would be better to post the question to a new thread, so it appears as a new unanswered question, and you will get more looks (since it will show up on the "Unanswered threads" list), and a greater chance of getting an answer.

So please post this question to a new thread.