Restrict data entry to specified cells

[ajsguinness]

Hi, I'd like to be able to restrict new data entry to specified cells in a
workbook. I'd like a method to say where data should be added, and then for
that to be inserted at the top of the column of entries, e.g. button or
similar for "click here to add data" or something similar which then opens a
dialogue box where data is added. When click finished or close, the new data
should be automatically added to the top of the list. Is that possible?

 

[Luke M]

For the cells you want data inputted into, format cell, protection, uncheck
the "locked" box. Protect the worksheet (Tools - Protection - Protect sheet.
Now, record a macro of you unprotecting worksheet, copying/moving the data
from those cells to the top of your list (using insert row, paste, etc.
Whatever works best). Before stopping macro, protect workbook again.

Next, using the Forms toolbar, you can create a button and assign your macro
to it. Alternatively, if you're creative, you can draw a shape from the
drawing toolbar and also assign a macro to it.

 

[ajsguinness]

Thanks Luke.

Andy

For the cells you want data inputted into, format cell, protection, uncheck
the "locked" box. Protect the worksheet (Tools - Protection - Protect sheet.
Now, record a macro of you unprotecting worksheet, copying/moving the data
from those cells to the top of your list (using insert row, paste, etc.
Whatever works best). Before stopping macro, protect workbook again.

Next, using the Forms toolbar, you can create a button and assign your macro
to it. Alternatively, if you're creative, you can draw a shape from the
drawing toolbar and also assign a macro to it.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*