Excel VB Auto populate Sheets from Master Sheet
This project received 44 bids from talented freelancers with an average bid price of $117 USD.Get free quotes for a project like this
Project Budget$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..
Browse Related Skills
Other things people do on Freelancer
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online