make interactive sheets

[Al3ks]

Hi,
I need to make interactive sheets so me and my colleague can make some modifications.
I need 2 sheet to be interactive (drobilice, potrosnja delova).
Can it be done without making caure interactive, cause drobilice take data from caure?
In drobilice i wanna A, C, E, F columns to be locked in interactive mode (i can hide them).
I try with single file web page and web page, i try to check all options under tools (web and general options). I was clicked on publish. And i couldnt make any change, it was like jpg.

It cant upload drobilice.mht

[JeteMc]

Not sure that I understand what you want to accomplish, guessing that it has something to do with the values in column B. However in trying to figure things out I found that the values in column F are not coming from the correct rows on the caure sheet. If you look at column G on the drobilice sheet you'll see that most of the values in column F incorrectly come from either row 2 or 31. I modified the values in column A on the caure2 sheet and the index/match formula on the drobilice2 sheet. As you can see the values for column F on the drobilice2 sheet now come from the correct row.
If the request does have something to do with the values in column B on the drobilice sheet, please let us know where they come from, as I can't figure them out.
Let us know if you have any questions.

[Al3ks]

Hi Jete,
in first, when iwas reading ur post, i was in "what the f**k this guy talk about when everything work fine". But, i downloaded doc and after i saw i was in "he have time to manipulate with data, just to make jocks". I open my original doc and saw same thing. " What the f***? Are there gremlins in my comp?"
Tnx for point on that Jete.
Idea of this question is to manipulate with data by me and my friend who dont work anymore in same firm with me.
We make everything alone or with help from others over internet. This is just one of documents that we maked.
Whole production in our copper mine, by shifts, by day, by vehicles we input in other excel document. That is our major document (production - proizvodnja)
From that document we take data for "crusher production" (drobilice proizvodnja) per every crusher (time of crushers in work and production per shift)
Then we have document for non-production shifts and why we didnt have production (crusher hault, conveyor hault, etc...).

When i see how we can modificate 1 sheet i will upload to him all sheets (we make our private page on wordpress - non published).