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:] Input 2 files and create 3rd file (4 replies)
  2. [SOLVED:] Multiply two columns and sum a column in Listview (4 replies)
  3. Need VBA code revised to ignore the Column A data, please! (3 replies)
  4. Compress Mutilple Files (0 replies)
  5. Need Help with Excel Project (0 replies)
  6. [SOLVED:] Show UserForm ONLY once workbook is fully open & displayed (15 replies)
  7. [SOLVED:] Adding to Collections (2 replies)
  8. [SOLVED:] How to ignore hidden columns (3 replies)
  9. Highlight 2 Cells Based on a text value(false) (0 replies)
  10. Dialog box, select rows>5, delete in multiple worksheets (17 replies)
  11. Hyperlink Error handling challenges. (7 replies)
  12. [SOLVED:] How DO I remove the FALSE return from this formula to leave an empty cell. (3 replies)
  13. I have a formula that needs to be turned into a VBA, please! (7 replies)
  14. VBA - Connecting to Database using System DSN (0 replies)
  15. CommandButton - Save in multiple locations (1 replies)
  16. [SOLVED:] Need VBA out- put to different location on worksheet. (10 replies)
  17. Moving data labels to variable location on bar chart (2 replies)
  18. Linking equation with a code. (19 replies)
  19. Trouble executing VBA on remote connection (1 replies)
  20. Loop through Pivot Table Filter field from a List and create pdf (7 replies)
  21. [SOLVED:] Remove extra commas from end of content (4 replies)
  22. [SLEEPER:] Update a list rather than just add to (0 replies)
  23. [SOLVED:] Anyone fluent with .Names.Add using values rather than addresses? (advanced) (19 replies)
  24. aggregate Data and create new dashboard (4 replies)
  25. [SOLVED:] ADO - Issue in Excel (2 replies)
  26. [SOLVED:] Data sort a dynamic range? (2 replies)
  27. Sleeper: How to divide time series in to shorter time series in vba (1 replies)
  28. Alternating MsgBox (8 replies)
  29. [SOLVED:] Data sort a dynamic range of conditionally formatted cells? (3 replies)
  30. Specified table rows copy from Sheet to another sheet (0 replies)
  31. Search for Job ID and update fields in row below (0 replies)
  32. Elseif with values of formulas (4 replies)
  33. Autohighlight (0 replies)
  34. Need this to in VBA please the formula used is limited. Thank you (4 replies)
  35. Calendar by BlueCactus not works (22 replies)
  36. [SOLVED:] Select and sort rows based on multiple criteria (1 replies)
  37. [SOLVED:] Renaming a sheet after a cell value that's too long (4 replies)
  38. synthax of Cells.offset.value (2 replies)
  39. Calculate the percentage of those who answered YES (2 replies)
  40. Excel VBA to compare two lists (0 replies)
  41. Expand the Range For Each Cell in Range (3 replies)
  42. Help in VBA problems with Macro (2 replies)
  43. Ribbon Interface Menu builder (5 replies)
  44. Exporting worksheet from a closed workbook in a shared drive to another workbook (1 replies)
  45. [SOLVED:] Help edit data in listview via two Dtpickers (3 replies)
  46. [SOLVED:] Need VBA TO LIST VALUES THAT CORRESPOND VALUES IN GHIJK (14 replies)
  47. [SOLVED:] need VBA to arrange the data from left to right smallest to largest, please! (3 replies)
  48. [SOLVED:] VBA to place combinations from cell to muliple cells essentially un merge them please (4 replies)
  49. Saving & closing (2 replies)
  50. Form 2.0 Frame (1 replies)
  51. A way to filter based on strikethrough formatting? (1 replies)
  52. [SOLVED:] Row Compare - Data not cell (5 replies)
  53. [SOLVED:] "For each ... next" loop not working (2 replies)
  54. Slow dynamic shart update xl2016 (0 replies)
  55. Change list values using VBA (3 replies)
  56. [SOLVED:] Merge Excel files with different yet similar data headers (10 replies)
  57. VBA Assistance - Highlighting and Deleting based on another cell value. (1 replies)
  58. Using And / Or with Conditional Formatting (5 replies)
  59. VBA to login and post in FACEBOOK (11 replies)
  60. VBA assistance (4 replies)
  61. Auto-populate a master list from info in other sheets without adding spaces (1 replies)
  62. [SOLVED:] Take values from different area of a column with a variable range lenght (5 replies)
  63. Loking for a macr to delete first six lines of txt documents (1 replies)
  64. Split Excel sheets to multiple Workbooks based on Criteria in Cell A1 (0 replies)
  65. Interest claculator that allows payments and advances (4 replies)
  66. Define cells and cut them (1 replies)
  67. Save specific Outlook attachment to folder (0 replies)
  68. [SOLVED:] Make formula equal to cell contents of last cell in a column (2 replies)
  69. Email Attachment via Outlook (1 replies)
  70. If a cell is filled up, copy data to the right of cell instead (7 replies)
  71. If cell in column B(tab1), copy tab2 and paste value from column B(tab1) into new tab (1 replies)
  72. Using ADO with Excel (44 replies)
  73. Can't get right code to amend records in listview (3 replies)
  74. [SOLVED:] Need Help with revision of current VBA macro! please! (3 replies)
  75. [SOLVED:] Select Case (0 replies)
  76. [SOLVED:] adding comments to ListColumn tables in Excel with Access VBA (13 replies)
  77. Optomize Code for a Sort and Remove Duplicates Macro (1 replies)
  78. VBA Excel Google Search Scraper/Extract (0 replies)
  79. [SOLVED:] VBA to Paste top rows to bottom 4 rows as values (8 replies)
  80. Check for empty cell in a range of #N/A cells (14 replies)
  81. [SOLVED:] Increase cell value by 1 when workbook opens (3 replies)
  82. [SOLVED:] Sumif using offset in vba (6 replies)
  83. vlookup on temp file (3 replies)
  84. HELP!!! Importing CSV file into excel based on cell value (1 replies)
  85. [SOLVED:] Need help with fixing code - Match FName + LName and highlightcells (9 replies)
  86. cannot add date (1 replies)
  87. Find last column , enter formula to last column skip 3 lines and repeat (4 replies)
  88. "object expected" suddenly popping up (3 replies)
  89. [SOLVED:] VBA to populate row of cells with userform listbox data (code runs by column only) (3 replies)
  90. VBA Interacting With A Child Window (0 replies)
  91. VBA Code: excel is hanging at some point (0 replies)
  92. [SOLVED:] Import Excel Named Ranges into Word with VBA (3 replies)
  93. copy paste macro needs sum function (1 replies)
  94. Compare the value with different name. (4 replies)
  95. Excel Vba Code To Create New Worksheets When Range Is Updated (13 replies)
  96. Excel VBA code to get data from a cell. (1 replies)
  97. Links and Macros Automatically Enabled (1 replies)
  98. [SOLVED:] VBA to transpose rows to column based on values in col A (2 replies)
  99. [SOLVED:] Change listview items font color based on criteria (7 replies)
  100. [SOLVED:] Naming a column B range based on Col A value (3 replies)
  101. Extracting minimum and maximum points above and below moving average (9 replies)
  102. [SOLVED:] Ranking like values the same, but not omitting the next rank number? (4 replies)
  103. [SOLVED:] Using VBA code to change value of a checkbox in a cell (2 replies)
  104. excel vba range property non contiguous ranges (4 replies)
  105. [SOLVED:] Run-time error '13': type mismatch VBA code (1 replies)
  106. [SOLVED:] Ribbon Issue (15 replies)
  107. Offset selection by 3 columns? (4 replies)
  108. [SOLVED:] Excel VBA to print 3 copies of sheet if it finds something in cell A2. (2 replies)
  109. Replacing "/" with nothing -VBA (3 replies)
  110. Autofill a resize range (1 replies)
  111. Open Multiple Files in a Folder, List file name, and calculate Average of Column (19 replies)
  112. Using Index match in VBA returns wrong value (13 replies)
  113. Looping Through Worksheets (34 replies)
  114. [SOLVED:] Help w/combining excel actions (0 replies)
  115. cut entire row and paste many times as quantity - Tables (0 replies)
  116. VBA "Object doesn't support this method" HELP!! (4 replies)
  117. Countif Synthax (3 replies)
  118. Remove blank cells to left if condition (2 replies)
  119. [SOLVED:] VBA to pull values from cells off of second sheet (3 replies)
  120. [SOLVED:] Naming a Range (VBA) (1 replies)
  121. [SOLVED:] Copy rows and paste them to new sheet (3 replies)
  122. Speed Up Get Data Code (15 replies)
  123. [VBA]:How to use VBA to merge 2 sheets into one with the same ID (4 replies)
  124. Script to Change Chart Titles (4 replies)
  125. [SOLVED:] What I'm doing wrong??? (7 replies)
  126. [SOLVED:] copy from one sheet to another sheet based on column names (20 replies)
  127. SumIf in vba returns 0 value in userform (1 replies)
  128. [SOLVED:] Where is the error in this short code?? (3 replies)
  129. Extract specific values in text files and paste to Excel (3 replies)
  130. Numbered Text boxes managed by Loop or for? (0 replies)
  131. [SOLVED:] Split a Text File - Rename With the Original Text Heading Found in file (8 replies)
  132. Select and delete entire columns (3 replies)
  133. VBA assign random variables to cells (1 replies)
  134. can't run a simple recorded macro (6 replies)
  135. [SOLVED:] Arranging groups of numbers into a normal distribution (8 replies)
  136. Need help implementing UserInterFaceOnly:=True (2 replies)
  137. join multidimensional array vba (1 replies)
  138. [SOLVED:] Find with additional requirement (5 replies)
  139. [SOLVED:] Match Funtion Help (2 replies)
  140. [SOLVED:] VBA to insert Now() when formula result changes (7 replies)
  141. Converting xls formula to VBA function (7 replies)
  142. 3-dimensional grid search (1 replies)
  143. Find Search with Msg PopUp (4 replies)
  144. [SOLVED:] Need help need VBA to build combinations from values from structured data (33 replies)
  145. WaterFall Chart - Up/Down Bars (0 replies)
  146. CopyPicture method of Range class failed (18 replies)
  147. Find a particular text in column A and copy the value from next column and transpose (2 replies)
  148. VBA code for distributing items having different weight and time to different slots (4 replies)
  149. Vba Outlook license reminder notification (0 replies)
  150. VBA Google Search Scraper/Extract (1 replies)
  151. PrintToFile Problem (0 replies)
  152. Extract web data (0 replies)
  153. [SOLVED:] VBA to copy last row of one sheet onto another sheet (16 replies)
  154. VBA to delete rows *partial text* (1 replies)
  155. Export excel sheet to .txt, reformat to .dat. But format changes in Linux (6 replies)
  156. Converting Values from one spreadsheet, and turning it into an XSLT code. (0 replies)
  157. Compare Dates within Textboxes in Userform (3 replies)
  158. Link button to table row for sorting (0 replies)
  159. Need to direct my appointment a non default calendar (1 replies)
  160. Delete record from listview and excel sheet at the same time and apply duplicate prev (0 replies)
  161. how to minimize sum with macros (1 replies)
  162. [SOLVED:] Format all my Command Buttons The Same - Retain Press Color Change Individual Button (21 replies)
  163. VBA Code: ascending order of the columns (4 replies)
  164. [SOLVED:] listbox items = column headers macro (5 replies)
  165. [SOLVED:] Identify 7 day separation between product calls (9 replies)
  166. Pull data from Word to Excel help (3 replies)
  167. [SOLVED:] Textbox .ColumnWidths without trial and error? (9 replies)
  168. Insert value after matching with existing cell (7 replies)
  169. Creating chart by searching input datas in different worksheets (2 replies)
  170. copy/paste values only between 2 tabs (3 replies)
  171. forcing excel sheet to save it as .xlsm (4 replies)
  172. [SOLVED:] Export Each Excel Row Text - to PPT (15 replies)
  173. [SOLVED:] Copying and Pasting through Ranges of Varying Lengths (3 replies)
  174. [SOLVED:] VBA Power Programming 2007 - Disk Examples (3 replies)
  175. [SOLVED:] VBA to run a Linear Regression Automatically (16 replies)
  176. Combine multiple sheets from multiple workbooks to a single workbook of multiple work (2 replies)
  177. [SOLVED:] Application.Onkey (7 replies)
  178. [SOLVED:] Move up cells less than row value (4 replies)
  179. [SOLVED:] Find First Cell in Column Containing non-NULL Data (6 replies)
  180. Fix Broken Code (8 replies)
  181. Paste with offset from a different sheet VBA (5 replies)
  182. Recording results of multiple runs using VBA (4 replies)
  183. How to close the all excel workbooks once i open a one excel workbook (1 replies)
  184. [SOLVED:] VBA/ Checkbox to add/remove fields in pivot (4 replies)
  185. [SOLVED:] Cell Returns no value even though the cell does contain a value (4 replies)
  186. [SOLVED:] macro to hyperlink excel cells to pdfs (12 replies)
  187. Removing blank lines from report calculated by macro (9 replies)
  188. convert text with (.) to number with (,) (7 replies)
  189. [SOLVED:] Search left from specific column eg. "y" (9 replies)
  190. Pulling Data from Web - page still loading (0 replies)
  191. [SOLVED:] Import worksheet based on filename and date (12 replies)
  192. Help with macro for filter (2 replies)
  193. [SOLVED:] Get latitude and longitude from Bing using VBA (16 replies)
  194. Shape Conditional Formatting & Permanent Logged In User, Date & Time Stamp (2 replies)
  195. [SOLVED:] Finding the Sum of Numbers between words in the entire workbook. (5 replies)
  196. How to Go to Next Row on a UserForm (7 replies)
  197. [SOLVED:] VBA/VBE Weird behavior when deleting a code line in a sub using a different sub (2 replies)
  198. VBA Code: Use keyboard keys in VBA coding (2 replies)
  199. VBA Code - If Code #1234 found in ColumnA then result code 5678 return in ColumnC (12 replies)
  200. Help with code to determine whether two strings are in a cell (1 replies)
  201. Compare 2 multi-arrays and isolate duplicate into 3rd array (3 replies)
  202. [SOLVED:] Add a sort filter to existing code (1 replies)
  203. Help putting border around a range (3 replies)
  204. Color issue confusing me (7 replies)
  205. [SOLVED:] index match function & IF to exclude few values (1 replies)
  206. VBA Excel data to Powerpoint (5 replies)
  207. Userform With Multiple Independent Combobox (delete row when not match) (1 replies)
  208. Search through a number of files for keywords and return associated data. help! (5 replies)
  209. [SOLVED:] Clear contents before replacing text (7 replies)
  210. Move cell values and buttons up from application caller (0 replies)
  211. Copy sheets from file to another but Not Copying those that already exist in 2nd file (1 replies)
  212. [SOLVED:] VBA Code to Insert a Row (13 replies)
  213. [SOLVED:] Move data from one sheet to another and export (11 replies)
  214. Merge and Append 95 Workbooks into One Workbook (10 replies)
  215. Turning Auto Calcs into Run by Button (11 replies)
  216. [SOLVED:] Dynamically Color Coded excel rows (3 replies)
  217. [SOLVED:] VBA Code: If not in column A then Replace (5 replies)
  218. Problem to create an indexed array - M(1 to 1, 1 to 4){i} (20 replies)
  219. [SOLVED:] Copy value of cell if date matches the date of another sheet (7 replies)
  220. Running macros while logged off (3 replies)
  221. Delete row based upon Date (13 replies)
  222. [SOLVED:] Cannot unlink word header (4 replies)
  223. Small Script Edit - Pasting value in front of data set (1 replies)
  224. [SOLVED:] How can I remove duplicates from a dynamic range? (4 replies)
  225. Saving Row as Text file - Concatenate & Line Breaks Not Working (2 replies)
  226. [SOLVED:] Custom Function Needed for Evaluating Performance (3 replies)
  227. PROBLEM WITH SCROLL BOX INSIDE A FORM (10 replies)
  228. Running a PDF file from Excel (9 replies)
  229. HELP with Formula to calculate Interest Rate (7 replies)
  230. VBA Calling/Application.run with dynamic inputs + error handling (5 replies)
  231. [SOLVED:] Question with FSO filtering - snb (2 replies)
  232. How to Shell to other Application with excel vba (0 replies)
  233. VBA Code - Lookup column1 in Column2 (3 replies)
  234. [SOLVED:] PivotTable field name is not valid when changing source data (1 replies)
  235. [SOLVED:] [VBA] Pasting data in Word looping for no apparent reason (8 replies)
  236. Excel 2013 - VB Script to save and e-mail form (0 replies)
  237. Concatenate in VBA (4 replies)
  238. [SOLVED:] Add Dates to Printed Header (15 replies)
  239. Multi-step workbook/sheet automation with VBA, macros, INDEX MATCH combination (3 replies)
  240. VBA Importing a sheet from a closed excel workbook (3 replies)
  241. [SOLVED:] Change Numbers to Words (12 replies)
  242. [SOLVED:] FSO filtering on the fly (24 replies)
  243. Error When Testing Collection for Key Exists (7 replies)
  244. VBA CODE- Match 2 cells and display the result (9 replies)
  245. Moving sheets to a new workbook (9 replies)
  246. Excel Duplicates (5 replies)
  247. Copy and Enter Current Record Displayed in Userform a # of Times to WS (0 replies)
  248. [SOLVED:] VBA Sheet Protection Failing (2 replies)
  249. SaveAs xlText (tab delimited text): delete empty line at the end (7 replies)
  250. [SOLVED:] Max value in array and return adjacent column (similar to offset/match in excel) (6 replies)