En cours


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"


"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

Compétences : Visual Basic, Traitement de Données, Excel, Architecture Logicielle, Visual Basic pour les apps

en voir plus : vba macro excel unicode, excel vba macro paste adjacent column, next empty cell vba macro paste, vba macro trial, vba macro generate report excel word, paste excel vba macro, inputting multiple data vba macro, access vba multiple filter, read webpage data excel vba macro, read word file vba macro, vba macro filter unique results, vba macro filter sort, magento price slider multiple filter, sort filter data vba macro, fixed price room extension design package in usa, www kuyhaa android com read more i need a password to extract the fifa manager 13 password to extract fifa manager 13 ask me fas, SMALL VBA PROJECT - FIXED PRICE, managing updates to shared vba macro code for multiple users, find and replace multiple values in excel using vba macro, how to combine multiple excel sheets into one worksheet using vba

Concernant l'employeur :
( 11 commentaires ) Montreal, Canada

Nº du projet : #29846812

Décerné à:


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 l Plus

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% CAD en 1 jour
(0 Commentaires)

2 freelances font une offre moyenne de 30 $ pour ce travail


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. Th Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 7 jours
(1 Évaluation)