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 Loop - If Cell is not empty then.... (6 replies)
  2. Display Data from Sheet (1 replies)
  3. [SOLVED:] Assigning values from a table (12 replies)
  4. Macro for copy & paste data from worksheets if path of file changes (1 replies)
  5. [SOLVED:] Generate 5/50 lottery combination with selected odd sum or by even sum!! (14 replies)
  6. excel 2016 splitting datasets creating new separate sheets (2 replies)
  7. VBA code to prompt user to select file folder but still keep the file name... (2 replies)
  8. [SOLVED:] Excel 2013>VBA>Function>Sum Visible Columns (9 replies)
  9. Enabling Content in access db with Excel VBA (0 replies)
  10. Excel Userform Listbox VBA Help (10 replies)
  11. [SOLVED:] How to replace a path in the code by a variable? (1 replies)
  12. Setting a range object & applying table style (9 replies)
  13. Excel 2013 VBA Import Dynamic Range from other Workbook (1 replies)
  14. (VBA) error adding Title and Subtitle to PowerPoint Slide (2 replies)
  15. Count number of mondays (21 replies)
  16. Count texts in two colums and if no match write data (1 replies)
  17. Adjust placement of copy paste to suit last row of previous paste (16 replies)
  18. [SOLVED:] Loop through combinations and add only Even & Odd numbers together within each. (5 replies)
  19. Counting rows in clipboard (4 replies)
  20. [SOLVED:] Apply different format to each column of selection (4 replies)
  21. [SOLVED:] How do I have a cell value displayed on my user form? (12 replies)
  22. Help with #Value! errors (4 replies)
  23. [SOLVED:] Loop through URLs, save source (2 replies)
  24. [SOLVED:] How to connect to a RECORDSET (13 replies)
  25. VBA to collect data from Pivot (0 replies)
  26. VBA: adjusting pivot table per macro (0 replies)
  27. MATCH VALUE FROM TAB2 and UPDATE TAB1-CONDITIONAL (2 replies)
  28. Copy Multiple sheet as SaveAs (1 replies)
  29. SUM of Values by Region and District (1 replies)
  30. Put Excel image to PowerPoint in specific location? (2 replies)
  31. Different references for same formula (more complicated than it sounds) (8 replies)
  32. [SOLVED:] Help Understanding Code (5 replies)
  33. Merging PDFs and Allowing for Filling of Adobe Fields (8 replies)
  34. VBA Cloudera Hadoop connection (1 replies)
  35. [SOLVED:] pulling data from a csv file based on specific dates (4 replies)
  36. VBA (3 replies)
  37. Compares different rectangular areas and highlights equal values (1 replies)
  38. [SOLVED:] Goal Seek without Cell Reference (18 replies)
  39. [SOLVED:] Clear activex listbox selection (5 replies)
  40. [SOLVED:] Excel Book Recommendations (2 replies)
  41. What Do You Think About This? (5 replies)
  42. Help -needed call named range based on cell value (5 replies)
  43. Directing SendKeys to the Correct Application (8 replies)
  44. Order Assignment Problem (2 replies)
  45. VBA to Add 3 Aligned Footers with Custom Formatting and Text (38 replies)
  46. [SOLVED:] Empty Row Deletion (2 replies)
  47. Values lookup in two different tables (2 replies)
  48. [SOLVED:] If range contans "0", mark as incomplete (2 replies)
  49. Combining parts of 3 workbooks (6 replies)
  50. Embedded HTML Image Issues (0 replies)
  51. [SOLVED:] Several If statements inside For Loop (2 replies)
  52. [SOLVED:] What is wrong with my VBA code? (20 replies)
  53. Using Range.Find to search another Open Workbook (1 replies)
  54. Is it possible at all? (2 replies)
  55. ODBC connection if not on users PC (0 replies)
  56. Copy and Paste based on cell value (3 replies)
  57. hide rows based on highlighted cell in column (6 replies)
  58. [SOLVED:] Error when using variable when connecting to SQL from Excel (3 replies)
  59. VBA wont run unless through the editor (6 replies)
  60. vba help (1 replies)
  61. Macro wont work with a cell which is updateing by formular (16 replies)
  62. Intermittent errors after running macro varying number of times (0 replies)
  63. VBA to Search both Email subject and/or Email Body in Outlook (3 replies)
  64. [SOLVED:] Preserve exact formula, monthly analysis for full year (1 replies)
  65. [SOLVED:] Excel Loop WITH Function (2 replies)
  66. [SOLVED:] Vba find and replace with loop (2 replies)
  67. VBA - Auto Select Sheet, Save & Close after 1 hour (7 replies)
  68. [SOLVED:] match delete vba (3 replies)
  69. [SOLVED:] Clear multi - select Listbox (21 replies)
  70. Remove string in text files (5 replies)
  71. [SOLVED:] Help needed with VBA to auto insert pic into comment (10 replies)
  72. Spreadsheet Consolidation based on specific path (6 replies)
  73. [SOLVED:] Types inside a Type (14 replies)
  74. Pivot find and replace (3 replies)
  75. Save as Types (3 replies)
  76. Textfile loop to find/replace characters (1 replies)
  77. [SOLVED:] Easy If-Than code for comparison of multiple values doesn't return correct value (2 replies)
  78. Lable the last know person to entra data to a cell from a list of names, populate dat (0 replies)
  79. [SOLVED:] Using Userform with Date Picker to Select Data Range in Excel (10 replies)
  80. Auto Data Display by Scanning. Please help (0 replies)
  81. VBC Excel to find latest creation date zip within folder, then open CSV file embedded (18 replies)
  82. IE WEBSITE FILE UPLOAD (9 replies)
  83. VBA to Find & Fill a cell based on row & column headers? (0 replies)
  84. VBA macro to hide rows based on cell value (6 replies)
  85. [SOLVED:] Macro for copy/paste values for only that row where the change is made (3 replies)
  86. Hyperlink from a cell in another sheet. Not quite working for me. (2 replies)
  87. Creating indivisual diaries from master rota (13 replies)
  88. [SOLVED:] Can this Conditional Formatting Code be simplified (7 replies)
  89. A day longer than 24 hours (1 replies)
  90. [SOLVED:] vba to loop through multiple worksheets and paste specific data based on a date (4 replies)
  91. [SOLVED:] Creating Sheets from Cell Value IF Only! (2 replies)
  92. VBA Current region minus header and last column (3 replies)
  93. [SOLVED:] Pivot Table Grand Total (2 replies)
  94. Percentage covered by values using VBA (7 replies)
  95. Last entry in a Column (2 replies)
  96. Auto updating of worksheets in an Excel Workbook (8 replies)
  97. Populate vlookup formula 1Million item (1 replies)
  98. [SOLVED:] Problem using keyPress command (10 replies)
  99. [SOLVED:] Applying a multiplication by macro on a column (18 replies)
  100. New VBA Code (1 replies)
  101. [SOLVED:] Filter and copy to WorkSheet help (2 replies)
  102. VBA matching, data manipulation across different worksheets (20 replies)
  103. [SOLVED:] Help Needed! Macro to pull if cell does not equal criteria (6 replies)
  104. Why is the sub or Function not defined for the following code (6 replies)
  105. [SOLVED:] vba or formula to find number of duplicates in a range (5 replies)
  106. Procedure Too Large (15 replies)
  107. Macro To Add DSN (2 replies)
  108. Why is the default value of UserInterfaceOnly False? (4 replies)
  109. [SOLVED:] How to extract date range into multiple rows? (4 replies)
  110. Save As Help (10 replies)
  111. Runtime 1004 error (5 replies)
  112. VBA code to copy / paste values only + auto change cell value (5 replies)
  113. Need to copy from all sheets from all workbooks (4 replies)
  114. How can I refresh a webpage in VBA before downloading it? (0 replies)
  115. Sleeper: Merge worksheets (2 replies)
  116. VBA excel help (22 replies)
  117. [SOLVED:] How to export variable from textbox into a cell after clicking on a button? (2 replies)
  118. Join Error (1 replies)
  119. Macro to pull outlook info based on excel values (0 replies)
  120. Hyperlink to specific sheets in workbook based on drop down selection (6 replies)
  121. I need to count the amount of weeks a piece of text has appeared since last change (6 replies)
  122. Advice needed to speed this code. (67 replies)
  123. course analysis from bitcoins with VBA (38 replies)
  124. Excel formula help (3 replies)
  125. NEW TO VBA...Need Help..driving me nuts (7 replies)
  126. Checking Excel background image with VBA (20 replies)
  127. [SOLVED:] HELP ON FIND/REPLACE (11 replies)
  128. Creating a form to filter data? (13 replies)
  129. Convert Table to Calendar (Wincalendar functionality) (0 replies)
  130. [SOLVED:] Can I use an excel sheet to calculate in a vba program? (2 replies)
  131. How to find and use the maximum value in VBA code (4 replies)
  132. Macro to remove marker line and border (7 replies)
  133. Help with the meaning of this code (13 replies)
  134. Writing to a cell in a loop (10 replies)
  135. Excel 2013 Macros Click-Activated Shapes (1 replies)
  136. A variable SUM formula in excel (3 replies)
  137. [SOLVED:] Accessing Excel Tab data from Button (6 replies)
  138. filter multiple columns simultaneously using Vbscript (1 replies)
  139. Using a barcode scanner with Excel (1 replies)
  140. Color Code Data According by Categories (7 replies)
  141. invalid or unqualified reference (6 replies)
  142. Combobox from external database, not working (3 replies)
  143. Avoid duplication in copying (1 replies)
  144. Sleeper: Need help with my code as it doesnt seem to be appearing (2 replies)
  145. [SOLVED:] Find average of all values between two index match values in table (2 replies)
  146. vba code To Save Copy As Cell.Value (2 replies)
  147. Macro Help - Pasting (4 replies)
  148. [SOLVED:] Load data from TXT to Excel sheet (numbers with decimal get like text) (11 replies)
  149. copy filtered data into different worksheet (0 replies)
  150. Selective listing of files in a folder (32 replies)
  151. Userform with changeable headers/ listboxes to opt for creating reports from Excel DB (0 replies)
  152. [SOLVED:] Sum Up Cells Value When Specific Value Match (3 replies)
  153. Help with text file row count - only want the last 13 rows (10 replies)
  154. Import particular data from book1 to book2 (0 replies)
  155. VBA Macro Help - Extract from Multiple Closed Workbooks (0 replies)
  156. [SOLVED:] Run-time error '445' - Object doesn't support this activity (18 replies)
  157. macro prompt? (3 replies)
  158. VBA VLOOKUP (0 replies)
  159. Select number of rows based cell value (5 replies)
  160. Saving Screenshots in excel (1 replies)
  161. Unable to get pivottable property of class (1 replies)
  162. Problem between macro event and SpinButton (3 replies)
  163. save and close an excel sheet when I press the Windows + L buttons (16 replies)
  164. Checkbox make values to textbox (2 replies)
  165. [SOLVED:] Type Mismatch Error Confusion (14 replies)
  166. Populating a Cell with a Table (5 replies)
  167. How to generate Sum formula in excel (3 replies)
  168. need a vba code HELLLLLPPPPPP (7 replies)
  169. [SOLVED:] Difficulty using KeyPress Command (2 replies)
  170. [SOLVED:] VBA - Change code to work on whole workbook (2 replies)
  171. How to insert a formula in a dynamic range using VBA (6 replies)
  172. Redim Preserve Change LBOUND (16 replies)
  173. [SOLVED:] Very omplicated calculation of hours worked (PLEASE HELP) (8 replies)
  174. How to execute a VBA program and halting another VBA code till the old program ends (6 replies)
  175. Problem with copying the text format. (2 replies)
  176. [SOLVED:] Macro to delete all rows between two different text stings in column A (8 replies)
  177. Reference specific text strings despite being repeated elsewhere? (18 replies)
  178. Macro to copy values from one sheet to another based on specific conditions (1 replies)
  179. excel help (0 replies)
  180. [SOLVED:] ListBox_Click event fires without clicking (9 replies)
  181. [SOLVED:] How to check if value starts with text (2 replies)
  182. Compare data from two workbooks (0 replies)
  183. [SOLVED:] UserForm that Stays Visible on Screen When Scrolling (7 replies)
  184. Web query Looping from table selection (6 replies)
  185. Macro to find and replace based on different text within one cell (4 replies)
  186. Generate Shapes, Align, Group, Cut and Paste (14 replies)
  187. [SOLVED:] List box looses Blue 'highlight' when changing forecolor (10 replies)
  188. [SOLVED:] Function working within Sub but not in spreadsheet (3 replies)
  189. VBA Pivot Table creation looks different than manual creation (2 replies)
  190. [SOLVED:] Test Pivot Table (4 replies)
  191. Strings and Variables (5 replies)
  192. read Tag property without opening file (7 replies)
  193. How to find and use the maximum value in VBA (7 replies)
  194. Macro to loop through Web Queries and enact a second macro once each page loads (1 replies)
  195. Match 1st ?? in column vertically, if Yes, then see if 2nd ?? matches horizontally? (4 replies)
  196. vba code for getting the filename for another worksheet on a newfile worksheet (1 replies)
  197. VBA code to remove text from a column (6 replies)
  198. [SOLVED:] Compiling a List to a Seperate Sheet (2 replies)
  199. How to make a solver VBA code in a dynamic range (1 replies)
  200. [SOLVED:] Excel 2013 ActiveX Combo Boxes Macro Glitch (3 replies)
  201. Trendline for y-values (1 replies)
  202. Match index with closest previous date (3 replies)
  203. [SOLVED:] Run-Time Error "1004" LOOPS! (5 replies)
  204. [SOLVED:] VBA find the FIRST real row (5 replies)
  205. Custom Menu/Macro Library (1 replies)
  206. [SOLVED:] How to get the absolute column number of given cell value from the range C2:K2 (3 replies)
  207. VBA CODE HELP ...if you have time!!! (10 replies)
  208. Consolidating Order Sheet (3 replies)
  209. How to leave just the text I want in a cell. (2 replies)
  210. VBA export filename and path (9 replies)
  211. Help with code to export excel to text file with number format (2 replies)
  212. Populate (string) array from sheet (1 replies)
  213. How to increment Alpha numeric Value (6 replies)
  214. VBA Fill arrays from sheet | SUMIFS | create & fill table based on multiple criteria (0 replies)
  215. Non Looping For Next Loop (3 replies)
  216. ActiveCell.Value=replace........not putting range in new column. (2 replies)
  217. Copy to multiple sheet based on cell value criteria (0 replies)
  218. [SOLVED:] Issue with Mass-Email Excel macro (2 replies)
  219. 1004 Error Copying and Pasting Range (2 replies)
  220. [SOLVED:] Group shapes in a single cell without select (1 replies)
  221. Copy Data From One Sheet to Another with Input Box (1 replies)
  222. Extract specific columns from DBF to Excel (0 replies)
  223. Macro to enter filepath on click browse button (4 replies)
  224. Listing values assosciated with headings on a worksheet (15 replies)
  225. [SOLVED:] Listing unique vales in a range with blank cells (8 replies)
  226. Copy Pivot Table From One Workbook To Another (0 replies)
  227. Copy data in disperce cells from multiple excel workbooks..? (5 replies)
  228. [SOLVED:] VBA Syntax to run sql statement with where and order by (1 replies)
  229. Download images from the excel and save to a Folder (4 replies)
  230. Flip an image in a userform? (1 replies)
  231. [SOLVED:] Something missing from code (2 replies)
  232. Help with Sub (3 replies)
  233. Add Active X Command Button to sheet and keep Userform Open (9 replies)
  234. Matching data from two different sheets (3 replies)
  235. Error Handling for data scraping (1 replies)
  236. lookup problem (1 replies)
  237. [SOLVED:] Align all shapes to the center of their cell (1 replies)
  238. Update data from mapping table to another worksheet (3 replies)
  239. Hide Excel Tabs-Heading-Formula Bar on Opening (3 replies)
  240. Play embedded wav file when workbook opens (12 replies)
  241. [SOLVED:] Confused between Date and Today (2 replies)
  242. Open workbook with one password close with another from a list?? (0 replies)
  243. formula to check different between 2 dates within same month in range (4 replies)
  244. Applying Border to symbols in Excel VBA (0 replies)
  245. power function in VBA (6 replies)
  246. [SOLVED:] error in VBA lookup code (1 replies)
  247. Get TIME format to match? (5 replies)
  248. Macro Automatically SUM upper data when entering new data (1 replies)
  249. Copy range into a image in Outlook (1 replies)
  250. Excel File Recovery (0 replies)