kdashsohel
New Member
- Joined
- Jul 27, 2017
- Messages
- 9
Hello everyone,
I am fairly novice in terms of Macro and VBA. I work for immigration, and my supervisor had given me quite a huge task. I have a spreadsheet where I have to put information of a person's background and its family size. My problem is I am unable to figure out how to automatically create the number of rows once the family size has been inputted, also how to assign a number for each group of family created. For example below,
*(red means input, pink means automatic computerized input)*
<tbody>
</tbody>
Then
<tbody>
</tbody>
Then
<tbody>
</tbody>****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
<tbody>
</tbody></body>
Then
<tbody>
</tbody>
Then
<tbody>
</tbody>
Then
<tbody>
</tbody>
I am probably asking too much since I am new in this forum. Any help is greatly appreaciated.
*Note that my work environment involves two languages, English and French. I am working on an english computer station, but the majority of my colleagues are working in a french computer station. I am not sure if the VBA language will impact how excel works once shared in a different station.*
Once again thanks to anyone who is willing to take their time in helping me out!
I am fairly novice in terms of Macro and VBA. I work for immigration, and my supervisor had given me quite a huge task. I have a spreadsheet where I have to put information of a person's background and its family size. My problem is I am unable to figure out how to automatically create the number of rows once the family size has been inputted, also how to assign a number for each group of family created. For example below,
*(red means input, pink means automatic computerized input)*
# | # of Family | First Name | Last Name | ID | Family Size |
1 | Dennis | Smith | 123 | 4 | |
2 | Keith | John | 456 | ||
3 | Damian | Doe | 789 |
<tbody>
</tbody>
Then
# | # of Family | First Name | Last Name | ID | Family Size |
1 | 1 | Dennis | Smith | 123 | 4 |
2 | 1 | ||||
3 | 1 | ||||
4 | 1 | ||||
5 | Keith | John | 456 | ||
6 | Damian | Doe | 789 |
<tbody>
</tbody>
Then
# | # of Family | First Name | Last Name | ID | Family Size |
1 | 1 | Dennis | Smith | 123 | 4 |
2 | 1 | Jane | Smith | 741 | |
3 | 1 | Mark | Smith | 852 | |
4 | 1 | Julie | Smith | 963 | |
5 | Keith | John | 456 | 1 | |
6 | Damian | Doe | 789 |
<tbody>
</tbody>
# | # of Family | First Name | Last Name | ID | Family Size |
1 | 1 | Dennis | Smith | 123 | 4 |
2 | 1 | ||||
3 | 1 | ||||
4 | 1 | ||||
5 | Keith | Joe | 456 | ||
6 | Damian | Doe | 789 |
<tbody>
</tbody>
Then
# | # of Family | First Name | Last Name | ID | Family Size |
1 | 1 | Dennis | Smith | 123 | 4 |
2 | 1 | Jane | Smith | 741 | |
3 | 1 | Mark | Smith | 852 | |
4 | 1 | Julie | Smith | 963 | |
5 | Keith | John | 456 | 1 | |
6 | Damian | Doe | 789 |
<tbody>
</tbody>
Then
# | # of Family | First Name | Last Name | ID | Family Size |
1 | 1 | Dennis | Smith | 123 | 4 |
2 | 1 | Jane | Smith | 741 | |
3 | 1 | Mark | Smith | 852 | |
4 | 1 | Julie | Smith | 963 | |
5 | Keith | John | 456 | 1 | |
6 | Damian | Doe | 789 | 2 |
<tbody>
</tbody>
Then
# | # of Family | First Name | Last Name | ID | Family Size |
1 | 1 | Dennis | Smith | 123 | 4 |
2 | 1 | Jane | Smith | 741 | |
3 | 1 | Mark | Smith | 852 | |
4 | 1 | Julie | Smith | 963 | |
5 | Keith | John | 456 | 1 | |
6 | 2 | Damian | Doe | 789 | 2 |
7 | 2 | Maryam | Doe | 951 |
<tbody>
</tbody>
I am probably asking too much since I am new in this forum. Any help is greatly appreaciated.
*Note that my work environment involves two languages, English and French. I am working on an english computer station, but the majority of my colleagues are working in a french computer station. I am not sure if the VBA language will impact how excel works once shared in a different station.*
Once again thanks to anyone who is willing to take their time in helping me out!