Insert row and data into range

**jewellove** · 10-24-2014, 09:49 AM

Please advise how to insert row and data into a range. See the attached spreadsheet. Thank you.

**pareshj** · 10-24-2014, 10:22 AM

Hi,

Why did you not included d in the list??

**jewellove** · 10-24-2014, 10:45 AM

Yes i missed out d. D should be there. That is the reason why can not insert rows and data manually as the chances of error in data entry is high.

**AB33** · 10-24-2014, 10:58 AM

The attached code is based on original sample attached.

**jewellove** · 10-24-2014, 09:44 PM

Solved. Thank you Guru AB33. You made my work so much easier...

**Loganeb** · 10-24-2014, 10:53 PM

I was able to solve this with a formula as well.

Excel Forum.xlsm

Re: Insert row and data into range