Zamknięty

Excel VB Auto populate Sheets from Master Sheet

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

Umiejętności: Wprowadzanie danych, Przetwarzanie danych, Excel, Visual Basic, Visual Basic for Apps

Zobacz więcej: auto populate data excel, excel split sheet sheets, excel master sheet, populate pdf form excel, covert net excel, master sheet creator, excel apr calculation, populate pay periods excel

O pracodawcy:
( 0 ocen ) United Kingdom

Numer ID Projektu: #11764432

43 freelancerów złożyło ofertę na średnią kwotę w wysokości $119 do tego projektu.

$150 USD w ciągu 2 dni
(256 Ocen)
7.6
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
(18 Ocen)
6.4
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
(281 Ocen)
6.7
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
(100 Ocen)
6.1
$100 USD w ciągu 3 dni
(86 Ocen)
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
(52 Ocen)
5.3
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
(134 Ocen)
5.7
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
(93 Ocen)
5.4
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
(30 Ocen)
4.9
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
(19 Ocen)
4.2
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
(29 Ocen)
4.6
saminatinny

A proposal has not yet been provided

$222 USD w ciągu 3 dni
(28 Ocen)
4.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
(20 Ocen)
3.8
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
(7 Ocen)
3.2
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 Ocen)
2.7
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
(4 Ocen)
2.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
(3 Ocen)
2.7
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
(3 Ocen)
1.9
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
(2 Ocen)
1.3
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 Ocen)
1.5