Major Update

[Richard]

I have a spreadsheet with over 60K rows that I need to update with an
additional column of data. Unfortunately it would be too much work to repull
the data and get it formatted appropriately. I was planning to use vlookup
to complete the update but so far has been very time consuming. Does anyone
have a better option not requiring VBA?

 

[John W. Vinson]

I have a spreadsheet with over 60K rows that I need to update with an
additional column of data. Unfortunately it would be too much work to repull
the data and get it formatted appropriately. I was planning to use vlookup
to complete the update but so far has been very time consuming. Does anyone
have a better option not requiring VBA?

Is this a spreadsheet in Excel? or a table in Access? If it's in Excel, please
repost your question in an Excel newsgroup. If in Access, please post some
more details - VLookUp is an Excel function not available in Access, for
example.

John W. Vinson [MVP]

 

[Jerry Whittle]

Option 1. Import the spreadsheet into Acess as it would be much better in a
database with that many rows.

Option 2. Failling that, ask this question in an Excel forum!

 

[angel]

I have a spreadsheet with over 60K rows that I need to update with an
additional column of data. Unfortunately it would be too much work to
repull
the data and get it formatted appropriately. I was planning to use
vlookup
to complete the update but so far has been very time consuming. Does
anyone
have a better option not requiring VBA?