Log in

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. Power Query: Which technique will get me the same results as XLOOKUP? (5 replies)
  2. [SOLVED:] Assignment Vs Condition (14 replies)
  3. Searching for special characters (8 replies)
  4. [SOLVED:] Sending Charts to Power Point. (7 replies)
  5. [SOLVED:] Defining Variables (2 replies)
  6. [SOLVED:] Runtime error: 13 mismatch in complicated VBA array (19 replies)
  7. Simulating a function 1000 times for a given integer (easy) (1 replies)
  8. [SOLVED:] Is it possible to chart hidden figures (data) (6 replies)
  9. [SOLVED:] A more simple or efficient way of entering header row text & formatting ? (8 replies)
  10. VBA code help (3 replies)
  11. Simulating Futures trade outcome with 0-100% liquidity buffer (HELP!) (0 replies)
  12. [SOLVED:] Converting Column To Specific Date Format (18 replies)
  13. Standard deviation of a subset in VBA (10 replies)
  14. [SOLVED:] I would like to calculate equilibrium price and quantity using VBA but I can't. Help! (4 replies)
  15. [SOLVED:] Opening and extracting data from another workbook (5 replies)
  16. How to distinguish data from html (3 replies)
  17. [SOLVED:] Multi choice data source select for a chart (21 replies)
  18. [SOLVED:] Count the number if times a unique number appears in a list (38 replies)
  19. Excel VBA Open Word Doc and Save as New Word Doc (8 replies)
  20. [SOLVED:] Creating a logging column and fill out missing values (4 replies)
  21. Question How to put slash with word and ascending numbers in excel with VBA (12 replies)
  22. [SOLVED:] Download Multiple tables following URLs list in an Excel's worksheet Through VBA (8 replies)
  23. Experts Help (3 replies)
  24. Create screenshot with macro (4 replies)
  25. [SOLVED:] When should code be broken down into proceedures (7 replies)
  26. [SOLVED:] How to close all .csv or .xlsx type file (5 replies)
  27. [SOLVED:] Selecting Cells Advanced (16 replies)
  28. Open DXF file from a button on the toolbar or userform is not working, Need help? (19 replies)
  29. [SOLVED:] Debug this code. (12 replies)
  30. [SOLVED:] Case Select vs. Switch (10 replies)
  31. Is there a limit to how many terms you can stick in a Case Selection? (10 replies)
  32. VBA Code Needed (7 replies)
  33. [SOLVED:] save vba process data time (7 replies)
  34. [SOLVED:] JsonConverter question (8 replies)
  35. Extract and Copy Data from an Array to a Cell with Criteria (4 replies)
  36. [SOLVED:] VBA Date Filtering Issue (3 replies)
  37. Turn Excel Object Broswer into a 4-column long list, in Excel (2 replies)
  38. [SOLVED:] Multiple chart combined into one (12 replies)
  39. Plausibility check via VBA (2 replies)
  40. [SOLVED:] Renaming File Name (4 replies)
  41. [SOLVED:] Offset value as ".Text" use (5 replies)
  42. [SOLVED:] Update cell value for all files in a folder (3 replies)
  43. [SOLVED:] Excel Image Viewer and Rename its File Name (17 replies)
  44. Issue saving Excel Worksheet to .pdf (8 replies)
  45. Let and Lambda (10 replies)
  46. [SOLVED:] How to list dates defined by a data validation process (26 replies)
  47. [SOLVED:] Chart data for a selected range (12 replies)
  48. [SOLVED:] Converting numbers to text by macro (3 replies)
  49. [SOLVED:] vba get html table value into excel sheet (9 replies)
  50. Excel VBA Find macro fails to find a string even when the string is present in sheet! (9 replies)
  51. Need Help with Excel Macro (5 replies)
  52. [SOLVED:] Need help on VBA (13 replies)
  53. Excel - find a specified value in word document table and move it (2 replies)
  54. userform - help needed (2 replies)
  55. How to Delete Rows Based on Given text (3 replies)
  56. Excel VBA, copy 8 columns of data, paste "stacked" into 4 colums (4 replies)
  57. Excel VBA Repeating and Merging Data Into Some Columns (1 replies)
  58. [SOLVED:] Rename Excel files in folder with VBA (12 replies)
  59. spilt date and time to new columns (11 replies)
  60. Excel 365 Crashing on a 64 bit system (9 replies)
  61. How to share an Excel file with VBA code online? (1 replies)
  62. Macro that converts 1000pdf files from folder to jpgs (1 replies)
  63. getdetailsof - method or data member not found (9 replies)
  64. Selecting a cell in a given Range Not working (2 replies)
  65. VBA Code Help Bounty 1/5 Star Difficulty (27 replies)
  66. Excel Not Enough memory error into a export to pdf (4 replies)
  67. Sleeper: Writing File Address to Save File Directly to a Shared Folder (1 replies)
  68. [SOLVED:] Capturing Sort order.. (11 replies)
  69. [SOLVED:] List of Categories/Units given in a table of data (2 replies)
  70. Excel 2007 and Acrobat Reader VBA code to combine multiple PDF files into one PDF (4 replies)
  71. How to combine many ranges into one big table with vba? (and remove all of the headin (9 replies)
  72. [SOLVED:] Error 50290 on Selection Macro (17 replies)
  73. [SOLVED:] Iterating through a range of cells with a message at the end (11 replies)
  74. Excel 2007 Macro to convert more pdf files to 1 single pdf file (5 replies)
  75. [SOLVED:] Using a VBA code to change another VBA code (4 replies)
  76. Special combinations (10 replies)
  77. [SOLVED:] Copy/Paste/Count String Data from LookUp List with VBA (11 replies)
  78. [SOLVED:] Take Focus Away From UserForm After Initializing It (2 replies)
  79. [SOLVED:] Close a UserForm Via Code Only (12 replies)
  80. Message Boxes, Routines and how prevent Message boxes until an event happens (19 replies)
  81. [SOLVED:] Prevent Macro From Activating Upon Selecting Cells For Printing (2 replies)
  82. [SOLVED:] Power Query Custom Column Formula (6 replies)
  83. [SLEEPER:] Goalseek loop (1 replies)
  84. [SOLVED:] Macros run in spreadsheet but produce errors when run in vba editor (9 replies)
  85. [SOLVED:] Restructuring data from html output to excel worksheet with vba (8 replies)
  86. Is there a way to speed up my code which copy a heavily formula infested worksheet (14 replies)
  87. S: Select all slicers on a sheet and arrange them vertically IN ALPHA ORDER by NAME? (6 replies)
  88. [SOLVED:] "Translation" help for a bit of code (where year is identified) (6 replies)
  89. Adding an asterisk (5 replies)
  90. [SOLVED:] VBA script to open files based on criterias (14 replies)
  91. VBA script to monitor folder and change file to csv (3 replies)
  92. [SOLVED:] Disable Save Notification Upon Closing Excel (2 replies)
  93. Better to create PDF file from Excel or from Word? (7 replies)
  94. VBA code to move data from Pivot Table to unhidden columns on a different sheet? (1 replies)
  95. Name Manager for Excel on-line, now available! (0 replies)
  96. [SOLVED:] Solutions for Text Boxes in Excel (6 replies)
  97. [SOLVED:] Copying (downloading) a file knowing its URL (With VBA). (8 replies)
  98. VBA - character counting analysis (5 replies)
  99. [SLEEPER:] Physical Counting (1 replies)
  100. [SOLVED:] VBA Arrays with References to Multiple Sheets (14 replies)
  101. [SOLVED:] Calculation of all combinations by taking a min Max quantity from multiple data set (7 replies)
  102. [SOLVED:] Open an Excel on OneDrive (2 replies)
  103. [SOLVED:] Edit with VBA on Startup: File > Options > Customize Ribbon (2 replies)
  104. Excel VBA Macros (1 replies)
  105. VBA code to create OUTLOOK email (8 replies)
  106. [SOLVED:] problem change Office365 for creating a calendar in Outlook. (9 replies)
  107. [SOLVED:] Addition to VBA code (10 replies)
  108. macros (2 replies)
  109. Copying chart from Excel to PowerPoint (2 replies)
  110. VBA - matching and adding value with conditions - please help (7 replies)
  111. [SOLVED:] How to quickly filter out blank cells in multiple rows & columns? (10 replies)
  112. Help editing a current piece of VBA (6 replies)
  113. Help! VBA codiing is not my expertise... (3 replies)
  114. MSG Box (6 replies)
  115. [SOLVED:] Advanced Filter for Dates (4 replies)
  116. Extracting Multiple data points from single Pivot Table (7 replies)
  117. [SOLVED:] Excel Track changes in Excel vba code (3 replies)
  118. how to exchange Multidimesional Arrays' datas? (3 replies)
  119. VBA Macro - invoice - add data to the record fail (1 replies)
  120. [SOLVED:] Search 2 Columns For A Value and Retrieve Values Needed (2 replies)
  121. [SOLVED:] Service Géoplateforme d'images WMS-Raster (3 replies)
  122. [SOLVED:] Macro, how to SaveAs a file with a new name in the same directory where the main file (17 replies)
  123. Create Chart by VBA (2 replies)
  124. [SOLVED:] Lock and unlock conditional on specific cells (6 replies)
  125. [SOLVED:] Using named cell range in a formula (10 replies)
  126. [SOLVED:] Help with code to copy cell value before change event (18 replies)
  127. Speed up Looping through subfolders (1 replies)
  128. VBA - protect sheet and allow grouping/ungrouping (outline) (6 replies)
  129. [SOLVED:] List all formulas in a worksheet on a separate worksheet (2 replies)
  130. delete blank rows in excel using VBA (1 replies)
  131. Excel Macro (2 replies)
  132. [SOLVED:] Make VSTACK(FilterFunctionA,FilterFunctionB) show parent (6 replies)
  133. [SOLVED:] Filter formula include argument (4 replies)
  134. [SOLVED:] Removing redundant code (4 replies)
  135. [SOLVED:] Close VBA form (10 replies)
  136. [SOLVED:] Removing a Users access to a Shared Workbook (6 replies)
  137. Sleeper: Edit VBA code to let it automaticlly create Folder (3 replies)
  138. [SOLVED:] Help With Save All Sheets Except First VBA Code (7 replies)
  139. [SOLVED:] ADODB Get actual displayed values (9 replies)
  140. [SOLVED:] Big Crash (11 replies)
  141. [SOLVED:] stamp duty tax (6 replies)
  142. Sleeper: CheckBoxes (3 replies)
  143. Sleeper Form to populated Selected Cell with Code depending on Radio Option and value (1 replies)
  144. Sleeper: Looping through pivot (and copying data to another sheet) (8 replies)
  145. [SOLVED:] Conditional formatting and wildcards (to apply CF to a string of text) (3 replies)
  146. [SOLVED:] VBA Code Need it to Copy Formulas (6 replies)
  147. Sleeper: Old Windows user in first cell and New Windows user in second cell (VBA) (7 replies)
  148. [SOLVED:] Confusion about XLOOKUP (4 replies)
  149. [SOLVED:] VBA Code to Copy Info (6 replies)
  150. [SOLVED:] Combining VBA Code--Some Help (2 replies)
  151. [SOLVED:] VBA Code to copy 4 cells from one worksheet to another Worksheet (6 replies)
  152. Sleeper: Help with VBA code and XLOOKUP (2 replies)
  153. Date Formula with IF and ISBLANK (6 replies)
  154. [SOLVED:] Copy Used Range Other Workbooks Other Dir n Paste Master WB Sheet1 (2 replies)
  155. [SOLVED:] VBA for all Sheets (Windows login username to cell) (4 replies)
  156. [SOLVED:] Tricky Dynamic filtering problem when using VSTACK (8 replies)
  157. Help Nesting a Formula (3 replies)
  158. [SOLVED:] Add logic to control brightness of shape/button objects? (3 replies)
  159. [SOLVED:] Create a Sorted List of unsorted cells based on color of next cell into a new sheet. (17 replies)
  160. [SOLVED:] Help with RefreshAll (9 replies)
  161. Get Selected Object Name (1 replies)
  162. [SOLVED:] Need a VBA Ignore "Not in List" Validation Error (7 replies)
  163. [SOLVED:] VBA Autofilter Method for Inventory List (18 replies)
  164. Importing Report with Formatting issues (10 replies)
  165. Data pull failing in VBA code using User Form (8 replies)
  166. Sleeper: Mark the content with the same values in once cell in red (19 replies)
  167. [SOLVED:] How to add/copy Dynamic Named Ranges to Workbook (3 replies)
  168. Macro to Copy Values and fill colors. (3 replies)
  169. Fixed width import - remove trailing empty columns (14 replies)
  170. [SOLVED:] Which is Faster? (7 replies)
  171. [SOLVED:] "This Workbook" script ignored on opening (4 replies)
  172. [SOLVED:] VBA Excel - For... next instruction (5 replies)
  173. [SOLVED:] Application level click event for shape (2 replies)
  174. [SOLVED:] Combine 2 ranges, compare and take the unique values (11 replies)
  175. Beginner help with VBA (2 replies)
  176. [SOLVED:] Pick multiple file extensions in msoFileDialogFolderPicker (7 replies)
  177. [SOLVED:] VBA - how to change Text Box to date format (4 replies)
  178. vba borders and conditional formatting (4 replies)
  179. Need Help Converting a JSON file to new format (2 replies)
  180. [SOLVED:] Reoccurring Corrupt files (4 replies)
  181. Error when trying to access .ChartData.Workbook for Map Charts (ChartType=xlRegionMap (3 replies)
  182. Need a button to do all the work (4 replies)
  183. RANGE FILL BASED ON CELL VALUES (2 replies)
  184. [SOLVED:] I need VBA to delete lines related to date (3 replies)
  185. Split two different columns with two different addresses (5 replies)
  186. VBA : Input form : Copy column and paste special value in another column (4 replies)
  187. VBA - define variables for shape names & use in a loop function (8 replies)
  188. Converting 32-bit to 64-bit VBA code (3 replies)
  189. Prepare Profit and Loss Statement (2 replies)
  190. [SOLVED:] VBA Code to call another VBA function when certain cells match a given criteria (25 replies)
  191. help with detrended fluctuatin analysis (3 replies)
  192. Vba to copy range from Sheet to another and define a name (4 replies)
  193. [SOLVED:] VBA - Remove Duplicate rows from an entire worksheet (3 replies)
  194. [SOLVED:] Help with a Macro to insert a column of a fairly complicated Date/Time function (3 replies)
  195. Perform basic operations basen on a cell (2 replies)
  196. [SOLVED:] Failed to run codes from txt file (8 replies)
  197. [SOLVED:] VBA Code to Copy UserForm Textbox data to specific Excel sheet/cells (4 replies)
  198. [SOLVED:] Return Subtotal for Table Columns (3 replies)
  199. Optimization of newton-raphson iterative solution with excel solver vba (1 replies)
  200. VBA dictionary concept problem (4 replies)
  201. [SOLVED:] List the 2nd Tuesday of the month for the next 12 months - Calculation Error (9 replies)
  202. Macro to apply MP3 tags changes with VBA (5 replies)
  203. [SOLVED:] Pivot table filter based on value using VBA code (5 replies)
  204. [SOLVED:] Transfer columns from comparable workbook if cell value exists (9 replies)
  205. Scan and copy in same worksheet (0 replies)
  206. Pulling data from another workbook and worksheet (3 replies)
  207. Pull information from selected row via listbox (3 replies)
  208. Extracting Financial Data From PDF (2 replies)
  209. Unprotect sheet for certain users upon start up (2 replies)
  210. A1 RECTANGULAR B1 APPLY (7 replies)
  211. [SLEEPER:] Copy data including coloured cells automatically to another sheet (2 replies)
  212. [SOLVED:] VBA - Search explorer for keyword and return file path (3 replies)
  213. [SOLVED:] Split Text File Into Multiple Text Files keeping the header row (13 replies)
  214. Moving rows when cell value is changed (1 replies)
  215. VBA User form error when saving data to a table (3 replies)
  216. [SOLVED:] dynamically call sub via string (12 replies)
  217. Looping through textboxes to copy files and send emails. (5 replies)
  218. [SOLVED:] Stuck on sorting array (3 replies)
  219. [SOLVED:] VBA display pictures in a table (7 replies)
  220. [SOLVED:] Clearing clipboard performance (7 replies)
  221. Syntax issue (6 replies)
  222. Run time error 91 object variables not set (17 replies)
  223. Create new column in excel when email received. (6 replies)
  224. Excel VB Macro Help (2 replies)
  225. [SOLVED:] Need help: debug/fix VBA code to create new worksheets from template and names list (6 replies)
  226. [SOLVED:] Problem with Query Filters on Excel (4 replies)
  227. Command button to download all attachments recieved today from a specific sender. (12 replies)
  228. Excel Not Changing Serial Date to Formatted Date (4 replies)
  229. [SOLVED:] IF statment nested within VBA Code (71 replies)
  230. Workaround to Create a Checkbox in a table with cells(A:A) (2 replies)
  231. [SOLVED:] VBA help - New row in excel with predefined data (4 replies)
  232. Why cannot print PDF (4 replies)
  233. VBAcode to switch(show and hide) between 4 sum value fields on a data mod pivot table (3 replies)
  234. [SLEEPER:] Row protection based on specific cell (6 replies)
  235. [SOLVED:] Non-VBA question for Conditional Formatting (3 replies)
  236. [SOLVED:] VBA Combination/Posibility problem with and "not equal/OR" (10 replies)
  237. Generating and populating a table based on list of values in another workbook. (4 replies)
  238. Modules and forms autoupdate (1 replies)
  239. [SOLVED:] Auto commentary function (4 replies)
  240. need help in looping (13 replies)
  241. Use Excel VBA to extract fund size data (10 replies)
  242. Next Help to fix VBA please? (3 replies)
  243. Need help with the following code--To Save and Close (3 replies)
  244. Export bespoke PDF macro (0 replies)
  245. [SOLVED:] Compare each Value from a Row with Values in a Range (11 replies)
  246. Sleeper: Inserting a Row under a Specified Value (4 replies)
  247. Sum of arrays (5 replies)
  248. [SOLVED:] Why doesn't the macro I created work on all of my sheets. (4 replies)
  249. VBA copies random rows to new sheet (0 replies)
  250. how to merge two VBA codes in one? (6 replies)