SUMMARY: Need to Find Key Word in Col A, Select Content, Paste Consecutively on Newly Added Sheet to build a table of content that should be grouped together in one table.
Need to be able to search through Col A of an active sheet (we'll say Sheet1 is active), locate exact word "DOC" in this case.
The 'hit' is located on A15. I need it to select that row (15)
and all rows beneath it -- up until it encounters a cell in COL A that begins with the all caps word "TABLE".
Let's say it selected rows 15:21 (whatever content exists in those rows should get copied)
The selected/copied range should get pasted on a newly added/empty sheet starting on row 2 (A2).
So at this point, on the new sheet, A2:A8 rows are holding the copied-over data.
The code should go back to the original active sheet (Sheet1) and continue looking for the next 'hit'
and repeat the process..
Let's say the next hit is on A53. It will start selecting rows 53 down to row 59 until it encounters the word "TABLE" in column A again...
Row 60 (A60 has the all caps word "TABLE") so it stops the select/copy just before that row and paste this 2nd selection over to Sheet2 immediately below the content it pasted previously. (and continues to paste down Sheet2 until all hits of chunks of content have built a new table of 'like' content.
*Example file is attached