Search results

@Ben Millen Welcome to Chandoo.org Paste the below formula in the Column D1 or where ever =SUM(IF(FREQUENCY(B:B,B:B)>0,)) The Above formula count only unique No. not the duplicate Now Place this code in UserForm Private Sub UserForm_Initialize() TextBox1.Value = Worksheets("Daily...

@tarynmahon Change this $A$1 to $A1 copy and drag down other wise please upload a sample file Thanks

@pankaj Please mention the Exact result which will be come in there in manual figure with that it is ease to give the correct formula Thanks

@Marco.Zingariello Please change the Range type in your master book as K:K to K2:K1000 etc hope it will give some thing other wise inform us Thanks

Glad it helps you

@Somendra Misra It will look good or not if we mention the Day also in the Calendar with little bit add in your formula =IF(B15="","",INDEX("Day " & B15 &" - " &$C$5:$I$9,ROWS(J$15:J15),MATCH(J$14,$C$4:$I$4,0))) Thanks

@garyaps Welcome to Chandoo.org group, glad you are here please upload a sample file with you desire requirement. There is lot of tricks to use the copy and paste method with VBA and Formula also. Thanks

@DashboardNovice Place This Code in the Command Button and press Private Sub CommandButton1_Click() Sheet1.PrintPreview True For i = 1 To Worksheets.Count strRes = MsgBox("Do you want to print " & Worksheets.Item(i).Name, vbOKCancel, "Print Preview") If strRes = 1 Then...

@Richard Welcome to Chandoo.org, glad you are here Some of your requirement is done by formula and some to be use with VBA for export the PDF. It is better to upload a sample file with your desire required to understand before you start a point please check this link...

Hi SirJB7 After Long time we can C you, Glad you are back. and finally i got the thread which i start this thread http://chandoo.org/forum/threads/run-excel-file-only-on-designated-computer.9508/ actually in our profile page we can't get all the threads which we started or replied

@DMA Try The Below Code Sub UpdateLogWorksheet() 'http://www.contextures.com/xlForm02.html 'code by Dave Peterson and modified by cdbauer1 'Make sure that your column headers on the PartsData tab go in the order of the Data Validation list and that they are identically named Dim historyWks...

To Post codes use the codes as before code ([)code(]) after code ([)/code(]) Don't use this () Hope it clear

@ManuGrim can you please elaborate the problem what do you want to express exactly

@ManuGrim Please Change Your Code to This Sub Worksheet_change(ByVal Target As Range) If Target.Address = "$C$1" Then Select Case Target.Value Case Is = "House" Sheet1.Range("D:ZZ").EntireColumn.Hidden = True Sheet1.Range("D:F").EntireColumn.Hidden = False Case Is = "Car"...

Glad It Worked

@leimst Try the below code Sub Evaluate_Data() Dim i, j, LastRowSh1, LastRowSh2 LastRowSh2 = Sheets("Reference").Range("A" & Rows.Count).End(xlUp).Row LastRowSh1 = Sheets("Data").Range("A" & Rows.Count).End(xlUp).Row For i = 1 To LastRowSh2 For j = 1 To LastRowSh1 If...

No Luke I can't remember the links because they are too old and i try to remember they are but i can't now. it's ok no problem when i remember then sure i will knock your door bell One more thing, for what i am searching is i have created some excel files and i want these files are run only...

noop nothing is happen

Hi Luke Thanks for your Replay, sorry i can't remember that and i tried to search with few wards but i can't, and one more thing in my book mark there is one thread which is hui replied for restrict the file to work in another system with IP address or what any help about this Thanks

Hi I have Small Doubt that is how to find our Book Marks and Important Subjects which was settled in our Old Forum. Due to i have some important books are in there but i can't find them here and in my profile too Kindly Suggest me about this Thanks SP

@Sathish it's give the hole value as 9.11E+14 so there is little change Select Whole Column - > Ald +D+E - > Next - > Next - > Select Text - > Finish

@kumar Try this in B1 and copy down =IF(ISTEXT(A1),A1,IF(ISNUMBER(A1),TEXT(A1,"0")))

@Some it's give the same result of edited cell not difference

@kumar Select your range and Format them as number and remove the decimal placess in number format

@Abhijeet Why not you hide the Folder and sub folders from option of Folder and Search Option 1. First select the folder which you want to Hide 2. Right click on the Selected Folder 3. Select Properties 4. In the General Option you can find the Hide and Read only Access Now your...