I have a sheet that is setup in a nice looking way for the public to see, all of the contents of the cells are based on formulas that reference different pages for different info. I can highlight a section of that sheet and save as web page to get a html file that looks identical for use on our website. The process works great, but I want to add more.

Even though the contents of the cells in the sheet are defined thru formulas, the resulting html has the values and not the formulas. I want to make those values mouseover links that call a Javascript...

Example...

In the HTML if it says, 

Please Login or Register  to view this content.
I want to make it say this in the exact same place

Please Login or Register  to view this content.
Now, on top of simply that, the number 11111 used in my example, needs to come from a lookup table matched from the result of the value of the cell. So every link will end up having a different # based on data found in another worksheet. About 60 of these per html file, 2 files per day, every day.

I have looked into several different options on how to acomplish this. A custom export script based on xl2html is one possibility that I know I could eventually make work, but the time to complete that is an issue. I could also probably make a script that could go through the finished html and make the changes based on the refrence in the excel by matching strings and making replacements. I was hoping for a simplier solution using an excel formula of some kind. I may could even put the html into the formula itsself, so in excel it looks like html, but renders as html on the web page, except it turns my < into &lt; so that doesn't work really unless there is a workaround. Can anyone help me with some more ideas? Or a direction to go?

This is for an extra work project I am doing to expand our website, and would love some insight from some of you talented people. One of the key things to remember is, the final process to do what I want to do needs to be quick as it will be repeated ad-nausum and I dont have the time at work for a drawn out process done twice a day.