Search results for query: *

Hi there I have a laptop where Windows XP is corrupt and I cannot do anything once the system has booted up. Everything takes ages and all processes soon freeze. I cannot even run antivirus or spyware scans. I recently made an image of the drive using Acronis True Image and can reinstate it...

Hi I am naming my Excel SHEETS with dates i.e. Sheet 1 is called '1 dec' Sheet 2 is called '2 dec' I would like this (Sheetname) DATE to be copied into a CELL (formatted for date) in the same Sheet. Can this be done? Appreciations Emerald "Be kind for everyone you meet is fighting a...

Hi Skip Thanks again. Only needed an extra closing bracket at the end. =if(isblank(c11),"",if(isna(VLOOKUP (C11,SchemeList!$A$2:$B$39,2,FALSE)) ,"BSS",VLOOKUP(C11,SchemeList!$A$2:$B$39,2,FALSE))) "Be kind for everyone you meet is fighting a harder battle

Hi Skip Can u tell me how to amend the formula so that if cell C1 is blank (without any entry), then the formula cell also remains blank? "Be kind for everyone you meet is fighting a harder battle

Hi Skip I made a slight adjustment to the formula and it now works. The brackets were not quite right. Amended it is =IF(ISNA(VLOOKUP(C11,SchemeList!$A$2:$B$39,2,FALSE)),"BSS",VLOOKUP(C11,SchemeList!$A$2:$B$39,2,FALSE)) Thanks again "Be kind for everyone you meet is fighting a harder battle

Hi Skip hv tried what u suggest a few times, but does not work. however, I am grateful and thank you for taking the time to respond. best wishes Emerald "Be kind for everyone you meet is fighting a harder battle

Hi there, I have a VLOOKUP cell which is =VLOOKUP(C11,SchemeList!$A$2:$B$39,2,FALSE) Is it possible to put in a condition in this formula so that if an entry is put into C11 that cannot be matched from cells A2:B39 in the 'SchemeList' Sheet then the entry 'BSS' appears in the VLOOKUP cell...

Hi Skip Tks v much for yr help I took yr advice and tips and have sorted it out. Emerald "Be kind for everyone you meet is fighting a harder battle

Hi SkipVought Thanks for yr reply. OK so the table is in Sheet2 headings A1, B1... are also in Sheet2 According to yr instructions, pls can u explain which sheet your reference B2 is on? and also exactly where do I put =vlookup(a2,sheet2!A2:B99,2,false) and if it is not too complicated...

Hi I have created a drop-down list in a column in an excel spreadsheet. There are several CATEGORIES for the ITEMS in the drop-down list column. The ITEMS are e.g. ORANGES, BANANAS, APPLES, CARROTS, BEEF, LEEKS In the adjoining column to the left I manually enter the CATEGORIES e.g. FRUIT...

Does anyone know if there is a simple and good quality program to backup my linux hard drive and make an image where I can make a boot CD like True Image for Windows? True image by Acronis is a great program for Windows and you can make a boot CD, but unfortunately it is not suitable for Linux...

Something strange has recently happenned with my computer running XP Pro and Photoshop 7 although everything else feels and appears to be totally normal. So I believe I may have accidentally activated some hidden function in Windows XP or Photoshop. When I right click on a JPEG file and choose...

Dear Jock Brilliant!!!!!!! You are a genius! It works perfectly as I wanted. Thanks emerald "Be kind for everyone you meet is fighting a harder battle

Hi Brendaly I just tried what you suggest. All that seems to happen is that the html file gets attached to a blank email. There must be some kind of security risk that IE cannot handle and that is why it is not straight forward in Outlook. However the less security conscious using OE have the...

I have resorted to a rather crude yet somewhat effective method to achieve my goal and is as follows: 1. open a new html email message 2. now using browser( I use Mozilla)open html web page that I want to send and click onto it and select all and copy 3. click into new html email clear area and...

CorBlimeyLimey I tried what you suggest and it seems to take me one step closer, but when I clear the source from the Outlook HTML editor notepad page and paste in the code from my Dreamweaver page and save the notepad editor, the email page remains blank. "Be kind for everyone you meet is...

In Outlook Express when I start a new message, there 3 tabs, namely EDIT, SOURCE AND PREVIEW All I do then is select the SOURCE tab, clear the existing code and then copy and paste the source code from my HTML Dreamweaver document into the space. I then click the EDIT tab and hey presto my web...

I am going absolutely barmy trying to get some code from a Dreamweaver created web page into a new mail message(HTML) in Outlook XP. I cannot believe it is not possible!!!???? I know it can be done in Outlook Express (a program normally used by less demanding users). Has anyone achieved it in...

Everything worked fine upto a point on the compaq armada e500 notebook with win 98 and is much better with a recent windows XP installation except for the fact that the Toshiba CD/RW DVD-Rom plays CDs fine, but cannot seem to play DVDs for want of some kind of driver/firmware/update. I went to...

I am trying to rid myself of a Norton Antivirus program on my Win XP Pro system and the add/remove programs does not respond. There is also no uninstall file in the Norton Antivirus Program folder. Does anyone know how I can remove it manually i.e. by carefully removing selective files? This...