Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
frame style effect required
I'm building a spreadsheet for work, its for quoting a price for
foundations on each house on a building site. i have a front page which has column A detailing all the items required - simplified it would be concrete, stone, bricks etc. Column B is the price/rate for that item then each plot has its own worksheet with the same format except with a quantity to multiply by the rate to get theprice, the prices are then summed and read back to the front page which has a summary for every single plot. the problem i have is that there are 110 worksheets in the book and we're trying to get to a basic template to use for different building sites. the aim is to enter the specific requirements i.e. the bricks concrete etc (which will change from site to site) on the front page and have them update on each worksheet. using a straight =sheet1 a1 type formula has the desired effect except the formating isn't read. we need the titles to be in bold etc and they may not always be in the same cell depending how many items are falling under the heading for that particular site -which rules out applying the format to each worksheet. I've used the camera tool to put an image of the headings on each sheet which updates as they update which works fine aside from the fact the sheet is extremely slow to run. having built a few websites i wondered if it was possible to create something like an i frame where the headings are entered in one sheet which is then embedded at the side of each individual worksheet and remains fixed in place like a frozen pane - basically so that instead of 110 images i'd have a link to another spreadhseet visible. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make my borded automatic black instead of pink? | Excel Worksheet Functions | |||
From Dollar ($) sign style to Dirhams (Dhs.) sign style | Excel Discussion (Misc queries) | |||
Can not delete Excel Style | Excel Discussion (Misc queries) | |||
Currency, Percent and Comma Style buttons | Excel Worksheet Functions | |||
changing font style in a complex worksheet function | Excel Worksheet Functions |