Search results

Dear All, I have a sheet, in which lot of dates are there. I want to create a CF to highlight cells which contains specific year. For example if the cells contain 1-1-1908, 2-10-1908, 11-11-1908 (these three cells belongs to year 1908). Now if i put this year 1908 in CF, all these cells should...

Dear Cammandk First let me confirm some details: 1. if Z11 = "1" then I need the code to copy AA11:AG11 to Sheet8 B3 (Is the range AA11:AG11 will be same for all during the loop?) 2.The loop goes all way down to Z386 and copies any rows with "1" in to Sheet 8 (In this line you are saying that...

Dear VDS, Please read below posts, it might resolve your problem http://chandoo.org/wp/2012/08/17/extract-dates-from-text/ http://chandoo.org/wp/2012/06/19/extract-numbers-from-text-excel/ http://chandoo.org/wp/2011/08/23/split-text-on-new-line-macro/...

Dear Abhijeet, If the format is not fix, you should explain, how you want the formula to get your desired result. In the above "15.12.2013 343 S030.tif" we are thinking that first 10 digits (15.12.2013) then your required 3 digits (343), so should adjust/know the position of your required data...

Failure will teach, challenge will learn

if this was your stardard format means rest of the text will same as the format "15.12.2013 343 S030.tif", then u can use =MID(B1,FIND(" ",B1)+1,3)

Dear abhijeet, before proceed further, i just want to ask one thing that, the above sentence "15.12.2013 343 S030.tif" is this was written in any cell in the excel worksheet or this was a file name which was saved in your system. Please explain

thank you Hui, for your support

Thank you dear, i expect more from you, i learned so many techniques to how to solve the problems.

Dear Jfern024 There are lot of ways to achieve this. My using named ranges Create named ranges as Week1,Week2,Week3,Week4 and put dates like 1-7-13 to 7-7-13 in week1, 8-7-13 to 14-7-13 in week2 and so on. After you created range names, click data validation in one of the cells and...

Dear All Can you please share your favorite URL link which can explain Dasboard concepts and preparation very clearly. I want to learn dasboard preparation, but can't able to get proper sites. Regards vijay

Thank you so much Luke, Very interesting to skip the operation with Label option, i never think like you, Great Dear Sirjb7, Initially when i started this post, i already mentioned that it is a one of the part in my project, and that time, my query is about "SELECT CASE" and now "SKIP" option...

Dear All I want to skip a file selection, when the file name starts with QP. Below is my code, The problem is that file names which are starts with after Q, then the files not selected, and code exit, So i need a code, it need to send all files except the file name starts with QP in that...

Dear Dev Have i sorted out your problem? Regards vijay

Dear Dev Can you please mail the file to my email id : vijaykumar [at] yamaha-motor-india [dot] com

Dear Sirjb7 In my system, it is not appearing, how can i get this. ms office info: office 2010, 32 bit windows 7 Professional SP1, system type 64bit Regards Vijay

Thank so much colin for your valuable comment/suggestion

Thank you so much Colin. Very clear explanation, now i understand why the code doesn't work.

Dear Colin Legg, Thanks for your suggest, it works but still i am in confusion, why the previous method like myfile.name not works. On error resume next i put, becoz my project is in under preparation thanks vijay

Dear In SUMIF(range, criteria,[sum_range]), in sum_range you can select entire range from C to Z, it will sum all the values for the criteria you specified Regards Vijay

Dear Sirjb7 Thank you so much, Please find below filenames which are printed by Debug.Pring myfile.name HARENDRA27-Jun-13-100638.xlsx KAPOOR27-Jun-13-100638.xlsx NIKHIL27-Jun-13-100639.xlsx NITIN27-Jun-13-100639.xlsx PPS27-Jun-13-100640.xlsx RAJDEV27-Jun-13-100640.xlsx...

Dear File name will be done on this line xMonth = Format(xDate, "mm mmmm") xFile = "CHReport_" & xCurrentName & Format(xDate, "dd-mm-yyyy") & ".xlsx" xPath = xDir & xMonth & xFile xFile is your file name. Kindly change as per your requirement

Dear All Can you please rectify, what is the problem in below code Sub SendMail() Dim fso As New FileSystemObject Dim myFolder As Folder Dim myFile As File Dim OutApp As Outlook.Application Dim Attach As Variant Dim Email As String Set myFolder = fso.GetFolder("W:Quote Pendency")...

Dear SirJB7 Win Diff, is this internal program or external program, becoz i can't able to understand "Run Windiff"

Dear sgmpatnaik I can't tell you the process, becoz i have a tool to remove/recover the password. If you wish to know the password of your original file, then u have to sent it. I will keep your privacy. Regards vijay