I have been trying to replace a group of macros in a workbook here because they are slow due to the shear volume of data. I posted an earlier attempt which filtered the data twice but because if read the filtered ranges cell by cell into a holding array it was too slow.
I have my two arrays "Var" and "vaData" but cant think of a course to take from here. Any pointers or suggested methods appreciated
Please Login or Register to view this content.
Last edited by nigelog; 01-31-2019 at 01:00 PM.
How aboutPlease Login or Register to view this content.
Hi Fluff
the intermediate window was giving an array of 17,000 to 1 when it should have have been 30 entries so I thought was not reading vadata array.
Made this change to check and no it copies without filtering
Please Login or Register to view this content.
is this declaring a item as empty??
Please Login or Register to view this content.
It's filtering for me, the temp sheet has 5371 rows rather than 17139.
And yes the item is being set to empty (or "") as it's not needed.
Apologies, you are quite correct. The filtering is just the reverse of what I had in mind therefore I never spotted it.
I changed to
and I appear to be sorted. Many thanks FluffPlease Login or Register to view this content.
Ah. My change is not correct. It does give me the entries for the 3rd item in vaData but only that. I will reverse change and see what I can do.
The change you made should show only those customers that appear in the vaData.
Is that what you want?
It is but when I run that the first entries I get are Advanced etc, it has excluded the first customer Abbeyross.
The only entries that should appear on Sheet "Temp" are the entries on "GeneralReport" who's names appear on the list vaData. All other customer names deleted
That is exactly what is needed but it is starting from the 3rd item in vadata instead of the first
Sorted. My fault again. Thankyou Fluff
Last edited by nigelog; 01-31-2019 at 01:00 PM.
Glad you got it sorted & thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks