Excel VBA spreadsheet

€8-30 EUR

クローズ

投稿日:

約6年前

€8-30 EUR

完了時にお支払い

Hi, basically what I'm looking for is that: I have a few tabs with data each tab is in the same structure, lets say, column A is account number , column B is Month (Jan , Feb etc) column C is amount. now in the main tab as you can see in the pic Column E contain the account numbers and column G to R are like that,row number 1 is the month for the sumifs criteria row number 3 is the tab name to take the data from. now I want when the user change the name of the tab (from a drop down list) in row 3 it will sumifs from this tab in all the column also when the user change the account number in column E it will change also all the rows in this account based on the tab to take in row number 3. the same if the user change the month.

Data Processing

Excel

Software Architecture

Visual Basic

Visual Basic for Apps

プロジェクト ID: 16439883

プロジェクトについて

32個の提案

リモートプロジェクト

アクティブ 6年前

お金を稼ぎたいですか？

メールアドレス

Freelancerで入札する利点

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

仕事で報酬を得る

提案をご説明ください

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

この仕事に32人のフリーランサーが、平均€22 EURで入札しています

@schoudhary1553

Dear Sir, I have gone through your project details and understand that you need Excel VBA spreadsheet. I have 5 years of experience in Data Processing, Excel, Software Architecture, Visual Basic, Visual Basic for Appszd I will make Excel VBA spreadsheet Kindly ping me to discuss further details.

€30 EUR 1日以内

4.9

(521 レビュー)

8.4

@P0L

Hello, I’m an Excel VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

€30 EUR 1日以内

5.0

(491 レビュー)

8.0

@sloker18

I am proficient in using excel macro/VBA, I have read through your requirement and I can finish the work quickly. I am ready to start yoru project right away, I ensure your project will be delivered with high quality. Awaiting for your precious reply.

€20 EUR 1日以内

5.0

(136 レビュー)

7.5

@periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered ten excel vba projects in the past two months. Requirements are clear. Willing to take up your project. Thank you, Regards.

€30 EUR 0日以内

5.0

(179 レビュー)

7.0

@ksriniravi

Greetings! Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. I have 18 years experience in using Excel as part of my daily work life. Over the last 22 MONTHS , I have spent at least 250 HOURS on automation in Excel every month. If awarded, I can get your work completed to your fullest satisfaction. Have a Great Day! Srinivasan Krishnamoorthi

€30 EUR 1日以内

5.0

(230 レビュー)

7.1

@avinav606lx

Hi there, I am an expert in Excel VBA with over 5+ years of experience. Ping me to discuss more. Thanks Aman

€30 EUR 1日以内

4.9

(181 レビュー)

6.6

@expertatwork

I can do this excel macro

€10 EUR 1日以内

4.9

(258 レビュー)

6.4

@Sercho56

I am very experienced with VBA and can easily write a sub routine that will achieve your desired effect on changing the values in the drop down cells.

€19 EUR 3日以内

5.0

(47 レビュー)

6.2

@vlayausa

Hello, I am proficient with Excel and VBA and would love to help you with this project. Please contact me for more information.

€23 EUR 1日以内

4.9

(154 レビュー)

5.9

@arash18k

Hi As I understand from your explanation, you need your data in the row 3 changed based on the specific drop down list (which is the name of the taps), so when user select a specific tab name in that cell, then all your formula results updated based on that. you can do this in many ways, the simplest way is set each cells of the row 3 equal to the drop down list cell and use $ to fix that cell (for example =$E$3) and for the second (choosing a specified code number) is as simple as above. However, if you need help for doing this, I will do it for you for free (if all you want is same as I said)

€8 EUR 0日以内

5.0

(15 レビュー)

5.1

@jasalaz100

Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Experience of 7 years using excel for organizing and analyzing any company variables. Experience on programming with VB in excel, creating any report using pivot tables and pivot charts, dashboards.

€26 EUR 1日以内

4.9

(33 レビュー)

5.3

@hsingla85

€26 EUR 1日以内

5.0

(10 レビュー)

4.6

@AnumZia

I m highly energetic n good Lerner like to work on time. Best one to complete tasks. Pm to discuss further details Thanks

€24 EUR 0日以内

4.8

(15 レビュー)

4.4

@lherreraz

Hi there! I read the project's description and I'm sure that I can help you with this. I have a large experience working with advanced Excel, using formulas and Macros using VB, the most important thing is that I can do the job, quickly and well done. Please, contact me and let's talk about how I could help for your project.

€30 EUR 1日以内

5.0

(15 レビュー)

3.8

@vivirain

Hi there, Greetings! I have rich experience in Excel VBA and can start working right now. I can help get it work within 1 day. Feel free to contact me and discuss more details. Best Regards,

€24 EUR 1日以内

4.9

(11 レビュー)

3.9

@ReneRondon

Hello. I bid for this project because I'm an Chartered Accountant with lot of experience in MS Excel and VBA programming (macros) I guarantee you an accurate job, full functionality and fast delivery, all this in exchange of a fair rate that is perfectly adjusted to your budget.

€24 EUR 1日以内

4.8

(24 レビュー)

3.5

@nanda1208

I think I can help you on your project. Feel free to contact me to discuss my bid and deadlines. Best Regards.

€10 EUR 2日以内

5.0

(14 レビュー)

3.4

@ongskjason

A proposal has not yet been provided

€30 EUR 1日以内

5.0

(6 レビュー)

3.6

@webexperts98

Hi, I have read your project descriptions carefully before the bidding. I am ready to endow with the solution as per your requirement accurately above mentioned criteria. Please come in chat box....... I am highly interested to work on this project. Eagerly waiting for your response. Regards, Subrata.

€14 EUR 1日以内