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. VBA - select a drop-down in a web (2 replies)
  2. Select specific tab in already open instance of Internet Explorer (0 replies)
  3. [SOLVED:] Excel VBA Project References (7 replies)
  4. Advanced Auto Filter Long Text Strings From List Table (3 replies)
  5. Toggle Shape Text & Colour On Click - Application.Caller (1 replies)
  6. [SOLVED:] Storing unique values in array (4 replies)
  7. Create Pivot Table from multiple sheets (1 replies)
  8. Filtered visible cells to Userform as row source. (5 replies)
  9. Polygone färben (2 replies)
  10. [SOLVED:] Summarize Data to New Sheet (20 replies)
  11. [SOLVED:] Automate Lookup Function to create participant schedules (7 replies)
  12. Add to Dynamic List if it doesn't exist (2 replies)
  13. Copy Rows - If Column B has the Word Found in a Worksheet List (2 replies)
  14. List all possible order combinations (3 replies)
  15. excel spreadsheet with macro to run without openning excel in specific time everyday (3 replies)
  16. VBA - Copy/Paste in new sheet + delete blank cells (6 replies)
  17. VBA - search and display the results from the websites (5 replies)
  18. copying data from worksheet to another (19 replies)
  19. Combo box data to select sheet (16 replies)
  20. ReadLine command for UNIX txt file (4 replies)
  21. Picturebox in Worksheet SetPixel (0 replies)
  22. If Statement Excel Macro (9 replies)
  23. help to fetch data from a closed file in excel (3 replies)
  24. [SOLVED:] UserForm Update/TextBox DblClick (11 replies)
  25. [SOLVED:] For loop very bad performance (8 replies)
  26. Import Data from txt file in specific cells (8 replies)
  27. Macro encrypt-decrypt function in one (1 replies)
  28. VBA Macro to combine workbooks in a folder into a "Master sheet" (2 replies)
  29. copying all columns including hidden (2 replies)
  30. [SOLVED:] Send data from multiple worksheet to a summary worksheet (3 replies)
  31. saving selected worksheets into new file (1 replies)
  32. VBA for Input Date (11 replies)
  33. [SOLVED:] Macro to Change all Date formats in workbook to 01/2017 to 01.2017 (and vice versa) (8 replies)
  34. [SLEEPER:] Macro to UnGroup and Group Based on Current Month (1 replies)
  35. Receipt Format (3 replies)
  36. [SOLVED:] Look for duplicates across 2 identical tabs, remove then merge remaining data (4 replies)
  37. Navigate web pages until search complete (1 replies)
  38. [SOLVED:] Reference Another Workbook Using Relative and Fixed Cell References (3 replies)
  39. [SOLVED:] Concatenate Rows Of Data (4 replies)
  40. Target.value (2 replies)
  41. Find Multiple String Variables in a different sheet (5 replies)
  42. Automating Internet Explorer / Interacting with HTML class question (0 replies)
  43. [SOLVED:] Clear Data Module - Clearing Header when No Data (3 replies)
  44. [SOLVED:] ndate returning time in Holland not London (10 replies)
  45. Pivotal Filter Selection Macro (25 replies)
  46. Compare two images (1 replies)
  47. VBA for make resume by date (Unique & No Duplicate) (3 replies)
  48. Download File from Website From Excel (2 replies)
  49. Excel - how to hide columns but allow users to insert rows (1 replies)
  50. InStr - Not operating (6 replies)
  51. Convert Excel to Web Application (1 replies)
  52. userform textbox test for format (2 replies)
  53. Outlook 2013 Global Address List Alias to Excel Document (0 replies)
  54. Improving a Concatenate & Vlookup Process (1 replies)
  55. Excel Macro Find and Replace Functions within Cell Formulae (21 replies)
  56. [SOLVED:] Write from excel to text file format (3 replies)
  57. excel vba macros help needed (9 replies)
  58. evaluate a date with vba (4 replies)
  59. Accessing a network file that might already be open by another user (0 replies)
  60. [SOLVED:] Select next cell after dynamic range (4 replies)
  61. [SOLVED:] OLE - Embedded Custom Icon won't stick (2 replies)
  62. [SOLVED:] Excel Select the Rows - Input Box - Save to Text Files (3 replies)
  63. The paste method of the _chart object failed (10 replies)
  64. [SOLVED:] Reading in a text file and only printing certain lines (3 replies)
  65. Implementing Save As function in VBA code (1 replies)
  66. Iterating through Groupings using VBA (4 replies)
  67. [SOLVED:] VBA macro to order and delete information (8 replies)
  68. Writing registry keys with API Calls (7 replies)
  69. VBA Newbie (Trying to write a code to copy and paste info from one sheet to another) (2 replies)
  70. Array Values filling specific cells (6 replies)
  71. passing string from userform to public module variable (1 replies)
  72. Auto populating text fields on websites and scraping the web (1 replies)
  73. Issue creating SQL query from string in VBA (3 replies)
  74. Need to split sheets based on number of family members (5 replies)
  75. [SOLVED:] How can I put the results of the Array back to the corresponding cells? (29 replies)
  76. Invoke an .exe file using macro in excel (1 replies)
  77. PivotSelect Question (4 replies)
  78. [SOLVED:] Applying Proper Case to Strings (10 replies)
  79. Reducing the need for Multiple hardline codes (40 replies)
  80. Changing a font style and color in VBA (9 replies)
  81. Reading a Text File into an Intermediate Window (12 replies)
  82. [SOLVED:] Stack bar chart configuration in Excel (2 replies)
  83. List select and copy sheet from another location (1 replies)
  84. Ask for Explanation (14 replies)
  85. How to refer on a picture on a different worksheet (6 replies)
  86. Userform Standalone/Hide Excel Application (0 replies)
  87. [SOLVED:] Check value based on cell text and turn another cell Green if there is a match (2 replies)
  88. [SOLVED:] autohide userform with active sheet modification (3 replies)
  89. Find DUP, remove both same entries (4 replies)
  90. calling inputbox if cell value is true (5 replies)
  91. [SOLVED:] No response to change event (4 replies)
  92. Automatically Converting Numbers stored as text to numers (1 replies)
  93. VBA Autofilter 3 Criteria (14 replies)
  94. Adding prefix to cell in column as it is added (9 replies)
  95. Add row to table refering to a Cell Value (1 replies)
  96. [SOLVED:] .pattern help please (2 replies)
  97. Help with populating a table with values on other sheets (1 replies)
  98. drop down lists vba (0 replies)
  99. [SOLVED:] Image frame resolution (2 replies)
  100. [SOLVED:] thisworkbook.path and dir function (1 replies)
  101. [SLEEPER:] How to make Total Row always at the Last Row / bottom of the Printed Page (0 replies)
  102. Copy Transpose and Paste Macro (11 replies)
  103. [SOLVED:] Extract Numeric Substring From longer String (12 replies)
  104. [SOLVED:] Macro to Autofill (3 replies)
  105. VBA code to create Indented BOM (2 replies)
  106. Data Entry from Excel or CSV to AS400 Emulator is possible or not? (3 replies)
  107. [SOLVED:] Looping through checkboxes in user form (2 replies)
  108. Get rid of extra row height with Word Wrap (3 replies)
  109. [SOLVED:] Pull data from specific worksheet from multiple workbooks (2 replies)
  110. Get a Cell into a Standard Format depending on its Contents - UDF/Formula Only (8 replies)
  111. Autofill formula help (3 replies)
  112. Using .Value fails when initialising a user form (3 replies)
  113. explore the land owner (3 replies)
  114. Adding Worksheets to an Array (18 replies)
  115. Calculate months onwards from set date (2 replies)
  116. VBA for sending Bulk Email with Unique Attachments in XLS to Unique Receipient (10 replies)
  117. i could not paste the copied data (VBA) (1 replies)
  118. wildcard character is not working while opening excel file (5 replies)
  119. Issues with VBA's vbModeless for programmatically-created userforms: they close (5 replies)
  120. [SOLVED:] Array Relative Erase Variables but Next (4 replies)
  121. [SOLVED:] VBA for Auto Filter and Copy/Past the Visible Cells at Destination Workbook (14 replies)
  122. [SOLVED:] Help with Filtering...(autofilter) (6 replies)
  123. [SOLVED:] excel 2010 dashbord to show totals (2 replies)
  124. [SOLVED:] Please Modify this VBA for New Requirement Or Provide a New One (9 replies)
  125. [SOLVED:] To Pull out Certain Set of Data from a Cell [ Urgent ] (6 replies)
  126. VBA to write PDF froms from Excel, Radio Buttons (4 replies)
  127. [SOLVED:] Need a UDF to Identify and remove parts of Cell Data from a Range (2 replies)
  128. inputBox default input in code, user not input (5 replies)
  129. Find a name from a list of names (14 replies)
  130. VBA freeze / timeout when processing large data sets (6 replies)
  131. Smartview connection issue (0 replies)
  132. [SOLVED:] working with record sets (0 replies)
  133. [SOLVED:] 3 Contact Numbers along with , (coma) Too many arguments (2 replies)
  134. Ending a Sub on a Timer Loop (3 replies)
  135. sum if textbox <>"" (3 replies)
  136. Can i create a Licence to an excel vba solution !? (1 replies)
  137. How to add cells with Conditional Formatting (1 replies)
  138. VBA code to delete row is value in column is less than a specific defined value (4 replies)
  139. [SOLVED:] Selecting pages to print within worksheet (4 replies)
  140. VBA - Verification of the sheet > MsgBox (5 replies)
  141. VBA (Noob): Automatically select the next row (8 replies)
  142. [SOLVED:] Is there a way to add Arrow Keys to Excel's Quick Access Toolbar? (2 replies)
  143. Check if library exists (8 replies)
  144. [SOLVED:] Copy/Paste unique rows based on multiple criteria (8 replies)
  145. Different custom ribbon for each sheet (0 replies)
  146. Defining Name Ranges Using VBA (3 replies)
  147. [SOLVED:] Need to remove a certain part of cell Data (8 replies)
  148. Lookup Text Value (0 replies)
  149. Copy / Display row from another sheet (18 replies)
  150. Didn't work my macro to copy&paste only as formulas by default... can you give it a q (4 replies)
  151. [SOLVED:] Adding A Reference (8 replies)
  152. [SOLVED:] Show Column Headings in PDF's to Be Emailed (2 replies)
  153. VB Excel, increase factor in table (5 replies)
  154. about Array (13 replies)
  155. [SOLVED:] Delete row if it contains a certain criteria Please Help (2 replies)
  156. [SOLVED:] Macro to delete rows (5 replies)
  157. Excel VBA: limit file opening times, AND prevent copying. plus authorization code (9 replies)
  158. [SOLVED:] Non-Printing Characters: Box with a Question Mark Unable to remove (15 replies)
  159. count the number of changes in several cells (1 replies)
  160. Choose date and calculate onwards (11 replies)
  161. Extracting and refreshing data set (5 replies)
  162. Date generating (8 replies)
  163. [SOLVED:] Using If function to separate data into multiple sheet (21 replies)
  164. Excel eMail sending failure in Windows 10 (3 replies)
  165. Need to consolidate comments across spreadsheets (4 replies)
  166. [SOLVED:] In a userform, applying results to a different workbook (3 replies)
  167. [SOLVED:] Automatically readjusting a Pivot Table's data source range (3 replies)
  168. [SOLVED:] Remove numbers of a 1st column founded in a 2nd one (1 replies)
  169. [SOLVED:] Need help with Multiple Pivot Table PivotField filters (1 replies)
  170. [SOLVED:] Printing multiple ranges/charts from different sheets at the same time? (5 replies)
  171. Need help with MSXML2.serverXMLHTTP request (0 replies)
  172. [SOLVED:] VBA search (18 replies)
  173. Textbox entry search populates into listbox I'm stuck on how to make the VBA code (0 replies)
  174. How to get data from 2 criteria (StartDatte to EndDatte) (0 replies)
  175. [SOLVED:] Code Products (5 replies)
  176. [SOLVED:] Odd scope of Workbook_WindowDeactivate? (10 replies)
  177. Macro to copy non-blank cells in 2 columns and paste values into first blank cells in (5 replies)
  178. [SOLVED:] Automating Copy And Paste (3 replies)
  179. [SOLVED:] Looking to code a function to efficiently remove multiple commas in a string (13 replies)
  180. Find variants of positions and value. Need help! (1 replies)
  181. Dynamic Userform for data entry (8 replies)
  182. Need help .Range.AutoFilter multiple field (4 replies)
  183. [SOLVED:] Search Column and skip hidden rows (3 replies)
  184. Error trying to attach file to email (2 replies)
  185. [SOLVED:] Assign each element of an array to a variable (5 replies)
  186. Load and Sort ComboBox with Dynamic Range From Sheet (1 replies)
  187. Conditional formatting (1 replies)
  188. VBA to Force the User to Enter Data into a Cell before moving to next cell (1 replies)
  189. [SOLVED:] Help storing values in Array and returning to 3 values (2 replies)
  190. [SOLVED:] VBA Compile Error "Else without if" (4 replies)
  191. Break single row into multiple rows based on FORMAT (2 replies)
  192. convert alpha to numeric (1 replies)
  193. How do I make a data scraper [Copy and pastes multiple pages into excel]? (0 replies)
  194. Novice syntax question...if then statements...error 1004 (1 replies)
  195. [SOLVED:] K-ESIMO MATRIX FORMULA (10 replies)
  196. [SOLVED:] Adding a line to an acces table from a vba userform (1 replies)
  197. [SOLVED:] populating combobox from access table (6 replies)
  198. Macro to Check For a Cell Value and Perform Null & Data Type Check for multiple Cols (0 replies)
  199. Macro to check 4 columns to check for Unique combination & highlight dups (2 replies)
  200. [SOLVED:] Need Help, How to Add more than 10 Columns ? (6 replies)
  201. [SOLVED:] Lookup Max value on one sheet and populate on another in used range (8 replies)
  202. [SOLVED:] Changing source range of pivot table (2 replies)
  203. Macro for infinitely moving data to new location (need help). (6 replies)
  204. automatic removal of empty rows (3 replies)
  205. Check Number of rows and insert category name (10 replies)
  206. [SOLVED:] Excel chart problem's (2 replies)
  207. Add Zeros At End of String (7 replies)
  208. [SOLVED:] VBA text conversion into Number Help (7 replies)
  209. [SOLVED:] User Input to VLOOKUP a number in spreadsheet (7 replies)
  210. All pivot charts export at a time to folder doesn't work in excel 2016 (0 replies)
  211. [SOLVED:] Report Generator Fix - Run-time error '1004': Doc not saved (3 replies)
  212. [SOLVED:] Can this code be optimized with regard to the Do While...Loop? (5 replies)
  213. Error while connecting to Oracle database from excel macro (1 replies)
  214. Help with a macro to check results and highlight future forecasts (0 replies)
  215. [SOLVED:] Update Master File With Data From Open Workbook (19 replies)
  216. [SOLVED:] delete sign pilcrow in combobox (8 replies)
  217. Copy multiple files from one folder to other using the file names given in excel. (1 replies)
  218. [SOLVED:] Embedding the most recent picture taken into a cell (11 replies)
  219. [SOLVED:] Simplify XY Scatter into short line segments, individually colored (4 replies)
  220. exclude a row in code (1 replies)
  221. [SOLVED:] VBA Combining tables into one - value paste needed (1 replies)
  222. [SOLVED:] Set File Path to Cell in a workbook (2 replies)
  223. [SOLVED:] VBA macro for combining several cells into one (4 replies)
  224. Combo Box linked with List box (0 replies)
  225. [SOLVED:] Automatic Filter (3 replies)
  226. Outputing the time taken for a calculation (1 replies)
  227. Content in a range is not clearing when i using F5 key (1 replies)
  228. Selection Clear Content (2 replies)
  229. Excel Window - Automatically Resizes to Last Size (0 replies)
  230. [SOLVED:] Insert new row above specific text (3 replies)
  231. Search for files/folder based on excel list info and copy them to new destination fol (1 replies)
  232. merge/join/combine multiple tables into one master table (2 replies)
  233. [SOLVED:] Lookup Value in two columns and identify opposite values (5 replies)
  234. Userform for Data Entry Into Several Different Worksheets (0 replies)
  235. Match same quote number and roll up (0 replies)
  236. How to simulate Brownian motion for multiple trajectories? (1 replies)
  237. Help Deleting Rows with "If, then" statement (1 replies)
  238. [SOLVED:] Insert cell content in shapes VBA (20 replies)
  239. [SOLVED:] VBA macro for filtering and copying duplicates (8 replies)
  240. Find cell, make active cell and repeat (5 replies)
  241. capture specific records from multiple sheets to one sheet (1 replies)
  242. Excel VBA macro to copy specific rows and delete it (4 replies)
  243. multiple vlookup formula is not working (3 replies)
  244. [SOLVED:] Vlookup in VBA: lookup multiple values (11 replies)
  245. [SOLVED:] Array Index new with Criteria of Old Array (2 replies)
  246. How to highlight cells with dependents in other worksheets? (6 replies)
  247. Copy a varying range (1 replies)
  248. Find Z value from given XY. Obtain plane from 3 coordinates VBA function (3 replies)
  249. [SOLVED:] Conditional formatting of cells for 45 different cases with 5 criteria each (8 replies)
  250. Need a Help to expand the data in HTML Page in Internet Explorer (0 replies)