TheRedCardinal
Board Regular
- Joined
- Jul 11, 2019
- Messages
- 243
- Office Version
- 365
- 2021
- Platform
- Windows
Hi all,
I was hoping to get some advice on how to set up a new macro procedure I need to complete.
I've designed something but it's clunky and slow and so there must be a better way (hopefully!)
The situation is this:
There is approximately 10,000 rows of data.
I've been toying with arrays but can't quite make the plan work in my head.
Any tips?
I was hoping to get some advice on how to set up a new macro procedure I need to complete.
I've designed something but it's clunky and slow and so there must be a better way (hopefully!)
The situation is this:
- I have an imported table on Worksheet 1, that contains a column called Voucher (currently in B) and 5 columns of blank data to its right
- I have a non-table list in Worksheet 2, that also contains a column headed Voucher (also in B)
- For each row of data in WS1, I need to find the matching voucher in WS2, and then return the data from columns D and F, into columns D and E
- So far, just a simple lookup
- But I also need to check if the voucher exists more than once in WS2 (it can't in WS1) - and if it does, I need a comment adding in column F of WS1 to that effect
- I also need to add a comment if there is no match, but this is done by "IFERROR" right now
There is approximately 10,000 rows of data.
I've been toying with arrays but can't quite make the plan work in my head.
Any tips?