Marco / VBA needed to extract data from one sheet to another table

[lmszs]

Hi All,

I am very very new to Macro's and VBA and would really appreciate some help - I am not sure where to start

I have some data which is copied from our system in the format below, I then need to add only parts of this information to an existing spreadsheet on the network.

This is the information (there could be lots of these entries, but all need to be added to the spreadsheet)

Device ooo.1111111111111111111111555666663333 performance has deteriorated.
increased from average value of 2041 days to 44589 days.
warning
2/6/2014 2:38:18 AM
aaa-ab-cde00.efghijklmno.ddd.kk

Device ooo.11111111111111111111115556666633356kk performance has deteriorated.
increased from average value of 2041 days to 44589 days.
warning
2/6/2014 2:38:18 AM
*aaa-ab-cde00.efghijklmno.ddd.kk*

I then need part of the above data to be transferred to in Excel in the following column headers (see attachment for layout)

Date Time Host Device Low Value High Value

Does anybody know what is the quickest and easiest way of updating this spreadsheet..... I have to update the spreadsheet every morning and it is very time consuming

Let me know if you need anymore information....Your help would be really appreciated

Many thanks
Lorraine

[JOHN H. DAVIS]

Can you attach a sample which has the data as it appears first on the spreadsheet when downloaded. Your current layout I think is how you would like it too appear after you run the macro.

[lmszs]

Hi John,

Thanks for your reply.... unfortunately this is how the data is copied out of the system exactly I normally just paste this into Excel in another sheet eg sheet 2 and then I cut and paste the data I need to where I need the data in the format shown on the attached spreadsheet .... in the end I only need the data that is in the attached spreadsheet format I then delete 'sheet 2' as I no longer need the original information.

Device ooo.1111111111111111111111555666663333 performance has deteriorated.
increased from average value of 2041 days to 44589 days.
warning
2/6/2014 2:38:18 AM
aaa-ab-cde00.efghijklmno.ddd.kk

Device ooo.11111111111111111111115556666633356kk performance has deteriorated.
increased from average value of 2041 days to 44589 days.
warning
2/6/2014 2:38:18 AM
aaa-ab-cde00.efghijklmno.ddd.kk

Does that make sense?

[JOHN H. DAVIS]

I'm trying too establish if this is 5 rows or 1 cell when you paste it.

Device ooo.1111111111111111111111555666663333 performance has deteriorated.
increased from average value of 2041 days to 44589 days.
warning
2/6/2014 2:38:18 AM
aaa-ab-cde00.efghijklmno.ddd.kk

[lmszs]

Ahhh now I understand, sorry... it pastes into 5 rows in 1 column

[JOHN H. DAVIS]

If you pasted into Sheets("Sheet1") the results will go to Sheets("Sheet2") with this attempt.

Please Login or Register  to view this content.

There are much more elegant ways to achieve this and it doesn't handle varying device numbers well.