Search results

Thanks for the suggestion. I've managed to resolve the issue now - it's not pretty but it works! I may look at using this method when I come to tidy everything up.

I'm new to this so I didn't realise I couldn't stack the data. I'm trying to fix that now.

I've checked the run and it's overwriting the data. I must've been looking too closely to even think about that! Thank you for your help - I'll look at options for searching the whole workbook.

Unfortunately, I'm working with a copy of live data so I can't really share it. It's also drawing data from a predesigned spreadsheet so I'm stuck with the format they're using. I'll see if I can run up some dummy data to make things a little clearer.

I really don't know enough about this to structure things correctly - I'm working through and refining things as I go. It may be an overwriting issue but I wasn't sure of how to check through multiple sheets. I'll see if I can work on that as it does make sense.

The number of records vary and the example I included are sourced from Jan$ through to May$, although some are missing.

Hi, I'm a beginner at VBA and SQL and I've hit an issue trying to build a function which searches and selects records in a closed workbook and pastes the results in the active workbook. The problem I'm having is that only eight records are being returned, despite more matching the criteria...