If a column contains a duplicate, then fill another column with the value.

Hi,

Currently I'm manually adding data from a sales figure list into our annual testing log which can take hours.

I'm wondering if there is a macro or something that would help me do it?

What I need to do is, when column C "part code" contains a duplicate then Column V to AG "Months" copies the value into the empty duplicate cell above.
Sales Figures.JPG


Hopefully this makes some sense and the attachment worked?

Kind Regards
David

Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

1. Make sure that your sample data are 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 data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as 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.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

Sorry - I can't see what is clearly obvious to you. What should be appearing based on your request and where?

Just give us a manually mocked up version of what you want with the manually mocked up cells highlighted in yellow - it will be so much easier than trying to visualise what you mean.

Where is the yellow value coming from? How many rows could potentially be duplicated?

welcome to the forum. i suggest you do an example like how i did below. i did a Before and an After. you may read more about good samples in my signature link.

i am guessing you want to move the value up and remove the value in the row it was duplicated. so maybe:

Please Login or Register  to view this content.

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button