Not sure how to search for this answer?

rtwhbw123

New Member
Joined
Sep 2, 2014
Messages
10
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.
 
Last edited:

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
rtwhbw123,

Welcome to the MrExcel forum.

1. What version of Excel and Windows are you using?

2. Are you using a PC or a Mac?


We can not tell by your text display what cells, rows, columns your raw data is actually in.


So that we can get it right the first time:

Can you post a screenshot of the actual raw data worksheet?

And, can you post a screenshot of the worksheet results (manually formatted by you) that you are looking for?

To post your data, you can download and install one of the following two programs:
1. MrExcel HTMLMaker20101230
https://onedrive.live.com/?cid=8cffdec0ce27e813&sc=documents&id=8CFFDEC0CE27E813!189

Installation instructions here:
http://www.mrexcel.com/forum/board-announcements/515787-forum-posting-guidelines.html#post2545970

2. Excel Jeanie
Download


If you are not able to give us screenshots:

You can upload your workbook to Box Net,

sensitive data changed

mark the workbook for sharing

and provide us with a link to your workbook.
 
Upvote 0

Forum statistics

Threads
1,213,556
Messages
6,114,284
Members
448,562
Latest member
Flashbond

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top