Закрыт

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

Навыки: Ввод данных, Обработка данных, Excel, Visual Basic, Visual Basic для приложений

Показать больше: 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

О работодателе:
( 0 отзыв(-а, -ов) ) United Kingdom

ID проекта: #11764432

43 фрилансеров(-а) подали заявки на эту работу; средняя заявка - $119

$150 USD за 2 дней(-я)
(256 отзывов(-а))
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 Больше

$263 USD за 7 дней(-я)
(18 отзывов(-а))
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 за 3 дней(-я)
(281 отзывов(-а))
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 Больше

$150 USD за 7 дней(-я)
(100 отзывов(-а))
6.1
$100 USD за 3 дней(-я)
(86 отзывов(-а))
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 Больше

$100 USD за 3 дней(-я)
(52 отзывов(-а))
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 Больше

$100 USD за 3 дней(-я)
(134 отзывов(-а))
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 за 3 дней(-я)
(93 отзывов(-а))
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 за 2 дней(-я)
(30 отзывов(-а))
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 Больше

$60 USD за 2 дней(-я)
(19 отзывов(-а))
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 Больше

$30 USD за 1 день
(29 отзывов(-а))
4.6
saminatinny

A proposal has not yet been provided

$222 USD за 3 дней(-я)
(28 отзывов(-а))
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 за 1 день
(20 отзывов(-а))
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 за 3 дней(-я)
(7 отзывов(-а))
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 за 1 день
(2 отзывов(-а))
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 за 1 день
(4 отзывов(-а))
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 Больше

$90 USD за 3 дней(-я)
(3 отзывов(-а))
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 Больше

$30 USD за 3 дней(-я)
(3 отзывов(-а))
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 Больше

$55 USD за 3 дней(-я)
(2 отзывов(-а))
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 Больше

$30 USD за 1 день
(2 отзывов(-а))
1.5