Excel VBA spreadsheet

€8-30 EUR

Closed

Posted

about 6 years ago

€8-30 EUR

Paid on delivery

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

Project ID: 16439883

About the project

32 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

32 freelancers are bidding on average €22 EUR for this job

@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 in 1 day

4.9

(521 reviews)

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 in 1 day

5.0

(491 reviews)

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 in 1 day

5.0

(136 reviews)

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 in 0 day

5.0

(179 reviews)

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 in 1 day

5.0

(230 reviews)

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 in 1 day

4.9

(181 reviews)

6.6

@expertatwork

I can do this excel macro

€10 EUR in 1 day

4.9

(258 reviews)

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 in 3 days

5.0

(47 reviews)

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 in 1 day

4.9

(154 reviews)

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 in 0 day

5.0

(15 reviews)

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 in 1 day

4.9

(33 reviews)

5.3

@hsingla85

€26 EUR in 1 day

5.0

(10 reviews)

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 in 0 day

4.8

(15 reviews)

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 in 1 day

5.0

(15 reviews)

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 in 1 day

4.9

(11 reviews)

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 in 1 day

4.8

(24 reviews)

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 in 2 days

5.0

(14 reviews)

3.4

@ongskjason

A proposal has not yet been provided

€30 EUR in 1 day

5.0

(6 reviews)

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 in 1 day