+ Reply to Thread
Results 1 to 5 of 5

Complex Macro/Problem Approach

  1. #1
    Registered User
    Join Date
    07-28-2011
    Location
    AL, USA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Question Complex Macro/Problem Approach

    I have an Excel 2003 spreadsheet I paste into each day. I would like to streamline the work process in order to save time. The actual data that needs to be interacted with begins on row 82, and ends on a different row each day.

    In column A are links (individual records) that can be clicked and will bring up different web pages. In Column B are names. In Column D are different names, but occasionally the % symbol. In Column E are numbers (0 through 100).

    I need to create a formula(s) or macro(s) (I am thinking the latter) that will do the following:

    If the number in Column E is less than 100, access the link in Column A (Column A displays a number, but is hyperlinked so appears in blue font), search for two text strings "SSN" and "Comments:", and display the text between the end of the text search string and the next delimiter in Columns F (for "SSN") and G (for (Comments:")

    Once that is completed, then check column D for % symbols and display a prompt to the user: "Is Name from Column B located in Location A or Location B?" and overwrite the contents of Column H with Location A or Location B depending on the user's Selection.

    I know absolutely nothing of Macros, and have done all of my previous automating through the creative use of formulas.
    Last edited by lmorrison; 07-28-2011 at 07:01 PM. Reason: Moderator Suggestion

  2. #2
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Complex Macro Needed

    Hi, you are right when you say complex. Because of this, it would be best if you could upload a mock workbook with mock data (nothing personal or sensitive to others) as well as a before and after of what the code should be doing. This would make the our task much easier.

    Regards:

    Michael
    If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.

    ---Keep on Coding in the Free World---

  3. #3
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Complex Macro Needed

    Welcome to the forum.

    Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

    Thanks
    Entia non sunt multiplicanda sine necessitate

  4. #4
    Registered User
    Join Date
    07-28-2011
    Location
    AL, USA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Complex Macro/Problem Approach

    I have included a mockup spreadsheet.
    I am unable to include a mockup of the linked websites and have substituted a generic website instead.

    In viewing the source code for the linked websites, the requested data "SSN" and "Comments:" falls within <td> or table cells. Even if the process/macro/formula just displays the contents of the all the cells appearing in the source code, that's fine. I can use formulas to pull the required data.

    Maybe that'll make it easier. But truth be told, I feel like a little fish in a big sea.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    07-28-2011
    Location
    AL, USA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Complex Macro/Problem Approach

    Any thoughts or ideas from anyone?

+ Reply to Thread

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