S
Stable
Hi there,
In a workbook, I have saved into sheet1 a csv file
containing 49800 lines with 4 columns of stock data -
workbook saved as excel file.
In a second workbook, I have saved into sheet1 another
CSV file containing 49800 lines with 2 columns of branch
data -workbook saved as excel file. Next I move the
second worksheet into the first workbook so that I only
have to deal with 1 workbook. In the branch worksheet I
have set up 3 columns of Vlookup referencing the stock
data in sheet1.
This procedure has been set up in a macro to process a
further 3 branches.
I have tested this procedure for branches with 100 lines
and it seems to work OK. However when I test with the CSV
files containing 49800 lines it falls over during the
autofill of the VLookup for the 4 columns.
Does anyone have any ideas?
Cheers
In a workbook, I have saved into sheet1 a csv file
containing 49800 lines with 4 columns of stock data -
workbook saved as excel file.
In a second workbook, I have saved into sheet1 another
CSV file containing 49800 lines with 2 columns of branch
data -workbook saved as excel file. Next I move the
second worksheet into the first workbook so that I only
have to deal with 1 workbook. In the branch worksheet I
have set up 3 columns of Vlookup referencing the stock
data in sheet1.
This procedure has been set up in a macro to process a
further 3 branches.
I have tested this procedure for branches with 100 lines
and it seems to work OK. However when I test with the CSV
files containing 49800 lines it falls over during the
autofill of the VLookup for the 4 columns.
Does anyone have any ideas?
Cheers