Each month we receive several files from servicers. There are some files which have the same format, but a different number of row counts. I would like to create a macro so I am not repeating the same steps for each file, but we my limited experience I am not sure how to create the macro such that it can handle the differing row counts. I know if I create the macro by having Excel code my steps, that will not work for each spreadsheet because of the difference in row counts.
If some could advise how I can get past that either through examples or explaination I would appreciate it.
I am using Microsoft Excel 2000
Thanks
If some could advise how I can get past that either through examples or explaination I would appreciate it.
I am using Microsoft Excel 2000
Thanks