00:00This is how we create a simple data entry tool where you can enter data on this cell
00:04here.
00:05Well, let's call it the data entry cell and you have a button here.
00:08When you click this button, this data entry data end up in your database or your table
00:13below.
00:14First, click on developer tab.
00:17If this developer tab is not available, right click anywhere on your ribbon here and select
00:21customize the ribbon.
00:23And in this Excel option pop up window here, click on customize ribbon if it's not selected
00:28yet and make sure that your developer is checked.
00:31Once that's done, click OK and your developer tab should be available.
00:35And then next thing you'll have to do is to click on record macro, give it a name, I'm
00:40going to call it macro 17 and click on OK.
00:43The first thing you'll have to do is to select the very first row on your table like this
00:47and then press control shift plus and select shift cell down and click OK.
00:54What this does is that it inserts a new row for you.
00:57Next, you select the data entry cell like this.
01:00Press control C to copy the clipboard.
01:03And then select A10, the very first row on your table.
01:08Right click and then select transpose from the context menu like this and select it.
01:14What it does is that it copies the data entry data into the very first row.
01:19Now you're going to copy the format.
01:21Select the second row like this and then go to home clipboard format painter.
01:27And then next thing you'll have to do is click on A10 so that the new row looks exactly like
01:32the second row.
01:33Once that's done, go to a developer and stop your recording.
01:36You can also stop recording from here if you like.
01:40Once the recording is stopped, let's insert a new button so that you can click on it and
01:45add a new row.
01:46Click on insert and you'll be selecting this button here.
01:51And insert the button by just drag dropping the button.
01:54And then you'll be able to associate the button action with macro 17 which we just created.
01:59And click OK.
02:01And now every time you press button 7 or your insert button, you can see whatever you have
02:06entered in here get added to your database here.
Comments