Please help me write a macro to solve:
Have a table of values B3:G31. If any row that the value of cells between cell A3:A31 = 5 copy that row to I3:O3
file is attached.
Thanks
Please help me write a macro to solve:
Have a table of values B3:G31. If any row that the value of cells between cell A3:A31 = 5 copy that row to I3:O3
file is attached.
Thanks
![]()
Please Login or Register to view this content.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
As there are 6 columns in the range B:G shouldn't the output be I:N, not I:O?
Based on that assumption, the following will do the job:
Regards,![]()
Please Login or Register to view this content.
Robert
Last edited by Trebor76; 10-21-2013 at 01:35 AM.
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
Thank you so much. Yes it should be I:O![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks