URGENT!!! shared workbooks

[Guest]

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

 

[David McRitchie]

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/[email protected]

 

[Guest]

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?????????

 

[Guest]

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?????????????

 

[David McRitchie]

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.

 

[Dave Peterson]

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.