Macro to find specific word in cell and then copy and paste the adjacent cell upwards

[raytej82]

I have a system download that downloads onto a csv file, i open this into excel, however the unique code instead of it appearing downwards in a column for each item it puts the unique code at the bottom of each section.

As there is a large volume of data I require the data to go into a pivot table, however as the code it displayed at the bottom this makes it time consuming to manually copy and paste the code upwards.

Is there a macro code that I can use that search's for 'Branch Plant' in column E and then copy the unique code in F into cell E where there is an 'Item group' present in column E. Each week there will be different number of cells.

See attached file: eg, I require F15 to be shown in E13 and E14, and F30 to be shown in E21 to E29 and so on........

Thanks in advance

[walruseggman]

I'd be interested if someone had a better implementation than this. This is just my first thought, but it should work just fine for you:

Please Login or Register  to view this content.

[PCI]

Try

Please Login or Register  to view this content.

[raytej82]

Amazing, they both work.

Thank you very much, this will save me so much time.

Very happy