How to extract data into a new worksheet

[Confidentjohn]

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

 

[ColinKJ]

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

 

[Confidentjohn]

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

 

[ColinKJ]

John,

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

You could send the example

ColinKJ

 

[Confidentjohn]

Hello ColinKJ

I have sent you a email to your address,

Thank you so much for any help you could give

cheers

John