Home > Forum Home > Analyzing Corporate Financial Data > Insert a row Share

Insert a row

Excel Help for Insert A Row in Analyzing Corporate Financial Data


Forum TopicPost Reply Login

Insert A Row

Rate this:
(3/5 from 1 vote)
ConfusedHi

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 on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most recent | Chronological | Highest Rated
Happy
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 on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Insert a row in the