Hi All -
I would like to search my first sheet "MP List" in columns C, E and F for two pieces of text "cost" and "cc" and if they exist(does not have to be unique, as long as "cost" or "cc" appear in any cell in those 3 columns, copy the entire row (Columns A:S) to a new sheet called "Cost" and delete them from the original sheet.
Can someone help me with this?
Most of what I've seen does not specifically search a few columns, it either searches 1 column or the entire sheet's cells.
Last edited by mag1c; 07-17-2018 at 11:41 AM.
Hi !
An easy beginner way : using a filter or an advanced filter …
You're absolutely right, however this is something we do weekly so it would be nice to automate. I was attempting to alter Jindon's code from another thread but don't seem to be having any luckOriginally Posted by Marc L
Please Login or Register to view this content.
Please do not quote the whole just previous post as it's just clutter !
As any filter or advanced filter can be used in a VBA procedure …
Just activate the Macro Recorder and operate manually : you will get your own code base !
In case of an optimization need, post the generated code here.
Or at least attach a workbook with a source worksheet and an expected result worksheet
with an explanation of your need accordingly …
Thank you,
the issue I have with using the Macro Recorder is that when I filter based on the word "cost" , I need to copy the entire row for any cell in that row that contains "cost" and paste it into a new sheet, then delete the the rows on the main sheet.
The Macro creates a range of these specific rows I select and isn't repeatable because the word "cost" will not always appear in the same row, thus using the macro recorder will not bring the correct information guaranteed each time.
Do you mean filter any row that have "cost" in any column?
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