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