Hide row if it's value 0 even while carrying formula

[blk]

canve we hide entire row untill it is false help me out.
thank you.

[stnkynts]

Please provide some more information so we may assist you.

[blk]

i created one data base so when i enter the bill number in to sheet3 "B8" then it's value will be go to sheet2 A2 cell then in sheet2 it will autofilter from A5 range. but it is doing like that untill i double click the sheet2 A2 cell and then press the enter, in sheet3 which one have 0(Zero) value it's need to hide entire row untill it's false, and in excutive name cell i used "=sum(sheet2!F6)"" formula but it's not working, help me out from this problem.


thank you for your assistance.

[blk]

please any one halpe me out................

[blk]

please help me

[blk]

i created one data base so when i enter the bill number in to sheet3 "B8" then it's value will be go to sheet2 A2 cell then in sheet2 it will autofilter from A5 range. but it is dose work untill i double click on sheet2 A2 cell and then press the enter its will filtering, in sheet3 which one have 0(Zero) value it's need to hide entire row untill it's false even while carrying, and in excutive name bellow cell i used "=sum(sheet2!F6)"" formula but it's not working, help me out from this problem.

thank you for assistance

[Marcol]

Try this in "Sheet3" C8

Please Login or Register  to view this content.

Drag across to E8 then Down to Row 23

Is that what you mean?

You might want to use format painter to reformat Row 8 before you drag down.

[blk]

hello,

thank you for your assistance, but also i want to hide sheet3 row even while it's carrying formula and when i enter bill number in sheet3 B8 range so then it's go to sheet2 A2 range it's working but not chenging values of sheet2 from range A6 untill i Double click then press enter on the sheet2 range A2.


and once again thank you,

[blk]

hello,

thank you for your assistance, but also i want to hide sheet3 row even while it's carrying formula and when i enter bill number in sheet3 B8 range so then it's go to sheet2 A2 range it's working but not chenging values of sheet2 from range A6 untill i Double click then press enter on the sheet2 range A2.


and once again thank you,

[blk]

please help me any one....................

[Decoderman]

You are going to have to be more clear on what you are wanting.

Thanks

[blk]

hello,

thank you for responce to my post, i have created this data base that attached to this post, so i will use to example madical store so my quetion is i am gonna use sheet3 as bill format, when i add data it will go to sheet1 and i have advance filter in sheet2, when i enter value in sheet3 range B8 it will go to sheet2 range A2 then in sheet2 will filter but it's not working as said untill i double click on sheet2 range A2 and then press enter then its working and in sheet3 from range C9 to C23 it needs to hide if value 0(zero) or (" ") even while carrying formula.

thank you.