Hi All,
I've spend the last few days bodging my way to this VBA script thanks to a lot of helpful input.
I'm trying to create a script that auto-updates selected data in around 250 rows in Sheet1. The data is chosen based on the data in sheet2, which is effectively the names of who needs updating along which the data which needs updating (the layout of both sheets aren't the same. Sheet1 contains around 80 pieces of information per person whereas sheet2 only contains around 10 pieces of information per person).
I believe, thanks to a very helpful reddit user i've almost completed the task but given I didn't write the script itself it's a little out of my league in terms of understanding, I'm still at a very beginner form level.
So the problem.
Everytime I run the below scripts I get a Runtime error (13) Type Mismatch for this string of data -HTML Code:
Class Module: clsEmployee
HTML Code:
Updater Module
HTML Code:
The data it's altering are all standard numbers below 2500.
The team is representing by a number also.
It might be quite a simple thing but like I mentioned I'm just starting to learn how to really use VBA and I can't contact the guy who originally helped me. Anyone able to help here?
Bookmarks