J
jeremiah
I am able to insert 4 rows at each change in value in column a, now I need to
copy paste a range from another sheet into those 4 inserted rows when the
value in column c meets certain criteria, otherwise I will copy a different
range into those 4 rows. In detail...I have both Fulltime employees and
Seasonal employees and the column headings for both groups of employees are
not the same. I need to ask If the employee is an RFT then copy range A1:c4
to offset (-4, 0), otherwise, copy range A5:c8, etc. I haven't been able to
make this work when I am trying to combine the insert rows and copy paste
special into 1 module.
copy paste a range from another sheet into those 4 inserted rows when the
value in column c meets certain criteria, otherwise I will copy a different
range into those 4 rows. In detail...I have both Fulltime employees and
Seasonal employees and the column headings for both groups of employees are
not the same. I need to ask If the employee is an RFT then copy range A1:c4
to offset (-4, 0), otherwise, copy range A5:c8, etc. I haven't been able to
make this work when I am trying to combine the insert rows and copy paste
special into 1 module.