input table

Hi all,

I am really stuck on a project I am doing. I
In sheet1 I have an input table consisting of 2 rows and 4 columns, this is for the user to be able to put the required information in. Then either on a click of a button i.e a macro, or some formulae, the input data is copied over to the databasr in sheet 2. I need this to work so that each time a new record can be added to the database.

Hope some one can help!!

Thanks

n

Hello Newo,

You will need to edit this macro to match the input range you are using, and enter the first cell of where the records begin. What needs to changed is highlighted.

Please Login or Register  to view this content.

How to Install the Macro:
1) After making the changes to the code, copy it using CTRL+C.
2) Right Click on any Worksheets name tab.
3) Press the keys ALT+I to bring up the Insert Menu.
4) Press M to insert a code module.
5) Paste the macro using CTRL+V.
6) Save it using CTRL+S.

Now you add a button to your worksheet and assign AddRecord as the macro to run. When the button is clicked, the data in the input range is copied.

Sincerely,
Leith Ross

Fantastic stuff thanks for that!!!