Thanks Dave
You gave a good advise.
If I don't go with shared workbook and my data is in 5 diffrent sheets, then
what will be best solution to consolidate the data.
The option I though was to call a procedure that will get data from all 5
sheets with sheet index in an array and then use that array for all my
calculation.
Please guide me , how can I do this.
Also, if I do this will it be possible to trace the row# of the record and
the name of the sheet.
Ex: If I have all the information in one array and based on my criteria I
found a match in the array element. Can I somehow trace the row# and the
sheet where the value is store. Ex my array element (10,2) meets my criteria
and it is stored in sheet 4 in row#10.


"Dave Peterson" wrote:

There are instructions how to handle those conflicts in Excel's help.

I searched for "resolve conflicts" and got a couple of options. But I think it
depends on who you should trust.

But I've never used a shared workbook in real life. Lots of very smart people
in the newsgroups will recommend never using them. (Stories of shared workbooks
becoming corrupted.)

You may want to use an application that was meant for simultaneous access by
your users--maybe Access or any other database program????

ub wrote:

Hi Dave
Currently the data from all 5 user is feeded in 1 sheet that is a shared
workbook.
But often we get a Reslove Conflict - Shared workbook error.
I am not able to handle this error so that I can advise the user who's data
was not saved to resubmit the data.
That is why I thought to feed data in 5 different sheets and then
consolidate it.
Please advise if you have any other suggestion

--

Dave Peterson