Tool to convert spreadsheets to new format


I have three spreadsheets which have different formats and another sheet.

I need a tool (excel/access) that will match the spreadsheets to the other sheet and those that have matching keys create a new file based on a specific format.

This needs to be repeatable so that we can re-run this on a monthly basis.

Taidot: Excel, Visual Basic, tietojenkäsittely, Microsoft Access

Näytä lisää: convert address book format, convert flash dvd format, convert outlook csv format, convert image vector format cs3, convert psd illustrator format, convert tiff map format, convert word illustrator format, convert images quality format, convert logos vector format, convert 3ds uploadable format life, tool convert oracle report excel, convert tab delimited format csv format mac, convert design eps format, update access excel tool, convert old ppt to new format, comments are only supported for keys stored in the new format (-o)

Tietoa työnantajasta:
( 5 arvostelua ) Edinburgh, United Kingdom

Projektin tunnus: #23904660

Myönnetty käyttäjälle:


I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]

£100 GBP 1 päivässä
(142 Arvostelua)

32 freelanceria on tarjonnut keskimäärin 106£ tähän työhön


Dear Employer, I understand you need a tool to automate your manual Excel based requirement. Please message me and I will make a perfect VBA based tool for you. Thanks and Regards, Ash

£150 GBP 2 päivässä
(194 arvostelua)

Sir, I ll create an Excel app with macros. It will be easy to use : 1. Select the 4 files to treat 2. run the code to make the match 3. will create the new output file. Can you please provide the 4 files to check the l Lisää

£100 GBP 3 päivässä
(297 arvostelua)

I already have made a similar tool.. 1- Will provide you an executable that will ask to browse input excel sheets with different formats (Please share different format sheets so that i could look at it and ask questio Lisää

£130 GBP 7 päivässä
(133 arvostelua)

I would like to discuss little bit more about the project for appropriate duration and cost as well. Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner with 100% accuracy r Lisää

£20 GBP 1 päivässä
(118 arvostelua)

Hi, Would you like to see a quick demo of your spreadsheet converted to a new format before you award the project? You can consider it professionally done in less than 24 hrs. Rather than fill this proposal with a lis Lisää

£150 GBP 5 päivässä
(55 arvostelua)

Hi, I can develop an excel vba program (macro) to compare your 3 excel files and create a new one with matching data. I can work on this project with monthly basis. I am experienced Data Analyst and Macro Developer a Lisää

£90 GBP 3 päivässä
(91 arvostelua)

I can perfectly help you in creating such a VBA based Excel. I am a professional Excel expert and VBA programming expert holding years of experience in utilizing advance level tools and functions of Excel including VBA Lisää

£111 GBP 2 päivässä
(58 arvostelua)

£29 Only ------- In just 3 Hours ------ Excel VBA Macro Coding, Formula Generation and Automation process expert with 5* ratting ----- I can make a VBA Macro program to match spreadsheet and create a new sheet with spe Lisää

£29 GBP 1 päivässä
(79 arvostelua)

Hi. I am ready to write your project Write apps on your demand in many languages (Visual Basic, VBA, VBS, .NET, C#, JS, Python, Java, PowerShell) Write database apps including many db formats: MS Access, MS SQL, SQL Lisää

£65 GBP 2 päivässä
(34 arvostelua)

Hi, I can create a VBA script in Excel fro this which can be run by just clicking on a run button, and will go through all your sheets and find the matched keys and will create your new file based on those. Please send Lisää

£150 GBP 3 päivässä
(12 arvostelua)

Hi there, Please share me the files thus I can see its structure and design a macro that will convert it into a standard format. I’ll be standing by to help. Reggie PS: Please message thus I can show you the video Lisää

£90 GBP 3 päivässä
(13 arvostelua)

⭐ Hello, Brendan⭐ I can do this easily, I'll automate this job, Cost is £50 in Less than 2 days (maybe ~7 hours), I'll use C#.NET and build for you a windows desktop application with GUI (buttons, interface, etc). Ple Lisää

£50 GBP 2 päivässä
(7 arvostelua)

Hi, I am ready to start right away. I'm an expert in Data Entry. I have reviewed your job description as well and very confident to handle this project perfectly. I understood your all requirements. I have done many p Lisää

£135 GBP 1 päivässä
(20 arvostelua)

Hi there! Will be able to use programming (vba) to help you automate this so that you can generate on monthly basis as required. a preview will be shown before you award. need you to send me the file though. Cheers!

£100 GBP 2 päivässä
(5 arvostelua)

i am Farhin. Data processing expert who knows the value of time, very hard working and always delivers the work on time .my motive is to make my employer happy without adding additional charges. If you are looking for Lisää

£20 GBP 1 päivässä
(14 arvostelua)

Good Day I’ve checked project details and I can do this perfectly. I am ready to start now. Please share more detail to the project. I have huge experience in working this project. Waiting for your quick reply. Look fo Lisää

£60 GBP 7 päivässä
(6 arvostelua)

-------- Pro Visual Basic/ Data Processing/ Excel/ Microsoft Access Expert! -------- Hi,dear It is very attracting my mind because I'm very interested in your project and also, have rich experiences and high skills on Lisää

£50 GBP 2 päivässä
(1 arvostelu)

Dear Hiring Manager, At First take my sincere respect.I have gone through your project [login to view URL] that i am able to understand that i have the enough Skills to the [login to view URL] is some information about why i am Lisää

£80 GBP 1 päivässä
(2 arvostelua)

Hello sir I am Ankit Patel and I have very good experience of working with MS office and I am best in excel as I have mentioned in my bio and I can give you reliable and accurate work.

£166 GBP 7 päivässä
(0 arvostelua)

Hello Dear, I have read your inquiry and understand what exactly you want. Also it will be done by using VBA and I'm very familiar with making such projects. My expertise includes. -Excel Equations. -Excel Pivot Tables Lisää

£20 GBP 1 päivässä
(0 arvostelua)