PDA

View Full Version : Excel Help



Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 [163]

  1. [SOLVED] Extract numbers starting with 07
  2. Formulas no longer work in Excel for Office 365
  3. [SOLVED] vba sum format number with currency
  4. UserForm to Return the MAX date in a TextBox resulting from VLOOKUP in ComboBox
  5. [SOLVED] Add Roundup formula to VBA button
  6. [SOLVED] help adjusting code delete empty rows based on condition from sheet1 to sheet2
  7. VBA code to copy to new workbook and insert pivot
  8. [SOLVED] Highlight cells that contain specific words
  9. [SOLVED] question re "for each range in target"
  10. Please help VBA Coding for Repeat Task for Step 2 to Step 6
  11. Advice on comparing excel workbooks
  12. Help!! Merging multiple Excel workbooks into one master sheet.
  13. VBA to check if object is inside or outside of freeform area
  14. [SOLVED] I want my reset button on VBA userform to do nothing if "no" is selected
  15. [SOLVED] How to define range based on the value of another cell
  16. Check if labels are visible
  17. [SOLVED] copy multiple rows of numbers to new location on same sheet.
  18. EXPORTING DATA TO MS ACCESS FOR SIMULTANEOUS MULTI USER
  19. [SOLVED] Part of a string
  20. [SOLVED] Delete text line with specific word from multiline cell
  21. Search for a string in text files.
  22. Publish to Sharepoint
  23. [SOLVED] Transferring selected cells to a new sheet
  24. VBA mult AdvancedFilter - Unique Column 1, Greater than 0 Column 3
  25. Replacing Date with Period Based on Matrix
  26. auto fit cell height for merged cells in sheet that has protected (locked) cells
  27. Convert Binary to decimal on and vice versa on VBA
  28. Solver in Userform Linked in Excel
  29. Using non-contiguous ranges in Solver VBA
  30. Help VBA search
  31. [SOLVED] Finding cells formatted with colour gradients of various colours
  32. Like expression with AND or OR
  33. Formula/vba - Summary Report without Pivot
  34. [SOLVED] VBA - Filling Master Template
  35. Room Booking System
  36. combine multiple txt files
  37. [SOLVED] How to Add Different Texts to End of Excel Cells Macro
  38. VBA - Collection help..
  39. Date Picker VBA that will work on all versions of excel
  40. Copying multiple text files into one excel but different tabs
  41. MISSING DATA IN EXPORTING CALCULATED QUERYTable FROM ACCESS TO EXCEL USING EXCEL ADO
  42. [SOLVED] Pull rows from array given two conditions
  43. [SOLVED] Run-time error '424': Object Required
  44. simple copy-past
  45. Subscript out of range error in VBA code
  46. Replacing multiple numerical values
  47. Insert a line break after word wrap
  48. newbie vba questions & help with posible loop for multiple cell values to sheet
  49. [SOLVED] VBA- Variable declaration help
  50. VBA Array Help in filtering data with logic
  51. [SOLVED] Combo Box Index select
  52. [SOLVED] Combine common worksheet names when splitting a file
  53. [SOLVED] Turning off alerts issue
  54. How to Copy Paste Symbols-Phonetics Data to Excel sheet?
  55. Range.Find Issues
  56. [SOLVED] When you have one workbook, two windows, does any event happen closing second window?
  57. Is there any event allowing Cancel of closing a Window (not closing a Workbook)?
  58. Apply AutoFilter based on selected cell in another sheet
  59. Declared public variables have ceased to pick up values
  60. [SOLVED] Copy and rename multiple sheets
  61. Excel 2016 Open Read Only file
  62. [SOLVED] Interactive Way to Search Based on First Few Characters Typed
  63. [SOLVED] Between two numbers
  64. [SOLVED] Clear all textboxes except 1
  65. [SOLVED] Copy value - Another Excel
  66. Splitting up a String
  67. Delete certain rows and highlight certain cells
  68. How to remove [TAG 001], [TAG 002], [TAG 003], etc from string
  69. Prepare hierarchical and non-numeric pivot tables in Excel
  70. Search string if it contains words from a range then replace with adjacent cell
  71. Inserting Recordeset into Access DB via VBE - Error operation must be an updatable...
  72. [SOLVED] Sum values vba code
  73. Running macro on files in a folder: impossibly hard!
  74. Count only visible data after filtering
  75. VBA to perform lookup for individual lookup range
  76. [SOLVED] Cannot show merged cells
  77. copy and change date
  78. [SOLVED] Copy Data from worksheet to another one with VBA
  79. Bad file name or number - Runtime Error 52
  80. [SOLVED] Changing Column Headers
  81. VBA code: copy data from sheet and paste values onto another specidied workbook
  82. Get first and last dates (dd/mm/jj) from year range
  83. vba - Extract Unique values from Single Column via Colllection and Dictionary
  84. [SOLVED] Data Conversion using Dynamic Multi-Dimensional Array
  85. [SOLVED] Linking a commandbar button to a macro in an addin
  86. Macro for sorting by lot number, splitting table w/new header, then sort by due date
  87. [SOLVED] Fill Column
  88. Array only returning first column of values
  89. [SOLVED] Pass Params on Activate event
  90. easy VBA seek for help!
  91. Help with random selection and variable criteria
  92. Multiple Rowsource in combo box?
  93. pick a new interior color from an array when next color is needed
  94. [SOLVED] How to fetch data from a excel table with multiple rows.
  95. [SOLVED] Match FileNames and then Merge those PDFs
  96. Userform with listbox and checkboxes that finds values on a worksheet
  97. counting number of occurrence of a value and depositing that number in another column
  98. [SOLVED] Refer to range in cell formula
  99. PLEASE HELP ME!!!
  100. Select Random cells from range
  101. Get name of procedure
  102. Reconciliation based on recurring values
  103. [SOLVED] [R1C1] Formula with a loop index in VBA
  104. [SOLVED] VBA code to set print preferences
  105. [SOLVED] How to Selection.Insert Shift:=xlDown with keep destination formatting?
  106. [SOLVED] SAVING RANGE AS PDF FOR MULTIPLE FILES
  107. [SOLVED] Problem with hiding rows
  108. Multiple dropdown list
  109. Excel Sumproduct Count Blank Cell as well...
  110. Caption label
  111. Modify macro to output to Combobox
  112. Extract Items from String and then Sort
  113. Matching data from columns with offset multiple row data in other worksheet
  114. Cell content as part of filename
  115. Count colored cells in a range using columns and rows, output result
  116. VBA scrip to sort data inside sheet
  117. Number help
  118. [SOLVED] Copy / Paste data ranges to specific locations
  119. application.run - return value byRef
  120. Control Tip Text
  121. [SOLVED] How to get the first & last range value for this type of data...?
  122. Updating a Chart while VBA is running
  123. Copy Multiple Files from Absolute Paths to SharePoint with Same File Names
  124. VBA problem
  125. [SOLVED] Copy and paste VBA
  126. [SOLVED] VBA code for selecting data from statement to output sheet
  127. [SOLVED] VBA Code to remove Data embedded in the "Pick From Drop Down List"
  128. [SOLVED] Userform open from one worksheet and referencing another worksheet
  129. VBA code not working in 365
  130. Error Handling for InputBoxes
  131. Run-time error 438: Object doesn't support this property or method
  132. [SOLVED] Copy .pdf files from one location to a new folder based on a list of cell
  133. [SOLVED] VBA Code to add groupings to subtotals
  134. [SOLVED] Need help with logic
  135. VBA Advanced filter help..... Criteria excluding a list
  136. BeforeSave and Userform: Issues with saving the excel file
  137. [SOLVED] Multiple selections from drop down list
  138. On editing protected view programmatically , display setting are getting changed .
  139. VBA filter and cell formatting
  140. Copy data from one sheet to another sheet where the values are matching
  141. Help import from csv file
  142. Search data using Userform and then scroll through matching records
  143. VBA how to superscript characters in a string following an apostrophe?
  144. [SOLVED] Declaring Variable Type - Excel 2013
  145. Export as CSV file
  146. User Form - Many Text Boxes - Restrict One Text Box with Password for Editing
  147. Loop through a folder and copy data from files to another WB
  148. Word file - filled using excel and send by email as attachment
  149. Why is my code showing error??
  150. [SOLVED] VBA to replace previous table and check if one cells value is equal to the previous o
  151. Print to PDF file
  152. [SOLVED] VBA Code to Run Code Across Multiple Worksheets at One Time
  153. Array issues - one vs two dimensional
  154. Excel VBA code to Delete 'Heading 1' from Word Document
  155. Excel to JSON -- bracketing
  156. Findvalue from 2 searchstrings
  157. VLOOKUP not working properly
  158. [SOLVED] Use .Range("A1:A10000") to end of records?
  159. How can I control when and if my chart updates and not updates?
  160. My chart "hides" from view sometimes after running or when idle.
  161. Two userforms in one sheet
  162. [SOLVED] Create a File list with metadata
  163. Filepath to reference cell value
  164. [SOLVED] VLOOKUP Not Updating when Data Repeated
  165. Userform - Compile Error: Invalid qualifier
  166. [SOLVED] Format transfer to sheet 2 after match in sheet1
  167. Creation of File list in a new Workbook
  168. [SOLVED] Printout VBA
  169. [SOLVED] VBA Code to stop loop if cell / range is blank
  170. Crank Nicholson
  171. Crank Nicholson Method
  172. [SOLVED] 2 separate change events code issue (Floating Cmd Button & List box selection)
  173. Input user form to change cell value
  174. Excel help copy and paste from sheets then move to next row
  175. Formulas NameManager
  176. Excel vba merge cells based on duplicate cell data
  177. Transform data type in column
  178. VBA to Recalculate Grand Total
  179. Application.Match gives 'Type Mismatch' only on descending date values, match type=-1