Move and delete rows on conditions

[tracktor]

I need to move and delete entire rows base on conditions of cell contents on 2 sheets. There are several thousand records on each sheet. I have attached an excel file to explain this easier. I have it uploaded here and also posted this on Code Cage Forums. I don't know how to upload the file on this thread. Sorry.

http://www.thecodecage.com/forumz/m...ve-delete-rows-conditions.html#post1054986150

 

[hiker95]

tracktor,

What version of Excel are you using?

You will generally get much more help (and faster) in this forum if you can post your small samples (what you have and what you expect to achieve) directly in the forum.

To attach screenshots, see below in my Signature block: Post a screen shot with one of these:

If you are not able to give us screenshots, see below in my Signature block: You can upload your workbook to Box Net

 

[tracktor]

I am using Excel 2010 https://cssp.box.net/shared/5dnx1a2vgv also the link at code cage has the file uploaded there. In my file I have merged cells, this is only an example file, the actual spreadsheets do not have merged cells. You can unmerge them if needed. I just did it to explain what I wanted.

 

[hiker95]

tracktor,

Having a little problem understanding your instructions.

Can we have another workbook on Box.Net that displays what Sheet1 and Sheet2 should look like after the macro.

 

[tracktor]

Here is the workbook After the Macro https://cssp.box.net/shared/r466kl82as

Basically all the rows on Sheet2 of the original file with the astericks in Column G are deleted and on Sheet1 the rows with a minus sign in Column G are moved to Sheet2. Also, Column G will not be in the actual workbook, so you cant use the * or- signs as identifiers.

 

[tracktor]

Here is a more updated sample https://cssp.box.net/shared/r466kl82as

 

[hiker95]

tracktor,

Still having a problem understanding your instructions.

Click on the Post Reply button, and just enter the word BUMP, and then click on the Submit Reply button, and someone else will assist you.

 

[VoG]

Use Excel Jeanie to post before and after shots http://www.excel-jeanie-html.de/html/hlp_schnell_en.php

 

[tracktor]

Does this work with Excel 2010. For some reason I can't find it in Excel.

 

[VoG]

Look on the Add-ins tab.