A Macro to read an excel, then sort it into “departments” using a list of phone numbers for each department and then place some of the row’s information onto a new worksheet
$30-100 AUD
Paid on delivery
A Macro to read an excel with about 14 columns, then to sort each row into “departments” based upon comparing a row’s “phone number” (in a phone number column), using a list of phone numbers for each department where we would load/supply the phone numbers for each department into the Macro (repeated/perhaps adjusted/new department added) each month. Then paste about 10 of those columns of information from each row onto a new row in a new worksheet with a header specifically for that department. Arithmetic will be applied to one column for the new row that shows a “Rounded-up” amount of seconds/minutes to increments of six seconds, or 30 seconds, or one minute, with a minimum amount of seconds to be billed for each call, before placing that time onto the destination work sheet column, and there will be a multiplier, a “cost per minute” based on a list of about 30 prices related to the area code, exchange or country code.
Project ID: #10574085
