Excel VB Auto populate Sheets from Master Sheet

Zamknięty Opublikowano 7 lat temu Płatność przy odbiorze
Zamknięty Płatność przy odbiorze

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..

Wprowadzanie danych Przetwarzanie danych Excel Visual Basic Visual Basic for Apps

Numer ID Projektu: #11764432

O projekcie

42 ofert Zdalny projekt Aktywny 7 lat temu

42 freelancerów złożyło ofertę za $118 w tym projekcie

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 w ciągu 3 dni
(335 Oceny)
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 pr Więcej

$150 USD w ciągu 7 dni
(178 Oceny)
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 Więcej

$263 USD w ciągu 7 dni
(22 Oceny)
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 impl Więcej

$30 USD w ciągu 1 dnia
(167 Oceny)
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 detail Więcej

$100 USD w ciągu 3 dni
(289 Oceny)
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 w ciągu 1 dnia
(48 Oceny)
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? P Więcej

$100 USD w ciągu 3 dni
(73 Oceny)
5.8
osmemon

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

$30 USD w ciągu 1 dnia
(35 Oceny)
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 w ciągu 3 dni
(111 Oceny)
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 w ciągu 2 dni
(35 Oceny)
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 w ciągu 3 dni
(45 Oceny)
5.0
saminatinny

A proposal has not yet been provided

$222 USD w ciągu 3 dni
(28 Oceny)
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 th Więcej

$90 USD w ciągu 3 dni
(9 Oceny)
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 a Więcej

$55 USD w ciągu 3 dni
(12 Oceny)
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 Więcej

$60 USD w ciągu 2 dni
(21 Oceny)
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 w ciągu 1 dnia
(17 Oceny)
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 o Więcej

$30 USD w ciągu 3 dni
(6 Oceny)
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 w ciągu 1 dnia
(2 Oceny)
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 w ciągu 1 dnia
(4 Oceny)
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 Więcej

$30 USD w ciągu 1 dnia
(2 Oceny)
1.9