Automatic row generation

K

Kyle80

Please help! I'm a fairly experienced programmer, who is new to Excel.

Here's an example of what I need to do:

1- Find a Row in "Sheet2" with "NEWYORK" in it
2- If found, Automatically Insert (and shfit cells down) a ROW in
"Sheet1"
3- Copy values of row from "Sheet2" into the new Row created in Sheet1
4- Repeat until no more occurrences of "NEWYORK" are found

Any help would be greatly appreciated!

Cheers,
Kyle
 

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

Similar Threads

Automatically populating cells down a row 8
if statement, change cell only if true 4
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
INCORPORATING A ROW NUMBER INTO A FORMULA RANGE 0
Array with many cells from a row but not in order or together 11
auto added checkbox 2
Compare Sheets 0
How to check a condition and write another cell 0

Top