| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| Technology & Technical Skills Computer skills, hardware, software, internet topics, gadgets, programming |
|
Welcome to the Personal Development for Smart People Forums, the place for lively, intelligent discussion of all personal growth issues -- physical, mental, financial, social, emotional, spiritual, and more. You're currently viewing as a guest, which gives you limited read-only access. By joining our free community, you'll be able to post your own messages, access many members-only features, see the new messages posted since your last visit, and of course remove this header message. Registration is fast, simple, and free, so please join today. If you arrived here from a search engine, you may want to explore the main site first, which includes hundreds of deep and insightful articles on a variety of personal development topics. |
 |
| | Thread Tools | Display Modes |
01-10-2008, 03:09 AM
| |||
| |||
 Spreadsheet formula question Spreadsheets are my Achilles heel, I swear... So, I'm making an item spreadsheet for my Yahoo store. I have a field, CODE, in block C1, where I'll enter my item numbers. In H1, I have YPATH, which is the url of the item page so that it may be listed on Yahoo! Shopping. For the YPATH column, I'd like to have http:// www.redcherrycheesecake.com ( CODE column entry ).htm for each new row/CODE number...but how the heck do I program my spreadsheet to insert the number into the url automatically? Is there a way to do that, so I don't have to type 10001 in column C, and then have to cut/paste 10001 manually in column H1? It would save a lot of time to just have it fill in the info by itself. Thanks for any help you can give. This is throwing me for a loop. Last edited by Isis Kali : 01-10-2008 at 03:13 AM. Reason: Wow! This just ate my formatting!      |
|
01-10-2008, 05:08 AM
| |||
| |||
| Hi, This should work: =HYPERLINK("http://www.redcherrycheesecake.com"&C1&".htm") Then you can drag this formula down and it will put the codes in for you. I think you said you have the codes in column C... Good luck! |
|
01-10-2008, 07:17 AM
| |||
| |||
| Quote:
 = "http://www.redcherrycheesecake.com/" & C1 & ".htm" |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| My figure out the feelings inside my brain/body thread | Sunnybayes | Personal Effectiveness | 87 | 04-27-2008 03:57 PM |
| Dreams Question | Lil Chris | Psychic & Paranormal | 5 | 10-14-2007 03:42 AM |
| A Question - and Hello! | Kura Ookami | General & Introductions | 2 | 09-01-2007 03:12 PM |
| Learning, but not doing | andrew | Personal Effectiveness | 79 | 06-14-2007 12:35 AM |
| self employment taxes question.... | VetTechJess | Business & Financial | 0 | 06-06-2007 10:08 PM |
All times are GMT. The time now is 05:01 AM.