I have a workbook with 2 sheets. On Sheet1 I have a VLOOKUP formula that references a range name FlightNumbers on the second sheet named Flight Numbers. I have received an updated list of flight numbers. I thought the easiest way to incorporate this new data would be to first define the range name FlightNumbers on the new sheet to include all the data, then delete my FlightNumbers sheet and finally to drag the new FlighNumbers sheet into my workbook. But all my VLOOKUP formulas now show #REF.
How should I incorporate the new data into my workbook?
Thanks,
__._,_.___
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
MARKETPLACE
.
__,_._,___
Tidak ada komentar:
Posting Komentar