Search results

@deb Bhai in the List Tab i have mention the Party names in C6:c50 and In H5 = ABC AND I5 = XYZ and from H6 to I50 i have given the Quantity of Opening Balance Say H5 - ABC I5 - XYZ 10 5 -5 15 Hope it clear Thanks

@NARAYANK991 Thanks for your valuable replay, yes i forget to mention the End Date Column Sorry for that now coming to point about my question is that In List Tab i have mention the Party Named in the Column C and In Column H5 & I5 i mention the Brand Name, from H6 to I50 i mention the Party...

Hello i have small problem that is i want to add the Start Date and End Date in a Sumproduct Formula as a extra Critera my formula is =SUMPRODUCT(('Dealer List'!$C$6:$C$50=$C9)*('Dealer List'!$H$5:$I$5=F$7),'Dealer List'!$H$6:$I$50)+SUMPRODUCT(('Dispatch Register'!$F$6:$F$3490=$C9)*('Dispatch...

@VDS Sorry for my late replay, i can't under stand why the formula is not stand in your system any how Please try another one Say your date in Range A1 = 30/11/2013 in B1 = Text(a1,"dd") in C1 = Text(a1,"mm") in D1 = Text(a1,"yyyy") Hope it's clear your problem Thanks

Glad your problem solve

@VDS yest it can be done using with Text Function say your Date in A1 as = 03/12/2013 simple type in B1 as = TEXT(A1,"ddmmyyyy") then the date filed will be display as 03122013 Hope it clear now other wise please upload a sample file Thanks

@VDS sorry i can't understand what you say if possible please upload a sample file then i will try to solve your problem as per my understanding in the Govt. section there are some VBA Experts who build the format the date field should be enter as text format due to the Regional setting is...

@VDS you are using the word format i think it is better to use the Excel file, i will give you some details how to maintain what is your format please fill all in the Sheet1 and link to Sheet2 with this formula =MID($a1,COLUMN()-1,1) and drag to right and down for your better knowledge i...

@joharmenezes Not sure what you are trying but you can try this =IFERROR(VLOOKUP(A1&"*",Sheet3!$A$1:$B$3,2,FALSE),"") or =IFERROR(VLOOKUP("*"&A1&"*",Sheet3!$A$1:$B$3,2,FALSE),"") for your knowledge i attached the sample file Hope it will solve other wise please inform Thanks

@VDS we don't need any personal information here we just want your column heading with dummy dates and dummy contents of your data that's all and your expecting result data That's all Hope you understand Thanks

@VDS if possible please give us a sample file with your desire requirement, it is good to solve your problem correctly Thanks

@VDS When you are going to use the formula then no need to set the custom format because your result will come directly as you required Exp Say your Date range is in A2:A1000 and you want the Date formula to be in "MMMM,YYYY" in the Range B2:B1000 Then you use the Formula as per mine or...

@VDS That is not a formula, what faseeh explained you select the Range which you want to the Date format as MMMM, YYYY Say your range is $B2:$B1000 select the range mouse right click format cells Custom in Type select the format Desire Thanks

@vds that is not in date format it must be in text format please check the Range B84

@VDS Try this, say your Expiry date column in E and month column in F then try in F2 =TEXT(E2,"MMMM, YYYY") Hope it clear other wise please give some more details Thanks

@Ranjeet Hello, first of all i would like to remind you this is week end and some of our members are from different places so you have to patient to get the replay about your question. please read the forum rules once again if you read already Forum Rules coming to your point please check...

@somnath i didn't get any macro in your attached file

@nacer sala Welcome to Changoo.org, Glad you are here, first of all i would like to inform you that before post a question please read the forum instruction from the given link http://chandoo.org/forum/threads/new-users-please-read.294/ hope you understand Thanks

@Portucale Welcome to Changoo.org, Glad you are here, as per my understanding your First Column that is Column A named as ADV_OffphoneHrs and Column B as ADV_OffPhone if it is correct then correct this line as for i = 0 change for i = 2 it is better to upload a sample file to get...

@lohit Hello Very Good Morning Thanks for your Valuable Replay Sorry for my late replay, i was just out away from my system for 2 days that's why i can't replay you as per your instruction i check there is no Disable Addins list in there. now i am going to do your 2,3,4 steps let see...

@SirJB7 Thanks for your Replay Hmm, i can't upload the file here sir if you will give your mail id then i will send the files to you Thanking You Regards

@Hui Thank you Sir, i will try as per your instruction tomorrow in my office, if any problem i will inform you Thanking You With Regards

Sure Sir, i will send the tom Thanking you With Regards

@Narayan Sir, as per you instruction i un Install the Office and Re Install but there is no change it will crash the excel file Regards

@Mridul Welcome to Chandoo.org, Glad you Are here you can use move or copy option open your both files 1. Select the Invoice!b5 sheet 2. Press the mouse right click button 3. Select Move or copy 4. Select the Option To Book (where you want to move the sheet) 5. Choose where you want...