Board,
I have the following spreadsheet that I have to manipulate each month for payments to contractors. The sheet lists all the insurance policies under each agent/contractor. The number of policies for each contractor varies greatly.
I have to download it then do the following:
delete some blank lines (they vary as to where they are in the sheet)
delete some lines with content that is not needed (again they vary as to how many and where they are located)
Insert 2 columns (one of which is the current date)
2nd column will contain the name and production number of each agent
- the agent's name is listed in the first line above all of his/her policies
----------cell 1 cell 2 cell 3 cell 4 cell 5 cell 6 cell 7
line 23 - -- -- -- -- -- -- Agent Name
line 24 - -- -- policy #1 data data data data
line 25 - -- -- policy #2 data data data data
line 26 - -- -- policy #3 data data data data
line 27 - -- -- policy #4 data data data data
et cetera -- represent blank cells
I would like to automate the moving of the Agent name from line 23 cell 7 in the example above to line 24 cell1, line 25 cell1, line 26 cell1, line 27 cell1, etc. So that each policy will have the agent's name beside each policy they wrote.
I was not sure of how to search this particular need, so I wanted to provide a visual idea. I doubt macros could do it because the number of policies varies and the number of lines I need delete varies.
Curious if someone could suggest a way or point me in the right direct. Thanks in advance to reading and any suggestions provided.
I have the following spreadsheet that I have to manipulate each month for payments to contractors. The sheet lists all the insurance policies under each agent/contractor. The number of policies for each contractor varies greatly.
I have to download it then do the following:
delete some blank lines (they vary as to where they are in the sheet)
delete some lines with content that is not needed (again they vary as to how many and where they are located)
Insert 2 columns (one of which is the current date)
2nd column will contain the name and production number of each agent
- the agent's name is listed in the first line above all of his/her policies
----------cell 1 cell 2 cell 3 cell 4 cell 5 cell 6 cell 7
line 23 - -- -- -- -- -- -- Agent Name
line 24 - -- -- policy #1 data data data data
line 25 - -- -- policy #2 data data data data
line 26 - -- -- policy #3 data data data data
line 27 - -- -- policy #4 data data data data
et cetera -- represent blank cells
I would like to automate the moving of the Agent name from line 23 cell 7 in the example above to line 24 cell1, line 25 cell1, line 26 cell1, line 27 cell1, etc. So that each policy will have the agent's name beside each policy they wrote.
I was not sure of how to search this particular need, so I wanted to provide a visual idea. I doubt macros could do it because the number of policies varies and the number of lines I need delete varies.
Curious if someone could suggest a way or point me in the right direct. Thanks in advance to reading and any suggestions provided.
Last edited:
