I don't think what I want is possible, but thought I'd ask around before I give up.
Is it possible to link a spreadsheet to an identical spreadsheet so that when you update the original it automatically updates the copy, but not the other way around? I have a spreadsheet that I will be updating daily, and I also need someone else to input a bit of data into it quite often. But I don't want her to have access to the original for fear she'll screw MY data up. Making a copy of the original won't work since I will be adding alot of data each day. Any suggestions? Is it possible to give her edit rights to only some of the columns and not others?
For example, lets say we sell Avon together - you have a spreadsheet of customers with all their contact info. Each day you add new customers along with the items they order. Then you need me to go in every few days after I deliver it to them and update it with the actual amount of the cash we received from them, and mark them paid on the spreadsheet. But you think I'm a dumbass and you're afraid I will accidently screw up the client data you spent weeks entering. How do you allow me to update my info yet insure that you're info stays safe?
Basically you are trying to do what people have been doing to excel since its inception: using it for stuff its not meant for! Sorry but it is the truth... Excel is a really fancy calculator... If you remember that it will serve you well and work good. You may be able to twist it to do what you are asking but in time it will hit a wall in some way and you will spend more time fiddling with excel then actually doing what you set out to do. It is like trying to dig a swimming pool with a snow shovel, it can be done but a backhoe will do it allot better and faster. Yes you may have to learn something new but think of how many pools you can dig after learning
The example you cite would be served by a database backed application of some kind. A point of sale or even a crm system does what you are looking for quite well and you can find some free and open source out there and even internet based ones can be found.
You can use excel to do this and even Google docs will do this but neither is really meant to.
Go to Google and search this term : free sales software for small business
No quotes or anything like that when you search and this will give you an idea of what is available and maybe save you a whole lot of time down the line and actually help you accomplish what you want to do which I'm pretty sure is NOT spend all your time fiddling with excel or bending some other software to your will, against its will.
Too many years in IT and have seen things like this waste so many people's time not to chime in. Good luck and pm me with more specific information if you would like some help but if you are doing something like your example than that search should get you on the right path.
Sent from my A100 using Tapatalk