Excel Macro To Insert Rows

Microsoft Excel 2003 (full product)
September 27, 2010 at 19:47:51
Specs: Windows 7
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.

See More: Excel Macro To Insert Rows

Report •

September 27, 2010 at 20:49:26
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?

Report •

September 28, 2010 at 05:40:26

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.


Report •

September 28, 2010 at 05:56:46
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.

Report •

Related Solutions

September 28, 2010 at 06:42:40

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.


Report •

Ask Question