PDA

View Full Version : Excel Help



Pages : 1 2 3 4 5 6 [7]

  1. Macro To Browse&Select File and import Specific Data
  2. BB codes with Excel 365
  3. Mail the files by vba to a specified email id
  4. compare data ... Incomplete rubbish
  5. Populate Address From Google Search
  6. Apply Vlookup formula in all the available sheets in a workbook
  7. VBA: Copy files in excel, edit and save
  8. Create copies of Worksheet (Master) based on a Range in another worksheet
  9. Extract Multiple Rows into a Limited Template based on Multiple Criterias
  10. Using "IF" in conditional formatting
  11. copy and paste by VBA based on criteria
  12. Close All Open Excel Files With VBA Open Close File issue unsolved
  13. Conditional Format Based On Percentage Variance
  14. Find & Replace during cell copy from page 1 to page 2
  15. Populating Userform from table and change table entries
  16. VBA - Command Button to Multiply Value In Cell in Last Updated Column
  17. VBA - Need a VBA to unprotect all worksheets in all workbooks in a given folder.
  18. Split Multiple workbook in a folder into separate worksheet and rename the file name with Date
  19. Mystery with Text formatted cell - Help
  20. VBA to create formula references and values in Sheet2 that either reference or are derived from Sheet1
  21. Identifying cells with two or more images in them
  22. Add Remark in cloumn based on calculation/comparisons in one worksheet
  23. VBA required to delimit cells with Rules applied over it.
  24. Copy and paste of data if matches Conditional calculation and pasting of the data
  25. VBA for dynamic sheets name + dynamic link + hide sheets based on a cell Value
  26. Active X TextBox with fixed width, but dynamic height
  27. Need a shorter VBA code: Hide and unhide sheets based on presence of name in list
  28. Select column based on user input
  29. Msgbox notification with paasword by vba macro
  30. Autofill and Reverse Autofill
  31. consolidate a notepad by vba
  32. Extract Pictures From Multiple Sheet Overload (Occurring Duplicate)
  33. listbox populated with Vlookup from multiple worksheet
  34. Insert Pictures From Multiple Sheet in Any Cell Then Auto fit Resize
  35. listbox value transfer to new excel worksheet
  36. VBA intersect function for rows and column
  37. Cell Value to become part of RC in macro
  38. Cut & paste between sheets Move Some Data Rows To New Worksheet Based On Conditions
  39. Compare worksheet names
  40. Problem inserting new worksheet in Excel daily time tracker w/ date format (at specific location in book)
  41. Link same cells across multiple sheets
  42. Want to learn excel VBA
  43. Tree-Like Horizontal Hierarchical List in Excel
  44. VBA to show text "Enter Text Here" in excel cell
  45. Adding value of two cells to get result in 3rd cell
  46. Reserve the Horizontal line numbers and information , but the calculation result is change
  47. Hide Comment Red Mark but Show comment on hover
  48. Drop-Down Menu with Multiple Conditions
  49. Can the attachment be completely turned into VBA? (No More Formula)
  50. Conditional Appearance of msgbox
  51. Auto Show Drop-Down List When Selecting the Cell
  52. Showing Custom Value Based on the Condition of Dynamic Table
  53. Macro to Count below and drag across
  54. Autofit Merged Cell Row Height for Some Specific Rows Only
  55. Automated Search Results Returning Nothing
  56. Align TextBox Within A Range
  57. VLOOKUP on Matching Multiple Criteria
  58. Run Macro one after the other
  59. HELP - Calculation Based on Dynamic Variables (What-if Scenario)
  60. Dependent Drop Down Lists
  61. Concatenate with style
  62. Help requested for code in an existing post (check if OCX file already registered, if not register it)
  63. Convert all columns with dates to serial numbers vba
  64. Display a message if already saved data
  65. Order multiple texts in "row.cells" in columns
  66. Need help to convert Excel data to XML
  67. Using text in an excel cell drop down list to open Microsoft access to a specific record using VB.
  68. corrupted Personal.xlsb?
  69. Rearrange Data - Sheet 1 into Sheet 2 Macro?
  70. Can not copy data with VBA code
  71. VBA Macro which create new lines by codes
  72. XLM Macro 4.0 Exec string is to long/
  73. How to calculate best bowling figure (cricket)
  74. Run-time error 1004 when trying to resize a multi area range object
  75. formatting number in csv file import. Number being rounded / decimnal places truncated
  76. Get Pictures from Word Documents in All Sub Folders
  77. VBA Beginer -Real Estate Industry
  78. Autofill Text if Criteria are met
  79. Summarize Data from Dates to Months based on Criteria
  80. Vba - Check String/Text From Multiple Workbook Without Opening All Files
  81. VBA : Insert Pictures With Multiple Select Picture & Consecutive Placing
  82. problem hilighting or editing within the EXCEL CONTENTS BOX of the FORMULA BAR
  83. User Form entry in a second sheet - need help with VBA code
  84. VBA Import Table From MS Word Included Format
  85. VBA Copy Tables from Word to Excel
  86. Explain App.Index(Rng, Rws(), Clms()) (multicolumn Combobox with Index.application)
  87. Macro or VBA to sort values
  88. Update Row on another sheet based on Cell Value
  89. How can I concat a Do While result?
  90. find last alphanumeric row of .txt file and fill into excel cell
  91. Transpose 2 column [Key, values] list to mulit column [unique Key, Value1, value2, value3, ......] list
  92. Add the value taken from the user to my range for ActiveX ComboBox
  93. create form with ActiveX combobox, textbox
  94. CORRECT WAY TO FILL A TEXTBOX
  95. Copy data from multiple rows between two keyword and paste the data in row(s) of single cell in sheet2
  96. Make all text file content in one line if a space found
  97. in VBA if the given string is found then delete everything between two newlines where the string appears.
  98. VBA: keep only one searched string.
  99. Error in code conditional formatting
  100. Vlookup and Match problem
  101. Update my existing macro to be able to update and delete
  102. Copy to Summarise data based on 2 criteria: User ID and gaps in continuous day segments for same user
  103. Excel VBA Highlight Duplicates and Duplicate between Range
  104. Dropdown menu that inserts signature Picture from selected name: Not always working or gets wrong picture
  105. VBA code for adding data from a sheet to another
  106. How to insert picture using VLOOKUP Formula!
  107. Help with calculating percentages
  108. Right Hand Side Range Range Value values Range=Range.Value only sometimes. Range Range.Value Anomaly
  109. VBA - Count filtered rows in the table
  110. Make a created file protected by password
  111. finding differences
  112. ADS info via VBA 64bit
  113. How to Apply Payments to Aged Receivables Automatically using Excel VBA
  114. VBA split files - confirmed saved in directory, but directory is blank
  115. Lock rows with dates 30 days in the future