View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
YESHWANT JOSHI[_2_] YESHWANT JOSHI[_2_] is offline
external usenet poster
 
Posts: 42
Default Automatically move data from one worksheet to another

"In Progress" worksheet. type the following formula. To start with let's say
A2
=if(celladdress="C","In Progress worksheet!a2,"")
in this "celladdress" address means address of column which contains "C" if
completed on that row and also do not forget to put $ before column, e. g.
$K2)
then copy the same to right as far as u want, and down as far as u want
then apply filter for nonblanks
and u will be home with your desired results

click yes below, if it works

"CdnBlueEyes" wrote:

I have an excel file that is tracking projects completion and status. Within
the file I have 2 worksheets ("In Progress" and "Completed"). Within the "In
Progress" worksheet, I have columns capturing the project name, assigned
date, assigned by, estimated completion date, comments, etc. I also have a
column that has an IF statements and adds the letter C when the completed
date is entered. I wanted the whole row to transfer over to the "Completed"
worksheet when this C appeared on the "In Progress" worksheet. Is this
possible??? I am not very good with macros :(