Excel VBA spreadsheet

€8-30 EUR

Stengt

Lagt ut

omtrent 6 år siden

€8-30 EUR

Betalt ved levering

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

Prosjekt-ID: 16439883

Om prosjektet

32 forslag

Eksternt prosjekt

Aktiv 6 år siden

Ønsker du å tjene penger?

E-postadresse

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen

Få betalt for arbeidet ditt

Skisser forslaget ditt

Det er gratis å registrere seg og by på jobber

32 frilansere byr i gjennomsnitt €22 EUR for denne jobben

@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 om 1 dag

4,9

(521 omtaler)

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 om 1 dag

5,0

(491 omtaler)

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 om 1 dag

5,0

(136 omtaler)

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 om 0 dag

5,0

(179 omtaler)

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 om 1 dag

5,0

(230 omtaler)

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 om 1 dag

4,9

(181 omtaler)

6,6

@expertatwork

I can do this excel macro

€10 EUR om 1 dag

4,9

(258 omtaler)

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 om 3 dager

5,0

(47 omtaler)

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 om 1 dag

4,9

(154 omtaler)

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 om 0 dag

5,0

(15 omtaler)

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 om 1 dag

4,9

(33 omtaler)

5,3

@hsingla85

€26 EUR om 1 dag

5,0

(10 omtaler)

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 om 0 dag

4,8

(15 omtaler)

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 om 1 dag

5,0

(15 omtaler)

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 om 1 dag

4,9

(11 omtaler)

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 om 1 dag

4,8

(24 omtaler)

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 om 2 dager

5,0

(14 omtaler)

3,4

@ongskjason

A proposal has not yet been provided

€30 EUR om 1 dag

5,0

(6 omtaler)

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 om 1 dag