Excel Book Advice

[nighoftheeighth]

I am curently building a pricelist and need some help.

I have around 80 pages of a workbook in Microsoft Excel 07and each of these contains the following:

Main Logo
Product Image
Prices (determined by a control sheet)
Contact Info
8 Secondary logos at footer

It has become around 10mb and is very cumbersome when handling images, not to mention page size problems.

I have to change the main logo and the 8 secondary logos, this got me thinking about how css & html works, and would there be a way of exporting the Prices only from Excel to a pre-designed template.

I don't understand how this could be done?

 

[MarcLister]

You could have each price coded to be a paragraph or have the prices set to be one paragraph with a line break after each price.

So either <p>PRICE</p> or
<p>PRICE<br/>
PRICE<br/>
PRICE<br/>
</p> etc.

You could go to a spare column next to the prices and use the CONCATENATE function to add <p> and </p> tags before and after each price. Say there's a price in B2 and you want each price to be a paragraph you could do something like: =CONCATENATE("<p>",B3,"</p>"). If the price was £4 say you'd get <p>£4</p>. Copy and drag the CONCATENATE formula and you have all your prices in HTML format ready to copy into a webpage template.