Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP insert rows
I use VLOOKUP from different WORKBOOKS to my report. when I insert or
delete rows in my report, then all my formulas get scrambled (#REF ) . Is there anyway that I can do to prevent it from happening? Please help- THANKS |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP insert rows
Hi Positive,
one way is to immediately undo *BACK* your last action that produce the #REF! result, thru an *Alarming formula which counts the #REF! error results... I am headed to same direction with your concern... Maybe a Macro can trigger this Alarm, depending also on the type of #REF! either 1) due to deletion of one cell in the same sheet. 2) due to deletion of other sheet or workbook. I hope the there are always bright minds that keep giving bright solutions to our realworld problems. regards, driller -- ***** birds of the same feather flock together.. "Positive" wrote: I use VLOOKUP from different WORKBOOKS to my report. when I insert or delete rows in my report, then all my formulas get scrambled (#REF ) . Is there anyway that I can do to prevent it from happening? Please help- THANKS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert new rows based on Data in other rows | Excel Worksheet Functions | |||
How do I insert blank rows between rows in completed worksheet? | Excel Discussion (Misc queries) | |||
How do i insert of spacer rows between rows in large spreadsheets | Excel Discussion (Misc queries) | |||
How to insert rows after each row of data (800 rows)? | Excel Discussion (Misc queries) | |||
Insert Rows between the existing rows | Excel Discussion (Misc queries) |