software

I'm trying to figure out what worksheet function(s) will best handle what I'm
trying to accomplish. go easy on how I attempt to detail what I'm trying to
do.

Think budgetting tool.

I've created a quot;childquot; worksheet matrix that sums data belonging to certain
account and object codes. Each worksheet is ONE GL account with X number of
object codes. say 50. The object codes don't change per worksheet but are
unique amongst themselves; Only the Account # field changes per worksheet
(and correlating values). I've created a quot;parentquot; worksheet that rolls up
each Account # worksheet by object code (using DSUM). In essence I'm asking
various department heads to budget by Acccount # (worksheet) and object code.

I'm trying to create one worksheet that will then list all of the Account
Number worksheets (by object code). Will Excel read through an expanding
number of worksheets successively as it will read through successive rows and
columns and return a specific value (or set of values) from each worksheet?
For instance, return cell values (these are the acccount numbers) on one
worksheet from a group of worksheets wherein cell A3 is unique to EACH
Account number worksheet.

I'm not sure I'm doing an adequate job explaing this but any
suggestions/comments would be appreciated. Thx.

/brian

Try looking he

www.officearticles.com/excel/...rk sheets.htm

quot;brianTmcnamaraquot; wrote:

gt; I'm trying to figure out what worksheet function(s) will best handle what I'm
gt; trying to accomplish. go easy on how I attempt to detail what I'm trying to
gt; do.
gt;
gt; Think budgetting tool.
gt;
gt; I've created a quot;childquot; worksheet matrix that sums data belonging to certain
gt; account and object codes. Each worksheet is ONE GL account with X number of
gt; object codes. say 50. The object codes don't change per worksheet but are
gt; unique amongst themselves; Only the Account # field changes per worksheet
gt; (and correlating values). I've created a quot;parentquot; worksheet that rolls up
gt; each Account # worksheet by object code (using DSUM). In essence I'm asking
gt; various department heads to budget by Acccount # (worksheet) and object code.
gt;
gt; I'm trying to create one worksheet that will then list all of the Account
gt; Number worksheets (by object code). Will Excel read through an expanding
gt; number of worksheets successively as it will read through successive rows and
gt; columns and return a specific value (or set of values) from each worksheet?
gt; For instance, return cell values (these are the acccount numbers) on one
gt; worksheet from a group of worksheets wherein cell A3 is unique to EACH
gt; Account number worksheet.
gt;
gt; I'm not sure I'm doing an adequate job explaing this but any
gt; suggestions/comments would be appreciated. Thx.
gt;
gt; /brian

Michael,

almost but not really....

I'm really looking to return all successive values in a given cell per
worksheet to a different cell in succession. worksheet 3:a3 lands in
worksheet4:a1. worksheet2:a3 lands in worksheet4:b1. worksheet1:a3 lands in
worksheet4:c1.

-brianquot;Michael E. McGrawquot; wrote:

gt; Try looking he
gt;
gt; www.officearticles.com/excel/...rk sheets.htm
gt;
gt; quot;brianTmcnamaraquot; wrote:
gt;
gt; gt; I'm trying to figure out what worksheet function(s) will best handle what I'm
gt; gt; trying to accomplish. go easy on how I attempt to detail what I'm trying to
gt; gt; do.
gt; gt;
gt; gt; Think budgetting tool.
gt; gt;
gt; gt; I've created a quot;childquot; worksheet matrix that sums data belonging to certain
gt; gt; account and object codes. Each worksheet is ONE GL account with X number of
gt; gt; object codes. say 50. The object codes don't change per worksheet but are
gt; gt; unique amongst themselves; Only the Account # field changes per worksheet
gt; gt; (and correlating values). I've created a quot;parentquot; worksheet that rolls up
gt; gt; each Account # worksheet by object code (using DSUM). In essence I'm asking
gt; gt; various department heads to budget by Acccount # (worksheet) and object code.
gt; gt;
gt; gt; I'm trying to create one worksheet that will then list all of the Account
gt; gt; Number worksheets (by object code). Will Excel read through an expanding
gt; gt; number of worksheets successively as it will read through successive rows and
gt; gt; columns and return a specific value (or set of values) from each worksheet?
gt; gt; For instance, return cell values (these are the acccount numbers) on one
gt; gt; worksheet from a group of worksheets wherein cell A3 is unique to EACH
gt; gt; Account number worksheet.
gt; gt;
gt; gt; I'm not sure I'm doing an adequate job explaing this but any
gt; gt; suggestions/comments would be appreciated. Thx.
gt; gt;
gt; gt; /brian

Brian:

I am sure that we can help you except your explanation is very unclear.

Give us some sample data: About 3 columns and 4 rows from 3 sheets. Then
explain in the context of your example data what you are trying to
accomplish.

=Mac=

L. A. McClellandquot;brianTmcnamaraquot; gt; wrote in message
...
gt; Michael,
gt;
gt; almost but not really....
gt;
gt; I'm really looking to return all successive values in a given cell per
gt; worksheet to a different cell in succession. worksheet 3:a3 lands in
gt; worksheet4:a1. worksheet2:a3 lands in worksheet4:b1. worksheet1:a3 lands
gt; in
gt; worksheet4:c1.
gt;
gt; -brian
gt;
gt;
gt; quot;Michael E. McGrawquot; wrote:
gt;
gt;gt; Try looking he
gt;gt;
gt;gt; www.officearticles.com/excel/...rk sheets.htm
gt;gt;
gt;gt; quot;brianTmcnamaraquot; wrote:
gt;gt;
gt;gt; gt; I'm trying to figure out what worksheet function(s) will best handle
gt;gt; gt; what I'm
gt;gt; gt; trying to accomplish. go easy on how I attempt to detail what I'm
gt;gt; gt; trying to
gt;gt; gt; do.
gt;gt; gt;
gt;gt; gt; Think budgetting tool.
gt;gt; gt;
gt;gt; gt; I've created a quot;childquot; worksheet matrix that sums data belonging to
gt;gt; gt; certain
gt;gt; gt; account and object codes. Each worksheet is ONE GL account with X
gt;gt; gt; number of
gt;gt; gt; object codes. say 50. The object codes don't change per worksheet but
gt;gt; gt; are
gt;gt; gt; unique amongst themselves; Only the Account # field changes per
gt;gt; gt; worksheet
gt;gt; gt; (and correlating values). I've created a quot;parentquot; worksheet that rolls
gt;gt; gt; up
gt;gt; gt; each Account # worksheet by object code (using DSUM). In essence I'm
gt;gt; gt; asking
gt;gt; gt; various department heads to budget by Acccount # (worksheet) and object
gt;gt; gt; code.
gt;gt; gt;
gt;gt; gt; I'm trying to create one worksheet that will then list all of the
gt;gt; gt; Account
gt;gt; gt; Number worksheets (by object code). Will Excel read through an
gt;gt; gt; expanding
gt;gt; gt; number of worksheets successively as it will read through successive
gt;gt; gt; rows and
gt;gt; gt; columns and return a specific value (or set of values) from each
gt;gt; gt; worksheet?
gt;gt; gt; For instance, return cell values (these are the acccount numbers) on
gt;gt; gt; one
gt;gt; gt; worksheet from a group of worksheets wherein cell A3 is unique to EACH
gt;gt; gt; Account number worksheet.
gt;gt; gt;
gt;gt; gt; I'm not sure I'm doing an adequate job explaing this but any
gt;gt; gt; suggestions/comments would be appreciated. Thx.
gt;gt; gt;
gt;gt; gt; /brian