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. Textbox entry search populates into listbox I'm stuck on how to make the VBA code (0 replies)
  2. How to get data from 2 criteria (StartDatte to EndDatte) (0 replies)
  3. [SOLVED:] Code Products (5 replies)
  4. [SOLVED:] Odd scope of Workbook_WindowDeactivate? (10 replies)
  5. Macro to copy non-blank cells in 2 columns and paste values into first blank cells in (5 replies)
  6. [SOLVED:] Automating Copy And Paste (3 replies)
  7. [SOLVED:] Looking to code a function to efficiently remove multiple commas in a string (13 replies)
  8. Find variants of positions and value. Need help! (1 replies)
  9. Dynamic Userform for data entry (8 replies)
  10. Need help .Range.AutoFilter multiple field (4 replies)
  11. [SOLVED:] Search Column and skip hidden rows (3 replies)
  12. Error trying to attach file to email (2 replies)
  13. [SOLVED:] Assign each element of an array to a variable (5 replies)
  14. Load and Sort ComboBox with Dynamic Range From Sheet (1 replies)
  15. Conditional formatting (1 replies)
  16. VBA to Force the User to Enter Data into a Cell before moving to next cell (1 replies)
  17. [SOLVED:] Help storing values in Array and returning to 3 values (2 replies)
  18. [SOLVED:] VBA Compile Error "Else without if" (4 replies)
  19. Break single row into multiple rows based on FORMAT (2 replies)
  20. convert alpha to numeric (1 replies)
  21. How do I make a data scraper [Copy and pastes multiple pages into excel]? (0 replies)
  22. Novice syntax question...if then statements...error 1004 (1 replies)
  23. [SOLVED:] K-ESIMO MATRIX FORMULA (10 replies)
  24. [SOLVED:] Adding a line to an acces table from a vba userform (1 replies)
  25. [SOLVED:] populating combobox from access table (6 replies)
  26. Macro to Check For a Cell Value and Perform Null & Data Type Check for multiple Cols (0 replies)
  27. Macro to check 4 columns to check for Unique combination & highlight dups (2 replies)
  28. [SOLVED:] Need Help, How to Add more than 10 Columns ? (6 replies)
  29. [SOLVED:] Lookup Max value on one sheet and populate on another in used range (8 replies)
  30. [SOLVED:] Changing source range of pivot table (2 replies)
  31. Macro for infinitely moving data to new location (need help). (6 replies)
  32. automatic removal of empty rows (3 replies)
  33. Check Number of rows and insert category name (10 replies)
  34. [SOLVED:] Excel chart problem's (2 replies)
  35. Add Zeros At End of String (7 replies)
  36. [SOLVED:] VBA text conversion into Number Help (7 replies)
  37. [SOLVED:] User Input to VLOOKUP a number in spreadsheet (7 replies)
  38. All pivot charts export at a time to folder doesn't work in excel 2016 (0 replies)
  39. [SOLVED:] Report Generator Fix - Run-time error '1004': Doc not saved (3 replies)
  40. [SOLVED:] Can this code be optimized with regard to the Do While...Loop? (5 replies)
  41. [SLEEPER:] Error while connecting to Oracle database from excel macro (1 replies)
  42. Help with a macro to check results and highlight future forecasts (0 replies)
  43. [SOLVED:] Update Master File With Data From Open Workbook (19 replies)
  44. [SOLVED:] delete sign pilcrow in combobox (8 replies)
  45. Copy multiple files from one folder to other using the file names given in excel. (1 replies)
  46. [SOLVED:] Embedding the most recent picture taken into a cell (11 replies)
  47. [SOLVED:] Simplify XY Scatter into short line segments, individually colored (4 replies)
  48. exclude a row in code (1 replies)
  49. [SOLVED:] VBA Combining tables into one - value paste needed (1 replies)
  50. [SOLVED:] Set File Path to Cell in a workbook (2 replies)
  51. [SOLVED:] VBA macro for combining several cells into one (4 replies)
  52. Combo Box linked with List box (0 replies)
  53. [SOLVED:] Automatic Filter (3 replies)
  54. Outputing the time taken for a calculation (1 replies)
  55. Content in a range is not clearing when i using F5 key (1 replies)
  56. Selection Clear Content (2 replies)
  57. Excel Window - Automatically Resizes to Last Size (0 replies)
  58. [SOLVED:] Insert new row above specific text (3 replies)
  59. Search for files/folder based on excel list info and copy them to new destination fol (1 replies)
  60. merge/join/combine multiple tables into one master table (2 replies)
  61. [SOLVED:] Lookup Value in two columns and identify opposite values (5 replies)
  62. Userform for Data Entry Into Several Different Worksheets (0 replies)
  63. Match same quote number and roll up (0 replies)
  64. [SLEEPER:] How to simulate Brownian motion for multiple trajectories? (1 replies)
  65. Help Deleting Rows with "If, then" statement (1 replies)
  66. [SOLVED:] Insert cell content in shapes VBA (20 replies)
  67. [SOLVED:] VBA macro for filtering and copying duplicates (8 replies)
  68. Find cell, make active cell and repeat (5 replies)
  69. capture specific records from multiple sheets to one sheet (1 replies)
  70. Excel VBA macro to copy specific rows and delete it (4 replies)
  71. multiple vlookup formula is not working (3 replies)
  72. [SOLVED:] Vlookup in VBA: lookup multiple values (11 replies)
  73. [SOLVED:] Array Index new with Criteria of Old Array (2 replies)
  74. How to highlight cells with dependents in other worksheets? (6 replies)
  75. Copy a varying range (1 replies)
  76. Find Z value from given XY. Obtain plane from 3 coordinates VBA function (3 replies)
  77. [SOLVED:] Conditional formatting of cells for 45 different cases with 5 criteria each (8 replies)
  78. Need a Help to expand the data in HTML Page in Internet Explorer (0 replies)
  79. [SOLVED:] Concatenate Date and Keep Formatting (8 replies)
  80. Code Execution Speed (0 replies)
  81. Loading text file with specific name in excel (1 replies)
  82. custom function in Excel VBA which takes an array as an argument (3 replies)
  83. Search for a word and get the (row, column) numbers, when the word is found. (3 replies)
  84. [SOLVED:] Need help creating a loop please (6 replies)
  85. conditional format on a different column (1 replies)
  86. [SOLVED:] Multiple Find/Replace At Once (Feeding From A Table) (9 replies)
  87. Need Help: Import worksheets by name using an array of defined names (6 replies)
  88. Need Help - VBA HTML Wikipedia data (0 replies)
  89. [SOLVED:] Need help modifying VBA code to suit requirements - Listing Uniques based on criteria (2 replies)
  90. [SOLVED:] Copy-Paste cell text content + delete rows (4 replies)
  91. Need help: I am out of my depth. (9 replies)
  92. [SOLVED:] Need help passing variable values to For Loop (3 replies)
  93. Sales in the fortnight (1 replies)
  94. Find last match in date sorted list using index match with multiple conditions (2 replies)
  95. Excel will lock specific area based on a date (0 replies)
  96. Need a little help please (3 replies)
  97. [SOLVED:] copy data in specific columns to another sheet (5 replies)
  98. VBA - Importing External Data from Txt Files (3 replies)
  99. Split Workbook Into Multiple Workbooks (1 replies)
  100. How to copy rows from a sheet to ather sheets in the same workboouk with criteria (5 replies)
  101. VBA code fastest highlight of unique values (8 replies)
  102. [SOLVED:] help with validation (5 replies)
  103. [SOLVED:] Find Match, Copy/Paste to a closed worksheet in workbook (1 replies)
  104. Interfacing with local 'virtual' server (0 replies)
  105. Excel SmartArt Organizational Chart - Name and Title (2 replies)
  106. [SOLVED:] MouseMove event for disabled controls. (9 replies)
  107. Copy Range Until Last Cell With Data (4 replies)
  108. How To Detect Click On Zoom In Status Bar? (1 replies)
  109. Userform with Combobox launched from Worksheet (4 replies)
  110. use excel vba to select an item in a Kendo grid in IE (0 replies)
  111. Select different cells in several sheets. (8 replies)
  112. [SOLVED:] No Pair (13 replies)
  113. VBA Find & Replace based on cell reference within a range (4 replies)
  114. [SOLVED:] Help sorting numbers in listbox in ascending order (5 replies)
  115. Active Cell and Timers - Fix References (8 replies)
  116. Manual calendar (1 replies)
  117. Group data on one table based on information in another table (0 replies)
  118. [SOLVED:] Public procedure to sort similar rows (2 replies)
  119. Creating a message box with multiple options (1 replies)
  120. [SOLVED:] Macro not copying down lines (4 replies)
  121. Macro for removing 2 letters word (9 replies)
  122. Excel And Perfmon (1 replies)
  123. [SOLVED:] List Box - Reset Button - Search Filter Clear (3 replies)
  124. [SOLVED:] Formula to Display Several Strings of Text in a Cell (2 replies)
  125. Copy Highlighted Cell to Another Worksheet (1 replies)
  126. Loop to concatenate cells (12 replies)
  127. How to relate. OPTION BUTTONS (2 replies)
  128. Merging of files where columns are the same (0 replies)
  129. VBA Classes (10 replies)
  130. "For Loop" to Change "Chart title" based on sequential cells (4 replies)
  131. Sleeper: Error in VBA Excel (2 replies)
  132. Pivot table to refreash and ask for new filter dates (0 replies)
  133. [SOLVED:] Concatenate Two Cells in a third cell (7 replies)
  134. [SOLVED:] Separate files and save them in PDF format (4 replies)
  135. Count down timer help (6 replies)
  136. What is the best way to combine multiple workbooks into one? (1 replies)
  137. List Box - Application.run Macros (8 replies)
  138. [SOLVED:] Autofilter problem (5 replies)
  139. [SOLVED:] Download Attachment from Email and extract Data (3 replies)
  140. I simply can't do it alone (simple VBA macro to search and find), please help!? (0 replies)
  141. Find Max Value in one worksheet and return the value to a cell in another (7 replies)
  142. Highlighting row containing specific word in specific column (3 replies)
  143. [SOLVED:] code not calculating storage charge correctly (7 replies)
  144. [SOLVED:] Listbox Multiselect issue (10 replies)
  145. [SOLVED:] Importing data from Word to Excel in non-continuous fields (0 replies)
  146. Passing selections from a drop down box to loop in sub procedure (4 replies)
  147. Merge Only Visible Worksheets (1 replies)
  148. [SOLVED:] Index Match Over Multiple Worksheets (1 replies)
  149. Create New Folders - Input Box (6 replies)
  150. VLookup to skip blank cell (1 replies)
  151. [SOLVED:] Ranking the rows without sorting (8 replies)
  152. Shuffleboard tournament math (6 replies)
  153. [SOLVED:] Highlight two sets of cells based on selection. (2 replies)
  154. Use conditional statement to sum column values and paste to new worksheet (12 replies)
  155. [SOLVED:] Change multiple Form Control Button captions from a list on another worksheet (2 replies)
  156. Parsing websites (11 replies)
  157. [SOLVED:] identify Highlight Overlap dates (10 replies)
  158. could not get single (last) element while looping through class name (web scraping) (2 replies)
  159. [SOLVED:] Procedure for merging common values in same column (2 replies)
  160. [SOLVED:] Combobox question (1 replies)
  161. Save SVG image as png or jpg format from a website (6 replies)
  162. [SLEEPER:] VBA Import Text Line by Line to formatted Cells (3 replies)
  163. Question about Copy and paste DataObject in excel worksheet (5 replies)
  164. [SOLVED:] Need Way to move certain data when certain column is updated (4 replies)
  165. Help me for ListBox ListFillRange (3 replies)
  166. Last Occurence of last month Transaction using Index sumproduct (6 replies)
  167. VBA REPLACE CURRENT CELL WITH CURRENT MONTH AND TEXT (6 replies)
  168. download company URL's & company names across multiple pages from web (Web scraping) (7 replies)
  169. [SOLVED:] Code That Creates Names based on the Sheet Name (4 replies)
  170. [SOLVED:] ActiveX Label (2 replies)
  171. [SOLVED:] MERGE 2 DİFFERENT VBA CODE (5 replies)
  172. [SLEEPER:] VLOOKUP, INDEX and MATCH formatting problem (5 replies)
  173. Filename Variable (8 replies)
  174. Help is multiple nested IF statements using range objects (4 replies)
  175. Mapping userform checkbox value to Outlook (0 replies)
  176. [SOLVED:] How to unzip with VBA? (2 replies)
  177. Consolidate multiple workbooks and worksheets from a folder (5 replies)
  178. Word Document Data to Excel Spreadsheet code/macro (4 replies)
  179. Please help me with this excel generator (3 replies)
  180. Prevent Copying Worksheets (9 replies)
  181. Macro Formula with dynamic ranges (1 replies)
  182. SubTest Help for debugging (5 replies)
  183. VBA Print to PDF Button code issues with multiple users (2 replies)
  184. Change file extensions (9 replies)
  185. [SOLVED:] Autofilter in Macro not working! (8 replies)
  186. Create if statement: if value exists then create new sheet (6 replies)
  187. Limiting the number of checkboxes to be selected (1 replies)
  188. [SOLVED:] Copy entire row to new tab if a cell contains certain text (13 replies)
  189. Copy row to exisiting tab and then delete (1 replies)
  190. [SOLVED:] VBA: Index/Match (1 replies)
  191. Outputting to more than one cell at the one time in VBA (1 replies)
  192. help with dynamic offset (12 replies)
  193. Add additional step to macro (2 replies)
  194. MACRO: IF THEN Statement (Multiple Criteria Match then Copy) (48 replies)
  195. Positioning labels within chart (1 replies)
  196. VBA: VLOOKUP with LOOP (1 replies)
  197. [SOLVED:] no idea (8 replies)
  198. IN Statement in VBA (6 replies)
  199. [SOLVED:] Compare data between two sheets (4 replies)
  200. VBA - help assigning varibles (2 replies)
  201. [SOLVED:] Time Loop (3 replies)
  202. Cell Anchoring in VBA?? (4 replies)
  203. Listboxes with filtered data > import data from table to userform? (4 replies)
  204. How to put timestamp on a cell using a button VBA (1 replies)
  205. [SOLVED:] Help getting a Macro to work!! (8 replies)
  206. Gmail Login failed (Web Scraping) (6 replies)
  207. [SOLVED:] Copy values from loop and paste in different worksheet (3 replies)
  208. [SOLVED:] DDD.MMSS to DDD-MM-SS (9 replies)
  209. [SOLVED:] Multiple Excel sheets update (3 replies)
  210. Consolidating multiple worksheet into one by finding Column Name (1 replies)
  211. Interact with Internet Explorer open tabs - VBA (0 replies)
  212. Custom Sort Parts List - VBA (11 replies)
  213. [SOLVED:] datevalue error - #Value (2 replies)
  214. Facing problem with update the record (3 replies)
  215. [SOLVED:] IF formula in Macro for entire row (9 replies)
  216. VBA to merge / unmerge identified rows when target is used (1 replies)
  217. Function Error (6 replies)
  218. [SOLVED:] Replace Number In A Column With A Different Number (5 replies)
  219. Runtime 91 error on userform populating one input box on webpage (7 replies)
  220. [SOLVED:] Coding Help for Range Calculations (5 replies)
  221. [SOLVED:] Excel VBA refer to a userform by variable to address it (8 replies)
  222. Copy & Paste Dynamic Range to New Worksheet (2 replies)
  223. Decode Base64 to String in VBA to Excel cell (8 replies)
  224. vba loop to find and change value in textbox on userform (2 replies)
  225. [SOLVED:] Insert picture name in worksheet change (7 replies)
  226. [SOLVED:] Sorting Columns into Tables (2 replies)
  227. range: from active cell to last cell in current column (discontinuing) (6 replies)
  228. Show column heading and corresponding value based on dropdown selection (6 replies)
  229. Changing Combo Box Selection Value (2 replies)
  230. Transform data from vertical to horizontal (11 replies)
  231. [SOLVED:] VBA macro for comparing 4 columns and highlight (3 replies)
  232. Reading 1st row of a CSV file into Array without opening it (7 replies)
  233. [SOLVED:] ListBox1_Click to select an item on a worksheet (3 replies)
  234. [SOLVED:] VBA Regex (2 replies)
  235. [SOLVED:] transfer of information from identical excel files and identical sheets of accumulati (15 replies)
  236. Overriding Disable copy/paste code (2 replies)
  237. [SOLVED:] Need help gettin this macro to run faster, Please! (79 replies)
  238. Error Trying to send email via Excel (2 replies)
  239. Vlookup Error with Negative Value Range (4 replies)
  240. Changing values based on offset values (2 replies)
  241. VBA to Copy and Past from One Sheet to Another (1 replies)
  242. [SOLVED:] Why does the "Format shape" window appear when i run a macro? (4 replies)
  243. textbox format (5 replies)
  244. Macro to Automate a school timetable workbook (1 replies)
  245. [SOLVED:] Mac excel shortcut to select all rows till end (1 replies)
  246. [SOLVED:] Way to speed up this newbie's simple recalc/copy/paste loop? (10 replies)
  247. [SOLVED:] Identify unique items in column and delete row (2 replies)
  248. 2 issues with Macros (Printing Pages & Not copying data when worksheet is Blank) (2 replies)
  249. [SOLVED:] Need Help restructuriing Macro that highlights dups to highlight also partial (2 replies)
  250. [SOLVED:] Removing duplicates from cells across rows, not down columns, without deleting rows (2 replies)