Em Andamento

Excel Template project

We want to develop an excel template to import data from a CSV file.

The CSV file has much more data than we want to see, so we'd like to take only the data we want from that file and have it populate automatically into our Excel template, which is more simple and easy to read.

Ideally, our template will have the info included in our sample file: product name, cost, net price, tax, gross price, COGS% and GM%.

We would like to input just this information from the CSV file that we download regularly.

We would also like to have the COGS% cell text in RED if the % is 30% or greater.

We have created a sample template which is very basic, but would welcome a cleaner, more organized version.

Habilidades: Processamento de Dados, Processamento de dados, Excel, Microsoft Office, Visual Basic

Ver mais: gantt chart excel template project management, simple project management marketing excel template, excel vba project template, excel template project status, excel template project evaluation, excel elearning project management template free, excel template tracking project teams, project roi excel template, free excel template philippine version, excel template project team, template project tracking excel, project tracker excel template, project tracking excel template, excel template project tracking, free excel template building project budget

Acerca do Empregador:
( 46 comentários ) Shreveport, United States

ID do Projeto: #16293787

Premiar a:


Hi, I'm willing to do this without even being awarded, just to take the risk of selection out of you. I just need the word GO through Chat I'll start tomorrow morning, and I'll keep you posted through the process Mais

$88 USD em 1 dia
(6 Avaliações)

23 freelancers are bidding on average $109 for this job


Expert Excel Programmer on freelancer.com and have been featured by the freelancer community https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story) I am an Engineering Graduate with an MB Mais

$200 USD in 3 dias
(552 Comentários)

Hi, I have undertaken similar Excel macro projects earlier on freelancer and would be happy to take on this project. Shall make a user friendly interface for selecting the input csv file. Regards, Arul

$150 USD in 3 dias
(200 Comentários)

Hello , I have read your project description and understood your requirement. I have 5 years experience in Excel VBA programming and can complete task within time with 100% [url removed, login to view] are very responsible towards our Mais

$35 USD in 3 dias
(305 Comentários)

Hello, I’m an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$100 USD in 3 dias
(234 Comentários)

I am very much able to excel template as per your requirement - i am ready to start

$99 USD in 2 dias
(98 Comentários)

Hi, I am very keen to take up the assignment and provide the template for importing required data from CVS file. I have done good amount of work in Excel macro handling and well versed with writing macros in Exce Mais

$80 USD in 3 dias
(74 Comentários)

Went through the files: Product_Component_brand_Uptown(Example).xlsx [url removed, login to view] [url removed, login to view] For each product group list the produc Mais

$100 USD in 3 dias
(41 Comentários)
$30 USD in 0 dias
(51 Comentários)

Greeting, I have understood your Excel Template project task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Data Entry, Data Processing, Mais

$180 USD in 3 dias
(8 Comentários)

hello. how are you? i am expert of Microsoft Excel, excel VBA and data analyst. i have many years of experience on like these job. i can satisfy every thing what you want in short time. best regard.

$100 USD in 3 dias
(17 Comentários)
$155 USD in 3 dias
(21 Comentários)
$100 USD in 2 dias
(3 Comentários)

Hi. I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, fo Mais

$100 USD in 3 dias
(14 Comentários)

Hi. I can develop a nice solution for you for this. I have had to build similar arrangements and can easily solve this for you in an efficient way.

$175 USD in 2 dias
(1 Comentário)

Hey there, Greetings of the day! I can make macro to organize data in manner you required within 2 days. Basically, I am excel expert experienced in making sheets full of complex formulas and VBA for more efficie Mais

$55 USD in 2 dias
(4 Comentários)

We are into developing, Graphic designing, powerpoint Presentation, customizing and maintaining and animated videos. we provide a personal touch to all of our projects and treat each of them like they were our own per Mais

$80 USD in 0 dias
(5 Comentários)
$100 USD in 3 dias
(3 Comentários)

I am an MBA, and ex-investment banker. I assure all my clients a high quality work in a stipulated time period. My skill set includes the following: 1. Excel 2. Financial Modelling 3. PowerPoint Presentation 4. M Mais

$190 USD in 5 dias
(1 Comentário)

Sir i read your initial requirements and i have some question regarding to your [url removed, login to view] we discuss it on chat ?

$100 USD in 3 dias
(1 Comentário)

I have read your requirement that you want to convert csv into xlsx with needed fieldsonly, I am proficient in Microsoft Excel macro and VBA, I am well capable to finish this project for you, I assure you your project Mais

$100 USD in 3 dias
(1 Comentário)