ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   I need a macro to find cut and paste data to new cell (https://www.excelbanter.com/excel-discussion-misc-queries/1281-i-need-macro-find-cut-paste-data-new-cell.html)

Rex

I need a macro to find cut and paste data to new cell
 
I have data that I have imported to excel which I need to reformat to be able
to create a pivot table. The data is in journal form with the comment sitting
in column D above the journal number. I need a macro to find cut and paste
the comments from column D to column C. The comments are not all the same but
do contain a common word such as "To" and as the journals are not all the
same size the comment does not appear at regular intervals. Any help
appreciated as I am new to VBA.


All times are GMT +1. The time now is 06:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com