Macro to copy specific entries and adjust value based on a table

[Seraph122]

Hi All,

Happy Holidays everyone!!

I could use some help with the following goal. In the attached file, I have an Import tab that shows 5 columns. I need a macro that only copies entries where the value in column D is equal to one of the values in the Adjustment Table tab.

So in this case, whenever a row with a value G, H, or J in column D, the macro copies the row into the Export tab, and adjusts it based on the value next to the adjustment name. So in this case, all entries with "G" in column D will have their "E" column adjusted with an increased 2.2%, and placed into the Export tab.

I think the example in the attachment will make more sense.

Can anyone assist me with this?

Thank you!

[jeffreybrown]

How about

Please Login or Register  to view this content.

[smuzoen]

You could use something along these lines.

Please Login or Register  to view this content.

See attached workbook

[Seraph122]

Thanks for both of your responses! I have tested them and they both work great!

I have one quick question, is there an easy way to sort the macro output in the Export tab after it has finished generating the lines? Smuzoen, I noticed your macro automatically sorts the output entries by the Name order, which is great. If the need came up for example, could I sort it first by Name and then by Store and then by Date?

Thank you both again!

[smuzoen]

It was only a coincidence that it sorted by Name as your workbook was sorted. I added an extra sub to sort however I was not sure which column was Store - I assumed column C was store so you will need to adjust sort macro as required. I added code to clear the output from Export sheet prior to data being copied across as well. See attached workbook V2.

[Seraph122]

This is excellent!!

Thank you so much smuzoen!