Insert a row

Excel Help for Insert A Row in Analyzing Corporate Financial Data

Insert A Row

Rate this: (3/5 from 1 vote)

	Hi I have 5 spreadsheets in 1 book. I have a vlookup in spreadsheet 1 column B which looks up column A in spreadsheet 2 Column C looks up column A in spreadsheet 3 and so on. When an item is not found excel returns #NA. I would like a macro that checks for these #NA errors and say cell B30 contained #NA would automatically insert a blank row in spreadsheet 2 at row 30 and paste the contents of A30 into it. Thank you in anticipation macke
	Posted by macke on 05 Dec 2008

Replies - Displaying 1 to 1 of 1

Order Replies By: Most Recent | Chronological | Highest Rated

	Use an IF statement Rate this: (3/5 from 1 vote) You can wrap and IF function around your VLOOKUP function to text is a #NA value is returned and then execute the desired calculation.
	Excel Business Forums Administrator
	Posted by Excel Helper on 05 Dec 2008

Displaying page 1 of 1