G
Guest
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 "child" 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 "parent" 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
trying to accomplish. go easy on how I attempt to detail what I'm trying to
do.
Think budgetting tool.
I've created a "child" 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 "parent" 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