WindyCityME
New Member
I am in search of the best way to copy certain columns of extracted data from an ERP system to Excel worksheet to another Excel worksheet table with a different column name so it can be uploaded to another ERP system. There are several columns to be copied and pasted into the destination worksheet. The destination Excel worksheet will have different column headers and will be in different column locations from the source excel worksheet. Would like to do this automatically since this will be a normal occurrence. Any suggestions on how this can be accomplished. I have been knocking my brain on this and just can't figure it out.