example.xls
Hi, Was hoping somebody on here could help me write up a macro. little experience with excel.
Attached is an example spread sheet, data is always changing. What I would like to acheive is to search column C for "TRUE", copy columns a, b, c, d for all rows with "true" and move them to start in G3. Repeat search for "False" and move to start in M3. Repeat search again for "Not assigned" and move to start in S3.
Try this...
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thanks for the reply AlpahFrog! Works good except it is not deleting the rows in colums A-D that have been copied and pasted.
Last edited by adammss; 10-14-2013 at 04:22 PM.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks