so close but not quite there on an insert rows and copy paste spec

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.
 
D

Don Guillett

If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top