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. [SOLVED:] VBA Input Box (6 replies)
  2. how to lookup combo box into textbox in excel VBA (3 replies)
  3. [SOLVED:] Parent / Child Relationships (7 replies)
  4. Pasting range from Source ab to Destination tab based on name (4 replies)
  5. Conditional Outline Borders Based on Criteria (4 replies)
  6. VLookup Duplicating Data (2 replies)
  7. vba adding up time with spin control & text box with userfirendly output (4 replies)
  8. [SLEEPER:] adjusting code search by combobox (3 replies)
  9. I need VBA for my work. Thanks for all helps (0 replies)
  10. [SOLVED:] Macro Run-time Error '1004' Application-defined or object-defined error (4 replies)
  11. when importing data VBA code changes values ​​of the original ​​book (8 replies)
  12. VBA Looking for a Better solution than iCol for next loop (3 replies)
  13. If condition is not met, go back to start of code VBA (7 replies)
  14. Workbook.BeforeSave Event on Mac Office (1 replies)
  15. Group of Functions (1 replies)
  16. In VBA transfer data from one spreadsheet to another based on new date (1 replies)
  17. [SOLVED:] Error: Application-defined or object-defined when trying to hide row (1 replies)
  18. search by header column in VBA and copy corresponding column (12 replies)
  19. [SOLVED:] Converting Tables Into ListObject (5 replies)
  20. VBA for consolidating data without duplicates (0 replies)
  21. [SOLVED:] Go To Next Filter (13 replies)
  22. Loop through a collection of controls (6 replies)
  23. move to end of the procedure (11 replies)
  24. how to check if already exist in db (1 replies)
  25. When would you execute doevents more than once? (3 replies)
  26. [SOLVED:] Formula help (25 replies)
  27. [SOLVED:] Excel Formula to Link Totals from Newly Created Tabs to Summary Sheet (1 replies)
  28. Vlookup open file on background (5 replies)
  29. userform textbox save file path in cell as hyperlink (3 replies)
  30. [SOLVED:] PivotTable.DrillDown and filtering the output based on target column data type (11 replies)
  31. [SOLVED:] Pull Latitude from XML and keep Double (3 replies)
  32. userform comobox question (1 replies)
  33. Using Solver with a macro (0 replies)
  34. VBA: search for multiple words (3 replies)
  35. [SOLVED:] Multiple Filters of Pivot Table (30 replies)
  36. How to switch between worksheets while VBA is running? (5 replies)
  37. Issue with VBS - wscript and saving multiple files (0 replies)
  38. [SOLVED:] VBA code for consolidating/transf data from multiple worksheets in one Template sheet (5 replies)
  39. Autofilter List Exists (1 replies)
  40. MACRO filter column based on reference criteria copy, paste and repeat (9 replies)
  41. Merge cells based on the cell value updated on other column (1 replies)
  42. Renaming Worksheets Using VBA (3 replies)
  43. Word recovery and mapping vba (2 replies)
  44. help with vba loop inside listbox & search value (3 replies)
  45. excel vba to outlook email (1 replies)
  46. Adding message and loop to input box password (2 replies)
  47. Leading zeroes depending on file name (0 replies)
  48. Fill in the data with date range (0 replies)
  49. Conditional Format (0 replies)
  50. Copy certain cells to new sheet based upon a different cell? (4 replies)
  51. [SOLVED:] Compare 2 columns from separate sheets and create new sheet with data from both (1 replies)
  52. Finding a value in my table (4 replies)
  53. [SOLVED:] Auto unformatting of output filename with leading zeroes (1 replies)
  54. [SOLVED:] Compound interest rate with leap year (16 replies)
  55. [SLEEPER:] TextBox SetFocus Problem on UserForm (3 replies)
  56. Page setup when selected items are sent to print Preview (1 replies)
  57. Live data output (1 replies)
  58. VBA userform output storing number as text (1 replies)
  59. [SOLVED:] Flashing cell (5 replies)
  60. [SOLVED:] Help with Formula (14 replies)
  61. [SOLVED:] Listbox Selection not working with 1 result (2 replies)
  62. [SOLVED:] Timestamp difference in Millisecond (3 replies)
  63. VBA - what is Chr(1) (5 replies)
  64. Image viewer with images control (4 replies)
  65. [SOLVED:] Unique values from dynamic list (3 replies)
  66. DTPicker select date to display in Text box (1 replies)
  67. [SOLVED:] looping from one worksheet to the next fails (2 replies)
  68. If condition for check all the rows (3 replies)
  69. Dashbored where he take stairs (4 replies)
  70. [SOLVED:] DataPoint = NormInv(rand(), MeanNow, 1#) fails in VBA (4 replies)
  71. please help in vba macro--Compare and merge data given in parent child hierarchy (1 replies)
  72. [SOLVED:] Stuck with block if without end if, totally lost. (3 replies)
  73. Reverse date Import from .csv file (6 replies)
  74. [SOLVED:] Find - replace (19 replies)
  75. Can't open new workbook (3 replies)
  76. [SOLVED:] Copy userform info to worksheet row based on 2 criteria (2 replies)
  77. [SOLVED:] Macro to clear data but keep formula (2 replies)
  78. Using userform VBA to create a list (5 replies)
  79. Using Hyperlink to open a hidden sheet - not working (0 replies)
  80. [SOLVED:] Custom Ribbon Add Additional Tab (10 replies)
  81. Excel VBA - Copying to specific column (1 replies)
  82. [SOLVED:] Creating Array from cells givin error " Subscript out of range" (3 replies)
  83. Touch Screen Programming (1 replies)
  84. [SOLVED:] Range A1 notation (6 replies)
  85. Excel Hide - Unhide Columns With Userform (0 replies)
  86. Grouping - VBA (0 replies)
  87. Variation on dynamic Linked Cells code (2 replies)
  88. [SOLVED:] Listbox export (8 replies)
  89. [SOLVED:] VBA loop formula explanation? (1 replies)
  90. [SOLVED:] Excel VBA MsgBox NOT closing (4 replies)
  91. 2 different lists (3 replies)
  92. [SOLVED:] VBA Copy Paste Formula (3 replies)
  93. Using Excel VBA Get the "Page Number" of Table current cells in Winword. (2 replies)
  94. [SOLVED:] Help Debugging Short VBA Formula (2 replies)
  95. Excel vba crashes? (5 replies)
  96. [SOLVED:] Recalculate the cells in a column to achieve a set SUM value (4 replies)
  97. [SOLVED:] Extract Multiple Rows into a Limited Template based on Multiple Criterias (3 replies)
  98. Help with hiding rows based on content of a cell (0 replies)
  99. [SOLVED:] Export from Excel to text file, insert delimiter (17 replies)
  100. [SLEEPER:] Lock cells and paste values based on a cell value (0 replies)
  101. [SOLVED:] Moving Rows (4 replies)
  102. [SOLVED:] Question about excel instances locked down if spreadsheet hidden while using a form (2 replies)
  103. Get Msgbox in a table (5 replies)
  104. [SOLVED:] VBA code excel (10 replies)
  105. [SOLVED:] Creating Multiple Tables Using Loop in VBA. I still want to add new sheets and add (103 replies)
  106. Best Approach to Do This Report (10 replies)
  107. VBA Help - Avoid triggering a Change Event on Delete (2 replies)
  108. Issue with code to check whether an excel file is open or not (0 replies)
  109. Data copy from other sheet based on cell value (1 replies)
  110. Drop down list without blank cell (3 replies)
  111. Delete the list from UserForm (0 replies)
  112. [SOLVED:] Export Multiple wbk (10 replies)
  113. ClearingContents in ranges that don't intersect (10 replies)
  114. Sleeper: Cascade String concatenation problem (2 replies)
  115. Batch script for inputting data into cells (5 replies)
  116. VBA search function (4 replies)
  117. [SOLVED:] VBA Replace From Code to Range (7 replies)
  118. Excel formula help match (4 replies)
  119. Form Close (1 replies)
  120. VBA That Will Group Specific Blank Rows (8 replies)
  121. [SOLVED:] Removing duplicate from keywords (10 replies)
  122. Change first letter of word to uppercase (4 replies)
  123. [SOLVED:] Parenting Calendar in excel exported to CSV for import into google calendar (6 replies)
  124. importing sheet from another file - issue with data validation (1 replies)
  125. [SOLVED:] VBA to calculate TOTAL based on condition (2 replies)
  126. [SOLVED:] setting a cell to a formula (3 replies)
  127. Excel Vlookup and multiple search results (1 replies)
  128. [SOLVED:] Remove Header / Footer from files in folder (2 replies)
  129. [SOLVED:] VBA to insert blank rows based on conditions (2 replies)
  130. [SOLVED:] Get data in various cells based on a cell value from another sheet (2 replies)
  131. [SOLVED:] struggling with vbYes and vbNo coding (2 replies)
  132. Store in DataBase (29 replies)
  133. [SOLVED:] Data uploading from userform to excel when "No" is selected in msgbox (3 replies)
  134. [SOLVED:] Replacing drop downs by two multichoice listboxes to copy&paste in between sheets (3 replies)
  135. [SOLVED:] VBA copy / paste to the next specific row (2 replies)
  136. tracking worksheet changes over multiple columns (1 replies)
  137. [SOLVED:] CTRL + Shift + Down in a Macro (29 replies)
  138. [SOLVED:] select data using drop down list (6 replies)
  139. Fetching data in various cells based on on one cell (2 replies)
  140. cumulative sum between two dates (1 replies)
  141. Sleeper: How to calculate Volume Weighted Average Price (VWAP) of all relevant deals (2 replies)
  142. [SOLVED:] Good way to mark a textbox so users know it is required to fill (5 replies)
  143. VBA Update from Excel to SQL Table Contents. (3 replies)
  144. [SOLVED:] Excel VBA to read txt file, input all data into one cell (8 replies)
  145. [SOLVED:] Vba Custom Format "0000" in File Name (2 replies)
  146. [SOLVED:] Transfer data from Excel to double column of information in Word (15 replies)
  147. [SOLVED:] VBA macro code to expand a certain column (3 replies)
  148. [SLEEPER:] Case issue (4 replies)
  149. Find cell matching text then get last row before blank (9 replies)
  150. subtract today's date from a date in another column (5 replies)
  151. type mismatch error that i didn't get before (6 replies)
  152. [SOLVED:] Abbreviate the next succeeding instances of scientific names (20 replies)
  153. How to Calculate Standard Dev without using the worksheet function in VBA (2 replies)
  154. VBA Error When Add / Delete a Row (5 replies)
  155. [SOLVED:] Find and replace module help (5 replies)
  156. Convert from range to tables and code support? (2 replies)
  157. Copy Data from one Worksheet to Another (0 replies)
  158. vba excel function return #VALUE! (2 replies)
  159. Search and Fill Listbox (2 replies)
  160. Data migration between tabs using VBA (1 replies)
  161. Procedure too large error (14 replies)
  162. [SOLVED:] VBA newcomer - help with IF to determine whether to run code (2 replies)
  163. Filling ComboBox? (4 replies)
  164. conditional formatting help (1 replies)
  165. Backtesting futures using VBA (2 replies)
  166. VBA Code to Loop and Calculate Subtotals with blank rows (2 replies)
  167. Application.FileDialog clean up (6 replies)
  168. Yearly Calendar Project (4 replies)
  169. Search with Table (0 replies)
  170. autofit cell height for merged cells (3 replies)
  171. Debug stops running macro and will only continue in step mode (3 replies)
  172. Importing pictures by directory string (1 replies)
  173. Set Range Using a Function (1 replies)
  174. [SOLVED:] Hyperlinks with changing Sheet Names (0 replies)
  175. VBA: Filtering for a date range from 2 ComboBoxes for dates (3 replies)
  176. [SOLVED:] Produce parts list from breakdown (5 replies)
  177. Flags on birthday calendar (11 replies)
  178. User defined directory not working (1 replies)
  179. Code that detects data in cells and pastes data into the next cells (3 replies)
  180. [SOLVED:] Excel Macro help - If target cell in range of cells. (1 replies)
  181. Runtime Error 438 (3 replies)
  182. Skip blank from Auto Filter (2 replies)
  183. Making 2 Dependent drop downs (1 replies)
  184. VBA pivot table error 5 (7 replies)
  185. adjusted code show the data in listbox on userform (6 replies)
  186. [SOLVED:] Button click to change shape color (10 replies)
  187. Active X Textbox Content to Userform Textbox (2 replies)
  188. Update Shared Spreadsheets (0 replies)
  189. Macro to clear hidden contents based off other cell values (4 replies)
  190. [SOLVED:] Rename New Sheet? (11 replies)
  191. VBA Code to edit and update existing data (11 replies)
  192. Application.Match gives 'Type Mismatch' only on descending date values, match type=-1 (3 replies)
  193. VBA to Recalculate Grand Total (2 replies)
  194. Transform data type in column (1 replies)
  195. [SLEEPER:] Excel vba merge cells based on duplicate cell data (5 replies)
  196. Formulas NameManager (0 replies)
  197. Excel help copy and paste from sheets then move to next row (1 replies)
  198. Input user form to change cell value (1 replies)
  199. [SOLVED:] 2 separate change events code issue (Floating Cmd Button & List box selection) (7 replies)
  200. Crank Nicholson Method (2 replies)
  201. Crank Nicholson (2 replies)
  202. [SOLVED:] VBA Code to stop loop if cell / range is blank (2 replies)
  203. [SOLVED:] Printout VBA (3 replies)
  204. Creation of File list in a new Workbook (4 replies)
  205. [SOLVED:] Format transfer to sheet 2 after match in sheet1 (5 replies)
  206. Userform - Compile Error: Invalid qualifier (2 replies)
  207. [SOLVED:] VLOOKUP Not Updating when Data Repeated (8 replies)
  208. Filepath to reference cell value (4 replies)
  209. [SOLVED:] Create a File list with metadata (9 replies)
  210. Two userforms in one sheet (11 replies)
  211. My chart "hides" from view sometimes after running or when idle. (0 replies)
  212. How can I control when and if my chart updates and not updates? (15 replies)
  213. [SOLVED:] Use .Range("A1:A10000") to end of records? (11 replies)
  214. VLOOKUP not working properly (5 replies)
  215. Findvalue from 2 searchstrings (3 replies)
  216. Excel to JSON -- bracketing (5 replies)
  217. [SOLVED:] Excel VBA code to Delete 'Heading 1' from Word Document (2 replies)
  218. Array issues - one vs two dimensional (1 replies)
  219. [SOLVED:] VBA Code to Run Code Across Multiple Worksheets at One Time (11 replies)
  220. Print to PDF file (6 replies)
  221. [SOLVED:] VBA to replace previous table and check if one cells value is equal to the previous o (6 replies)
  222. Why is my code showing error?? (5 replies)
  223. Word file - filled using excel and send by email as attachment (1 replies)
  224. Loop through a folder and copy data from files to another WB (6 replies)
  225. User Form - Many Text Boxes - Restrict One Text Box with Password for Editing (1 replies)
  226. Export as CSV file (0 replies)
  227. [SOLVED:] Declaring Variable Type - Excel 2013 (4 replies)
  228. VBA how to superscript characters in a string following an apostrophe? (12 replies)
  229. Search data using Userform and then scroll through matching records (9 replies)
  230. [SOLVED:] Help import from csv file (21 replies)
  231. Copy data from one sheet to another sheet where the values are matching (2 replies)
  232. VBA filter and cell formatting (0 replies)
  233. On editing protected view programmatically , display setting are getting changed . (2 replies)
  234. [SOLVED:] Multiple selections from drop down list (6 replies)
  235. [SOLVED:] BeforeSave and Userform: Issues with saving the excel file (12 replies)
  236. VBA Advanced filter help..... Criteria excluding a list (7 replies)
  237. [SOLVED:] Need help with logic (7 replies)
  238. [SOLVED:] VBA Code to add groupings to subtotals (10 replies)
  239. [SOLVED:] Copy .pdf files from one location to a new folder based on a list of cell (4 replies)
  240. Run-time error 438: Object doesn't support this property or method (6 replies)
  241. Error Handling for InputBoxes (1 replies)
  242. VBA code not working in 365 (5 replies)
  243. [SOLVED:] Userform open from one worksheet and referencing another worksheet (2 replies)
  244. [SOLVED:] VBA Code to remove Data embedded in the "Pick From Drop Down List" (9 replies)
  245. [SOLVED:] VBA code for selecting data from statement to output sheet (10 replies)
  246. [SOLVED:] Copy and paste VBA (4 replies)
  247. VBA problem (5 replies)
  248. Copy Multiple Files from Absolute Paths to SharePoint with Same File Names (1 replies)
  249. Updating a Chart while VBA is running (0 replies)
  250. [SOLVED:] How to get the first & last range value for this type of data...? (1 replies)