New to macros

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What I'd like to do, if possible:

Say the field in column "A" equals "complete"

Then cut entire line and paste it in the next available line of a new
spreadsheet and delete the old line from the original sheet.

This is a project management worksheet. I want to be able to totally remove
an item from the "To Do" sheet and place it on the "Complete" sheet.
 
One way is to use data>filter>autofilter>filter on complete>copy/paste to
new>delete>unfilter. Record a macro while doing.
 
You must log in or register to reply here.

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

Run two macros for two different sheets 11
Error Message - Macro to Unlink MS Queries from Workbook 0
Macro to copy A1 tp J(bottom) 1
Macro to combine worksheets 10
Playing back a Pivot Table macros 2
Macro for all Excel Workbooks to print to PDF 2
Macro to Call A Subroutine on a Sheet Sometimes stops? 1
Get info from second sheet 3

Back
Top