Find Jobs
Hire Freelancers

VBA Macro multiple filter 50CAD FIXED PRICE READ CAREFULLY

$30-250 CAD

Selesai
Disiarkan hampir 3 tahun yang lalu

$30-250 CAD

Dibayar semasa penghantaran
I need macro to do: In the initial sheet with the macro, it has buttons at the top one besides the others. From left to right, buttons: "Import From Folder & Run", "Filter" "Clear Filter" "Help" (where all this info gets into) 1. "Import From Folder & Run" button to be able to choose Import from folder: From the Import Folder location, once clicked Select Folder, Application starts and it Opens each excel sheets in order to copy the data into the main sheet (the sheet with the buttons) (after copy of each sheet close each sheet). The copy is done in the following format: Title of the sheet comes first, second all the data from the sheet and a space at the end so there is a space between the last cell of data and the next sheet. 2. Move all columns starting with B 2 additional columns on the right. 3. Calculate number of words in A and insert on B. 4. Calculate the now J * F and put info on C. 5. Open form with all columns to filter. Form contains fields to enter numbers as filters. Form filter has the title of the column that it filters for and has min and max fields. Ex if want to put Min 50 Max 500. "Submit" button in order to filter by criteria entered. Functions "Import From Folder" chooses the import from folder and runs the application "Filter" is to open form with filter fields "Clear Filter" is to clear the pasted info in the initial sheet "Help" Prompts this document "Submit" on the form field to Submit filters and close form
ID Projek: 29832055

Tentang projek

8 cadangan
Projek jarak jauh
Aktif 3 tahun yang lalu

Ingin menjana wang?

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan
Dianugerahkan kepada:
Avatar Pengguna
I can do it. Hi i am an Senior VBA Expert. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platfrom give me a chance to show you the best i can do at your service.
$50 CAD dalam 1 hari
4.8 (78 ulasan)
5.1
5.1
8 pekerja bebas membida secara purata $68 CAD untuk pekerjaan ini
Avatar Pengguna
Hi, I am well versed with automation using VBA in Excel can help to implement the Import, Filter, Clear Filter and Help and Submit functionality. A quick discussion would help. Looking forward to your response. Thanks
$75 CAD dalam 3 hari
4.9 (220 ulasan)
6.8
6.8
Avatar Pengguna
✅ Expert on Advanced Excel ✅ Hi there! I read your project descriptions I can write VBA code for advanced filter and rest all functions. I'm expert on vba, macro, nested formula & fuction, advanced sort, advanced filter, power query, conditional formatting, dropdown, data validation, user form, login form and advanced excel automation related various task. Knock me over chat so, we can discuss further and start work. Regards Javed
$50 CAD dalam 2 hari
4.8 (67 ulasan)
5.5
5.5
Avatar Pengguna
Greating, I am highly skilled in Microsoft Excel and VBA. I have more than 16 years experience in windows applications programming and I am highly skilled in VBA programming. I will do the work according to your plan and finalize your request at the right time. Which version of Microsoft Excel are you working with? I'm interested in working with you. I guarantee the work done for up to a week. Regards,
$90 CAD dalam 3 hari
5.0 (9 ulasan)
4.2
4.2
Avatar Pengguna
⭐⭐⭐⭐⭐ Dear Client. The best quality and the fastest delivery speed are promised⭐⭐⭐⭐⭐ I have checked your details carefully and confident I can finish this project perfectly. I have rich experiences about Excel VBA over 5 years of experiences. If you give me a chance, you will get the greatest satisfy. If you mind me, please let me know via chat. Best regards. Kirill.
$50 CAD dalam 1 hari
5.0 (1 ulasan)
1.7
1.7
Avatar Pengguna
I am work carefully and Ian not disappoint you.i am very clever for my work and also be might the work and my payment is safe
$140 CAD dalam 7 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
I am Interested For this project . so. kindly send me details of your project for work .I will do it complete in committed time.
$35 CAD dalam 2 hari
0.0 (0 ulasan)
0.0
0.0

Tentang klien

Bendera CANADA
Montreal, Canada
4.8
11
Kaedah pembayaran disahkan
Ahli sejak Dis 6, 2017

Pengesahan Klien

Terima kasih! Kami telah menghantar pautan melalui e-mel kepada anda untuk menuntut kredit percuma anda.
Sesuatu telah berlaku semasa menghantar e-mel anda. Sila cuba lagi.
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.