Fermé

Create a spreadsheet which can combine 2 sets of data and then manipulate/filter it and create a .csv output

Requirement:

Create a spreadsheet where we can combine 2 separate spreadsheets together, manipulate the data and then create a function to export to a csv file in a certain format.

This piece of work brings data together from 2 sources which we will download ourselves on a daily basis:

Sheet 1 (AH Data)

Sheet 2 (PF Data)

Stage 1: Importing all data and merging 2 sheets

Create a sheet which has 2 buttons which will allow us to import the 2 above spreadsheets from local files on a PC.

Sheet 1 has data on several tabs (could be 50 or more) this all needs to be consolidated on to one sheet. A VLOOKUP will be required to add 4 columns of data from Sheet 2 onto the relevant record in sheet 1. This will give us a full data set for the day.

Stage 2: Data Manipulation

Once we have all the data on one sheet it needs to be manipulated. We need to create certain rules which will rule out some of the lines of data. There will be 2 main rules that need to be applied. We believe these will be IF functions. We then need to remove duplicates. This process will then give us the data set we require.

Stage 3: CSV export

We would then like a button which would export certain columns of this manipulated/filtered data into a CSV file.

Other Information:

This sheet is to be used on a daily basis. It will be the same data sources but different data each day but the same filters would be applied.

The actual detail of the work required and example sheets 1 & 2 will be given once the bid is awarded.

Compétences : Saisie de Données, Traitement de Données, Excel, Architecture Logicielle, Visual Basic

en voir plus : data extractor filter, create csv file dts sql server 2005, create csv pdf php, data entry, data processing, excel, visual basic, web scraping, visual basic for apps, microsoft excel, php create csv, create csv file, create csv files utility, php mysql create csv file, data extractor filter error, install data extractor filter error, create csv file complete day, program create csv access database, php create csv godaddy database email, create csv php page

Concernant l'employeur :
( 2 commentaires ) Crawley, United Kingdom

Nº du projet : #17398423

53 freelance font une offre moyenne de £131 pour ce travail

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) Relevant Skills and Experience I am an E Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(602 Commentaires)
8.3
KulfiSoftwares

I love excel, and have done several projects to clean, merge, remove duplicates, summarize, and even write custom macros. I understand how you need the 2 sheets imported, filtered, and then exported. Relevant Skills a Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(287 Commentaires)
7.5
schoudhary1553

Hi there, Warm Greetings We came along with your request for Create a spreadsheet which can combine 2 sets of data and then manipulate/filter it and create a .csv output Relevant Skills and Experience I have more th Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(282 Commentaires)
7.6
aarifakhtar

Hi: I understand that you are looking for a script/macro which would allow you to read two files, combine them, manipulate some of the data and then output a single file to csv format. Relevant Skills and Experience I Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(172 Commentaires)
7.0
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards Relevant Skills and Experi Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 2 jours
(210 Commentaires)
6.8
ksriniravi

Greetings! With the help of macro the requirements can be implemented without the use of VLOOKUP and IF formulas. Relevant Skills and Experience 18 years experience in using Excel as part of daily work life. Implement Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(153 Commentaires)
6.7
paris2785

Hello! I'm going to write the necessary code that will implement all 3 stages you mention. These tasks are quite familiar to me and I just completed an almost identical project a week ago. Relevant Skills and Experien Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 2 jours
(154 Commentaires)
6.7
mrbrave

Hi, I will create a VBA macro with easy to use interface with a button. On pressing button, macro will automate the whole process and create output csv file. Relevant Skills and Experience I have over 7 years of Excel Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(239 Commentaires)
6.6
sonarkaushik

I am very able to create a excel vba macro to suffice your requirement.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 2 jours
(111 Commentaires)
6.3
Gangsong

Hi I have read your job description carefully i can start right now. Relevant Skills and Experience VBA, C#, Data Processing, Excel Proposed Milestones £150 GBP - complete

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(9 Commentaires)
5.5
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(34 Commentaires)
5.6
archanaoswal

I can write the required macro to extract data from 2 files, combine them as per the requirements and export it to csv Relevant Skills and Experience I have excellent command on MS Excel. I have completed complex proj Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 2 jours
(61 Commentaires)
5.6
aimefx

Hi, I am an expert in excel, VBA and power bi. I have completed many similar projects before which I can show you in chat. Recently I have combined 176 workbooks into a single worksheet. Relevant Skills and Experienc Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(41 Commentaires)
5.3
uzafar99

Hi, I can help you. I have worked with VBA extensively in the past to get custom functionality similar to yours. I can also provide a quick turnaround and will not waste your time. Relevant Skills and Experience VBA, Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(22 Commentaires)
5.0
comwizz2

You need a macro programmed excel sheet that accepts 2 files and combines then filters them before doing a csv export. Relevant Skills and Experience I have extensive experience in Microsoft languages and automation. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(6 Commentaires)
5.2
prabakarm23

I have 8 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server. Relevant Skills and Expe Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(63 Commentaires)
5.1
jasalaz100

Immediate [login to view URL], fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Relevant Skills and Experience Experience of 7 years usi Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(23 Commentaires)
4.7
AkilaArun

The steps defined in the Project are very clear. Step 1 : Will write a code to fetch data from two sheets (Location where the two sheets will be stored to be specified. Then will code for the rest. Relevant Skills an Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 2 jours
(30 Commentaires)
4.7
TechnoGuruu

I have checked all the details of your projects and all three stages where you want to merge, remove duplicate and export to CSV. I will create a efficient sheet for you will perform all these tasks. Relevant Skills a Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(32 Commentaires)
4.8
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 5 jours
(22 Commentaires)
4.4