CutandPaste01
New Member
- Joined
- May 7, 2002
- Messages
- 3
I've got a spreadsheet where the user enters information about an organisation including one cell where they enter the total number of employees. This is on one worksheet "Organisation"
I then want them to enter information about each employee on another Worksheet "Employees". This information will be in rows and only numbers will be stored:
Employee1:Info1:Info2:Info3
Employee2:Ino1:Info2:Info3
and so on.
At the bottom of each column I want to add the totals. I don't need to pull in any info about the employee as the user can overtype Employee1 etc.
What I want to do is after entering the number of employees in the cell I want the same number of rows to be automatically generated so that there is a row for each employee. This could be done from a button.
I'm totally new to Excel VBA so any help would be appreciated!
I then want them to enter information about each employee on another Worksheet "Employees". This information will be in rows and only numbers will be stored:
Employee1:Info1:Info2:Info3
Employee2:Ino1:Info2:Info3
and so on.
At the bottom of each column I want to add the totals. I don't need to pull in any info about the employee as the user can overtype Employee1 etc.
What I want to do is after entering the number of employees in the cell I want the same number of rows to be automatically generated so that there is a row for each employee. This could be done from a button.
I'm totally new to Excel VBA so any help would be appreciated!