VBA copy and past to different cell

[namluke]

Hi i have this data ( Device:[Hc1 3300 Trunk1] P776 - Mecca Cash Out) in cell d3, what i need is my macro to refer to that cell and bring back the text after the dash and paste to another cell.

For example, if it had that text in d3 then the macro runs it puts just Mecca Cash Out in D2.

Thanks in advance

[AndyLitch]

This macro will put the formula into the cell

Please Login or Register  to view this content.

[namluke]

Im having trouble sloting it in, it needs to go around the bold text, any advice?

Please Login or Register  to view this content.

[AndyLitch]

Advice .. yes... Tell management to stop being idiots...It's not about timing - it's about productivity.