I have a workbook that has 109 worksheets in it, now I need to have the same
layout on each page is there a way to type it on wrksht 1 so that it will
automactally enter the same text through out the rest of the wrkshts?  Or is
the old fashion way the only way out of this?

I have the following INSERT statement (which works fine) -- what I need is
to modify it so that the value of the field "Location" will be passed to SQL
server with a one-up suffix (example:  on the 1st pass, append "1" to the
location Dallas, to get "Dallas 1" on the 2nd pass, ...

I created a worksheet a few months ago... that had a column with cells
that we gave a name.  We referenced some formulas to this name range..
and everything worked out fine.
Yesterday.. I open the worksheet and highlight those exact cells to see

How to build a graph that reads data from a few worksheets?
As an example;
In worksheet 01, we have
A - 12

I'm tryin to create a workbook to maintain a list of 21 names, which are
to be sorted and printed on a weekly basis based on total hours worked. So
far I have created a sheet for the total hours worked (which is the sort
criteria, along with one other parameter), and 52 separate ...

good day...
having rpoblems right now on how to programmatically repeat rows belo
a worksheet. can anybody plz help?
thank

I have used Named Formulas and am now learning about User Defined
Functions.   One thing I found with named formulas is that the naming
conventions around global/local selections.  Reading about UDFs makes
me think they might be a better option for a lot of my work.

Here's my Code...
---------------------------------------------------------
Sub recruitem3()
Dim arrExcelValues()

Hello All . . .
Please answer the questionary in the following URI
http://nees.awardspace.com/
Thanks a lot . . . :D

Evening
I have two simalar issues.
1) I have a column of text that represents the date but is entered as
text. The entry has a leading space (entered as "<sp>12 DEC 06")  that

If Wrap text is enabled for a cell, the row autofit function works properly.
But if I merge 2 or more cells in a row, then autofit doesn't work. It sets
itself to the height of 1 row even if the contents require more than 1 row's
height.

Well, I don't yet have my copy of MS-Excel 2007, but I am happy to see
that (in theory at least) the spreadsheets one will be able to generate
will be much larger than the 256-column, 65,536 (?) row spreadsheets of
the MS-Excel I now have.  According to Microsoft:

I'm trying to join 3 cells that are map references
A1   35
B1   02
C1   105

All my spreadsheets that  have been made in excel 2000 don't print out in
excel 2003 as they do in excel 2000.
The margins are off and the page breaks blend into the next page. I got a
new PC and it has office 2003 and all my excel files from my old PC have this

I have a set of forumulas that I want to drag down an Excel Sheet and
have the Cells increment by 4 each time rather than 1.  I can't find an
automated way to do this in Excel so I'm having to hand edit each
formula line.