i have an excell book open with multipule sheets. the 1st sheet has all the master info, the other sheets are cells for production.
on the master sheet i have columb a,b,c,d,e,f,g. in the F columb im putting the formula. the G im putting the value. the info i need to distrubute to the other sheets is in columb a,b,c,d. no i can get the info using a simple IF formula, but can figure out how to distrubute to the other sheets. can anyone help?
say in F4 my formula is =ifg4>0,"a4:d4 (that get the info i need but how do i tell it to move to another cell columb or row on another sheet? or do i need a different formula all together?
do you want to find out what are in columns a,b,c,d are when G in that row is greater than zero.
1. your data must have column headings in row no. 1 if not introduce row 1 and type the column heading, any heading would do
2. highlight the whole data
4.click the small arrow in column G at the column heading
5.in the download back choose "custom"
6. in the custom window in the left hand side window choose "greater than"
7.in the right hand side window type 0- that is zero number
you will only thos rows which has G column is positive.(more than zero)
you can highlight the filtered data and copy it anlywhere
9. then you again click data-filter-autofitler----filtering will be removed and you will gets the whole data.
If anything else you want post with complete examples.