Search results

how shocked.? Still no any answer from any excel ninja.

Please help if any one is working on this.

Hi Excel Ninja's, Need help on Calculated Item in PIVOT TABLE. Attaching the File for the same. Hope file will explain everything. Please revert if any. Regards Istiyak

http://chandoo.org/wp/2014/02/13/dynamic-cascading-dropdowns-that-reset/

Open Ms Access 1. Go to External Data tab 2. Select " Excel " under Import field 3. Select your file It's Done. Access is the local PC database tool which allows the lots of technical features to user i.e. Tables, Query, Forms, reports etc.. Hope this will helps u. Regards Istiyak

here is the formula help.

Hi Hui.. Its not working on my system. showing error on Combobox_Change() event on [Campaign] line please suggest

you can use GoalSeek feature of Excel

Use helper column with formula. Left(Cell NO of 16digit card,16) now you can perform your task with this helper column have look on sample upload

This is brain stroming activity.. actually take time.

Just go to field setting and do it From "AVERAGE" to "SUM

Hi hui, I want create calculated filed like this =BillPen/(SUM('Bill Count' )-sumif( 'World',"Store", 'Bill Count')) It is giving me an error. Please suggest. Regards istiyak

when we are calculating data for the week then it is giving problem, if we are doing the same things with particular day data then its working fine.

Hi Hui, Above is the normal things which i have already done. but the question remains the same. 1. Bill Count is the main count fill Suppose its 1 in this we are having sub parameter like billpen is the sub count ie. 1,1,1,1.. So this each 1,1,1, needs to be devide by SUM of Bill count of...

Hi Team, i have some query as i uploaded sample file. Kindly help Snap is as below. Also please if i will compare two three or so weeks then result should be same. Regards istiyak

Sub mymacro() MsgBox ("Enter Pressed") TextBox1.Value = "" UserForm1.TextBox1.SetFocus End Sub Private Sub CommandButton1_Click() MsgBox ("Enter Pressed") TextBox1.Value = "" UserForm1.TextBox1.SetFocus End Sub Private Sub tExtBOX1_KeyDown(ByVal KeyCode As...

pfa sample file attached.

Team, i have code but "SET Focus" is not working, system directly setting focus on Last element of Forms i.e. Submit button on form

Hi Ninja's, Supposed i have a form which i have designed for some inventory scanning purpose. In this form i have a text box in which i will scan barcode of particular inventory. So when i will scan those barcode Code it should be work like after scanning it should check logics and then...

you can Make one excel on desktop in which you can get latest updated file on top OR seperately. by creating an object you can also open that latest updated file.

Hi please check this. it might help.

Hi Team, Need Slabwise description. Sample Excel file is self explanetory. Kindly Help to do that. Regards Istiyak Snap :

Select a range from just below the available dragging point to end range. Now press Ctrl + ' and then press Ctrl + Entrl :)

http://chandoo.org/forum/threads/static-timestamp.20951/ This might be help you out.

not getting desired result.