I need to insert rows in a sheet b, if criteria are met on sheet a. Furthermore, I need sheet a's data to be copied into the new rows on sheet b. for instance.
if any cell in column 10 on sheet a equals 4, then I need to insert a row in sheet b. the row on sheet b should contain the data from columns 2,3,5,and 6 from the row on sheet a that had a value 4 in column 10.
edited by moderator: Subject Line edited to be less generic.
When you need something at work, do you just walk into someone's office and say "I need this" and "I need that"? I know if you tried that in my office, it would be a long, long time before you got what you wanted. I'm guessing that when you're face to face with someone you're a bit more polite than that and actually ask for assistance.
Why do people think there is no need to be polite when communicating in a Help forum?
DerbyDad, My appologies for my poor manners. I'm generally a cordial guy and can understand your frustration. That being said, do you have a possible solution? I would appreciate your assistance.
Regards,
You say you want to insert rows on Sheet B, but you don't say where the rows should be inserted. You say you want the data from Sheet A Columns 2, 3, 5 and 6 to be copied to Sheet B, but you don't say which columns the data should be copied to.
DerbyDad, If the value of the cell in column AB of Sheet A is a 4, then I want to insert the data above row 18 on sheet B. A 3 would have data inserted above row 14. A 2 would have data inserted above row 10. A 1 would have data inserted above row 7.
The data that gets pasted into the new row on sheet B comes from Sheet A. For instance, if cell AB10 on sheet B equals 3, then cells C10, D10, F10, and J10 on sheet B would get copied and their data would show up in cells B7, C7, D7, and E7 on sheet A.
Thanks.