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. Creating chart by searching input datas in different worksheets (2 replies)
  2. copy/paste values only between 2 tabs (3 replies)
  3. forcing excel sheet to save it as .xlsm (4 replies)
  4. [SOLVED:] Export Each Excel Row Text - to PPT (15 replies)
  5. [SOLVED:] Copying and Pasting through Ranges of Varying Lengths (3 replies)
  6. [SOLVED:] VBA Power Programming 2007 - Disk Examples (3 replies)
  7. [SOLVED:] VBA to run a Linear Regression Automatically (16 replies)
  8. Combine multiple sheets from multiple workbooks to a single workbook of multiple work (2 replies)
  9. [SOLVED:] Application.Onkey (7 replies)
  10. [SOLVED:] Move up cells less than row value (4 replies)
  11. [SOLVED:] Find First Cell in Column Containing non-NULL Data (6 replies)
  12. Fix Broken Code (8 replies)
  13. Paste with offset from a different sheet VBA (5 replies)
  14. Recording results of multiple runs using VBA (4 replies)
  15. How to close the all excel workbooks once i open a one excel workbook (1 replies)
  16. [SOLVED:] VBA/ Checkbox to add/remove fields in pivot (4 replies)
  17. [SOLVED:] Cell Returns no value even though the cell does contain a value (4 replies)
  18. [SOLVED:] macro to hyperlink excel cells to pdfs (12 replies)
  19. Removing blank lines from report calculated by macro (9 replies)
  20. convert text with (.) to number with (,) (7 replies)
  21. [SOLVED:] Search left from specific column eg. "y" (9 replies)
  22. Pulling Data from Web - page still loading (0 replies)
  23. [SOLVED:] Import worksheet based on filename and date (12 replies)
  24. Help with macro for filter (2 replies)
  25. [SOLVED:] Get latitude and longitude from Bing using VBA (16 replies)
  26. Shape Conditional Formatting & Permanent Logged In User, Date & Time Stamp (2 replies)
  27. [SOLVED:] Finding the Sum of Numbers between words in the entire workbook. (5 replies)
  28. How to Go to Next Row on a UserForm (7 replies)
  29. [SOLVED:] VBA/VBE Weird behavior when deleting a code line in a sub using a different sub (2 replies)
  30. VBA Code: Use keyboard keys in VBA coding (2 replies)
  31. VBA Code - If Code #1234 found in ColumnA then result code 5678 return in ColumnC (12 replies)
  32. Help with code to determine whether two strings are in a cell (1 replies)
  33. Compare 2 multi-arrays and isolate duplicate into 3rd array (3 replies)
  34. [SOLVED:] Add a sort filter to existing code (1 replies)
  35. Help putting border around a range (3 replies)
  36. Color issue confusing me (7 replies)
  37. [SOLVED:] index match function & IF to exclude few values (1 replies)
  38. VBA Excel data to Powerpoint (5 replies)
  39. Userform With Multiple Independent Combobox (delete row when not match) (1 replies)
  40. Search through a number of files for keywords and return associated data. help! (5 replies)
  41. [SOLVED:] Clear contents before replacing text (7 replies)
  42. Move cell values and buttons up from application caller (0 replies)
  43. Copy sheets from file to another but Not Copying those that already exist in 2nd file (1 replies)
  44. [SOLVED:] VBA Code to Insert a Row (13 replies)
  45. [SOLVED:] Move data from one sheet to another and export (11 replies)
  46. Merge and Append 95 Workbooks into One Workbook (10 replies)
  47. Turning Auto Calcs into Run by Button (11 replies)
  48. [SOLVED:] Dynamically Color Coded excel rows (3 replies)
  49. [SOLVED:] VBA Code: If not in column A then Replace (5 replies)
  50. Problem to create an indexed array - M(1 to 1, 1 to 4){i} (20 replies)
  51. [SOLVED:] Copy value of cell if date matches the date of another sheet (7 replies)
  52. Running macros while logged off (3 replies)
  53. Delete row based upon Date (13 replies)
  54. [SOLVED:] Cannot unlink word header (4 replies)
  55. Small Script Edit - Pasting value in front of data set (1 replies)
  56. [SOLVED:] How can I remove duplicates from a dynamic range? (4 replies)
  57. Saving Row as Text file - Concatenate & Line Breaks Not Working (2 replies)
  58. [SOLVED:] Custom Function Needed for Evaluating Performance (3 replies)
  59. PROBLEM WITH SCROLL BOX INSIDE A FORM (10 replies)
  60. Running a PDF file from Excel (9 replies)
  61. HELP with Formula to calculate Interest Rate (7 replies)
  62. VBA Calling/Application.run with dynamic inputs + error handling (5 replies)
  63. [SOLVED:] Question with FSO filtering - snb (2 replies)
  64. How to Shell to other Application with excel vba (0 replies)
  65. VBA Code - Lookup column1 in Column2 (3 replies)
  66. [SOLVED:] PivotTable field name is not valid when changing source data (1 replies)
  67. [SOLVED:] [VBA] Pasting data in Word looping for no apparent reason (8 replies)
  68. Excel 2013 - VB Script to save and e-mail form (0 replies)
  69. Concatenate in VBA (4 replies)
  70. [SOLVED:] Add Dates to Printed Header (15 replies)
  71. Multi-step workbook/sheet automation with VBA, macros, INDEX MATCH combination (3 replies)
  72. VBA Importing a sheet from a closed excel workbook (3 replies)
  73. [SOLVED:] Change Numbers to Words (12 replies)
  74. [SOLVED:] FSO filtering on the fly (24 replies)
  75. Error When Testing Collection for Key Exists (7 replies)
  76. VBA CODE- Match 2 cells and display the result (9 replies)
  77. Moving sheets to a new workbook (9 replies)
  78. Excel Duplicates (5 replies)
  79. Copy and Enter Current Record Displayed in Userform a # of Times to WS (0 replies)
  80. [SOLVED:] VBA Sheet Protection Failing (2 replies)
  81. SaveAs xlText (tab delimited text): delete empty line at the end (7 replies)
  82. [SOLVED:] Max value in array and return adjacent column (similar to offset/match in excel) (6 replies)
  83. [SOLVED:] VBA Set Variable equal to macro function (2 replies)
  84. VBA Form inserting dates in the wrong format (2 replies)
  85. create a worksheet based on description (8 replies)
  86. [SOLVED:] Open Latest Outlook email by Received Date (17 replies)
  87. Sort on multiple dynamic columns using excel VBA (0 replies)
  88. [SOLVED:] How to add a label to one selected data point in an xy scatter chart (0 replies)
  89. Build new Nested Loop in VBA (0 replies)
  90. [SOLVED:] User Form .SetFocus Help (9 replies)
  91. excel says it cant find the file I just DoubleClicked (0 replies)
  92. Determine if all files in a folder were created today (2 replies)
  93. Loop within a loop vba (1 replies)
  94. Date Validations using VBA code (6 replies)
  95. Sleeper: Look up records in Access from Excel and copy data to cell (1 replies)
  96. [SOLVED:] import txt or csv delimited parts into different excel sheets (6 replies)
  97. Data from Excel to Word 07 Bookmark (0 replies)
  98. I Need an Array Formula? (6 replies)
  99. Return the value below the cell that contains a specific string (3 replies)
  100. If dropdown only contains one option, automatically show that option - How???? (6 replies)
  101. Vba to insert text in range of cells (10 replies)
  102. [SOLVED:] macro to take values from range to slicers (5 replies)
  103. Split certain cells to multiple sheets IF value (8 replies)
  104. Help with a code for a picker (1 replies)
  105. How to Pass an array of implement(ed) object(s) to a sub/function? (12 replies)
  106. Create new sheet (4 replies)
  107. [SLEEPER:] Create Summary (1 replies)
  108. [SOLVED:] Vlookup using Vba code across two tabs (4 replies)
  109. Help vba code for a formula in two cells (1 replies)
  110. [SOLVED:] via code to use to 6, 8, 12 sheets (19 replies)
  111. VBA Help - Excel Range (text) to Word Bookmark (1 replies)
  112. Pull data from webpage (0 replies)
  113. [SOLVED:] Pulling specific lines from a text file into Excel (1 replies)
  114. [SOLVED:] Advise on "Best" or "Better" practices (5 replies)
  115. [SOLVED:] How to set the SubTotal TotalList using a variant instead of an array (5 replies)
  116. How do I copy Internet Most Visited Places shortcuts to an Excel sheet ? (0 replies)
  117. Develop a macro to solve below problem (13 replies)
  118. PDF Data to Excel Adobe XI (0 replies)
  119. how to open protected view excel file using VBA macro (1 replies)
  120. Help with VBA code Transfer excel range to Word bookmark (5 replies)
  121. Linking Content of Wkbk1 to Wkbk2, Extract filtered information into table in wkbk2 (0 replies)
  122. Userform calls other userform, then populate worksheet (0 replies)
  123. VBA: Text from Excel to Word with formatting (0 replies)
  124. Revising a code that inserts a new option column upon execution of an option button (2 replies)
  125. VBA Multi Select ListBox Issues (15 replies)
  126. VBA code for entering a formula not as expected (1 replies)
  127. Linear programming using solver in Excel 2000 (6 replies)
  128. Conditional wrap line - VBA Excel (3 replies)
  129. [SOLVED:] TRYING TO UNDERSTAND HOW EXCEL VBA MACROS AND USER FORMS ARE LINKED TO EXCEL FILES (24 replies)
  130. search in another excel file with VBA (1 replies)
  131. Return Last April using VBA (6 replies)
  132. nervous! How To Import Data From SQL Query To VBA Coding? (7 replies)
  133. Macro to combine columns without formulas (11 replies)
  134. Defining Dynamic Named Ranges with VBA (6 replies)
  135. Copy-Paste rows from multiple worksheets into a new workbook based on unique id (2 replies)
  136. Using vba to automate a Microsoft Word document with data imported from a Excel sheet (0 replies)
  137. Create different text files from parts of a range (6 replies)
  138. Prompt/Store value based on a selection/entry (7 replies)
  139. [SOLVED:] Pivot Table VBA (1 replies)
  140. Excel Recursive function through XML file (1 replies)
  141. [SOLVED:] Employee schedules, 15 minutes interval table [working/slow; need alternative ideas] (10 replies)
  142. [SOLVED:] Nested Loop in VBA (9 replies)
  143. [SOLVED:] VBA Edit to Search Range (2 replies)
  144. Can you help fix this macro? (5 replies)
  145. Macro to Transpose data (7 replies)
  146. I need help with this VBA exam example (2 replies)
  147. how to get the directory (file save) when the macro is run the first time in the day (4 replies)
  148. Code to sum columns in lastrow +1 (7 replies)
  149. [SOLVED:] Odd error when comparing times with "dateadd" (7 replies)
  150. [SOLVED:] Find and Open an email in Outlook (4 replies)
  151. [SOLVED:] Auto-remove duplicates from dynamic list (11 replies)
  152. [SOLVED:] Use Cell Value to go offset to another cell (1 replies)
  153. Establishing comm link with Eicon Aviva from Excel VBA (4 replies)
  154. Using VBA to send emails via outlook using excel cells (1 replies)
  155. [SOLVED:] Excel 2010 How to Create a Custom Toolbar and Distribute to 50+ Users (1 replies)
  156. [SOLVED:] Max Row Index for an Array (5 replies)
  157. 2003 sorting code not working in 2010 (1 replies)
  158. [SOLVED:] SUMIF with Left criteria VBA (3 replies)
  159. Loop for copying values from excel file to fill sentences in Word (6 replies)
  160. What if analysis in Median (formula help required) (2 replies)
  161. How to Allocate ER Credit with VBA (7 replies)
  162. VBA to copy down information into blank row (2 replies)
  163. Help: How to Find and Replace VBA Code with VBA Code? (4 replies)
  164. [SOLVED:] Application.FileSearch Help (19 replies)
  165. [SOLVED:] write data consecutively if certain cell is not empty (12 replies)
  166. [SOLVED:] Aligning a chart textbox with a variable datapoint (2 replies)
  167. [SOLVED:] VBA: Importing data from one worksheet to another returns "TRUE" (4 replies)
  168. [SOLVED:] Modification to copy VBA code (2 replies)
  169. [SOLVED:] Filter Data Using Macro (5 replies)
  170. Syntax for unique values (3 replies)
  171. [SOLVED:] save one large file as separate text files (6 replies)
  172. [SOLVED:] Transformation of data with macro (4 replies)
  173. How to avoid Circular reference in a Range (6 replies)
  174. [SOLVED:] Unable to locate named range in code (2 replies)
  175. google poly line encoding in excelR (3 replies)
  176. [SOLVED:] AdvancedFilter displaying Unique values. (8 replies)
  177. Open a file from browse window and perform VLOOKUP (0 replies)
  178. Multiple Command Buttons & results in a new sheet. (0 replies)
  179. Looping a macro until the formula within the macro results in an acceptable output (1 replies)
  180. Copy Charts from Excel to power point 2007 and save as. (10 replies)
  181. VBA formula (4 replies)
  182. [SOLVED:] vb to copy and paste based on criteria (11 replies)
  183. XML Source data format change, Macro's no longer working (21 replies)
  184. Formating date delimiters in real time (1 replies)
  185. Copy email id & contact numbers from multiple resume which is in word file (0 replies)
  186. CMD.exe window keeps "taking over" when looping (8 replies)
  187. [SOLVED:] Array declaration question - "myArray()" versus "myArray" (3 replies)
  188. Pivot error (16 replies)
  189. Cycling through filters (1 replies)
  190. Creating list of Unique values in offset cells (13 replies)
  191. Data Comparison between master workbook and another workbook (10 replies)
  192. ISNA alternative (0 replies)
  193. [SOLVED:] SUM IFS (Vba) (1 replies)
  194. Importing Data from Closed Workbook (1 replies)
  195. [SOLVED:] Help with Loop (21 replies)
  196. Pivot Table expand/collapse buttons (2 replies)
  197. date issue for excel file (6 replies)
  198. Help with worksheet_change (6 replies)
  199. Code for multiplying 2 values based on search (3 replies)
  200. [SOLVED:] Excel MultiLine Textbox to Access Database - MultiLine lost in the Access Database (7 replies)
  201. [Solved] Referring to a String within Quotations (2 replies)
  202. [SOLVED:] Create Outlook 2013 Calendar items without duplicates (7 replies)
  203. Urgent: Help Needed With INDIRECT Formula (1 replies)
  204. add date to the column during update in worksheet (3 replies)
  205. Reset Sub Workbook_BeforeClose (4 replies)
  206. How can I copy and image file from Access Table to Excel? (1 replies)
  207. place grid in parsed xlsx (1 replies)
  208. TextBox Has Numericals, Value is String of Hexadecimals (3 replies)
  209. [SOLVED:] Seletion problem in listbox (Userform) (13 replies)
  210. Exit from Sub which is called from another Sub (8 replies)
  211. Run-time error "91": (3 replies)
  212. [SOLVED:] Listview in userform to show data entred by textboxes and comboboxes (37 replies)
  213. AutoFilter and Copy - Paste (3 replies)
  214. Macro to Copy data from Input sheet to Output sheet based out few criteria (5 replies)
  215. Excel file which listed new for any update information (4 replies)
  216. Assigning a cell value to a variable - between different workbooks (5 replies)
  217. Help....for Changing Vba Code in a Pivot for Filtering a Criteria. (2 replies)
  218. VBA Shift One Row Down. (3 replies)
  219. Excel userform to search find and return data (1 replies)
  220. Macro to Convert text to Number to last cell in the range (11 replies)
  221. VBA problem can anybody help (1 replies)
  222. Use Find Method to Clear Groups of Cells in Column When First Cell Marked "DELETE" (40 replies)
  223. [SOLVED:] Creating a new row problem (4 replies)
  224. Cell Split or add Rows Excel VBA Leave Plan (4 replies)
  225. Pasting Rows from one Table to another (2 replies)
  226. Vlookup/Index match, Vba code for two sheets in a Workbook (2 replies)
  227. [SOLVED:] Returning the Desktop Path (3 replies)
  228. User Defined Function Call Error (11 replies)
  229. [SOLVED:] Formula - Sumif,sumifs, aggregate (3 replies)
  230. [SOLVED:] Transponse help (6 replies)
  231. [SOLVED:] Delete table last row (1 replies)
  232. [SOLVED:] IF / OR Statement (2 replies)
  233. Retaining the Macro code for disabling Save option in Excel (10 replies)
  234. VBA Expert Wanted! >> Populate Table by Cycling Through Sheets (4 replies)
  235. [SOLVED:] Text Box not Displaying (5 replies)
  236. Get data from a PDF...VBA (2 replies)
  237. fill in sequence number (6 replies)
  238. [SOLVED:] conditionally sum values based on the TOTAL of multiple columns being greater than 0 (4 replies)
  239. Prevent duplicates for 2 sheets + msgBox (1 replies)
  240. Conditional macro in Excel based on two or more conditions (2 replies)
  241. copy-paste from one Excel file to the other VBA (0 replies)
  242. Delete rows based on a condition (4 replies)
  243. [SOLVED:] How can I use a current worksheet rather than creating a new one? (2 replies)
  244. VBA: Compare 2 cells from different workbook and publish the text right or wrong (3 replies)
  245. [SOLVED:] Improve Multiple loop code (19 replies)
  246. [SLEEPER:] Need help creating VBA code for interpolation (kinda) (2 replies)
  247. Simple computation to record the difference between consecutive cells over a range (4 replies)
  248. [SOLVED:] Merging multiple worksheets into one (18 replies)
  249. VBA String Range Detection (5 replies)
  250. Macro for counting frequencies (6 replies)