keithl816 Wrote:
Hi Trudy,

I found that the same problems arose when I did the same thing,
Basically what I did was made a Main Sheet that had a command button
that brought up a data form for the different sheets that hold data. In
that data form you would be able to add info delete info without
disturbing the cells that would affect the sheet with all of your
formulas. If you would prefer to just bring the form up on the sheet
with your data just simply click on cell a1 and go to Data/Form. It
will not work if you have any merged cells. If you have mergerd cells
you will probably have to do something different.

If you would like to create a command button for bringing the form up
let me know and I'll try to guide you through it.

Hope this helps,

Larry

I could definitely use more help. I've been reading about data forms.
Typical of a newbie, I tried the last of your suggestions, made lots of
changes - and then cliked "Close". Nnone of the changes were saved. I
think I need to look more clearly at my options before closing a
window!



--
lburg801
------------------------------------------------------------------------
lburg801's Profile: http://www.excelforum.com/member.php...o&userid=28338
View this thread: http://www.excelforum.com/showthread...hreadid=480391