Find Jobs
Hire Freelancers

VBA Macro multiple filter 40CAD FIXED PRICE READ CAREFULLY

$30-250 CAD

Inaendelea
Imechapishwa about 3 years ago

$30-250 CAD

Kulipwa wakati wa kufikishwa
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 (CSV type) in order to first spread using comma delimited, than 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. Under the buttons, there are the fields to enter numbers as filters above each column. 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. 6. B is now named "Keyword Length" 7. C is now named "Paid Clicks" Functions "Import From Folder" chooses the import from folder and runs the application "Filter" once clicked is to apply criteria from filter fields "Clear Filter" is to clear the pasted info in the initial sheet "Help" Prompts this document
Kitambulisho cha mradi: 29846812

Kuhusu mradi

2 mapendekezo
Mradi wa mbali
Inatumika 3 yrs ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
Imetolewa kwa:
Picha ya Mtumiaji
Hey I have gone through the project details and I can surely create you the excel macro exactly the way you want. It’s really simple for me We can have a trial before awarding the project. I am ready to work with you less than fixed budget Inbox me to share you the sample file Available 24/7 Regards Sooraj kumar
$30 CAD ndani ya siku 1
0.0 (0 hakiki)
0.0
0.0
2 wafanyakazi huru wana zabuni kwa wastani $30 CAD kwa kazi hii
Picha ya Mtumiaji
Hi. I have read your project and I completely understand that. Some days ago I have complete the same related task. So I can do easily this task. I am always available also right now. I am waiting for your reply. Thanks, Alamin.
$30 CAD ndani ya siku 7
5.0 (1 hakiki)
0.0
0.0

Kuhusu mteja

Bedera ya CANADA
Montreal, Canada
4.8
11
Njia ya malipo imethibitishwa
Mwanachama tangu Des 6, 2017

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.