Copy and paste data in a different format

[fabian_76]

Hi guys,

Hopefully some one can give a hand with this. Attached you can find a file where I have a sample of my daily tasks.

The data on the source part may be up to 150 rows, columns are always the same.

Thank you in advance.

[jindon]

Try

Please Login or Register  to view this content.

[fabian_76]

Jindon thank you so much, it worked like a charm. I am new on this, could you please comment out in each line so I can enrich my knowledge and in case things change I can adjust the code to my needs?

Regards,

[jindon]

1) Loop through the cells that are Numeric value in col.A
2) Cut 1 row below and one column to the right and paste to 2 columns to the right.
3) Delete the row that have enpty in Col.A.
4) Find " (*" and replace with "" in col.E. You have space that is not a "space", but ChrW(160)
5) Clear Col.F to Col.J

HTH

[fabian_76]

Jindon,
People like you make these forums worthwhile add value to other people.

Thanks,

[jindon]

You are welcome and thanks for the rep.