if a1= active, copy a2-a6 to a1-a5 on sheet2 Closed

Question

Hello,

I am new to macros and would like to know if it is possible to create something to do the following:

I have a list of jobs that are either active or inactive (sheet1,column A) and if the job is active, i would like copy the information in that row (sheet1, a2-a6) onto a second sheet (sheet2,a1-a5) I would like it to then move to the next row and do the same for approximately 30 rows. 

Is this possible?


Thanks in advance,

Batman

venkat1926 · Answer

can be done but some clarification is required 

suppose A1 has column heading "job activity"

A2 down have entries"active" or "non active". 
suppose A2 has entry "active" what are entries in A3,A4,A5,A6,A7. do you want A2:A6 to be copied or A3 to A7.
can you post  the first 10 entries of column A and say exactly what you want

If a1= active, copy a2-a6 to a1-a5 on sheet2

1 response

Similar discussions

Subscribe To Our Newsletter!