Concluído

Tool to convert spreadsheets to new format

Hi,

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.

Habilidades: Excel, Visual Basic, Processamento de dados, Microsoft Access

Veja mais: 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)

Acerca do Empregador:
( 5 comentários ) Edinburgh, United Kingdom

ID do Projeto: #23904660

Concedido a:

aubrey03

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 em 1 dia
(142 Comentários)
6.2

32 freelancers estão ofertando em média £106 para esse trabalho

asin1987

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 in 2 dias
(194 Comentários)
7.7
bouslimi1979

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 Mais

£100 GBP in 3 dias
(297 Comentários)
7.7
customizedata

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 Mais

£130 GBP in 7 dias
(133 Comentários)
6.6
royalcalif

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 Mais

£20 GBP em 1 dia
(118 Comentários)
6.2
dvcontact

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 Mais

£150 GBP in 5 dias
(55 Comentários)
6.5
vsprybhanu

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 Mais

£90 GBP in 3 dias
(91 Comentários)
5.7
daniyal3214

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 Mais

£111 GBP in 2 dias
(58 Comentários)
5.6
AnowarRatul

£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 Mais

£29 GBP em 1 dia
(79 Comentários)
5.0
writingapp

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 Mais

£65 GBP in 2 dias
(34 Comentários)
5.0
arash18k

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 Mais

£150 GBP in 3 dias
(12 Comentários)
4.4
IgeS

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 Mais

£90 GBP in 3 dias
(13 Comentários)
4.5
w4po

⭐ 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 Mais

£50 GBP in 2 dias
(7 Comentários)
3.9
wkcompany

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 Mais

£135 GBP em 1 dia
(20 Comentários)
3.8
jaelahoe

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 in 2 dias
(5 Comentários)
3.0
Farhinzaffar1

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 Mais

£20 GBP em 1 dia
(14 Comentários)
3.0
imdadulislam1886

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 Mais

£60 GBP in 7 dias
(6 Comentários)
1.8
zoranzdravkovic2

-------- 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 Mais

£50 GBP in 2 dias
(1 Comentário)
2.0
imran594

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 Mais

£80 GBP em 1 dia
(2 Comentários)
1.5
ankitpatel4464

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 in 7 dias
(0 Comentários)
0.0
BasmaTalaat92

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 Mais

£20 GBP em 1 dia
(0 Comentários)
0.0