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. [SOLVED:] Macros run in spreadsheet but produce errors when run in vba editor (9 replies)
  2. [SOLVED:] Restructuring data from html output to excel worksheet with vba (8 replies)
  3. Is there a way to speed up my code which copy a heavily formula infested worksheet (14 replies)
  4. S: Select all slicers on a sheet and arrange them vertically IN ALPHA ORDER by NAME? (6 replies)
  5. [SOLVED:] "Translation" help for a bit of code (where year is identified) (6 replies)
  6. Adding an asterisk (5 replies)
  7. [SOLVED:] VBA script to open files based on criterias (14 replies)
  8. VBA script to monitor folder and change file to csv (3 replies)
  9. [SOLVED:] Disable Save Notification Upon Closing Excel (2 replies)
  10. Better to create PDF file from Excel or from Word? (7 replies)
  11. VBA code to move data from Pivot Table to unhidden columns on a different sheet? (1 replies)
  12. Name Manager for Excel on-line, now available! (0 replies)
  13. [SOLVED:] Solutions for Text Boxes in Excel (6 replies)
  14. [SOLVED:] Copying (downloading) a file knowing its URL (With VBA). (8 replies)
  15. VBA - character counting analysis (5 replies)
  16. [SLEEPER:] Physical Counting (1 replies)
  17. [SOLVED:] VBA Arrays with References to Multiple Sheets (14 replies)
  18. [SOLVED:] Calculation of all combinations by taking a min Max quantity from multiple data set (7 replies)
  19. [SOLVED:] Open an Excel on OneDrive (2 replies)
  20. [SOLVED:] Edit with VBA on Startup: File > Options > Customize Ribbon (2 replies)
  21. Excel VBA Macros (1 replies)
  22. VBA code to create OUTLOOK email (8 replies)
  23. [SOLVED:] problem change Office365 for creating a calendar in Outlook. (9 replies)
  24. [SOLVED:] Addition to VBA code (10 replies)
  25. macros (2 replies)
  26. Copying chart from Excel to PowerPoint (2 replies)
  27. VBA - matching and adding value with conditions - please help (7 replies)
  28. [SOLVED:] How to quickly filter out blank cells in multiple rows & columns? (10 replies)
  29. Help editing a current piece of VBA (6 replies)
  30. [SLEEPER:] Help! VBA codiing is not my expertise... (3 replies)
  31. MSG Box (6 replies)
  32. [SOLVED:] Advanced Filter for Dates (4 replies)
  33. Extracting Multiple data points from single Pivot Table (7 replies)
  34. [SOLVED:] Excel Track changes in Excel vba code (3 replies)
  35. [SLEEPER:] how to exchange Multidimesional Arrays' datas? (3 replies)
  36. VBA Macro - invoice - add data to the record fail (1 replies)
  37. [SOLVED:] Search 2 Columns For A Value and Retrieve Values Needed (2 replies)
  38. [SOLVED:] Service Géoplateforme d'images WMS-Raster (3 replies)
  39. [SOLVED:] Macro, how to SaveAs a file with a new name in the same directory where the main file (17 replies)
  40. Create Chart by VBA (2 replies)
  41. [SOLVED:] Lock and unlock conditional on specific cells (6 replies)
  42. [SOLVED:] Using named cell range in a formula (10 replies)
  43. [SOLVED:] Help with code to copy cell value before change event (18 replies)
  44. Speed up Looping through subfolders (1 replies)
  45. VBA - protect sheet and allow grouping/ungrouping (outline) (6 replies)
  46. [SOLVED:] List all formulas in a worksheet on a separate worksheet (2 replies)
  47. delete blank rows in excel using VBA (1 replies)
  48. Excel Macro (2 replies)
  49. [SOLVED:] Make VSTACK(FilterFunctionA,FilterFunctionB) show parent (6 replies)
  50. [SOLVED:] Filter formula include argument (4 replies)
  51. [SOLVED:] Removing redundant code (4 replies)
  52. [SOLVED:] Close VBA form (10 replies)
  53. [SOLVED:] Removing a Users access to a Shared Workbook (6 replies)
  54. Sleeper: Edit VBA code to let it automaticlly create Folder (3 replies)
  55. [SOLVED:] Help With Save All Sheets Except First VBA Code (7 replies)
  56. [SOLVED:] ADODB Get actual displayed values (9 replies)
  57. [SOLVED:] Big Crash (11 replies)
  58. [SOLVED:] stamp duty tax (6 replies)
  59. Sleeper: CheckBoxes (3 replies)
  60. Sleeper Form to populated Selected Cell with Code depending on Radio Option and value (1 replies)
  61. [SLEEPER:] Looping through pivot (and copying data to another sheet) (8 replies)
  62. [SOLVED:] Conditional formatting and wildcards (to apply CF to a string of text) (3 replies)
  63. [SOLVED:] VBA Code Need it to Copy Formulas (6 replies)
  64. Sleeper: Old Windows user in first cell and New Windows user in second cell (VBA) (7 replies)
  65. [SOLVED:] Confusion about XLOOKUP (4 replies)
  66. [SOLVED:] VBA Code to Copy Info (6 replies)
  67. [SOLVED:] Combining VBA Code--Some Help (2 replies)
  68. [SOLVED:] VBA Code to copy 4 cells from one worksheet to another Worksheet (6 replies)
  69. Sleeper: Help with VBA code and XLOOKUP (2 replies)
  70. Date Formula with IF and ISBLANK (6 replies)
  71. [SOLVED:] Copy Used Range Other Workbooks Other Dir n Paste Master WB Sheet1 (2 replies)
  72. [SOLVED:] VBA for all Sheets (Windows login username to cell) (4 replies)
  73. [SOLVED:] Tricky Dynamic filtering problem when using VSTACK (8 replies)
  74. Help Nesting a Formula (3 replies)
  75. [SOLVED:] Add logic to control brightness of shape/button objects? (3 replies)
  76. [SOLVED:] Create a Sorted List of unsorted cells based on color of next cell into a new sheet. (17 replies)
  77. [SOLVED:] Help with RefreshAll (9 replies)
  78. [SLEEPER:] Get Selected Object Name (4 replies)
  79. [SOLVED:] Need a VBA Ignore "Not in List" Validation Error (7 replies)
  80. [SOLVED:] VBA Autofilter Method for Inventory List (18 replies)
  81. Importing Report with Formatting issues (10 replies)
  82. [SOLVED:] Data pull failing in VBA code using User Form (8 replies)
  83. Sleeper: Mark the content with the same values in once cell in red (19 replies)
  84. [SOLVED:] How to add/copy Dynamic Named Ranges to Workbook (3 replies)
  85. Macro to Copy Values and fill colors. (3 replies)
  86. [SLEEPER:] Fixed width import - remove trailing empty columns (14 replies)
  87. [SOLVED:] Which is Faster? (7 replies)
  88. [SOLVED:] "This Workbook" script ignored on opening (4 replies)
  89. [SOLVED:] VBA Excel - For... next instruction (5 replies)
  90. [SOLVED:] Application level click event for shape (2 replies)
  91. [SOLVED:] Combine 2 ranges, compare and take the unique values (11 replies)
  92. Beginner help with VBA (2 replies)
  93. [SOLVED:] Pick multiple file extensions in msoFileDialogFolderPicker (7 replies)
  94. [SOLVED:] VBA - how to change Text Box to date format (4 replies)
  95. vba borders and conditional formatting (4 replies)
  96. Need Help Converting a JSON file to new format (2 replies)
  97. [SOLVED:] Reoccurring Corrupt files (4 replies)
  98. Error when trying to access .ChartData.Workbook for Map Charts (ChartType=xlRegionMap (3 replies)
  99. Need a button to do all the work (4 replies)
  100. RANGE FILL BASED ON CELL VALUES (2 replies)
  101. [SOLVED:] I need VBA to delete lines related to date (3 replies)
  102. Split two different columns with two different addresses (5 replies)
  103. VBA : Input form : Copy column and paste special value in another column (4 replies)
  104. VBA - define variables for shape names & use in a loop function (8 replies)
  105. Converting 32-bit to 64-bit VBA code (3 replies)
  106. Prepare Profit and Loss Statement (2 replies)
  107. [SOLVED:] VBA Code to call another VBA function when certain cells match a given criteria (25 replies)
  108. help with detrended fluctuatin analysis (3 replies)
  109. Vba to copy range from Sheet to another and define a name (4 replies)
  110. [SOLVED:] VBA - Remove Duplicate rows from an entire worksheet (3 replies)
  111. [SOLVED:] Help with a Macro to insert a column of a fairly complicated Date/Time function (3 replies)
  112. Perform basic operations basen on a cell (2 replies)
  113. [SOLVED:] Failed to run codes from txt file (8 replies)
  114. [SOLVED:] VBA Code to Copy UserForm Textbox data to specific Excel sheet/cells (4 replies)
  115. [SOLVED:] Return Subtotal for Table Columns (3 replies)
  116. Optimization of newton-raphson iterative solution with excel solver vba (1 replies)
  117. VBA dictionary concept problem (4 replies)
  118. [SOLVED:] List the 2nd Tuesday of the month for the next 12 months - Calculation Error (9 replies)
  119. Macro to apply MP3 tags changes with VBA (5 replies)
  120. [SOLVED:] Pivot table filter based on value using VBA code (5 replies)
  121. [SOLVED:] Transfer columns from comparable workbook if cell value exists (9 replies)
  122. Scan and copy in same worksheet (0 replies)
  123. Pulling data from another workbook and worksheet (3 replies)
  124. Pull information from selected row via listbox (3 replies)
  125. Extracting Financial Data From PDF (2 replies)
  126. Unprotect sheet for certain users upon start up (2 replies)
  127. A1 RECTANGULAR B1 APPLY (7 replies)
  128. [SLEEPER:] Copy data including coloured cells automatically to another sheet (2 replies)
  129. [SOLVED:] VBA - Search explorer for keyword and return file path (3 replies)
  130. [SOLVED:] Split Text File Into Multiple Text Files keeping the header row (13 replies)
  131. Moving rows when cell value is changed (1 replies)
  132. VBA User form error when saving data to a table (3 replies)
  133. [SOLVED:] dynamically call sub via string (12 replies)
  134. Looping through textboxes to copy files and send emails. (5 replies)
  135. [SOLVED:] Stuck on sorting array (3 replies)
  136. [SOLVED:] VBA display pictures in a table (7 replies)
  137. [SOLVED:] Clearing clipboard performance (7 replies)
  138. Syntax issue (6 replies)
  139. Run time error 91 object variables not set (17 replies)
  140. Create new column in excel when email received. (6 replies)
  141. Excel VB Macro Help (2 replies)
  142. [SOLVED:] Need help: debug/fix VBA code to create new worksheets from template and names list (6 replies)
  143. [SOLVED:] Problem with Query Filters on Excel (4 replies)
  144. Command button to download all attachments recieved today from a specific sender. (12 replies)
  145. Excel Not Changing Serial Date to Formatted Date (4 replies)
  146. [SOLVED:] IF statment nested within VBA Code (71 replies)
  147. Workaround to Create a Checkbox in a table with cells(A:A) (2 replies)
  148. [SOLVED:] VBA help - New row in excel with predefined data (4 replies)
  149. Why cannot print PDF (4 replies)
  150. [SLEEPER:] VBAcode to switch(show and hide) between 4 sum value fields on a data mod pivot table (3 replies)
  151. [SLEEPER:] Row protection based on specific cell (6 replies)
  152. [SOLVED:] Non-VBA question for Conditional Formatting (3 replies)
  153. [SOLVED:] VBA Combination/Posibility problem with and "not equal/OR" (10 replies)
  154. Generating and populating a table based on list of values in another workbook. (4 replies)
  155. Modules and forms autoupdate (1 replies)
  156. [SOLVED:] Auto commentary function (4 replies)
  157. need help in looping (13 replies)
  158. Use Excel VBA to extract fund size data (10 replies)
  159. Next Help to fix VBA please? (3 replies)
  160. Need help with the following code--To Save and Close (3 replies)
  161. Export bespoke PDF macro (0 replies)
  162. [SOLVED:] Compare each Value from a Row with Values in a Range (11 replies)
  163. Sleeper: Inserting a Row under a Specified Value (4 replies)
  164. Sum of arrays (5 replies)
  165. [SOLVED:] Why doesn't the macro I created work on all of my sheets. (4 replies)
  166. VBA copies random rows to new sheet (0 replies)
  167. how to merge two VBA codes in one? (6 replies)
  168. Sleeper: Reset CommandButton Caption after creating PDF (2 replies)
  169. [SOLVED:] VBA code not working (8 replies)
  170. Creating a macro to highlight cells in one sheet using info provided in another sheet (5 replies)
  171. How to save multiple output excel in single folder in the given format (2 replies)
  172. ActiveWorkbook.SaveAs not working with folder (2 replies)
  173. [SOLVED:] Create Named Ranges from worksheet list (5 replies)
  174. [SOLVED:] Help needed to find matching string from the collection. (30 replies)
  175. userform close when i close another excel file (5 replies)
  176. [SOLVED:] Excel VBA NOT LOOPING (3 replies)
  177. [SOLVED:] Open file with vba based on file name (3 replies)
  178. VBA and Highlight function has stopped the Undo Funciton (15 replies)
  179. Cannot find the Chrome binary (2 replies)
  180. Could not find installable isam when connecting Excel 2016 to SharePoint 1016 lists (0 replies)
  181. Split file with multiple sheets into new workbooks based on column value (0 replies)
  182. [SOLVED:] Subtracting Single and Formular values (5 replies)
  183. Sleeper: VBA to continuously click email hyperlink (4 replies)
  184. Need help with VBA (1 replies)
  185. [SOLVED:] Macro to import historical data using web query (9 replies)
  186. [SOLVED:] Inserting Date Last Modified in lots of excel files without opening (24 replies)
  187. VBA module to Macro short cut and sharing to multiple users (16 replies)
  188. [SOLVED:] How to search text in pdf files in one folder (1 replies)
  189. Hide unhide sheets with navigation buttons (1 replies)
  190. [SOLVED:] Why does this work? Replacing IF with Text (8 replies)
  191. [SOLVED:] Saving index to a variable prior to closing the file (2 replies)
  192. [SOLVED:] Close Specific Workbooks Without Saving (22 replies)
  193. [SOLVED:] Summing dynamic Excel column and count (17 replies)
  194. Command Button (3 replies)
  195. [SOLVED:] VBA Hyperlink not working (4 replies)
  196. [SOLVED:] Help with Convert a formula (5 replies)
  197. [SOLVED:] Incrementing a list on clicking a macro button (10 replies)
  198. [SOLVED:] Incrementing value in a cell depending on clicking of a macro button (3 replies)
  199. circular flow diagram (4 replies)
  200. Sleeper: Method to show exponential growth in population (1 replies)
  201. How to create a module to find missing brands and models (look through table 1, compa (2 replies)
  202. [SOLVED:] Update Excel table from a one column range on a different sheet (6 replies)
  203. [SOLVED:] Pivot table showing how a Batsman was given out (6 replies)
  204. [SOLVED:] Existing macro to password protect sheets has stopped working (6 replies)
  205. How to.. Macros only running one active worksheet (2 replies)
  206. Sleeper: Change Cell's named reference via VBA (3 replies)
  207. [SOLVED:] Join Lines (2 replies)
  208. Adding worksheets to a Listbox (14 replies)
  209. [SOLVED:] VBA sub - result in run-time error 9, but code looks good (6 replies)
  210. Sleeper: VBA Change Line colors (12 replies)
  211. Sleeper: Loop for copying and pasting tables (4 replies)
  212. [SOLVED:] Macro Codes for auto fit columns and rows (5 replies)
  213. Sleeper: VBA code to un-merge cells from a Database (4 replies)
  214. [SOLVED:] how to enable macro button for every sheet (2 replies)
  215. Convert Index Match to a regular excel reference (8 replies)
  216. Table format to rows Macro (5 replies)
  217. [SLEEPER:] Simplification of Repetative Actions on 2 sets of Different Ranges (14 replies)
  218. [SOLVED:] Select row apart from a merged area (4 replies)
  219. Sleeper: Excel's Formula by Example (1 replies)
  220. [SOLVED:] Counts min and max quantity of equals 'strings' based on a filter column (10 replies)
  221. [SOLVED:] Custom Function Wtih Range in Another Sheet (3 replies)
  222. Moving file to folder with first couple matching characters (2 replies)
  223. Sleeper: Need some help with arrays and loops (3 replies)
  224. Oddly slow running code, under very specific circumstances (9 replies)
  225. Hide the Macro form Dialog Box (4 replies)
  226. Changing excel version with macros (2 replies)
  227. Switching Between Two Already Open Apps (3 replies)
  228. Automatic sensitivity assignment in Excel VBA - Blocks automatic processes in VBA (5 replies)
  229. [SOLVED:] Excel not handling large number correctly (3 replies)
  230. [SOLVED:] Press button to assign the reason provided and count (9 replies)
  231. [SOLVED:] Dependant cells (11 replies)
  232. [SOLVED:] Copy and paste vba - Full numbers come out -1 (2 replies)
  233. [SOLVED:] Power Query to transpose a dataset (7 replies)
  234. [SOLVED:] VBA Macro. I Think I'm Close But Something Is Not Right (6 replies)
  235. Change lines in a macro with the same idea but different reordering (0 replies)
  236. Automatic form creation from construction activities list (0 replies)
  237. [SOLVED:] Use an Input box to select a range (7 replies)
  238. [SOLVED:] Transposing data (10 replies)
  239. [SOLVED:] Run-time error 1004 when trying to open a VBA form (11 replies)
  240. [SOLVED:] Should I need a terminate initialisation subset as well? (2 replies)
  241. [SOLVED:] VBA Highlight consequent cells based on value from another cell with criteria (2 replies)
  242. Find duplicates in combobox - get index and remove from other comboboxes. (2 replies)
  243. [SOLVED:] PowerQuery Steps to Move Data (2 replies)
  244. [SOLVED:] Error handling (14 replies)
  245. [SOLVED:] VBA code not work if I change the file name (7 replies)
  246. Feedback for Dashboards (0 replies)
  247. Removing folder and subfolder from hyperlink path (1 replies)
  248. [SLEEPER:] Please make my code for an active workbook (4 replies)
  249. Can't position dialog (2 replies)
  250. [SOLVED:] Appointments Failing to Line up correctly when more than one Appt scheduled in a day (11 replies)