Dibatalkan

Create a spreadsheet which can combine 2 sets of data and then manipulate/filter it and then 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.

Kemahiran: Pemasukan Data, Pemprosesan Data, Excel, Kejuruteraan Perisian, Visual Basic

Lihat lagi: tableau union custom sql, dplyr merge columns, how to import data to excel, how to import data into excel from web, import data into excel from another excel file, excel import data from another workbook vba, tidyr select, dplyr append, create program for extract product data from particular online shop 2, create program for extract product data from particular online shop -- 2, excel macro create spreadsheet template list data, create spreadsheet compile data, create spreadsheet website data, can create spreadsheet certain fields locked, install data extractor filter

Tentang Majikan:
( 1 ulasan ) Crawley, United Kingdom

ID Projek: #16987725

Dianugerahkan kepada:

rohitagarberg

Hi Sir I have checked the complete details of the project and will create a macro to import 2 sheets with multiple [login to view URL] Them together. Perform data analysis and macro to export the result as CSV Regards

£90 GBP dalam 3 hari
(345 Ulasan)
6.5

46 pekerja bebas membida secara purata £134 untuk pekerjaan ini

jaylancer43

Hello Sir, Thank you for this opportunity. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/article Lagi

£150 GBP dalam 3 hari
(595 Ulasan)
8.3
rinsadsl

Hi, I have worked with such large csv/excel sheets and manipulating them and producing a result sheet. Then we can export it to CSV. First if all I needed to see a sample sheet from you. I can do this as an excel add Lagi

£277 GBP dalam 5 hari
(507 Ulasan)
8.3
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 then create a csv output and we reviewed your project descr Lagi

£150 GBP dalam 3 hari
(272 Ulasan)
7.6
deepbluetech

Hi, I am an Excel macro expert and have prior experience in handling similar projects involving merging of Excel data and filtering. Shall provide an user friendly interface to select the input files and save output in Lagi

£250 GBP dalam 3 hari
(251 Ulasan)
7.3
P0L

Hello, I’m an Excel/VBA expert and I would like to help you with your project. Please send me a message so that we can discuss more.

£100 GBP dalam 3 hari
(277 Ulasan)
7.1
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

£100 GBP dalam 2 hari
(207 Ulasan)
6.8
SigmaVisual

Hi, I have experience of working on similar data automation projects. Please let me know if you are interested and I am available to discuss and start right away.

£150 GBP dalam 3 hari
(68 Ulasan)
7.2
paris2785

Hi, there. My name's Paris Pallas and I'm an Excel expert. Having completed almost 230 projects during the last 5 years successfully I feel really confident in assisting with yours as well. You're welcome to visit m Lagi

£120 GBP dalam 3 hari
(151 Ulasan)
6.7
aanvikm

Hello Sir, I am interested in this project. I can provide you a more customized solution for this excel project. Please let me know if you would like to discuss. Thanks Aanvik

£150 GBP dalam 3 hari
(53 Ulasan)
6.6
£150 GBP dalam sehari
(84 Ulasan)
6.4
sergpooh

Hello. I have a great experience with excel, VBA, export to csv. I had similar tasks as you can see in reviews in my profile. I have a 100% completed tasks. I'll make the best solution for you. Could you send me actual Lagi

£149 GBP dalam 3 hari
(58 Ulasan)
6.1
SShtv

I have a large and successful practical experience of processing and analyzing data in Excel, including using the VBA. Your task is clear to me and I am ready to solve it. I have successful experience performing simi Lagi

£75 GBP dalam 2 hari
(58 Ulasan)
5.6
archanaoswal

I have excellent command on MS Excel and can do the merging and exporting of data as specified. I have completed complex projects in Excel before . For instance - Get match details, odds and stats of tennis matches Lagi

£150 GBP dalam 3 hari
(53 Ulasan)
5.6
abhinovpankaj

Hello, I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applicat Lagi

£122 GBP dalam 3 hari
(64 Ulasan)
5.5
prabakarm23

Greetings for the Day!!! 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 Serv Lagi

£55 GBP dalam 3 hari
(62 Ulasan)
5.1
AnumZia

!!!Dear Honor !!! We Can Help You Make That Happen !!! Let's discuss.................................. Cheers :(

£166 GBP dalam 2 hari
(45 Ulasan)
5.3
dvcontact

Hi, I have read very carefully your project details about creating a spreadsheet to combine two different spreadsheets together, manipulating data and creating a function to export to a csv file. I am absolutely sure Lagi

£150 GBP dalam 3 hari
(31 Ulasan)
5.4
surekash7096

I have the experience and expertise in Excel to combine files and create csv files based on your given criteria. Ready to start work immediately.

£100 GBP dalam 2 hari
(71 Ulasan)
5.3
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 Lagi

£83 GBP dalam 3 hari
(29 Ulasan)
4.3
Maheshpatel107

Hello, I have read your requirements to Combine 2 excel files and export as csv with some filters. I will create sheet which will have following functions. --->2 Buttons [login to view URL] excel sheets from local pc 2. Expo Lagi

£150 GBP dalam 5 hari
(15 Ulasan)
4.6