Rabu, 02 November 2011

[ExcelVBA] Replacing a Sheet with One of the Same Name

 

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,

__._,_.___
Recent Activity:
----------------------------------
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

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___

Tidak ada komentar:

Posting Komentar