1. M

    VBA Lookup and like function

    Hello, I'm trying to create a VBA code that looks ups a grade number and retrieves the name associated with that number, however, the current code I've written has a 'like' function that I don't quite understand and means that a student that receives a 4% will appear for lookups values 4 and...
  2. B

    VBA SQL Query ACCESS DB w/ LIKE "*" Operator

    Hi Community, Looking for some help in solving a problem. I am getting back a NULL (no records it seems) when processing this query in VBA, but when i try it similarly in Acess it works the way it's supposed to. Not sure what i am doing wrong here. Any help would be appreciated. VBA SQL...
  3. A

    Help with LIKE in macro please

    Hi Guys, I have already had some great help on this forum, but once again I am stuck and am hoping someone can help me. I have a spreadsheet with multiple worksheet names, I want to copy some data across from e.g. the last 5 worksheet to the first 5 worksheets. The complication is that the...

Some videos you may like

This Week's Hot Topics