Can I create an if else statement within a Macro? If so how do I convert the
following formula to a macro that will continue to check additional cells for
text content and pull that content to another worksheet?

=IF('C:\Documents and Settings\Rhonda\My Documents\Help Me Rhonda
TOA\[E40.xls]E40'!$E$370,+'C:\Documents and Settings\Rhonda\My
Documents\Help Me Rhonda TOA\[E40.xls]E40'!$E$37,0)

Can this be done?

Are you trying to create linked worksheet formulas via a macro, or just drop
in values?
Dale Preuss

"Help Me Rhonda TOA" wrote:

Can I create an if else statement within a Macro? If so how do I convert the
following formula to a macro that will continue to check additional cells for
text content and pull that content to another worksheet?

=IF('C:\Documents and Settings\Rhonda\My Documents\Help Me Rhonda
TOA\[E40.xls]E40'!$E$370,+'C:\Documents and Settings\Rhonda\My
Documents\Help Me Rhonda TOA\[E40.xls]E40'!$E$37,0)

Can this be done?

I'm just trying to drop in the values, but only if they are not empty.

"Dale Preuss" wrote:

Are you trying to create linked worksheet formulas via a macro, or just drop
in values?
Dale Preuss

"Help Me Rhonda TOA" wrote:

Can I create an if else statement within a Macro? If so how do I convert the
following formula to a macro that will continue to check additional cells for
text content and pull that content to another worksheet?

=IF('C:\Documents and Settings\Rhonda\My Documents\Help Me Rhonda
TOA\[E40.xls]E40'!$E$370,+'C:\Documents and Settings\Rhonda\My
Documents\Help Me Rhonda TOA\[E40.xls]E40'!$E$37,0)

Can this be done?

Just drop in values, but only if they are not empty.

"Dale Preuss" wrote:

Are you trying to create linked worksheet formulas via a macro, or just drop
in values?
Dale Preuss

"Help Me Rhonda TOA" wrote:

Can I create an if else statement within a Macro? If so how do I convert the
following formula to a macro that will continue to check additional cells for
text content and pull that content to another worksheet?

=IF('C:\Documents and Settings\Rhonda\My Documents\Help Me Rhonda
TOA\[E40.xls]E40'!$E$370,+'C:\Documents and Settings\Rhonda\My
Documents\Help Me Rhonda TOA\[E40.xls]E40'!$E$37,0)

Can this be done?

Just drop in values -- but only if they are not empty.

"Dale Preuss" wrote:

Are you trying to create linked worksheet formulas via a macro, or just drop
in values?
Dale Preuss

"Help Me Rhonda TOA" wrote:

Can I create an if else statement within a Macro? If so how do I convert the
following formula to a macro that will continue to check additional cells for
text content and pull that content to another worksheet?

=IF('C:\Documents and Settings\Rhonda\My Documents\Help Me Rhonda
TOA\[E40.xls]E40'!$E$370,+'C:\Documents and Settings\Rhonda\My
Documents\Help Me Rhonda TOA\[E40.xls]E40'!$E$37,0)

Can this be done?

Just drop in values -- but only if they are not empty.


"Dale Preuss" wrote:

Are you trying to create linked worksheet formulas via a macro, or just drop
in values?
Dale Preuss

"Help Me Rhonda TOA" wrote:

Can I create an if else statement within a Macro? If so how do I convert the
following formula to a macro that will continue to check additional cells for
text content and pull that content to another worksheet?

=IF('C:\Documents and Settings\Rhonda\My Documents\Help Me Rhonda
TOA\[E40.xls]E40'!$E$370,+'C:\Documents and Settings\Rhonda\My
Documents\Help Me Rhonda TOA\[E40.xls]E40'!$E$37,0)

Can this be done?

Just drop in values -- but only if they are not empty.

"Dale Preuss" wrote:

Are you trying to create linked worksheet formulas via a macro, or just drop
in values?
Dale Preuss

"Help Me Rhonda TOA" wrote:

Can I create an if else statement within a Macro? If so how do I convert the
following formula to a macro that will continue to check additional cells for
text content and pull that content to another worksheet?

=IF('C:\Documents and Settings\Rhonda\My Documents\Help Me Rhonda
TOA\[E40.xls]E40'!$E$370,+'C:\Documents and Settings\Rhonda\My
Documents\Help Me Rhonda TOA\[E40.xls]E40'!$E$37,0)

Can this be done?

Rhonda,

There are several ways to do this; each requires a loop of some sort.

If you are working in a matrix of ten columns by 20 rows and about a third
of the cells are populated, do you want empty cells not shown on the
destination worksheet?
Example: On the source worksheet, of the 20 rows in column A, 5 are
populated. Should cells A1:A5 on the destination worksheet hold the
transfered contents regardless of which 20 cells were populated on the source
and regardless of the contents of the other 9 columns on the source?

Or, are you trying to remove blank rows of data?

Dale Preuss



"Help Me Rhonda TOA" wrote:


Just drop in values -- but only if they are not empty.

"Dale Preuss" wrote:

Are you trying to create linked worksheet formulas via a macro, or just drop
in values?
Dale Preuss

"Help Me Rhonda TOA" wrote:

Can I create an if else statement within a Macro? If so how do I convert the
following formula to a macro that will continue to check additional cells for
text content and pull that content to another worksheet?

=IF('C:\Documents and Settings\Rhonda\My Documents\Help Me Rhonda
TOA\[E40.xls]E40'!$E$370,+'C:\Documents and Settings\Rhonda\My
Documents\Help Me Rhonda TOA\[E40.xls]E40'!$E$37,0)

Can this be done?

Cells A1:A5 would show on the destination sheet under a specified group
without the other empty rows of text; and the other 9 columns would show on
the destination sheet in a different block of cells (separated by whatever
their column headings are) if they are not empty. The destination sheet is a
type of summary of what was input from the other sheets. Picture this: I
receive 8 different forms and from those forms I transfer all names entered
on the form based on whatever category that person fits into -- for example,
all supervisors are copied to a block on the destination sheet that holds all
supervisors; another block would hold all managers; another block would hold
all employees on duty, and so forth.

So, if the supervisors are in cell E37 and E38; all managers in cell
T37:T40; and all employees in cells F41, S41, and Y41 -- I only want to copy
the cells to the destination sheet only if a name has been input to identify
members of each category.


"Dale Preuss" wrote:

Rhonda,

There are several ways to do this; each requires a loop of some sort.

If you are working in a matrix of ten columns by 20 rows and about a third
of the cells are populated, do you want empty cells not shown on the
destination worksheet?
Example: On the source worksheet, of the 20 rows in column A, 5 are
populated. Should cells A1:A5 on the destination worksheet hold the
transfered contents regardless of which 20 cells were populated on the source
and regardless of the contents of the other 9 columns on the source?

Or, are you trying to remove blank rows of data?

Dale Preuss



"Help Me Rhonda TOA" wrote:


Just drop in values -- but only if they are not empty.

"Dale Preuss" wrote:

Are you trying to create linked worksheet formulas via a macro, or just drop
in values?
Dale Preuss

"Help Me Rhonda TOA" wrote:

Can I create an if else statement within a Macro? If so how do I convert the
following formula to a macro that will continue to check additional cells for
text content and pull that content to another worksheet?

=IF('C:\Documents and Settings\Rhonda\My Documents\Help Me Rhonda
TOA\[E40.xls]E40'!$E$370,+'C:\Documents and Settings\Rhonda\My
Documents\Help Me Rhonda TOA\[E40.xls]E40'!$E$37,0)

Can this be done?

Cells A1:A5 would show on the destination sheet under a specified group
without the other empty rows of text; and the other 9 columns would show on
the destination sheet in a different block of cells (separated by whatever
their column headings are) if they are not empty. The destination sheet is a
type of summary of what was input from the other sheets. Picture this: I
receive 8 different forms and from those forms I transfer all names entered
on the form based on whatever category that person fits into -- for example,
all supervisors are copied to a block on the destination sheet that holds all
supervisors; another block would hold all managers; another block would hold
all employees on duty, and so forth.

So, if the supervisors are in cell E37 and E38; all managers in cell
T37:T40; and all employees in cells F41, S41, and Y41 -- I only want to copy
the cells to the destination sheet only if a name has been input to identify
members of each category.


"Dale Preuss" wrote:

Rhonda,

There are several ways to do this; each requires a loop of some sort.

If you are working in a matrix of ten columns by 20 rows and about a third
of the cells are populated, do you want empty cells not shown on the
destination worksheet?
Example: On the source worksheet, of the 20 rows in column A, 5 are
populated. Should cells A1:A5 on the destination worksheet hold the
transfered contents regardless of which 20 cells were populated on the source
and regardless of the contents of the other 9 columns on the source?

Or, are you trying to remove blank rows of data?

Dale Preuss



"Help Me Rhonda TOA" wrote:


Just drop in values -- but only if they are not empty.

"Dale Preuss" wrote:

Are you trying to create linked worksheet formulas via a macro, or just drop
in values?
Dale Preuss

"Help Me Rhonda TOA" wrote:

Can I create an if else statement within a Macro? If so how do I convert the
following formula to a macro that will continue to check additional cells for
text content and pull that content to another worksheet?

=IF('C:\Documents and Settings\Rhonda\My Documents\Help Me Rhonda
TOA\[E40.xls]E40'!$E$370,+'C:\Documents and Settings\Rhonda\My
Documents\Help Me Rhonda TOA\[E40.xls]E40'!$E$37,0)

Can this be done?

Rhonda,
How are names distinguished from other information?
Dale

"Help Me Rhonda TOA" wrote:

Cells A1:A5 would show on the destination sheet under a specified group
without the other empty rows of text; and the other 9 columns would show on
the destination sheet in a different block of cells (separated by whatever
their column headings are) if they are not empty. The destination sheet is a
type of summary of what was input from the other sheets. Picture this: I
receive 8 different forms and from those forms I transfer all names entered
on the form based on whatever category that person fits into -- for example,
all supervisors are copied to a block on the destination sheet that holds all
supervisors; another block would hold all managers; another block would hold
all employees on duty, and so forth.

So, if the supervisors are in cell E37 and E38; all managers in cell
T37:T40; and all employees in cells F41, S41, and Y41 -- I only want to copy
the cells to the destination sheet only if a name has been input to identify
members of each category.


"Dale Preuss" wrote:

Rhonda,

There are several ways to do this; each requires a loop of some sort.

If you are working in a matrix of ten columns by 20 rows and about a third
of the cells are populated, do you want empty cells not shown on the
destination worksheet?
Example: On the source worksheet, of the 20 rows in column A, 5 are
populated. Should cells A1:A5 on the destination worksheet hold the
transfered contents regardless of which 20 cells were populated on the source
and regardless of the contents of the other 9 columns on the source?

Or, are you trying to remove blank rows of data?

Dale Preuss



"Help Me Rhonda TOA" wrote:


Just drop in values -- but only if they are not empty.

"Dale Preuss" wrote:

Are you trying to create linked worksheet formulas via a macro, or just drop
in values?
Dale Preuss

"Help Me Rhonda TOA" wrote:

Can I create an if else statement within a Macro? If so how do I convert the
following formula to a macro that will continue to check additional cells for
text content and pull that content to another worksheet?

=IF('C:\Documents and Settings\Rhonda\My Documents\Help Me Rhonda
TOA\[E40.xls]E40'!$E$370,+'C:\Documents and Settings\Rhonda\My
Documents\Help Me Rhonda TOA\[E40.xls]E40'!$E$37,0)

Can this be done?

Yes, I have set up a database that holds all information input from the
workbooks into a columnar format and the columns all have headings that
distinguish one column of information from another.

"Dale Preuss" wrote:

Rhonda,
How are names distinguished from other information?
Dale

"Help Me Rhonda TOA" wrote:

Cells A1:A5 would show on the destination sheet under a specified group
without the other empty rows of text; and the other 9 columns would show on
the destination sheet in a different block of cells (separated by whatever
their column headings are) if they are not empty. The destination sheet is a
type of summary of what was input from the other sheets. Picture this: I
receive 8 different forms and from those forms I transfer all names entered
on the form based on whatever category that person fits into -- for example,
all supervisors are copied to a block on the destination sheet that holds all
supervisors; another block would hold all managers; another block would hold
all employees on duty, and so forth.

So, if the supervisors are in cell E37 and E38; all managers in cell
T37:T40; and all employees in cells F41, S41, and Y41 -- I only want to copy
the cells to the destination sheet only if a name has been input to identify
members of each category.


"Dale Preuss" wrote:

Rhonda,

There are several ways to do this; each requires a loop of some sort.

If you are working in a matrix of ten columns by 20 rows and about a third
of the cells are populated, do you want empty cells not shown on the
destination worksheet?
Example: On the source worksheet, of the 20 rows in column A, 5 are
populated. Should cells A1:A5 on the destination worksheet hold the
transfered contents regardless of which 20 cells were populated on the source
and regardless of the contents of the other 9 columns on the source?

Or, are you trying to remove blank rows of data?

Dale Preuss



"Help Me Rhonda TOA" wrote:


Just drop in values -- but only if they are not empty.

"Dale Preuss" wrote:

Are you trying to create linked worksheet formulas via a macro, or just drop
in values?
Dale Preuss

"Help Me Rhonda TOA" wrote:

Can I create an if else statement within a Macro? If so how do I convert the
following formula to a macro that will continue to check additional cells for
text content and pull that content to another worksheet?

=IF('C:\Documents and Settings\Rhonda\My Documents\Help Me Rhonda
TOA\[E40.xls]E40'!$E$370,+'C:\Documents and Settings\Rhonda\My
Documents\Help Me Rhonda TOA\[E40.xls]E40'!$E$37,0)

Can this be done?

Yes, I have set up a database that pulls the information contained on the
different worksheets into a columnar format -- each column is pulled from the
very same cell on each of the worksheets and the columns all have headings.

"Dale Preuss" wrote:

Rhonda,
How are names distinguished from other information?
Dale

"Help Me Rhonda TOA" wrote:

Cells A1:A5 would show on the destination sheet under a specified group
without the other empty rows of text; and the other 9 columns would show on
the destination sheet in a different block of cells (separated by whatever
their column headings are) if they are not empty. The destination sheet is a
type of summary of what was input from the other sheets. Picture this: I
receive 8 different forms and from those forms I transfer all names entered
on the form based on whatever category that person fits into -- for example,
all supervisors are copied to a block on the destination sheet that holds all
supervisors; another block would hold all managers; another block would hold
all employees on duty, and so forth.

So, if the supervisors are in cell E37 and E38; all managers in cell
T37:T40; and all employees in cells F41, S41, and Y41 -- I only want to copy
the cells to the destination sheet only if a name has been input to identify
members of each category.


"Dale Preuss" wrote:

Rhonda,

There are several ways to do this; each requires a loop of some sort.

If you are working in a matrix of ten columns by 20 rows and about a third
of the cells are populated, do you want empty cells not shown on the
destination worksheet?
Example: On the source worksheet, of the 20 rows in column A, 5 are
populated. Should cells A1:A5 on the destination worksheet hold the
transfered contents regardless of which 20 cells were populated on the source
and regardless of the contents of the other 9 columns on the source?

Or, are you trying to remove blank rows of data?

Dale Preuss



"Help Me Rhonda TOA" wrote:


Just drop in values -- but only if they are not empty.

"Dale Preuss" wrote:

Are you trying to create linked worksheet formulas via a macro, or just drop
in values?
Dale Preuss

"Help Me Rhonda TOA" wrote:

Can I create an if else statement within a Macro? If so how do I convert the
following formula to a macro that will continue to check additional cells for
text content and pull that content to another worksheet?

=IF('C:\Documents and Settings\Rhonda\My Documents\Help Me Rhonda
TOA\[E40.xls]E40'!$E$370,+'C:\Documents and Settings\Rhonda\My
Documents\Help Me Rhonda TOA\[E40.xls]E40'!$E$37,0)

Can this be done?