Results 1 to 5 of 5

How to extract data into a new worksheet

This is a discussion on How to extract data into a new worksheet within the Excel Questions forums, part of the Question Forums category; Hello all I'm currently trying to figure out if something is possible. I'm doing some web analytics at the moment, ...

  1. #1
    Board Regular
    Join Date
    Mar 2009
    Posts
    62

    Default How to extract data into a new worksheet

    Hello all

    I'm currently trying to figure out if something is possible.

    I'm doing some web analytics at the moment, and to reduce the amount of manual exports I have to do from our package I was wondering if the following was possible.

    I want to extract some raw unsorted data into a worksheet.

    The next part is where I'm unsure. I want to be able to use some regular expressions to extract data and auto populate a new worksheet based on that criteria. I already know the expressions to use but really not sure how to do this of if this sort of task is possible

    Thanks in advance

  2. #2
    Board Regular
    Join Date
    Jan 2009
    Location
    Spain
    Posts
    983

    Default Re: How to extract data into a new worksheet

    Hi,

    What you want is very common. The VBA code to do it depends on the structure of the raw data, and how you want the the new worksheet formated.

    Can you provide a sample of the raw data, and an example of how you want the finished sheet to look

    Regards

    ColinKJ

  3. #3
    Board Regular
    Join Date
    Mar 2009
    Posts
    62

    Default Re: How to extract data into a new worksheet

    Hello ColinKJ

    Thank you for getting back to me,

    Im really struggling to get the files into this message board, can i be a complete novice and also ask for a hand doing this.

    Cheers

    John

  4. #4
    Board Regular
    Join Date
    Jan 2009
    Location
    Spain
    Posts
    983

    Default Re: How to extract data into a new worksheet

    John,

    I've sent you a private message with my email address.

    You could send the example

    ColinKJ

  5. #5
    Board Regular
    Join Date
    Mar 2009
    Posts
    62

    Default Re: How to extract data into a new worksheet

    Hello ColinKJ

    I have sent you a email to your address,

    Thank you so much for any help you could give

    cheers

    John

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com