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 165 166 167 168 169 170 171 172 173

  1. EXPORTING DATA TO MS ACCESS FOR SIMULTANEOUS MULTI USER
  2. [SOLVED:] Part of a string
  3. [SOLVED:] Delete text line with specific word from multiline cell
  4. Search for a string in text files.
  5. Publish to Sharepoint
  6. [SOLVED:] Transferring selected cells to a new sheet
  7. Sleeper: AdvancedFilter - Unique Column 1, Greater than 0 Column 3
  8. Replacing Date with Period Based on Matrix
  9. auto fit cell height for merged cells in sheet that has protected (locked) cells
  10. Convert Binary to decimal on and vice versa on VBA
  11. Solver in Userform Linked in Excel
  12. Using non-contiguous ranges in Solver VBA
  13. Help VBA search
  14. [SOLVED:] Finding cells formatted with colour gradients of various colours
  15. Like expression with AND or OR
  16. Formula/vba - Summary Report without Pivot
  17. [SOLVED:] VBA - Filling Master Template
  18. Room Booking System
  19. [SLEEPER:] Combine multiple txt files
  20. [SOLVED:] How to Add Different Texts to End of Excel Cells Macro
  21. VBA - Collection help..
  22. Date Picker VBA that will work on all versions of excel
  23. Copying multiple text files into one excel but different tabs
  24. MISSING DATA IN EXPORTING CALCULATED QUERYTable FROM ACCESS TO EXCEL USING EXCEL ADO
  25. [SOLVED:] Pull rows from array given two conditions
  26. [SOLVED:] Run-time error '424': Object Required
  27. simple copy-past
  28. Subscript out of range error in VBA code
  29. Replacing multiple numerical values
  30. Insert a line break after word wrap
  31. newbie vba questions & help with posible loop for multiple cell values to sheet
  32. [SOLVED:] VBA- Variable declaration help
  33. VBA Array Help in filtering data with logic
  34. [SOLVED:] Combo Box Index select
  35. [SOLVED:] Combine common worksheet names when splitting a file
  36. [SOLVED:] Turning off alerts issue
  37. [SOLVED:] How to Copy Paste Symbols-Phonetics Data to Excel sheet?
  38. Range.Find Issues
  39. [SOLVED:] When you have one workbook, two windows, does any event happen closing second window?
  40. Is there any event allowing Cancel of closing a Window (not closing a Workbook)?
  41. Apply AutoFilter based on selected cell in another sheet
  42. Declared public variables have ceased to pick up values
  43. [SOLVED:] Copy and rename multiple sheets
  44. Excel 2016 Open Read Only file
  45. [SOLVED:] Interactive Way to Search Based on First Few Characters Typed
  46. [SOLVED:] Between two numbers
  47. [SOLVED:] Clear all textboxes except 1
  48. [SOLVED:] Copy value - Another Excel
  49. Splitting up a String
  50. Delete certain rows and highlight certain cells
  51. How to remove [TAG 001], [TAG 002], [TAG 003], etc from string
  52. Prepare hierarchical and non-numeric pivot tables in Excel
  53. Search string if it contains words from a range then replace with adjacent cell
  54. Inserting Recordeset into Access DB via VBE - Error operation must be an updatable...
  55. [SOLVED:] Sum values vba code
  56. Running macro on files in a folder: impossibly hard!
  57. Count only visible data after filtering
  58. VBA to perform lookup for individual lookup range
  59. [SOLVED:] Cannot show merged cells
  60. copy and change date
  61. [SOLVED:] Copy Data from worksheet to another one with VBA
  62. [SLEEPER:] Bad file name or number - Runtime Error 52
  63. [SOLVED:] Changing Column Headers
  64. VBA code: copy data from sheet and paste values onto another specidied workbook
  65. Get first and last dates (dd/mm/jj) from year range
  66. vba - Extract Unique values from Single Column via Colllection and Dictionary
  67. [SOLVED:] Data Conversion using Dynamic Multi-Dimensional Array
  68. [SOLVED:] Linking a commandbar button to a macro in an addin
  69. Macro for sorting by lot number, splitting table w/new header, then sort by due date
  70. [SOLVED:] Fill Column
  71. Array only returning first column of values
  72. [SOLVED:] Pass Params on Activate event
  73. easy VBA seek for help!
  74. Help with random selection and variable criteria
  75. Multiple Rowsource in combo box?
  76. pick a new interior color from an array when next color is needed
  77. [SOLVED:] How to fetch data from a excel table with multiple rows.
  78. [SOLVED:] Match FileNames and then Merge those PDFs
  79. Userform with listbox and checkboxes that finds values on a worksheet
  80. counting number of occurrence of a value and depositing that number in another column
  81. [SOLVED:] Refer to range in cell formula
  82. PLEASE HELP ME!!!
  83. Select Random cells from range
  84. Get name of procedure
  85. Reconciliation based on recurring values
  86. [SOLVED:] [R1C1] Formula with a loop index in VBA
  87. [SOLVED:] VBA code to set print preferences
  88. [SOLVED:] How to Selection.Insert Shift:=xlDown with keep destination formatting?
  89. [SOLVED:] SAVING RANGE AS PDF FOR MULTIPLE FILES
  90. [SOLVED:] Problem with hiding rows
  91. Multiple dropdown list
  92. Excel Sumproduct Count Blank Cell as well...
  93. Caption label
  94. Modify macro to output to Combobox
  95. Extract Items from String and then Sort
  96. Matching data from columns with offset multiple row data in other worksheet
  97. Cell content as part of filename
  98. Count colored cells in a range using columns and rows, output result
  99. VBA scrip to sort data inside sheet
  100. Number help
  101. [SOLVED:] Copy / Paste data ranges to specific locations
  102. application.run - return value byRef
  103. Control Tip Text
  104. [SOLVED:] How to get the first & last range value for this type of data...?
  105. Updating a Chart while VBA is running
  106. Copy Multiple Files from Absolute Paths to SharePoint with Same File Names
  107. VBA problem
  108. [SOLVED:] Copy and paste VBA
  109. [SOLVED:] VBA code for selecting data from statement to output sheet
  110. [SOLVED:] VBA Code to remove Data embedded in the "Pick From Drop Down List"
  111. [SOLVED:] Userform open from one worksheet and referencing another worksheet
  112. VBA code not working in 365
  113. Error Handling for InputBoxes
  114. Run-time error 438: Object doesn't support this property or method
  115. [SOLVED:] Copy .pdf files from one location to a new folder based on a list of cell
  116. [SOLVED:] VBA Code to add groupings to subtotals
  117. [SOLVED:] Need help with logic
  118. VBA Advanced filter help..... Criteria excluding a list
  119. [SOLVED:] BeforeSave and Userform: Issues with saving the excel file
  120. [SOLVED:] Multiple selections from drop down list
  121. On editing protected view programmatically , display setting are getting changed .
  122. VBA filter and cell formatting
  123. Copy data from one sheet to another sheet where the values are matching
  124. [SOLVED:] Help import from csv file
  125. Search data using Userform and then scroll through matching records
  126. VBA how to superscript characters in a string following an apostrophe?
  127. [SOLVED:] Declaring Variable Type - Excel 2013
  128. Export as CSV file
  129. User Form - Many Text Boxes - Restrict One Text Box with Password for Editing
  130. Loop through a folder and copy data from files to another WB
  131. Word file - filled using excel and send by email as attachment
  132. Why is my code showing error??
  133. [SOLVED:] VBA to replace previous table and check if one cells value is equal to the previous o
  134. Print to PDF file
  135. [SOLVED:] VBA Code to Run Code Across Multiple Worksheets at One Time
  136. Array issues - one vs two dimensional
  137. [SOLVED:] Excel VBA code to Delete 'Heading 1' from Word Document
  138. Excel to JSON -- bracketing
  139. Findvalue from 2 searchstrings
  140. VLOOKUP not working properly
  141. [SOLVED:] Use .Range("A1:A10000") to end of records?
  142. How can I control when and if my chart updates and not updates?
  143. My chart "hides" from view sometimes after running or when idle.
  144. Two userforms in one sheet
  145. [SOLVED:] Create a File list with metadata
  146. Filepath to reference cell value
  147. [SOLVED:] VLOOKUP Not Updating when Data Repeated
  148. Userform - Compile Error: Invalid qualifier
  149. [SOLVED:] Format transfer to sheet 2 after match in sheet1
  150. Creation of File list in a new Workbook
  151. [SOLVED:] Printout VBA
  152. [SOLVED:] VBA Code to stop loop if cell / range is blank
  153. Crank Nicholson
  154. Crank Nicholson Method
  155. [SOLVED:] 2 separate change events code issue (Floating Cmd Button & List box selection)
  156. Input user form to change cell value
  157. Excel help copy and paste from sheets then move to next row
  158. Formulas NameManager
  159. Excel vba merge cells based on duplicate cell data
  160. Transform data type in column
  161. VBA to Recalculate Grand Total
  162. Application.Match gives 'Type Mismatch' only on descending date values, match type=-1
  163. VBA Code to edit and update existing data
  164. [SOLVED:] Rename New Sheet?
  165. Macro to clear hidden contents based off other cell values
  166. Update Shared Spreadsheets
  167. Active X Textbox Content to Userform Textbox
  168. [SOLVED:] Button click to change shape color
  169. adjusted code show the data in listbox on userform
  170. VBA pivot table error 5
  171. Making 2 Dependent drop downs
  172. Skip blank from Auto Filter
  173. Runtime Error 438
  174. [SOLVED:] Excel Macro help - If target cell in range of cells.
  175. Code that detects data in cells and pastes data into the next cells
  176. User defined directory not working
  177. Flags on birthday calendar
  178. [SOLVED:] Produce parts list from breakdown
  179. VBA: Filtering for a date range from 2 ComboBoxes for dates
  180. [SOLVED:] Hyperlinks with changing Sheet Names
  181. Set Range Using a Function
  182. Importing pictures by directory string
  183. Debug stops running macro and will only continue in step mode
  184. autofit cell height for merged cells
  185. Search with Table
  186. Yearly Calendar Project
  187. Application.FileDialog clean up
  188. VBA Code to Loop and Calculate Subtotals with blank rows
  189. Backtesting futures using VBA
  190. conditional formatting help
  191. Filling ComboBox?
  192. [SOLVED:] VBA newcomer - help with IF to determine whether to run code
  193. Procedure too large error
  194. Data migration between tabs using VBA
  195. Search and Fill Listbox
  196. vba excel function return #VALUE!
  197. Copy Data from one Worksheet to Another
  198. Convert from range to tables and code support?
  199. [SOLVED:] Find and replace module help
  200. VBA Error When Add / Delete a Row
  201. How to Calculate Standard Dev without using the worksheet function in VBA
  202. [SOLVED:] Abbreviate the next succeeding instances of scientific names
  203. type mismatch error that i didn't get before
  204. subtract today's date from a date in another column
  205. Find cell matching text then get last row before blank
  206. [SLEEPER:] Case issue
  207. [SOLVED:] VBA macro code to expand a certain column
  208. [SOLVED:] Transfer data from Excel to double column of information in Word
  209. [SOLVED:] Vba Custom Format "0000" in File Name
  210. [SOLVED:] Excel VBA to read txt file, input all data into one cell
  211. VBA Update from Excel to SQL Table Contents.
  212. [SOLVED:] Good way to mark a textbox so users know it is required to fill
  213. Sleeper: How to calculate Volume Weighted Average Price (VWAP) of all relevant deals
  214. cumulative sum between two dates
  215. Fetching data in various cells based on on one cell
  216. [SOLVED:] select data using drop down list
  217. [SOLVED:] CTRL + Shift + Down in a Macro
  218. tracking worksheet changes over multiple columns
  219. [SOLVED:] VBA copy / paste to the next specific row
  220. [SOLVED:] Replacing drop downs by two multichoice listboxes to copy&paste in between sheets
  221. [SOLVED:] Data uploading from userform to excel when "No" is selected in msgbox
  222. Store in DataBase
  223. [SOLVED:] struggling with vbYes and vbNo coding
  224. [SOLVED:] Get data in various cells based on a cell value from another sheet
  225. [SOLVED:] VBA to insert blank rows based on conditions
  226. [SOLVED:] Remove Header / Footer from files in folder
  227. Excel Vlookup and multiple search results
  228. [SOLVED:] setting a cell to a formula
  229. [SOLVED:] VBA to calculate TOTAL based on condition
  230. importing sheet from another file - issue with data validation
  231. [SOLVED:] Parenting Calendar in excel exported to CSV for import into google calendar
  232. Change first letter of word to uppercase
  233. [SOLVED:] Removing duplicate from keywords
  234. VBA That Will Group Specific Blank Rows
  235. Form Close
  236. Excel formula help match
  237. VBA Replace From Code to Range
  238. VBA search function
  239. Batch script for inputting data into cells
  240. Sleeper: Cascade String concatenation problem
  241. ClearingContents in ranges that don't intersect
  242. [SOLVED:] Export Multiple wbk
  243. Delete the list from UserForm
  244. Drop down list without blank cell
  245. Data copy from other sheet based on cell value
  246. Issue with code to check whether an excel file is open or not
  247. VBA Help - Avoid triggering a Change Event on Delete
  248. Best Approach to Do This Report
  249. Creating Multiple Tables Using Loop in VBA. I still want to add new sheets and add
  250. [SOLVED:] VBA code excel