Help

I have a workbook with numerous worksheets in it. Each work sheet has
information down colum A. In the first Worksheet i want it to gather all the
information in colum A of each persons Sheet. For example. In the main
worksheet it will say Employee1!$A$1 in Row 2 Column B. What i am trying to
do is copy that formula, but I dont want to have to change the names. Is
there a function code that i can do so that it will automatically change the
names?

I dont know if this makes sense, but any help would be appreciated.

Héctor
Fri Mar 14 23:53:22 CDT 2008

hi, John !

I suppose that you will need the name(s) for each person/sheet...
somewhere in your gathering resume, say... in column/row titles ?
after that, you could use indirect(...) worksheet-function (or other sort of alternates)

what you have not commented yet, is where you need the data gathering and it's "source" cell/range -?-

regards,
hector.

__ original post __
> I have a workbook with numerous worksheets in it. Each work sheet has information down colum A.
> In the first Worksheet i want it to gather all the information in colum A of each persons Sheet.
> For example. In the main worksheet it will say Employee1!$A$1 in Row 2 Column B.
> What i am trying to do is copy that formula, but I dont want to have to change the names.
> Is there a function code that i can do so that it will automatically change the names?
> I dont know if this makes sense, but any help would be appreciated.

SeanTimmons
Sat Mar 15 08:34:00 CDT 2008

I would say the easiest thing to do is copy the formula, then highlight each
column at a time and do a find/replace. Doesn't stop you from having to
change the names, but you do it once per employee instead of however many
rows you may have.

"John" wrote:

> I have a workbook with numerous worksheets in it. Each work sheet has
> information down colum A. In the first Worksheet i want it to gather all the
> information in colum A of each persons Sheet. For example. In the main
> worksheet it will say Employee1!$A$1 in Row 2 Column B. What i am trying to
> do is copy that formula, but I dont want to have to change the names. Is
> there a function code that i can do so that it will automatically change the
> names?
>
> I dont know if this makes sense, but any help would be appreciated.