Hi, I need to write a macro which will export entire rows of data to a new file (one row per person copied directly from the master, one file to be sent to each employer), I could write a loop that basically says:
Code:
For rownum from LastRow to 9
If Range("A:" & rownum).value = "Employer1" Then Copy stuff over
Next rownum
But could I use classes to do this quicker and easier? I cannot get my head around how to use them, I have all the employee data in a sheet indexed by unique IDs so I would tell the class module that all the instances of the class are in the sheet?
The more I look into classes the more confused I get.
Export range to new file (using classes)
Similar Threads
Threaded Mode
