Greetings.
This is likely a simple problem but I haven't found a solution yet (at least not one I understand) so I hope to harness the considerable power of your collective knowledge.
I have a worksheet with data arranged in one column (B). Each block of data (of which there can be a varying number) is 148 lines long and separated by the word 'Finished' plus a blank line. The ultimate goal is to select each block of data and transpose it as a new row in another workbook.
My problem is how to select each block of data without directly naming it? B1:B148, B151:B298,.... just won't do.
I hope I was clear enough. Obviously I have very little VBA experience so I'd appreciate any help you could offer. Thanks in advance.
-- Windows XP, Excel 2003. --
This is likely a simple problem but I haven't found a solution yet (at least not one I understand) so I hope to harness the considerable power of your collective knowledge.
I have a worksheet with data arranged in one column (B). Each block of data (of which there can be a varying number) is 148 lines long and separated by the word 'Finished' plus a blank line. The ultimate goal is to select each block of data and transpose it as a new row in another workbook.
My problem is how to select each block of data without directly naming it? B1:B148, B151:B298,.... just won't do.
I hope I was clear enough. Obviously I have very little VBA experience so I'd appreciate any help you could offer. Thanks in advance.
-- Windows XP, Excel 2003. --