VBA Macro multiple filter 25 EUR FIXED PRICE READ CAREFULLY

終了済み 投稿 2年前 着払い
終了済み

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

エクセル ビジュアルベーシック アプリ用ビジュアルベーシック 情報処理 PHP

プロジェクトID: #29832075

プロジェクトについて

17個の提案 リモートプロジェクト アクティブ 2年前