|
URGENT!!! shared workbooks
I have set up a custom form in excel for users to select or type data into
that then sends the information to a new sheet in a list format at button click e.g Email only recontact size Budget yes no 100 5000 no yes 200 6000 #1 I then made it a shared workbook with the necessary ranges unprotected. but say for instance i am adding new data into the form thus creating a new record it places it underneath the previous record, but if my partner is also adding new records in the shared workbook at the same time abviously some of his cells and my cells conflict so when saved you have to change the previous persons work thus loosing the records the other user made. is there a macro or an option or somthing to say when saved if data in cells in range #1 (example)do not change make saved entry go to unused cells underneath the last record, and i dont want to have to start again because i have several complex cost, losses and estimate calculations running off that data being stored their to be able to remember wich i need to change. Can you help |
well not to sound like a knob but i put urgent because i need it for 2morrow,
I did use my real name look you'll see ash A.G.M are my initials its my first time using this comunities thing and it said put sometheing original down as you name, also i wasn't sure of wich discussion type it fitted into so i posted it in several different ones because i thought it had the Qualified people working in each group type so i thought it would make a difference, ok. also I didnt use the word MY BOSS so???? next time i wont use any of the above, apart from my name unless you want me to change my initails by depol????????? "David McRitchie" wrote: There are a few things that just will delay any answers, one of them is the use of "urgent" when you are not about to lose your files, wording like "my boss", and the other is the posting to several newsgroups. and not using your name is an additional source of irritation because it indicates you don't care about those you are asking for help from.. See reply in microsoft.public.excel and stick with that thread if you have additional questions or that does not solve your problem. http://groups.google.com/groups?thre...gp13.phx .gbl --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "A.G.M ash" <A.G.M wrote in message ... I have set up a custom form in excel for users to select or type data into that then sends the information to a new sheet in a list format at button click e.g Email only recontact size Budget yes no 100 5000 no yes 200 6000 #1 I then made it a shared workbook with the necessary ranges unprotected. but say for instance i am adding new data into the form thus creating a new record it places it underneath the previous record, but if my partner is also adding new records in the shared workbook at the same time abviously some of his cells and my cells conflict so when saved you have to change the previous persons work thus loosing the records the other user made. is there a macro or an option or somthing to say when saved if data in cells in range #1 (example)do not change make saved entry go to unused cells underneath the last record, and i dont want to have to start again because i have several complex cost, losses and estimate calculations running off that data being stored their to be able to remember wich i need to change. Can you help |
so from that msg do you think i am likely to get anymore input or is it a
rule to ignore people who cant read minds????????????? "A.G.M ash" wrote: well not to sound like a knob but i put urgent because i need it for 2morrow, I did use my real name look you'll see ash A.G.M are my initials its my first time using this comunities thing and it said put sometheing original down as you name, also i wasn't sure of wich discussion type it fitted into so i posted it in several different ones because i thought it had the Qualified people working in each group type so i thought it would make a difference, ok. also I didnt use the word MY BOSS so???? next time i wont use any of the above, apart from my name unless you want me to change my initails by depol????????? "David McRitchie" wrote: There are a few things that just will delay any answers, one of them is the use of "urgent" when you are not about to lose your files, wording like "my boss", and the other is the posting to several newsgroups. and not using your name is an additional source of irritation because it indicates you don't care about those you are asking for help from.. See reply in microsoft.public.excel and stick with that thread if you have additional questions or that does not solve your problem. http://groups.google.com/groups?thre...gp13.phx .gbl --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "A.G.M ash" <A.G.M wrote in message ... I have set up a custom form in excel for users to select or type data into that then sends the information to a new sheet in a list format at button click e.g Email only recontact size Budget yes no 100 5000 no yes 200 6000 #1 I then made it a shared workbook with the necessary ranges unprotected. but say for instance i am adding new data into the form thus creating a new record it places it underneath the previous record, but if my partner is also adding new records in the shared workbook at the same time abviously some of his cells and my cells conflict so when saved you have to change the previous persons work thus loosing the records the other user made. is there a macro or an option or somthing to say when saved if data in cells in range #1 (example)do not change make saved entry go to unused cells underneath the last record, and i dont want to have to start again because i have several complex cost, losses and estimate calculations running off that data being stored their to be able to remember wich i need to change. Can you help |
The rule used to be to watch a newsgroup for a week before posting so
you know what the group is about, but you can see all the posting now, so you can tell right away. Every ISP or web based site handling newsgroups is going to at least mention lots of things about newsgroup etiquette, it is obvious that you ignored that.. The only things that I thing may differ from a few other newsgroups are -- there is no moderator, keep your complete conversation in the newsgroup -- post only in plain text exceptions are generally have binaries in the newsgroup name and many but certainly not all alt. newsgroups. probably no quibbles with the above.. In addition: -- most of us are experienced people and if you did not meet your deadline, it is your problem, not ours, which does apply here to your postings.. -- Searching for previous postings in Google web search and Google groups search should be done first, and frequently is not. Sometimes hard to tell if someone really tried or not, but you can often spot a quality question by what is included in a question as to what is known and what is needed.. http://www.mvps.org/dmcritchie/excel/xlnews.htm -- You don't change the name of a subject within a thread, which you did, you also posted with a blank subject which is just normally going to be treated as SPAM in a newsgroup or in an email, some agents would not allow you to send with a blank subject or at least provide a warning.. -- Ask only one question in a thread, or try to make sure they are related and that the same person who can answer one can easily answer both; otherwise, you may be hurting yourself. Frequently a related question with both answers can help someone else -- so there is no hard rule, just a warning that you might not get your more important question answered, or both might be ignored because someone does not have the answer to both.. . Please read Hints for New Posters http://www.cpearson.com/excel/newposte.htm and just to let you know that they was a consensus of the newsgroup you can read something about what went into them at http://www.mvps.org/dmcritchie/excel/posting.htm and that was before Microsoft CDO came into being that flat out perverts Usenet usage I kind of figured you would not understand how "my boss" might relate to you so I changed the wording in the other replies in the other newsgroups to something that specifically applied to you -- we don't care about your deadlines, we answer pretty much as fast as we can whether it takes ten minutes or several days, you don't get any more priority than anyone else. No you are not likely to get answers to your original question in this newsgroup/thread, because you have another newsgroup that you posted the same question in and have replies to. Many of the people here have jobs and get paid a lot of money for what they do, whether it has anything to do with Excel or not. Others used to work for peanuts but consider their time just as valuable and not to be wasted.. Everyone here is willing to help others, but are too damn old to be abused. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "A.G.M ash" wrote in message ... so from that msg do you think i am likely to get anymore input or is it a rule to ignore people who cant read minds????????????? "A.G.M ash" wrote: well not to sound like a knob but i put urgent because i need it for 2morrow, I did use my real name look you'll see ash A.G.M are my initials its my first time using this comunities thing and it said put sometheing original down as you name, also i wasn't sure of wich discussion type it fitted into so i posted it in several different ones because i thought it had the Qualified people working in each group type so i thought it would make a difference, ok. also I didnt use the word MY BOSS so???? next time i wont use any of the above, apart from my name unless you want me to change my initails by depol????????? "David McRitchie" wrote: There are a few things that just will delay any answers, one of them is the use of "urgent" when you are not about to lose your files, wording like "my boss", and the other is the posting to several newsgroups. and not using your name is an additional source of irritation because it indicates you don't care about those you are asking for help from.. See reply in microsoft.public.excel and stick with that thread if you have additional questions or that does not solve your problem. http://groups.google.com/groups?thre...gp13.phx .gbl --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "A.G.M ash" <A.G.M wrote in message ... I have set up a custom form in excel for users to select or type data into that then sends the information to a new sheet in a list format at button click e.g Email only recontact size Budget yes no 100 5000 no yes 200 6000 #1 I then made it a shared workbook with the necessary ranges unprotected. but say for instance i am adding new data into the form thus creating a new record it places it underneath the previous record, but if my partner is also adding new records in the shared workbook at the same time abviously some of his cells and my cells conflict so when saved you have to change the previous persons work thus loosing the records the other user made. is there a macro or an option or somthing to say when saved if data in cells in range #1 (example)do not change make saved entry go to unused cells underneath the last record, and i dont want to have to start again because i have several complex cost, losses and estimate calculations running off that data being stored their to be able to remember wich i need to change. Can you help |
I pretty much make it a rule not to respond to any message that is multiposted
to a lot of groups. A personal choice I'm happy with. A.G.M ash wrote: so from that msg do you think i am likely to get anymore input or is it a rule to ignore people who cant read minds????????????? "A.G.M ash" wrote: well not to sound like a knob but i put urgent because i need it for 2morrow, I did use my real name look you'll see ash A.G.M are my initials its my first time using this comunities thing and it said put sometheing original down as you name, also i wasn't sure of wich discussion type it fitted into so i posted it in several different ones because i thought it had the Qualified people working in each group type so i thought it would make a difference, ok. also I didnt use the word MY BOSS so???? next time i wont use any of the above, apart from my name unless you want me to change my initails by depol????????? "David McRitchie" wrote: There are a few things that just will delay any answers, one of them is the use of "urgent" when you are not about to lose your files, wording like "my boss", and the other is the posting to several newsgroups. and not using your name is an additional source of irritation because it indicates you don't care about those you are asking for help from.. See reply in microsoft.public.excel and stick with that thread if you have additional questions or that does not solve your problem. http://groups.google.com/groups?thre...gp13.phx .gbl --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "A.G.M ash" <A.G.M wrote in message ... I have set up a custom form in excel for users to select or type data into that then sends the information to a new sheet in a list format at button click e.g Email only recontact size Budget yes no 100 5000 no yes 200 6000 #1 I then made it a shared workbook with the necessary ranges unprotected. but say for instance i am adding new data into the form thus creating a new record it places it underneath the previous record, but if my partner is also adding new records in the shared workbook at the same time abviously some of his cells and my cells conflict so when saved you have to change the previous persons work thus loosing the records the other user made. is there a macro or an option or somthing to say when saved if data in cells in range #1 (example)do not change make saved entry go to unused cells underneath the last record, and i dont want to have to start again because i have several complex cost, losses and estimate calculations running off that data being stored their to be able to remember wich i need to change. Can you help -- Dave Peterson |
| All times are GMT +1. The time now is 10:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com