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. Macro crash when extending date range
  2. vba searchble dropdown
  3. Copy data from 1 row to canvas
  4. [SOLVED:] 2 ListBox/ Can't Show Column Headers on 2nd Listbox When Sheets are Selected on 1st
  5. Copy data from 1 row to other Sheet
  6. [SOLVED:] Hide Worksheet Selection From two Different ListBox in a UserForm
  7. How to end the last row and save the new file?
  8. Sharepoint- persons and groups field
  9. Nested IFs
  10. Spread Sheet - Automatic Reset a Cell to 0 'Zero'
  11. Function that converts cell into just the value of its formula
  12. [SOLVED:] Pick and Chose which Workbook(s) to Close from a UserForm
  13. [SOLVED:] VBA VLOOKUP BETWEEN TWO NAMED TABLES
  14. Interact with cloud-based storage using VBA
  15. VBA Code to copy value in a cell and paste in at the first row of the Table
  16. Userform needs to be "moved" to show objects.
  17. [SOLVED:] Move Select Rows and Columns to Sheet 2
  18. hex to color
  19. Pop up windows asks what name the folder should have
  20. vba userform move listbox1 item to listbox2
  21. Select only cells with visible values
  22. Listbox fill via recordset
  23. Map SharePoint drive using VBA
  24. Bar charts in pivot
  25. 6 columns to 6 sheets in same workbook and 6 sheets charts pasted to PowerPoint slide
  26. update final sheet with data from existing sheets
  27. For Next lop ends on x +1
  28. [SOLVED:] why is my 'find and replace' function automatically set to look in formulas?
  29. complex excel formula
  30. Conditional Formatting in Listview
  31. Text File processed into Excel
  32. Excel VBA to delete Email String from Picked Folder
  33. [SOLVED:] Download files from excel multiple links
  34. Extract Excel Outlook Attcahments
  35. [SOLVED:] VBA to export data with altered format to a csv
  36. Changing shapes in footers
  37. [SOLVED:] Fill in blank cells with the data listed above it
  38. [SOLVED:] Use Inputbox to Add Column in Excel Table with Multiple Criteria
  39. How can I create product keys for VBA add-ins and store it in the system?
  40. How to Bring up the Table Design Dialogbox (VBA) for the User to Select Table Designs
  41. [SOLVED:] VBA formula not working because array formula needed
  42. vba - Sendkeys Crtl+C and clipboard
  43. Excel UDF with IF
  44. VBA Addition to existing cell
  45. VBA to Paste Text into Ppt as Title
  46. [SOLVED:] VBA Create Diagramms
  47. [SOLVED:] Copying data to another sheet in a particular format and Auto-adjustment
  48. [SOLVED:] UserForm Button That Loops Through Various Table Styles on the Table Design Ribbon
  49. Extract record based on company
  50. [SOLVED:] Linear Interpolation
  51. [VBA] Edit and Move my diagram
  52. Do not update range if cell is not empty
  53. [SOLVED:] Dynamic column Add and names
  54. [SOLVED:] VBA Insert ROWs into table and continue index value based on last row
  55. RAM does not get released when workbook is closed
  56. Excel version
  57. [SOLVED:] Application-defined or object-defined error - Error in replicating code
  58. [SOLVED:] Payroll Formula Help
  59. How to Run a Batch File Using VBA in Excel 2013
  60. Add sheet and rename sheet and paste only value
  61. NumberFormat of a table column
  62. Concatenate with conditional and reference
  63. Combine All Data From one Worksheets in All Workbooks in a Specified Directory
  64. [SOLVED:] Transferring Wide Data to Long Data
  65. One OptionButton change state of another one in different group
  66. How to pop up message box even when editing a cell
  67. Adjusting VBA module
  68. Run-time error ‘1004’: Method ‘Name’ of object ‘_Worksheet’ failed
  69. [SOLVED:] Resolve changed filename in Excel shortcut Target attribute
  70. [SOLVED:] Listbox Multiselect
  71. [SOLVED:] Getting Error when calculating date value
  72. Copy & Paste from 1 WB to another WB
  73. How to extract a specific data in a column and parse it in another column with VBA
  74. [SOLVED:] Formula Modification Help with And/OR
  75. General about VBA
  76. Reading a SharePoint list using Excel VBA
  77. Experiencing workbook with user form keeps closing upon opening
  78. [SOLVED:] Help. Macro works, but Excel is not responding well after running it
  79. Copy data column from a table to another
  80. [SOLVED:] Color Cell based off of a Simple Range.
  81. Sum Cell Values Until Blank Cells With VBA
  82. Google Spread Sheet Search any part of the cell and display
  83. Stop Importing file after 'End Records'
  84. Work book with on time control to close in specified time
  85. [SOLVED:] AND Cell value A minus Cell value B divided by Cell value A > 0.1
  86. Formula for finding unique values
  87. Move WordArts on others Sheets with a checkbox on the active sheet?
  88. loop + Add value
  89. [SOLVED:] run macro on range of cells only
  90. [SOLVED:] Excel 365 - VBA to assign a formula
  91. VBA Beginer -Real Estate Industry
  92. vbObjectError Not Working as Expected
  93. unable to get match property of worksheetfunction class
  94. MACROS &VBA BEGINNER
  95. Block to write in cell
  96. [SOLVED:] VBA Format Function not Formatting Numbers on Worksheet
  97. can you set 3d models to have to same depth? excel, vba
  98. Extract 10 digits number from text or any special characters
  99. How to query an open ListObject?
  100. How to assign Xaxis limits to multiple scatter plots on the same sheet?
  101. [SOLVED:] Use a formatting cell property to count duplicate
  102. How can I set the default font color of chart titles?
  103. Can VBA determine the first row number of each page?
  104. is there any macro to open temp file folder and delete temp files
  105. [SOLVED:] Exclude Sheet from Formula
  106. [SOLVED:] Get out of design mode
  107. Countif into VBA from teams excel
  108. Formulas or guide of simpler formulas
  109. [SOLVED:] Sorting based on letter, and then on number
  110. Adapt code attached to normal excel sheet
  111. Count blank rows after non blank row
  112. [SOLVED:] Stuck with replacing character
  113. How to Merge two arrays with filter condition?
  114. [SOLVED:] Delete worksheets with blank cell
  115. [SOLVED:] VBA dynamic column names in pivot tables
  116. [SOLVED:] "Object variable or with block variable not set" Error on Second loop of For Loop
  117. [SOLVED:] Selecting one OptionButton reset the choices in another Group
  118. Adding formula to excisting formulas
  119. Read content of a XLSX or CSV file using VBA if that is stored on an FTP-server ?
  120. [SOLVED:] Find last number in column if year matches
  121. Sleeper: Is there a faster method to find extended file properties
  122. [SOLVED:] Total filtered rows - Range of object Global failed
  123. [SOLVED:] Finding 1 but not 10 or 100
  124. [SOLVED:] add lines
  125. Insert time in another column when a column containing RTD updates values
  126. [SOLVED:] Trying to add tick marks to scatter plots.
  127. [SOLVED:] how to find a value and copy remark, author, row and column header names to new sheet
  128. Error after date: 10-10-2021
  129. vba command import data from web page
  130. Procv
  131. [SOLVED:] Name PDF from Filter Criteria Row
  132. Automatically replacing placeholders in different word templates via Excel
  133. How to disable editing in Analysis for office
  134. [SOLVED:] Date Format Issue in the Data Received
  135. How to webscrape using VBA querySelectorAll when selectors have data-bind in them
  136. [SOLVED:] Create n number of tables based on number of days in that week
  137. How can I control the color of wires in wireframe 3-D surface chart?
  138. Excel VB Script to Fill Values Based on Common Values in an Adjacent Cell
  139. Filters
  140. Making listboxes interdependent
  141. Deleting Blank Rows in VBA Code
  142. Concatenate columns without formula in private sub worksheet_change
  143. [SOLVED:] Lookup & Color cell Red
  144. Add worksheet change event to all sheets during runtime
  145. Automatically conjoin columns
  146. Name Word File According to cell value in excel
  147. [SOLVED:] Compare first word in Multiline and delete the whole line in a multiline cell
  148. vba que: coding for dynamic calendar; multiple drop down lists outputting to new shee
  149. parsing address into separate cells
  150. Imprt data from MDB file
  151. How do you upload PDF?
  152. how merge and unmerge duplictes items in listbox on userform
  153. Button to Stop Number Loop Code Running
  154. search button
  155. [SOLVED:] Help : Shorten code to check multiple columns in Worksheet_Change event
  156. Outlook Macro sorts Excel worksheet but corrupts file?
  157. [SOLVED:] Sort table vertically
  158. [SOLVED:] If cell is empty equal value from offset(1,4)
  159. Macro - Copy values in column if any of them changes
  160. [SOLVED:] Help : Looping and Conditional Formating
  161. How can I add more contour lines to a wireframe chart?
  162. [SOLVED:] Delete row when Cells D,E,F are empty.
  163. VBA code and VBA loop
  164. Sleeper: Interpretation of `@` sign in the formula bar
  165. [SOLVED:] Run-Time Error 1004: Document Not Saved
  166. Worksheets numerically sorting
  167. Auto filter in all worksheets in VBA.
  168. VBA
  169. Use the VBA filter
  170. [SOLVED:] VBA Error - Mail Merge
  171. [SOLVED:] Help : Maxifs with criteria of any part of the cell value separated with commas
  172. Help with VBA
  173. VBA Path Query
  174. [SOLVED:] Use Offset to select offset cell value
  175. [SOLVED:] how to add range in this vba code
  176. AT-Sign appearing in formula inserted via VBA
  177. Search files from textbox in UserForm, display result in Listbox
  178. Copy Table Thanks and best regards
  179. Copy data from another file without opening
  180. [SOLVED:] Help with intersect
  181. [SOLVED:] Script to detect overlapping values based on two variables
  182. [SOLVED:] Changing Font Colour
  183. VBA Create Hyperlink when additional data is added for each row based on cell value
  184. VBA to Automate Outlook Mail
  185. [SOLVED:] Deadline pop up reminder
  186. Calendar Control in Excel VBA
  187. [SOLVED:] Compare column values
  188. How to create a coordinate system for a svg picture in excel?
  189. Excel Search Code Help
  190. [SOLVED:] Problem Evaluate Variables
  191. [SOLVED:] Select & hide multiple rows based on cell value
  192. [SOLVED:] Create Copies of Workbook with Sheet2 Formulas Referencing Sheet1 Not Workbook Copied
  193. Match values between tabs and insert value from other column
  194. [SOLVED:] Copy formula down in next blank row andn hard paste previous results
  195. Collect data from a multi-sheets workbook
  196. Trouble switching to the M1 Mac or Excel in Office16.54
  197. VBA macro to search contents of a folder of Excel Workbooks
  198. finding partial string into another workbook, then do several cell copy when found
  199. add multiple rows with content in another tab
  200. Select multiple named ranges and clear contents
  201. [SOLVED:] Excel VBA search other email account than default
  202. [SOLVED:] Layout list by VBA
  203. [SOLVED:] Create Name in Name Box
  204. VBA and Budgeting
  205. Create Table with quartils
  206. VBA for Depreciation Calculation
  207. Export multiple sheets to PDF per product by looping through slicer
  208. Need help updating sort automatically, but only if a cell has a number
  209. [SOLVED:] Delete multiple rows based on cell color
  210. Format Incremental Value as Two Digit String
  211. [SOLVED:] VBA to enter formula using variables: Error 438
  212. [SOLVED:] Single workbook - Cannot run the macro... the macro may not be available in this work
  213. [SOLVED:] How correctly check for error?
  214. How to sort single column (selected)?
  215. [SOLVED:] Why For each rw is empty?
  216. giving a direction to VBA to open a specific file
  217. Sleeper: Application FileSearch help
  218. Static cell
  219. VBA- No form on Mac
  220. VBA Excel deleting duplicates
  221. [SOLVED:] How to move column of data down (shift it by 1 row)
  222. [SOLVED:] Highest consecutive values in column
  223. What does line 7 mean
  224. [SOLVED:] Error with progress bar chart
  225. [SOLVED:] Type Mismatch Error when Setting WorkSheets
  226. [SOLVED:] Remove part of a string
  227. Using VBA to rename or delete subfolders
  228. Help fixing and cleaning up code
  229. [SOLVED:] Unmerge Cells & Copy Cells Down to Next Line of Data
  230. VBA creating relative references to table columns
  231. incrementing a set string by1
  232. Finding minimum value Using VBA
  233. Combine these codes to one
  234. VBA: Remove line in cell if substring present
  235. link pictures from Sharepoint to Excel macro
  236. [SOLVED:] Copy unique values from new data and append to existing list in another worksheet
  237. Roll column forward and hard paste previous
  238. VBA: fetch data from cells and concatenate matching data heading in another sheet
  239. Save-As name based on cell value
  240. [SOLVED:] AVERAGEIFS formula - adjust to exclude values of 0
  241. Pivot filter by each item and copy to new sheet
  242. [SOLVED:] Include the exact name from one cell in to a formula in another cell
  243. [SOLVED:] Unexpected Numerical Value in Table When Adding Blank Line
  244. [SOLVED:] Run time Error 1004 when assigning cell value
  245. Compare Multiple Columns between two workbooks and update the values in the second wo
  246. scraping element in web page....
  247. [SOLVED:] Dragging Formula down through merged cells
  248. [SOLVED:] Extract files in a folder containing contents in column A and move them to own folder
  249. Copy the last category and insert custom text
  250. [SOLVED:] Change destination folder