If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
URGENT!!! shared workbook
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 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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
protecting shared workbook | G | General Discussion | 2 | June 9th, 2006 04:37 PM |
Can I add field validations in a shared workbook ? | Arun | General Discussion | 1 | May 2nd, 2005 12:00 PM |
My Shared workbook is driving me crazy!!! | Paul. | General Discussion | 1 | April 15th, 2005 11:56 AM |
Customer Unable to Edit a Shared Workbook | Lisa | General Discussion | 0 | February 17th, 2005 02:57 PM |
Shared Workbook problem! | skc | Worksheet Functions | 0 | March 23rd, 2004 11:11 AM |