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. Copy Paste from multiple worksheets into one based on multiple criteria (20 replies)
  2. FORCE TO POPULATE CELL (2 replies)
  3. [SOLVED:] Need a little help with "totals" (4 replies)
  4. Create Sheet if Workbook name contain some text (1 replies)
  5. Create a simple chart in a sheet where a pivot table already exists (6 replies)
  6. Edit VBA to prevent paste but allow copy and save the file with a file name derived (0 replies)
  7. [SOLVED:] Help to Improve Double Loop Code (8 replies)
  8. Excel as Notify Icon (1 replies)
  9. find matching entry, then copy and paste (2 replies)
  10. [SOLVED:] Range, Columns, and Copy (12 replies)
  11. Help with code (2 replies)
  12. [SOLVED:] struggling with excel combo boxes macro (0 replies)
  13. Sumifs and dates (1 replies)
  14. [SOLVED:] Sum from previous sum formula in a column to active cell (9 replies)
  15. Exel Crashes with Form Control (14 replies)
  16. Code to Group Worksheets when Printing and Print Preview - 2003 vs 2010 (6 replies)
  17. XML Data I/O (0 replies)
  18. [SOLVED:] RunTime Error 53 : File Not Found error (10 replies)
  19. Bill of Material (2 replies)
  20. Fill a combobox with data found in a range based on worksheet chosen in another cbx (3 replies)
  21. Copy data from different workbook and consolidate into one masterfile workbook (0 replies)
  22. [SOLVED:] Help with Loops (4 replies)
  23. [SOLVED:] User input to delete value in named range: (8 replies)
  24. VLOOKUP returns #N/A (2 replies)
  25. Find a "zero" of an implicit function (1 replies)
  26. [SOLVED:] Date overlap (9 replies)
  27. [SOLVED:] copy not contiguous cells via VBA (3 replies)
  28. Barcode fonts (3 replies)
  29. blank row (2 replies)
  30. trasfer data from Lotus macro to Excal VBA macro (2 replies)
  31. Change Cell Color on Sheet "Statistic" if value is negative (2 replies)
  32. PivotFields class returns an error when .Function property is set (2 replies)
  33. [SOLVED:] 2013 CalcPad.xlsm in XLStart folder. Open Excel - "CalcPad.xlsm is already open." (1 replies)
  34. Total data if salary each month is the same - VBA (0 replies)
  35. How to copy format of a column using spin button (0 replies)
  36. Extract values of a certain format (10 replies)
  37. Rename Code Modules Programmatically (17 replies)
  38. VBA Calendar (5 replies)
  39. Search for a string on all excel files inside a ZIp folder (6 replies)
  40. help with copy range (4 replies)
  41. [SOLVED:] Creating a unique id (13 replies)
  42. [SOLVED:] Populating Listbox (8 replies)
  43. [SOLVED:] Ie Automation (3 replies)
  44. Unable to set FormulaArray Property of the Range Class - Using Replace Function (3 replies)
  45. [SOLVED:] RTE Error (6 replies)
  46. Rename buttons using loop and "i + 1" (6 replies)
  47. Call previous dictionary entry (3 replies)
  48. [SOLVED:] Change the macro to search for a specific word (as written) and not close to it (8 replies)
  49. Information sheet or message in xlam? (2 replies)
  50. VBA Script to Average Amplitude Values in Each Bin Range of a Frequency Histogram (4 replies)
  51. Have Macro run when cell is updated (13 replies)
  52. Percentage Difference for Two Percentage (1 replies)
  53. [SOLVED:] Copy sheet into another workbook and put in alphabetical order (7 replies)
  54. Excel slideshow and data query help (5 replies)
  55. Help to use an array for this little section of code (2 replies)
  56. Worksheet change clears selection(s) on MultiSelect type listbox. (4 replies)
  57. vba code move cell to next cell (9 replies)
  58. if find string copy that cell to right column (3 replies)
  59. Copy & Pasting Overwrites My Data Validation (4 replies)
  60. [SOLVED:] Need: VB code to get values from different closed workbooks (4 replies)
  61. html problem with vba (1 replies)
  62. [SOLVED:] Adjust error calculation in VBA (2 replies)
  63. Wrong line in the macro. (5 replies)
  64. Workbook -macros query (1 replies)
  65. [SOLVED:] GetElementsByClassName With IE8 (3 replies)
  66. [SOLVED:] Consolidate spreadhseets (1 replies)
  67. Filtercopy does not return records listed with criteria value below 7 characters (7 replies)
  68. savecopyas in event (1 replies)
  69. Check 2 column and Combine Data (0 replies)
  70. [SOLVED:] Call Sub in module from userform (5 replies)
  71. [SOLVED:] VBA conditional formatting (9 replies)
  72. Excel VBA - Delete last row containing data (4 replies)
  73. [SOLVED:] Updating sheet with data from another sheet (6 replies)
  74. Help on Shell and Class module (1 replies)
  75. Excel VBA - vLook-Up if match first 2 characters of one column with another column (3 replies)
  76. Copy range of cells between workbooks with same named sheets (1 replies)
  77. Varible help? (5 replies)
  78. Move various duplicate rows to new sheet (3 replies)
  79. Using Min() in VBA (3 replies)
  80. [SOLVED:] Transfer values from sheet to textbox (4 replies)
  81. [SOLVED:] Finding non-zero minimum in a dynamic array (6 replies)
  82. search for data and delete rows containing it (1 replies)
  83. [SOLVED:] compare date in number and product (4 replies)
  84. [SOLVED:] Automating Date Entry (9 replies)
  85. [SOLVED:] Open CSV File Automatic Separating Comma (2 replies)
  86. VBA to change column to row and store the result in new column (4 replies)
  87. VBA Change ODBC Connection String (Excel) (7 replies)
  88. [SOLVED:] range copy with paste (4 replies)
  89. [SOLVED:] In a workbook in several sheets - each sheet several macro at once (3 replies)
  90. [SOLVED:] Find vs Match (9 replies)
  91. [SOLVED:] how to copy the visible cells of a table to another tab? (4 replies)
  92. [SOLVED:] Access records via Excel VBa between dates (12 replies)
  93. Is it possible to display information from 3 cells side by side in a single cell? (3 replies)
  94. Run time error 424 (2 replies)
  95. I Need Help Vba Code Automatically Sort Rows Largest To Smallest (7 replies)
  96. [SOLVED:] Function data type issue (12 replies)
  97. Copying & pasting the Data from Multiple sources to corresponding multiple destinatio (1 replies)
  98. Closing Excel when UserForm closed (only if not an admin) (4 replies)
  99. vba excel populate textbox into listbox (3 replies)
  100. Barcode Scanner Excel Lookup (2 replies)
  101. Select multiple worksheets using list contained in worksheet (4 replies)
  102. [SOLVED:] Automatically sum cell values from new sheets (that are not created yet) (3 replies)
  103. [SLEEPER:] Extracting Image information using Data Modified from Folders & Subfolders (1 replies)
  104. [SOLVED:] Referece to Formulas R1C1 (8 replies)
  105. [SOLVED:] time calculation problem (5 replies)
  106. [SOLVED:] Removing web address references / placing ... on a cell after 397 characters. (6 replies)
  107. [SOLVED:] Macros - dates in a column and display months in another column (2 replies)
  108. find and move the duplicate values in another sheet (3 replies)
  109. [SOLVED:] Automatically give new sheet name (created frm template w/macro) the value of a cell (14 replies)
  110. Help for transferring the raw computation to Excel VBA in financial situation (0 replies)
  111. [SOLVED:] Check sheet1 Copy duplicate items rows on sheet2 to sheet3 (4 replies)
  112. Can not run VBA use data from other excel file (10 replies)
  113. Need Help For Excel VBA Coding Convert to Addins (or) dll (1 replies)
  114. Filter specific data to a new workbook (6 replies)
  115. [SOLVED:] Merge and Combine data (1 replies)
  116. [SOLVED:] Delete File In Use error (5 replies)
  117. [SOLVED:] Please help with my ListBox (10 replies)
  118. [SOLVED:] Export and import CSV Date format proble in Excel2010 (3 replies)
  119. I Need Eidt Code Copy And Paste (7 replies)
  120. Setting print area and borders. (5 replies)
  121. [SOLVED:] UnProtect al files in a folder (2 replies)
  122. Opening Excel Automatically (3 replies)
  123. Updating Access from Excel UF (7 replies)
  124. [SLEEPER:] VBA and NumberFormat (2 replies)
  125. [SOLVED:] Footers question in VBA (1 replies)
  126. [SOLVED:] What to do with my Excel .xml file (3 replies)
  127. [SOLVED:] Macro in 2003 works, in 2010 doesnt work (part 2) (4 replies)
  128. vba macro code for finding the common entry names (0 replies)
  129. [SOLVED:] Replace Cell Date with text (4 replies)
  130. Excel 2003 Macro, no longer working in 2010 (4 replies)
  131. [SOLVED:] Find and replace question (6 replies)
  132. Combo Box Data Validation Macro (5 replies)
  133. Simple excel macro help required (1 replies)
  134. Using vba to populate data into a master workbook (1 replies)
  135. Use of operators in Text Boxes inconsistent? (21 replies)
  136. [SOLVED:] Working With Subset Of Data (2 replies)
  137. [SOLVED:] Using a Variable in creating a Validation List (2 replies)
  138. date falls on monday display the date of saturday (4 replies)
  139. Combine macros (3 replies)
  140. [SOLVED:] Search all open workbook and if find the match data , clean the cell on Column A (11 replies)
  141. advanced replace macro (7 replies)
  142. [SOLVED:] Remove the limitation 65536 rows (4 replies)
  143. [SOLVED:] Handling Strings with seperators (2 replies)
  144. [SOLVED:] MID Formula help - when last digit value is 0 (3 replies)
  145. [SOLVED:] Unable to use Validation (10 replies)
  146. Fill in between the points on a scatter plot (0 replies)
  147. Worksheet to find values of a sheet and copy the column (1 replies)
  148. if find the matched data in another workbook copy the complete row (15 replies)
  149. Overflow error. (4 replies)
  150. Not able to design pivot based on requirement (1 replies)
  151. [SOLVED:] "mypath" causing a problem in a network drive (11 replies)
  152. [SLEEPER:] How do I delete something based on headers? (1 replies)
  153. Conditional Min and max in a hour format (0 replies)
  154. [SOLVED:] Creating a combined formula with erow macros (2 replies)
  155. [SOLVED:] if find none numeric data on cloumn A just clean the column A (2 replies)
  156. [SLEEPER:] Creating a macro for next empty row (2 replies)
  157. [SOLVED:] if cell start with 0 clean the cell from A to Z (6 replies)
  158. [SOLVED:] Multiple Goal Seek Code - Only Solves the First Row (2 replies)
  159. Redim Preserve array problem (3 replies)
  160. VBA Macro stops working after opening the VB Editor (1 replies)
  161. Normalise Pivot Table (4 replies)
  162. [SOLVED:] Copy row cells to powerpoint (14 replies)
  163. Evaluate content control title and move to correct column (9 replies)
  164. Create Output File (1 replies)
  165. Categories List (9 replies)
  166. [SOLVED:] Do While Loop will not execute (0 replies)
  167. [SOLVED:] if does not find matched value data with data on cell delete the row (7 replies)
  168. [SOLVED:] Subscript out of range Multidimensional Array (11 replies)
  169. Macro speed (1 replies)
  170. [SOLVED:] Formula be replaced with macro (4 replies)
  171. [SOLVED:] VBA SUM question (13 replies)
  172. [SOLVED:] Delete Row if Cell Contains More Than 10 Characters (6 replies)
  173. [SOLVED:] Request to Modify Macro (4 replies)
  174. Using a drop-list to categorize and insert cells (4 replies)
  175. [SOLVED:] Extract 1st 4 letters of last name..ideas? (11 replies)
  176. List view for VBA Excel Macro (1 replies)
  177. [SOLVED:] Look/Match specific text based on similar column criteria (7 replies)
  178. [SOLVED:] Name Splitter Help (6 replies)
  179. VBA Conditional Formatting Not Working Properly (5 replies)
  180. Multi Columns, Multi Listbox Form (4 replies)
  181. Worksheet_change event executed on a wrong sheet? (31 replies)
  182. [SOLVED:] Check Label for certain text (2 replies)
  183. A macro that adds up prices and sorts them in categories (6 replies)
  184. Excel freezes after running Macro (1 replies)
  185. macro opens the desired file and paste the information in a selected from me sheet (14 replies)
  186. [SOLVED:] Running a script from a blank workbook and apply to specific files in specific folder (4 replies)
  187. [SOLVED:] Add to Column Next to Selection (3 replies)
  188. macro to delete row if cell is empty (1 replies)
  189. [SOLVED:] Variable coping (3 replies)
  190. [SOLVED:] Search a string to contains.... (5 replies)
  191. macro to delete data based on time (1 replies)
  192. How to delete rows if a cell is red? (2 replies)
  193. [SOLVED:] Overwrite write reserved file with updated copy (same name; also write reserved) (1 replies)
  194. Pull Data From One Worksheet To Another (2 replies)
  195. How to find worksheet that contains an error (with 100+ worksheets in it) (2 replies)
  196. [SOLVED:] First unhidden column (7 replies)
  197. [SOLVED:] Removing last six characters from a string (17 replies)
  198. Password Protected code needs editing Employee no longer with Company (1 replies)
  199. [SOLVED:] Delete a known named range from a known cell (5 replies)
  200. [SOLVED:] Pull Data from Sheet3 to Sheet1 (4 replies)
  201. [SOLVED:] Before_Close Sub (3 replies)
  202. Matching First Name & Name Text Boxes on Form with Corresponding Columns TROUBLESHOOT (0 replies)
  203. Listbox Problem (1 replies)
  204. VBA code error (3 replies)
  205. VBA code edit to populate to end of data (2 replies)
  206. VBA User form and Coding help (1 replies)
  207. Macro to find a cell containing text, select range offset, cut and paste to lower row (2 replies)
  208. Formulas help (4 replies)
  209. Code VBA checkbox and optionbox (2 replies)
  210. select the second row of the result of advanced filter. (8 replies)
  211. [SOLVED:] design ideas for UF and multiple users (6 replies)
  212. [SOLVED:] from a string, how to get the equivalent constant value? (7 replies)
  213. [SOLVED:] How to jump next to column (9 replies)
  214. [SOLVED:] UF validation based on date (2 replies)
  215. trying to copy a cell to a different cell automatically (1 replies)
  216. [SOLVED:] Reverse columns and Rows (5 replies)
  217. Copying table from Excel, and saving error (0 replies)
  218. ListBox.ListCount limit in Excel 2010, and/or previous years... (3 replies)
  219. File attached (1 replies)
  220. Extracting 4 digit number from combobox, looking that up in a worksheet column etc. (3 replies)
  221. Sleeper: Macro to delete rows in result of advanced filter. (5 replies)
  222. [SOLVED:] HOw to run a macro automaticcaly when open a workbook (8 replies)
  223. HELP- Vba to copy Word to Excel (2 replies)
  224. selecting specific rows (19 replies)
  225. [SOLVED:] On Error GoTo ??? (8 replies)
  226. [SOLVED:] Trying to solve count (22 replies)
  227. [SOLVED:] VBA Automatic Rolling Column Headings (4 replies)
  228. VBA Excel Help Selecting Multiple Pages (1 replies)
  229. What exactly is VBA? (7 replies)
  230. [SOLVED:] Creating excel file using VBA - File name to contain the current date and time (5 replies)
  231. [SOLVED:] VLOOKUP only if #N/A found (5 replies)
  232. Problem sharing program with another computer (6 replies)
  233. How to rename cells (1 replies)
  234. [SOLVED:] Grouping not working properly using slicer for pivot data (1 replies)
  235. Help Subtract value and update cell in another workbook (6 replies)
  236. How do I disable auto text to columns with VBA? (2 replies)
  237. Cell Values getting truncated when converting an excel 2010 file to dbf 5 (1 replies)
  238. [SOLVED:] POP UP VBA!! (4 replies)
  239. Reply on open Outlook item by Excel VBA (1 replies)
  240. attachment download from outlook (2 replies)
  241. Break each external links in a cell and replace with the current value of each link (4 replies)
  242. [SLEEPER:] Prefill cells with command line switches from a browser (1 replies)
  243. [SOLVED:] What is happening with this function (7 replies)
  244. Get the position of the data in the table (3 replies)
  245. [SOLVED:] Searching for one of many text strings in a cell based on a text string lookup table (7 replies)
  246. Help with creation of Word Document from Excel (16 replies)
  247. [SOLVED:] Checking if cell value is within +-15 from next one. (3 replies)
  248. Help needed to track user changes on a worksheet in different columns for each user (3 replies)
  249. PivotTable: CD count not track count. (5 replies)
  250. [SOLVED:] Copy PDF (6 replies)