Find Jobs
Hire Freelancers

Excel VBA Macro

$10-30 CAD

Selesai
Dibuat lebih dari 8 tahun yang lalu

$10-30 CAD

Dibayar ketika dikirim
See attached sample sheet. It has four sheets: (a) "all data" sheet: this sheet has all data (b)"list sheet": this sheet has name of some shops (c) "data with shops from list only" sheet: this sheet contains data from "all data" sheet which has same shop as in " list" sheet (d)" data without shops from list": this sheet has the data from "all data" sheet for those shops which are NOT in "list " sheet. Looking for a Macro in VBA to do following: (1) Select all the data from all data row by row (2) check if the shop name is in list (3) if yes, then paste the row in "data with shops from list only" (4) if not, then paste the row in "data without shops from list"
ID Proyek: 8858675

Tentang proyek

11 proposal
Proyek remot
Aktif 8 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 can do the project in one hour and deliver a flawless work. It's actually a quite simple task and you will have it done right away. All the best!
$15 CAD dalam 1 hari
0,0 (0 ulasan)
0,0
0,0
11 freelancer menawar dengan rata-rata $19 CAD untuk pekerjaan ini
Avatar Pengguna
Hello, My name is Dusan and I am expert in Web Scraping and manual Data Entry and Processing. Please, check my profile to see that people who worked with me are extremely satisfied with results and speed. I have done over 120 projects on Freelancer and I have 100% completion rate. Contact me to talk about your project in details. Best regards, Dusan
$20 CAD dalam 1 hari
5,0 (59 ulasan)
6,0
6,0
Avatar Pengguna
Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 50 projects, almost 45+ are complex VB/VBA projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VB/.NET, SQL, MS Office, Access/Excel/Word, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.
$19 CAD dalam 1 hari
5,0 (35 ulasan)
5,0
5,0
Avatar Pengguna
I'm programmer/developer, expert in macro/VBA and Excel It is easy task for me. I will write macro that copy that to sheet 3 or 4 as your described.
$19 CAD dalam 1 hari
5,0 (27 ulasan)
3,7
3,7
Avatar Pengguna
Hello Sir, I’m very interested in your job post involving these skills. I have good experience in data entry, web research, Google documents and MS Office. My typing speed is more than 45 words per minute. I believe my skills would be ideal for your project. I can complete this job within the required time period. I am mostly online. We can discuss there in details, If you are interested. Regards, Rakib Hossain.
$15 CAD dalam 1 hari
5,0 (2 ulasan)
1,2
1,2
Avatar Pengguna
Hello, It's a simple macro that can be written in less than hour. Should you are interested in my offer please let me know. Regards, Andrzej
$10 CAD dalam 1 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
A proposal has not yet been provided
$25 CAD dalam 3 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
Hi! I can find two options to solve it! 1. Doing it with a VBA macro and you can pick the options from a form 2. Doint it by using PivotTables (your file doesn't have to change to .xlsm) What do you think about it?
$13 CAD dalam 1 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
I have 10 years of exp in Excel, Power Point. I am working as Project Manager in one of the MNC .So I believe I will be able to finish the Job within 1 days. We can discuss more about this , once the Bid is over.
$25 CAD dalam 1 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
Tough a newbie on Freelancer, but I have proven skills. One opportunity, and I shall be able to deliver what is expected.
$15 CAD dalam 1 hari
0,0 (0 ulasan)
0,0
0,0

Tentang klien

Bendera CANADA
Milton, Canada
5,0
10
Memverifikasi Metode pembayaran
Anggota sejak Mar 16, 2015

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.