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 Formula not working as expected (5 replies)
  2. vba help to copy specific colulmn.. from a sheet (1 replies)
  3. adding selected rows into a sheet with a specific selection (4 replies)
  4. Control strings (7 replies)
  5. Advance Filter using VBA (9 replies)
  6. how to make CommandButton1.Rotation = 90 in office 2016 (4 replies)
  7. [SOLVED:] Move File to Folder if filename matches foldername (5 replies)
  8. [SOLVED:] Need help with Do While Loop or If this AND that then.... (6 replies)
  9. VBA code in Cash Flow forecast (24 replies)
  10. Macro to convert from Paste Bottom-Up to Top-Down? (8 replies)
  11. Move cells to another worksheet (2 replies)
  12. [SOLVED:] Unzip files to a folder udf (3 replies)
  13. [SOLVED:] Searching with recursion (13 replies)
  14. [SOLVED:] VBA code mysteriously timing out (2 replies)
  15. VBA Macro - Use relative ranges to graph (7 replies)
  16. [SOLVED:] #Name? error for TextJoin UDF (9 replies)
  17. MSO File Picker Help (2 replies)
  18. VBA code for lookup table (7 replies)
  19. [SOLVED:] vba Double for each Loop combining task (1 replies)
  20. Vertical Column with possibility to filter (3 replies)
  21. modifying function cohort/matrix of ratings migration (0 replies)
  22. VBA Conditional Formating (2 replies)
  23. USER-FORM FILTER DATA EDIT (1 replies)
  24. [SOLVED:] Sort/ transfer data (6 replies)
  25. [SOLVED:] Procedure Too Large - Compile Error (14 replies)
  26. Search string in two columns in different excel sheets and copy the matching data (1 replies)
  27. [SOLVED:] VBA VLOOKUP ON Historic trades (6 replies)
  28. [SOLVED:] VBA FILTER (10 replies)
  29. [SOLVED:] Need help duplicating a row (if not already duplicated) (2 replies)
  30. [SOLVED:] vba help on vlookup (8 replies)
  31. Export all the sheets in excel to images individually files (4 replies)
  32. Add Data Field in Pivot Table (2 replies)
  33. Disable Overtype / Insert Ability in VB Editor for Excel 2016 … (2 replies)
  34. Empty a Module within Excel 2016 … (7 replies)
  35. [SOLVED:] Two rankings (8 replies)
  36. [SOLVED:] Populating colums based on cell value and conditions (21 replies)
  37. VBA Use hidden cell to run IF Statement (3 replies)
  38. [SOLVED:] Pivot Table Error with VBA Code (5 replies)
  39. [SOLVED:] Highlighting a cell if there is a match with another cell (9 replies)
  40. [SOLVED:] Looping through ActiveX checkboxes and adding items to ActiveX List Box (5 replies)
  41. Subscript out of range (4 replies)
  42. [SOLVED:] Auto Save excel workbook every 5 minutes (8 replies)
  43. Can you speed up my vba that copy and pastes the header amongst worksheets? (1 replies)
  44. Trying to copy a macro into another workbook (14 replies)
  45. [SOLVED:] Simple for each loop problem (3 replies)
  46. [SOLVED:] How to Send a HTML Email using Word Email Template using Excel Macro (3 replies)
  47. Compare two strings for similarity or highlight differences in Excel (12 replies)
  48. Run-Time error "7" out of memory (1 replies)
  49. VBA To Check That Value Appears In Single Cell Range Before Starting Macro (9 replies)
  50. Change marker size for all series in a plot (VBA) (2 replies)
  51. [SOLVED:] Copy and Move files to existing Sub-folders based on filename/Sub-folders's Name (9 replies)
  52. [SOLVED:] Convert to a number (3 replies)
  53. [SOLVED:] Take out space (22 replies)
  54. [SOLVED:] How to send email in excel using content in word as email body (7 replies)
  55. [SOLVED:] VBA code to cycle through sheets (9 replies)
  56. Reading and Writing to dat file via forms (6 replies)
  57. VBA: referencing cell in one worksheet and using it as range start for another sheet (6 replies)
  58. [SOLVED:] Running Macros from ComboBox with Items from a Range (3 replies)
  59. Function to update a cell in another worksheet giving #1004 error (5 replies)
  60. [SOLVED:] VBA Code assistance to separate a workbook into several different files. (10 replies)
  61. Autofilter failed (3 replies)
  62. [SOLVED:] VBA code attach an excel file to outlook with a variable file path (7 replies)
  63. VBA code running too slow in Excel 2013 (13 replies)
  64. [SOLVED:] Format Issue (6 replies)
  65. Find and Change Values (11 replies)
  66. [SOLVED:] Break up column A content between column A and B (6 replies)
  67. Help with filter by date (5 replies)
  68. [SOLVED:] VBA function to return MySQL Data (5 replies)
  69. vba adding image after clicking on the textbox (2 replies)
  70. [SOLVED:] Select working(Active) range with mouse (14 replies)
  71. [SOLVED:] Need help with Question, is it possible to Call modules to work or loop through? (32 replies)
  72. [SOLVED:] need macro added to current to automatically move to next row for next search and (6 replies)
  73. userform icon in taskbar problem in win10 office 2016 bit 32 (11 replies)
  74. excel vba macro to apply filter multiple column using header names (13 replies)
  75. [SOLVED:] Split function in vba (6 replies)
  76. Run macro on all files (1 replies)
  77. VBA to update a table from another table (2 replies)
  78. Subscript out of range (2 replies)
  79. [SOLVED:] Handling Formula Errors & Formula Length Limit (20 replies)
  80. [SOLVED:] Pull specific data based on If statements (3 replies)
  81. [SOLVED:] Save Outlook attachment into an Excel cell, as OLEObject in VBA (4 replies)
  82. [SOLVED:] Modified a function that is called in another function, now getting runtime error? (5 replies)
  83. [SOLVED:] Angles between 2 lines (6 replies)
  84. Get (some of) Excel Clipboard contents via Windows clipboard "XML Spreadsheet" format (1 replies)
  85. Vba Compile Error :( (15 replies)
  86. Find out row and column range (3 replies)
  87. [SOLVED:] Create 2 Dimensional Array from "For" Loop (8 replies)
  88. [SOLVED:] Extract part of a line and paste in another cell (3 replies)
  89. [SOLVED:] Remove symbol (2 replies)
  90. [SOLVED:] Copy range to blank cell (10 replies)
  91. Open all CSV files in folder, and merge to one master file. (7 replies)
  92. [SOLVED:] Array limits? (6 replies)
  93. Import data from different files and sheets into file with corresponding data cells (1 replies)
  94. VBA Macro to copy multiple charts from one excel file to a word bookmark locations (2 replies)
  95. Required Email generated with signature and attachments (5 replies)
  96. [SOLVED:] Alternatives to MINIFS (Minimum IF's) (7 replies)
  97. File size reduction (43 replies)
  98. [SOLVED:] How do I set passwords and how to save as a certain name for a file (9 replies)
  99. [SOLVED:] Sort by row based on column value (9 replies)
  100. [SOLVED:] Module Level Variable Loses Value (9 replies)
  101. [SOLVED:] MACRO: SaveAs Cell Value File Name (Pull Two Cells within Worksheet as File Name) (5 replies)
  102. [SOLVED:] IF, AND, OR Nesting - Part of it not working (4 replies)
  103. Help with pulling names from online database (0 replies)
  104. [SOLVED:] How to export and save each worksheet as new workbook in Excel? (4 replies)
  105. [SOLVED:] Project Planner Not Working (5 replies)
  106. Labor Tracking / Time Tracking (2 replies)
  107. [SOLVED:] Loop through column data and delete or copy based on value given (12 replies)
  108. Significance Testing Macro (8 replies)
  109. Code suggestions required. (5 replies)
  110. Macro to Copy certain WS's based on Key to a New WB and email (1 replies)
  111. [SOLVED:] VBA to fill up website form and upload file path via “Browse” buttton (4 replies)
  112. VBA - SAP 'Save As' dialogue box (2 replies)
  113. [SOLVED:] Progress Bar for macro (3 replies)
  114. Userform- Populating Dependent List Help (2 replies)
  115. [SOLVED:] Rename text file with new name (14 replies)
  116. Macro to copy excel recordset and insert in to Database based on a condition (3 replies)
  117. [SOLVED:] Text Size Issues in Text Box (2 replies)
  118. Need VBA to create inputbox for multiple values & filter multiple columns (4 replies)
  119. Formatting, Highlighting Travel Times Conflicts (3 replies)
  120. data transfer (3 replies)
  121. [SOLVED:] Macro to Set Page to Print in Particular Range & Adding a Company Logo (4 replies)
  122. [SOLVED:] Need VBA to arrange data Cell adress data please!! (2 replies)
  123. [SOLVED:] Adding a Scroll Option to The Text Boc Functionality (2 replies)
  124. [SOLVED:] Help with code on language translation file (21 replies)
  125. [SOLVED:] loading a variant array (7 replies)
  126. [SOLVED:] Help with updating formula's with VBA (22 replies)
  127. Auto Save excel file to another Computer on the network (2 replies)
  128. pivot table - sort items with different order for each parent item (4 replies)
  129. [SOLVED:] UserForm VLOOKUP to get Data and Change one Column (7 replies)
  130. Help in Pivot (5 replies)
  131. [SOLVED:] Summing of columns into specified cell loop (4 replies)
  132. Compare values inside the range (sheet1) and copy the row to new sheet (sheet2) (12 replies)
  133. How Do I Filter In Excel Using TextBox? (0 replies)
  134. Adding functionality to an existing Excel Workbook (example pictures included) (1 replies)
  135. VBA code for extracting report from Outlook Mails (0 replies)
  136. [SOLVED:] Message in Every Cell (2 replies)
  137. [SOLVED:] Unmerge cells across rows only not across columns (2 replies)
  138. Copy and combine files using VBA (1 replies)
  139. [SOLVED:] VBA: Chart with Combobox (4 replies)
  140. VBA: Match string and color substring (5 replies)
  141. Combine Multiple Worksheets w/ Different Headers Into One Worksheet (1 replies)
  142. [SOLVED:] need help gettng macro to run faster! please!!! (14 replies)
  143. [SOLVED:] ActiveSheet.Previous.Select (3 replies)
  144. Customised spell check in VBA (1 replies)
  145. [SOLVED:] Select from Cube Through VBA (12 replies)
  146. Excel Function -Address (3 replies)
  147. Populating PDF document with Excel vba (2 replies)
  148. [SOLVED:] Extract the formulas of each cell in range - VBA (17 replies)
  149. Get the heights related data in row D (6 replies)
  150. File folder to single spreadsheet (20 replies)
  151. Adding comboboxes in a loop (14 replies)
  152. [SOLVED:] When using open text file how to tell if the file existed, or a file was created? (2 replies)
  153. VBA Error - Missing 4 columns Data after copying (2 replies)
  154. Creating an xml file from each row in excel (3 replies)
  155. Save active sheet only as pdf + Increment the invoice number + print active sheet (7 replies)
  156. New to Macros - file naming issue (5 replies)
  157. [SOLVED:] Re allocate Named Range addresses (5 replies)
  158. [SOLVED:] code for copy and paste (5 replies)
  159. [SOLVED:] Store special cells in one range (14 replies)
  160. [SOLVED:] Autofilter latest event date (3 replies)
  161. insert six rows at specific points (9 replies)
  162. [SOLVED:] PivotTable.DrillDown and filtering the output (14 replies)
  163. [SOLVED:] Search for data highlighted in red return it and return the data in next two columns (2 replies)
  164. VBA to copy url from excel sheet and open in webpage and copy source to notepad (3 replies)
  165. [SOLVED:] Excel coordinate projection - distance and bearing (5 replies)
  166. Identifying file type in excel (2 replies)
  167. Values are not copying over as entered on one sheet to another. (4 replies)
  168. Convert from Text to Columns Doesn't Work if Source is Modified (7 replies)
  169. Help with copy paste code (3 replies)
  170. Sleeper: Adding a certain number of cells between sets of data based on a comparison (3 replies)
  171. If-statement with relative values (11 replies)
  172. Can you customise the results from comparing two worksheets? (1 replies)
  173. [SOLVED:] Unwanted selection change (2 replies)
  174. [SOLVED:] Combining Static Series and Dynamic Series in a Dynamic Chart Issues (7 replies)
  175. Date Variable Showing 12:00:00 AM, Why? (4 replies)
  176. [SOLVED:] Ctrl-C selection in memory - how work with it by VBA Excel code? (4 replies)
  177. Copy function from workbook to another in VBA (2 replies)
  178. [SOLVED:] Write an IF statement relating to 2 different worksheets (20 replies)
  179. [SOLVED:] How to write VBA code to auto insert the last row occupied into Master Sheet (22 replies)
  180. Last saved issue (1 replies)
  181. Every time i run the macro it has different values, need help please (3 replies)
  182. Accessing Hidden Sheets Via Hyperlink (1 replies)
  183. Custom XLAM ribbon question (2 replies)
  184. Custom Option Buttons VBA (9 replies)
  185. [SOLVED:] Deleting empty rows (6 replies)
  186. Complex Macros needed to Make and Save Workbooks (10 replies)
  187. Challenge to get huge Excel Workbook running online (8 replies)
  188. Copy row based on criteria to existing sheets & constant update (3 replies)
  189. Issues with pagination in a worksheet generated by a macro (1 replies)
  190. Help to create a file from the inputs in the input sheet (3 replies)
  191. Creating Folders from Excel into Outlook (attachment) (1 replies)
  192. [SOLVED:] Count all files with specific extension (16 replies)
  193. Copy from one workbook to another without opening the second workbook (3 replies)
  194. [SOLVED:] Code for copy and pasting in excel (18 replies)
  195. [SOLVED:] Help with making code run faster (16 replies)
  196. [SOLVED:] VBA formula with variables (6 replies)
  197. [SOLVED:] Separate Regions (1 replies)
  198. Wildcard with match index (10 replies)
  199. Vba far loop too slow (6 replies)
  200. [SOLVED:] How to call DblClick sub from code VBA Excel (2 replies)
  201. Application.EnableEvents (20 replies)
  202. [SOLVED:] VBA Count IF help (5 replies)
  203. [SOLVED:] Put Country Codes in Excel For SharePoint (37 replies)
  204. [SOLVED:] VBA to Auto Number (2 replies)
  205. Need help exporting row data in excel to their own individual powerpoint slide. (1 replies)
  206. [SOLVED:] VBA Auto Filter + Paste to New Sheets + Autofill (2 replies)
  207. [SOLVED:] Return Row - Column for cell addresses (24 replies)
  208. [SOLVED:] Copy ThisWorkbook Code with Copy Sheet to New Book (6 replies)
  209. [SOLVED:] Variable Vlookup vba (8 replies)
  210. [SOLVED:] Get last row in range that contains formulas (12 replies)
  211. [SOLVED:] Break all external links (7 replies)
  212. [SOLVED:] Use formula to grab data from sheets (11 replies)
  213. Cell evaluation (2 replies)
  214. Excel Billing Invoice with VBA and mdb (1 replies)
  215. Comparing Dates (12 replies)
  216. Excel help required: How to insert excel remarks in scanned pdf file. (1 replies)
  217. [SOLVED:] Move some cells to next records and delete some rows (2 replies)
  218. [SOLVED:] MSGBOX VBOKONY, Cancel exits sub. (7 replies)
  219. [SOLVED:] Need help restructuring macro to do opposite and adding to macro, please! (5 replies)
  220. [SOLVED:] Check if cell has custom format using UDF (14 replies)
  221. [SOLVED:] Sort each subset of n rows by specific column ranking (3 replies)
  222. [SOLVED:] Importing data in consecutive rows (3 replies)
  223. [SOLVED:] Macro to follow hyperlinks when a certain criteria is met (4 replies)
  224. Extract string from text file (1 replies)
  225. Select Folder and Break External Links of All Files (1 replies)
  226. INDEX and MATCH query (8 replies)
  227. [SOLVED:] Filter on prior date (1 replies)
  228. [SOLVED:] How to use Array (9 replies)
  229. [SOLVED:] activate opened workbook (2 replies)
  230. List content of zip files (8 replies)
  231. How to get the numbers from the data (1 replies)
  232. Strange character (format) when merging 2 utf-8 files (3 replies)
  233. [SOLVED:] Count Find Array (14 replies)
  234. [SOLVED:] VBA, Excel 2010, Need to change headers in .csv files (12 replies)
  235. [SOLVED:] How to tell a Macro to do nothing for a set period of time? (3 replies)
  236. Program takes long to load (7 replies)
  237. [SOLVED:] Embed an image and range to outlook using excel vb (1 replies)
  238. [SOLVED:] VBA find replace object error (10 replies)
  239. Transfer data from adjacent cells to non-adjacent cells (7 replies)
  240. Updating data in a closed workbook. (12 replies)
  241. [SOLVED:] Combine Formula (23 replies)
  242. [SOLVED:] Variable changes its cases. (3 replies)
  243. [SOLVED:] How to arrange the order (10 replies)
  244. adding additional calculations (8 replies)
  245. Google Search VBA and Pull Data (0 replies)
  246. [SOLVED:] Conditional format macro (4 replies)
  247. [SOLVED:] NAME? error with predefined function which previously was working (4 replies)
  248. Excel Small Function Formula (Not using VBA Code) (0 replies)
  249. [SOLVED:] Extract two fields from text files (6 replies)
  250. Logic Program for VBA.. may be hard (15 replies)