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

Closed
batman28x - Nov 8, 2009 at 03:47 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 8, 2009 at 09:21 PM
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

1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Nov 8, 2009 at 09:21 PM
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
0