ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   looping thru range extracting data based on character (https://www.excelbanter.com/excel-programming/374921-looping-thru-range-extracting-data-based-character.html)

gtslabs[_2_]

looping thru range extracting data based on character
 
I have data in columns A and B.
They are separated into groups with a text heading starting with an
open bracket [
I want to loop thru the rows and copy the data starting with each
bracket until I hit the next bracket and put them into a series of
columns.
So the first set would go in a different sheet in A and B, the next Set
would go in C and D.
I am able to find the brackets but not sure what to do next.

This is what I have so far just to find each bracket.
Sub getdata()
For I = 22 To 6000 ' find end of data sets
If Left(Cells(I, 1), 1) = "[" Then StartRow = I

Next
End Sub

Any help would be appreciated.



All times are GMT +1. The time now is 11:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com