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