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