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