ElectricSkywalker
Board Regular
- Joined
- May 27, 2002
- Messages
- 112
Hi All,
I have recently been asked make a database in Excel. Yes, I know that Access would be the better program to use, but our firm doesn't seem to have enough Access licences, so I need a quick lesson in creating a database in Excel.
Basically, I have started by creating the user forms in VBA. That was the easy part.
However, I have only worked out how to input the data into one cell at a time.
Example:
Name: (Linked to Cell G1)
Sales Date: (linked to Cell H1)
Number of Sales: (Linked to Cell I1)
If the first person enters the data, thats fine, cells G1, H1 and I1 are filled up.
How do I then get the second persons data to go down to Rows G2, H2, and I2......and so on????
Can anyone direct me to any sites or examples on the web that I can get into and have a crack at?? It would be most appreciated,
Cheers,
Greg
I have recently been asked make a database in Excel. Yes, I know that Access would be the better program to use, but our firm doesn't seem to have enough Access licences, so I need a quick lesson in creating a database in Excel.
Basically, I have started by creating the user forms in VBA. That was the easy part.
However, I have only worked out how to input the data into one cell at a time.
Example:
Name: (Linked to Cell G1)
Sales Date: (linked to Cell H1)
Number of Sales: (Linked to Cell I1)
If the first person enters the data, thats fine, cells G1, H1 and I1 are filled up.
How do I then get the second persons data to go down to Rows G2, H2, and I2......and so on????
Can anyone direct me to any sites or examples on the web that I can get into and have a crack at?? It would be most appreciated,
Cheers,
Greg