Search results

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

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

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...

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

Namaste all, Have uploaded sample file so u can easily check what i desire. Unable to explain that in word. Hope you all can understand. Regards Istiyak

Hi Team, I have one queary. Unable to creat Calculated Field in PVT which content Contribution of Each Category. Product Figures devided by TTL Grand Figures. Attaching File for the same. Regards Istiyak

Hi freinds, i have large data approx 50k rows. In last column i have a amount. I want some specification I.e. 1.5k-2k and so many others as i want this with the help of formula. I have used nested if and got sucess but as u know we are able to enter only 7 criteria. Is there any way so...

i have uploaded a file on my website. www.istiyakshaikh.hpage.com > Downloads > Calendar.xls Kindly add the code in the file, so that calendar can popup with current date. Control : Calendar Control 11.00 Format : Excel 2003 Any query plz let me know. Regards Istiyak

Today i m working with macro and i acknowledged that i need to assign a macro to the hyperlink. After so many research i m zero...... Plz help me. Waiting. Regards Istiyak

Hi friends, I have two problems. 1. i have inserted one picture in my excel book when i m clicking on it is showing me caledar which i have added in VBA module. The query is that i want to popup that calendar with current date. i is not updating every day (Not showing current date by...

Is this possible to creat dropdown list based upon files available in Specific folder. I.e. folder on desktop = Exported data Files in folders = 0229.xls, 0429.xls, 02452.xls etc,. So is this possible to creat dropdown in my actual sheet. waiting for solution. Regards Istiyak

Hi, I don't know it right or wrong but i just wanted to know what is the Diffrerence Beetween "Class Module" and "Module" in VBA screen. Regards Istiyak

Hi Team, I have uploaded one file on my website. http://www.istiyakshaikh.hpage.com > download > problem.xls Eximine the file and let me know what is the problem. Copy original data and paste it in column A to D (etc) While i m running a mecro it is convering value wrongly...

Hi,,,.. i m having atleast 40-50 name ranges in my workbook. it is very long process to copy and paste name ranges in sheet for reference. Can i know is these possible to Extract Name Ranges To Excel Sheet.?? Regards !$T!

Hi.. There are two problems i m having. 1. I have added advance control (Calendar Control) in my form. when i m opening that form on my pc it is showing that calendar but when i m opening that form on another's pc it was blank. i think that might be going on due to advance control not...

Can we negotiate VBA on any error while VBA is executing. Regards Istiyak

I m using 2003 at my office and my other office using 2007. The query is that when i m designing something in 2003 and open it at my other place in 2007 it will looking mismatch..... (not at proper place as i already set up good in 2003). while i m coming back and checking it in 2003 it is...

Can we add a Calendar Control In Forms..??

Namaste Team, I need VBA which do something on given topics. 1. Set location on SHEET1 and CELL A1. 2. Auto enable mecro 3. Auto Enable Design mode of Form COntrols. So user can start work directly, they don't have to do anything else Any idea plz let me know. Regards Istiyak

Namaste Team. Plz examine the given formula and revert with the solution. =if(a1=b1,hyperlink(a1,"Check"),hyperlink(b1,"Check")) While i am clicking on it, it is going on a1 even the condiotion is false (Naturally when condition false it should go on b1). Suggest what to do.? Regards...

Namaste Team... I want to creat 1 employee master file where i have to enter every details of employee with their photo. I am able to enter every data in database sheet with the help of mecro but having not idea to copy past image with help of mecro. Note : Image should be on fix location...

Hi Team, I m not very mch powerful in VBA bt preety sure you guys help me. Need Simple VBA For Given Details. Sheet 1 cell Details A1 Mr. Null A2 Week2 A3 Site0452 Sheet 2 name=ANYTHING Need to creat 1 folder in current directory where file saved with the content in A2...

Namaste Team, Have uploaded one small pic on my website www.istiyakshaikh.hpage.com > dowloads > shortcut Can any one give me if any shortcut for that ?? Help Appriciiiiattteedd ?? Regards !$T!

I have uploaded a file on my website, path is given below http://www.istiyakshaikh.hpage.com > Dowloads > Query.xls Can anyone help me for the same. Any query plz let me know. Regards !$T!

Greetings.! Can we search the similar records with the help of any formula. If we enter john in cell a3 so in search cells (a5 to last cell depends upon the results of entered value) we can get similar values of john. I.e. John smith, john paul, john ntan etc.... Which depends upon a lookup...