LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 328
Default How to Autofill HTML code into Excell spreadsheet

Hello,

I have a website that will have over 3000 items (books) in it. I am in the
process of uploading all inventory to the site using Excel. It is an Ebay
Prostores website.

I use the website software to also upload items to Ebay. I do not like the
way it uploads items, it only uploads the description and not additional
fields from my site like the ISBN number, number of pages etc.

So when I want to upload inventory that will be listed to Ebay I make an
item and I can add html code to the description field and the item will look
how I like and include all details I need. However, in order to do this I
must view the page source for every item and copy and paste the appropriate
HTML code into my description column on my Excel spreadsheet, this will not
save me any time.

What I need to know is how to create a snippet of html code that I can paste
into my spreadsheet for every item and it will automatically pull the
appropriate information from the appropriate cells and insert it into the
html code. I hope I'm clear here. All of the content that I will need auto
inserted into the HTML column of my spreadsheet will be found elsewhere on
the spreadsheet.

Right now say I have 20 columns for each line item in my spreadsheet. I
want to pull information (the contents) from 6 different columns (the same
columns all the time) and have it automatically inserted into html code in
another column. The base html code will always remain the same, but there
are things in the code that will be different for each invidual item.

Someone can email me for more information if they prefer.

I don't know macros and don't have the time to learn right now. I'm very
quick but I'm under a lot of pressure to get this site up and have to
concentrate on that right now, I don't have the time to learn something new -
although I love doing that.

I would be willing to hire someone to figure it out for me, I just don't
know where to look.

Thank you very much for any direction or suggestions.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Html controls in spreadsheet michael sharpe Excel Programming 1 September 7th 06 06:53 AM
HTML controls in spreadsheet michael sharpe New Users to Excel 0 September 6th 06 08:15 PM
autofill data from excell dbase into html form offline? Robin Hood Excel Programming 2 November 13th 05 08:29 PM
How to alter data on HTML webpage into Excell cells as numbers? roameri New Users to Excel 6 July 31st 05 11:42 PM
Excell HTML Conversion Needs Refresh to Correct Format ppt Excel Programming 0 July 11th 03 11:15 PM


All times are GMT +1. The time now is 08:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"