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

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