Fast refresh of uploaded data into another sheet

thanks challis =)
the thing with this app, is that we are limited to the use of excel only.
this is to minimize user training and adjustments that we could possibly
encounter once we implement this project.

"challis" <bmlx@yahoo.com> wrote:
>
>This seems like an overly long time. I think this type of operation should
>take no more than 10 seconds (tops)
>
>Here is what propose you try. Instead of loading the data to an excel file,
>load it into an Access Table with the lookup data in another table.
>
>Then generate the Excel file from a query using ADO.
>
>Alternatively cache the lookupvalues in memory (sorted) then let your code
>do a binary search for each of the incoming line items.
>
>
>challis
>
>
>
>
>"Jeff" <jnuestro@yahoo.com> wrote:
>>
>>Peace!
>>
>>I am currently developing an application that enables the user to upload
>>data from text files into a worksheet.
>>
>>The upload part is already done.
>>
>>
>>My problem is, the sheet that contains the uploaded data is being referenced
>>by another sheet using VLOOKUP.
>>
>>The upload plus the calculation of the formula now takes very long - up
>to
>>an hour for 300 records.
>>
>>Is there a better way of doing this?
>>
>>The referencing sheet is the report sheet. and that is the one being viewed
>>by the user, so it is important for them to get the results and fast.
>>
>>Thanks in advance =)
>>
>>
>>
>