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. Split two different columns with two different addresses
  2. [SOLVED:] I need VBA to delete lines related to date
  3. RANGE FILL BASED ON CELL VALUES
  4. Need a button to do all the work
  5. Error when trying to access .ChartData.Workbook for Map Charts (ChartType=xlRegionMap
  6. [SOLVED:] Reoccurring Corrupt files
  7. Need Help Converting a JSON file to new format
  8. vba borders and conditional formatting
  9. [SOLVED:] VBA - how to change Text Box to date format
  10. [SOLVED:] Pick multiple file extensions in msoFileDialogFolderPicker
  11. Beginner help with VBA
  12. [SOLVED:] Combine 2 ranges, compare and take the unique values
  13. [SOLVED:] Application level click event for shape
  14. [SOLVED:] VBA Excel - For... next instruction
  15. [SOLVED:] "This Workbook" script ignored on opening
  16. [SOLVED:] Which is Faster?
  17. [SLEEPER:] Fixed width import - remove trailing empty columns
  18. Macro to Copy Values and fill colors.
  19. [SOLVED:] How to add/copy Dynamic Named Ranges to Workbook
  20. Sleeper: Mark the content with the same values in once cell in red
  21. [SOLVED:] Data pull failing in VBA code using User Form
  22. Importing Report with Formatting issues
  23. [SOLVED:] VBA Autofilter Method for Inventory List
  24. [SOLVED:] Need a VBA Ignore "Not in List" Validation Error
  25. [SLEEPER:] Get Selected Object Name
  26. [SOLVED:] Help with RefreshAll
  27. [SOLVED:] Create a Sorted List of unsorted cells based on color of next cell into a new sheet.
  28. [SOLVED:] Add logic to control brightness of shape/button objects?
  29. Help Nesting a Formula
  30. [SOLVED:] Tricky Dynamic filtering problem when using VSTACK
  31. [SOLVED:] VBA for all Sheets (Windows login username to cell)
  32. [SOLVED:] Copy Used Range Other Workbooks Other Dir n Paste Master WB Sheet1
  33. Date Formula with IF and ISBLANK
  34. Sleeper: Help with VBA code and XLOOKUP
  35. [SOLVED:] VBA Code to copy 4 cells from one worksheet to another Worksheet
  36. [SOLVED:] Combining VBA Code--Some Help
  37. [SOLVED:] VBA Code to Copy Info
  38. [SOLVED:] Confusion about XLOOKUP
  39. Sleeper: Old Windows user in first cell and New Windows user in second cell (VBA)
  40. [SOLVED:] VBA Code Need it to Copy Formulas
  41. [SOLVED:] Conditional formatting and wildcards (to apply CF to a string of text)
  42. [SLEEPER:] Looping through pivot (and copying data to another sheet)
  43. Sleeper Form to populated Selected Cell with Code depending on Radio Option and value
  44. Sleeper: CheckBoxes
  45. [SOLVED:] stamp duty tax
  46. [SOLVED:] Big Crash
  47. [SOLVED:] ADODB Get actual displayed values
  48. [SOLVED:] Help With Save All Sheets Except First VBA Code
  49. Sleeper: Edit VBA code to let it automaticlly create Folder
  50. [SOLVED:] Removing a Users access to a Shared Workbook
  51. [SOLVED:] Close VBA form
  52. [SOLVED:] Removing redundant code
  53. [SOLVED:] Filter formula include argument
  54. [SOLVED:] Make VSTACK(FilterFunctionA,FilterFunctionB) show parent
  55. Excel Macro
  56. delete blank rows in excel using VBA
  57. [SOLVED:] List all formulas in a worksheet on a separate worksheet
  58. VBA - protect sheet and allow grouping/ungrouping (outline)
  59. Speed up Looping through subfolders
  60. [SOLVED:] Help with code to copy cell value before change event
  61. [SOLVED:] Using named cell range in a formula
  62. [SOLVED:] Lock and unlock conditional on specific cells
  63. Create Chart by VBA
  64. [SOLVED:] Macro, how to SaveAs a file with a new name in the same directory where the main file
  65. [SOLVED:] Service Géoplateforme d'images WMS-Raster
  66. [SOLVED:] Search 2 Columns For A Value and Retrieve Values Needed
  67. VBA Macro - invoice - add data to the record fail
  68. [SLEEPER:] how to exchange Multidimesional Arrays' datas?
  69. [SOLVED:] Excel Track changes in Excel vba code
  70. Extracting Multiple data points from single Pivot Table
  71. [SOLVED:] Advanced Filter for Dates
  72. MSG Box
  73. [SLEEPER:] Help! VBA codiing is not my expertise...
  74. Help editing a current piece of VBA
  75. [SOLVED:] How to quickly filter out blank cells in multiple rows & columns?
  76. VBA - matching and adding value with conditions - please help
  77. Copying chart from Excel to PowerPoint
  78. macros
  79. [SOLVED:] Addition to VBA code
  80. [SOLVED:] problem change Office365 for creating a calendar in Outlook.
  81. VBA code to create OUTLOOK email
  82. Excel VBA Macros
  83. [SOLVED:] Edit with VBA on Startup: File > Options > Customize Ribbon
  84. [SOLVED:] Open an Excel on OneDrive
  85. [SOLVED:] Calculation of all combinations by taking a min Max quantity from multiple data set
  86. [SOLVED:] VBA Arrays with References to Multiple Sheets
  87. [SLEEPER:] Physical Counting
  88. VBA - character counting analysis
  89. [SOLVED:] Copying (downloading) a file knowing its URL (With VBA).
  90. [SOLVED:] Solutions for Text Boxes in Excel
  91. Name Manager for Excel on-line, now available!
  92. VBA code to move data from Pivot Table to unhidden columns on a different sheet?
  93. Better to create PDF file from Excel or from Word?
  94. [SOLVED:] Disable Save Notification Upon Closing Excel
  95. VBA script to monitor folder and change file to csv
  96. [SOLVED:] VBA script to open files based on criterias
  97. Adding an asterisk
  98. [SOLVED:] "Translation" help for a bit of code (where year is identified)
  99. S: Select all slicers on a sheet and arrange them vertically IN ALPHA ORDER by NAME?
  100. Is there a way to speed up my code which copy a heavily formula infested worksheet
  101. [SOLVED:] Restructuring data from html output to excel worksheet with vba
  102. [SOLVED:] Macros run in spreadsheet but produce errors when run in vba editor
  103. [SLEEPER:] Goalseek loop
  104. [SOLVED:] Power Query Custom Column Formula
  105. [SOLVED:] Prevent Macro From Activating Upon Selecting Cells For Printing
  106. [SLEEPER:] Message Boxes, Routines and how prevent Message boxes until an event happens
  107. [SOLVED:] Close a UserForm Via Code Only
  108. [SOLVED:] Take Focus Away From UserForm After Initializing It
  109. [SOLVED:] Copy/Paste/Count String Data from LookUp List with VBA
  110. [SOLVED:] Special combinations
  111. [SOLVED:] Using a VBA code to change another VBA code
  112. Excel 2007 Macro to convert more pdf files to 1 single pdf file
  113. [SOLVED:] Iterating through a range of cells with a message at the end
  114. [SOLVED:] Error 50290 on Selection Macro
  115. How to combine many ranges into one big table with vba? (and remove all of the headin
  116. [SLEEPER:] Excel 2007 and Acrobat Reader VBA code to combine multiple PDF files into one PDF
  117. [SOLVED:] List of Categories/Units given in a table of data
  118. [SOLVED:] Capturing Sort order..
  119. Sleeper: Writing File Address to Save File Directly to a Shared Folder
  120. Excel Not Enough memory error into a export to pdf
  121. [SLEEPER:] VBA Code Help Bounty 1/5 Star Difficulty
  122. Selecting a cell in a given Range Not working
  123. [SLEEPER:] getdetailsof - method or data member not found
  124. [SLEEPER:] Macro that converts 1000pdf files from folder to jpgs
  125. [SLEEPER:] How to share an Excel file with VBA code online?
  126. [SLEEPER:] Excel 365 Crashing on a 64 bit system
  127. [SLEEPER:] spilt date and time to new columns
  128. [SOLVED:] Rename Excel files in folder with VBA
  129. [SLEEPER:] Excel VBA Repeating and Merging Data Into Some Columns
  130. [SLEEPER:] Excel VBA, copy 8 columns of data, paste "stacked" into 4 colums
  131. [SLEEPER:] How to Delete Rows Based on Given text
  132. [SLEEPER:] userform - help needed
  133. [SLEEPER:] Find a specified value in word document table and move it
  134. [SOLVED:] Need help on VBA
  135. [SLEEPER:] Need Help with Excel Macro
  136. [SLEEPER:] Excel VBA Find macro fails to find a string even when the string is present in sheet!
  137. [SOLVED:] vba get html table value into excel sheet
  138. [SOLVED:] Converting numbers to text by macro
  139. [SOLVED:] Chart data for a selected range
  140. [SOLVED:] How to list dates defined by a data validation process
  141. [SOLVED:] Let and Lambda
  142. [SLEEPER:] Issue saving Excel Worksheet to .pdf
  143. [SOLVED:] Excel Image Viewer and Rename its File Name
  144. [SOLVED:] Update cell value for all files in a folder
  145. [SOLVED:] Offset value as ".Text" use
  146. [SOLVED:] Renaming File Name
  147. [SLEEPER:] Plausibility check via VBA
  148. [SOLVED:] Multiple chart combined into one
  149. [SLEEPER:] Turn Excel Object Broswer into a 4-column long list, in Excel
  150. [SOLVED:] VBA Date Filtering Issue
  151. [SLEEPER:] Extract and Copy Data from an Array to a Cell with Criteria
  152. [SOLVED:] JsonConverter question
  153. [SOLVED:] save vba process data time
  154. [SLEEPER:] VBA Code Needed
  155. [SOLVED:] Is there a limit to how many terms you can stick in a Case Selection?
  156. [SOLVED:] Case Select vs. Switch
  157. [SOLVED:] Debug this code.
  158. Open DXF file from a button on the toolbar or userform is not working, Need help?
  159. [SOLVED:] Selecting Cells Advanced
  160. [SOLVED:] How to close all .csv or .xlsx type file
  161. [SOLVED:] When should code be broken down into proceedures
  162. [SLEEPER:] Create screenshot with macro
  163. [SLEEPER:] Experts Help
  164. [SOLVED:] Download Multiple tables following URLs list in an Excel's worksheet Through VBA
  165. [SLEEPER:] Question How to put slash with word and ascending numbers in excel with VBA
  166. [SOLVED:] Creating a logging column and fill out missing values
  167. [SLEEPER:] Open Word Doc and Save as New Word Doc
  168. [SOLVED:] Count the number if times a unique number appears in a list
  169. [SOLVED:] Multi choice data source select for a chart
  170. [SOLVED:] How to distinguish data from html
  171. [SOLVED:] Opening and extracting data from another workbook
  172. [SOLVED:] I would like to calculate equilibrium price and quantity using VBA but I can't. Help!
  173. [SOLVED:] Converting Column To Specific Date Format
  174. Simulating Futures trade outcome with 0-100% liquidity buffer (HELP!)
  175. [SLEEPER:] VBA code help
  176. [SOLVED:] A more simple or efficient way of entering header row text & formatting ?
  177. [SOLVED:] Is it possible to chart hidden figures (data)
  178. Simulating a function 1000 times for a given integer (easy)
  179. [SOLVED:] Runtime error: 13 mismatch in complicated VBA array
  180. [SOLVED:] Defining Variables
  181. [SOLVED:] Sending Charts to Power Point.
  182. [SOLVED:] Assignment Vs Condition
  183. [SOLVED:] Power Query: Which technique will get me the same results as XLOOKUP?
  184. [SOLVED:] To declare or not to declare
  185. [SLEEPER:] Average value
  186. [SOLVED:] conditional formatting to be macro on specific rows and colums
  187. [SLEEPER:] VBA - Way to recreate chart from excel in powerpoint (not paste or embed)
  188. [SLEEPER:] Fix for BOM issue in first cell of imported txt file in Excel 2019?
  189. [SOLVED:] VBScript deprecated
  190. [SOLVED:] Finding data
  191. [SLEEPER:] I see there's a new function in Excel
  192. [SOLVED:] Split specific hours at the start of the week
  193. [SOLVED:] Sum (column) value across multiple column criteri
  194. [SOLVED:] Match and then Copy/Paste based on dates
  195. [SLEEPER:] Reports the distance between values with respect to a given value
  196. [SLEEPER:] format help
  197. [SOLVED:] Automatically rename a template sheet with today's date.
  198. [SOLVED:] Count matching criterias only if duplicate values are found formula ?
  199. [SOLVED:] Automatically filter a report with date and time, with other criteria
  200. [SLEEPER:] function that will set a specified cell to a specified value.
  201. [SOLVED:] Multiple Date matches
  202. [SOLVED:] Button to copy cells from A4 to A13 to the clipboard
  203. [SOLVED:] Unrelated User Entry Pause
  204. [SOLVED:] Problem with VBA in Excel - following code giving me an error
  205. [SLEEPER:] multiple e-mail links over 255 characters.
  206. [SOLVED:] New to VBA and require assistance modifying code.
  207. [SOLVED:] vba - select and copy multiple rows in different columns
  208. [SLEEPER:] Help
  209. [SOLVED:] Remove duplicates macro for a table ?
  210. [SLEEPER:] Copy & insert the currently selected row of data multiple times
  211. [SLEEPER:] Extract Members of an Outlook Dynamic Distribution List to excel worksheet
  212. [SLEEPER:] Have this code/query select what ever the current table is as a range & process?
  213. [SOLVED:] Conditional formatting by specific rule through many rows.
  214. [SOLVED:] Send multiple columns and rows by e-mail vba
  215. [SOLVED:] Sort running sum in descending order using excel formula
  216. [SOLVED:] Create sophisticated loop
  217. [SOLVED:] Partial qualifying references
  218. [SOLVED:] VBA Excel - identify duplicates and rearrange them
  219. [SOLVED:] How to stop an Excel table being oversized if transferring to a Word document table
  220. [SOLVED:] Pulling data from multiple sheets
  221. [SLEEPER:] Compare two sheets and Conditions
  222. [SOLVED:] Where did the Dodgy Brothers go?!
  223. [SLEEPER:] max and min values and change the currency
  224. [SLEEPER:] probability of getting a pair in poker in excel
  225. [SLEEPER:] merge files in folders
  226. [SOLVED:] Run-time error '-2147024809 (80070057)': The query name contains invalid characters
  227. [SOLVED:] How to look up a text word within multiple cells with Specific Criteria in EXCEL
  228. [SOLVED:] VBA removing table rows with current macro
  229. [SLEEPER:] Help - Powershell to VBA
  230. [SLEEPER:] Need assistance to calculate each name based on DATE
  231. [SOLVED:] Look if values exist seperately and together, then write Yes or No in cell
  232. [SOLVED:] I created my own dropdown..
  233. [SOLVED:] VBA macro to sort and ROUNDUP and save sheet to file
  234. [SLEEPER:] Sort data in one column based on value in another issue
  235. [SOLVED:] Copy rows based on specific criteria and pasting values to another sheet.
  236. [SOLVED:] Copy data to two different sheets
  237. [SLEEPER:] All of a sudden my VBA no longer works in ANY workbook, old or new ??????
  238. [SLEEPER:] Multiple references
  239. [SOLVED:] Trying to automatically add attachments to emails
  240. [SOLVED:] Vlookup or similiar within a GETPIVOTDATA Statment
  241. [SOLVED:] Move picture in cell to a specified number of cells away, without losing focus
  242. [SOLVED:] All macros quit working
  243. [SOLVED:] Excel link to Access Table
  244. [SOLVED:] Visitor registry with signatures, excel the way to go ?
  245. [SOLVED:] Excel 2016 Buttons in Print Preview Disabled
  246. [SOLVED:] Filter in a secondary workbook
  247. [SOLVED:] Multiple Criteria in a Filter command
  248. [SLEEPER:] Ron de Bruin website
  249. [SOLVED:] Custom Ribbon fails to load sometimes
  250. [SLEEPER:] Getting started series on creating office-js add-ins