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

Closed
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
804
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