Macro that will Pull Cells from Other Worksheets if not empty?

[Help Me Rhonda TOA]

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$37>0,+'C:\Documents and Settings\Rhonda\My
Documents\Help Me Rhonda TOA\[E40.xls]E40'!$E$37,0)

Can this be done?

 

[Dale Preuss]

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

 

[Help Me Rhonda TOA]

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

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

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$37>0,+'C:\Documents and Settings\Rhonda\My
Documents\Help Me Rhonda TOA\[E40.xls]E40'!$E$37,0)

Can this be done?

 

[Help Me Rhonda TOA]

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

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

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$37>0,+'C:\Documents and Settings\Rhonda\My
Documents\Help Me Rhonda TOA\[E40.xls]E40'!$E$37,0)

Can this be done?

 

[Help Me Rhonda TOA]

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

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

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$37>0,+'C:\Documents and Settings\Rhonda\My
Documents\Help Me Rhonda TOA\[E40.xls]E40'!$E$37,0)

Can this be done?

 

[Help Me Rhonda TOA]

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

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

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$37>0,+'C:\Documents and Settings\Rhonda\My
Documents\Help Me Rhonda TOA\[E40.xls]E40'!$E$37,0)

Can this be done?

 

[Help Me Rhonda TOA]

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

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

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$37>0,+'C:\Documents and Settings\Rhonda\My
Documents\Help Me Rhonda TOA\[E40.xls]E40'!$E$37,0)

Can this be done?

 

[Dale Preuss]

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

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

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

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$37>0,+'C:\Documents and Settings\Rhonda\My
Documents\Help Me Rhonda TOA\[E40.xls]E40'!$E$37,0)

Can this be done?

 

[Help Me Rhonda TOA]

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.

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

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

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

:

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$37>0,+'C:\Documents and Settings\Rhonda\My
Documents\Help Me Rhonda TOA\[E40.xls]E40'!$E$37,0)

Can this be done?

 

[Help Me Rhonda TOA]

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.

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

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

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

:

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$37>0,+'C:\Documents and Settings\Rhonda\My
Documents\Help Me Rhonda TOA\[E40.xls]E40'!$E$37,0)

Can this be done?

 

[Dale Preuss]

Rhonda,
How are names distinguished from other information?
Dale

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.

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

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

:

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

:

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$37>0,+'C:\Documents and Settings\Rhonda\My
Documents\Help Me Rhonda TOA\[E40.xls]E40'!$E$37,0)

Can this be done?

 

[Help Me Rhonda TOA]

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.

Rhonda,
How are names distinguished from other information?
Dale

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.

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



:


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

:

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

:

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$37>0,+'C:\Documents and Settings\Rhonda\My
Documents\Help Me Rhonda TOA\[E40.xls]E40'!$E$37,0)

Can this be done?

 

[Help Me Rhonda TOA]

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.

Rhonda,
How are names distinguished from other information?
Dale

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.

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



:


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

:

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

:

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$37>0,+'C:\Documents and Settings\Rhonda\My
Documents\Help Me Rhonda TOA\[E40.xls]E40'!$E$37,0)

Can this be done?