Simon_Price
09-17-2009, 06:51 AM
Good Afternoon,
Before I begin I am not working in my prefered method to create a database....
I have been asked by my company to create a database that acts similar to MS Access, but in MS Excel 2007.
What I am looking for is the method on how to create the Record Set(s)
for example,
Data entry sheet
Cell A1 First Name
Cell B1 Second Name
Cell D1 Role
Cell E1 Department
Cell A3 Course Date
Cell B3 Course taken
I then want the user to click a 'Save' Button which will then transfer this information from from teh Data Entry Sheet into the Record Set where Row 1 is the headers in A, B, C, D and then from Row two downwards is contains the information in a very large table.
Can anyone help me please.
Your time and efforts are all appreciated.
Kind regards
Simon
Before I begin I am not working in my prefered method to create a database....
I have been asked by my company to create a database that acts similar to MS Access, but in MS Excel 2007.
What I am looking for is the method on how to create the Record Set(s)
for example,
Data entry sheet
Cell A1 First Name
Cell B1 Second Name
Cell D1 Role
Cell E1 Department
Cell A3 Course Date
Cell B3 Course taken
I then want the user to click a 'Save' Button which will then transfer this information from from teh Data Entry Sheet into the Record Set where Row 1 is the headers in A, B, C, D and then from Row two downwards is contains the information in a very large table.
Can anyone help me please.
Your time and efforts are all appreciated.
Kind regards
Simon