Don't overwrite a row

[Guest]

I have an Excel worksheet that is write-protected. (The original owner
wanted us to enter the information, print it, and then close without saving,
thereby deleting the electronic version of the data and keeping only the
printed version.) This doesn't make sense to my boss and she wants to be
able to keep some of the data. The information we want to keep can be stored
in another workbook or even in another program (Access?), whichever is
easiest.

I've tried to set things up to simply link the data from certain fields into
a new workbook. It surprised me that this seemed to work, even though the
original data disappeared when the original workbook was closed without
saving. But I'm having trouble because when entering the data into my new
workbook, I can't figure out how to keep it from overwriting a row that was
already entered. It wants to put everything in Row 1. I can't figure out
how to tell it that if Row 1 has data, go to Row 2, etc. It will always be
taking data from the same reference point in the read only document (because
they've erased the earlier data when they closed without saving), but I want
to copy into subsequent rows in my 2nd workbook.

Can someone please help me figure out how to save the data? Is my idea the
best way to accomplish what I want?

Also, there will be about 10 people entering the "disappearing" data, and
they'll be entering this data over a period of several months. I figured I'd
have each of them keep their own 2nd workbook of saved data, and merge them
together later. Is there a way to have everyone work on one shared file, and
keep all the "kept" data in one workbook? We're using Excel 2002 on Windows
ME.

 

[Guest]

In relation to your questions,..

Part one -- This would be most effective using a VB Macro -- do you know any
Visual Basic?

As for the second part, you can set the workbook to a shared workbook
"Tools>Share Workbook". This will allow multiple users ot enter data onto
the workbook, but only one saved version. The trick is in them not putting
information into the same space i.e. assign a worksheet to each user that
they and only they use.

Let me knwo if you need help with the VB for part one

 

[Guest]

No, I'm not much good with Visual Basic. Can someone help me with this?

 

[Dave Peterson]

How about this interpretation:

You have a worksheet that contains your data entry form. You put a button from
the forms toolbar on that worksheet.

When the user clicks that button, values from certain cells are copied to the
next available row in a history worksheet in the same workbook.

When the user saves the workbook, his/her data is saved. If the user doesn't
save (just testing/screwing around (or even made a mistake)), no data is saved.

If that sounds like an option, here's a link to a similar post:

http://groups.google.com/[email protected]

 

[AlfD]

Hi!

Are you still stuck with this write-protected workbook or have yo
rewritten it or what?
And by write-protected do you mean it has password protection or tha
its file is write-protected?


Al