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. [SOLVED:] Userform textbox skipped in tab order after re-enabling - unwanted behaviour
  2. Userform problem : makes excel crash
  3. Searching for Macro
  4. Arrays in VBA errors
  5. Listbox and name manager comparison
  6. How to a reference to a new sheet in same workbook
  7. Sum function in other sheet
  8. Maximum Limit for MMULT()
  9. [SOLVED:] Sorting one Column in a Table
  10. [SOLVED:] RE: VBA auto filter Iterate through each criteria
  11. Hilbert Curve VBA
  12. [SOLVED:] VBA error: Run time error "424":Object require(pull data from HTML Element)
  13. fixing show message when open workbook from dialog to copy data
  14. [SOLVED:] if cell value in range = "code" then copy paste value to last used row another sheet
  15. Finding Keywords from Text String - Formula
  16. CommandButton1_automatically update the date in ("A") column
  17. Insert new row for breakdown detail data
  18. Put NA on cells with dates before indicated start week
  19. text in cell in condition
  20. [SOLVED:] How to copy the most current file from one folder to another
  21. Need help to Code VBA using the combination of text and date format
  22. Hundreds of sheets, trying to loop through and extract specific columns
  23. find replace
  24. [SOLVED:] Value from UserForm to Worksheet - Accounting format - (How to?)
  25. VBA - Count # of cells in Column B that are greater in value than in Column A
  26. [SLEEPER:] Last update field formula on Google sheet
  27. Calendar to bring the Leave Type from Leave Data to Calendar
  28. Total dummy when it comes to VBA, so hoping someone can help!
  29. Filter based on two columns
  30. [SOLVED:] adjusting code search files into folder and sub folder
  31. [SOLVED:] VBA - hiding column based on value of cell
  32. Excel VBA problem on application.inputbox that returns range
  33. [SOLVED:] How to remove rows based on filters?
  34. [SOLVED:] Calculating between 2 worksheets
  35. Sleeper: Copying a Value to an Addess Reference which is Nested in Another Cell
  36. Convert a formula to UDF Function
  37. [SOLVED:] Stacked Chart Percentages
  38. Change all Workbook Connection Strings
  39. Assigning a value to the specified cells?
  40. Perform action with dynamic ActiveX button
  41. [SOLVED:] transferring a column from sheet to sheet with the help of button
  42. Single & Double-Click a Shape Object
  43. Transfer the values from one sheet to another by adding them to below of previous row
  44. Search in Excel specific word, delete all rows who does not have that word
  45. Excel VBA to create a series of new pivot tables
  46. Sleeper: Compare two sets of data with multiple conditions
  47. Looking to condense data with quantity totals
  48. VBA Code to pull data dynamically from multiple sheet tabs
  49. How to subtract number of hours from 24 hour timezone in alphanumeric format
  50. create uninterrupted sequences of 2,3,4,5,6,7,8. from 01 to 25 goal.
  51. Does Excel 2007 SP3 work without issue on Windows 10?
  52. Validata Lists using offset, match and counta formulas - Different Sheets
  53. [SOLVED:] Return to Cell in Column A after entering value in Column Z
  54. VBA to arrange response value in large database
  55. Text Wrapping - Stuck for a solution
  56. Count number of users active each mont
  57. VBA - Opening File with Yesterday's Date
  58. Roster Automation
  59. Put NA on week dates IN RANGE
  60. Transpose 1 Column to Multiple Rows/Columns
  61. [SOLVED:] VBA -Identify blank fields for user form before submitting -Force User to add data
  62. VB on Time
  63. Duplicating Multiple sheets to all workbooks in folder
  64. VBA Copy paste Images from one cell to another cell on a different sheet
  65. [SOLVED:] Find column header
  66. [SOLVED:] Changing numbers with scientific notation (E+) in pivot table created by VBA
  67. OLAP pivot table vba filtering using VisibleItemsList
  68. Copy data range to a new workbook
  69. Adding a sum total to a Ron de Bruin VBA to email workbooks
  70. [SOLVED:] Formula assistance required.
  71. [SOLVED:] VBA to Find Maximum Value in a Range
  72. [SOLVED:] Dynamic Array not Resizing
  73. [SOLVED:] 3 columns matched create report
  74. Combine specific sheets from multiple workbooks into 1 workbook.
  75. [SOLVED:] copying images from one folder and pasting in another based on schedule in excel file
  76. VBA Help
  77. User Form error
  78. [SOLVED:] Anomaly With Formula
  79. [SOLVED:] Object Required Error when Selecting Range
  80. Index Match to Determine Paste Location
  81. Advice needed to speed up Painting code based on defined colors.
  82. Automatically Printing Autofilters / loop through all filter values then print vba
  83. Convert Excel range into HTML table
  84. Excel pivot fields recognition issue
  85. How do I link a cell to 2 non-bold cells and 1 bold cell and keep that formatting?
  86. [SOLVED:] sum data based on dates from sheet to another
  87. [SOLVED:] Using Application.Run
  88. Copying vales with their number format from Excel into a word table
  89. Insert Multiple Picture into excel thru vba
  90. Dynamic dropdownlist from productlist
  91. [SOLVED:] Help to amend vba to highlight any cells where file paths do not exists
  92. Worksheet object onClickEvent with changing cells issue
  93. Refresh item data in IRibbon combo box
  94. vlookup from Last Modified File in Folder
  95. Assistance needed for converting formula in Array VBA.
  96. transfer if there are no blank cells
  97. XML Map Export and Save
  98. Folder and cell value
  99. Error checking on existing roster
  100. [SOLVED:] Highlight minimum value ignoring 0
  101. [SOLVED:] Loop Vlookup for each cell in range from another worksheet
  102. Updating VBA code to Paste Values only
  103. [SOLVED:] loop through range inserting sum formulas based on start and end indicators (text)
  104. If Checkbox is checked, display message... If checkbox is unchecked, do nothing
  105. 'Cascading' comboboxes
  106. create a cubic grid shell in VBA
  107. Pivot Table Copy Paste 5 Days in a Row
  108. Convert Text to cells Sentences by Punctuation Marks
  109. Adding and Activating Reference
  110. packing list serial number generator for boxes
  111. Concatenate Values
  112. Update image/replace image from excel to PowerPoint
  113. Trying to rename individual shapes within a duplicated group.
  114. 2007: Issue with graphics shifting when saving to a PDF.
  115. Help with Debugging Code
  116. open file with vba
  117. [SOLVED:] 2007 Formula: Trying to locate a numeric value in a square named range.
  118. Export to PDF (specific sheets) if cells in Input sheet are >0, if condition is met
  119. [SOLVED:] Count number of occurrences via combobox in user form
  120. Excel VBA with Advanced Filter Error messages
  121. help needed to calculate dates and time together
  122. Create New Folder Based on Cell Name and Copy Files into it
  123. Macro or form based solution for attached excel sheet
  124. Help to check string of file name, if meet will copy valu to master workbook
  125. Workbook open event not working
  126. Macro wont run on duplicate columns
  127. [SOLVED:] AutoFilter Percent Values +-5%
  128. [SOLVED:] Sequentially Number Search Using an Array
  129. Intellisense working Sporadically
  130. [SOLVED:] Use dropdown to populate other cells
  131. Vlookup to delete entire row on another worksheet
  132. random selection from a growing range
  133. [SOLVED:] VBA Coding Help for Conditional Formatting
  134. [SOLVED:] Fuzzy Lookup add-in VBA
  135. [SOLVED:] Looping through Dates to Determine in Date Falls Between Other Dates
  136. If statement help
  137. Search for Strings Listed in Column A and Insert Offset values in B
  138. Finding IDs
  139. Is there any way to create a macro to keep doing nonlinear regressions?
  140. Auto populate table from another worksheet
  141. [SOLVED:] Multiple find and replace in Excell sheets
  142. Syntax To QuickSort A Range Of Numbers In An Array
  143. [SOLVED:] Copy, Rename and validate multiple excel files
  144. 2007 VBA: Cannot figure out recursion to show all possible paths in a 4 x 4 grid.
  145. Run macro run by itself
  146. Basic question - create and fill X new rows based on instances of character in cell
  147. Excel VBA data transfer between workbooks
  148. Importing Multiple .Txt Files Into Excel Based on the Date Last Modified in VBA
  149. Counting the number of times a string appears on a filtered worksheet.
  150. Convert Many Invoice Formats to a Standard Format
  151. Importing text file into Excel but worksheet names are too long!
  152. [SOLVED:] IF condition is not working with formula
  153. [SOLVED:] Make code more efficient
  154. Exiting Command Prompt window from Excel
  155. [SOLVED:] Create a new folder based on cell and copy list of file into created folder
  156. fixing error code get folder names and files names
  157. VBS for Check the zide and move files
  158. "Run-time error '1004' with .xlt file
  159. [SOLVED:] Date Not Filtering Correctly
  160. Run-time error 1004: The extract range has a missing or invalid field name
  161. Open specific worksheet and hide all other worksheet
  162. [Question] Dynamic amount of averages
  163. Extracting data from excel VBA
  164. Filtering a DefinedName that a ComboBox pulls from within a VBA Form
  165. Add-In Buttons Delete When Excel Closes
  166. SaveAs2 fileformat/encoding not working ???
  167. Help about sorting rows and assigning a new field automatically?
  168. VBA code to copy data from Excel by rows to multiple text files
  169. [SOLVED:] RE: copy paste entire pivot data Using VBA
  170. [SOLVED:] Excel formula syntax
  171. (Question) Make Subtotal ignore ="" Cells
  172. Easy! Need some help, Delete Line from txt file
  173. Change String
  174. Find & Replace - All worksheets except one and with different Target column
  175. Filter Listbox value marching with Combobox value
  176. Auto-expand text rows in protected worksheet - can I do it?
  177. Looking to make this macro Faster
  179. [SOLVED:] Need assistance copying Cells that just contain certain data
  180. Excel VBA Multiple loops
  181. [SOLVED:] Copy, Find Match in another worksheet, and then Paste Range
  182. Call shortcut only in specific column
  183. Run time error 438
  184. [SOLVED:] Locate a set value and copy the value in the cell that's below it
  185. Code to loop through ws only works on active sheet
  186. [SOLVED:] User forms - Alternatives to Me.Field = "Value"
  187. VBA help for sales report
  188. [SLEEPER:] Use Macro on Teams/Sharepoint/Onedrive
  189. [SOLVED:] Userform search is not working after delete any record
  190. Making a dynamic list.
  191. VBA Help - Code for Report Updates
  192. Populate in listbox
  193. Vlookup not working when Table array refers to a cell with variable
  194. Scroll Bar (Form Control) Offset Table - Sync Scroll Bar Pos. Across Multiple Sheets
  195. Could use some VB help with dealing with combo box data from a Union All query
  196. Last save time
  197. [SOLVED:] Like Operator
  198. Filter/paste rows by months in the near future
  199. [SOLVED:] Need VBA Help With the following info
  200. [SOLVED:] Convert Excel Cell Text in Bold or Italic to HTML Tags/Convert Cell Line Breaks
  201. Upper Case
  202. VBA conks out on very simple code
  203. [SOLVED:] VBA Index Match across two worksheets
  204. VBA help on pulling data from an external workbook
  205. Use a master list to run a macro that opens, extracts, and closes multiple workbooks
  206. Expand VBA code to search Column & Paste Cells to Other Sheet
  207. Type Mismatch error when there is no type mismatch
  208. How to create a macro that puts today's date and time in cell
  209. [SOLVED:] VBA Disbale Copy&Paste in target range (not complete sheet/workbook)
  210. [SOLVED:] Drag tool to adjust formulas correctly
  211. How to fix a messed Excel sheet and make a proper format?
  212. Extract and move records , then delete from master sheet
  213. [SOLVED:] Function for checking and opening a workbook
  214. Sleeper: VBA Macros 438 runtime error
  215. VBA Sum Array Formulas
  216. [SOLVED:] Custom Sort On Column
  217. Xlsm file problem
  218. VBA Time Stamp for single cell entry
  219. VBA code to open workbooks in a folder, create new sheet, paste headers and formulas?
  220. Change alignment
  221. [SOLVED:] Object Required Error in UnHiding rows
  222. [SOLVED:] VBA code to calculate dates from an event
  223. Macro to find best way to combine numbers to equal a certain sum
  224. VBA look for cell next to first blank, copy and paste
  225. [SOLVED:] RE: Pivot table creation in existing sheet- VBA issues
  226. VBA Code Copy&Paste Request
  227. [SOLVED:] Debugging VBA built on Excel2013 not working on v2016
  228. [SOLVED:] HELP - Calculate Based on Dynamic Variables (What-if Scenario)
  229. excel to pdf print
  230. How to hide/unhide worksheets based on cell value?
  231. Is there a way to protect or lock my macro?
  232. Generating a table of events based on a calendar on a different worksheet
  233. Trouble sorting as part of a Macro
  234. Auto Filter Data from Multiple Worksheets Using only One Combobox
  235. Truncate Data in Excel VBA to prompt Pass or Fail
  236. What function should I use?
  237. Macro to copy a cell value and put in different worksheet
  238. [SOLVED:] Creating an 11 digit number
  239. Formula Assistance Required
  240. VBA
  241. Array of unique values in a Column range
  242. Disable SAVE/SAVE AS and Make Savable Again after Username and Password
  243. Converting three calculators in a workbook into one with a dropdown box (hardcoded)
  244. [SOLVED:] VBA Sum function NOT calculating small values
  245. [SOLVED:] Delete Hidden Rows when Filter applied
  246. Sum with integer
  247. save from template to range value name workbook
  248. [SOLVED:] VBA to add new row above and include formatting
  249. [SOLVED:] Paste to next empty row in another workbook
  250. How to move data between date rows using VBA?