• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. R

    Remove Listbox item if match not found in VBA

    Thanks Hui for reply. I made it working by changing loop For intItem = ListBox1.ListCount To 0 step - 1 If IsInArray(ListBox1.List(intItem), myarray) Then Else ListBox1.RemoveItem intItem EndIf Next
  2. R

    RE;Formula hide

    Hi Sree Can you please upload a sample file. Will see.
  3. R

    RE;Formula hide

    Hi Sree To avoid errors in Column D, put these formula in D2 or wherever you need as =IF(ISERROR(SUM(A2:C2)),"",SUM(A2:C2)) If you want to lock column, first you need to select entire sheet and right click format cell, click Protection and uncheck Locked Checkbox. Once done, select column D...
  4. R

    Remove Listbox item if match not found in VBA

    Hello I am writing vba code that will search all listbox items against a entire column in a sheet. If listbox item not found in Excel sheet column, i want to delete the item from list. I tried few codes, its showing some error as "Could not get list property, Invalid property array index"...
  5. R

    Formula to call column based on criteria

    Perfect, Thanks Chihiro, its working
  6. R

    Formula to call column based on criteria

    Thanks bobhc, But is that possible to do in formulas, i saw somewhere using Index, if we entered the formula in once cell, it will show remaining in next row and so. i am not able to find where and how to do it.
  7. R

    Formula to call column based on criteria

    Hello to all I am trying to find formula for my excel file. i have 2 columns, one is Day and second one is Employee name, there is list of Days in column and Employee name is Column B. i have added drop down, once we selected day (Monday), i want to load all employees comes under that day...
  8. R

    Possible combination Excel VBA

    Sorry Narayan, I think i forgot make it multiselect. All listbox is multiselect.
  9. R

    Possible combination Excel VBA

    Yes, If they selected ALL, then they will not select another item. or else multiselect for all listboxes.
  10. R

    Possible combination Excel VBA

    Sure Narayan and Hui. I have attached my file. Here is the steps: 1. I have few datas in Data sheet. (This is PL Report, which is updating daily) 2. In home sheet, I have 5 List boxes. Based on the selection from Listboxes i need to copy row from Data sheet to Home sheet. 3. I have added new...
  11. R

    Possible combination Excel VBA

    I have 5 listboxes. All Listboxes contains a fields Called "All". There is a code in Excel VBA if Listbox is not selected as "All" then following code will execute. If i10.Range("A"& j)= ary(UBound(ary))And i10.Range("B"& j).Value = ary1(UBound(ary1))And i10.Range("G"& j)=...
  12. R

    Copy row based on listbox in macro

    I am creating Excel file, where i have 5 listboxes, each listbox is loaded with data from other sheet. What i am doing is, If i selected a item in all listbox, macro is checking next sheet, and displays row which has value that i selected in list boxes. This part i completed, Now what i...
  13. R

    f8 works but not in runtime, code skips in vba

    I am clueless, i have code that will do some form entering, it was working perfectly, suddenly it started to skip some code, When i run it through F8 (Step by step), it works perfectly, when i run it, it showing error, any suggestion, Here is my code, Dim ie AsObjectSet ie =...
  14. R

    Web scrapping To Excel using VBA

    Hi I have written some code using XML HTTP, still i am getting error as "Table not found". Here is my code. Sub AdditionalInfo() Dim oDom As Object: Set oDom = CreateObject("htmlFile") Dim x As Long, y As Long Dim oRow As Object, oCell As Object Dim data, aTable As Object...
  15. R

    Web scrapping To Excel using VBA

    I contacted, but not received any response, i will search microsoft XMLHTTP,
  16. R

    Web scrapping To Excel using VBA

    Sorry to ask you, what is that Pilot IE?
  17. R

    Web scrapping To Excel using VBA

    Thanks Hui and Marc, I have tried by recording macros using the manual. With ActiveSheet.QueryTables.Add(Connection:= _ "URL;http://xgis.maaamet.ee/ky/vorm", Destination:=Range("$A$1")) .Name = "vorm" .FieldNames = True .RowNumbers = False...
  18. R

    Web scrapping To Excel using VBA

    I am trying to scrape particular information from the below website. I have tried by recording macros, but i am not getting output for this particular website only. Website name : http://xgis.maaamet.ee/ky/FindKYByT.asp I have two column in my Excel sheet. Column A have some parcel numbers...
  19. R

    Merge excel files to master file

    1. Do you want a pop window to select a folder or you want to hard coded in your code. Yes, I need, because folder will be in different location. i need to browse 2. Is structure of the workbooks are same yes its same 3. Do you want to copy all the data, from starting row to end row, or some...
  20. R

    Merge excel files to master file

    I have excel files that i saved in a folder, i need to merge all excel files to my macro enabled workbook, [Simple excel file saved as macro-enable with one button as Browse, once i selected it has to browse my folder]. Once its browsed the folder it has to goto sheet name called "Data" same...
  21. R

    Monthly calculation

    Its working as per my requirements, Thanks Debraj.
  22. R

    Monthly calculation

    Ok fine. Thanks.
  23. R

    Monthly calculation

    Ok, as per example, For Project 1 I will get output as : (1.5*7) + (2*8) , because in Data sheet, only that two row falls under last 30 days criteria, (3/11/2014) and (2/12/2014) , remaining is more than 30 days, so i don't want that data, (1/13/2014) Project 2, date is greater than current...
  24. R

    Monthly calculation

    Thanks again Somendra, Here is the file, only changes is in first sheet one column is there Date, I need total $ which is between Today - 30 means from last 30 days, from each project how many hours worked and total $ spent.
  25. R

    Monthly calculation

    Hi Yesterday, i posted one post http://chandoo.org/forum/threads/calculate-sum-based-on-multiple-sheets.15298/ i got the perfect output from Somendra Misra, I have small continuation for that file. Bit different. In sheet1 i have Columns like: Project, Employee Name, Date, Hours In Sheet 2 i...
Back
Top