Posts by destinythanh

hi All
my workbook is error when open by excel 2010.

https://www.dropbox.com/s/s9dt…2014-02-20%2007.30.19.png

https://www.dropbox.com/s/tjok…REVIEWED%20BY%20HANH.xlsx
this is important file. please fix it
many thanks

Re: get the first value in row

thank all
now i have lots of solutions. thanks holycow

Re: get the first value in row

hi all
i finally find the solution.
http://www.giaiphapexcel.com/f…91%C3%A2%CC%80u-ti%C3%AAn
thanks all

Re: get the first value in row

hi MattChoo
i would like formula that i can get value like the column highlight.
you can see E11:L11. i would like get the first value : 73
similar rows below
thanks for your support

hi all
i have work book that i would like to get the first value in the row.i would like to formula at column hight light
is there fomula can do that?

please follow this link
https://www.dropbox.com/s/3rq9…st%20data%20in%20row.xlsx
thanks

Re: lose conditional formatting in pivot table

hi holycow
i would like $D6 is between 2.5 and 3.
how can i fix it ?
thanks

hi All
i would like to apply conditional formatting in pivot table. However they are lost after refreshing.
how can i solve it?
please follow this link.
many thanks

hi All
i am trouble with work book which is circular reference error.
it took me long time to open this workbook.
please support me

https://www.dropbox.com/s/8341…/MANPOWER%20PLANNING.xlsx

Re: formulas to calculate daily results

hi All
i solved the problem .
Thanks All

Re: formulas to calculate daily results

hi holy cow. this case , no one achieves their daily targets. and they don't have bonus base on daily schedule.
100% bonus,
<100% no bonus.
[ATTACH=CONFIG]57908[/ATTACH]
And we only accept the results for date plan. we do not accept the results the day after
https://www.dropbox.com/s/yjdptxn55mk8f4i/3.JPG
can you calculate 70pcs for following case ? thank for your support. i am looking forward to hearing from you.
[ATTACH=CONFIG]57909[/ATTACH]

Re: formulas to calculate daily results

hi Holycow
i have just upload new file. i need to calculate % daily results base on case that i mention
thanks for your support. tomorrow i have to submit these results

dear All
i am having trouble with formula to calculate daily results.I can only calculate results base on daily plan. i can not solve these problems
please follow this link https://www.mediafire.com/?c95zmzz1asjf154

Re: hide/unhide sheets (VBA)

hi Holycow
i am having trouble with this VBA. it's not run, and debug.
please open link which i send in post #10
many thanks

Re: hide/unhide sheets (VBA)

hide holy cow
Could you write a code that i can hide/unhide specified sheets ?

Re: Find value in workbook similar to another and replace automate by 0

hi Holycow
value in before image, if they are same in file uesd to compare, they will be return to 0. but they are not the same with file used to compare.
http://[Blocked Image: http://www.uphinh.vn/image/stream/1529862.jpg]

please see the image i would like VBA do

Re: Find value in workbook similar to another and replace automate by 0

hi Holycow
you misunderstand me. i mean value in each row, each column I -> O, if they are the same with value in file used to compare, they will be turn 0, but do not delete information column A-> H. i know it is difficult to do that.
every Saturday at 8am, i export file from ERP system to calculate the production results. And database after 8am, i use them to calculate the results next week, but i have to eliminate database before 8am.

Re: Find value in workbook similar to another and replace automate by 0

Hi Holy cow
something is wrong, You can check part V55-a in KE HOACH SAN XUAT THANG 11 TUAN4 ,i think it shouldn't change , but when i apply VBA 16-11-2013 it return o => wrong.
can you fix them ?
thanks

http://www.mediafire.com/?nnxbmcapxcf3ki2

Re: hide/unhide sheets (VBA)

hi All
i apply this VBA into workbook , but it's not run although all the cell values are the exact sheet names.
please follow this link

Re: hide/unhide sheets (VBA)

hi ALL
i give up

Re: hide/unhide sheets (VBA)

hi i have a message errror

Quote

ActiveWorkbook.Worksheets(Cell.Value).Visible = Not ActiveWorkbook.Worksheets(Cell.Value).Visible