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 code for vlookup in multiple worksheets (2 replies)
  2. [SOLVED:] Week number instead of Day Dates (2 replies)
  3. List Files (Specific File Type) from Folder & Sub-folders to Excel w/ VBA (0 replies)
  4. Converting DOS Commands to VBA Function (2 replies)
  5. Cell Address Goal Seek (0 replies)
  6. [SOLVED:] Seek matching text in cells and if match found enter info in third cell (2 replies)
  7. VBA Code needed. if more than 90 days, Message Box Expired, Elseif still valid (0 replies)
  8. [SOLVED:] VBA code to prompt message " file in use" please wait (5 replies)
  9. Find and Replace not working (0 replies)
  10. VBA: Export to PDF combination of cells (0 replies)
  11. Formula for sale (0 replies)
  12. I need VBA code (5 replies)
  13. Lookup a date range by Matching a column data set in a table & fetch respective data (0 replies)
  14. [SOLVED:] byref argument type mismatch (1 replies)
  15. Case with boolean (2 replies)
  16. [SOLVED:] Why does my Array only fill half way? (5 replies)
  17. Changing first name to initial only, adding second initial and combining repeats (3 replies)
  18. [SOLVED:] Data type mismatch with VBA Range.Copy & Range.PasteSpecial (2 replies)
  19. [SOLVED:] Keep 1 Record every 5 duplicate (4 replies)
  20. [SOLVED:] Use a variable for subroutine name (6 replies)
  21. Auto copy and paste query table (0 replies)
  22. VBA macro to copy from various sheet to a new file (1 replies)
  23. [SOLVED:] Declaring a variable using part of a filepath name (3 replies)
  24. Noob to vba - loop not looking at all (2 replies)
  25. Help?! Run-time error 6 overflow (6 replies)
  26. Speed Up VBA Macro (2 replies)
  27. [SOLVED:] Modifying existing form - how to add date picker (11 replies)
  28. Seperate Data by trade ID and Date (0 replies)
  29. Seeking help to make cell ranges dynamic (4 replies)
  30. [SOLVED:] VBA function - Inputting multiple cells instead of a complete range of cells? (5 replies)
  31. VBA Printing only columns with data (0 replies)
  32. vba excel macro for print button (1 replies)
  33. Looping Through Pivot Items (0 replies)
  34. Ensure that only unique values are extracted (2 replies)
  35. Search and Extract related data from TXT file and append into Excel (3 replies)
  36. [SOLVED:] Embedded Templates (12 replies)
  37. [SOLVED:] Editing part of a string (2 replies)
  38. Combining Multiple Worksheets with Same Table Headers (3 replies)
  39. Sleeper: Macro to compare two workbook (3 replies)
  40. EXCEL syntax isue (2 replies)
  41. Select cells with input box and unlock them in a protected worksheet (15 replies)
  42. [SOLVED:] Using Structured Cell References (4 replies)
  43. Selecting Pivot Table Range with Dynamic Data (1 replies)
  44. Extract Crossing new Sheet (2 replies)
  45. vba Help - extract Matching value (3 replies)
  46. Out of memory - find and replace part of hyperlink (0 replies)
  47. If Pivot Item = "" then skip (0 replies)
  48. adjusting code calling data in worksheet (3 replies)
  49. Import data to excel (0 replies)
  50. URGENT HELP PLEASE Copying same data to multiple rows (0 replies)
  51. [SOLVED:] Loop a sort function (2 replies)
  52. VBA to check if cell changed (1 replies)
  53. [SOLVED:] Single column into matrix (2 replies)
  54. Resizing a table to size 1 row (7 replies)
  55. VBA form question (6 replies)
  56. Sleeper: Trying to Sort "Multiple Rows" together (2 replies)
  57. Changing column types (1 replies)
  58. Caculate From One Cell & a Dimension Table (1 replies)
  59. [SOLVED:] Filling one Cell from another Cell (3 replies)
  60. [SOLVED:] Merge multiple Excel files into ONE WORKSHEET (14 replies)
  61. How can I modify this code to use a cell value when naming the new workbooks? (1 replies)
  62. COUNTIF Column based in VBA (1 replies)
  63. Automatically updating date cell unless row is blank (2 replies)
  64. Extract unique values from column based on criteria (0 replies)
  65. MACRO/VBA - Extract unique values to different worksheet that meets a criteria (0 replies)
  66. VBA - capacity smoothing (4 replies)
  67. Using Index Match with an unknown range (5 replies)
  68. [SOLVED:] A Class Module to store Images from a folder for later reuse in Workbook Excel VBA (31 replies)
  69. VBA to compare values in 2 cells and post a value in another (1 replies)
  70. Importing Images/Pictures/Shapes from a Closed Excel Workbook (12 replies)
  71. Sleeper: Overcoming ADO Recordset 64 Characters limitation for Fields (13 replies)
  72. VBA Pasting values to different cells in the same named range (7 replies)
  73. How can I write VBA macro for bchain() and bdh()? (3 replies)
  74. PDF creating and past copy different folder (0 replies)
  75. Remove "Filters" from Macro Script (2 replies)
  76. [SOLVED:] VBA Conditional formatting - multiple adjacent cells if specific text on left (10 replies)
  77. Parse rows to sheets (1 replies)
  78. [SOLVED:] AverageIfs to compare AM vs PM hours (4 replies)
  79. Macro IF statements (1 replies)
  80. [SOLVED:] IF Statement using VBA (5 replies)
  81. Copy cell data from one protected file to another (1 replies)
  82. [SOLVED:] sort data within the same cell (1 replies)
  83. Setting Linked cell to another work sheet (6 replies)
  84. VBA userform listbox - hard set range to specific sheet (2 replies)
  85. Make code more variable (8 replies)
  86. [SOLVED:] Match Error 2042 (1 replies)
  87. Export pivot table to individual PDF (2 replies)
  88. Question about clear, clear contents (11 replies)
  89. Reference to Lists in another workbook (1 replies)
  90. [SOLVED:] VBA coding for Excel problem (4 replies)
  91. [SOLVED:] Worksheet_BeforeDoubleClick (1 replies)
  92. [SOLVED:] Create a border around a range for specific criteria (3 replies)
  93. Help reversing calculations. (2 replies)
  94. Removing parts before each item (4 replies)
  95. [SOLVED:] VBA Input Box (6 replies)
  96. how to lookup combo box into textbox in excel VBA (3 replies)
  97. [SOLVED:] Parent / Child Relationships (7 replies)
  98. Pasting range from Source ab to Destination tab based on name (4 replies)
  99. Conditional Outline Borders Based on Criteria (4 replies)
  100. VLookup Duplicating Data (2 replies)
  101. vba adding up time with spin control & text box with userfirendly output (4 replies)
  102. adjusting code search by combobox (3 replies)
  103. I need VBA for my work. Thanks for all helps (0 replies)
  104. [SOLVED:] Macro Run-time Error '1004' Application-defined or object-defined error (4 replies)
  105. when importing data VBA code changes values ​​of the original ​​book (8 replies)
  106. VBA Looking for a Better solution than iCol for next loop (3 replies)
  107. If condition is not met, go back to start of code VBA (7 replies)
  108. Workbook.BeforeSave Event on Mac Office (1 replies)
  109. Group of Functions (1 replies)
  110. In VBA transfer data from one spreadsheet to another based on new date (1 replies)
  111. [SOLVED:] Error: Application-defined or object-defined when trying to hide row (1 replies)
  112. search by header column in VBA and copy corresponding column (12 replies)
  113. [SOLVED:] Converting Tables Into ListObject (5 replies)
  114. VBA for consolidating data without duplicates (0 replies)
  115. [SOLVED:] Go To Next Filter (13 replies)
  116. Loop through a collection of controls (6 replies)
  117. move to end of the procedure (11 replies)
  118. how to check if already exist in db (1 replies)
  119. When would you execute doevents more than once? (3 replies)
  120. [SOLVED:] Formula help (25 replies)
  121. [SOLVED:] Excel Formula to Link Totals from Newly Created Tabs to Summary Sheet (1 replies)
  122. Vlookup open file on background (5 replies)
  123. userform textbox save file path in cell as hyperlink (3 replies)
  124. [SOLVED:] PivotTable.DrillDown and filtering the output based on target column data type (11 replies)
  125. [SOLVED:] Pull Latitude from XML and keep Double (3 replies)
  126. userform comobox question (1 replies)
  127. Using Solver with a macro (0 replies)
  128. VBA: search for multiple words (3 replies)
  129. [SOLVED:] Multiple Filters of Pivot Table (30 replies)
  130. How to switch between worksheets while VBA is running? (5 replies)
  131. Issue with VBS - wscript and saving multiple files (0 replies)
  132. [SOLVED:] VBA code for consolidating/transf data from multiple worksheets in one Template sheet (5 replies)
  133. Autofilter List Exists (1 replies)
  134. MACRO filter column based on reference criteria copy, paste and repeat (9 replies)
  135. Merge cells based on the cell value updated on other column (1 replies)
  136. Renaming Worksheets Using VBA (3 replies)
  137. Word recovery and mapping vba (2 replies)
  138. help with vba loop inside listbox & search value (3 replies)
  139. excel vba to outlook email (1 replies)
  140. Adding message and loop to input box password (2 replies)
  141. Leading zeroes depending on file name (0 replies)
  142. Fill in the data with date range (0 replies)
  143. Conditional Format (0 replies)
  144. Copy certain cells to new sheet based upon a different cell? (4 replies)
  145. [SOLVED:] Compare 2 columns from separate sheets and create new sheet with data from both (1 replies)
  146. Finding a value in my table (4 replies)
  147. [SOLVED:] Auto unformatting of output filename with leading zeroes (1 replies)
  148. [SOLVED:] Compound interest rate with leap year (16 replies)
  149. [SLEEPER:] TextBox SetFocus Problem on UserForm (3 replies)
  150. Page setup when selected items are sent to print Preview (1 replies)
  151. Live data output (1 replies)
  152. VBA userform output storing number as text (1 replies)
  153. [SOLVED:] Flashing cell (5 replies)
  154. [SOLVED:] Help with Formula (14 replies)
  155. [SOLVED:] Listbox Selection not working with 1 result (2 replies)
  156. [SOLVED:] Timestamp difference in Millisecond (3 replies)
  157. VBA - what is Chr(1) (5 replies)
  158. Image viewer with images control (4 replies)
  159. [SOLVED:] Unique values from dynamic list (3 replies)
  160. DTPicker select date to display in Text box (1 replies)
  161. [SOLVED:] looping from one worksheet to the next fails (2 replies)
  162. If condition for check all the rows (3 replies)
  163. Dashbored where he take stairs (4 replies)
  164. [SOLVED:] DataPoint = NormInv(rand(), MeanNow, 1#) fails in VBA (4 replies)
  165. please help in vba macro--Compare and merge data given in parent child hierarchy (1 replies)
  166. Stuck with block if without end if, totally lost. (3 replies)
  167. Reverse date Import from .csv file (6 replies)
  168. [SOLVED:] Find - replace (19 replies)
  169. Can't open new workbook (3 replies)
  170. [SOLVED:] Copy userform info to worksheet row based on 2 criteria (2 replies)
  171. [SOLVED:] Macro to clear data but keep formula (2 replies)
  172. Using userform VBA to create a list (5 replies)
  173. Using Hyperlink to open a hidden sheet - not working (0 replies)
  174. [SOLVED:] Custom Ribbon Add Additional Tab (10 replies)
  175. Excel VBA - Copying to specific column (1 replies)
  176. [SOLVED:] Creating Array from cells givin error " Subscript out of range" (3 replies)
  177. Touch Screen Programming (1 replies)
  178. [SOLVED:] Range A1 notation (6 replies)
  179. Excel Hide - Unhide Columns With Userform (0 replies)
  180. Grouping - VBA (0 replies)
  181. Variation on dynamic Linked Cells code (2 replies)
  182. [SOLVED:] Listbox export (8 replies)
  183. [SOLVED:] VBA loop formula explanation? (1 replies)
  184. [SOLVED:] Excel VBA MsgBox NOT closing (4 replies)
  185. 2 different lists (3 replies)
  186. [SOLVED:] VBA Copy Paste Formula (3 replies)
  187. Using Excel VBA Get the "Page Number" of Table current cells in Winword. (2 replies)
  188. [SOLVED:] Help Debugging Short VBA Formula (2 replies)
  189. Excel vba crashes? (5 replies)
  190. [SOLVED:] Recalculate the cells in a column to achieve a set SUM value (4 replies)
  191. [SOLVED:] Extract Multiple Rows into a Limited Template based on Multiple Criterias (3 replies)
  192. Help with hiding rows based on content of a cell (0 replies)
  193. VBA help, export from Excel to text file, insert delimiter (17 replies)
  194. Lock cells and paste values based on a cell value (0 replies)
  195. [SOLVED:] Moving Rows (4 replies)
  196. [SOLVED:] Question about excel instances locked down if spreadsheet hidden while using a form (2 replies)
  197. Get Msgbox in a table (5 replies)
  198. [SOLVED:] VBA code excel (10 replies)
  199. Creating Multiple Tables Using Loop in VBA. I still want to add new sheets and add (103 replies)
  200. Best Approach to Do This Report (10 replies)
  201. VBA Help - Avoid triggering a Change Event on Delete (2 replies)
  202. Issue with code to check whether an excel file is open or not (0 replies)
  203. Data copy from other sheet based on cell value (1 replies)
  204. Drop down list without blank cell (3 replies)
  205. Delete the list from UserForm (0 replies)
  206. [SOLVED:] Export Multiple wbk (10 replies)
  207. ClearingContents in ranges that don't intersect (10 replies)
  208. Sleeper: Cascade String concatenation problem (2 replies)
  209. Batch script for inputting data into cells (5 replies)
  210. VBA search function (4 replies)
  211. VBA Replace From Code to Range (7 replies)
  212. Excel formula help match (4 replies)
  213. Form Close (1 replies)
  214. VBA That Will Group Specific Blank Rows (8 replies)
  215. [SOLVED:] Removing duplicate from keywords (10 replies)
  216. Change first letter of word to uppercase (4 replies)
  217. [SOLVED:] Parenting Calendar in excel exported to CSV for import into google calendar (6 replies)
  218. importing sheet from another file - issue with data validation (1 replies)
  219. [SOLVED:] VBA to calculate TOTAL based on condition (2 replies)
  220. [SOLVED:] setting a cell to a formula (3 replies)
  221. Excel Vlookup and multiple search results (1 replies)
  222. [SOLVED:] Remove Header / Footer from files in folder (2 replies)
  223. [SOLVED:] VBA to insert blank rows based on conditions (2 replies)
  224. [SOLVED:] Get data in various cells based on a cell value from another sheet (2 replies)
  225. [SOLVED:] struggling with vbYes and vbNo coding (2 replies)
  226. Store in DataBase (29 replies)
  227. [SOLVED:] Data uploading from userform to excel when "No" is selected in msgbox (3 replies)
  228. [SOLVED:] Replacing drop downs by two multichoice listboxes to copy&paste in between sheets (3 replies)
  229. [SOLVED:] VBA copy / paste to the next specific row (2 replies)
  230. tracking worksheet changes over multiple columns (1 replies)
  231. [SOLVED:] CTRL + Shift + Down in a Macro (29 replies)
  232. [SOLVED:] select data using drop down list (6 replies)
  233. Fetching data in various cells based on on one cell (2 replies)
  234. cumulative sum between two dates (1 replies)
  235. Sleeper: How to calculate Volume Weighted Average Price (VWAP) of all relevant deals (2 replies)
  236. [SOLVED:] Good way to mark a textbox so users know it is required to fill (5 replies)
  237. VBA Update from Excel to SQL Table Contents. (3 replies)
  238. [SOLVED:] Excel VBA to read txt file, input all data into one cell (8 replies)
  239. [SOLVED:] Vba Custom Format "0000" in File Name (2 replies)
  240. [SOLVED:] Transfer data from Excel to double column of information in Word (15 replies)
  241. [SOLVED:] VBA macro code to expand a certain column (3 replies)
  242. [SLEEPER:] Case issue (4 replies)
  243. Find cell matching text then get last row before blank (9 replies)
  244. subtract today's date from a date in another column (5 replies)
  245. type mismatch error that i didn't get before (6 replies)
  246. [SOLVED:] Abbreviate the next succeeding instances of scientific names (20 replies)
  247. How to Calculate Standard Dev without using the worksheet function in VBA (2 replies)
  248. VBA Error When Add / Delete a Row (5 replies)
  249. [SOLVED:] Find and replace module help (5 replies)
  250. Convert from range to tables and code support? (2 replies)