How to add a button/function that allows you to add a row of data to a table?

[manicss01]

Hi all,

I'm not the most adept excel user so please bare with me.

I have created a table on excel and want to add a function to the worksheet that allows you to create a new row of data for that table.

I know you can do this using the data entry form but I was wondering whether there was a way to launch that form using a button on the spreadsheet?

All replies will be greatly appreciated.

 

[manicss01]

Why don't you start your table in A1?

I have a header and other functions at the top of the worksheet. I am trying to create a functional worksheet that people can use within my team to update with new tasks, so I want it to be fairly user friendly. The two few rows are made up of buttons (to which i was going to assign the new data row function) and a title for the document.

 

[Andrew Poulsom]

If you select the range and name it Sheet1!Database (changing the sheet reference if necessary) does the VBA code work for you?

 

[manicss01]

If you select the range and name it Sheet1!Database (changing the sheet reference if necessary) does the VBA code work for you?

After I researched the problem online, I tried exactly that Andrew and it worked! Thanks for all your help.