Newbie & linked wordksheets = mass confusion

Originally Posted by keithl816

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!

Hi Trudy,

Before closing the data form, hit the enter key after you enter your data for that row.

Larry