it isn't a rocket science to translate things from Excel to GSheets (in case counterparts exist)
But sometimes they don't.

I would just recommend that if you have future questions that are going the same route, to just mention this up-front (that your intention is to move to Google Sheets).
You would hate to have someone spend a lot of time creating a VBA solution for you that you can't use (and they probably won't be too happy about it either!).