Major Update

R

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?
 
J

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?
Click to expand...

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]
 
J

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!
 
A

angel

Richard said:
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?
Click to expand...
 
Top