I have a number of html pages to create. Basically all of the pages are
generic expect for specific keywords and table data. I am attempting to use
excel to ease the creation of these pages.
Currently I have a "setup page/ worksheet". This worksheet has quite a few
variables that is passed onto 3 other worksheets. I am wanting to get advice
as to what the best procedure would be to combine these into a single text
file. I know I will use the append command to combine each worksheet.

My main concern is that I have a list of items(single column) on the "setup
page" that I use to create code (worksheet3) for html table. The formula on
worksheet 3 is a offset and works fine. I use a variable from sheet1 to
determine the amount of rows. Here is formula I currently use:
=IF(OFFSET($A$1,Sheet1!$C$2*(ROW()-1)+COLUMN()-2,0)="","",OFFSET($A$1,Sheet1!$C$2*(ROW()-1)+COLUMN()-2,0)).
Basically A1 is trimmed data from sheet1, along with variable to determine
rows(Sheet1!$C$2).

1)Is there a way to create / or select a range of cells(columns x 4 rows) on
worksheet3 based on variable from "setup" page / Sheet1!$C$2?

2) on worksheet2 I need to select an entire column(no empty cells).
Specifically b column.This list again could be of varying length based on
data from setup page.

3) worksheet4 I have the "top" portion of html code that needs to be
selected This selection not vary - its fixed.

I want to take range from sheet4 output to txt file - append
have excess automatically select cells(this part I dont know how to do cause
the selection (#rows)could vary) from sheet 2 output to same txt file - append
and again automatically select # number of columns (Sheet1!$C$2) x 4 rows
and output to the same txt file.

I would also like to know if its possible to use info from cell to name the
output file(ie "setup sheet g1=blah.txt")?

I would like to get any advice and ideas how to get these 3 sheets into one
file. As always I have learned quite a bit from these newsgroups and the help
is greatly appreciated.

Thanks,
Jack