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. [SLEEPER:] Search for Values that meet a Criteria and Paste Location in a New Sheet (1 replies)
  2. Macro to move from windows media player to an Excel worksheet (6 replies)
  3. Search From a User Form and Display Results in a Worksheet (1 replies)
  4. Creating a official form in Excel using VBA!! (2 replies)
  5. [SOLVED:] Condensing IF statements (4 replies)
  6. Making VBA program more user friendly (8 replies)
  7. Find duplicate values accross columns per row (7 replies)
  8. [SOLVED:] Assigning two macros to one shape to run on different actions (5 replies)
  9. Find value in Excel from Array within Word (5 replies)
  10. Advance filter help (8 replies)
  11. Time Conversion into text (1 replies)
  12. [SOLVED:] Formula Support Issue (2 replies)
  13. [SOLVED:] Composing Email using Macro (6 replies)
  14. VBA ListBox List - Want only selected columns to be displayed (21 replies)
  15. [SLEEPER:] Multiselect Multicolumn Listbox allow users to add data? (3 replies)
  16. [SOLVED:] Range Syntax (13 replies)
  17. [SOLVED:] Copy Column Table x times and add counter (2 replies)
  18. vba to copy and paste each file name (2 replies)
  19. vba help (1 replies)
  20. [SOLVED:] Windows Folder Creation From Excel & How to Check A Folder Has Not Been Created (2 replies)
  21. [SOLVED:] Open CSV UTF-8 files (no acces to editing BOM) (3 replies)
  22. Error 400 (1 replies)
  23. [SOLVED:] VBA plot a Scatter graph data - X and Y axis data taken from sheet row by row (16 replies)
  24. [SOLVED:] Message Box Still Appearing When Code Runs Correctly (6 replies)
  25. progress bar (1 replies)
  26. Call code when text is in a Range, NOT every time it appears in the Range. (9 replies)
  27. No Locals Window (2 replies)
  28. Listbox items as Hyperlinks (1 replies)
  29. Get XLA file (3 replies)
  30. code optimization (10 replies)
  31. [SOLVED:] Trying to copy multiple worksheets into new workbooks (3 replies)
  32. [SOLVED:] complie error: Expected: end of statement (3 replies)
  33. VBA error 1004 (2 replies)
  34. [SOLVED:] Print Hidden Worksheets from Userform (13 replies)
  35. Unable to use formula in Shapes (3 replies)
  36. Management weekly report (3 replies)
  37. [SOLVED:] Faster way delete strikethrough (2 replies)
  38. [SOLVED:] Array Filtered without Spaces after 1aRow (6 replies)
  39. Ctrl Shift Enter on FormulaArray VBA (2 replies)
  40. FIFO-GAIN-STOCK PROBLEM (1 replies)
  41. Why will my loop not move through different worksheets (tabs) (2 replies)
  42. [SOLVED:] Autofilter with variable criteria & field (2 replies)
  43. Using Countif iterating thru rows in a sheet (1 replies)
  44. APIs for Hiding UserForm "X" and\or Adding UserForm Minimize (32 & 64 bit) (8 replies)
  45. [SOLVED:] Error on adding validation list (2 replies)
  46. [SOLVED:] How to open windows folder using double click on a cell. (11 replies)
  47. Monthly/Yearly Bills workbook (0 replies)
  48. [SOLVED:] Passing UserForm Text from One Excel Application to Another (9 replies)
  49. VBA SUMIFS Function (2 replies)
  50. Copying rows over to new workbooks based on unique column values (5 replies)
  51. Win10 + Excel 2016 fail to connect WebDav with ADODB.connection (1 replies)
  52. How to combine Selection. PasteSpecial and Selection.insert Shift in one VBA code ? (1 replies)
  53. Generating a Pareto chart based on date (2 replies)
  54. Run-time Error 1004 (1 replies)
  55. VBA Auto Filter (5 replies)
  56. Export / Save as PDF in specific folder. (1 replies)
  57. [SOLVED:] Comparing two range of cells to find out the number of matches (4 replies)
  58. Help about dynamic value table array in Vlookup (10 replies)
  59. [SOLVED:] Dynamically populate multiple ComboBoxes (5 replies)
  60. [SOLVED:] Generating results from different sheet by filters (10 replies)
  61. how to check network file through VBA (4 replies)
  62. Multipage Tiff file in Excel VBA Userform (6 replies)
  63. [SOLVED:] Another Delete Sheets Macro (3 replies)
  64. [SOLVED:] How to set formula equal to a series of numbers (2 replies)
  65. UserForm has Minimize Button. How do I execute it via code. (11 replies)
  66. [SOLVED:] Help to get one or more filename from folder in excel and make it hyperlink to it (4 replies)
  67. Copy Cells with Range(Cells R,C). match returning location in numbers (4 replies)
  68. Check If URL Returns 404 (1 replies)
  69. [SOLVED:] Subtotal?? (8 replies)
  70. [SOLVED:] Search workbook for worksheet name, IF yes then run code, IF not display MsgBox (2 replies)
  71. VBA with Vlookup dynamic (5 replies)
  72. [SOLVED:] Option Button Value (3 replies)
  73. count up cell value by one and automatically be protected (4 replies)
  74. Remove duplicated values from 1d string array vba (1 replies)
  75. Counter sums quantity of files in said folder but doesnt update unless double clicked (10 replies)
  76. insert rows and paste in section from a range (4 replies)
  77. VBA code to make sheet uneditable after I save (4 replies)
  78. Workbook that forces users to enable Macros and automatically closes after some time (3 replies)
  79. Email userform (13 replies)
  80. Sheet Not Fully Active after Selecting or Activating (9 replies)
  81. [SOLVED:] VLOOKUP and skip blanks (5 replies)
  82. [SOLVED:] Convert C# to VBA (15 replies)
  83. Export From Excel To Access! (0 replies)
  84. Migrated to Office 365 from Office 2016 - MACRO no longer functions (1 replies)
  85. [SOLVED:] Remove permanent comment from cell (1 replies)
  86. [SOLVED:] Multiple users (2 replies)
  87. Sort using part of cell value (2 replies)
  88. [SOLVED:] Save Each Worksheet to Individual PDF (6 replies)
  89. Help with coding for labels (1 replies)
  90. Storing row numbers (4 replies)
  91. [SOLVED:] Create table for each name in specific column (2 replies)
  92. Formula to check for embedded object and return a checkmark (5 replies)
  93. Find Text String in Range then copy cell into another range (1 replies)
  94. [SOLVED:] Clearing a merged range of 4 columns and 2 rows (2 replies)
  95. [SOLVED:] Chinese Encode in VBA (6 replies)
  96. vba consolidation of specific sheets data and Pasting in specific Master sheets (2 replies)
  97. alternative to VLOOKUP for large range (5 replies)
  98. [SOLVED:] -- (Double Unary) (2 replies)
  99. Generate random number of strings that are stored in an array . (7 replies)
  100. [SLEEPER:] Excel formula (1 replies)
  101. VBA CODE showing result as #VALUE! (2 replies)
  102. vba code not working (0 replies)
  103. problem with getelementsby... (4 replies)
  104. Excel VBA to import txt file AND automatically insert rows (1 replies)
  105. Read multiple .txt files and copy specific text to excel (1 replies)
  106. [SOLVED:] Run time error 13 Type mismatch (4 replies)
  107. [SLEEPER:] Loop inside a function to retrieve data (1 replies)
  108. [SOLVED:] Find and replace multiple values in Excel using VBA (10 replies)
  109. Need some help with a macro (9 replies)
  110. [SOLVED:] Using VBA to save a xlsm file (Excel 2013) (3 replies)
  111. match supplier name in form with standard supplier name (2 replies)
  112. Need to filter data and create new workbooks (4 replies)
  113. autogenrate id in userform (1 replies)
  114. Sum? sumif? sumproduct? (12 replies)
  115. Combox Depending on others (2 replies)
  116. Looping through columns to merge files into a PDF (4 replies)
  117. Finding Duplicates in Two Columns (1 replies)
  118. [SOLVED:] Beginner help on creating excel visual tool through VBA (4 replies)
  119. [SOLVED:] What determines the size of the userform other than screen resolution? (4 replies)
  120. [SOLVED:] Change a range of cells based on value in specific cell using VBA code (2 replies)
  121. [SOLVED:] the remove method in Collection and Select Case (2 replies)
  122. Toggle Button copy same toggle instructions (6 replies)
  123. [SOLVED:] array filling with multiple unique names (5 replies)
  124. add supplier & customer (8 replies)
  125. Extract data from text file to Excel sheet (1 replies)
  126. [SOLVED:] Change Cell Value As Part Of Copy/Paste Operation (2 replies)
  127. Error after RmDir !! (4 replies)
  128. VBA current cell value = another cell value if criteria met (5 replies)
  129. [SOLVED:] Array formula? (7 replies)
  130. Combo box Duplicates (5 replies)
  131. [SOLVED:] Need a help with loading data using class module (Derivative & Portfolio) (4 replies)
  132. Help with creating duplicate sheets, combo box are linked together (0 replies)
  133. [SOLVED:] Finding the length of elements in a 2D array (3 replies)
  134. [SOLVED:] Edit new code to allow update of posiitional references to be edited by user. (2 replies)
  135. [SOLVED:] Need an advice for searching function (28 replies)
  136. [SOLVED:] Excel Userform Directory - search button using checkboxes (5 replies)
  137. VBA: Copy row to the last line of data (4 replies)
  138. Copying a section if item from a drop down list is selected (16 replies)
  139. problem with data extraction with VBA from Web site (2 replies)
  140. Run-time error 1004 (4 replies)
  141. [SOLVED:] Need help with VBA conditional VLOOKUP on another file (3 replies)
  142. Sumproduct across ranges with varying sum values (4 replies)
  143. sub that creates two arrays month and dayslnMonth (14 replies)
  144. [SLEEPER:] Remove Duplicate VBA (5 replies)
  145. Export to XML (2 replies)
  146. [SOLVED:] VBA Copy formula x times to the right based on value in cell (3 replies)
  147. Application Error (10 replies)
  148. Project Explorer taking up full screen (3 replies)
  149. Merge Multiple Workbooks into One (3 replies)
  150. VLOOKUP to the left (2 replies)
  151. the color of cells (5 replies)
  152. [SOLVED:] Detect the same value on cell and merge them (6 replies)
  153. [SOLVED:] About WorkSheet_Change Event VBA (1 replies)
  154. [SOLVED:] Best way to hide rows depending on cell value? (16 replies)
  155. Dynamic diagramm (14 replies)
  156. [SOLVED:] Date Series Fill (13 replies)
  157. VBA please Support (12 replies)
  158. VBA to create-rename new sheets in a workbook and export them individually as CSV (6 replies)
  159. VBA: Copy and Past between different instances (7 replies)
  160. Help create Macro remove multi-lines duplicate characters (1 replies)
  161. [SOLVED:] Using String variables within a formula in VBA (7 replies)
  162. Macro breaking when any edits to sheet are made (4 replies)
  163. [SOLVED:] Combining multiple Named Ranges into one (8 replies)
  164. [SOLVED:] Need an advice for Insert new Row in other Sheet in VBA (2 replies)
  165. User form Help (5 replies)
  166. Formula for counting most frequent values (1 replies)
  167. VBA how to: Multi line text in cell to column (7 replies)
  168. [SOLVED:] Linear interpolation. retrieving the wrong data. (2 replies)
  169. [SOLVED:] Form Control Listbox help (12 replies)
  170. Use VBA to send XML API (0 replies)
  171. Search for file name in all drives (9 replies)
  172. [SOLVED:] Macro to update macro buttons (3 replies)
  173. Macro captures scrap and submits it to another book. Please Help improve. (1 replies)
  174. [SOLVED:] Email Range in Body of Email - Not pasting the data (9 replies)
  175. VBA Code required to see if workbook is opened or not. (5 replies)
  176. Need an advice for VLOOKUP function in VBA (2 replies)
  177. Looping through code (7 replies)
  178. how to move xls files in same named folders by vba (1 replies)
  179. [SOLVED:] Need VBA Help! (3 replies)
  180. DropBox getting dropdown menu from filtered table (2 replies)
  181. VBA that allows sorting of data by user (2 replies)
  182. Copy to new WorkSheet and name as specific dates (5 replies)
  183. Search and replace (1 replies)
  184. Filter the microsoft date and time picker control output (3 replies)
  185. [SOLVED:] VBA for Excel: automated correction of wrong decimal separator (8 replies)
  186. [SOLVED:] Assistance with bringing specific items from text file into Excel (2 replies)
  187. VBA to insert SUMIFS formula with row number updated when inserted (2 replies)
  188. [SOLVED:] Median with a Condition on Text Selection that Differs Only by Ending Number (4 replies)
  189. Copy selective columns from one worksheet to another in the same workbook (2 replies)
  190. Search Matching Value (1 replies)
  191. [SOLVED:] Set Columns Names in ListBoxes (2 replies)
  192. Userform Listbox Filter using comboBox (29 replies)
  193. CHOOSE with HLOOKUP (3 replies)
  194. [SOLVED:] Insert picture into image control (8 replies)
  195. insert formula - Run-time error '1004' - Application defined or object-defined error (17 replies)
  196. HELP: VBA Listbox - highlight selected states of AU and display some basic info (12 replies)
  197. [SOLVED:] VBA for picking only one value from an SQL base (2 replies)
  198. Re: Track Changes - Text and Formulas with user name and time stamp (1 replies)
  199. Display Data from Two Sheets (0 replies)
  200. Coloring range of cells under colored cels (15 replies)
  201. Restrict entry to textbox (9 replies)
  202. Excel VBA Listbox with additional item number column (11 replies)
  203. [SOLVED:] Index/Match with multiple criteria (4 replies)
  204. [SOLVED:] Help! edit multi-cells with conditions. Thank all of you! (3 replies)
  205. [SOLVED:] Clear cell after Worksheet_Change Analysis (4 replies)
  206. VBA/Excel Workbook Help (2 replies)
  207. [SLEEPER:] Copying & pasting data using file path (11 replies)
  208. from a formula to a macro (1 replies)
  209. Referencing List, how can i find the closest match? (4 replies)
  210. [SOLVED:] VBA Lookup, how to return multiple columns? (2 replies)
  211. [SOLVED:] generate random and unique value of cells (3 replies)
  212. [SOLVED:] Rearranging Words within a Cell (15 replies)
  213. VBA pull first 4 digits until the bottom of the data (1 replies)
  214. Create a list of unique values from multiple workbooks (1 replies)
  215. Copy rows and column headings to new workbook based on cell value (7 replies)
  216. Dataset updates changing the pivot table (1 replies)
  217. VBA Code optimization- Speed up this Macro (2 replies)
  218. [SOLVED:] Change Textbox and Combobox Back Color (7 replies)
  219. [SOLVED:] Sorting Rows by certain columns using VBA (or not?) (2 replies)
  220. Addition of cells as path (1 replies)
  221. Filter Value from Column and paste selection as value in another Sheet VBA (2 replies)
  222. [SOLVED:] Linear interpolation (9 replies)
  223. [SOLVED:] Pivot Table grouping (4 replies)
  224. Graph Data Labels - how to avoid line break (1 replies)
  225. Copy whole frame content to worksheet (3 replies)
  226. [SOLVED:] Help with limiting VBA range (4 replies)
  227. [SOLVED:] Copy column from one sheet to another then sort and remove multiple delimiters (7 replies)
  228. [SOLVED:] Copy + Paste to Last Row based on Last Row of adjacent Column (2 replies)
  229. VBA: Folder & File Lister (1 replies)
  230. Attendance Spreadsheet - Custom point reduction (8 replies)
  231. Find list of words occurred (7 replies)
  232. [SOLVED:] Adding new lines in multiple spreadsheets (5 replies)
  233. [SOLVED:] Condensing code - Using Arrays for Loops (5 replies)
  234. VBA Code to link spreadsheet data (12 replies)
  235. Reverse INDEX and MATCH (2 replies)
  236. Sleeper: Converting Index Match function to VBA code (1 replies)
  237. [SOLVED:] Create a Project Scheduler With Excel (44 replies)
  238. [SOLVED:] automatically consolidate data from different sheets to 1 combined sheet (4 replies)
  239. VBA Get a value from a cell and compare to multiple conditions ElseIf (4 replies)
  240. Method 'Copy' of object'_Worksheet' failed PROBLEM (6 replies)
  241. [SOLVED:] BeforeSave loops and workbook closes (2 replies)
  242. Generating an array, and using Vlookup to loop through this array (VBA) (40 replies)
  243. [SOLVED:] Time Conversion (20 replies)
  244. VBA to copy range from one sheet to another. (1 replies)
  245. [SOLVED:] Looking for help to identify matches across multiple columns (5 replies)
  246. VBA macro to set up dynamic print area (6 replies)
  247. Allocation of Data - URGENT HELP (2 replies)
  248. [SOLVED:] Format Shape menu appears after a printpreview. (3 replies)
  249. [SOLVED:] Move matching rows to existing sheets (9 replies)
  250. code for copying from multiple files and paste in master file (1 replies)