Category: Excel

Convert excel file to multiple csv files


I need a tool to create from Excel file multiple CSV files. My first thought is to have it done through Macro (VBA). I am trying to describe the structure dynamically, so the macro could be reused for similar projects, but if this will bring up the costs, I will have to go for the “quick and dirty” solution.
So the goal of the project is defined, “how to” deliver is still open, we can discuss.

I am looking for someone who can deliver rather quickly – lets say 1-2 weeks max (for production version).

Everything is described in the attached Word file. In the file, there are 3 inserted XLS files (objects) – please make sure to review them as well.

Thank you


Jupiter export to CSV

Excel VBA expert needed


This is a very simple project.
I need this done quickly after being hired.

Ignore the $999 budget and bid what you believe is fair.

Open the attached workbook.

This is a simple Excel-based CRM.
New leads are loaded in the “new” tab.
The current database of leads is in the “main” tab.

The user will place new leads in the “new” tab and we need a script/macro that will move the new leads from the “new” tab into the “main” tab.
However, we do NOT want duplicates added.

Your script will clean up all the URLs (column A) from the “new” tab and remove the “www.” so we are left with the rest of the domain name (e.g.:  “” will be converted to “”).
Next your script will compare the URLs against the company names (column A) in the “main” tab.
If there are duplicates these rows will be ignored.
The remainder URLs will be appended to the “main” tab

In the workbook, the “new” tab has two duplicate records ( and
Thus the remaining records in the “new” tab (the URL and the phone number) are appended to the “main” tab.
After the append is done, the “new” tab is cleared out (from row 2 and down).


crm-19-12-15 (2)

Excel macros workbook


This project needs to be done today.
You will need to be ready to start work upon being hired on 1/12/2020 @ 8am PST (California time).
Please ignore the budget of $999 and bid what you believe is fair.

Excel VBA expert needed to add calculations script/macros to the attached file.
This is a pricing tool.

The user inputs data into the green column headers of the first tab (“input” tab).
The user is interested in 4 items (marked with an “x” in “Check” column A.
Of these 4 items, the user knows the quantity he needs for 3 of them (cells B2, B5, B6)
The user had ordered 1 of the 4 items before at the price and quantity specified (cells I5 and I6).

The user inputs quantity discounts in the “discounts” tab.
There are only four rows here, but the user can add as may as he wants with different quantity ranges.

The “output” tab takes the 4 items the user wants and attempts to calculate pricing based on the quantity requested.

When your script is run it will take the 4 items requested in the “input” tab and create a table in the “output” tab.
It will then attempt to calculate the quantity pricing for the items that had not been purchased in the past (rows 2, 3, and 5 of the “Output” tab). Look inside the calculations to see how the quantity pricing was calculated (F2:I2, F3:I3, F5:I5).
The “Total” (column J of “output” tab) is calculated based on the quantity desired.
Next, your script will calculate the quantity pricing for items that had been ordered in the past (row 4).
Look at rows F4:I4 of the “output” tab to see how it was calculated. Please note, these cell formulas refer to the “discount” tab’s text that is grayed out. The reason it is grayed out is that, the actual workbook will not show any of this gray text. I am only showing it to show you how it was calculated.
After all the rows are calculated in the “Output” tab, the “Total” (row 6) of the “Output” tab is calculated.
Finally, the columns K and L of the “input” tab are populated from the resulting data from the “Output” tab. Feel free to look inside the formulas to see where it comes from.

So, in summary, your script will use the data from the “Input” and the “Discount” tabs to generate the table from scratch in the “Output” tab. Once the “Output” tab is populated, the “Input” tab’s columns K and L will be populated referencing the data in the “Output” tab.


price generator 3

Single excel sheet->break it up into different tabs based on what in a single column.

Source: 1 single xlsx file with one sheet(see below TESTDATA.xlsx).
Part 1-I want to have your program be able to have a browse file so I can import the sheet into your program
Part 2-Scan a single column(TypeCode) and make a tab for each TypeCode(about 7-10).  Then copy source data(TESTDATA.xlsx) from the main sheet into those new tabs.
Part 3-Create a tab at the end called Statistics.(See FiNALSampleOutput.xlsx)  On this sheet, I need each of the Part Numbers.(you will need to remove duplicate part numbers(see FAB Tab-source 5 duplicate, remove down to 1)
Then sum the number of the part numbers and put count under Part numbers. (see attached FINALSampleOutput-Tab Statistics)



Merging Excel Files, Removing Duplicates


Column A “Source” labeled “GrowthList” starting on row 7472
I only want to keep records with source GrowthList if the record doesn’t already exist in prior 7472 rows.
(match/de-depe using CEO email address, CEO name as backup)

Deliverable is Master File excel with records removed where Source (Column A) = GrowthList, and where CEO Email OR CEO Name already exists in prior 7472 rows.

Master File Use