Gliderprincess
New Member
- Joined
- Aug 8, 2019
- Messages
- 1
Hello all!
I have a database management query that has to be done in Excel (even though it would be easier in Access)
How would I go about entering data into a 'form' or cells that will then keep a record of all of these in one sheet, but also populate into a sheet depending on the value in a particular cell?
ie:
Sheet 1 - Data Entry
Job title: A, B, C, D... (Selection via list)
Name: Free text
Sheet 2 - Record of all entries
Job title - (All entries from Sheet 3+)
Member Name - (All entries from Sheet 3+)
Next Training requirement (From sheet 3+)
Sheet 3+
Job title - A/B/C/D
Member name (Carried over)
Training requirements (to mark off as they go)
It's a copy/paste issue, however seems difficult (to me) to program as it is dependant on the entry within a particular cell (B6). Can this be done as an If...Then function? Can it automatically update sheet 2, with the data from sheet 3+ without having a heap of blank entries?
Thanks in advance for your help!
~GliderPrincess~
I have a database management query that has to be done in Excel (even though it would be easier in Access)
How would I go about entering data into a 'form' or cells that will then keep a record of all of these in one sheet, but also populate into a sheet depending on the value in a particular cell?
ie:
Sheet 1 - Data Entry
Job title: A, B, C, D... (Selection via list)
Name: Free text
Sheet 2 - Record of all entries
Job title - (All entries from Sheet 3+)
Member Name - (All entries from Sheet 3+)
Next Training requirement (From sheet 3+)
Sheet 3+
Job title - A/B/C/D
Member name (Carried over)
Training requirements (to mark off as they go)
It's a copy/paste issue, however seems difficult (to me) to program as it is dependant on the entry within a particular cell (B6). Can this be done as an If...Then function? Can it automatically update sheet 2, with the data from sheet 3+ without having a heap of blank entries?
Thanks in advance for your help!
~GliderPrincess~
