macro to find text heading then select underlying data?

Hi, I don't expect a solution for this, but it would be great to know if it might be possible. Looking at the attached worksheet, would it be possible to search for a text heading (i.e. Group A) and then select all rows and columns underneath that heading until there is an empty cell?

The format of my actual data extract is just like this, where the text heading is listed, then dashes below, then data. The amount of rows will vary, that's why I hope to select all for each keyword until an empty row appears.

If it is possible to find and select that data, I then want to cut and past in a new worksheet tab.

thanks for any input!

Hi
.
You will have to save your file as an Excel Macro file.
.
Then you will have to add a module for putting code in.
.
Note: There are general modules and Class modules.
You want to add a General module in that the code below
is for a general module.
.
Based on your original Excel file I have made the assumption that all data
blocks begin with the word GROUP e.g. Group A , Group B etc.
.
If that assumption is NOT true then the code below will fail.
.
Please note the following about the code below:

* Alot of it will seem like gibberish. Just ignore most of it and look for a
subroutine called PUBLIC SUB MAIN. Once you have found it - put your
cursor in it and run it using the F8 key or the Shift F8 to by pass going into
lower sub routines.

* It is "more correct" to use local variables in a sub-routine but I not done this
and created properties for various counts and other thingies. They are being
used in place of local variables.

* I tested the code by (1) using what you had and (2) adding additional GROUPS
with various # of blank lines between them and the code seems to work,
.
BUT - the code assumes that the KEY WORD GROUP is **always** there
and **always** in the 1st column.

* This code is NOT elegant or the fastest way to do it - but its the way
I think. -g-
.
Just copy and paste the code below into the module I described above.
.
As in your example - I ASSUME data is in SHEET1 and you want to
write to SHEET2. (You can change this in the code if required)
.
HTH
regards
John

Please Login or Register  to view this content.

Hi
I woke up this morning and realized that what I posted is NOT what you wanted.
Very simply (if I am correct) you are simply trying to write the FINANCIAL DATA ONLY
to another worksheet.
Additionally, I am assuming that you WANT the column headings.
If these assumptions are correct - then here is the revised code.
HTH
regards
John

Please Login or Register  to view this content.

Thanks all for the feedback. I will try out some of these suggestions.

Thank you