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. Extracting minimum and maximum points above and below moving average (9 replies)
  2. [SOLVED:] Ranking like values the same, but not omitting the next rank number? (4 replies)
  3. [SOLVED:] Using VBA code to change value of a checkbox in a cell (2 replies)
  4. excel vba range property non contiguous ranges (4 replies)
  5. [SOLVED:] Run-time error '13': type mismatch VBA code (1 replies)
  6. [SOLVED:] Ribbon Issue (15 replies)
  7. Offset selection by 3 columns? (4 replies)
  8. [SOLVED:] Excel VBA to print 3 copies of sheet if it finds something in cell A2. (2 replies)
  9. Replacing "/" with nothing -VBA (3 replies)
  10. Autofill a resize range (1 replies)
  11. Open Multiple Files in a Folder, List file name, and calculate Average of Column (19 replies)
  12. Using Index match in VBA returns wrong value (13 replies)
  13. Looping Through Worksheets (34 replies)
  14. [SOLVED:] Help w/combining excel actions (0 replies)
  15. cut entire row and paste many times as quantity - Tables (0 replies)
  16. VBA "Object doesn't support this method" HELP!! (4 replies)
  17. Countif Synthax (3 replies)
  18. Remove blank cells to left if condition (2 replies)
  19. [SOLVED:] VBA to pull values from cells off of second sheet (3 replies)
  20. [SOLVED:] Naming a Range (VBA) (1 replies)
  21. [SOLVED:] Copy rows and paste them to new sheet (3 replies)
  22. Speed Up Get Data Code (15 replies)
  23. [VBA]:How to use VBA to merge 2 sheets into one with the same ID (4 replies)
  24. Script to Change Chart Titles (4 replies)
  25. [SOLVED:] What I'm doing wrong??? (7 replies)
  26. [SOLVED:] copy from one sheet to another sheet based on column names (20 replies)
  27. SumIf in vba returns 0 value in userform (1 replies)
  28. [SOLVED:] Where is the error in this short code?? (3 replies)
  29. Extract specific values in text files and paste to Excel (3 replies)
  30. Numbered Text boxes managed by Loop or for? (0 replies)
  31. [SOLVED:] Split a Text File - Rename With the Original Text Heading Found in file (8 replies)
  32. Select and delete entire columns (3 replies)
  33. VBA assign random variables to cells (1 replies)
  34. can't run a simple recorded macro (6 replies)
  35. [SOLVED:] Arranging groups of numbers into a normal distribution (8 replies)
  36. Need help implementing UserInterFaceOnly:=True (2 replies)
  37. join multidimensional array vba (1 replies)
  38. [SOLVED:] Find with additional requirement (5 replies)
  39. [SOLVED:] Match Funtion Help (2 replies)
  40. [SOLVED:] VBA to insert Now() when formula result changes (7 replies)
  41. Converting xls formula to VBA function (7 replies)
  42. 3-dimensional grid search (1 replies)
  43. Find Search with Msg PopUp (4 replies)
  44. [SOLVED:] Need help need VBA to build combinations from values from structured data (33 replies)
  45. WaterFall Chart - Up/Down Bars (0 replies)
  46. CopyPicture method of Range class failed (18 replies)
  47. Find a particular text in column A and copy the value from next column and transpose (2 replies)
  48. VBA code for distributing items having different weight and time to different slots (4 replies)
  49. Vba Outlook license reminder notification (0 replies)
  50. VBA Google Search Scraper/Extract (1 replies)
  51. PrintToFile Problem (0 replies)
  52. Extract web data (0 replies)
  53. [SOLVED:] VBA to copy last row of one sheet onto another sheet (16 replies)
  54. VBA to delete rows *partial text* (1 replies)
  55. Export excel sheet to .txt, reformat to .dat. But format changes in Linux (6 replies)
  56. Converting Values from one spreadsheet, and turning it into an XSLT code. (0 replies)
  57. Compare Dates within Textboxes in Userform (3 replies)
  58. Link button to table row for sorting (0 replies)
  59. Need to direct my appointment a non default calendar (1 replies)
  60. Delete record from listview and excel sheet at the same time and apply duplicate prev (0 replies)
  61. how to minimize sum with macros (1 replies)
  62. [SOLVED:] Format all my Command Buttons The Same - Retain Press Color Change Individual Button (21 replies)
  63. VBA Code: ascending order of the columns (4 replies)
  64. [SOLVED:] listbox items = column headers macro (5 replies)
  65. [SOLVED:] Identify 7 day separation between product calls (9 replies)
  66. Pull data from Word to Excel help (3 replies)
  67. [SOLVED:] Textbox .ColumnWidths without trial and error? (9 replies)
  68. Insert value after matching with existing cell (7 replies)
  69. Creating chart by searching input datas in different worksheets (2 replies)
  70. copy/paste values only between 2 tabs (3 replies)
  71. forcing excel sheet to save it as .xlsm (4 replies)
  72. [SOLVED:] Export Each Excel Row Text - to PPT (15 replies)
  73. [SOLVED:] Copying and Pasting through Ranges of Varying Lengths (3 replies)
  74. [SOLVED:] VBA Power Programming 2007 - Disk Examples (3 replies)
  75. [SOLVED:] VBA to run a Linear Regression Automatically (16 replies)
  76. Combine multiple sheets from multiple workbooks to a single workbook of multiple work (2 replies)
  77. [SOLVED:] Application.Onkey (7 replies)
  78. [SOLVED:] Move up cells less than row value (4 replies)
  79. [SOLVED:] Find First Cell in Column Containing non-NULL Data (6 replies)
  80. Fix Broken Code (8 replies)
  81. Paste with offset from a different sheet VBA (5 replies)
  82. Recording results of multiple runs using VBA (4 replies)
  83. How to close the all excel workbooks once i open a one excel workbook (1 replies)
  84. [SOLVED:] VBA/ Checkbox to add/remove fields in pivot (4 replies)
  85. [SOLVED:] Cell Returns no value even though the cell does contain a value (4 replies)
  86. [SOLVED:] macro to hyperlink excel cells to pdfs (12 replies)
  87. Removing blank lines from report calculated by macro (9 replies)
  88. convert text with (.) to number with (,) (7 replies)
  89. [SOLVED:] Search left from specific column eg. "y" (9 replies)
  90. Pulling Data from Web - page still loading (0 replies)
  91. [SOLVED:] Import worksheet based on filename and date (12 replies)
  92. Help with macro for filter (2 replies)
  93. [SOLVED:] Get latitude and longitude from Bing using VBA (16 replies)
  94. Shape Conditional Formatting & Permanent Logged In User, Date & Time Stamp (2 replies)
  95. [SOLVED:] Finding the Sum of Numbers between words in the entire workbook. (5 replies)
  96. How to Go to Next Row on a UserForm (7 replies)
  97. [SOLVED:] VBA/VBE Weird behavior when deleting a code line in a sub using a different sub (2 replies)
  98. VBA Code: Use keyboard keys in VBA coding (2 replies)
  99. VBA Code - If Code #1234 found in ColumnA then result code 5678 return in ColumnC (12 replies)
  100. Help with code to determine whether two strings are in a cell (1 replies)
  101. Compare 2 multi-arrays and isolate duplicate into 3rd array (3 replies)
  102. [SOLVED:] Add a sort filter to existing code (1 replies)
  103. Help putting border around a range (3 replies)
  104. Color issue confusing me (7 replies)
  105. [SOLVED:] index match function & IF to exclude few values (1 replies)
  106. VBA Excel data to Powerpoint (5 replies)
  107. Userform With Multiple Independent Combobox (delete row when not match) (1 replies)
  108. Search through a number of files for keywords and return associated data. help! (5 replies)
  109. [SOLVED:] Clear contents before replacing text (7 replies)
  110. Move cell values and buttons up from application caller (0 replies)
  111. Copy sheets from file to another but Not Copying those that already exist in 2nd file (1 replies)
  112. [SOLVED:] VBA Code to Insert a Row (13 replies)
  113. [SOLVED:] Move data from one sheet to another and export (11 replies)
  114. Merge and Append 95 Workbooks into One Workbook (10 replies)
  115. Turning Auto Calcs into Run by Button (11 replies)
  116. [SOLVED:] Dynamically Color Coded excel rows (3 replies)
  117. [SOLVED:] VBA Code: If not in column A then Replace (5 replies)
  118. Problem to create an indexed array - M(1 to 1, 1 to 4){i} (20 replies)
  119. [SOLVED:] Copy value of cell if date matches the date of another sheet (7 replies)
  120. Running macros while logged off (3 replies)
  121. Delete row based upon Date (13 replies)
  122. [SOLVED:] Cannot unlink word header (4 replies)
  123. Small Script Edit - Pasting value in front of data set (1 replies)
  124. [SOLVED:] How can I remove duplicates from a dynamic range? (4 replies)
  125. Saving Row as Text file - Concatenate & Line Breaks Not Working (2 replies)
  126. [SOLVED:] Custom Function Needed for Evaluating Performance (3 replies)
  127. PROBLEM WITH SCROLL BOX INSIDE A FORM (10 replies)
  128. Running a PDF file from Excel (9 replies)
  129. HELP with Formula to calculate Interest Rate (7 replies)
  130. VBA Calling/Application.run with dynamic inputs + error handling (5 replies)
  131. [SOLVED:] Question with FSO filtering - snb (2 replies)
  132. How to Shell to other Application with excel vba (0 replies)
  133. VBA Code - Lookup column1 in Column2 (3 replies)
  134. [SOLVED:] PivotTable field name is not valid when changing source data (1 replies)
  135. [SOLVED:] [VBA] Pasting data in Word looping for no apparent reason (8 replies)
  136. Excel 2013 - VB Script to save and e-mail form (0 replies)
  137. Concatenate in VBA (4 replies)
  138. [SOLVED:] Add Dates to Printed Header (15 replies)
  139. Multi-step workbook/sheet automation with VBA, macros, INDEX MATCH combination (3 replies)
  140. VBA Importing a sheet from a closed excel workbook (3 replies)
  141. [SOLVED:] Change Numbers to Words (12 replies)
  142. [SOLVED:] FSO filtering on the fly (24 replies)
  143. Error When Testing Collection for Key Exists (7 replies)
  144. VBA CODE- Match 2 cells and display the result (9 replies)
  145. Moving sheets to a new workbook (9 replies)
  146. Excel Duplicates (5 replies)
  147. Copy and Enter Current Record Displayed in Userform a # of Times to WS (0 replies)
  148. [SOLVED:] VBA Sheet Protection Failing (2 replies)
  149. SaveAs xlText (tab delimited text): delete empty line at the end (7 replies)
  150. [SOLVED:] Max value in array and return adjacent column (similar to offset/match in excel) (6 replies)
  151. [SOLVED:] VBA Set Variable equal to macro function (2 replies)
  152. VBA Form inserting dates in the wrong format (2 replies)
  153. create a worksheet based on description (8 replies)
  154. [SOLVED:] Open Latest Outlook email by Received Date (17 replies)
  155. Sort on multiple dynamic columns using excel VBA (0 replies)
  156. [SOLVED:] How to add a label to one selected data point in an xy scatter chart (0 replies)
  157. Build new Nested Loop in VBA (0 replies)
  158. [SOLVED:] User Form .SetFocus Help (9 replies)
  159. excel says it cant find the file I just DoubleClicked (0 replies)
  160. Determine if all files in a folder were created today (2 replies)
  161. Loop within a loop vba (1 replies)
  162. Date Validations using VBA code (6 replies)
  163. Sleeper: Look up records in Access from Excel and copy data to cell (1 replies)
  164. [SOLVED:] import txt or csv delimited parts into different excel sheets (6 replies)
  165. Data from Excel to Word 07 Bookmark (0 replies)
  166. I Need an Array Formula? (6 replies)
  167. Return the value below the cell that contains a specific string (3 replies)
  168. If dropdown only contains one option, automatically show that option - How???? (6 replies)
  169. Vba to insert text in range of cells (10 replies)
  170. [SOLVED:] macro to take values from range to slicers (5 replies)
  171. Split certain cells to multiple sheets IF value (8 replies)
  172. Help with a code for a picker (1 replies)
  173. How to Pass an array of implement(ed) object(s) to a sub/function? (12 replies)
  174. Create new sheet (4 replies)
  175. [SLEEPER:] Create Summary (1 replies)
  176. [SOLVED:] Vlookup using Vba code across two tabs (4 replies)
  177. Help vba code for a formula in two cells (1 replies)
  178. [SOLVED:] via code to use to 6, 8, 12 sheets (19 replies)
  179. VBA Help - Excel Range (text) to Word Bookmark (1 replies)
  180. Pull data from webpage (0 replies)
  181. [SOLVED:] Pulling specific lines from a text file into Excel (1 replies)
  182. [SOLVED:] Advise on "Best" or "Better" practices (5 replies)
  183. [SOLVED:] How to set the SubTotal TotalList using a variant instead of an array (5 replies)
  184. How do I copy Internet Most Visited Places shortcuts to an Excel sheet ? (0 replies)
  185. Develop a macro to solve below problem (13 replies)
  186. PDF Data to Excel Adobe XI (0 replies)
  187. how to open protected view excel file using VBA macro (1 replies)
  188. Help with VBA code Transfer excel range to Word bookmark (5 replies)
  189. Linking Content of Wkbk1 to Wkbk2, Extract filtered information into table in wkbk2 (0 replies)
  190. Userform calls other userform, then populate worksheet (0 replies)
  191. VBA: Text from Excel to Word with formatting (0 replies)
  192. Revising a code that inserts a new option column upon execution of an option button (2 replies)
  193. VBA Multi Select ListBox Issues (15 replies)
  194. VBA code for entering a formula not as expected (1 replies)
  195. Linear programming using solver in Excel 2000 (6 replies)
  196. Conditional wrap line - VBA Excel (3 replies)
  197. [SOLVED:] TRYING TO UNDERSTAND HOW EXCEL VBA MACROS AND USER FORMS ARE LINKED TO EXCEL FILES (24 replies)
  198. search in another excel file with VBA (1 replies)
  199. Return Last April using VBA (6 replies)
  200. nervous! How To Import Data From SQL Query To VBA Coding? (7 replies)
  201. Macro to combine columns without formulas (11 replies)
  202. Defining Dynamic Named Ranges with VBA (6 replies)
  203. Copy-Paste rows from multiple worksheets into a new workbook based on unique id (2 replies)
  204. Using vba to automate a Microsoft Word document with data imported from a Excel sheet (0 replies)
  205. Create different text files from parts of a range (6 replies)
  206. Prompt/Store value based on a selection/entry (7 replies)
  207. [SOLVED:] Pivot Table VBA (1 replies)
  208. Excel Recursive function through XML file (1 replies)
  209. [SOLVED:] Employee schedules, 15 minutes interval table [working/slow; need alternative ideas] (10 replies)
  210. [SOLVED:] Nested Loop in VBA (9 replies)
  211. [SOLVED:] VBA Edit to Search Range (2 replies)
  212. Can you help fix this macro? (5 replies)
  213. Macro to Transpose data (7 replies)
  214. I need help with this VBA exam example (2 replies)
  215. how to get the directory (file save) when the macro is run the first time in the day (4 replies)
  216. Code to sum columns in lastrow +1 (7 replies)
  217. [SOLVED:] Odd error when comparing times with "dateadd" (7 replies)
  218. [SOLVED:] Find and Open an email in Outlook (4 replies)
  219. [SOLVED:] Auto-remove duplicates from dynamic list (11 replies)
  220. [SOLVED:] Use Cell Value to go offset to another cell (1 replies)
  221. Establishing comm link with Eicon Aviva from Excel VBA (4 replies)
  222. Using VBA to send emails via outlook using excel cells (1 replies)
  223. [SOLVED:] Excel 2010 How to Create a Custom Toolbar and Distribute to 50+ Users (1 replies)
  224. [SOLVED:] Max Row Index for an Array (5 replies)
  225. 2003 sorting code not working in 2010 (1 replies)
  226. [SOLVED:] SUMIF with Left criteria VBA (3 replies)
  227. Loop for copying values from excel file to fill sentences in Word (6 replies)
  228. What if analysis in Median (formula help required) (2 replies)
  229. How to Allocate ER Credit with VBA (7 replies)
  230. VBA to copy down information into blank row (2 replies)
  231. Help: How to Find and Replace VBA Code with VBA Code? (4 replies)
  232. [SOLVED:] Application.FileSearch Help (19 replies)
  233. [SOLVED:] write data consecutively if certain cell is not empty (12 replies)
  234. [SOLVED:] Aligning a chart textbox with a variable datapoint (2 replies)
  235. [SOLVED:] VBA: Importing data from one worksheet to another returns "TRUE" (4 replies)
  236. [SOLVED:] Modification to copy VBA code (2 replies)
  237. [SOLVED:] Filter Data Using Macro (5 replies)
  238. [SLEEPER:] Syntax for unique values (3 replies)
  239. [SOLVED:] save one large file as separate text files (6 replies)
  240. [SOLVED:] Transformation of data with macro (4 replies)
  241. [SLEEPER:] How to avoid Circular reference in a Range (6 replies)
  242. [SOLVED:] Unable to locate named range in code (2 replies)
  243. google poly line encoding in excelR (3 replies)
  244. [SOLVED:] AdvancedFilter displaying Unique values. (8 replies)
  245. Open a file from browse window and perform VLOOKUP (0 replies)
  246. Multiple Command Buttons & results in a new sheet. (0 replies)
  247. Looping a macro until the formula within the macro results in an acceptable output (1 replies)
  248. Copy Charts from Excel to power point 2007 and save as. (10 replies)
  249. VBA formula (4 replies)
  250. [SOLVED:] vb to copy and paste based on criteria (11 replies)