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 [164]

  1. VBA That Will Group Specific Blank Rows
  2. Form Close
  3. Excel formula help match
  4. VBA Replace From Code to Range
  5. VBA search function
  6. Batch script for inputting data into cells
  7. Cascade String concatenation problem
  8. ClearingContents in ranges that don't intersect
  9. [SOLVED] Export Multiple wbk
  10. Delete the list from UserForm
  11. Drop down list without blank cell
  12. Data copy from other sheet based on cell value
  13. Issue with code to check whether an excel file is open or not
  14. VBA Help - Avoid triggering a Change Event on Delete
  15. Best Approach to Do This Report
  16. Creating Multiple Tables Using Loop in VBA. I still want to add new sheets and add
  17. [SOLVED] VBA code excel
  18. Get Msgbox in a table
  19. [SOLVED] Question about excel instances locked down if spreadsheet hidden while using a form
  20. [SOLVED] Moving Rows
  21. Lock cells and paste values based on a cell value
  22. VBA help, export from Excel to text file, insert delimiter
  23. Help with hiding rows based on content of a cell
  24. [SOLVED] Extract Multiple Rows into a Limited Template based on Multiple Criterias
  25. [SOLVED] Recalculate the cells in a column to achieve a set SUM value
  26. Excel vba crashes?
  27. [SOLVED] Help Debugging Short VBA Formula
  28. Using Excel VBA Get the "Page Number" of Table current cells in Winword.
  29. [SOLVED] VBA Copy Paste Formula
  30. 2 different lists
  31. [SOLVED] Excel VBA MsgBox NOT closing
  32. [SOLVED] VBA loop formula explanation?
  33. [SOLVED] Listbox export
  34. Variation on dynamic Linked Cells code
  35. Grouping - VBA
  36. Excel Hide - Unhide Columns With Userform
  37. [SOLVED] Range A1 notation
  38. Touch Screen Programming
  39. [SOLVED] Creating Array from cells givin error " Subscript out of range"
  40. Excel VBA - Copying to specific column
  41. [SOLVED] Custom Ribbon Add Additional Tab
  42. Using Hyperlink to open a hidden sheet - not working
  43. Using userform VBA to create a list
  44. [SOLVED] Macro to clear data but keep formula
  45. [SOLVED] Copy userform info to worksheet row based on 2 criteria
  46. Can't open new workbook
  47. [SOLVED] Find - replace
  48. Reverse date Import from .csv file
  49. Stuck with block if without end if, totally lost.
  50. please help in vba macro--Compare and merge data given in parent child hierarchy
  51. [SOLVED] DataPoint = NormInv(rand(), MeanNow, 1#) fails in VBA
  52. Dashbored where he take stairs
  53. If condition for check all the rows
  54. [SOLVED] looping from one worksheet to the next fails
  55. DTPicker select date to display in Text box
  56. Unique values from dynamic list
  57. Image viewer with images control
  58. VBA - what is Chr(1)
  59. [SOLVED] Timestamp difference in Millisecond
  60. [SOLVED] Listbox Selection not working with 1 result
  61. [SOLVED] Help with Formula
  62. [SOLVED] Flashing cell
  63. VBA userform output storing number as text
  64. Live data output
  65. Page setup when selected items are sent to print Preview
  66. TextBox SetFocus Problem on UserForm
  67. [SOLVED] Compound interest rate with leap year
  68. [SOLVED] Auto unformatting of output filename with leading zeroes
  69. Finding a value in my table
  70. [SOLVED] Compare 2 columns from separate sheets and create new sheet with data from both
  71. Copy certain cells to new sheet based upon a different cell?
  72. Conditional Format
  73. Fill in the data with date range
  74. Leading zeroes depending on file name
  75. Adding message and loop to input box password
  76. excel vba to outlook email
  77. help with vba loop inside listbox & search value
  78. Word recovery and mapping vba
  79. Renaming Worksheets Using VBA
  80. Merge cells based on the cell value updated on other column
  81. MACRO filter column based on reference criteria copy, paste and repeat
  82. Autofilter List Exists
  83. [SOLVED] VBA code for consolidating/transf data from multiple worksheets in one Template sheet
  84. Issue with VBS - wscript and saving multiple files
  85. How to switch between worksheets while VBA is running?
  86. [SOLVED] Multiple Filters of Pivot Table
  87. VBA: search for multiple words
  88. Using Solver with a macro
  89. userform comobox question
  90. [SOLVED] Pull Latitude from XML and keep Double
  91. [SOLVED] PivotTable.DrillDown and filtering the output based on target column data type
  92. userform textbox save file path in cell as hyperlink
  93. Vlookup open file on background
  94. [SOLVED] Excel Formula to Link Totals from Newly Created Tabs to Summary Sheet
  95. [SOLVED] Formula help
  96. When would you execute doevents more than once?
  97. how to check if already exist in db
  98. move to end of the procedure
  99. Loop through a collection of controls
  100. [SOLVED] Go To Next Filter
  101. VBA for consolidating data without duplicates
  102. [SOLVED] Converting Tables Into ListObject
  103. search by header column in VBA and copy corresponding column
  104. [SOLVED] Error: Application-defined or object-defined when trying to hide row
  105. In VBA transfer data from one spreadsheet to another based on new date
  106. Group of Functions
  107. Workbook.BeforeSave Event on Mac Office
  108. If condition is not met, go back to start of code VBA
  109. VBA Looking for a Better solution than iCol for next loop
  110. when importing data VBA code changes values ​​of the original ​​book
  111. [SOLVED] Macro Run-time Error '1004' Application-defined or object-defined error
  112. I need VBA for my work. Thanks for all helps
  113. adjusting code search by combobox
  114. vba adding up time with spin control & text box with userfirendly output
  115. VLookup Duplicating Data
  116. Conditional Outline Borders Based on Criteria
  117. Pasting range from Source ab to Destination tab based on name
  118. [SOLVED] Parent / Child Relationships
  119. how to lookup combo box into textbox in excel VBA
  120. [SOLVED] VBA Input Box
  121. Removing parts before each item
  122. Help reversing calculations.
  123. [SOLVED] Create a border around a range for specific criteria
  124. [SOLVED] Worksheet_BeforeDoubleClick
  125. VBA coding for Excel problem
  126. Reference to Lists in another workbook
  127. Question about clear, clear contents
  128. Export pivot table to individual PDF
  129. [SOLVED] Match Error 2042
  130. Make code more variable
  131. VBA userform listbox - hard set range to specific sheet
  132. Setting Linked cell to another work sheet
  133. [SOLVED] sort data within the same cell
  134. Copy cell data from one protected file to another
  135. [SOLVED] IF Statement using VBA
  136. Macro IF statements
  137. [SOLVED] AverageIfs to compare AM vs PM hours
  138. Parse rows to sheets
  139. [SOLVED] VBA Conditional formatting - multiple adjacent cells if specific text on left
  140. Remove "Filters" from Macro Script
  141. PDF creating and past copy different folder
  142. How can I write VBA macro for bchain() and bdh()?
  143. VBA Pasting values to different cells in the same named range
  144. Overcoming ADO Recordset 64 Characters limitation for Fields
  145. Importing Images/Pictures/Shapes from a Closed Excel Workbook
  146. VBA to compare values in 2 cells and post a value in another
  147. [SOLVED] A Class Module to store Images from a folder for later reuse in Workbook Excel VBA
  148. Using Index Match with an unknown range
  149. VBA - capacity smoothing
  150. MACRO/VBA - Extract unique values to different worksheet that meets a criteria
  151. Extract unique values from column based on criteria
  152. Automatically updating date cell unless row is blank
  153. COUNTIF Column based in VBA
  154. How can I modify this code to use a cell value when naming the new workbooks?
  155. [SOLVED] Merge multiple Excel files into ONE WORKSHEET
  156. [SOLVED] Filling one Cell from another Cell
  157. Caculate From One Cell & a Dimension Table
  158. Changing column types
  159. Trying to Sort "Multiple Rows" together
  160. VBA form question
  161. Resizing a table to size 1 row
  162. [SOLVED] Single column into matrix
  163. VBA to check if cell changed
  164. [SOLVED] Loop a sort function
  165. URGENT HELP PLEASE Copying same data to multiple rows
  166. Import data to excel
  167. adjusting code calling data in worksheet
  168. If Pivot Item = "" then skip
  169. Out of memory - find and replace part of hyperlink
  170. vba Help - extract Matching value
  171. Extract Crossing new Sheet
  172. Selecting Pivot Table Range with Dynamic Data
  173. [SOLVED] Using Structured Cell References
  174. Select cells with input box and unlock them in a protected worksheet
  175. EXCEL syntax isue
  176. Macro to compare two workbook
  177. Combining Multiple Worksheets with Same Table Headers