I have built a worksheet in Excel to print ID cards using data in another
worksheet exported from an accounting program. The field for the first name
is =([filename]Sheet1!$C$3). Is there a way to use a variable to copy the
next name in the file, ie, cell C4, without having to enter each one
manually?

Sorry if this has already been covered. I love Excel and know it will do SO
much more than I understand.

Thank you in advance.

On Jul 31, 9:34 pm, Ruthie wrote:
I have built a worksheet in Excel to print ID cards using data in another
worksheet exported from an accounting program. The field for the first name
is =([filename]Sheet1!$C$3). Is there a way to use a variable to copy the
next name in the file, ie, cell C4, without having to enter each one
manually?

Sorry if this has already been covered. I love Excel and know it will do SO
much more than I understand.

Thank you in advance.

You should be able to if you get rid of the absolutes ($ signs)
then you should be able to drag the formula down

Thanks for your response. I have tried =([filename]Sheet1!C3) for the first
name, and that works. I really don't understand what you're telling me to do
besides get rid of the $ signs. I am trying to define a formula which will
copy subsequent names on the list without having to type each cell reference.
Is that possible?

"D." wrote:

On Jul 31, 9:34 pm, Ruthie wrote:
I have built a worksheet in Excel to print ID cards using data in another
worksheet exported from an accounting program. The field for the first name
is =([filename]Sheet1!$C$3). Is there a way to use a variable to copy the
next name in the file, ie, cell C4, without having to enter each one
manually?

Sorry if this has already been covered. I love Excel and know it will do SO
much more than I understand.

Thank you in advance.

You should be able to if you get rid of the absolutes ($ signs)
then you should be able to drag the formula down

If the cells in the destination sheet are continuous, in a column or row,
then as D. said, get rid of the $ symbol (as you show in last post), Next
move the mouse pointer toward the lower right corner of the cell with the
formula in it until it becomes a narrow + symbol. Click and hold and drag
down the sheet (or across it) and formulas will be duplicated in the cells
below/to the right and their address will change automatically. Search Excel
Help for topic Fill Data that should help you some.

"Ruthie" wrote:

Thanks for your response. I have tried =([filename]Sheet1!C3) for the first
name, and that works. I really don't understand what you're telling me to do
besides get rid of the $ signs. I am trying to define a formula which will
copy subsequent names on the list without having to type each cell reference.
Is that possible?

"D." wrote:

On Jul 31, 9:34 pm, Ruthie wrote:
I have built a worksheet in Excel to print ID cards using data in another
worksheet exported from an accounting program. The field for the first name
is =([filename]Sheet1!$C$3). Is there a way to use a variable to copy the
next name in the file, ie, cell C4, without having to enter each one
manually?

Sorry if this has already been covered. I love Excel and know it will do SO
much more than I understand.

Thank you in advance.

You should be able to if you get rid of the absolutes ($ signs)
then you should be able to drag the formula down

Thanks for explaining that, and it works! (I love it when I learn something
new!) Unfortunately, the destination cells are not contiguous. The worksheet
is a template for ID cards, ten to a page, and the cells containing formulas
for imported data are spread out on the card.

I'm still trying to figure out how to modify the formulas without changing
each one. I could do that, but there are ~300 cards with four imported fields
in each. I just keep thinking there's got to be a better way to do this...

"JLatham" wrote:

If the cells in the destination sheet are continuous, in a column or row,
then as D. said, get rid of the $ symbol (as you show in last post), Next
move the mouse pointer toward the lower right corner of the cell with the
formula in it until it becomes a narrow + symbol. Click and hold and drag
down the sheet (or across it) and formulas will be duplicated in the cells
below/to the right and their address will change automatically. Search Excel
Help for topic Fill Data that should help you some.

"Ruthie" wrote:

Thanks for your response. I have tried =([filename]Sheet1!C3) for the first
name, and that works. I really don't understand what you're telling me to do
besides get rid of the $ signs. I am trying to define a formula which will
copy subsequent names on the list without having to type each cell reference.
Is that possible?

"D." wrote:

On Jul 31, 9:34 pm, Ruthie wrote:
I have built a worksheet in Excel to print ID cards using data in another
worksheet exported from an accounting program. The field for the first name
is =([filename]Sheet1!$C$3). Is there a way to use a variable to copy the
next name in the file, ie, cell C4, without having to enter each one
manually?

Sorry if this has already been covered. I love Excel and know it will do SO
much more than I understand.

Thank you in advance.

You should be able to if you get rid of the absolutes ($ signs)
then you should be able to drag the formula down

So, does any kind soul know how this can be done? I appreciate your thoughts...

"Ruthie" wrote:

Thanks for explaining that, and it works! (I love it when I learn something
new!) Unfortunately, the destination cells are not contiguous. The worksheet
is a template for ID cards, ten to a page, and the cells containing formulas
for imported data are spread out on the card.

I'm still trying to figure out how to modify the formulas without changing
each one. I could do that, but there are ~300 cards with four imported fields
in each. I just keep thinking there's got to be a better way to do this...

"JLatham" wrote:

If the cells in the destination sheet are continuous, in a column or row,
then as D. said, get rid of the $ symbol (as you show in last post), Next
move the mouse pointer toward the lower right corner of the cell with the
formula in it until it becomes a narrow + symbol. Click and hold and drag
down the sheet (or across it) and formulas will be duplicated in the cells
below/to the right and their address will change automatically. Search Excel
Help for topic Fill Data that should help you some.

"Ruthie" wrote:

Thanks for your response. I have tried =([filename]Sheet1!C3) for the first
name, and that works. I really don't understand what you're telling me to do
besides get rid of the $ signs. I am trying to define a formula which will
copy subsequent names on the list without having to type each cell reference.
Is that possible?

"D." wrote:

On Jul 31, 9:34 pm, Ruthie wrote:
I have built a worksheet in Excel to print ID cards using data in another
worksheet exported from an accounting program. The field for the first name
is =([filename]Sheet1!$C$3). Is there a way to use a variable to copy the
next name in the file, ie, cell C4, without having to enter each one
manually?

Sorry if this has already been covered. I love Excel and know it will do SO
much more than I understand.

Thank you in advance.

You should be able to if you get rid of the absolutes ($ signs)
then you should be able to drag the formula down

I need to set up a basic monthly billing form in Excel 2003.
There will be five columns:
A=Date;B= Hours;C= Project Name;D= $ Rate;
E=Total for that date.

The bottom of the form needs to show the total numbers of hours worked and a
summary of the total billed for that date.

I am a dinosaur and would appreciate any help.
Thank you.
Howard Levine


"Ruthie" wrote:

I have built a worksheet in Excel to print ID cards using data in another
worksheet exported from an accounting program. The field for the first name
is =([filename]Sheet1!$C$3). Is there a way to use a variable to copy the
next name in the file, ie, cell C4, without having to enter each one
manually?

Sorry if this has already been covered. I love Excel and know it will do SO
much more than I understand.

Thank you in advance.