Unmanageable sheets

Judging from your description I would propose MS Access over Excel. You can store as many partners as necessary in tables and create queries to calculate numerical data. If you like, post an example (feel free to distort or change confidential info).

i can not attach a file...

I do not how to attach a file here...or i have no permissions to do that...
Thanks

ManvinderKaur said:

i can not attach a file...

Click to expand...

ManvinderKaur,

You can upload your workbook to www.box.net and provide us with a link to your workbook.

I'm going to 2nd the Access suggestion. Excel is a spreadsheet program, not a database program. You want to use the right tool for the job. Access queries would allow future manipulation of the data that might bring new and useful information.

If Access isn't an option, you could mimic a database. A macro could upload all the information to a single workbook. Each partner could be represented by their username - "environ("username")" will return the name they are logged on as which will give you something (hopefully) unique to use to separate each partner's data.

Hi, a suggestion for if you don't go the MS ACCESS way. What on the sheets are common (layouts, calculations, formulas etc.) and what is unique input and output? Unless you need to undertake similtaneous calculations across different sheets, why not look at storing the unique data only (Inputs and outcomes) via moving the data through a formula template as required? i.e. why store multiple instances of the same formula / layouts etc when all you need is the inputs and outputs? Dependant on the amount of inputs and outputs, 65 clients may equate to 65 rows of data. Even if too large for one sheet, you could have linked input & output sheets (a total of 2 sheets with 65 rows of data each) you would be able to regenerate any sheet at the "push of a button". Jeff

one client have one spreadsheet. all worksheets are in one workbook. there are 5 summary sheets ..that data come from all clients spreadhseets ..