关闭

Excel VB Auto populate Sheets from Master Sheet

该项目收到44 来自天才威客的竞标,平均竞标价格为$117 USD

为像这样的项目获取免费报价
雇主工作
项目预算
$30 - $250 USD
全部竞标
44
项目描述

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

在寻找赚取金钱的机会?

  • 设定您的预算和时间框架
  • 大致描述您的建议方案
  • 为您的工作领取工资

雇用同样在该项目上竞标的威客

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online