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. VBA codes find multiple data using multiple criteria (0 replies)
  2. [SOLVED:] Surveys in Excel! (3 replies)
  3. Right click on the tab: Enable (7 replies)
  4. Open and close multiple workbooks - out of memory (3 replies)
  5. Select Column with VBA and come up 3 rows from bottom (1 replies)
  6. Sleeper: Nested if VBA (16 replies)
  7. Filtering by InputBox date entries and using Autofilter with 3 criteria (3 replies)
  8. Copying data down the column til then "nth" row (2 replies)
  9. How can I speedUP my events based procedure? (6 replies)
  10. [SOLVED:] Change the range to all data range in column (2 replies)
  11. [SOLVED:] go to worksheet depending on Cell value (6 replies)
  12. Dependent (conditional) combo box without creating UserForm (2 replies)
  13. Open file from FTP: "Excel cannot access" error (8 replies)
  14. Count if - cell color index & cell value (range of value) (5 replies)
  15. excel vba to sum textbox values inside a userform frame (7 replies)
  16. #Click in Botton of Web Site whith VBA Excel 2007 (5 replies)
  17. I Need Help Vba Code Disable Key F12 (5 replies)
  18. length of a minimum of a range defined by a variable (1 replies)
  19. External reference help (1 replies)
  20. [SOLVED:] Formula to calculate how many circles fit in a larger circle (2 replies)
  21. inserting a pdf as ole object into word doc from excel (4 replies)
  22. onAction refreshing ribbon macro (3 replies)
  23. using pointer in VBA (4 replies)
  24. Excel and Word (0 replies)
  25. Read Only Files (8 replies)
  26. Save image from computer to worksheet via userform (1 replies)
  27. [SOLVED:] Beginner's attempt at VBA!! Not sure what is going on!! (6 replies)
  28. Macro which copy cells if other cell have specific value (1 replies)
  29. Need macro to check data from workbook to another workbook (5 replies)
  30. dual search criteria over two ranges (ie column) (1 replies)
  31. Need macro to update cell that linked to another program (1 replies)
  32. How to disable Clipboard Section (Cut, Copy, Paste) under Home Tab - Excel 2007 (2 replies)
  33. marco in Excel - loop probably (2 replies)
  34. IE automation - tricky - how to give the script a file path then click OK ? (1 replies)
  35. Application-defined or Object-defined error (4 replies)
  36. Excel 2010 VBA and Speech Recognition... (1 replies)
  37. [SOLVED:] Protect spesific columns from deleting (2 replies)
  38. How to move column?moving is possible,if so will it affect formulas? (15 replies)
  39. VBA to copy worksheet and insert at the end all worksheets (1 replies)
  40. defining a range as a string (3 replies)
  41. Workbook.Open Opens a Dialogue Box Instead of the Specified file (3 replies)
  42. fixe through the win7 date windows and get information by retrun,!!! (1 replies)
  43. Refresh ribbon with code (3 replies)
  44. How to make the values in larger font for the cells with datavalidation? (12 replies)
  45. Variable column reference for a formula (3 replies)
  46. [SOLVED:] searching a range alphabetically (3 replies)
  47. [SOLVED:] *variable* in .AutoFilter Criteria (4 replies)
  48. Adding attachment to the lotus notes via evcel VBA (3 replies)
  49. Kick off macro when a cell is double clicked? (5 replies)
  50. [SOLVED:] initialize all DTPicker same CustomFormat in UserForm (11 replies)
  51. IF function (4 replies)
  52. [SOLVED:] macro in excel (36 replies)
  53. [SOLVED:] Macro that copies data and format Worksheet to worksheet (4 replies)
  54. Insert Image to Specific Page using APPWD (3 replies)
  55. Chart color palette sync issue (9 replies)
  56. Code That Works on PC but not Mac (4 replies)
  57. how to set function( input range )and (array output)!! (2 replies)
  58. Please help - pivot drilldown macro (3 replies)
  59. Vlookup from external file (3 replies)
  60. [SOLVED:] Two macro button but in a double action (33 replies)
  61. [SOLVED:] Filter data to pages based on number format (2 replies)
  62. How can I see the code used on another form? (6 replies)
  63. [SOLVED:] exporting chart as image on a mac (1 replies)
  64. Trying to create Submit button that will attach the form created in Excel via Lotus (2 replies)
  65. [SOLVED:] VLookup Formula (7 replies)
  66. Compare two sentences and highlight in different color (17 replies)
  67. [SOLVED:] Change VBA from AutoFill to FillDown (4 replies)
  68. What method do I use? (4 replies)
  69. [SOLVED:] Dynamic hyperlinks? (1 replies)
  70. [SOLVED:] Run Crystal Report from Excel VBA (3 replies)
  71. [SOLVED:] Unprotect a merged cell (2 replies)
  72. [SOLVED:] SQL Syntax help (2 replies)
  73. Extracting a number from text using a vba function (4 replies)
  74. Macro that updates a workbook using an old workbook (1 replies)
  75. How to Convert XML text intoe Array (5 replies)
  76. skip zeros for chart range (2 replies)
  77. Select picture shapes (7 replies)
  78. Extra lines at the botom of notepad when opening CSV (5 replies)
  79. [SOLVED:] PLEASE HELP ME WITH MONTHVIEW (2 replies)
  80. The specified Dimension is not valid for the current chart type (9 replies)
  81. [SOLVED:] Update Cell Based Off TickBox Value (4 replies)
  82. Merge multiple workbooks with multiple worksheets into one (4 replies)
  83. Relative selecting to the right (or left)? (3 replies)
  84. positioning charts (1 replies)
  85. [SLEEPER:] Macro that Splits columns and creates .txt files with the data (5 replies)
  86. Generating sheets using several templates (9 replies)
  87. [SOLVED:] Turning part of substring into capital for text data (3 replies)
  88. [SOLVED:] Trouble getting word docs to print from Excel VBA (7 replies)
  89. Copy cells from open or closed workbook (2 replies)
  90. Pull Data from a closed/open excel workbook (3 replies)
  91. IF STATEMENT (7 replies)
  92. Print to txt file (10 replies)
  93. Gaining Familiarity with VBA (2 replies)
  94. [SOLVED:] VBA Code - Set up condition to an Option Button (7 replies)
  95. help me with a webbrowser control please (1 replies)
  96. Get Data From Web Page (14 replies)
  97. [SOLVED:] Automatically saving workbook containing macros as a macro-free workbook (10 replies)
  98. [SOLVED:] where are these two excel workbooks coming from (6 replies)
  99. How to split table into multiple worksheets based on one column and change its format (0 replies)
  100. Selecting values from different rows in a table and merge them in order in one row (1 replies)
  101. Replace unicode charachters in a text file (6 replies)
  102. unique records to Main worksheet in Excel VBA (5 replies)
  103. [SOLVED:] Format Current Selection as a Table (1 replies)
  104. [SOLVED:] Macro to Take a Worksheet from One workbook and Move it to Another (5 replies)
  105. [SOLVED:] VBA to insert column and write concatenation formula (2 replies)
  106. Colour Cell background based on cell values (9 replies)
  107. Find or Match with alphanumeric fields? (6 replies)
  108. Make conditional formatting (font color, number format) static (7 replies)
  109. Break/remove link (5 replies)
  110. Lock changes to Pivot Table Rules (7 replies)
  111. How to find a string in excel VBA (3 replies)
  112. Subtotal in VBA with counta function (1 replies)
  113. Find Values in Different Columns and Figure out where to place the values (0 replies)
  114. Dates and Filters (19 replies)
  115. For Each Loop Not Working (5 replies)
  116. [SLEEPER:] Unable to call Java web service via excel 2010 (0 replies)
  117. [SOLVED:] Match Criteria on two Sheets and see if the Conditions are met (2 replies)
  118. [SOLVED:] Conditional formatting (8 replies)
  119. selecting ranges (1 replies)
  120. [SOLVED:] Shuffle Array VBA (6 replies)
  121. [SOLVED:] EXCEL FILE NOT SAVING IN VBS (3 replies)
  122. Find indices of value and return entire rows of these indices (3 replies)
  123. [SOLVED:] Crossovers (17 replies)
  124. [SOLVED:] Formula Assistance Desperately Required (4 replies)
  125. [SOLVED:] Expiry date (2 replies)
  126. Copy filtered records and paste another worksheet in Excel VBA (0 replies)
  127. [SOLVED:] VBA Sum Records Which Match Monthly Column Heading (9 replies)
  128. Press ENTER instead of clicking on the button (1 replies)
  129. VBA Code - Data from Access to excel (3 replies)
  130. [SOLVED:] Clean the row if column F does not contain UDS or EUR (5 replies)
  131. dynamically inserting bars into a chart (0 replies)
  132. [SOLVED:] Check Column N and if empty clean data on columns M,L,K (6 replies)
  133. [SLEEPER:] Delete Characters in a string (6 replies)
  134. [SOLVED:] Copy paste help needed in macro (2 replies)
  135. follow hyperlink change file location (6 replies)
  136. Replace content of column (2 replies)
  137. Combine Workbook_different worksheet(same Name) in one master workbook (3 replies)
  138. Cell values based on dropdownlist selection (5 replies)
  139. [SOLVED:] Checkbox - linked cells (7 replies)
  140. Loop to set 250 strings to cell contents (5 replies)
  141. [SOLVED:] do until loop with if statement that applies on different columns (vba) (8 replies)
  142. If Statement ComboBox Value (5 replies)
  143. Delete then restore all data tables in a workbook - fix for Excel 2010? (4 replies)
  144. [SOLVED:] if sheet 9 exists, clear it otherwise create one (15 replies)
  145. [SOLVED:] Find value of cell after filtering (6 replies)
  146. [SOLVED:] Find and Replace in csv Files (13 replies)
  147. [SOLVED:] Macro that finds a semicolon, then copies and inserts rows, and removes some data (2 replies)
  148. Need your help! (1 replies)
  149. [SOLVED:] Shell Command Duration (10 replies)
  150. Auto insert colon and decimal period (1 replies)
  151. [SOLVED:] For Loop with multiple conditions. (7 replies)
  152. [SOLVED:] Pivot Table Filter Macro Error (1 replies)
  153. map xml to sheet whitout export (0 replies)
  154. Excel .xlsm + Run time error 1004 Initialization of the data source failed (2 replies)
  155. [SOLVED:] VBA Merge two tables into one (4 replies)
  156. [SOLVED:] min value (9 replies)
  157. Help needed! (1 replies)
  158. Do Until loop vs array (9 replies)
  159. [SOLVED:] VBA code skipping cells, not sure why? (4 replies)
  160. Using VBA to change File Folder Properties (3 replies)
  161. Delete some plot area (1 replies)
  162. Pull innertext from 2nd and 3rd tables within each class name (1 replies)
  163. [SOLVED:] deleting empty lines in a word document after inserting text (3 replies)
  164. What's the best way to create a custom user guide for a workbook? (3 replies)
  165. Sleeper: Download .xlsm from outlook (4 replies)
  166. number of decimal (digits after dot) and other (3 replies)
  167. I Need Help Conditional formatting in cell (4 replies)
  168. VBA S.O.S. (3 replies)
  169. Macro no longer works (1 replies)
  170. [SOLVED:] Replace only in text and numbers (not in formulas) (7 replies)
  171. VBA Code is too long and slow to load data from on worksheet to another (4 replies)
  172. PLEASE help me with a VBA macro to filter data with mutiple criteria (6 replies)
  173. VBA Code to search for value in worksheet and enter date into next column (3 replies)
  174. I need vba code Refresh all sheets and save (4 replies)
  175. [SOLVED:] Exporting Single column as .txt file (9 replies)
  176. VBA to Compare 2 Workbooks with Criteria and Paste Differences (2 replies)
  177. Easy way to code all toggle buttons? (3 replies)
  178. Challenge... Very difficult coding HTML knowledge required Please Help!! (4 replies)
  179. Cannot surpress compatibility or auto calculate message..HELP!! (1 replies)
  180. Selection = <Type mismatch> (12 replies)
  181. [SOLVED:] working with Date&Time values / nested loops / Formatting (6 replies)
  182. [SOLVED:] sending email (2 replies)
  183. [SOLVED:] sending email (0 replies)
  184. [SOLVED:] Filter table for results within a date range (0 replies)
  185. [SOLVED:] Is there any event which catches an image being pasted into a workbook? (4 replies)
  186. help me(filter in the listbox) (1 replies)
  187. [SOLVED:] Filter Data, Delete Rows, Then remove filter (2 replies)
  188. [SOLVED:] Make File Folders using data from column range (2 replies)
  189. [SOLVED:] Range of last used cell, Paste Data to last cell (1 replies)
  190. combox preload speed up (3 replies)
  191. Should I look for a solution? (2 replies)
  192. Finding value in matrix (5 replies)
  193. Help macro copying specific columns from one workbook and paste value .... in another (1 replies)
  194. Hide columns based on cell value (6 replies)
  195. How to stop displayig a cell text in the formula bar? (3 replies)
  196. [SOLVED:] 3D Z-Axis (8 replies)
  197. Using values from merged cells (VBA) (3 replies)
  198. [SOLVED:] find highest high and highlight it (11 replies)
  199. Coding Assistance! (7 replies)
  200. Sleeper: Make macro more efficient (3 replies)
  201. Macro SoS! (7 replies)
  202. [SOLVED:] Select specific sheets then run a copy row macro (2 replies)
  203. Macro to copy information from the main worksheet by date and city criteria and paste (5 replies)
  204. [SOLVED:] Pulling back Unique ID to excel (4 replies)
  205. [SOLVED:] vba to copy a content of cells marked green (5 replies)
  206. [SOLVED:] Running a macro in a worksheet from a module (10 replies)
  207. [SOLVED:] Can VBA copy a table from Word and be pasted entirely into one single cell in Excel? (2 replies)
  208. [SOLVED:] Find and copy from another sheet? (9 replies)
  209. VBA Suchen und Ersetzen (1 replies)
  210. [SOLVED:] Match and copy. (6 replies)
  211. VBA to determine the rank of a matrix (7 replies)
  212. Filtering text data into n subsets then summing (12 replies)
  213. BOM Challenge (10 replies)
  214. [SOLVED:] Need help with returning values from excel sheel to another using cell address (1 replies)
  215. Sleeper: Help required regarding solving the excel problem. (1 replies)
  216. [SOLVED:] VBA Evaluate returns #VALUE for some expressions (SUMPRODUCT and IF) (14 replies)
  217. reference combobox as a variable (4 replies)
  218. Excel vba string find and replace/change column value with a variable string (4 replies)
  219. [SOLVED:] VLOOKUP Problem (duplicating lines) (10 replies)
  220. [SOLVED:] Return Column / Row name of active cell (6 replies)
  221. [SOLVED:] Macro recording gives different result in graph (6 replies)
  222. [SOLVED:] referencing a control type (3 replies)
  223. [SOLVED:] Selecting userform from cell content (1 replies)
  224. [SOLVED:] Anyone know how to - Range = typed array (22 replies)
  225. VBA to force paste special (19 replies)
  226. [SOLVED:] VBA open password protected file in read only mode (3 replies)
  227. how to grab filter list data (2 replies)
  228. Quick question about my code that creates a 2D array (11 replies)
  229. Tweak VBA to Move SharePoint Files to a Folder in Same Location (5 replies)
  230. Copying formulas from 2 different workbooks (0 replies)
  231. VBA Reference problem (4 replies)
  232. [SOLVED:] Using stdev() function in VBA (2 replies)
  233. Help with activating sheets (3 replies)
  234. Running a macro when double clicking a cell in another sheet (1 replies)
  235. Write formula in VBA-'Error 13' (4 replies)
  236. [SOLVED:] Error 1004 Application defined or object defined when code runs (3 replies)
  237. [SOLVED:] Help with syntax for nested dictionaries (8 replies)
  238. Macro/VBA code help (9 replies)
  239. Evaluate 3 columns of data and display 1 value in a 4th column (3 replies)
  240. Create Button Shadow Effect (7 replies)
  241. [SOLVED:] VBA issue with renaming a file (8 replies)
  242. Macros for saving the file with sertain file name (2 replies)
  243. [SOLVED:] prevent form to make the sheet scroll? (7 replies)
  244. Check if a text box exists in a webpage and if so then run code. (4 replies)
  245. [SOLVED:] Using VBA in Excel 2010, need to change text of many cond formats, but how? (4 replies)
  246. Replace Query Database (5 replies)
  247. [SOLVED:] Create sub lists from main list (5 replies)
  248. Next loop without calling additional functions on error (4 replies)
  249. Sleeper: Adding a subroutine to a macro already done. (1 replies)
  250. [SOLVED:] Conditional percentile calculation (2 replies)