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 174

  1. need help to edit code use values instead of coords
  2. InvalidateControl in Excel not working... not sure what I'm doing wrong
  3. Absolute Cell Reference Using Match
  4. Secondary & primary axes scaling !
  5. Change Header Name on Worksheet Table from a ListBox
  6. VBE Programming buttons in Excel
  7. Automating My Excel Project
  8. [SLEEPER:] Allocation with VBA until limit value is reached
  9. Need Help with the Following Macro--Copy & Paste
  10. Iteration Until Conditions Are Met - Need VBA Code
  11. VLOOKUP
  12. [SOLVED:] Resize Code Window
  13. Show Hide ranges with button selection
  14. [SOLVED:] VBA to copy data from source to destination with unique column match
  15. Deleting rows in the middle of a table
  16. accessing data from intranet and copy pasting it into the appropriate cell
  17. [SOLVED:] Macro for numbering several levels
  18. Circularity Breaker
  19. API call, send XML
  20. [SOLVED:] Stripping certain data from left side of a string
  21. [SOLVED:] Using active cell move entire row from one table to another
  22. [SOLVED:] VBA Excel Match Sets of items in a range
  23. [SOLVED:] How to mark a post as solved
  24. [SOLVED:] Formula to find single date from multiple dates
  25. [SOLVED:] Input box Data entered need code to state you’ve entered Wrong data try again
  26. [SOLVED:] Python dictionary in VBA
  27. VBA code working on one file, giving error on another
  28. [SOLVED:] How to count unique values in a dynamic range
  29. [SOLVED:] Delete all conditional formatting and coloring conditional on specific rows
  30. [SLEEPER:] Split Workwook and save
  31. [SOLVED:] Dropdown List Copy/Paste to Excel Table on Different Worksheet But in Wrong Column
  32. [SOLVED:] remove . from the last of email
  33. From Abbreviation to full form street address Column E
  34. [SOLVED:] Need to delete any row with "Daily Ledger Bal' in the 3rd column
  35. Need VBA help for Multilevel number according to the document path
  36. [SOLVED:] Dynamically locate and copy last number in a column before #N/A error
  37. [SOLVED:] Create a working search box
  38. [SOLVED:] Copy active workbook
  39. [SOLVED:] Highlight domain
  40. Data transfer from online excel to offline excel only specfic columns
  41. [SOLVED:] return TEXT value from MID w integer results
  42. [SOLVED:] Check if Excel cell is not number
  43. Execute a function stored in text format
  44. Excel spreadsheet looks different depending on how I open the file.
  45. Create Hyperlinks based on selection and cell contents
  46. [SOLVED:] How do you get Excel VBA to realize the default properties again
  47. [SOLVED:] VBA code to replace "1" with "7:00/ 15:30"
  48. [SOLVED:] Evaluating Lat Long Equations
  49. Find and replace function (not Sub) with VBA
  50. Sleeper: Recursive folder search
  51. [SOLVED:] Formula to match information from a source sheet
  52. [SOLVED:] VLOOKUP - Multiply by a percentage if appropriate
  53. [SOLVED:] Copy file from source path in cell, to destination path in cell, and create folders
  54. [SOLVED:] condition error
  55. [SOLVED:] 'Run time error 438 Object does not support this property or method
  56. [SLEEPER:] copy rows with checkbox
  57. [SOLVED:] 'Run time error 1004 method 'range' of object'_worksheet' failed
  58. Error #Value!, vba code trinomial model, Option Put American
  59. when the checkbox is checked, something must only happen in that row
  60. [SOLVED:] problem adding 2 values ​​in 2 columns
  61. [SOLVED:] Copilot
  62. [SOLVED:] Find Small in and Array
  63. Drag & drop a file to automatically copy it to a destination folder
  64. make a table bigger at the touch of a button
  65. [SOLVED:] Finding wildcards in indexing and aggregate functions.
  66. transferring a spreadsheet but specifically which sheet
  67. [SOLVED:] Vertical progress bar with label and changing height - only "grows" downward
  68. [SOLVED:] Insert names found according row .
  69. [SOLVED:] How to connect to SQL server over the internet?
  70. how do i output an ascii text from excel and maintain proper dimensions
  71. [SOLVED:] Interpolation in excel
  72. Is chatGPT the way to go with Excel
  73. Array as variable
  74. [SOLVED:] Working with Read-Only Export - Save-As
  75. [SOLVED:] All userform controls are "not" working
  76. [SOLVED:] If Cell Contains Any Words Found in the Adjacent Cell
  77. [SOLVED:] Reading items
  78. Sleeper: Macro to select next result that an xlookup would return
  79. Create my own permanent Quick Access Data Form on a UserForm in VBA?
  80. [SOLVED:] columns to columns and rows
  81. Formula in VBA
  82. Sleeper: AdvancedFilter - Removing page
  83. Sleeper: AdvancedFilter - limited columns
  84. [SOLVED:] VBA Code to Send Email Using Excel
  85. Sleeper: 'New Outlook' Broken my VBA
  86. [SOLVED:] Trying to reference data from a column of cells in a message box
  87. Sleeper: Draw proper Bezier curves to contruct flow shapes for Sankey chart
  88. Sleeper: If and Statement based on one cell and
  89. [SOLVED:] Concatenate first 3 letters of first word, and first 3 letters of second word
  90. [SOLVED:] Switching 3 colors on Form
  91. VBA formula that creates new workbook from 1 sheet after 1 cell is updated and refres
  92. Sleeper: Ribbon Menu
  93. Sleeper: Reading serial port rs232 vba
  94. [SOLVED:] Filter function (not VBA)
  95. Sleeper: VBA Help on Excel to Web portal
  96. [SOLVED:] Standard Deviation of an array
  97. Sleeper: Payroll File--Need Help with Formula
  98. Convert Excel formula to VBA code
  99. Sleeper: Pull different numbers from independent lists efficiently
  100. [SOLVED:] Counting DataValidation Attempts
  101. Move data from Template A to template B
  102. [SOLVED:] Copy Macro based on ActiveCell.Offset(r,c)
  103. [SOLVED:] Appointments Failing to Line up correctly when more than one Appt scheduled in a day
  104. Can't position dialog
  105. [SLEEPER:] Please make my code for an active workbook
  106. Removing folder and subfolder from hyperlink path
  107. Feedback for Dashboards
  108. [SOLVED:] VBA code not work if I change the file name
  109. [SOLVED:] Error handling
  110. [SOLVED:] PowerQuery Steps to Move Data
  111. Find duplicates in combobox - get index and remove from other comboboxes.
  112. [SOLVED:] VBA Highlight consequent cells based on value from another cell with criteria
  113. [SOLVED:] Should I need a terminate initialisation subset as well?
  114. [SOLVED:] Run-time error 1004 when trying to open a VBA form
  115. [SOLVED:] Transposing data
  116. [SOLVED:] Use an Input box to select a range
  117. Automatic form creation from construction activities list
  118. Change lines in a macro with the same idea but different reordering
  119. [SOLVED:] VBA Macro. I Think I'm Close But Something Is Not Right
  120. [SOLVED:] Power Query to transpose a dataset
  121. [SOLVED:] Copy and paste vba - Full numbers come out -1
  122. [SOLVED:] Dependant cells
  123. [SOLVED:] Press button to assign the reason provided and count
  124. [SOLVED:] Excel not handling large number correctly
  125. Automatic sensitivity assignment in Excel VBA - Blocks automatic processes in VBA
  126. Switching Between Two Already Open Apps
  127. Changing excel version with macros
  128. Hide the Macro form Dialog Box
  129. Oddly slow running code, under very specific circumstances
  130. Sleeper: Need some help with arrays and loops
  131. Moving file to folder with first couple matching characters
  132. [SOLVED:] Custom Function Wtih Range in Another Sheet
  133. [SOLVED:] Counts min and max quantity of equals 'strings' based on a filter column
  134. Sleeper: Excel's Formula by Example
  135. [SOLVED:] Select row apart from a merged area
  136. [SLEEPER:] Simplification of Repetative Actions on 2 sets of Different Ranges
  137. Table format to rows Macro
  138. Convert Index Match to a regular excel reference
  139. [SOLVED:] how to enable macro button for every sheet
  140. Sleeper: VBA code to un-merge cells from a Database
  141. [SOLVED:] Macro Codes for auto fit columns and rows
  142. Sleeper: Loop for copying and pasting tables
  143. Sleeper: VBA Change Line colors
  144. [SOLVED:] VBA sub - result in run-time error 9, but code looks good
  145. Adding worksheets to a Listbox
  146. [SOLVED:] Join Lines
  147. Sleeper: Change Cell's named reference via VBA
  148. How to.. Macros only running one active worksheet
  149. [SOLVED:] Existing macro to password protect sheets has stopped working
  150. [SOLVED:] Pivot table showing how a Batsman was given out
  151. [SOLVED:] Update Excel table from a one column range on a different sheet
  152. How to create a module to find missing brands and models (look through table 1, compa
  153. Sleeper: Method to show exponential growth in population
  154. circular flow diagram
  155. [SOLVED:] Incrementing value in a cell depending on clicking of a macro button
  156. [SOLVED:] Incrementing a list on clicking a macro button
  157. [SOLVED:] Help with Convert a formula
  158. [SOLVED:] VBA Hyperlink not working
  159. Command Button
  160. [SOLVED:] Summing dynamic Excel column and count
  161. [SOLVED:] Close Specific Workbooks Without Saving
  162. [SOLVED:] Saving index to a variable prior to closing the file
  163. [SOLVED:] Why does this work? Replacing IF with Text
  164. Hide unhide sheets with navigation buttons
  165. [SOLVED:] How to search text in pdf files in one folder
  166. VBA module to Macro short cut and sharing to multiple users
  167. [SOLVED:] Inserting Date Last Modified in lots of excel files without opening
  168. [SOLVED:] Macro to import historical data using web query
  169. Need help with VBA
  170. Sleeper: VBA to continuously click email hyperlink
  171. [SOLVED:] Subtracting Single and Formular values
  172. Split file with multiple sheets into new workbooks based on column value
  173. Could not find installable isam when connecting Excel 2016 to SharePoint 1016 lists
  174. Cannot find the Chrome binary
  175. VBA and Highlight function has stopped the Undo Funciton
  176. [SOLVED:] Open file with vba based on file name
  177. [SOLVED:] Excel VBA NOT LOOPING
  178. userform close when i close another excel file
  179. [SOLVED:] Help needed to find matching string from the collection.
  180. [SOLVED:] Create Named Ranges from worksheet list
  181. ActiveWorkbook.SaveAs not working with folder
  182. How to save multiple output excel in single folder in the given format
  183. Creating a macro to highlight cells in one sheet using info provided in another sheet
  184. [SOLVED:] VBA code not working
  185. Sleeper: Reset CommandButton Caption after creating PDF
  186. how to merge two VBA codes in one?
  187. VBA copies random rows to new sheet
  188. [SOLVED:] Why doesn't the macro I created work on all of my sheets.
  189. Sum of arrays
  190. Sleeper: Inserting a Row under a Specified Value
  191. [SOLVED:] Compare each Value from a Row with Values in a Range
  192. Export bespoke PDF macro
  193. Need help with the following code--To Save and Close
  194. Next Help to fix VBA please?
  195. Use Excel VBA to extract fund size data
  196. need help in looping
  197. [SOLVED:] Auto commentary function
  198. Modules and forms autoupdate
  199. Generating and populating a table based on list of values in another workbook.
  200. [SOLVED:] VBA Combination/Posibility problem with and "not equal/OR"
  201. [SOLVED:] Non-VBA question for Conditional Formatting
  202. [SLEEPER:] Row protection based on specific cell
  203. [SLEEPER:] VBAcode to switch(show and hide) between 4 sum value fields on a data mod pivot table
  204. Why cannot print PDF
  205. [SOLVED:] VBA help - New row in excel with predefined data
  206. Workaround to Create a Checkbox in a table with cells(A:A)
  207. [SOLVED:] IF statment nested within VBA Code
  208. Excel Not Changing Serial Date to Formatted Date
  209. Command button to download all attachments recieved today from a specific sender.
  210. [SOLVED:] Problem with Query Filters on Excel
  211. [SOLVED:] Need help: debug/fix VBA code to create new worksheets from template and names list
  212. Excel VB Macro Help
  213. Create new column in excel when email received.
  214. Run time error 91 object variables not set
  215. Syntax issue
  216. [SOLVED:] Clearing clipboard performance
  217. [SOLVED:] VBA display pictures in a table
  218. [SOLVED:] Stuck on sorting array
  219. Looping through textboxes to copy files and send emails.
  220. [SOLVED:] dynamically call sub via string
  221. VBA User form error when saving data to a table
  222. Moving rows when cell value is changed
  223. [SOLVED:] Split Text File Into Multiple Text Files keeping the header row
  224. [SOLVED:] VBA - Search explorer for keyword and return file path
  225. [SLEEPER:] Copy data including coloured cells automatically to another sheet
  226. A1 RECTANGULAR B1 APPLY
  227. Unprotect sheet for certain users upon start up
  228. Extracting Financial Data From PDF
  229. Pull information from selected row via listbox
  230. Pulling data from another workbook and worksheet
  231. Scan and copy in same worksheet
  232. [SOLVED:] Transfer columns from comparable workbook if cell value exists
  233. [SOLVED:] Pivot table filter based on value using VBA code
  234. Macro to apply MP3 tags changes with VBA
  235. [SOLVED:] List the 2nd Tuesday of the month for the next 12 months - Calculation Error
  236. VBA dictionary concept problem
  237. Optimization of newton-raphson iterative solution with excel solver vba
  238. [SOLVED:] Return Subtotal for Table Columns
  239. [SOLVED:] VBA Code to Copy UserForm Textbox data to specific Excel sheet/cells
  240. [SOLVED:] Failed to run codes from txt file
  241. Perform basic operations basen on a cell
  242. [SOLVED:] Help with a Macro to insert a column of a fairly complicated Date/Time function
  243. [SOLVED:] VBA - Remove Duplicate rows from an entire worksheet
  244. Vba to copy range from Sheet to another and define a name
  245. help with detrended fluctuatin analysis
  246. [SOLVED:] VBA Code to call another VBA function when certain cells match a given criteria
  247. Prepare Profit and Loss Statement
  248. Converting 32-bit to 64-bit VBA code
  249. VBA - define variables for shape names & use in a loop function
  250. VBA : Input form : Copy column and paste special value in another column