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. [SOLVED:] Formula to return two multiple lookups in one cell ? (2 replies)
  2. [SOLVED:] HELP NEED TO MAKE CODE GENERIC LOOPING THROUGH CELLS TO IMPORT DATA (5 replies)
  3. VBA help in creating a dependent and source views (2 replies)
  4. Can't calculate long recursion (5 replies)
  5. VBA to check for PR SAP attachment (0 replies)
  6. [SOLVED:] All VBA Worksheet_Change Events Not Working (6 replies)
  7. [SOLVED:] Overflow Error when using Format() (2 replies)
  8. Is there a way to write this "for" loop? (2 replies)
  9. Bold and color numbers in specific format with special character (2 replies)
  10. [SOLVED:] Dynamically passing value to Sub using buttons (1 replies)
  11. [SOLVED:] Userform TextBox Loop Syntax (3 replies)
  12. [SOLVED:] Modify a macro to remove blanks from a worksheet (14 replies)
  13. Scanning Input not considered a Change (3 replies)
  14. extract data from Excel Columns to an Output sheet (2 replies)
  15. [SOLVED:] Using a string in names of dublicates (3 replies)
  16. [SOLVED:] Data Comparison (3 replies)
  17. Conditionally put - sign (0 replies)
  18. VBA Merging duplicate -cells issue (2 replies)
  19. Summarized data based on timetable sequence (0 replies)
  20. [SOLVED:] Edit Excel Links in PPT Using VBA and Early Binding (6 replies)
  21. Several questions about the collection. (3 replies)
  22. Employee number according to timetable sequence (0 replies)
  23. I am having an issue with macro assigned shapes (0 replies)
  24. VBA: Copy and Paste if criteria met (8 replies)
  25. [SOLVED:] Vba to calculate the number of days from today to the 1st of the month. (2 replies)
  26. [SOLVED:] Loop sheets that begin with given chars (1 replies)
  27. Extra Screen for Laptop usinig Android Phone (4 replies)
  28. How to get msgbox output with spaces between every three numbers? (2 replies)
  29. [SOLVED:] Excel Freezing Up When I Run Sub (5 replies)
  30. Double data and runtime error when running macro (7 replies)
  31. Possible to clean up my formula (6 replies)
  32. Run time 424 object required (4 replies)
  33. [SOLVED:] Multiple drop down selections in the same cell (1 replies)
  34. [SOLVED:] Turning 100 Data points into 6000 using VBA HELP! (23 replies)
  35. Add current selection to filter in VBA (0 replies)
  36. [SOLVED:] “Application.Speech.Speak”, to announce the greetings. (5 replies)
  37. extract data from a row with a lot of data (6 replies)
  38. Copy paste the data by vba (5 replies)
  39. [SOLVED:] Need advice on VBA Conditional formatting Formula : Run-time error '5' (1 replies)
  40. Select and Edit certain type of ChartObject in VBA (3 replies)
  41. [SOLVED:] Perform calculations on a field that has already been added to pivot table (0 replies)
  42. Copy and paste if cell contains specific text (6 replies)
  43. [SOLVED:] How to create a public array in class module? (15 replies)
  44. [SOLVED:] Is there code similar to "If Not Application.Intersect" & "If Not Intersect(Target.. (8 replies)
  45. Send reminder emails based on date in column, after finding last email correspondance (15 replies)
  46. [SOLVED:] Progress bar...% (3 replies)
  47. Lock Cell/Cell Range based on Cell value (12 replies)
  48. [SOLVED:] Suggestions regarding speed and efficiency (21 replies)
  49. Run-time error code "438" (11 replies)
  50. [SOLVED:] Filter and Sort with Multiple Headers (8 replies)
  51. [SOLVED:] Attach event to multiple ComboBoxes (3 replies)
  52. [SOLVED:] Working with Dates in VBA (5 replies)
  53. Cant count integer partitions by recursive function. (1 replies)
  54. [SOLVED:] Comparison isn't finding as true; but values sent to MsgBox show it should be.... (1 replies)
  55. Transfer of data between two workbooks using name of worksheet? (0 replies)
  56. [SOLVED:] Trying to set color to a range (2 replies)
  57. VBA vlookup in file a with data from file b (0 replies)
  58. VBA to copy specific columns from word table to Excel (0 replies)
  59. Arrange Data Properly (6 replies)
  60. Excel Data Files (2 replies)
  61. Need to select a workbook which changes names everyday (1 replies)
  62. Search, find, hide columns - VBA (2 replies)
  63. [SOLVED:] Cross Referencing Filenames Using an ID and "Charting" Results Across Columns (1 replies)
  64. VBA Code Required to autosize image - I can pay via. Paypal or other method... (1 replies)
  65. Searchable dropdown list (data from two columns) (2 replies)
  66. [SOLVED:] Copy value of active cell to another worksheet (3 replies)
  67. INSERTING MULTIPLE PICTURES THAT MEET CRITERIA (18 replies)
  68. How to hide textbox in userform by option button? (3 replies)
  69. RUNTIME 438 ERROR WHEN CLICKING IMAGE (1 replies)
  70. Dynamically adding and positioning check boxes to wrap inside frame (1 replies)
  71. VBA Help: Email attachment via folder or direct-link (3 replies)
  72. '1004': Application-defined or object defined error (VBA) (3 replies)
  73. VBA - Textfile Skip line Help in Looping (1 replies)
  74. [SOLVED:] Merge specific word files from excel VBA (4 replies)
  75. [SOLVED:] Adding links of files, seperating filenames with Split() - Error: Object variable or (7 replies)
  76. [SOLVED:] Trying to code this VBA macro but it's beyond my knowledge (9 replies)
  77. Bug? with activeX combobox (7 replies)
  78. VBA sorting error (8 replies)
  79. Pass variable from module to the userform. (6 replies)
  80. [SOLVED:] conditional month() (2 replies)
  81. Get COM Addin list of functions (0 replies)
  82. [SOLVED:] need help with filtered table (7 replies)
  83. VBA - loop help in Seperating the data...... (8 replies)
  84. VBA - Select Case Error (6 replies)
  85. Multi Find and Replace VBA Script Macro Not Working (16 replies)
  86. [SOLVED:] Event Before refresh pivot cache (8 replies)
  87. Object required on .Find (2 replies)
  88. trying to count total rows based on group of values in another column (3 replies)
  89. [SOLVED:] Automated Login Results in URL Change After More Than One Use (0 replies)
  90. [SOLVED:] Help With VBA Document Counter (2 replies)
  91. VBA code (macros) understanding (3 replies)
  92. Can't start edit or remove macros (1 replies)
  93. [SOLVED:] HOW TO ADD 2D NAMED RANGES WITH SAME DIMENSIONS? (4 replies)
  94. [SOLVED:] Pass the range from userform to sub of module (2 replies)
  95. [SOLVED:] HELP!! GETTING MULTIPLE VARIANTS INTO ONE RANGE!!!! (1 replies)
  96. RUNTIME 13: TYPE MISMATCH ERROR (2 replies)
  97. Inset formula into last cell of table column (3 replies)
  98. [SOLVED:] HARD:MADE A FUNCTION - HOW DO I LOOP THAT FUNCTION IN MY SUBROUTINE???? (8 replies)
  99. VBA loop copy & paste range to same worksheet name of another workbook (1 replies)
  100. VLookup VBA Code & Elseif troubles (13 replies)
  101. Ranking with conditions (2 replies)
  102. [SOLVED:] Copy/Paste Loop is only transferring rows 1,2, and 4, but not row 3? (6 replies)
  103. Copying spreadsheet into 120 sub-folders (3 replies)
  104. How to Merge Two Worksheet_Change Codes (6 replies)
  105. VBA Help - Run-time error '-2147417848 (80010108)': Method 'Value' of object 'Range' (2 replies)
  106. [SOLVED:] Using an array to transfer file names into workbook with multiple sheets (8 replies)
  107. Select case using a collection of values (1 replies)
  108. VBA - Seperating Column data based on Criteria..... (5 replies)
  109. Insert Two Blank Row if Condition Met (5 replies)
  110. [SOLVED:] FINDING LAST ROW IN COLUMN NOT WORKING (4 replies)
  111. Replace multiple repeated texts in multiple word documents from excel with excel vba (2 replies)
  112. Pull data from overall sheet to new sheet based on criteria (8 replies)
  113. Run-Time Error 13 (4 replies)
  114. Modifying COMport Code (3 replies)
  115. VBA - Unhiding a Worksheet and setting Sheet1 as current view (1 replies)
  116. Transferring Data from Multipage Userform to Separate, Subsequent Rows in Excel (14 replies)
  117. VBA - Merging and Bordering of cells if condition met.... (6 replies)
  118. [SOLVED:] Protected cells - want to enable comments (4 replies)
  119. Copying an active range (4 replies)
  120. [SOLVED:] Sending Email Drafts from secondary outlook email account (1 replies)
  121. VBA from access to excel (1 replies)
  122. XLSX-XML Conversion through Macro (0 replies)
  123. Add rows to existing table (0 replies)
  124. Show Sheets which have links to other sheets (0 replies)
  125. XLSX to XML Macro (0 replies)
  126. Force Excel Macro With Some Sheets Remain Hidden (3 replies)
  127. Excel Macro Copying Information From Many Folders (9 replies)
  128. [SOLVED:] Saving Current Worksheet as Text in Current Directory (20 replies)
  129. Listing Conditional Formatting on Separate Sheet or Workbook (1 replies)
  130. Help Creating Macro for Selection, copying ranges (2 replies)
  131. Converting countif to frequency (2 replies)
  132. Restructuring of data without a standardized format (1 replies)
  133. [SOLVED:] RUN TIME ERROR FOR A VARIANT! DONT KNOW MY MISTAKE HELP (6 replies)
  134. Number of days inventory held (2 replies)
  135. Hide / Unhide Rows and Columns based on selected cell value (drop-down) (9 replies)
  136. [SOLVED:] ADDING A SHEET USING VBA BUT GETTING ERROR (2 replies)
  137. Update data from one sheet to another sheet with header mapping (2 replies)
  138. [SOLVED:] HELP GETTING DIMENSIONS OF A VARIANT ARRAY (2 replies)
  139. Excel VBA UserForm not working. Need help pls! (4 replies)
  140. VBA to copy paste data in Master File........and adjust row as per data size.. (9 replies)
  141. [SOLVED:] Find string in multiple rows (17 replies)
  142. Search for Numbers (2 replies)
  143. [SOLVED:] Source and target cells specification in a macro (2 replies)
  144. match cells based on a string provided (2 replies)
  145. Macros to highlight three or more consecutive numbers entered in a set row (1 replies)
  146. [SOLVED:] Event Handler for external DLL events not triggering (8 replies)
  147. Need help writng macro to insert Spanish accented characters into a line of text (6 replies)
  148. [SOLVED:] Log to generate tracking numbers (4 replies)
  149. MULTIPLE FIND AND REPLACE FROM USERFORM INPUT (3 replies)
  150. Need to delete a workbook (34 replies)
  151. Heading Row Returns NULL (11 replies)
  152. insert sum or =+ formula based on value in another column for variable rows (1 replies)
  153. [SOLVED:] loop thru every sheet and filter out a specific name and create a new sheet (9 replies)
  154. Listbox.Column (2 replies)
  155. [SOLVED:] VBA to provide search data from text box value (15 replies)
  156. insert sum formulas based on worksheet data (8 replies)
  157. [SOLVED:] Extract Matching Cell Values in Two Columns and Paste in New Columns (22 replies)
  158. [SOLVED:] DATE VALIDATION IN TEXTBOX (2 replies)
  159. Find specific cell and insert page break - repeat till end of sheet (2 replies)
  160. [SOLVED:] automating calculations and adding to existing table (7 replies)
  161. [SOLVED:] Match code is not returning the desired field (3 replies)
  162. How do I check values on 4 columns simultaneously on two different workbook? (0 replies)
  163. Extract data from string to new sheet (2 replies)
  164. VB Code Help " Error Variable not Defined " and Run time Error "438"" (2 replies)
  165. Map cells based on text (3 replies)
  166. run time error '9' subscript out of range (5 replies)
  167. [SOLVED:] URGENT! GETTING DATA FROM ONE WORKBOOK TO ANOTHER USING VARIANT (2 replies)
  168. [SOLVED:] TABLE OF CONTENTS NOT USING TABS (6 replies)
  169. Based on Cell value, from next cell has to move to 2nd row (4 replies)
  170. [SOLVED:] RUNTIME 13: TYPE MISMATCH ERROR (3 replies)
  171. Filter and sum the column values (4 replies)
  172. List (Sort by) Birthday Anniversaries in .txt file (1 replies)
  173. Move to right column after return when I press enter (3 replies)
  174. vba import data from another workbook with auto filtered of specified name (7 replies)
  175. [SOLVED:] Calling a function (4 replies)
  176. Combining three different tables in a chart (0 replies)
  177. Sleeper: Can anyone help me with this code ? (14 replies)
  178. Need Help to modify this Macro (5 replies)
  179. Sleeper: Create table array for Vlookup with match and count to next blank row (1 replies)
  180. Delete columns in spreadsheet based on list of column names specified in listed range (7 replies)
  181. [SOLVED:] Improving Cell Change Macro (2 replies)
  182. [SOLVED:] i want VBA to display values greater than or equal to the given number (9 replies)
  183. [SOLVED:] Macro For Re-Coding Variables after a Specified Cut-off (2 replies)
  184. Charts and forms freeze after VBA macro execution (5 replies)
  185. [SOLVED:] Run-Time error '91' Object variable or With variable not set (5 replies)
  186. [SOLVED:] Excel macro, combine cells based on same merged row i different column (2 replies)
  187. [SOLVED:] How to use an Array instead of a Loop to clear contents of blank cells? - Speed Issue (7 replies)
  188. Excel Userform with Checkbox value, How to return to Checkbox value in Winword (3 replies)
  189. vba excel dir loosing file name in looping (4 replies)
  190. Slicer changing chart styles (1 replies)
  191. Sorting table with Duplicates (8 replies)
  192. [SOLVED:] Split text in different cells after each Dash (9 replies)
  193. Speed up the loop process (Copy paste Value) (5 replies)
  194. Trying to replicate MAX function in SAS (1 replies)
  195. [SOLVED:] if find specify word copy all the row to anther sheet (4 replies)
  196. [SOLVED:] In merged file, re-name sheets to include part of workbook name that they came from? (2 replies)
  197. Search multiple keywords to filter column (17 replies)
  198. Double run problem (3 replies)
  199. [SOLVED:] For Loop goes thru all sheets but doesn't execute code? (3 replies)
  200. [SOLVED:] VBA Copy & Paste Based on a Condition in Another Column (5 replies)
  201. Sorting arrays (2 replies)
  202. Nested if statement, loop or something else (4 replies)
  203. vlookup separate workbooks and sum the results (8 replies)
  204. VBA Userform match issue (2 replies)
  205. [SOLVED:] Execute Macro on Cell Change (5 replies)
  206. Calendar userform ( datepicker ) (5 replies)
  207. [SOLVED:] Stuck trying to figure out this macro (8 replies)
  208. [SOLVED:] Using End(xlToLeft) in Sheets with Tables (3 replies)
  209. Multiple conditional formatting to the same range (2 replies)
  210. Assistance resolving Runtime 1004 error (5 replies)
  211. Creating a VBA code for a cell with a dropdown list to allow multiple selections (2 replies)
  212. Chart series don't extend (3 replies)
  213. Add and Sort (8 replies)
  214. FILTER EXCEL PER COUNTRY & CREATE MULTIPLE WORKBOOKS (9 replies)
  215. Protect radio buttons on a sheet with VBA (5 replies)
  216. Write selected items on form to range (6 replies)
  217. "Run-Time Error 91" trying to run Login Code (1 replies)
  218. Rank for Top 5 after two criteria match excel formula (10 replies)
  219. Hiding columns based on cell values in column (3 replies)
  220. HELP! - Print All Options (Loop) On A Drop Down List after Refreshing Excel Add In (0 replies)
  221. Hiding and then Unhiding Rows on Excel sheet based on if a checkbox is unchecked? (1 replies)
  222. [SOLVED:] Help needed resolving Compile Error: Expected End Sub issue (4 replies)
  223. [SOLVED:] Help to build a data collecti searching from many Workbooks (16 replies)
  224. Need help with INDIRECT formula (0 replies)
  225. VBA:Problem with DCOUNT + Problem while copying data from range to listbox (0 replies)
  226. Looking for a free software/tool to perform analysis on excel data.... (1 replies)
  227. Change Color If Selected Cells Edited (5 replies)
  228. Table (12 replies)
  229. Worksheet_Change ( No Responese ) (3 replies)
  230. Format Column Labels (2 replies)
  231. Linking multiple sheet columns into one master sheet column (1 replies)
  232. VBA macro for dependents (15 replies)
  233. Simple and Basic VBA question. (4 replies)
  234. VBA adding numbers up to a certain range (7 replies)
  235. Code to detect duplicate cells in Excel (3 replies)
  236. VBA to save excel file (downloaded from server) to specific folder (0 replies)
  237. VBA Copy Sheets to New Workbook (6 replies)
  238. [SOLVED:] Numbering Duplicates Consecutively (3 replies)
  239. Excel automation error on VBA Code modification using VBA (0 replies)
  240. Activate sheet which contains date (1 replies)
  241. [SOLVED:] Form selection (10 replies)
  242. [SOLVED:] When stepping through, code doesn't stop after this "paste" command...why? (24 replies)
  243. Condition should applied if columns total value is not match (3 replies)
  244. VBscript for data matching (19 replies)
  245. convert gregorian date (3 replies)
  246. Copying real time data in excel using VBA (2 replies)
  247. [SOLVED:] using conditional format to change font if column has a number greater than or equal (8 replies)
  248. [SLEEPER:] MonthView DatePicker default to current date (4 replies)
  249. Mails from excel (4 replies)
  250. [SOLVED:] Template (6 replies)