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. [SLEEPER:] Looping and combining macros - help needed (18 replies)
  2. [SOLVED:] User-Defined Type Not Defined Error (9 replies)
  3. [SOLVED:] if find the spicify word copy data (9 replies)
  4. Filter dates and blanks (1 replies)
  5. VLOOKUP with a SUM (1 replies)
  6. Index Match Match (1 replies)
  7. [SOLVED:] splitting a range to a variable number (2 replies)
  8. [SOLVED:] Extract numbers from text string (5 replies)
  9. calculate data and find outliers (2 replies)
  10. VBA-code Import from website to excel (0 replies)
  11. Please help spot the error!!! (2 replies)
  12. [SOLVED:] Find and extract information from multiple excel files (1 replies)
  13. Paste values copied from a webpage (4 replies)
  14. VBA to stop dsiplaying the debugging option on pressing CTRL+Pause Break (2 replies)
  15. [SOLVED:] How to make Todays Date visible on Pivot Table Filters (1 replies)
  16. VBA Code Help Needed. Lookup Value Ranges (0 replies)
  17. Save As PDF in a particular order (1 replies)
  18. Calculating difference between months (3 replies)
  19. TimeSerial does not reflect Windows Regional Settings (3 replies)
  20. [SOLVED:] Help with vba Code (5 replies)
  21. Opening multiple doc/html files into excel worksheets within a single workbook (1 replies)
  22. [SOLVED:] Look For Sheets Wildcard no Loop (5 replies)
  23. [SOLVED:] Scoring data by finding duplicate names. (2 replies)
  24. [SOLVED:] Excel VBA - Open Word template and create bulleted list based on cell values (10 replies)
  25. VBA script to help sort and distribute data (3 replies)
  26. Searching for multiple values in string (9 replies)
  27. [SOLVED:] REFERENCING A VARIABLE FORM NAME (5 replies)
  28. Checking in a Document in SharePoint from Excel Macros (0 replies)
  29. Vba to copy excel worksheet orientation to word document (5 replies)
  30. [SOLVED:] Failing miserably at populating combobox (6 replies)
  31. Change value of adjacent cell if field in form matches (4 replies)
  32. Issue with pictures upload using vba code into excel- they disapear (1 replies)
  33. Reoccurring Data Transfer (2 replies)
  34. Compiling data questions (3 replies)
  35. Which copy/paste option (2 replies)
  36. HELP - SUMIF more than 3 conditions + operations in the sum (1 replies)
  37. Clear styles error (2 replies)
  38. Highlight Adjacent Cells Above Highlighted Cell (2 replies)
  39. [SOLVED:] Generating formula for summing time / date values. (8 replies)
  40. Enhancement of "Find text in Workbook and create link to cells" (2 replies)
  41. HELP! application.filesearch wont work in excel 2010 (2 replies)
  42. [SOLVED:] Help need to inser Carriage return in chart series name. (5 replies)
  43. VBA to run formula on Selected cells (1 replies)
  44. VBA for calculations (3 replies)
  45. Real-Time plus Countdown Timer (2 replies)
  46. Excel VBA Multiple Automatic Goal Seek Required – Please Assist us (2 replies)
  47. VBA Small Weather Forecast Spreadsheet (11 replies)
  48. [SLEEPER:] populating dynamic arrays from a dynamic array (1 replies)
  49. [SOLVED:] Connecting to Access 2010 (3 replies)
  50. [SOLVED:] Weeks and Months (7 replies)
  51. VBA dropdown help (1 replies)
  52. [SOLVED:] VBA Timer? (3 replies)
  53. [SOLVED:] Chart pop up (19 replies)
  54. Macros/VBA to do a loop and insert text (2 replies)
  55. [SOLVED:] Link to Word document (4 replies)
  56. New to VBA! Code for a sales calculator, how to output tables to user interface? (5 replies)
  57. Need help improving this VBA Code to make it run faster (3 replies)
  58. Delete all Datalabels on Chart Except Current Dates (4 replies)
  59. [SLEEPER:] Excel crashing every time I run my macro (1 replies)
  60. Funny Formating (1 replies)
  61. scheduled task & can't create outlook object (17 replies)
  62. [SOLVED:] Fill Userform textbox after clicking in sheet (return column number) (10 replies)
  63. [SLEEPER:] How to make print area fit entire page? (2 replies)
  64. Regex expression to retrieve data from HTML (4 replies)
  65. [SOLVED:] Looking for similar value (8 replies)
  66. [SLEEPER:] VBA codes to draw charts with data from multiple sheets (3 replies)
  67. VBA Code for VLOOKUP (2 replies)
  68. [SLEEPER:] VBA code finding duplicates in two Excel column. (2 replies)
  69. Help Getting Started (New Project) (4 replies)
  70. SQL Server Connection problem (5 replies)
  71. [SOLVED:] Show userform without showing excel (1 replies)
  72. Help! Error whilst record Macro ""Too many line continuations" (2 replies)
  73. (VBA) Conditionnal formatting with multiple conditions (3 replies)
  74. [SOLVED:] Splitting first, middle initial, and last name (3 replies)
  75. [SOLVED:] Looping through cutting and pasting values between two dates (33 replies)
  76. [SOLVED:] Sheet Reference based on a Cell Value??? (1 replies)
  77. [SOLVED:] Sending OutLook message no Attachment (2 replies)
  78. Add-in uninstalls after running on a CSV file (2 replies)
  79. Read Data From Excel File W/O Opening (0 replies)
  80. Extract specific data from a website (4 replies)
  81. [SOLVED:] Diary System - automation (7 replies)
  82. VBA for Import worksheet Selected Range Data from Another Closed workbook (0 replies)
  83. Efficiency Help (14 replies)
  84. 'Double' Random Selection in VBA (10 replies)
  85. Strange behavior of for... next loop (4 replies)
  86. Hi there (2 replies)
  87. Automate copying rows based on counter number increment (2 replies)
  88. How to apply the colour of a cell to another when its an exact duplicate (1 replies)
  89. [SOLVED:] FileDateTime Question (1 replies)
  90. Web Service Call and Authentification (0 replies)
  91. Cant access functions from a VBA add in (7 replies)
  92. [SOLVED:] Count functions, mostly at COUNTIF() Question (5 replies)
  93. Writing a loop with an offset and storing value in code while summing (2 replies)
  94. [SOLVED:] Formula (2 replies)
  95. [SOLVED:] Tab Button Control (9 replies)
  96. Sheet Reference error (1 replies)
  97. [SOLVED:] Code Not Iterating Each Worksheet (3 replies)
  98. [SOLVED:] Extracting values from cell where total has been rounded (13 replies)
  99. Looping through and Deleting data in Pivot chart (2 replies)
  100. [SOLVED:] Macro needs to recognize existing filename (3 replies)
  101. [SOLVED:] Is Variable Allocated (13 replies)
  102. Run-time error '429': ActiveX component can't create object (7 replies)
  103. On Error Issues (6 replies)
  104. Write a total number of hours each month into appropriate cell (4 replies)
  105. match multiline textbox item to coumn B3 in excel (2 replies)
  106. [SOLVED:] Using Items sequence numbers in order (7 replies)
  107. Create Combined Table from 2 Tables (2 replies)
  108. Creating a Macro to sort data (2 replies)
  109. [SOLVED:] Iterate Directory's Opening Workbook (22 replies)
  110. [SOLVED:] Microsoft Delpoyment Summary legit? (1 replies)
  111. VBA vlookup value not formula (1 replies)
  112. [SLEEPER:] Wildcards with Index Match Match (0 replies)
  113. Open a txt file (3 replies)
  114. [SOLVED:] Find "PR" in column O then color cell and msgbox (3 replies)
  115. [SOLVED:] Vba Cut Paste By Criteria (9 replies)
  116. Vlookup Error (3 replies)
  117. [SOLVED:] vba to check if folder exists in SharePoint and if not then create folder (10 replies)
  118. [SLEEPER:] Find columns based on header names and make the column proper (4 replies)
  119. [SOLVED:] Copy down values with VBA (1 replies)
  120. Is this possible in VBA ????? ( rexx interpret command) (2 replies)
  121. Blank cell not really empty when copy and paste from different projectsheets (5 replies)
  122. Specifying filter according to date (10 replies)
  123. [SOLVED:] Repeat Procedure (6 replies)
  124. Macro to pull calendar appointments from outlook into excel (2 replies)
  125. Reorganizing data (5 replies)
  126. populate word doc (1 replies)
  127. Convert Word document in HTML via Excel (1 replies)
  128. [SOLVED:] Finding matches coloring them and the color of the sheets (7 replies)
  129. highlight entire rows when two cells in row are populated (2 replies)
  130. place 0 before numbers in a string (13 replies)
  131. [SOLVED:] Data Entry UserForm for Excel 2007 (12 replies)
  132. IF and OR .... Can't seem to work it out. (4 replies)
  133. [SOLVED:] Excel is forcing numbers on me! (4 replies)
  134. [SOLVED:] vlookup help needed (3 replies)
  135. Error handling not working (5 replies)
  136. Automate capturing a particular columns using VBA (2 replies)
  137. VBA worksheet change event (1 replies)
  138. Need VBA code to display 1st PRIME number greater than value (N) (4 replies)
  139. [SOLVED:] Type Mismatch Error 13 in Using Range and Offset (1 replies)
  140. Referencing a column in AVERAGEIFS function in excel (1 replies)
  141. [SOLVED:] Access to info in Status Bar when in autofiltermode (4 replies)
  142. EXCEL: Data Validation With Case Sensetive. (10 replies)
  143. Update master workbook if does not match multiple columns (1 replies)
  144. change event (0 replies)
  145. VBA to filterthen copy cells from sheet1 then paste vlaue to sheet2 destinated cells (0 replies)
  146. [SOLVED:] Compare two lists First Name Last Name - If both match add Email Address (3 replies)
  147. consolidate with two criteria uisng VBA (0 replies)
  148. [SOLVED:] Help with formula please (2 replies)
  149. Copy Range from active row to new sheet (3 replies)
  150. [SOLVED:] Help with excel formula (4 replies)
  151. Sleeper: Finding and adding up values (0 replies)
  152. Vba Pivot table (4 replies)
  153. [SOLVED:] Compile error: Type mismatch: array or user-defined type expected (4 replies)
  154. Pivot Table Link Help (1 replies)
  155. [SOLVED:] VBA to create Table of Content but EXCLUDE xlSheetHidden andxlSheetVeryHidden (2 replies)
  156. Check a list of names, if a worksheet exists move on, if not, create one (8 replies)
  157. Excel Module to find() and assign variables (3 replies)
  158. [SOLVED:] Colour cell in column F if any value in cloumn J (2 replies)
  159. How Do I Get An Excel Sheet That Validates And Then Emails? (4 replies)
  160. Copy range and paste depending on the selected checkbox (1 replies)
  161. Macro becoming slower (25 replies)
  162. VBA Code For Appending to the text file (5 replies)
  163. Include theme colors in an add-in (10 replies)
  164. Consolidate worksheets with specific requirements (4 replies)
  165. [SOLVED:] delay in a macro? (2 replies)
  166. How to shade rows with three different colours (9 replies)
  167. [SOLVED:] Banding Formats (2 replies)
  168. Need VBA help duplicating certain rows and manipulating data on these rows (1 replies)
  169. run Word script from Excel with multiple open documents (5 replies)
  170. [SOLVED:] Class Modules - a few questions (5 replies)
  171. copy and pasting pivot graphs in different worksheets into a new worksheet (0 replies)
  172. Compare two workbooks and generate a report for the differences. (1 replies)
  173. [SOLVED:] Help Using Excel Month Function (3 replies)
  174. [SOLVED:] Lookup Value in Range for an If Statement (2 replies)
  175. get Zip codes from web based on address in cell excel VBA (2 replies)
  176. Automatically populating data when a certain column is filled (17 replies)
  177. vlookup query using VBA (19 replies)
  178. Userform Populated with range from another excel file (4 replies)
  179. Consulting work recommendations (1 replies)
  180. How to fill down to a certain length and delete everything before it (3 replies)
  181. Close Workbook Only if Completed (3 replies)
  182. InputBox OK and Cancel Button Problem (4 replies)
  183. How to paste data into next available blank row (3 replies)
  184. [SOLVED:] More precise number formats with "$" symbol? (9 replies)
  185. Can anybody help me? (12 replies)
  186. Copy row from one sheet to other sheet (1 replies)
  187. [SOLVED:] Find word insert formula (5 replies)
  188. Find match copy paste from another closed workbook (5 replies)
  189. [SOLVED:] Row deletion..!! Reverse case... (23 replies)
  190. [SOLVED:] macro to take information from. xml file and put it in. xls file (7 replies)
  191. Run time error 1004 Select methof of Worksheet class failed (6 replies)
  192. [SOLVED:] Find PN then trim all spaces (2 replies)
  193. destination name problem when error handeling... Please Help!!! (3 replies)
  194. Combining Workbooks with different file extensions (3 replies)
  195. Using a percentage in VBA (4 replies)
  196. VBA to copy from a web browser (2 replies)
  197. Sort not working anymore (2 replies)
  198. formula using VBA (5 replies)
  199. VB, Input Boxes and Printer Selection (2 replies)
  200. Add blank rows to fill a page (3 replies)
  201. Beginner's Question on IF function in VBA (4 replies)
  202. Creating Dynamic Named Ranges for Dependent Data Validation Lists (5 replies)
  203. select and delete row based on a cell's value (3 replies)
  204. problem with VBA when I open Excel automatically (2 replies)
  205. I Need assistance with popup calendar macro in excel 2010 (0 replies)
  206. How do I set .MarkerBackgroundColor in a chart to a ThemeColor with TintAndShade? (3 replies)
  207. Create a Loop Until using VBA (12 replies)
  208. EXCEL 2010: Macro is not working (3 replies)
  209. How to make all MsgBox and InputBox pop up in the same part of the screen. (4 replies)
  210. [SOLVED:] cmBox.setfocus doesn't give cmBox focus. Why? (24 replies)
  211. If function wont distinguish between letters and numbers. (5 replies)
  212. Compare and Copy (2 replies)
  213. [SOLVED:] VBA Stacking cells on top of each other (4 replies)
  214. Array Into Outlook Messages (3 replies)
  215. How to Convert XLM Files to Excel VBA Workbook/File? (7 replies)
  216. programmatically add reference and module in one macro (5 replies)
  217. Copy files listed in Excel from one directory to another...? (2 replies)
  218. [SOLVED:] Clearcontents method of range class failed (6 replies)
  219. [SOLVED:] Conditioning the names in a cell (6 replies)
  220. [SOLVED:] loop thru rows and populate a cell based on another cell's content (1 replies)
  221. need help with VBA for copying highlighted rows (2 replies)
  222. [SOLVED:] Listing Conditional Formatting on Separate Sheet or Workbook (23 replies)
  223. [SOLVED:] Can a Add-in detect when you save a different workbook? (3 replies)
  224. Create separate word docs with data from xls (6 replies)
  225. [SOLVED:] Date format issues with date picker on form (2 replies)
  226. [SOLVED:] Search rows on one or more criteria (2 replies)
  227. Help creating lotus email with attachments from excel look up list (1 replies)
  228. Anyone Used LockXLS? (3 replies)
  229. vlookup question (13 replies)
  230. [SOLVED:] Print two different worksheets from two files within one folder (5 replies)
  231. [SLEEPER:] Selected Slicer Value to Populate Cell (7 replies)
  232. Run macro in all worksheets (2 replies)
  233. Need help editing this macro code (1 replies)
  234. Output From and to document numbers and missing number for each branch in given range (12 replies)
  235. switching between running Programs or Alt+tab (2 replies)
  236. Using multiple checkboxes to hide and show specific columns Excel 2010 (1 replies)
  237. Excel 2007 to Excel 2010 Incompatibility (2 replies)
  238. Need a macros that read a range of cells, determine low value, then do something else (9 replies)
  239. hyphen in code (6 replies)
  240. [SOLVED:] Stability Issues in VBA macro (8 replies)
  241. custom views with a protected worksheet (4 replies)
  242. Recore new macro tool - automatically start on opening (2 replies)
  243. [SOLVED:] Can you clear ALL .OnKey assignments at once? (3 replies)
  244. [SOLVED:] Select, Zip, and Email Excel files (4 replies)
  245. Mid() mismatch (2 replies)
  246. Merging Data From Workbooks macro (8 replies)
  247. [SOLVED:] how do I change file extension on VBA that I already use (3 replies)
  248. VBA Yearly Extract (6 replies)
  249. [SOLVED:] Can this be done in a formula? (2 replies)
  250. Exclude specific worksheet from existing code (10 replies)