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

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