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