How to insert a new role if the content in the cell is different value

A blurry screenshot is of no use.

Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

1. Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution is also shown (mock up the results manually).

3. Make sure that all confidential information is removed first!!

4. Try to avoid using merged cells. They cause lots of problems!

Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

I asked for an Excel sheet... not for another picture of one.

OK. Now I can see what is happening!!! I just don't understand your request...

In E2 there is the value 002A. Which cell am I supposed to be comparing this to? What do you want to see in which cell??


You really are not doing very much to enable me to help you!!

I looked at this yesterday... and still didn't understand what you want. I've looked again now and can see what you need. I doubt if it can be done without VBA. My suggestion to you is that you mark this thread as solved and start a new one in the VBA sub-forum. Attach a file with 2 sheets in your new post. One with your raw data and another with 10 or so rows showing the desired results that way, it will a) be in the best place to get an answer and b) have zero replies, which is very often the first thing that we look for when we are wanting to find a problem to solve.

Regards,

Glenn

Hi Sasoona,

Thanks for your solution. That will solve the problem. I think I also want to know how to do it using VBA.
If I want to do multiple excel files, I think I need VBA.

Hi Glenn,
Please guide me how to do it in VBA.
The link in VBA forum >> https://www.excelforum.com/excel-pro...ml#post4657695

Sasoona. 1. I didn't see your answer until now. 2. I am roaming on a very slow metered connection and am not going to download a 1 Mb file. 3. I would not download a pdf anyway, This is an Excel Forum. Why not attach an Excel file?

Archimedes 79. I don't use VBA. That is why I suggested you close this thread and start another.
Glenn