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. Enable Maximize button and change userform size by manually dragging borders. VBA (2 replies)
  2. Macro to sum between headers (2 replies)
  3. Insert data inside filed form in WEB (1 replies)
  4. [SOLVED:] trouble viewing code (0 replies)
  5. Any 64-bit Office users? (4 replies)
  6. VBA Code Cannot Access Database In SQL Server (9 replies)
  7. [SOLVED:] Current Code works, then when I add a line, Excel Crashes (4 replies)
  8. [SOLVED:] How to produce two workbooks from a larger workbook (7 replies)
  9. How To Create Macro To Pull Tables From SQL Server (2 replies)
  10. search rows in VBA (1 replies)
  11. [SOLVED:] If Condition returns Formula (3 replies)
  12. [SOLVED:] eliminate question mark box when enter key is pressed (20 replies)
  13. Create a Stopwatch for time study (3 replies)
  14. Export Excel 2010 to Project 2010 VBA adding columns to Project (5 replies)
  15. Excel - Send sheet & use range as body (2 replies)
  16. Vlookup through VBA: Dynamic Range (10 replies)
  17. Automated Data import from website (1 replies)
  18. [SOLVED:] KB: Group All Command Buttons on a Userform (12 replies)
  19. Calendar not linking to Userforms. (2 replies)
  20. [SOLVED:] Find and replace macro bugging out with finding #VALUE! (1 replies)
  21. [SOLVED:] Loop in VBA (2 replies)
  22. Linking numerical value occurrence to a date (2 replies)
  23. Return data from different sheets and variated cells Macro (3 replies)
  24. [SOLVED:] Copying to another sheet. (5 replies)
  25. VBA - importing all excel files in subfolders (1 replies)
  26. Match words in 2 cells (1 replies)
  27. can anyone see an isue with this line? object defined error (6 replies)
  28. [SOLVED:] Show in Label value in cell specific column (everey minute) (5 replies)
  29. Enlarge and restore an embedded chart from a group of charts (2 replies)
  30. [SOLVED:] Summing of sheets macro needed. (8 replies)
  31. Table of content or Hyperlink for different Table Name in work-book (3 replies)
  32. Halp! Excel data exporting (5 replies)
  33. [SOLVED:] Time/Date Formula for Analysis (3 replies)
  34. Tracking old & new formula changes & other changes w/ links to original cells (1 replies)
  35. Update variabel to be = string, specified in a cell?(Splitting a cell and distribute) (2 replies)
  36. Weather Forecast Spreadsheet User Form Help (3 replies)
  37. Used Opentext command, - How do i select the pop-up Workbook? (5 replies)
  38. scrape excel sheet embedded in an intranet page (3 replies)
  39. CountIf Help (3 replies)
  40. Runtime error 462 (1 replies)
  41. MacBook Pro Comparison (3 replies)
  42. [SOLVED:] How to enable macro (5 replies)
  43. Save as user form (1 replies)
  44. Problem solved - sorry (0 replies)
  45. VBA - the lowest number not working (2 replies)
  46. Macro Keeps changing date to American format (16 replies)
  47. Default Cumulative Cost Curve (VBA) (1 replies)
  48. Hi (1 replies)
  49. Creating letters quicker from spreadsheet (9 replies)
  50. Modifying excel data through VBA (1 replies)
  51. Setting column number and row number to variables leads to lots of issues (1 replies)
  52. [SOLVED:] Macro to compile a list in another workbook (5 replies)
  53. [SOLVED:] SendKeys really working (9 replies)
  54. [SOLVED:] Cell formating (3 replies)
  55. Send Macro cell rang as attachment to outlook with default signature (5 replies)
  56. How to add alternate column in worksheet (2 replies)
  57. Formula won't work past a certain date (4 replies)
  58. #Value error msg in VBA code (5 replies)
  59. Search a table on a website for a word & extract the 3rd cell to the Right of it. (8 replies)
  60. [SOLVED:] Fast compare values of Non-Contiguous Cells row in two different workbooks (3 replies)
  61. VBA code required:Compare sheet1 with sheet2 and copy the difference (1 replies)
  62. keyboard shortcut to copy the url of a cell (4 replies)
  63. VBA, retreive information from a word document and store it in the Excel (1 replies)
  64. [SOLVED:] Range selection fail when integrating with PowerPoint (3 replies)
  65. Macro to save in txt format web pages (1 replies)
  66. Access different tabs in Excel forms (12 replies)
  67. [SOLVED:] Identifying mixed Managers (3 replies)
  68. [SOLVED:] is sheet selection by variable possible? (2 replies)
  69. VBA help loop search and check status of item (2 replies)
  70. [SOLVED:] Excel loop (3 replies)
  71. Open PDF file after creating multiple pages into one PDF (6 replies)
  72. [SOLVED:] vba to keep the focus on userform last used textbox (37 replies)
  73. Find date and return value (5 replies)
  74. loop to go through a list find an empty cell and then place something in the cell (4 replies)
  75. [SOLVED:] Overlaying Shapeor Picture based on contents of a cell (7 replies)
  76. Permutation List Code (4 replies)
  77. variations on import vba (9 replies)
  78. Find All files in a Folder that were created and/or Modified after a set date (x), Op (1 replies)
  79. [SOLVED:] Counting Names in List that have completed any one of a Number of Courses (9 replies)
  80. [SOLVED:] Move Pivot Table row to end automatically (5 replies)
  81. VBA: Workbook re-open after closing (3 replies)
  82. Minimizing error to fit numerical data points into categories. (0 replies)
  83. [SOLVED:] Count distinct values in an array (3 replies)
  84. Search for and extract data from one Excel workbook and paste in another Excel workb (0 replies)
  85. [SOLVED:] interpolate value Every at Chainage 1750 (5 replies)
  86. formatting numbers extracted with a web querry (1 replies)
  87. BOM Compare - compare between tow versions of data (2 replies)
  88. How to find certain cells and add up adjacent cells (1 replies)
  89. [SOLVED:] Find the last cell in a column conditionally formatted (5 replies)
  90. Almost there: Loop to search website (5 replies)
  91. [SLEEPER:] Looping and combining macros - help needed (18 replies)
  92. User-Defined Type Not Defined Error (9 replies)
  93. [SOLVED:] if find the spicify word copy data (9 replies)
  94. Filter dates and blanks (1 replies)
  95. VLOOKUP with a SUM (1 replies)
  96. Index Match Match (1 replies)
  97. [SOLVED:] splitting a range to a variable number (2 replies)
  98. [SOLVED:] Extract numbers from text string (5 replies)
  99. calculate data and find outliers (2 replies)
  100. VBA-code Import from website to excel (0 replies)
  101. Please help spot the error!!! (2 replies)
  102. [SOLVED:] Find and extract information from multiple excel files (1 replies)
  103. Paste values copied from a webpage (4 replies)
  104. VBA to stop dsiplaying the debugging option on pressing CTRL+Pause Break (2 replies)
  105. [SOLVED:] How to make Todays Date visible on Pivot Table Filters (1 replies)
  106. VBA Code Help Needed. Lookup Value Ranges (0 replies)
  107. Save As PDF in a particular order (1 replies)
  108. Calculating difference between months (3 replies)
  109. TimeSerial does not reflect Windows Regional Settings (3 replies)
  110. [SOLVED:] Help with vba Code (5 replies)
  111. Opening multiple doc/html files into excel worksheets within a single workbook (1 replies)
  112. [SOLVED:] Look For Sheets Wildcard no Loop (5 replies)
  113. [SOLVED:] Scoring data by finding duplicate names. (2 replies)
  114. [SOLVED:] Excel VBA - Open Word template and create bulleted list based on cell values (10 replies)
  115. VBA script to help sort and distribute data (3 replies)
  116. Searching for multiple values in string (9 replies)
  117. [SOLVED:] REFERENCING A VARIABLE FORM NAME (5 replies)
  118. Checking in a Document in SharePoint from Excel Macros (0 replies)
  119. Vba to copy excel worksheet orientation to word document (5 replies)
  120. [SOLVED:] Failing miserably at populating combobox (6 replies)
  121. Change value of adjacent cell if field in form matches (4 replies)
  122. Issue with pictures upload using vba code into excel- they disapear (1 replies)
  123. Reoccurring Data Transfer (2 replies)
  124. Compiling data questions (3 replies)
  125. Which copy/paste option (2 replies)
  126. HELP - SUMIF more than 3 conditions + operations in the sum (1 replies)
  127. Clear styles error (2 replies)
  128. Highlight Adjacent Cells Above Highlighted Cell (2 replies)
  129. [SOLVED:] Generating formula for summing time / date values. (8 replies)
  130. Enhancement of "Find text in Workbook and create link to cells" (2 replies)
  131. HELP! application.filesearch wont work in excel 2010 (2 replies)
  132. [SOLVED:] Help need to inser Carriage return in chart series name. (5 replies)
  133. VBA to run formula on Selected cells (1 replies)
  134. VBA for calculations (3 replies)
  135. Real-Time plus Countdown Timer (2 replies)
  136. Excel VBA Multiple Automatic Goal Seek Required – Please Assist us (2 replies)
  137. VBA Small Weather Forecast Spreadsheet (11 replies)
  138. populating dynamic arrays from a dynamic array (1 replies)
  139. [SOLVED:] Connecting to Access 2010 (3 replies)
  140. [SOLVED:] Weeks and Months (7 replies)
  141. VBA dropdown help (1 replies)
  142. [SOLVED:] VBA Timer? (3 replies)
  143. Chart pop up (19 replies)
  144. Macros/VBA to do a loop and insert text (2 replies)
  145. [SOLVED:] Link to Word document (4 replies)
  146. New to VBA! Code for a sales calculator, how to output tables to user interface? (5 replies)
  147. Need help improving this VBA Code to make it run faster (3 replies)
  148. Delete all Datalabels on Chart Except Current Dates (4 replies)
  149. [SLEEPER:] Excel crashing every time I run my macro (1 replies)
  150. Funny Formating (1 replies)
  151. scheduled task & can't create outlook object (17 replies)
  152. [SOLVED:] Fill Userform textbox after clicking in sheet (return column number) (10 replies)
  153. [SLEEPER:] How to make print area fit entire page? (2 replies)
  154. Regex expression to retrieve data from HTML (4 replies)
  155. [SOLVED:] Looking for similar value (8 replies)
  156. VBA codes to draw charts with data from multiple sheets (3 replies)
  157. VBA Code for VLOOKUP (2 replies)
  158. [SLEEPER:] VBA code finding duplicates in two Excel column. (2 replies)
  159. Help Getting Started (New Project) (4 replies)
  160. SQL Server Connection problem (5 replies)
  161. [SOLVED:] Show userform without showing excel (1 replies)
  162. Help! Error whilst record Macro ""Too many line continuations" (2 replies)
  163. (VBA) Conditionnal formatting with multiple conditions (3 replies)
  164. [SOLVED:] Splitting first, middle initial, and last name (3 replies)
  165. [SOLVED:] Looping through cutting and pasting values between two dates (33 replies)
  166. Sheet Reference based on a Cell Value??? (1 replies)
  167. [SOLVED:] Sending OutLook message no Attachment (2 replies)
  168. Add-in uninstalls after running on a CSV file (2 replies)
  169. Read Data From Excel File W/O Opening (0 replies)
  170. Extract specific data from a website (4 replies)
  171. [SOLVED:] Diary System - automation (7 replies)
  172. VBA for Import worksheet Selected Range Data from Another Closed workbook (0 replies)
  173. Efficiency Help (14 replies)
  174. 'Double' Random Selection in VBA (10 replies)
  175. Strange behavior of for... next loop (4 replies)
  176. Hi there (2 replies)
  177. Automate copying rows based on counter number increment (2 replies)
  178. How to apply the colour of a cell to another when its an exact duplicate (1 replies)
  179. [SOLVED:] FileDateTime Question (1 replies)
  180. Web Service Call and Authentification (0 replies)
  181. Cant access functions from a VBA add in (7 replies)
  182. [SOLVED:] Count functions, mostly at COUNTIF() Question (5 replies)
  183. Writing a loop with an offset and storing value in code while summing (2 replies)
  184. [SOLVED:] Formula (2 replies)
  185. [SOLVED:] Tab Button Control (9 replies)
  186. Sheet Reference error (1 replies)
  187. [SOLVED:] Code Not Iterating Each Worksheet (3 replies)
  188. [SOLVED:] Extracting values from cell where total has been rounded (13 replies)
  189. Looping through and Deleting data in Pivot chart (2 replies)
  190. [SOLVED:] Macro needs to recognize existing filename (3 replies)
  191. [SOLVED:] Is Variable Allocated (13 replies)
  192. Run-time error '429': ActiveX component can't create object (7 replies)
  193. On Error Issues (6 replies)
  194. Write a total number of hours each month into appropriate cell (4 replies)
  195. match multiline textbox item to coumn B3 in excel (2 replies)
  196. [SOLVED:] Using Items sequence numbers in order (7 replies)
  197. Create Combined Table from 2 Tables (2 replies)
  198. Creating a Macro to sort data (2 replies)
  199. [SOLVED:] Iterate Directory's Opening Workbook (22 replies)
  200. [SOLVED:] Microsoft Delpoyment Summary legit? (1 replies)
  201. VBA vlookup value not formula (1 replies)
  202. Wildcards with Index Match Match (0 replies)
  203. Open a txt file (3 replies)
  204. [SOLVED:] Find "PR" in column O then color cell and msgbox (3 replies)
  205. [SOLVED:] Vba Cut Paste By Criteria (9 replies)
  206. Vlookup Error (3 replies)
  207. [SOLVED:] vba to check if folder exists in SharePoint and if not then create folder (10 replies)
  208. Find columns based on header names and make the column proper (4 replies)
  209. [SOLVED:] Copy down values with VBA (1 replies)
  210. Is this possible in VBA ????? ( rexx interpret command) (2 replies)
  211. Blank cell not really empty when copy and paste from different projectsheets (5 replies)
  212. Specifying filter according to date (10 replies)
  213. [SOLVED:] Repeat Procedure (6 replies)
  214. Macro to pull calendar appointments from outlook into excel (2 replies)
  215. Reorganizing data (5 replies)
  216. populate word doc (1 replies)
  217. Convert Word document in HTML via Excel (1 replies)
  218. [SOLVED:] Finding matches coloring them and the color of the sheets (7 replies)
  219. highlight entire rows when two cells in row are populated (2 replies)
  220. place 0 before numbers in a string (13 replies)
  221. Data Entry UserForm for Excel 2007 (12 replies)
  222. IF and OR .... Can't seem to work it out. (4 replies)
  223. [SOLVED:] Excel is forcing numbers on me! (4 replies)
  224. [SOLVED:] vlookup help needed (3 replies)
  225. Error handling not working (5 replies)
  226. Automate capturing a particular columns using VBA (2 replies)
  227. VBA worksheet change event (1 replies)
  228. Need VBA code to display 1st PRIME number greater than value (N) (4 replies)
  229. [SOLVED:] Type Mismatch Error 13 in Using Range and Offset (1 replies)
  230. Referencing a column in AVERAGEIFS function in excel (1 replies)
  231. [SOLVED:] Access to info in Status Bar when in autofiltermode (4 replies)
  232. EXCEL: Data Validation With Case Sensetive. (10 replies)
  233. Update master workbook if does not match multiple columns (1 replies)
  234. change event (0 replies)
  235. VBA to filterthen copy cells from sheet1 then paste vlaue to sheet2 destinated cells (0 replies)
  236. [SOLVED:] Compare two lists First Name Last Name - If both match add Email Address (3 replies)
  237. consolidate with two criteria uisng VBA (0 replies)
  238. [SOLVED:] Help with formula please (2 replies)
  239. Copy Range from active row to new sheet (3 replies)
  240. [SOLVED:] Help with excel formula (4 replies)
  241. Sleeper: Finding and adding up values (0 replies)
  242. Vba Pivot table (4 replies)
  243. [SOLVED:] Compile error: Type mismatch: array or user-defined type expected (4 replies)
  244. Pivot Table Link Help (1 replies)
  245. [SOLVED:] VBA to create Table of Content but EXCLUDE xlSheetHidden andxlSheetVeryHidden (2 replies)
  246. Check a list of names, if a worksheet exists move on, if not, create one (8 replies)
  247. Excel Module to find() and assign variables (3 replies)
  248. [SOLVED:] Colour cell in column F if any value in cloumn J (2 replies)
  249. How Do I Get An Excel Sheet That Validates And Then Emails? (4 replies)
  250. Copy range and paste depending on the selected checkbox (1 replies)