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