Results 1 to 6 of 6

macro to find text heading then select underlying data?

Threaded View

  1. #1
    Registered User
    Join Date
    12-13-2006
    Posts
    27

    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!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1