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. help with complicated formula (60 replies)
  2. Deselecting a single pivot table item which is referenced in a specific cell (0 replies)
  3. [SOLVED:] Export worksheet to new workbook and restore original sheet (3 replies)
  4. Create Unique Values List From Named Range (4 replies)
  5. [SOLVED:] GoalSeek by VBA (4 replies)
  6. Duplicate data sets multiple times in VBA (7 replies)
  7. VBA Set cell value under last row (2 replies)
  8. looking help (4 replies)
  9. Date -> numeric translation issue (5 replies)
  10. Auto Name a workbook (13 replies)
  11. New to VBA, trouble with an If Else Then statement (4 replies)
  12. Need Some Change In Count Macro Running Code (3 replies)
  13. [SLEEPER:] Create sheet if it doesn't exist problem (7 replies)
  14. Formulate average count of DISTINCT records (4 replies)
  15. Export array values to Excel (10 replies)
  16. Refresh data in closed excel workbook (3 replies)
  17. VBA to auto-add rows to 3 Tables (or one and auto-resize 2) (1 replies)
  18. [SLEEPER:] Excel VBA macros - webquery (12 replies)
  19. How to extract filename from a folder which is on a netwrok drive (6 replies)
  20. [SLEEPER:] VBA code to open folders and pdf file inside the folders (32 replies)
  21. VBA export of specific rows (4 replies)
  22. Uncheck Chckbox in Protected Sheet (2 replies)
  23. Find Duplicates and Highlight Row in Red (4 replies)
  24. How to best count? (8 replies)
  25. Operation with dates (6 replies)
  26. Consolidate Data Using VBA (7 replies)
  27. Save text file as unicode from Excel VBA (2 replies)
  28. Check for a condition in a Do Unil Loop (9 replies)
  29. Cells(x,x) = 1 ? (6 replies)
  30. VBA Code - Autofill with a Dynamic Range (7 replies)
  31. SUMPRODUCT double counting (1 replies)
  32. non vba save as dialogue box (2 replies)
  33. footer (3 replies)
  34. Query SQL through VBA (2 replies)
  35. Initializing a userform from another userform? (8 replies)
  36. VBA CODE - SEARCH AND COPY (8 replies)
  37. Add Dynamic Option and loop to my code (1 replies)
  38. Save Breakpoints (1 replies)
  39. Solved: Range("FilterArea") (1 replies)
  40. Any suggestions on making this code faster (1 replies)
  41. Scrape data from website to excel - VBA (0 replies)
  42. Solved: Call CMD.EXE and send instructions (5 replies)
  43. Compare & Fill Data Help Needed ! (27 replies)
  44. Solved: Help transfer from Multi Column ComboBox to worksheet non ajacent columns (7 replies)
  45. Excel, VBA, Send Email (1 replies)
  46. VBA on a MAC (4 replies)
  47. Macro Speed Up - Help (9 replies)
  48. Counting Unique Values across multiple rows (2 replies)
  49. Solved: Save As Web Page plz plz help (2 replies)
  50. on each page, highlight the first cell on column A (8 replies)
  51. Application Defined or Object Defined Error (3 replies)
  52. VBA OF EMAIL FROM EXCEL (2 replies)
  53. [SLEEPER:] Compare, Match And Copy Data Row (23 replies)
  54. Solved: Learning! (2 replies)
  55. Solved: Automatically Open Files On Folder Select (8 replies)
  56. Autimatize worksheet names (3 replies)
  57. vba code import table excel to mysql (51 replies)
  58. Hostname to IP (1 replies)
  59. Sorting an array from small to large with an error twist! (5 replies)
  60. Conditionally Format cells in a row based on the sum of the previous nth cells. (15 replies)
  61. Automated Macros (5 replies)
  62. [SOLVED:] Need Help About Check Boxes (8 replies)
  63. Check SharePoint if file exists (2 replies)
  64. Lost on VBA HELP! (1 replies)
  65. Compile Error Variable Not Defined (2 replies)
  66. Import several text files into an excel file with macro (6 replies)
  67. Need to create VBA to transfer data in between workbooks (1 replies)
  68. Using Excel Solver (0 replies)
  69. Histogram help (1 replies)
  70. Split worksheet into multiple tabs (10 replies)
  71. [SLEEPER:] Pasting data from Excel into multiple Notepad Sessions (6 replies)
  72. Working with three workbooks (4 replies)
  73. Solved: Overflow Error in Code (3 replies)
  74. Solved: Finding a variable cell on another sheet for a formula (12 replies)
  75. Help transfer from ListBox to worksheet non ajacent columns (5 replies)
  76. Help Building A Fully Functioning Excel Add-In (1 replies)
  77. Solved: Code for Protecting a Specific Sheet in a Workbook with a Password on Exit (4 replies)
  78. Solved: Cut data before first space (13 replies)
  79. [SOLVED:] Export to PP (3 replies)
  80. Trying to copy paste and delete a row (20 replies)
  81. [SOLVED:] VBA to extract data from file in use (5 replies)
  82. Problem in replacing macro (5 replies)
  83. Importing data from a website into Excel (1 replies)
  84. pulling data from multiple sheet on to one sheet with specific value (3 replies)
  85. Solved: can I change some options when using PrintForm !!!! (6 replies)
  86. Solved: Rainflow Three-Point Algorithm (10 replies)
  87. Solved: Using Statemant CASE to delete rows in multiple sheets (15 replies)
  88. Problems with merge fields (8 replies)
  89. Solved: Skip cells (4 replies)
  90. Solved: VBA, checkbox, reporting and sum (5 replies)
  91. Extract Data From Alibaba Website (4 replies)
  92. by click on cell of column a the color of row change (3 replies)
  93. Solved: Change/Update Defined Names 'Ranges' (multiple) in Name Manager (9 replies)
  94. graph /objects protection/unprotect (3 replies)
  95. Worksheet entry help (3 replies)
  96. time and date in the excel cell (5 replies)
  97. Using Index Match, adding to the bottom of the row those that are missing (1 replies)
  98. Solved: Option to extend trend line on graph (1 replies)
  99. Solved: Inserting cell value in formula (6 replies)
  100. Solved: VBA issue (2 replies)
  101. Solved: Date Format (4 replies)
  102. Retrieve data from Access (1 replies)
  103. Manipilating an ASCII string in VBA (1 replies)
  104. Solved: Using VBA to Log In Members with a Username and Password stored within the Workbook. (10 replies)
  105. Download Data From Internet using Excel macro (5 replies)
  106. Value field appearing above row labels pivot table (2 replies)
  107. book (4 replies)
  108. Histograms in excel 2013 (1 replies)
  109. Code to automatically add new email address to a table (1 replies)
  110. Save Excel to PDF one page wide (4 replies)
  111. VBA export of cells with variable range (1 replies)
  112. Solved: Sum unique values in a range (9 replies)
  113. Code for not add the data in Sheet2 if all cells in range in Sheet1 are not filled (1 replies)
  114. Working with text for a report (5 replies)
  115. animated chart (1 replies)
  116. Who has a file open on SharePoint (0 replies)
  117. [SOLVED:] Check for presence of VBA Procedure in all modules (4 replies)
  118. [SLEEPER:] Pivot relationships (1 replies)
  119. Cashflow Present Value Calculation (2 replies)
  120. Two doubts on some (i think) simple codes (10 replies)
  121. Solved: Delete a six-row block which occurs every n rows (5 replies)
  122. Solved: Continue Macro after Error Handler (4 replies)
  123. Help - Automate Pivot Filter Changes (2 replies)
  124. [SLEEPER:] Pulling custom footer from another sheet, to only appear on *final* page (8 replies)
  125. Solved: Lock Cells (Excel 2010) (5 replies)
  126. Solved: Pull data from other sheets (6 replies)
  127. Solved: Storing Values/Data beyond a subroutine (13 replies)
  128. Solved: Removing a item from a listbox (5 replies)
  129. Solved: Send Data to different workbook (2 replies)
  130. Finding data in a range (6 replies)
  131. Problem with IE automation - getElementsByTagName (0 replies)
  132. Function to Return an Array (8 replies)
  133. Loop to combine data in 2 columns and insert string every 145 combinations (1 replies)
  134. SUM variable range LOOP (9 replies)
  135. Load text files to ONE sheet (1 replies)
  136. [SOLVED:] How to write a vba code (9 replies)
  137. Conditional Paste (2 replies)
  138. Solved: Help Importing multiple XML files - VBA (9 replies)
  139. How to find exact substring within a cell (2 replies)
  140. Loop through files in a directory and delete if not currently in use (19 replies)
  141. Solved: Use Index, Match, and Max VBA (1 replies)
  142. How to count number of red color in a row (32 replies)
  143. Axis Rounding (decimals, tens, hundreds, etc.) (0 replies)
  144. Solved: match 2 columns and display 3rd column value (2 replies)
  145. Solved: Dir function skipping the first file (4 replies)
  146. HELP! (11 replies)
  147. WHATS IT TAKE TO GET A ANSWER (5 replies)
  148. Solved: Sum a column B where column A is the same in two different sheets (8 replies)
  149. Detecting Multiple Active Sheets (1 replies)
  150. Multiple goal sheek code error (1 replies)
  151. Linking Combo boxes (3 replies)
  152. Solved: Make a Summary Sheet (17 replies)
  153. Refresh Data Connections in VBA then Message Box (3 replies)
  154. [SLEEPER:] Close IE using Caption Name (1 replies)
  155. Pictures - Grouping and Flip (0 replies)
  156. Find all black cells in a range (3 replies)
  157. Solved: VBA help (5 replies)
  158. VBA script to move files from one folder to 3 and populate list of files (2 replies)
  159. Solved: Problem with Proper Case (2 replies)
  160. Combining "Force users to enable macros in a workbook" and "Disable Cut, Copy, Paste" (8 replies)
  161. Solved: Another Dynamic Range Question (4 replies)
  162. [SOLVED:] Object Required For Parameter (3 replies)
  163. Naming Array (5 replies)
  164. Pop-up Error Message (4 replies)
  165. First Factor Formula (6 replies)
  166. Auto-insert comment, auto insert date and time (6 replies)
  167. Solved: vba auto row insert and revert back (20 replies)
  168. Merge “Paste Values only” VBA code with “force macros” VBA code and place the code in (4 replies)
  169. VBA to autofilter on current date (8 replies)
  170. Solved: Need VBA code to split quantities based on availability in another table (2 replies)
  171. How to move a cells value to a diffrent sheet with a check box (6 replies)
  172. Validating repeated values, then bring the result to another cell (9 replies)
  173. Macros to Import Keyword file (3 replies)
  174. Staying on Current Sheet (7 replies)
  175. [SOLVED:] Enable users to click"+" to group/ungroup in a protected sheet - VBA (6 replies)
  176. Date Separater (2 replies)
  177. Enable grouping and Ungrouping in Protected Sheet - VBA (3 replies)
  178. Problem with declaring variables (1 replies)
  179. Sleeper: Capture old value of cell before change! (5 replies)
  180. auto saving a file using a number value from a cell in the spreadsheet (11 replies)
  181. To count values in a changeble range (10 replies)
  182. Could you tell me what is Excel VBA? (2 replies)
  183. How show msgbox in created Word Document (21 replies)
  184. VBA to consolidate multiple excel files into one (3 replies)
  185. Bulk Email address verification through macro? (12 replies)
  186. Copy from notepad and paste in Excel cells (12 replies)
  187. help please ASAP type mismatch error (3 replies)
  188. Pivot Table and Formula (3 replies)
  189. Translate index-match function to vba code (1 replies)
  190. Solved: Code to search for a Value in a Range (2 replies)
  191. inserting multiple drop down menus (1 replies)
  192. Solved: Question Box on Flowchart (3 replies)
  193. Send email based on a date (0 replies)
  194. Solved: data from Word form to excel sheet (10 replies)
  195. Include Filename in the Modified Macro (3 replies)
  196. [SOLVED:] Copy info of a name range (20 replies)
  197. searching data if id of column matches (3 replies)
  198. extract data from pdf to excel (7 replies)
  199. Solved: Creating and Sorting a Dynamic Range (7 replies)
  200. Global Address Link (1 replies)
  201. Vba Code Automatically Sort Large To Small (14 replies)
  202. only local SQL databases? (1 replies)
  203. naming charts (2 replies)
  204. Compare Column (4 replies)
  205. VBA error 1004- Glitch or Coding Error?! (1 replies)
  206. Solved: Create files and change properties (6 replies)
  207. Solved: Finding % usage of a word - w/filtering (2 replies)
  208. Find Page numbers on one sheet (footer) and paste on cells in a different sheet (3 replies)
  209. If a cell is NA then lock sheet - VBA (6 replies)
  210. Error Handling inconsistent? (14 replies)
  211. [SOLVED:] Multiple selection in Data validation list (2 replies)
  212. Creating a form on an excel worksheet and posting it to a data sheet in the same wkbk (1 replies)
  213. Change Font and Size in Excel Footer (3 replies)
  214. Downloading URL to SaveAs in Directory (5 replies)
  215. General Excel Question (1 replies)
  216. Exporting specific data to seperate files (2 replies)
  217. Solved: Using find and copy, but only want it to search in 1st column (4 replies)
  218. Search and Replace Macro for .txt files modification (6 replies)
  219. Solved: How to fast write Excel VBA array contents to a text file! (2 replies)
  220. Built my excel app but it's super slow (6 replies)
  221. Show Equation of Referenced Cell (7 replies)
  222. Creating an excel Save As button in a workbook. (13 replies)
  223. Solved: Excel Workbook Not saving (2 replies)
  224. Create "draggable" series name for chart created in VBA (1 replies)
  225. Solved: VBA Program to Compare 4 Columns in Excel (Required) (2 replies)
  226. Excel form that attaches file (1 replies)
  227. Allow end users to delete multiple rows within a range only - VBA (1 replies)
  228. Solved: Excel forces text into date format (4 replies)
  229. Solved: Lock unprotected cells, if a cell is changed - VBA (6 replies)
  230. Solved: Arrary Function, Not updating Correctly on Different Sheets (9 replies)
  231. Timer counter (1 replies)
  232. unable to set the currentpage property of pivot in vba (0 replies)
  233. VBA: Compile Error: "Invalid qualifier" (8 replies)
  234. copy value and insert new row then paste (2 replies)
  235. Userform help (4 replies)
  236. Get current web page title and output to cell (7 replies)
  237. Vlookup issue - How to change the source file without affecting vlook (1 replies)
  238. Solved: vba to insert formula using variable (6 replies)
  239. Solved: Filter Guide on "X" criterion on the "Y" result tab "Z" and "V" (4 replies)
  240. Sleeper: Copy values using auto filter more criteria with macro (6 replies)
  241. need to concentrate on VBA itself (7 replies)
  242. Solved: Last 10 Rows of a Range from a Closed Workbook (2 replies)
  243. Help to execute a word macro within a excel macro (2 replies)
  244. Help to copy and paste based on cell values (1 replies)
  245. Insert Row in new workbook (3 replies)
  246. Sorting columns containing checkboxes by values in header row (2 replies)
  247. After send email, write column already sent (8 replies)
  248. Find the largest value in a column, then copy and paste to a different workbook (5 replies)
  249. Conditional Formatting and VB (9 replies)
  250. Solved: Add autofilter to data on a worksheet that is not the active sheet (2 replies)