I'm searching for the best way to get ADP as a column into my master spreadsheet. Ideally, I'd love it to be a column included in the export but without that, what have other people used to easily get that data in?
I'm not an Excel master but what I've been doing is copying ADP from another source, and trying to line it up by sorting by alphabetical on both data blocks. This is a bit of a pain as there are never the exact same entries so it requires some manual cleanup.
Excel experts out there have an easier way they can point me towards?
I'm not an Excel master but what I've been doing is copying ADP from another source, and trying to line it up by sorting by alphabetical on both data blocks. This is a bit of a pain as there are never the exact same entries so it requires some manual cleanup.
Excel experts out there have an easier way they can point me towards?
Comment