Find Jobs
Hire Freelancers

Extract Data

£10-20 GBP

Selesai
Dibuat lebih dari 4 tahun yang lalu

£10-20 GBP

Dibayar ketika dikirim
I am currently responsible for the production of financial reports for our Hotel business. However, there are limitations to what our account’s software can produce in detail so we have to use excel. I currently download a file for each month of the year from our accounts package and copy into an excel file that has a tab for each month from where the data is picked up and analysed elsewhere. I want to be able to download just one file that covers the 12 months, instead of twelve individual ones (or whatever time period) to save time, but then this data is extracted by some means into the relevant individual month’s tabs across the file. If this is by some sort of lookup or index or whatever formula means on each tab that would be great. If it is done by a macro / VBA script that is also ok. I don’t want to use pivot tables as the end users need something that needs very little interaction as I want to be able to let other team members run the reports. I have supplied two example files that are from a cut down version of one year. The actual file it is based on has in excess of 5,000 lines of data entry. Others will have significantly more lines so it will need flexibility. The example files are. 1) A file with 13 tabs (Extract Base model), being the tab that the data is downloaded into, named “download” and 12 tabs, one for each month. The download is populated with the example data and all the other tabs are blank to start with. 2) A file with 13 tabs (Extract Completed), being the tab that the data is downloaded into, named “download” and 12 tabs, one for each month. The download is populated with the example data and the other tabs are populated with the relevant data for each month derived from the “download” tab. This is what I am looking for the end product to be like.
ID Proyek: 21536675

Tentang proyek

6 proposal
Proyek remot
Aktif 4 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
Diberikan kepada:
Avatar Pengguna
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]
£50 GBP dalam 2 hari
4,9 (120 ulasan)
5,9
5,9
6 freelancer menawar dengan rata-rata £55 GBP untuk pekerjaan ini
Avatar Pengguna
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel application. I plan to use a combination of formulas and VBA code to accomplish this. The Excel file will run on PCs. I will charge you 90 pounds and can deliver within three days (we can discuss the milestones, I don't require any payment in front). I'm among the most experienced and skilled Excel, and VBA developers on this platform. In particular, I am in the top 2% of the freelancers having completed over 330 projects successfully in six years, and I feel confident in achieving your task as well.  I'm online from 7 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas
£90 GBP dalam 3 hari
4,9 (230 ulasan)
7,4
7,4
Avatar Pengguna
Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the projects, i do everything, that's why i only take what interests me and i can do it effectively. I can write a script (VBA) that processes the file (12 motnhs data) and generates all reports automatically with the press of a button. This tool will be reusable indefinitely. Look at the comments that employers have left me, that is my greatest satisfaction. Best regards
£100 GBP dalam 7 hari
4,9 (237 ulasan)
6,9
6,9
Avatar Pengguna
Hi, My name is Virendra. I am experienced Data Analyst and Macro Developer and have done mostly Excel VBA Programming jobs. I have excellent knowledge and experience of Manipulating and Exchanging Data in Multiple Sheets and Creating Reports. So, I can do this job nicely. Ready to start, please message me to discuss your project in more details. Thanks, Virendra
£20 GBP dalam 1 hari
4,8 (91 ulasan)
5,7
5,7
Avatar Pengguna
Hello, I am Luis and I will be glad to assist you with your project. Please contact me by chat then we could discuss further details about your Excel project and your budget. Kind regards, Luis Romero
£20 GBP dalam 2 hari
5,0 (127 ulasan)
5,6
5,6
Avatar Pengguna
Hello, I am an excel and VBA professional and I would be happy to assist you with your project. Please send me a message so that we can discuss in details your requirements. Looking forward to hearing from you, BR, Razvan
£50 GBP dalam 7 hari
5,0 (18 ulasan)
5,3
5,3

Tentang klien

Bendera UNITED KINGDOM
United Kingdom
4,9
4
Memverifikasi Metode pembayaran
Anggota sejak Apr 28, 2009

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.