I already have a macro that finds and copies the first row any record in a column to the next column.
I require some help to select say DATA CA001/10 in the records and copy to a new column.
Please refer to the attached example.
Thanks David
I already have a macro that finds and copies the first row any record in a column to the next column.
I require some help to select say DATA CA001/10 in the records and copy to a new column.
Please refer to the attached example.
Thanks David
If I understand what you are after correctly this macro will do what you want.
If you require it to search for multiple instances then try activating the do Loop commands that are disabled within the macro
![]()
Please Login or Register to view this content.
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
Hi, I think the following does what you want. Run the 'CopyRecordsMain' procedure - it will automatically call the other one.Originally Posted by das15hild
![]()
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks