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. Overflow error. (4 replies)
  2. Not able to design pivot based on requirement (1 replies)
  3. [SOLVED:] "mypath" causing a problem in a network drive (11 replies)
  4. How do I delete something based on headers? (1 replies)
  5. Conditional Min and max in a hour format (0 replies)
  6. [SOLVED:] Creating a combined formula with erow macros (2 replies)
  7. [SOLVED:] if find none numeric data on cloumn A just clean the column A (2 replies)
  8. Creating a macro for next empty row (2 replies)
  9. [SOLVED:] if cell start with 0 clean the cell from A to Z (6 replies)
  10. Multiple Goal Seek Code - Only Solves the First Row (2 replies)
  11. Redim Preserve array problem (3 replies)
  12. VBA Macro stops working after opening the VB Editor (1 replies)
  13. Normalise Pivot Table (4 replies)
  14. [SOLVED:] Copy row cells to powerpoint (14 replies)
  15. Evaluate content control title and move to correct column (9 replies)
  16. Create Output File (1 replies)
  17. Categories List (9 replies)
  18. [SOLVED:] Do While Loop will not execute (0 replies)
  19. [SOLVED:] if does not find matched value data with data on cell delete the row (7 replies)
  20. [SOLVED:] Subscript out of range Multidimensional Array (11 replies)
  21. Macro speed (1 replies)
  22. [SOLVED:] Formula be replaced with macro (4 replies)
  23. [SOLVED:] VBA SUM question (13 replies)
  24. [SOLVED:] Delete Row if Cell Contains More Than 10 Characters (6 replies)
  25. [SOLVED:] Request to Modify Macro (4 replies)
  26. Using a drop-list to categorize and insert cells (4 replies)
  27. [SOLVED:] Extract 1st 4 letters of last name..ideas? (11 replies)
  28. List view for VBA Excel Macro (1 replies)
  29. [SOLVED:] Look/Match specific text based on similar column criteria (7 replies)
  30. [SOLVED:] Name Splitter Help (6 replies)
  31. VBA Conditional Formatting Not Working Properly (5 replies)
  32. Multi Columns, Multi Listbox Form (4 replies)
  33. Worksheet_change event executed on a wrong sheet? (31 replies)
  34. [SOLVED:] Check Label for certain text (2 replies)
  35. A macro that adds up prices and sorts them in categories (6 replies)
  36. Excel freezes after running Macro (1 replies)
  37. macro opens the desired file and paste the information in a selected from me sheet (14 replies)
  38. [SOLVED:] Running a script from a blank workbook and apply to specific files in specific folder (4 replies)
  39. [SOLVED:] Add to Column Next to Selection (3 replies)
  40. macro to delete row if cell is empty (1 replies)
  41. [SOLVED:] Variable coping (3 replies)
  42. [SOLVED:] Search a string to contains.... (5 replies)
  43. macro to delete data based on time (1 replies)
  44. How to delete rows if a cell is red? (2 replies)
  45. [SOLVED:] Overwrite write reserved file with updated copy (same name; also write reserved) (1 replies)
  46. Pull Data From One Worksheet To Another (2 replies)
  47. How to find worksheet that contains an error (with 100+ worksheets in it) (2 replies)
  48. [SOLVED:] First unhidden column (7 replies)
  49. [SOLVED:] Removing last six characters from a string (17 replies)
  50. Password Protected code needs editing Employee no longer with Company (1 replies)
  51. [SOLVED:] Delete a known named range from a known cell (5 replies)
  52. [SOLVED:] Pull Data from Sheet3 to Sheet1 (4 replies)
  53. [SOLVED:] Before_Close Sub (3 replies)
  54. Matching First Name & Name Text Boxes on Form with Corresponding Columns TROUBLESHOOT (0 replies)
  55. Listbox Problem (1 replies)
  56. VBA code error (3 replies)
  57. VBA code edit to populate to end of data (2 replies)
  58. VBA User form and Coding help (1 replies)
  59. Macro to find a cell containing text, select range offset, cut and paste to lower row (2 replies)
  60. Formulas help (4 replies)
  61. Code VBA checkbox and optionbox (2 replies)
  62. select the second row of the result of advanced filter. (8 replies)
  63. [SOLVED:] design ideas for UF and multiple users (6 replies)
  64. [SOLVED:] from a string, how to get the equivalent constant value? (7 replies)
  65. [SOLVED:] How to jump next to column (9 replies)
  66. [SOLVED:] UF validation based on date (2 replies)
  67. trying to copy a cell to a different cell automatically (1 replies)
  68. [SOLVED:] Reverse columns and Rows (5 replies)
  69. Copying table from Excel, and saving error (0 replies)
  70. ListBox.ListCount limit in Excel 2010, and/or previous years... (3 replies)
  71. File attached (1 replies)
  72. Extracting 4 digit number from combobox, looking that up in a worksheet column etc. (3 replies)
  73. Sleeper: Macro to delete rows in result of advanced filter. (5 replies)
  74. [SOLVED:] HOw to run a macro automaticcaly when open a workbook (8 replies)
  75. HELP- Vba to copy Word to Excel (2 replies)
  76. selecting specific rows (19 replies)
  77. [SOLVED:] On Error GoTo ??? (8 replies)
  78. [SOLVED:] Trying to solve count (22 replies)
  79. [SOLVED:] VBA Automatic Rolling Column Headings (4 replies)
  80. VBA Excel Help Selecting Multiple Pages (1 replies)
  81. What exactly is VBA? (7 replies)
  82. [SOLVED:] Creating excel file using VBA - File name to contain the current date and time (5 replies)
  83. [SOLVED:] VLOOKUP only if #N/A found (5 replies)
  84. Problem sharing program with another computer (6 replies)
  85. How to rename cells (1 replies)
  86. [SOLVED:] Grouping not working properly using slicer for pivot data (1 replies)
  87. Help Subtract value and update cell in another workbook (6 replies)
  88. How do I disable auto text to columns with VBA? (2 replies)
  89. Cell Values getting truncated when converting an excel 2010 file to dbf 5 (1 replies)
  90. [SOLVED:] POP UP VBA!! (4 replies)
  91. Reply on open Outlook item by Excel VBA (1 replies)
  92. attachment download from outlook (2 replies)
  93. Break each external links in a cell and replace with the current value of each link (4 replies)
  94. Help with: Prefill cells with command line switches from a browser (1 replies)
  95. [SOLVED:] What is happening with this function (7 replies)
  96. Get the position of the data in the table (3 replies)
  97. [SOLVED:] Searching for one of many text strings in a cell based on a text string lookup table (7 replies)
  98. Help with creation of Word Document from Excel (16 replies)
  99. [SOLVED:] Checking if cell value is within +-15 from next one. (3 replies)
  100. Help needed to track user changes on a worksheet in different columns for each user (3 replies)
  101. PivotTable: CD count not track count. (5 replies)
  102. [SOLVED:] Copy PDF (6 replies)
  103. [SOLVED:] help with cell values -if same then mark as "duplicate" (19 replies)
  104. combine 2 macro code in to one so that i can use it in single sheet....its urgentttt (3 replies)
  105. How to Trigger an event (9 replies)
  106. Not VBA, but a IF & AND problem (3 replies)
  107. Call Outlook Macro form Excel (1 replies)
  108. Script isn't copying all values in the criteria correctly and need help displaying (21 replies)
  109. How to create multiple buttons in excel linking to each row (1 replies)
  110. VBA - phrase search and filtering (1 replies)
  111. AutoSum >40 (6 replies)
  112. Modifying This Macro Slightly Please (1 replies)
  113. Display all matching values in one comma separated cell (2 replies)
  114. CountIFs based on Data Validation boxes (1 replies)
  115. Select or Filte Row Based on Single Cell Colour? (6 replies)
  116. [SOLVED:] VBA Create Sheets & Copy Data (27 replies)
  117. [SOLVED:] Return Multiple Values based on Lookup Value (3 replies)
  118. Search Folder looking for File Tags (2 replies)
  119. [SOLVED:] Saving Symbols as a variable (4 replies)
  120. How to copy past only the cell marked in red (45 replies)
  121. VBA for multi-colored pivot chart bars? (2 replies)
  122. [SOLVED:] Populate form label with cell value (3 replies)
  123. [SOLVED:] Row count +1 on data import (4 replies)
  124. [SOLVED:] Look for #N/A sign then copy paste (2 replies)
  125. [SOLVED:] Display search terms in another cell (14 replies)
  126. Need help with VBA find match (2 replies)
  127. Worksheetfunction.countifs not working (1 replies)
  128. MOving and Sorting Data Marco from master sheet (6 replies)
  129. Search Excel file (3 replies)
  130. Copy fields from active task to active worksheet (3 replies)
  131. Categorising data by time (7 replies)
  132. macro causes Excel to 'crash' (6 replies)
  133. Sort by second column in listbox (4 replies)
  134. Send Email Via Excel and store a copy in Excel (7 replies)
  135. Rows to Column (Transpose) with one Heading (2 replies)
  136. macro code working for 1 file but not when trying to apply for the range of files (7 replies)
  137. [SOLVED:] VBA Create Sheets and Add Formula To Each Cell In Range (3 replies)
  138. Perdictive Pattern matching algorithm (6 replies)
  139. VBA problem with alternative to index match formula (4 replies)
  140. Grouping with Regular expressions in EXCEL 2010 VBA (5 replies)
  141. [SOLVED:] Need to combined 87 xlsx worksheets into 1 & append source filename to each record (13 replies)
  142. VBA code for distributing available stock (4 replies)
  143. [SOLVED:] Add value to existing named range via inout box (1 replies)
  144. Call macro by typing "Enter" (7 replies)
  145. Return combinations of the most popular choices (25 replies)
  146. [SOLVED:] excel VBA - Listbox only populating one result! (3 replies)
  147. [SOLVED:] Detecting "Protected View" (3 replies)
  148. VBA code to sort a sheet (3 replies)
  149. [SOLVED:] Load a Multidimensional array (6 replies)
  150. select and replace cell (3 replies)
  151. combo box error (4 replies)
  152. How to Arrange telephone directory ocr image in excel, in table form (3 replies)
  153. Formula for a table which does not exist (7 replies)
  154. OPEN: Excel Macro Save As with a new file name (5 replies)
  155. [SOLVED:] Supply one password to unlock all code in workbook (9 replies)
  156. [SOLVED:] Excel Save Error (12 replies)
  157. [SOLVED:] Selecting and deleting rows based on criteria (62 replies)
  158. [SOLVED:] #REF! (2 replies)
  159. Print sheet after update shapes/images (1 replies)
  160. Arranging data datewise (3 replies)
  161. Screen capture (print screen) to new Excel workbook or Word (11 replies)
  162. [SOLVED:] Trying to check if a checkbox is checked (3 replies)
  163. [SOLVED:] Objects and invalid use of property (2 replies)
  164. Importing Images Into Excel 2013 (8 replies)
  165. [SOLVED:] VBA: Mixing Relative & Absolute References (6 replies)
  166. SAS add in Advanced VBA question (6 replies)
  167. [SOLVED:] create a new checkbox and assign its ID? (2 replies)
  168. Copying part of a Text String of different lengths (16 replies)
  169. add individual rows to outlook calender with button (5 replies)
  170. [SOLVED:] Method Intersect Error (3 replies)
  171. Macro has working very slowly; How to speed up this macro. (2 replies)
  172. [SOLVED:] Macro to Consolidate multiple workbooks into new workbook based on criteria (3 replies)
  173. [SOLVED:] Deleting positive values in 45,000 row database (9 replies)
  174. Finding First Value that Falls in a Range Across Multiple Columns (4 replies)
  175. Changing the value of a pivot item (3 replies)
  176. [SOLVED:] Change 'Entire Row delete' to 'cells in columns A-G' (3 replies)
  177. Based on Condition Merge and CountIF & Apply (0 replies)
  178. [SOLVED:] Loop through a dynamic range and apply code in a seperate sheet (5 replies)
  179. Macro to copy data from different cells and paste in new sheet (5 replies)
  180. Text populate containing more records based on date (6 replies)
  181. [SOLVED:] One sub Button Two Macros (6 replies)
  182. how do I work with objects (pass objects to objects?) (5 replies)
  183. Creating New File Off Template and then some EXCEL MACROS (3 replies)
  184. [SOLVED:] Need help to calculate average of those cells between two blank cells (4 replies)
  185. 400 Error (1 replies)
  186. [SOLVED:] I am Having a challenge with ThisWorkbook.Close (29 replies)
  187. xml download "argument not optional" (2 replies)
  188. [SOLVED:] Cannot get xlSaveDialogAs or GetSaveAsFilename to work as required (15 replies)
  189. compare 2 sheet and all column if find duplicate will delete on sheet 2 (2 replies)
  190. [SOLVED:] When running a macro, Excel suddenly stops responding (5 replies)
  191. [SOLVED:] if find the matched data in another work workbook copy the complete row (1 replies)
  192. [SOLVED:] clean a row if it doesn't start with a number except _ (3 replies)
  193. [SOLVED:] When does a Workbook become a member of the WorkBooks Collection? (11 replies)
  194. [SOLVED:] Convert Cell Value in a range of cells (12 replies)
  195. Sleeper: Look up & return (7 replies)
  196. [SOLVED:] Linking/merging two worksheet_change functions (4 replies)
  197. [SOLVED:] Create a Loop - Help! (9 replies)
  198. [SOLVED:] Referencing a Userform in a module (4 replies)
  199. Excel CalCulation Issue (7 replies)
  200. Ribbon Change which works as an ADD-IN (1 replies)
  201. [SOLVED:] Conditional Compilation Quick Question (Well, at least hopefully) (17 replies)
  202. Find a unique value with a condition across 2 lists, add it to the less complete list (1 replies)
  203. Function isn't working on button click (10 replies)
  204. [SOLVED:] help needed to adjust a macro (4 replies)
  205. Who has ever met this? (5 replies)
  206. [SOLVED:] Find Method w/ VALUE error (19 replies)
  207. Input Box is popping too much. (2 replies)
  208. [SOLVED:] Get an automatic sequence in a formula (2 replies)
  209. VBA Conditional formatting if one cell equals another cell in value (3 replies)
  210. Requesting a macro for printing an Excel sheet automatically as PDF on daily basis. (1 replies)
  211. New to VBA. Getting a Compile Error. Please help. (4 replies)
  212. [SOLVED:] Problem Word Wrapping VBE Code (3 replies)
  213. Unlocking all Excel (2007) cells by default (2 replies)
  214. Automatically generating custom timeline on separate tab (Excel 2010) (6 replies)
  215. [SOLVED:] Moving automatically generated page breaks (2 replies)
  216. [SOLVED:] List all Open Window titles in column A (4 replies)
  217. How to use vlookup and countif together in one formula? (9 replies)
  218. extract data from txt file (9 replies)
  219. HELP - Copy Variable Sheet Range from multiple sheets to Summary Sheet (2 replies)
  220. [SOLVED:] Strange behaviour ListBox.Selected(index). (31 replies)
  221. If no error, write the word "ok" to a cell? (3 replies)
  222. [SOLVED:] Use Contents of ComboBox in Vlookup and Save to Data Table (4 replies)
  223. VBA Code to change Color in range of Cells. (3 replies)
  224. Best Tutorials / Courses / Reading to Master Excel (3 replies)
  225. Web Query refresh issue (0 replies)
  226. Compare 2 sheet and paste the resault on sheet3 (6 replies)
  227. [SOLVED:] hrefs from an ordered list <ol> on a webpage in Internet Explorer (3 replies)
  228. [SOLVED:] Lookup value in table with two criteria in rows (10 replies)
  229. Paste data from word table into excel sheet while skipping hidden columns (8 replies)
  230. [SOLVED:] Macro works in Excel 2003 but not in Excel 2007/2010 (2 replies)
  231. Excel VBA with Pivot Table (15 replies)
  232. Why a variable of type Range does not accept Nothing when cutting range of cells? (24 replies)
  233. macro to lookup record on current row and mark completion date to corresponding recor (8 replies)
  234. Import External Data (0 replies)
  235. Free Standing Alternatives to Excel Database (13 replies)
  236. Help with "Array fuctioons" (5 replies)
  237. VBA userform - decimal separator (5 replies)
  238. Unique Rank Question (2 replies)
  239. [SOLVED:] CDATA with values from the active worksheet (2 replies)
  240. [SOLVED:] VBA code works in office 2007 not in office 2010(embeds an attachment in excel) (25 replies)
  241. [SOLVED:] Problem with move more thab 65536 (8 replies)
  242. [SOLVED:] Weird Cell formatting (10 replies)
  243. [SOLVED:] Special Characters (6 replies)
  244. [SOLVED:] Copy to the latest blank row (2 replies)
  245. How to create a formula for a drop down list?? (2 replies)
  246. VBA chess game, userform (19 replies)
  247. [SOLVED:] Intersect - very basic problem (2 replies)
  248. [SOLVED:] VBA IF functions (Help) (10 replies)
  249. [SOLVED:] Change Row Color based on Cell String Match (7 replies)
  250. [SOLVED:] Where To Put Code (12 replies)