Spreadsheet Update

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Richard - 18 Jan 2008 20:48 GMT

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?

Reply to this Message

Tom Wickerath - 18 Jan 2008 20:59 GMT

Hi Richard,

This newsgroup is dedicated to the Microsoft Access database product. The
Microsoft website is not all that clear and may have misdirected you. I
suggest you re-post your question to the Excel newsgroup shown below:

http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public
.excel.misc&exp=1

Good Luck!

Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

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

Reply to this Message