Recent content by tourcd

Unfortunately I'm working with a very large dataset so no room for additional columns.

Sorry I did say "This has to be done without altering the raw data or adding additional columns etc." Done some more Googlin' but not having much luck.

Hi, I have an Excel sheet with two columns, DATETIME and BYTES. I'd like to chart this but alter the Y-axis scale to show the values in MB or GB. This has to be done without altering the raw data or adding additional columns etc. So an example row is: 05/05/2013 00:00 742436864 So in the...

Thanks SkipVought, could you post/send the full code?

The To: information extracted by the code in the linked thread above does not always return a full email address, sometimes it only contains a name. For example I'd expect to see "email@domain.com" in the To: column and I get "Jo Blogs" instead. However if you open up the full message header...

Hi, I need to extract information contained within the message header (or "Internet Header") in Outlook 2010. I'd like to pull out the To:, Subject: and Date: information from each email in my inbox and put it in to Excel. The following post thread707-1253839 has almost got me there...

Hi, Is there any way of finding out which version of the firmware maintenance CD (now rebadged "HP Smart Update Firmware DVD") I have installed on my server? I've taken over a box from someone who has left the company and need to understand which CD/DVD he used to update it. I know the CD is...

I have a PC with 2 partitions, XP is installed on the first, nothing on the second. I want to put WinPE on the second partition and be able to boot between the two. I understand I'll have to replace the XP boot mechanism with the Vista Bootloader which comes with the version of WinPE I'm using...

SkipVought, I've found the problem, it was a typo on my part. Thanks everyone for all your input, problem solved! :)

Thanks SkipVought, your solution looks very tidy but I experience a problem when running it. I get a "Run-time error '5': Invalid procedure call or argument" against this line... Set rFound = Cells.FindPrevious(rFound) Can you tell me why this is happening?

Thanks for your input. Maybe I didn't explain what I'm after clearly, let me give you an example. This is what I'm starting with... Year Value1 2008 1 Year Value1 2008 2 Year Value1 2008 3 Year Value2 2008 1 Year Value2 2008 2 Year Value2 2008 3 I'd like to end up with... Year Value1 2008 1...

Hi, I've got the following macro which runs through my spreadsheet looking for the word 'Heading' in column A. It deletes any row which contains the word 'Heading', great. However I would like it to keep the first occurance of 'Heading' and then continue to delete the rest. I'd then like it to...

Sorry. Will do.

Hi, I've got the following macro which runs through my spreadsheet looking for the word 'Heading' in column A. It deletes any row which contains the word 'Heading', great. However I would like it to keep the first occurance of 'Heading' and then continue to delete the rest. I'd then like it to...

Thanks! It was a bit of a noddy question (ashamed). What if a servername already existed in the text? So I would have to delete everything after the "=" first?