I'm looking for a macro that extracts rows from SHEET1 (without deleting them) and puts them into SHEET2 based on the contents of the cells in column H. In addition it should delete columns containing the words HHA, HHB or HHC in ROW 4 in the newly created SHEET2.
How is this possible with a macro?
Thanks in advance!
Last edited by Allerdrengen; 07-06-2017 at 07:57 AM.
Hi Allerdrengen
What is the criteria?based on the contents of the cells in column H
Good Luck...
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
Also....Add a comment if you like!!!!
And remember...Mark Thread as Solved...
Excel Forum Rocks!!!
Hello
If the word "Rotant" is present
Just a correction. The columns to be deleted should also be based on cell contents for ROW 4
And that is.............................The columns to be deleted should also be based on cell contents for ROW 4
If a cell in row 4 contains either HHA, HHB or HHC, it should delete the entire column.
Gonna have to be more specific....The code needs to be written to accommodate...
Row in which sheet....
Which column is the cell in.....
referring to Columns F,O,Pit should delete the entire column
SHEET2 should extract the ROWS from SHEET1 that contains the word "Rotants" in its corresponding cell in column H. Then the code should delete all columns containing the words "HHA", "HHB" or "HHC" in its corresponding cell in ROW 4 (This step happens in SHEET2).
Hope it clears it up
If I understand correctly....
For each cell in Sheet2.Row4 If cell contains words "HHA", "HHB" or "HHC" then that column that cell is in must be deleted....
Ideally you should upload a sample file so that we can test our code on...
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