pulling down empty cells

[HeyYouYesYouNoNotYouYou]

Hi,

I have a spreadsheet which has orders on, when one person has placed one order, the personal info and order come up on one row. However my problem is when someone places more than one order; this is because the personal info is on a row and the order(s) the rows below. What I need is some vba or a formula that can go down column N (orders) and if a cell is blank then copy column G (personal info) to the row(s) below depending on the column P (order quantity). However if column N (orders) isn't blank then I need it to be left as it is. I have tried vlookups, ifs and match, but no joy

Thanks in advance,

HeyYouYesYouNoNotYouYou

 

[HeyYouYesYouNoNotYouYou]

Hi Im still working on this and think the answer could lie with some vba which will go down column b (names) as every row has a name, then if the name is the same copy the cell above for columns F,G,H and I.

HeyYouYesYouNoNotYouYou