Recent content by okigram

Excuse me... but I'm somewhat lost. If someone could point me in the correct direction I'd appreciate it. How does one host multiple websites on one hosting account. The web host is iPower Pro Plan which says you can have multiple domains on the account. Do I need to do something with the...

Thanks for all of the feedback and abuse all of which was informative and quite entertaining! As a disclaimer, I did not post the question to create a backlink. Including the url is the only way you could review the website. The purpose of the website was to compile a list of iPhone...

Thanks for the feedback. I know the site is on the dull side but I originally set it up as a place where you could go to find a categorized list of iphone accessories. If you click on a link it takes you to that accessory's page which has a photo, a short product description and a link to the...

I suggest creating a robots.txt file and uploading it to your web server root folder and also create an xml sitemap and upload that to your server. You can create the sitemap here: http://www.xml-sitemaps.com/index.php You can find out more about the robots.txt file in...

How about Microsoft Paint? It's free and already on your computer if it's a PC. Just look in "Accessories

Any suggestions you have on making this website easier to navigate and use would be greatly appreciated. I have been debating whether to change it to a Wordpress-based website for ease of updating and to take advantage of tags and the database functionality. THanks for your help! http://ivalise.com

yes, but this is just a 'quick fix'(famous last words) that 'management' wanted. they've already sent out the spreadsheets to the mfg plants. this will suffice. thanks for your help Glenn!

thanks, that seems to do the trick. is there any way to automate this? i only ask because i have HR people that will be copying/pasting this worksheet into the workbooks as they receive them from the plants. i would like to limit explanation and potential mistakes as much as possible!!

there are 10 variations on the below formula in sheet2. =IF(ISERROR(MATCH(IF(ISTEXT(IdEntered),IdEntered,TEXT(IdEntered,"0")),PS_ID,0)),"",INDEX(Employee2,MATCH(IF(ISTEXT(IdEntered),IdEntered,TEXT(IdEntered,"0")),PS_ID,0),28)) PS_ID is the named range for column 1 in sheet1 IdEntered is...

sorry...sessions...okay...now i've opened up both spreadsheets in the same excel session. when i past the sheet with the formulas in it to the other workbook, they reference the workbook which they were pasted from. is there any way to paste the formulas without them referencing the old...

thanks for all the replies. I tried to open the workbooks i nthe same session. it does allow me to paste and the formulas come through. however they still reference the old spreadsheet. how do i get it to refrain from referencing the other exxel file. i would rather not have to go into all of...

maybe i should rephrase it thusly... the problem i am having is that whenn i try to paste formulas between work books created in different excel sessions, it just pastes the value. if i do a 'paste special' my options are to paste images or a link object...none of which i want to do...i want it...

hi, the problem i am having is that whenn i try to paste formulas between work books created in different excel sessions, it just pastes the value. if i do a 'paste special' my options are to paste images or a link object...none of which i want to do...i want it to paste the actual formula but...

How do you copy formulas or sheets containing formulas from one Excel Workbook to another Workbook? When I try to do this it copies the data. When I do a paste special it gives me different options including pasting an image. I'm using Excel 2000. Thanks