Macro help?: move row to other sheet when text is entered in cell

B

BigPapaJon

I have a simple project tracking sheet. When one project is finished
text is entered in Column C (starting in Row 2). I would like to enter
macro that would automatically move this row to the next sheet i
workbook.

Sheet 1 is called Enhancements and Sheet 2 is called Resolved.

I tried to use the AutoFilter, filtering by text that contains "?" (an
character), then copy/paste/delete, but I did not even come CLOSE t
being successful when using the Record Macro Feature.

I am not a total Excel newbie, but I have not had much experience i
using VBA on my own. Help a *-forum newbie-*out
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro: VBA code to move/forward email based on subjects and attachments 0
VB to move entire row to another sheet 1
copy rows from one Data sheet to another sheet based on cell conte 2
Visual to copy format one row down when data entered 1
How To Lookup a full row if it contain a text in a spec coloumn from diffrent sheet? 1
If text then email macro 0
Macro to Combine Data from Multiple Sheets with Cell References 4
Creating form on sheet 1 and having info move to sheet 2 4

Top