Excel VB Auto populate Sheets from Master Sheet

已关闭 已发布的 7 年前 货到付款
已关闭 货到付款

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的应用程式

项目ID: #11764432

关于项目

42个方案 远程项目 活跃的7 年前

有42名威客正在参与此工作的竞标,均价$118/小时

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天内
(335条评论)
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 更多

$150 USD 在7天内
(178条评论)
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 更多

$263 USD 在7天内
(22条评论)
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 更多

$30USD 在1天里
(167条评论)
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 更多

$100 USD 在3天内
(289条评论)
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.

$60USD 在1天里
(48条评论)
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天内
(73条评论)
5.8
osmemon

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

$30USD 在1天里
(35条评论)
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 在3天内
(111条评论)
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 在2天内
(35条评论)
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 在3天内
(45条评论)
5.0
saminatinny

A proposal has not yet been provided

$222 USD 在3天内
(28条评论)
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 更多

$90 USD 在3天内
(9条评论)
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 更多

$55 USD 在3天内
(12条评论)
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 更多

$60 USD 在2天内
(21条评论)
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..

$100USD 在1天里
(17条评论)
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 更多

$30 USD 在3天内
(6条评论)
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.

$30USD 在1天里
(2条评论)
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

$66USD 在1天里
(4条评论)
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 更多

$30USD 在1天里
(2条评论)
1.9