VBA Advance Filtering

$10-30 CAD

処理中

投稿日:

6年近く前

$10-30 CAD

完了時にお支払い

I would like to use customer filter and get the total quantity of the result. For instance i will select "BW" under "Invoiced By" and select certain product from "Product Name" drop down. Then I need the total quantity as a result. I need to have the option to add multiple filter from multiple column and get the quantity. Please check the attached file for sample data and then we can discuss more with a chosen candidate. Regards, Evan

Visual Basic for Apps

プロジェクト ID: 17475651

プロジェクトについて

6個の提案

リモートプロジェクト

アクティブ 6年前

お金を稼ぎたいですか？

メールアドレス

Freelancerで入札する利点

予算と期間を設定してください

仕事で報酬を得る

提案をご説明ください

登録して仕事に入札するのは無料です

アワード者:

@rinabuoy13

$30 CAD 1日以内

4.9

(41 レビュー)

5.2

この仕事に6人のフリーランサーが、平均$24 CADで入札しています

@zebracaro

I can do it for you quickly and exactly. Please contact me for saving your time and your money .

$30 CAD 1日以内

4.9

(111 レビュー)

6.5

@TonmoyRoy111

Dear client I understand the scope of work. I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Roy

$30 CAD 2日以内

4.9

(253 レビュー)

6.4

@dayakmlt

With the help of slicer u can have the desired output..........................................i added slicer to your data. check whether it is usefull to you..

$15 CAD 1日以内

5.0

(15 レビュー)

3.6

@engrtan

HI ! I would like to propose to you an alternative solution, one that would not require you to develop a VBA macro script. It would involve an additional Sheet to list down all possible values, without duplicates, for Product Name, Rate Plan, and Sales Person, and/or Invoiced By or another parameters that you might wish in the future. I intend to use the "Data Validation" functionality of MS Excel, setting up individual validations for each of your required parameters. The sum shall be done using a relatively simple SUMIFS formulation that can be edited by the end-user, as required. Please drop me a line, if you are interested. I hope to discuss further your requirements. Thank you in advance ! Best regards, Tristan

$20 CAD 2日以内