Populating sheets from an input sheet

S

Speedy

The questions is as follows: I import client accounting trial balances in a
worksheet. To this data I add a sort code which will determine which
specific subsequent worksheet needs to be populated. For example 3 seperate
investments to populate the investment lead sheet. The problem I have is
dealing with the unknown number of items that will appear under each sort
code making the use of a formula like =Sheet1 A1 dependent on knowing the
exact loaction and number of items.

Does anybody have a better solution for this. It can be done in VB I am
sure but I am not sure how to code this.

Has anybody got a solution?
 
O

Otto Moehrbach

Speedy
You have to provide much more detail about what you have to receive a
meaningful response. I would choose to use VBA for the task you describe.
If you wish, send me direct a small sample file of what you have.
Include a list of all the sort codes and the related sheets to be populated.
Also include directions to where in the subsequent sheets you want the data
pasted. Provide as much detail as you can. Remember that you are the only
one that understands what you want.
If you feel your data is proprietary, just make up something I can work
with that you can later relate to what you need.
My email address is [email protected]. Remove "Cobia97 from this
address. HTH Otto
 
Top