Excel VB Auto populate Sheets from Master Sheet
该项目收到45 来自天才威客的竞标，平均竞标价格为$117 USD。为像这样的项目获取免费报价
项目预算$30 - $250 USD
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..
- The New York Times
- Wall Street Journal
- Times Online