Macro to create a database

Sheet full of nothingness or invisible font ??????

Sorry. Added a new sheet now.

give this a try - macro on button

Hey, This works perfectly. Thanks.
However, I am trying to do the same in a work file. I see you have not added any macro. There is a code in VBA. I tried to replicate it. Changed cell references. But doing just that didn't work. Can you guide me step by step?
First add a blank table with headers on sheet1?
Then insert button? But you didn't assign any macro to it. I am sorry I have no background in macros and coding.

see forum rule 2.
this enables anyone helping you to copy your code and any formatting.
if you just type it in the post it could be full of typos (errors) which causes added confusion
I will reply when you have edited your previous post

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

Hey, It's done. Sorry for that.

is your code in Sheet1 module ?
failing that upload your workbook it is then a lot easier to see what is wrong.
follow big yellow banner for instructions - how to upload - paperclip attachment does not work

Hey, I have attached the work sheet. I want to add a submit button that will add Sr. No., Date of pressing the button, Weave (C2),
Construction (C3) & Greige Fabric Cost Total (I12) in the Database sheet table.
So, every time you enter a new weave and construction, all the info along with
calculated cost should get added to the next sheet table creating a database.
Thank you.

attached file - code on SUBMIT button - in Sheet1 module.
note file now saved as a macro enabled workbook.