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 174
  1. Insert value in web page and press button genera (4 replies)
  2. [SOLVED:] Sluggish Script when accessing Last Author (12 replies)
  3. VBA Figure out how to perform two different import actions into the same sheet (8 replies)
  4. [SOLVED:] I need custom table layout available in all Excel workbooks created by me (2 replies)
  5. [SOLVED:] VBA to search for different valuse in entire workbook depending on texts (2 replies)
  6. [SOLVED:] Need help with Multi Table Lookup Formula (6 replies)
  7. [SLEEPER:] Why does an "Automation" Error occur when I run this VBA Excel script? (8 replies)
  8. [SOLVED:] How to determine best months for Products (14 replies)
  9. [SOLVED:] Colour cell on click event (13 replies)
  10. [SOLVED:] Multiple condition page break (6 replies)
  11. [SOLVED:] Data cleaning temperature data where a value might be negative (7 replies)
  12. [SOLVED:] Merging arrays (15 replies)
  13. [SOLVED:] How to display the solution to this challenge (4 replies)
  14. [SLEEPER:] bing map api rest (2 replies)
  15. [SOLVED:] Obtaining a list of network printers (1 replies)
  16. [SOLVED:] I can't get an autosave macro to save a workbook to my PC every 10 minutes (7 replies)
  17. [SLEEPER:] Evaluate string and find word in appropriate worksheet (3 replies)
  18. [SLEEPER:] Wrap text and autofit in merge cells (6 replies)
  19. [SOLVED:] PDF file not saving in right area (5 replies)
  20. [SOLVED:] Running a Macro on another worksheet (14 replies)
  21. [SLEEPER:] Getting dropdown to repeat in new table row (4 replies)
  22. [SOLVED:] Identify Matches between Sheet Columns (21 replies)
  23. [SOLVED:] How to show the answer graphically (10 replies)
  24. [SLEEPER:] Pivot table variable problem (4 replies)
  25. [SOLVED:] Excel VBA: Enabling Macro Settings (6 replies)
  26. [SOLVED:] Intercept printing on Excel not working properly (6 replies)
  27. [SOLVED:] If cell is colored enter a letter to it (6 replies)
  28. [SLEEPER:] VBA Export PDF Help (8 replies)
  29. [SLEEPER:] VBA Code to select specific sheet from the ActiveSheet (8 replies)
  30. Putting Private Sub in created sheet (6 replies)
  31. [SOLVED:] Remove Zero values from list (1 replies)
  32. [SOLVED:] My Long is being converted to String (or being Rounded) (2 replies)
  33. [SLEEPER:] Optimize VBA (1 replies)
  34. [SOLVED:] VBA copy last row data of one sheet col B of workbook to another workbook sheet col A (2 replies)
  35. [SOLVED:] Transform count data date wise to Dates (7 replies)
  36. [SOLVED:] Code running extremely slow when creating PDFs (3 replies)
  37. [SOLVED:] How to display a rolling 12 month period within a defined range (2 replies)
  38. [SOLVED:] How was the supplied result arrived at? (3 replies)
  39. [SLEEPER:] Getting the original file creation date (10 replies)
  40. [SLEEPER:] I Need Advice with Automating Data Transfer Between Excel Sheets Using VBA (1 replies)
  41. [SLEEPER:] Paste disable button - in sheet (13 replies)
  42. [SOLVED:] VBA to record value of a named range cell (2 replies)
  43. [SLEEPER:] Multiple values (4 replies)
  44. Excel VBA Com Port communication (5 replies)
  45. [SLEEPER:] Remove "Search all menus" from my mouse menu I created. (1 replies)
  46. [SOLVED:] Finding Top Unique Distinct Pairs of Items per Guest Check (15 replies)
  47. [SOLVED:] How to go to a specific cell address from a ListBox selection and Highlight it (2 replies)
  48. [SLEEPER:] click on button in a web page (2 replies)
  49. [SOLVED:] Replace characters in array (8 replies)
  50. [SOLVED:] VBA .Find - not returning the first value in the searched range (4 replies)
  51. [SOLVED:] combining texts in a row in one cell macro (4 replies)
  52. [SOLVED:] blank rows (1 replies)
  53. [SLEEPER:] Automate reporting process (1 replies)
  54. [SOLVED:] bizarre "object required" (3 replies)
  55. [SLEEPER:] Hide columns that contain 0 value (4 replies)
  56. [SOLVED:] How to pass used range to a function in a cell (2 replies)
  57. Count of Records IF (18 replies)
  58. [SOLVED:] How to enable data to be filtered based of values in Data valuation cells (23 replies)
  59. [SLEEPER:] Help needed in VBA (5 replies)
  60. Trouble when using the weekday function (1 replies)
  61. [SOLVED:] Assign worksheet to Global variable. Possible? or Worth it? (9 replies)
  62. [SOLVED:] Help Needed with 64 Bit Declarations (13 replies)
  63. [SOLVED:] Compile error about multiline initializtion of date array (12 replies)
  64. [SOLVED:] SumIf and SumIfs Help (3 replies)
  65. [SOLVED:] How create border in excel vba (6 replies)
  66. [SOLVED:] VBA copy last row of a sheet of a workbook to last row of sheet in another workbook (2 replies)
  67. [SOLVED:] PQ privacy level (1 replies)
  68. [SOLVED:] "IF" statement isn't reading binaries properly (8 replies)
  69. [SOLVED:] VBA Double Click Macro dependent upon a range (column) (3 replies)
  70. [SLEEPER:] How to merge two different csv files by Macro (8 replies)
  71. [SOLVED:] Transpose from columns only found items (7 replies)
  72. [SOLVED:] Record change of value in cell/s (6 replies)
  73. [SOLVED:] Prevent code from moving a picture in cell outside of specified range (5 replies)
  74. [SLEEPER:] How can I create a VBA macro to automatically consolidate data (3 replies)
  75. [SOLVED:] I think its a string problem? (2 replies)
  76. [SLEEPER:] Drop down list help needed. Want lists that only shows selections from another list. (9 replies)
  77. [SLEEPER:] Strange behavior and errors I think ????? (4 replies)
  78. [SLEEPER:] Getting started series on creating office-js add-ins (0 replies)
  79. [SOLVED:] Custom Ribbon fails to load sometimes (9 replies)
  80. [SLEEPER:] Ron de Bruin website (3 replies)
  81. [SOLVED:] Multiple Criteria in a Filter command (6 replies)
  82. [SOLVED:] Filter in a secondary workbook (3 replies)
  83. [SOLVED:] Excel 2016 Buttons in Print Preview Disabled (4 replies)
  84. [SOLVED:] Visitor registry with signatures, excel the way to go ? (18 replies)
  85. [SOLVED:] Excel link to Access Table (3 replies)
  86. [SOLVED:] All macros quit working (5 replies)
  87. [SOLVED:] Move picture in cell to a specified number of cells away, without losing focus (2 replies)
  88. [SOLVED:] Vlookup or similiar within a GETPIVOTDATA Statment (2 replies)
  89. [SOLVED:] Trying to automatically add attachments to emails (16 replies)
  90. [SLEEPER:] Multiple references (4 replies)
  91. [SLEEPER:] All of a sudden my VBA no longer works in ANY workbook, old or new ?????? (4 replies)
  92. [SOLVED:] Copy data to two different sheets (3 replies)
  93. [SOLVED:] Copy rows based on specific criteria and pasting values to another sheet. (2 replies)
  94. [SLEEPER:] Sort data in one column based on value in another issue (2 replies)
  95. [SOLVED:] VBA macro to sort and ROUNDUP and save sheet to file (7 replies)
  96. [SOLVED:] I created my own dropdown.. (5 replies)
  97. [SOLVED:] Look if values exist seperately and together, then write Yes or No in cell (8 replies)
  98. [SLEEPER:] Need assistance to calculate each name based on DATE (6 replies)
  99. [SLEEPER:] Help - Powershell to VBA (2 replies)
  100. [SOLVED:] VBA removing table rows with current macro (15 replies)
  101. [SOLVED:] How to look up a text word within multiple cells with Specific Criteria in EXCEL (5 replies)
  102. [SOLVED:] Run-time error '-2147024809 (80070057)': The query name contains invalid characters (8 replies)
  103. [SLEEPER:] merge files in folders (2 replies)
  104. [SLEEPER:] probability of getting a pair in poker in excel (2 replies)
  105. [SLEEPER:] max and min values and change the currency (2 replies)
  106. [SOLVED:] Where did the Dodgy Brothers go?! (1 replies)
  107. [SLEEPER:] Compare two sheets and Conditions (4 replies)
  108. [SOLVED:] Pulling data from multiple sheets (19 replies)
  109. [SOLVED:] How to stop an Excel table being oversized if transferring to a Word document table (9 replies)
  110. [SOLVED:] VBA Excel - identify duplicates and rearrange them (6 replies)
  111. [SOLVED:] Partial qualifying references (8 replies)
  112. [SOLVED:] Create sophisticated loop (13 replies)
  113. [SOLVED:] Sort running sum in descending order using excel formula (2 replies)
  114. [SOLVED:] Send multiple columns and rows by e-mail vba (4 replies)
  115. [SOLVED:] Conditional formatting by specific rule through many rows. (5 replies)
  116. [SLEEPER:] Have this code/query select what ever the current table is as a range & process? (2 replies)
  117. Extract Members of an Outlook Dynamic Distribution List to excel worksheet (3 replies)
  118. VBA - Copy & insert the currently selected row of data multiple times (2 replies)
  119. [SOLVED:] Remove duplicates macro for a table ? (4 replies)
  120. [SLEEPER:] Help (2 replies)
  121. [SOLVED:] vba - select and copy multiple rows in different columns (4 replies)
  122. [SOLVED:] New to VBA and require assistance modifying code. (17 replies)
  123. multiple e-mail links over 255 characters. (5 replies)
  124. [SOLVED:] Problem with VBA in Excel - following code giving me an error (2 replies)
  125. Unrelated User Entry Pause (6 replies)
  126. [SOLVED:] Button to copy cells from A4 to A13 to the clipboard (3 replies)
  127. [SOLVED:] Multiple Date matches (9 replies)
  128. function that will set a specified cell to a specified value. (2 replies)
  129. [SOLVED:] Automatically filter a report with date and time, with other criteria (9 replies)
  130. [SOLVED:] Count matching criterias only if duplicate values are found formula ? (5 replies)
  131. [SOLVED:] Automatically rename a template sheet with today's date. (12 replies)
  132. format help (3 replies)
  133. reports the distance between values with respect to a given value (14 replies)
  134. [SOLVED:] Match and then Copy/Paste based on dates (11 replies)
  135. [SOLVED:] Sum (column) value across multiple column criteri (9 replies)
  136. [SOLVED:] Split specific hours at the start of the week (9 replies)
  137. [SLEEPER:] I see there's a new function in Excel (9 replies)
  138. [SOLVED:] Finding data (12 replies)
  139. VBScript deprecated (6 replies)
  140. How to search based on text in website to get element info? (0 replies)
  141. Happy Birthday VBAX (1 replies)
  142. Fix for BOM issue in first cell of imported txt file in Excel 2019? (3 replies)
  143. VBA - Way to recreate chart from excel in powerpoint (not paste or embed) (3 replies)
  144. [SOLVED:] conditional formatting to be macro on specific rows and colums (18 replies)
  145. Average value (3 replies)
  146. To declare or not to declare (18 replies)
  147. Power Query: Which technique will get me the same results as XLOOKUP? (8 replies)
  148. [SOLVED:] Assignment Vs Condition (17 replies)
  149. Searching for special characters (8 replies)
  150. [SOLVED:] Sending Charts to Power Point. (7 replies)
  151. [SOLVED:] Defining Variables (2 replies)
  152. [SOLVED:] Runtime error: 13 mismatch in complicated VBA array (19 replies)
  153. Simulating a function 1000 times for a given integer (easy) (1 replies)
  154. [SOLVED:] Is it possible to chart hidden figures (data) (6 replies)
  155. [SOLVED:] A more simple or efficient way of entering header row text & formatting ? (8 replies)
  156. VBA code help (3 replies)
  157. Simulating Futures trade outcome with 0-100% liquidity buffer (HELP!) (0 replies)
  158. [SOLVED:] Converting Column To Specific Date Format (18 replies)
  159. [SOLVED:] I would like to calculate equilibrium price and quantity using VBA but I can't. Help! (4 replies)
  160. [SOLVED:] Opening and extracting data from another workbook (5 replies)
  161. [SOLVED:] How to distinguish data from html (4 replies)
  162. [SOLVED:] Multi choice data source select for a chart (21 replies)
  163. [SOLVED:] Count the number if times a unique number appears in a list (38 replies)
  164. Excel VBA Open Word Doc and Save as New Word Doc (8 replies)
  165. [SOLVED:] Creating a logging column and fill out missing values (4 replies)
  166. Question How to put slash with word and ascending numbers in excel with VBA (12 replies)
  167. [SOLVED:] Download Multiple tables following URLs list in an Excel's worksheet Through VBA (8 replies)
  168. Experts Help (3 replies)
  169. Create screenshot with macro (4 replies)
  170. [SOLVED:] When should code be broken down into proceedures (7 replies)
  171. [SOLVED:] How to close all .csv or .xlsx type file (5 replies)
  172. [SOLVED:] Selecting Cells Advanced (16 replies)
  173. Open DXF file from a button on the toolbar or userform is not working, Need help? (19 replies)
  174. [SOLVED:] Debug this code. (12 replies)
  175. [SOLVED:] Case Select vs. Switch (10 replies)
  176. Is there a limit to how many terms you can stick in a Case Selection? (10 replies)
  177. VBA Code Needed (7 replies)
  178. [SOLVED:] save vba process data time (7 replies)
  179. [SOLVED:] JsonConverter question (8 replies)
  180. Extract and Copy Data from an Array to a Cell with Criteria (4 replies)
  181. [SOLVED:] VBA Date Filtering Issue (3 replies)
  182. [SLEEPER:] Turn Excel Object Broswer into a 4-column long list, in Excel (2 replies)
  183. [SOLVED:] Multiple chart combined into one (12 replies)
  184. Plausibility check via VBA (2 replies)
  185. [SOLVED:] Renaming File Name (4 replies)
  186. [SOLVED:] Offset value as ".Text" use (5 replies)
  187. [SOLVED:] Update cell value for all files in a folder (3 replies)
  188. [SOLVED:] Excel Image Viewer and Rename its File Name (17 replies)
  189. Issue saving Excel Worksheet to .pdf (8 replies)
  190. Let and Lambda (10 replies)
  191. [SOLVED:] How to list dates defined by a data validation process (26 replies)
  192. [SOLVED:] Chart data for a selected range (12 replies)
  193. [SOLVED:] Converting numbers to text by macro (3 replies)
  194. [SOLVED:] vba get html table value into excel sheet (9 replies)
  195. Excel VBA Find macro fails to find a string even when the string is present in sheet! (9 replies)
  196. Need Help with Excel Macro (5 replies)
  197. [SOLVED:] Need help on VBA (13 replies)
  198. Excel - find a specified value in word document table and move it (2 replies)
  199. userform - help needed (2 replies)
  200. How to Delete Rows Based on Given text (3 replies)
  201. Excel VBA, copy 8 columns of data, paste "stacked" into 4 colums (4 replies)
  202. Excel VBA Repeating and Merging Data Into Some Columns (1 replies)
  203. [SOLVED:] Rename Excel files in folder with VBA (12 replies)
  204. spilt date and time to new columns (11 replies)
  205. Excel 365 Crashing on a 64 bit system (9 replies)
  206. How to share an Excel file with VBA code online? (1 replies)
  207. Macro that converts 1000pdf files from folder to jpgs (1 replies)
  208. getdetailsof - method or data member not found (9 replies)
  209. Selecting a cell in a given Range Not working (2 replies)
  210. VBA Code Help Bounty 1/5 Star Difficulty (27 replies)
  211. Excel Not Enough memory error into a export to pdf (4 replies)
  212. Sleeper: Writing File Address to Save File Directly to a Shared Folder (1 replies)
  213. [SOLVED:] Capturing Sort order.. (11 replies)
  214. [SOLVED:] List of Categories/Units given in a table of data (2 replies)
  215. Excel 2007 and Acrobat Reader VBA code to combine multiple PDF files into one PDF (5 replies)
  216. How to combine many ranges into one big table with vba? (and remove all of the headin (9 replies)
  217. [SOLVED:] Error 50290 on Selection Macro (17 replies)
  218. [SOLVED:] Iterating through a range of cells with a message at the end (11 replies)
  219. Excel 2007 Macro to convert more pdf files to 1 single pdf file (5 replies)
  220. [SOLVED:] Using a VBA code to change another VBA code (4 replies)
  221. [SOLVED:] Special combinations (10 replies)
  222. [SOLVED:] Copy/Paste/Count String Data from LookUp List with VBA (11 replies)
  223. [SOLVED:] Take Focus Away From UserForm After Initializing It (2 replies)
  224. [SOLVED:] Close a UserForm Via Code Only (12 replies)
  225. Message Boxes, Routines and how prevent Message boxes until an event happens (19 replies)
  226. [SOLVED:] Prevent Macro From Activating Upon Selecting Cells For Printing (2 replies)
  227. [SOLVED:] Power Query Custom Column Formula (6 replies)
  228. [SLEEPER:] Goalseek loop (1 replies)
  229. [SOLVED:] Macros run in spreadsheet but produce errors when run in vba editor (9 replies)
  230. [SOLVED:] Restructuring data from html output to excel worksheet with vba (8 replies)
  231. Is there a way to speed up my code which copy a heavily formula infested worksheet (14 replies)
  232. S: Select all slicers on a sheet and arrange them vertically IN ALPHA ORDER by NAME? (6 replies)
  233. [SOLVED:] "Translation" help for a bit of code (where year is identified) (6 replies)
  234. Adding an asterisk (5 replies)
  235. [SOLVED:] VBA script to open files based on criterias (14 replies)
  236. VBA script to monitor folder and change file to csv (3 replies)
  237. [SOLVED:] Disable Save Notification Upon Closing Excel (2 replies)
  238. Better to create PDF file from Excel or from Word? (7 replies)
  239. VBA code to move data from Pivot Table to unhidden columns on a different sheet? (1 replies)
  240. Name Manager for Excel on-line, now available! (0 replies)
  241. [SOLVED:] Solutions for Text Boxes in Excel (6 replies)
  242. [SOLVED:] Copying (downloading) a file knowing its URL (With VBA). (8 replies)
  243. VBA - character counting analysis (5 replies)
  244. [SLEEPER:] Physical Counting (1 replies)
  245. [SOLVED:] VBA Arrays with References to Multiple Sheets (14 replies)
  246. [SOLVED:] Calculation of all combinations by taking a min Max quantity from multiple data set (7 replies)
  247. [SOLVED:] Open an Excel on OneDrive (2 replies)
  248. [SOLVED:] Edit with VBA on Startup: File > Options > Customize Ribbon (2 replies)
  249. Excel VBA Macros (1 replies)
  250. VBA code to create OUTLOOK email (8 replies)