do you run macros on your sheet..?
if so ..please post your code so we can help you.

this NG is about programming excel not just using it..

data doesnt get corrupted by itself, without further info it's a bit
hard to guess.


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Bruccce" wrote:

Unfortunately (sp?), this is not the issue....
I very rarely delete, and I always insert at the bottom. When I do
delete, I always click on the row...


Thanks,
Bruce
"keepitcool" wrote in message
...

could it be following:


you're inserting/deleting CELLS?.
BUT
you haven't selected an ENTIRE row or column.

if you do that the cells below the selected cell get shifted down and
your "records" get corrupted.

Make sure that BEFORE you insert or delete rows/columns, either
manually or with VBA you select entire rows (shift-space) or entire
columns (ctrl space)

if you do it via VBA..
THIS is what HELP says.. please note what they say about the shift
parameter...



Insert Method
See Also Applies To Example Specifics
Insert method as it applies to the Range object.

Inserts a cell or a range of cells into the worksheet or macro sheet
and shifts other cells away to make space.

expression.Insert(Shift, CopyOrigin)

expression Required. An expression that returns a Range object.

Shift Optional Variant. Specifies which way to shift the cells. Can
be one of the following XlInsertShiftDirection constants:
xlShiftToRight or xlShiftDown. If this argument is omitted, Microsoft
Excel decides based on the shape of the range.

CopyOrigin Optional Variant. The copy origin.



Hope this is it.. can't undo the existing corruption, but at least
you can avoid it in future...


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Bruccce" wrote:

I have a spreadsheet that I keep getting info from different rows
on to the wrong rows. This has happened several times.
I first thought (and I really try to be very careful not to do
this!) that I sorted some of the rows with out including all of the
rows. I always try to click on the upper left hand square before
doing any sort!

What can I do to prevent this data corruption, or make it so I can
recover my data?
I am thinking about a extra spreadsheet and anytime the data is
changed in a row, that the whole row be copied to this spreadsheet.
Would this work? any other ideas?

I have just lost about 9 days worth of calls (about 7 hours a day)
due to this corruption. I do have some backups, but I don't know
when the data got corrupted.

HELP!
Thanks
Bruce