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. If Statement ComboBox Value (5 replies)
  2. Delete then restore all data tables in a workbook - fix for Excel 2010? (4 replies)
  3. [SOLVED:] if sheet 9 exists, clear it otherwise create one (15 replies)
  4. [SOLVED:] Find value of cell after filtering (6 replies)
  5. [SOLVED:] Find and Replace in csv Files (13 replies)
  6. [SOLVED:] Macro that finds a semicolon, then copies and inserts rows, and removes some data (2 replies)
  7. Need your help! (1 replies)
  8. [SOLVED:] Shell Command Duration (10 replies)
  9. Auto insert colon and decimal period (1 replies)
  10. [SOLVED:] For Loop with multiple conditions. (7 replies)
  11. [SOLVED:] Pivot Table Filter Macro Error (1 replies)
  12. map xml to sheet whitout export (0 replies)
  13. Excel .xlsm + Run time error 1004 Initialization of the data source failed (2 replies)
  14. [SOLVED:] VBA Merge two tables into one (4 replies)
  15. [SOLVED:] min value (9 replies)
  16. Help needed! (1 replies)
  17. Do Until loop vs array (9 replies)
  18. VBA code skipping cells, not sure why? (4 replies)
  19. Using VBA to change File Folder Properties (3 replies)
  20. Delete some plot area (1 replies)
  21. Pull innertext from 2nd and 3rd tables within each class name (1 replies)
  22. [SOLVED:] deleting empty lines in a word document after inserting text (3 replies)
  23. What's the best way to create a custom user guide for a workbook? (3 replies)
  24. Sleeper: Download .xlsm from outlook (4 replies)
  25. number of decimal (digits after dot) and other (3 replies)
  26. I Need Help Conditional formatting in cell (4 replies)
  27. VBA S.O.S. (3 replies)
  28. Macro no longer works (1 replies)
  29. [SOLVED:] Replace only in text and numbers (not in formulas) (7 replies)
  30. VBA Code is too long and slow to load data from on worksheet to another (4 replies)
  31. PLEASE help me with a VBA macro to filter data with mutiple criteria (6 replies)
  32. VBA Code to search for value in worksheet and enter date into next column (3 replies)
  33. I need vba code Refresh all sheets and save (4 replies)
  34. [SOLVED:] Exporting Single column as .txt file (9 replies)
  35. VBA to Compare 2 Workbooks with Criteria and Paste Differences (2 replies)
  36. Easy way to code all toggle buttons? (3 replies)
  37. Challenge... Very difficult coding HTML knowledge required Please Help!! (4 replies)
  38. Cannot surpress compatibility or auto calculate message..HELP!! (1 replies)
  39. Selection = <Type mismatch> (12 replies)
  40. [SOLVED:] working with Date&Time values / nested loops / Formatting (6 replies)
  41. [SOLVED:] sending email (2 replies)
  42. [SOLVED:] sending email (0 replies)
  43. [SOLVED:] Filter table for results within a date range (0 replies)
  44. [SOLVED:] Is there any event which catches an image being pasted into a workbook? (4 replies)
  45. help me(filter in the listbox) (1 replies)
  46. [SOLVED:] Filter Data, Delete Rows, Then remove filter (2 replies)
  47. [SOLVED:] Make File Folders using data from column range (2 replies)
  48. [SOLVED:] Range of last used cell, Paste Data to last cell (1 replies)
  49. combox preload speed up (3 replies)
  50. Should I look for a solution? (2 replies)
  51. Finding value in matrix (5 replies)
  52. Help macro copying specific columns from one workbook and paste value .... in another (1 replies)
  53. Hide columns based on cell value (6 replies)
  54. How to stop displayig a cell text in the formula bar? (3 replies)
  55. [SOLVED:] 3D Z-Axis (8 replies)
  56. Using values from merged cells (VBA) (3 replies)
  57. [SOLVED:] find highest high and highlight it (11 replies)
  58. Coding Assistance! (7 replies)
  59. Sleeper: Make macro more efficient (3 replies)
  60. Macro SoS! (7 replies)
  61. [SOLVED:] Select specific sheets then run a copy row macro (2 replies)
  62. Macro to copy information from the main worksheet by date and city criteria and paste (5 replies)
  63. [SOLVED:] Pulling back Unique ID to excel (4 replies)
  64. [SOLVED:] vba to copy a content of cells marked green (5 replies)
  65. [SOLVED:] Running a macro in a worksheet from a module (10 replies)
  66. [SOLVED:] Can VBA copy a table from Word and be pasted entirely into one single cell in Excel? (2 replies)
  67. [SOLVED:] Find and copy from another sheet? (9 replies)
  68. VBA Suchen und Ersetzen (1 replies)
  69. Match and copy. (6 replies)
  70. VBA to determine the rank of a matrix (7 replies)
  71. Filtering text data into n subsets then summing (12 replies)
  72. BOM Challenge (10 replies)
  73. [SOLVED:] Need help with returning values from excel sheel to another using cell address (1 replies)
  74. Sleeper: Help required regarding solving the excel problem. (1 replies)
  75. [SOLVED:] VBA Evaluate returns #VALUE for some expressions (SUMPRODUCT and IF) (14 replies)
  76. reference combobox as a variable (4 replies)
  77. Excel vba string find and replace/change column value with a variable string (4 replies)
  78. [SOLVED:] VLOOKUP Problem (duplicating lines) (10 replies)
  79. [SOLVED:] Return Column / Row name of active cell (6 replies)
  80. [SOLVED:] Macro recording gives different result in graph (6 replies)
  81. [SOLVED:] referencing a control type (3 replies)
  82. [SOLVED:] Selecting userform from cell content (1 replies)
  83. [SOLVED:] Anyone know how to - Range = typed array (22 replies)
  84. VBA to force paste special (19 replies)
  85. [SOLVED:] VBA open password protected file in read only mode (3 replies)
  86. how to grab filter list data (2 replies)
  87. Quick question about my code that creates a 2D array (11 replies)
  88. Tweak VBA to Move SharePoint Files to a Folder in Same Location (5 replies)
  89. Copying formulas from 2 different workbooks (0 replies)
  90. VBA Reference problem (4 replies)
  91. [SOLVED:] Using stdev() function in VBA (2 replies)
  92. Help with activating sheets (3 replies)
  93. Running a macro when double clicking a cell in another sheet (1 replies)
  94. Write formula in VBA-'Error 13' (4 replies)
  95. [SOLVED:] Error 1004 Application defined or object defined when code runs (3 replies)
  96. [SOLVED:] Help with syntax for nested dictionaries (8 replies)
  97. Macro/VBA code help (9 replies)
  98. Evaluate 3 columns of data and display 1 value in a 4th column (3 replies)
  99. Create Button Shadow Effect (7 replies)
  100. [SOLVED:] VBA issue with renaming a file (8 replies)
  101. Macros for saving the file with sertain file name (2 replies)
  102. [SOLVED:] prevent form to make the sheet scroll? (7 replies)
  103. Check if a text box exists in a webpage and if so then run code. (4 replies)
  104. [SOLVED:] Using VBA in Excel 2010, need to change text of many cond formats, but how? (4 replies)
  105. Replace Query Database (5 replies)
  106. [SOLVED:] Create sub lists from main list (5 replies)
  107. Next loop without calling additional functions on error (4 replies)
  108. Sleeper: Adding a subroutine to a macro already done. (1 replies)
  109. [SOLVED:] Conditional percentile calculation (2 replies)
  110. Re-Enabling Cut/Copy/Paste on Excel (3 replies)
  111. Is it possible to run code every 24th hour for 3 days? (5 replies)
  112. Run code every 24th hour for three days - fx? (0 replies)
  113. İf cell contains the number then copy certain cells to another book (5 replies)
  114. [SOLVED:] Userform with doubleclick filled with values of autofilter (4 replies)
  115. [SOLVED:] VBA code to track changes in workbook (14 replies)
  116. VBA code not finding values that contain numbers and letters....HELP! (12 replies)
  117. Find maximum number of rows with text, then fill accordingly (6 replies)
  118. VBA code required to unhide multiple sheets (5 replies)
  119. [SOLVED:] Help with array printing (4 replies)
  120. [SOLVED:] VB to search for a key word in Column A, then copy it to column B for multiple rows. (3 replies)
  121. Put text in multiple cells (3 replies)
  122. Error 1004 (1 replies)
  123. Help me tweak working VBA Code (4 replies)
  124. [SOLVED:] Problem with Print All Sheets (4 replies)
  125. Calculation on matrix using formula (0 replies)
  126. [SOLVED:] Copy cells from password protected (to open) workbook into another file (2 replies)
  127. Traffic lights - Increasing/Decreasing Trends (3 replies)
  128. First 6 minimum values of a row in an array (5 replies)
  129. [SOLVED:] How to list all the files in a folder? (2 replies)
  130. [SOLVED:] VBA Code for Combining Multiple Columns into One Column - Excel for Mac (3 replies)
  131. [SOLVED:] Excel VBA to copy cells from password protected file into another file (12 replies)
  132. Extracting data, pivot tables, and maybe VBA help? (10 replies)
  133. Custom Data Type - Dim Variable As CustomDataTypeName (4 replies)
  134. My greeting macro doesn't run automatically when I open Excel (3 replies)
  135. [SOLVED:] WorksheetFunction.HLookUP 1004 Error (7 replies)
  136. [SOLVED:] Excel VBA to open a workbook that contains a string (1 replies)
  137. Run Macro Save AS (4 replies)
  138. [SOLVED:] Macro Button (3 replies)
  139. [SOLVED:] insert name of tabs that had data copied in master tab (5 replies)
  140. [SOLVED:] Getting values off another sheet by references!? (2 replies)
  141. Help with Data copy from IE to Excel (0 replies)
  142. Create appointments on a shared Outlook calendar from Excel (3 replies)
  143. Sleeper: Scaling chart based on values (1 replies)
  144. [SOLVED:] Getting values from merged cells (1 replies)
  145. Max Frequency (1 replies)
  146. [SOLVED:] UF Run Macro if LEN equals a number (3 replies)
  147. Assigning Headers (5 replies)
  148. VBA Get Data Java (0 replies)
  149. VBC to highlight / select group of active cell (3 replies)
  150. What does '400' mean? (4 replies)
  151. conditioned comboboxes (2 replies)
  152. Find and replace words that are formatted with tags (3 replies)
  153. [SOLVED:] Serious trouble with running total calculations (12 replies)
  154. ActiveWorkbook vs Application.Workbooks (2 replies)
  155. How to updated pivot tables on different tabs from user form parameters? (37 replies)
  156. Activating multiple sheets with countifs function (4 replies)
  157. [SOLVED:] Extracting values from sheet 1 to sheet 2 (5 replies)
  158. Source code - Cant find something that ought to be there (1 replies)
  159. Pivot data Filter VBA Code require (0 replies)
  160. How do you extract only specific FormFields from multiple Word documents into Excel? (4 replies)
  161. Creating a master tracker to copy worksheets and perform tasks (10 replies)
  162. [SOLVED:] Workbooks object question (2 replies)
  163. [SOLVED:] error when vba editor opens by code 'not trusted' (0 replies)
  164. VBA macro code to find and replace values in XMLfiles using Excel list (0 replies)
  165. [SOLVED:] Bypassing a dialog box (2 replies)
  166. [SOLVED:] UF ComboBox Populate from Sheet (3 replies)
  167. VBA Dynamic Start Rows (10 replies)
  168. Help for using MID and INSTR in source code! (3 replies)
  169. Error 424: what am I missing? (3 replies)
  170. [SOLVED:] Splitting the content of a cell based on special characters (2 replies)
  171. delete rows based on search criteria (1 replies)
  172. [SOLVED:] Working with "selection" instead of precise address= slow as a snail (5 replies)
  173. [SOLVED:] Sub or Function not defined (10 replies)
  174. [SOLVED:] How do I update multiple worksheets based on one userform? (3 replies)
  175. Combine Columns from different worksheets into one (2 replies)
  176. [SOLVED:] Make one loop with dinamic rang (Find Last Cell) (9 replies)
  177. [SOLVED:] Wronf priority of events? picture in form not showing because heavy processing (2 replies)
  178. Error bars on charts (1 replies)
  179. Print Results To Excel Worksheet (6 replies)
  180. Shared Workbooks - against all odds... (2 replies)
  181. Macro update to copy data from sheet 1,2,3 into same sheet (1 replies)
  182. [SOLVED:] Making multiple files. (4 replies)
  183. [SOLVED:] ByRef argument type mismatch (2 replies)
  184. [SOLVED:] vba conditional formatting (1 replies)
  185. i want required vba. I am looking for a small value from the Range (4 replies)
  186. [SOLVED:] unmerge all cells a workbook from another workbook (3 replies)
  187. Can't locate bug of a Run-time error '438' message (3 replies)
  188. [SOLVED:] Run time error 52 - bad file name or number (1 replies)
  189. AverageIF function (5 replies)
  190. [SOLVED:] VBA: Export Certain sheets of a workbook as PDFs (2 replies)
  191. Deleting Rows That contain specific content in two columns (1 replies)
  192. [SOLVED:] No rush, just to improve myself (3 replies)
  193. Send SMS from Excel VAB from API (2 replies)
  194. Compare cells with one value against cells with two values then merge and count (6 replies)
  195. countifs in the VBA (3 replies)
  196. web extraction (3 replies)
  197. Runtime Error 9 Help (3 replies)
  198. What should be the VBA code for this output (2 replies)
  199. Data set analysis (0 replies)
  200. Updating Links on networked spreadsheet (0 replies)
  201. how to skip a VBA code if it already exist - Rename worksheet (1 replies)
  202. Action to cells in a specific column of selected rows (2 replies)
  203. Searching for a string and move it's data to different sheets (8 replies)
  204. Disable "Save" & "SaveAs" (4 replies)
  205. After mail merge code want save as box for Word doc (8 replies)
  206. [SOLVED:] Looping Through Calculations (6 replies)
  207. Need Help: Changing Date Formatting, Filter Unique Value, Sort (1 replies)
  208. VBA assistance required for copy values (2 replies)
  209. [SOLVED:] Problem Copying two Sheets from one workbook to another workbook (2 replies)
  210. VBA Type Mismatch Error on Pivot Table Creation (5 replies)
  211. ActiveCell.Offset(1, 0).Range("A1").Select? (1 replies)
  212. Syntax to selecting multiple columns/particular column with its contents in Excel VBA (4 replies)
  213. opening a word document (5 replies)
  214. Getting 1004 Error from sorting a range and cannot figure out why. (3 replies)
  215. Excel VBA user form (3 replies)
  216. VBA help: Copy, offset, add cells, repeat, all on one button? (6 replies)
  217. VBA Creates Pivot Table Except when Row 1 is blank (5 replies)
  218. allocating the totals - to numbers equally (11 replies)
  219. User must fill in certain cells before they can close the workbook (5 replies)
  220. Help sorting data (7 replies)
  221. Macros - Upgrading from Excel 2003 to Excel 2010 (5 replies)
  222. Validation Of Names Required from given List :confused (5 replies)
  223. Recognizing linked changes, Worksheet_Change(ByVal Target As Range) (1 replies)
  224. [SOLVED:] Pivot table not showing the selected items when filter added (4 replies)
  225. Moving duplicate and unique values from one sheet to another. (0 replies)
  226. How can I fill Database with VBA on Mac? (0 replies)
  227. Printing Visible Data Only (3 replies)
  228. [SOLVED:] What did I miss? (get constant value from the string text) (8 replies)
  229. VBA Match & Copy (2 replies)
  230. Remove Duplicate macro, modify to delete adjacent cell (8 replies)
  231. How to save each change in list in new workbook (4 replies)
  232. Sleeper: VBA for Page Headers (1 replies)
  233. Combine data from many worksheet into one worksheet (1 replies)
  234. [SOLVED:] Summing of multiple totals. (2 replies)
  235. [SOLVED:] Combi Box disappearing from the screen. (3 replies)
  236. [SOLVED:] Showing help on object elements from a form? (2 replies)
  237. Excel vba copy paste with formulas (2 replies)
  238. Various items - exporting to various .txt files where duplicates (5 replies)
  239. [SOLVED:] VBA Sorting multiple rows (4 replies)
  240. [SOLVED:] VBA - Determine cell value of specific column and row in userform (2 replies)
  241. help me please (15 replies)
  242. sortind dates (2 replies)
  243. Need a VBA coding (5 replies)
  244. [SOLVED:] Optimizing VBA code so that it can execute on a workbook of 50,000 rows w/o crashing (11 replies)
  245. NEED CORRECTION IN MACRO (5 replies)
  246. Excel vba jump to specific row in worksheet (2 replies)
  247. HELP: How to format certain texts enclosed by specific characters (7 replies)
  248. Create individual folders for next day (4 replies)
  249. Syntax to identify if something does NOT match a Wildcard? (7 replies)
  250. [SOLVED:] Clear worksheets from list (7 replies)