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. [SOLVED:] VBA Set Variable equal to macro function (2 replies)
  2. VBA Form inserting dates in the wrong format (2 replies)
  3. create a worksheet based on description (8 replies)
  4. [SOLVED:] Open Latest Outlook email by Received Date (17 replies)
  5. Sort on multiple dynamic columns using excel VBA (0 replies)
  6. [SOLVED:] How to add a label to one selected data point in an xy scatter chart (0 replies)
  7. Build new Nested Loop in VBA (0 replies)
  8. [SOLVED:] User Form .SetFocus Help (9 replies)
  9. excel says it cant find the file I just DoubleClicked (0 replies)
  10. Determine if all files in a folder were created today (2 replies)
  11. Loop within a loop vba (1 replies)
  12. Date Validations using VBA code (6 replies)
  13. Sleeper: Look up records in Access from Excel and copy data to cell (1 replies)
  14. [SOLVED:] import txt or csv delimited parts into different excel sheets (6 replies)
  15. Data from Excel to Word 07 Bookmark (0 replies)
  16. I Need an Array Formula? (6 replies)
  17. Return the value below the cell that contains a specific string (3 replies)
  18. If dropdown only contains one option, automatically show that option - How???? (6 replies)
  19. Vba to insert text in range of cells (10 replies)
  20. [SOLVED:] macro to take values from range to slicers (5 replies)
  21. Split certain cells to multiple sheets IF value (8 replies)
  22. Help with a code for a picker (1 replies)
  23. How to Pass an array of implement(ed) object(s) to a sub/function? (12 replies)
  24. Create new sheet (4 replies)
  25. [SLEEPER:] Create Summary (1 replies)
  26. [SOLVED:] Vlookup using Vba code across two tabs (4 replies)
  27. Help vba code for a formula in two cells (1 replies)
  28. [SOLVED:] via code to use to 6, 8, 12 sheets (19 replies)
  29. VBA Help - Excel Range (text) to Word Bookmark (1 replies)
  30. Pull data from webpage (0 replies)
  31. [SOLVED:] Pulling specific lines from a text file into Excel (1 replies)
  32. [SOLVED:] Advise on "Best" or "Better" practices (5 replies)
  33. [SOLVED:] How to set the SubTotal TotalList using a variant instead of an array (5 replies)
  34. How do I copy Internet Most Visited Places shortcuts to an Excel sheet ? (0 replies)
  35. Develop a macro to solve below problem (13 replies)
  36. PDF Data to Excel Adobe XI (0 replies)
  37. how to open protected view excel file using VBA macro (1 replies)
  38. Help with VBA code Transfer excel range to Word bookmark (5 replies)
  39. Linking Content of Wkbk1 to Wkbk2, Extract filtered information into table in wkbk2 (0 replies)
  40. Userform calls other userform, then populate worksheet (0 replies)
  41. VBA: Text from Excel to Word with formatting (0 replies)
  42. Revising a code that inserts a new option column upon execution of an option button (2 replies)
  43. VBA Multi Select ListBox Issues (15 replies)
  44. VBA code for entering a formula not as expected (1 replies)
  45. Linear programming using solver in Excel 2000 (6 replies)
  46. Conditional wrap line - VBA Excel (3 replies)
  47. [SOLVED:] TRYING TO UNDERSTAND HOW EXCEL VBA MACROS AND USER FORMS ARE LINKED TO EXCEL FILES (24 replies)
  48. search in another excel file with VBA (1 replies)
  49. Return Last April using VBA (6 replies)
  50. nervous! How To Import Data From SQL Query To VBA Coding? (7 replies)
  51. Macro to combine columns without formulas (11 replies)
  52. Defining Dynamic Named Ranges with VBA (6 replies)
  53. Copy-Paste rows from multiple worksheets into a new workbook based on unique id (2 replies)
  54. Using vba to automate a Microsoft Word document with data imported from a Excel sheet (0 replies)
  55. Create different text files from parts of a range (6 replies)
  56. Prompt/Store value based on a selection/entry (7 replies)
  57. [SOLVED:] Pivot Table VBA (1 replies)
  58. Excel Recursive function through XML file (1 replies)
  59. [SOLVED:] Employee schedules, 15 minutes interval table [working/slow; need alternative ideas] (10 replies)
  60. [SOLVED:] Nested Loop in VBA (9 replies)
  61. [SOLVED:] VBA Edit to Search Range (2 replies)
  62. Can you help fix this macro? (5 replies)
  63. Macro to Transpose data (7 replies)
  64. I need help with this VBA exam example (2 replies)
  65. how to get the directory (file save) when the macro is run the first time in the day (4 replies)
  66. Code to sum columns in lastrow +1 (7 replies)
  67. [SOLVED:] Odd error when comparing times with "dateadd" (7 replies)
  68. [SOLVED:] Find and Open an email in Outlook (4 replies)
  69. [SOLVED:] Auto-remove duplicates from dynamic list (11 replies)
  70. [SOLVED:] Use Cell Value to go offset to another cell (1 replies)
  71. Establishing comm link with Eicon Aviva from Excel VBA (4 replies)
  72. Using VBA to send emails via outlook using excel cells (1 replies)
  73. [SOLVED:] Excel 2010 How to Create a Custom Toolbar and Distribute to 50+ Users (1 replies)
  74. [SOLVED:] Max Row Index for an Array (5 replies)
  75. 2003 sorting code not working in 2010 (1 replies)
  76. [SOLVED:] SUMIF with Left criteria VBA (3 replies)
  77. Loop for copying values from excel file to fill sentences in Word (6 replies)
  78. What if analysis in Median (formula help required) (2 replies)
  79. How to Allocate ER Credit with VBA (7 replies)
  80. VBA to copy down information into blank row (2 replies)
  81. Help: How to Find and Replace VBA Code with VBA Code? (4 replies)
  82. [SOLVED:] Application.FileSearch Help (19 replies)
  83. [SOLVED:] write data consecutively if certain cell is not empty (12 replies)
  84. [SOLVED:] Aligning a chart textbox with a variable datapoint (2 replies)
  85. [SOLVED:] VBA: Importing data from one worksheet to another returns "TRUE" (4 replies)
  86. [SOLVED:] Modification to copy VBA code (2 replies)
  87. [SOLVED:] Filter Data Using Macro (5 replies)
  88. Syntax for unique values (3 replies)
  89. [SOLVED:] save one large file as separate text files (6 replies)
  90. [SOLVED:] Transformation of data with macro (4 replies)
  91. How to avoid Circular reference in a Range (6 replies)
  92. [SOLVED:] Unable to locate named range in code (2 replies)
  93. google poly line encoding in excelR (3 replies)
  94. [SOLVED:] AdvancedFilter displaying Unique values. (8 replies)
  95. Open a file from browse window and perform VLOOKUP (0 replies)
  96. Multiple Command Buttons & results in a new sheet. (0 replies)
  97. Looping a macro until the formula within the macro results in an acceptable output (1 replies)
  98. Copy Charts from Excel to power point 2007 and save as. (10 replies)
  99. VBA formula (4 replies)
  100. [SOLVED:] vb to copy and paste based on criteria (11 replies)
  101. XML Source data format change, Macro's no longer working (21 replies)
  102. Formating date delimiters in real time (1 replies)
  103. Copy email id & contact numbers from multiple resume which is in word file (0 replies)
  104. CMD.exe window keeps "taking over" when looping (8 replies)
  105. [SOLVED:] Array declaration question - "myArray()" versus "myArray" (3 replies)
  106. Pivot error (16 replies)
  107. Cycling through filters (1 replies)
  108. Creating list of Unique values in offset cells (13 replies)
  109. Data Comparison between master workbook and another workbook (10 replies)
  110. ISNA alternative (0 replies)
  111. [SOLVED:] SUM IFS (Vba) (1 replies)
  112. Importing Data from Closed Workbook (1 replies)
  113. [SOLVED:] Help with Loop (21 replies)
  114. Pivot Table expand/collapse buttons (2 replies)
  115. date issue for excel file (6 replies)
  116. Help with worksheet_change (6 replies)
  117. Code for multiplying 2 values based on search (3 replies)
  118. [SOLVED:] Excel MultiLine Textbox to Access Database - MultiLine lost in the Access Database (7 replies)
  119. [Solved] Referring to a String within Quotations (2 replies)
  120. [SOLVED:] Create Outlook 2013 Calendar items without duplicates (7 replies)
  121. Urgent: Help Needed With INDIRECT Formula (1 replies)
  122. add date to the column during update in worksheet (3 replies)
  123. Reset Sub Workbook_BeforeClose (4 replies)
  124. How can I copy and image file from Access Table to Excel? (1 replies)
  125. place grid in parsed xlsx (1 replies)
  126. TextBox Has Numericals, Value is String of Hexadecimals (3 replies)
  127. [SOLVED:] Seletion problem in listbox (Userform) (13 replies)
  128. Exit from Sub which is called from another Sub (8 replies)
  129. Run-time error "91": (3 replies)
  130. [SOLVED:] Listview in userform to show data entred by textboxes and comboboxes (37 replies)
  131. AutoFilter and Copy - Paste (3 replies)
  132. Macro to Copy data from Input sheet to Output sheet based out few criteria (5 replies)
  133. Excel file which listed new for any update information (4 replies)
  134. Assigning a cell value to a variable - between different workbooks (5 replies)
  135. Help....for Changing Vba Code in a Pivot for Filtering a Criteria. (2 replies)
  136. VBA Shift One Row Down. (3 replies)
  137. Excel userform to search find and return data (1 replies)
  138. Macro to Convert text to Number to last cell in the range (11 replies)
  139. VBA problem can anybody help (1 replies)
  140. Use Find Method to Clear Groups of Cells in Column When First Cell Marked "DELETE" (40 replies)
  141. [SOLVED:] Creating a new row problem (4 replies)
  142. Cell Split or add Rows Excel VBA Leave Plan (4 replies)
  143. Pasting Rows from one Table to another (2 replies)
  144. Vlookup/Index match, Vba code for two sheets in a Workbook (2 replies)
  145. [SOLVED:] Returning the Desktop Path (3 replies)
  146. User Defined Function Call Error (11 replies)
  147. [SOLVED:] Formula - Sumif,sumifs, aggregate (3 replies)
  148. [SOLVED:] Transponse help (6 replies)
  149. [SOLVED:] Delete table last row (1 replies)
  150. [SOLVED:] IF / OR Statement (2 replies)
  151. Retaining the Macro code for disabling Save option in Excel (10 replies)
  152. VBA Expert Wanted! >> Populate Table by Cycling Through Sheets (4 replies)
  153. [SOLVED:] Text Box not Displaying (5 replies)
  154. Get data from a PDF...VBA (2 replies)
  155. fill in sequence number (6 replies)
  156. [SOLVED:] conditionally sum values based on the TOTAL of multiple columns being greater than 0 (4 replies)
  157. Prevent duplicates for 2 sheets + msgBox (1 replies)
  158. Conditional macro in Excel based on two or more conditions (2 replies)
  159. copy-paste from one Excel file to the other VBA (0 replies)
  160. Delete rows based on a condition (4 replies)
  161. [SOLVED:] How can I use a current worksheet rather than creating a new one? (2 replies)
  162. VBA: Compare 2 cells from different workbook and publish the text right or wrong (3 replies)
  163. [SOLVED:] Improve Multiple loop code (19 replies)
  164. Need help creating VBA code for interpolation (kinda) (3 replies)
  165. Simple computation to record the difference between consecutive cells over a range (4 replies)
  166. [SOLVED:] Merging multiple worksheets into one (18 replies)
  167. VBA String Range Detection (5 replies)
  168. Macro for counting frequencies (6 replies)
  169. Splitting Sheets (6 replies)
  170. [SOLVED:] Workbook.Open Event not working correctly (15 replies)
  171. [SOLVED:] Filter on today's date (9 replies)
  172. Consolidating Multiple Sheets into One File (7 replies)
  173. Private VBA Apply to all New Worksheets (6 replies)
  174. [SOLVED:] Lock (freeze?!) objects (3 replies)
  175. Filter (6 replies)
  176. Quartiles with N/A (1 replies)
  177. Filter all sheets by filtering one sheet (5 replies)
  178. error parsing text files in directory using excel 2010 vba (5 replies)
  179. [SOLVED:] Find a string and clear cell's contents to the right (4 replies)
  180. Hello, how to distribute content to a cell by various cells automatically. (0 replies)
  181. [SOLVED:] Excel Macro Run-time error '1004': Selected method of Range class failed (4 replies)
  182. [SOLVED:] Selecting ONLY filtered cells NOT all the active cells in a column (2 replies)
  183. VBA Adding Table Row - Quick Fix Help! (1 replies)
  184. Combining matching values. (12 replies)
  185. Slicers:Extract selected & unselected items to a Range (0 replies)
  186. Copy paste first row with correct cell reference (2 replies)
  187. Some problems by using two userforms (6 replies)
  188. How to remove cells leading ' s when cvs (comma separated) file is imported in Excel. (3 replies)
  189. Excel Array formula (2 replies)
  190. Excel Macro not working properly (missing data pasted using macro) (2 replies)
  191. [SOLVED:] Need Help: Formula to get the amount (number) only out of text (3 replies)
  192. VBA Code- Insert formula up to last row (2 replies)
  193. Please Help !! Code Needs Slight Modification (0 replies)
  194. List File Hyperlink (2 replies)
  195. Trouble with code to grab data from multiple sheets and filter and list (3 replies)
  196. [SOLVED:] Save File in New Created Folder (7 replies)
  197. [SOLVED:] Copying values between two matching values... (4 replies)
  198. How to divide two values from a pivot table (1 replies)
  199. [SOLVED:] Trouble saving as PDF (4 replies)
  200. Suddenly Can't find project or library on something that has been working for weeks (5 replies)
  201. [SOLVED:] Run macro for selected rows (16 replies)
  202. How to dynamically place a VBA code to a Output excel file? (2 replies)
  203. [SOLVED:] How to use auto filter in excel vba? (8 replies)
  204. Is it possible to convert a database with VBA macro in web page? (0 replies)
  205. Copy several pivot tables to new worksheet (1 replies)
  206. [SOLVED:] Click on Summary Tab to set Filter in detail Tab (3 replies)
  207. Auto filter criteria (3 replies)
  208. [SOLVED:] Summarising trading positions (6 replies)
  209. Extracting Data From Specific Cells From Each File Form A Netwrok Folder (6 replies)
  210. [SOLVED:] Different sum (1 replies)
  211. [SOLVED:] Help Required to make code run faster (14 replies)
  212. File name with some changing numbers (4 replies)
  213. [SOLVED:] Is it posible to "paste" a Dutch translation of an Ecel formula in a cell (14 replies)
  214. Create Multiple Excel Files from One file (3 replies)
  215. Need help copy cell based on other column value (8 replies)
  216. Populate Excel -Output Tab based on Input Tab (1 replies)
  217. Combine Macros (12 replies)
  218. [SOLVED:] Help with database in excell (6 replies)
  219. Simple IF statement help (6 replies)
  220. [SOLVED:] Multiple Monte Carlo Simulations (3 replies)
  221. Issue with Space in Path for Output File (5 replies)
  222. Writing macros to calculate mutual fund performances (1 replies)
  223. Import value from adjacent cell in another workbook if cell meets criteria (2 replies)
  224. [SOLVED:] Clear textbox along with cell contents (8 replies)
  225. Absolute/Relative Workbook hyperlinks? (14 replies)
  226. Search button (3 replies)
  227. SpecialCells(xlCellTypeConstants).select shows unexpected behavior (for me) (23 replies)
  228. Add Date to all files in a folder (14 replies)
  229. [SOLVED:] Deleting an Entire Row (4 replies)
  230. Problem with VBA code - simulating profit and loss from delta hedging. (1 replies)
  231. Help: Auto Calculate Macro (3 replies)
  232. [SOLVED:] Radio Buttons on User Forms (17 replies)
  233. [SOLVED:] Delete row based on date and cell value (5 replies)
  234. For in columns Range (1 replies)
  235. Extract data from Multiple excel files (2 replies)
  236. [SOLVED:] Help in fixing LinkedIn code (18 replies)
  237. Disable copy paste code not working if data is copy pasted from different workbooks (0 replies)
  238. [SOLVED:] Generate an table Index (2 replies)
  239. Desperately lost in VBA code (2 replies)
  240. [SOLVED:] Pasting specific cells in A different order (2 replies)
  241. [SOLVED:] Delete All Rows except Row Containing Text and Row Above (3 replies)
  242. [SOLVED:] copy specific worksheet in xlsx as text file (32 replies)
  243. [SOLVED:] Different size in a joined string (5 replies)
  244. Loop excel files and sort it in a tree diagram (0 replies)
  245. Obfuscate a SHEET? (11 replies)
  246. [SOLVED:] Are multiple hyperlinks to run multiple macros within a single sheet possible? (2 replies)
  247. [SOLVED:] Need help with this VBA code (10 replies)
  248. Copy a Table from outlook msg body to Excel on receiving mail (1 replies)
  249. hyperlink to run macro not working (2 replies)
  250. Load zip structure in a treeview (vba) (2 replies)