Excel VB Auto populate Sheets from Master Sheet

$30-250 USD

Fechado

Publicado

há mais de 7 anos

$30-250 USD

Pago na entrega

I have a sheet of master list [with some dummy data] .. then i have created the sub sheets which has to auto populate from the master list If there is a corresponding entry against P1 , P2 , P3 etc - I want only those data entered into the subsequent sheets. I have made an ON/OFF toggle for each month --- can you display data on rows below based on the months I choose on the Toggle on top For Eg If i have Jan Feb Mar , Apr as ON , i want to see only those months ... in the master list ... I tried using an IF function with the logic that P1>0 then please display corresponding cell data from master list - but then it fetches the blank rows too and displays as zero - i dont want to see the blanks .. i only want the data for which there is value entered..

Visual Basic for Apps

ID do Projeto: 11764432

Sobre o projeto

42 propostas

Projeto remoto

Ativo há 7 anos

Quer ganhar algum dinheiro?

Endereço de e-mail

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo

Seja pago pelo seu trabalho

Descreva sua proposta

É grátis para se inscrever e fazer ofertas em trabalhos

42 freelancers estão ofertando em média $118 USD for esse trabalho

@prameswara

Hello Sir Im excel VBA macro and formula Expert :) i can make automate your workbook please give me a chance for doing your job and im able to start doing your project right now Thank You Sincerely Prameswara

$94 USD em 3 dias

4,9

(335 avaliações)

7,0

@paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).

$150 USD em 7 dias

4,9

(178 avaliações)

7,0

@esalem

Hello, I am VB, VBA, C#, WPF, Java, Delphi, PHP, ASP.NET, CAD and GIS developer, I developed many desktop applications and custom tools, macros and Add-Ins. For reference see my profile. I am ready to discuss and doing the project. Regards, Eyad

$263 USD em 7 dias

4,9

(22 avaliações)

6,8

@ksriniravi

Greetings! I can think of a solution to your requirement. If you can share the workbook, I can try it out quickly. I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporting. In fact, over the last MONTH , I have spent at least 225 HOURS on automation in Excel. I can get your work completed to your fullest satisfaction. Have a Great Day! Srinivasan Krishnamoorthi

$30 USD em 1 dia

5,0

(167 avaliações)

6,7

@TonmoyRoy111

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me for further details. Thanks and regards Roy

$100 USD em 3 dias

4,9

(289 avaliações)

6,6

@diorisaguilar

I can help you with this task, I have worked in several projects like it. Can you share the spreadsheet to work on it?. I will be open to any suggestion you may have.

$60 USD em 1 dia

4,9

(48 avaliações)

6,0

@macroPOL

Hello, I am Excel and VBA expert. Yes, I can display data on rows below based on the months you choose (or based on any other criteria using the VBA). The blank rows are not a problem. Can I see the file? Please note that I have 100% completion rate and 5-star feedback on 50 projects.

$100 USD em 3 dias

5,0

(73 avaliações)

5,8

@osmemon

expert of excel and macro programming. I have done several similiar project.. inbox me to start working quickly.

$30 USD em 1 dia

4,8

(35 avaliações)

5,6

@tasleem83

I have gone through the description. I am very much interested to work on your project. I’ll provide you the work as per your requirement with in a particular time frame. So let’s start

$155 USD em 3 dias

4,7

(111 avaliações)

5,5

@carlosperezit

Hi Im an expert in MS technologies I have been working in software development for the last 20 years Regards Carlos

$111 USD em 2 dias

4,9

(35 avaliações)

5,1

@sorinacho88

Hello, I can help you with this project. If you are interested please open a chat with me. Kind regards, Sorin

$35 USD em 3 dias

5,0

(45 avaliações)

5,0

@saminatinny

A proposal has not yet been provided

$222 USD em 3 dias

4,9

(28 avaliações)

4,7

@SergeyKyiv

Greetings! My name is Sergey Murzin, I'm from Kyiv, Ukraine. I have 20 years experience with MS Excel/Access/VBA. Any code I provide is well structured and commented, client gets whole access and rights for the code I made. Warranty covers any bugs detected later. Looking forward for further clarifications of the details. Regards, Sergey

$90 USD em 3 dias

4,9

(9 avaliações)

4,4

@nevo1234

Dear sir, I am an Economist (BA+MA) and expert in Excel. reading your requirement it sound as if it can be solved using formulas but also If needed I can write a VBA Macro. it would be best if I can see the excel and we can discuss over chat what u want to accomplish exactly - so pls contact me over the site chat. brgds, itay

$55 USD em 3 dias

5,0

(12 avaliações)

4,3

@serdaryalcin

Hello, I can write a small macro that will scan the master sheet, and if found copy the content to the sub sheets. Or I can make use of VLOOKUP. These all depends on data, how many rows are we talking about? I need to see the file. Regards, PS: As your payment is not verified. I want 10 USD to start working on it.

$60 USD em 2 dias

5,0

(21 avaliações)

4,4

@JLQ006

Hi, I can finish the job in few hours. If you award the project to me now I can start working on it..

$100 USD em 1 dia

5,0

(17 avaliações)

3,8

@pepsmich

Dear sir/madam: I can help you get this done. Would you like to share the workbook so I can modify and send back to you for you to verify and confirm what I have done? No need to award me the project yet. Award only should you be satisfied with my work.

$30 USD em 3 dias

5,0

(6 avaliações)

3,5

@bhumika42

Hello, I have 10 years of experience into VBA, VB6, VB.Net. I have made created and modified many macros. Also have worked over many .Net based excel projects. Kindly let know about work.

$30 USD em 1 dia

4,8

(2 avaliações)

2,7

@sahinbudak

Hello, I am an excel master. I can populate the sub sheets with ehatever the conditions are. I can deliver the job in 24 hours. If you ask for it, I can also provide some sample works. Hope to worl with you

$66 USD em 1 dia

5,0

(4 avaliações)

1,8

@ehabzaky

Hello, I am an experienced developer but new freelancer. I have read and understood your project requirement. Please note that the file is not attached to the project. Just send me the file I will do the job for free. If and only if you are satisfied with the work you can award it to me. You will not lose anything and will help me to build my work experience in freelancer. Waiting your reply. Regards, Ehab Zaky

$30 USD em 1 dia