Deleting rows

[JT]

Our cost centers use a workbook to send data to the corporate office. There
are about 10 columns an one of the columns is used for the amount of the
charge.

Occassionaly, some will either delete an entire line or clear out the 10
columns because they don't want to send the info.

On certain cost centers, there is a hidden sheet to record additional
information. For these specific cost centers, my concern is if they delete
the entire row or clear out the 10 columns, the info still resides on the
hidden sheet.

What I'd like to do is identify when the entire row is selected or the 10
columns are selected and they clear them out, that I identify the row in
question and based on the ref number in another cell delete the line on the
hidden sheet.

I'm having trouble on getting started. What is the best way to accomplish
this? Is it a worksheet change event? cells change event?

Any help or suggestions would be greatly appreciated. As always, thanks for
the help. This is a terrific resource....

 

[smartin]

Our cost centers use a workbook to send data to the corporate office. There
are about 10 columns an one of the columns is used for the amount of the
charge.

Occassionaly, some will either delete an entire line or clear out the 10
columns because they don't want to send the info.

On certain cost centers, there is a hidden sheet to record additional
information. For these specific cost centers, my concern is if they delete
the entire row or clear out the 10 columns, the info still resides on the
hidden sheet.

What I'd like to do is identify when the entire row is selected or the 10
columns are selected and they clear them out, that I identify the row in
question and based on the ref number in another cell delete the line on the
hidden sheet.

I'm having trouble on getting started. What is the best way to accomplish
this? Is it a worksheet change event? cells change event?

Any help or suggestions would be greatly appreciated. As always, thanks for
the help. This is a terrific resource....

Hi JT,

Is there a way you can base the data in the hidden sheet on the /data/
on the user sheet, rather than by specific rows or columns? E.g., by
creating a series of lookup formulas?

Could you provide an example of how these two worksheets are related?