First, I dont have any coding background, Maybe my question is very stupid. I am working on a project and need a coding. What I am trying to do is
Select the sheets, and using while loop to go through all the rows
if find the "API" cell in column A, and start counting till to the first empty row, then copy these rows to a new sheet
after this one, keep going in the loop, and find the next 'API', and start the new counter again. rest are same as the pervious step.
Waiting online! Thanks a lot!