Tamamlanmış

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.

Beceriler: Veri Girişi, Veri İşleme, Excel, Microsoft Office, Visual Basic

Daha fazlasını gör: free excel template building project budget, excel template project tracking, project tracking excel template, excel, visual basic for apps, project tracker excel template, template project tracking excel, excel template project team, free excel template philippine version, project roi excel template, excel template tracking project teams, excel elearning project management template free, excel template project evaluation, excel template project status, excel vba project template, simple project management marketing excel template, gantt chart excel template project management

İşveren Hakkında:
( 50 değerlendirme ) Shreveport, United States

Proje NO: #16293787

Seçilen:

FerriSoft1

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 Daha Fazla

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(10 Değerlendirme)
4.3

Bu iş için 22 freelancer ortalamada $105 teklif veriyor

jaylancer43

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde200%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(601 Değerlendirme)
8.3
deepbluetech

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

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(204 Değerlendirme)
7.3
SBITServices

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% [login to view URL] are very responsible towards our Daha Fazla

in %bids___i_period_sub_35% gün içinde35%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(385 Değerlendirme)
7.3
P0L

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.

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(283 Değerlendirme)
7.1
sonarkaushik

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

in %bids___i_period_sub_35% gün içinde99%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(102 Değerlendirme)
6.2
finecodervw

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde80%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(74 Değerlendirme)
5.5
satishtl

Went through the files: Product_Component_brand_Uptown(Example).xlsx [login to view URL] [login to view URL] For each product group list the produc Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(47 Değerlendirme)
5.9
whitehorsetechn

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, Daha Fazla

in %bids___i_period_sub_35% gün içinde180%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(14 Değerlendirme)
5.3
in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(58 Değerlendirme)
5.4
in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(39 Değerlendirme)
5.1
sloker18

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(28 Değerlendirme)
4.3
JackieXu

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.

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(34 Değerlendirme)
4.8
designer504

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde80%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(7 Değerlendirme)
4.1
Agiletechstudio

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

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(6 Değerlendirme)
4.1
in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(6 Değerlendirme)
3.7
huongth

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(19 Değerlendirme)
3.6
Denishpatel96

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde55%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(4 Değerlendirme)
2.8
richcavanagh9

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.

in %bids___i_period_sub_35% gün içinde175%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
2.8
malavshelat

Hi there ! This is Malav shelat. Below is the proposal for project based on my skills. Skills Summary: - Globally certified SAS programmer for Base SAS and data manipulation techniques. - I have 2.5 years of expe Daha Fazla

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(4 Değerlendirme)
2.4
in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)
2.2