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. VBA Index/Multiple Match criteria (1 replies)
  2. [SOLVED:] Select Case nested in If Else... where's the break? (4 replies)
  3. [SOLVED:] Average times as long as between 2 dates (5 replies)
  4. [SOLVED:] Close a command button after it has been clicked (6 replies)
  5. [SOLVED:] Export embedded Word document and set data (2 replies)
  6. loop the wookbook with HPageBreaks and VPageBreaks. (0 replies)
  7. Calculate multiple sums depending on cells (8 replies)
  8. [SOLVED:] macro to repeat a value times in a column (6 replies)
  9. Sorting GPS Marks (18 replies)
  10. Excel 2010 Protect Existing Row, Allow New Rows (1 replies)
  11. Request Help for this Simple Macro (2 replies)
  12. How to paste a range of cells from excel to text field of a web page (1 replies)
  13. [SOLVED:] Find strings and delete (3 replies)
  14. Mass Pivot Table Changes (1 replies)
  15. Email Automation (1 replies)
  16. [SOLVED:] Need help with macro that clears out several different worksheets (39 replies)
  17. [SOLVED:] Delete Duplicate data on sheet2 and delete the row (2 replies)
  18. [SOLVED:] Loop Only Works on Active Sheet (4 replies)
  19. [SOLVED:] VBA Generate sheets with unique values (23 replies)
  20. Tips And Tricks (7 replies)
  21. Using inputbox to locate a range, and using 2 different locations to insert amounts (2 replies)
  22. Deleting repeated cells in two column table (text) (1 replies)
  23. help conditional formula if cell (1 replies)
  24. [SOLVED:] SetFocus on TextBoxes (3 replies)
  25. [SOLVED:] Insert blank row based on values in specified column (8 replies)
  26. [SOLVED:] VBA Code to parse boolean equations (27 replies)
  27. [SOLVED:] excel 2010 stops working when opening a userform (9 replies)
  28. [SOLVED:] VBA Format to Sheet Array (10 replies)
  29. Indexed Database Table in Excel for Lookup (7 replies)
  30. Need to link drop down list from range in xlsm (Add-In) (2 replies)
  31. [SOLVED:] Adding Values in a Userform (2 replies)
  32. [SOLVED:] Replace formula (8 replies)
  33. Can this be done with macro (7 replies)
  34. Object Variable or With Block variable not set (3 replies)
  35. Update Pivot Table filter by a value in another cell (1 replies)
  36. [SOLVED:] Dir function not working (8 replies)
  37. [SOLVED:] Deactivate Event Causing Error (12 replies)
  38. [SOLVED:] How to identify my version of VBA (2 replies)
  39. Getting "Subscript out of range" error (11 replies)
  40. Macro for adding variably named PDF in email from excel - (2 replies)
  41. Copy used cells and paste to master spreadsheet (3 replies)
  42. [SOLVED:] Multiply cell values using worksheet change event (12 replies)
  43. [SOLVED:] Userform listbox to range (3 replies)
  44. [SOLVED:] Set Range as a single cell relative to active cell (3 replies)
  45. Search column - move/copy entire row into another sheet. (3 replies)
  46. MAX MIN AVERAGE for situation (1 replies)
  47. Add New line above inlineshapes. (3 replies)
  48. Compare two columns to sheet3 based on condition (1 replies)
  49. [SOLVED:] Lotus Notes adding signature and attaching saved PDF (0 replies)
  50. [SOLVED:] Formulas to values with offset based on date > today (13 replies)
  51. whenever auto insert row than auto enter a formula in specific cell (6 replies)
  52. Set range and calculate sum problem (5 replies)
  53. typed and moving (9 replies)
  54. Macro not running properly on other systems (1 replies)
  55. Comma delimiters - Batch conversion of .csv to .xlsx (1 replies)
  56. [SOLVED:] Need to copy paste different cells to another file (files are same image) (5 replies)
  57. [SOLVED:] Export multiple worksheets into one csv file (27 replies)
  58. Adapt VBA Code With Adjusment Range (3 replies)
  59. [SOLVED:] vba textbox data valdiation (10 replies)
  60. [SOLVED:] Inquiry: VBA Code in Excel (3 replies)
  61. [SOLVED:] VBA Print function - want quotation marks in my text file (4 replies)
  62. [SOLVED:] Pivot Table Subtotals (1 replies)
  63. Sleeper: Open attached file from email in Lotus Notes in Excel (0 replies)
  64. [SOLVED:] Per hour result (5 replies)
  65. Sleeper: How to make Excel Start itself with a VBA Macro (5 replies)
  66. [SOLVED:] Passing Variables through VBA Excel - VBA Access (8 replies)
  67. Pivot table empty (0 replies)
  68. [SOLVED:] Ignoring comma when creating validation lists (13 replies)
  69. How to enter data in a specific cell (c8 in all sheets ) when data is on 1st sheet (9 replies)
  70. [SOLVED:] Tab order with VBA (21 replies)
  71. [SOLVED:] ComboBox: Possible to change Popout direction? (4 replies)
  72. [SOLVED:] check if listbox selected (4 replies)
  73. [SOLVED:] Pivot "For Each" Filtering Loop Failing (1 replies)
  74. Cells Clearcontents (1 replies)
  75. Insert blank rows based upon cell value with criteria (1 replies)
  76. Logic (7 replies)
  77. [SOLVED:] vba script to convert worksheets to pdf (8 replies)
  78. [SOLVED:] Identify value and automatically puts in another spreadsheet (1 replies)
  79. Macro to repeat merge, Filter, copy & paste to other sheet. (0 replies)
  80. Cut and Paste Rows from multiple Worksheets on to one summary sheet based on 1 condit (2 replies)
  81. enable and disable cells based on other cell value (0 replies)
  82. VBA concenate problem (9 replies)
  83. [SOLVED:] Sum the column (6 replies)
  84. Relative address rather than absolute address in VBA code (macro) (4 replies)
  85. CountIf with date (1 replies)
  86. Help Organising Data (2 replies)
  87. What to do when Text is found in a row? (1 replies)
  88. Search & Replace (2 replies)
  89. List Conditional Formatting on Separate Sheet (4 replies)
  90. VBA to Self Destruct File (16 replies)
  91. Find duplicates in each column, then delete rows containing only Subsequent duplicate (13 replies)
  92. [SOLVED:] Multiplied of 2 column (1 replies)
  93. [SOLVED:] Transposing in VBA (10 replies)
  94. [SOLVED:] Paste data to another sheet and do sum and Multiply. (7 replies)
  95. Best approach to filter on a value, but showing all lines concerned by same object? (2 replies)
  96. [SOLVED:] Help transforming dates and rounding numbers using VBA (9 replies)
  97. Excel Macro help with Outlook email (11 replies)
  98. [SOLVED:] VBA Black Scholes w/Greeks and Conditional Formula (5 replies)
  99. [SOLVED:] Duplicate Master from Brettdj (10 replies)
  100. VBA: Change conditionally highlighted rows from current date to 24 hours (1 replies)
  101. [SOLVED:] Plz help, Macro needed for If the file opened from folder, do this (6 replies)
  102. Opening multiple files and applying a macro to all of them (0 replies)
  103. My code works for a single row, but how do I make it work for all rows? (2 replies)
  104. Offset command for specific row display (3 replies)
  105. [SOLVED:] copy entire row to another sheet if cloumn A contains numeric data on Cloumn A (5 replies)
  106. combobox to populate listbox (7 replies)
  107. Generate path of a file in column and send email as attachment based on a cell value (5 replies)
  108. [SOLVED:] Count filled Cell where having number Only (6 replies)
  109. Copying a (variable) range from multiple worksheets to a summary worksheet (4 replies)
  110. Scrolling down flowchart (3 replies)
  111. Macro to find a word and select a range based in their position (2 replies)
  112. Copy my files + Date (3 replies)
  113. VBA- Skipping word in column of data and displaying result in other sheet (26 replies)
  114. Macro for copying specific values from one excel file to another (0 replies)
  115. VBA merge without creating new sheet (11 replies)
  116. [SOLVED:] vba macro code for filtering from the given numbers. (3 replies)
  117. [SOLVED:] Proper syntax to sort columns (only identified in variable) (8 replies)
  118. Using datevalue with different languages (3 replies)
  119. [SOLVED:] delete all sheets and charts except "Input" (4 replies)
  120. [SOLVED:] dayly data to weekly data (4 replies)
  121. [SOLVED:] TextBox Editor (2 replies)
  122. [SOLVED:] VBA Separate monthly data into weekly data (5 replies)
  123. Search for a string with " char. (3 replies)
  124. Error code 438 (10 replies)
  125. [SOLVED:] Loop Data validation list item and generate PDF for each (14 replies)
  126. VBA getElementsByTagName Issues (7 replies)
  127. Excel dashboard based on Outlook data with events (4 replies)
  128. [SOLVED:] R1C1 and using variable in array formula (4 replies)
  129. Can Excel run this big SQL? (23 replies)
  130. Sending email from Excel (1 replies)
  131. [SOLVED:] Why is this loop not working? (4 replies)
  132. Navigate Webiste and click on link/button using vba (4 replies)
  133. Running Macro when Data Valaudation Cell Changes (3 replies)
  134. Pasting into cell changes format - can this be stopped? (4 replies)
  135. VBA To Send Warning When The User Hasnt Worked In The Workbook For X Minutes (20 replies)
  136. What's the best approach: Need multiple queries displayed on Excel on the same page (8 replies)
  137. [SOLVED:] Mismatch error (9 replies)
  138. Simple Link to Access code (1 replies)
  139. [SOLVED:] selecting the newest date (4 replies)
  140. [SOLVED:] update pivot dynamically based on range in separate worksheet (9 replies)
  141. [SOLVED:] Chart title not updating (5 replies)
  142. [SOLVED:] On Error Close Worksheet (6 replies)
  143. SumIf Dynamic Range (7 replies)
  144. [SOLVED:] Force user to save as new file and NOT overwrite MASTER file (4 replies)
  145. [SOLVED:] Match numbers and highlight (2 replies)
  146. Run Access Macros in Excel (1 replies)
  147. Import Table With No ID From Internet (1 replies)
  148. Count Number of Targets Reached (2 replies)
  149. [SOLVED:] Working With Specific Named Ranges (8 replies)
  150. User form, VBA and timediff (4 replies)
  151. Listing folder names in a column (11 replies)
  152. [SOLVED:] Excel data import once only and save as new file (2 replies)
  153. I need good examples how to traverse xml file (0 replies)
  154. Run macro from an already open workbook (6 replies)
  155. help with uniquevalue function (1 replies)
  156. Clear contents (8 replies)
  157. Displaying an SQL Select Statement Help (2 replies)
  158. VBA runtime crash - Listrows.add (2 replies)
  159. Create Time Log Based on Workbook.Activate/Deactivate events (11 replies)
  160. Dumb question - onLoad? (9 replies)
  161. Excel weird behavior when connecting through ADODB (4 replies)
  162. [SOLVED:] Set a variable based on another variable (3 replies)
  163. [SOLVED:] VBA Create Unique Distinct List From Three columns (3 replies)
  164. [SOLVED:] Need code to merge PDF files in a folder using adobe acrobat X (48 replies)
  165. Help please (2 replies)
  166. Sending emails with attachments from excel (1 replies)
  167. Display a simple Access Database onClick (6 replies)
  168. want to compel user to enter data to both col B and then col C if data is in col A (3 replies)
  169. [SOLVED:] Vlookup: Wildcard in Reverse (7 replies)
  170. Help with ActiveX installs (date picker)? (1 replies)
  171. [SOLVED:] Compare/match name list in sheet with sheet names and delete extra names from list (20 replies)
  172. [SOLVED:] vba macro code for counting total days above 32 degrees, 33, 34, and goes on.. (11 replies)
  173. Generate number when userform information is submitted (3 replies)
  174. RETURN COLUMN SUMPRODUCT (5 replies)
  175. Copy data to other sheet (4 replies)
  176. Saving A Excel Macros File (4 replies)
  177. [SOLVED:] Data connections have been disabled (4 replies)
  178. Excel Crashes and macro runs slow (14 replies)
  179. [SOLVED:] manipulating bmp files (11 replies)
  180. [SOLVED:] IF / AND within VLOOKUP formula (3 replies)
  181. [SOLVED:] SUMIF formula (4 replies)
  182. (Help) Moving row with the macro (7 replies)
  183. Can not run SQL update statement (1 replies)
  184. [SOLVED:] Macro running but populaing wrong cells (5 replies)
  185. Window 8 PutInClipboard error (6 replies)
  186. VBA Code to select value from Popup dropdown (2 replies)
  187. VBA Multiplication Formula (2 replies)
  188. [SOLVED:] Look for specific date (5 replies)
  189. consolidate data from multiple excel files into single file (1 replies)
  190. [SOLVED:] Copy data to other sheet (3 replies)
  191. checking for duplicates and deleting duplicates (2 replies)
  192. VBA and SQL - help with update statement (1 replies)
  193. Prompt for narrative on saving spreadsheet (7 replies)
  194. copy paste macro (4 replies)
  195. need help to copy rows to a new sheet depend on a cell value (5 replies)
  196. help to Write a code to put value copy two tyms and columb values to row (2 replies)
  197. [SOLVED:] select the first value from data validation list (20 replies)
  198. Clear contents in multiple range and multiple sheets (2 replies)
  199. [SOLVED:] Vlookup and Type mismatch error (7 replies)
  200. A Data Cleaning Macro - Clean, Trim and CHAR(160) (49 replies)
  201. To pull text files (attachments) from Outlook and format them in Excel (0 replies)
  202. Randomly Assign Number Without Repeating The Same Number Twice (17 replies)
  203. Help: Dynamically Formatting Line Graph (1 replies)
  204. Help: Dynamically Formatting Line Graph (0 replies)
  205. [SOLVED:] Copy from one workbook then paste into one other (4 replies)
  206. sending mails from outlook using html tables with excel cell reference (0 replies)
  207. [SOLVED:] VBA MACRO CODE FOR GENERATING DAYS NUMBERING (11 replies)
  208. [SOLVED:] a better approach (10 replies)
  209. [SOLVED:] VBA Change Cell Formats (1 replies)
  210. Search a Column for a specific Value and Place in Another sheet (3 replies)
  211. Download Files in Excel Using VBA (0 replies)
  212. Clear contents (3 replies)
  213. Number format (3 replies)
  214. [SOLVED:] Shorten vba if Statements (4 replies)
  215. VBA Insert Formula At The End Of Row (5 replies)
  216. [SOLVED:] VBA Round To 2 Decimal Places (2 replies)
  217. Rotating employees and where to working (27 replies)
  218. [SOLVED:] VBA Not InStr (12 replies)
  219. [SOLVED:] VBA text file write not working on close and open (6 replies)
  220. Excel VBA to copy and move files (1 replies)
  221. Application.OnTime not getting canceled (2 replies)
  222. Substract hours when inicial time is before midnight and end time is after (2 replies)
  223. VBA importing data from .txt (5 replies)
  224. Copying Data from One Sheet to Different Sheets (1 replies)
  225. [SOLVED:] array formula that will index a horizontal array (2 replies)
  226. ActiveWorkbook.SaveAs on Mac OS X (0 replies)
  227. [SOLVED:] Opening files on network drive (1 replies)
  228. several handlers with same piece of code (2 replies)
  229. Compare Date from a Column Cells in alternate Columns Cells (0 replies)
  230. [SOLVED:] VBA Insert Formula On Multiple Sheets (8 replies)
  231. Solution to find overlapping rectangles given co-ordinates (6 replies)
  232. VBA Finding String on Webpage (0 replies)
  233. [SOLVED:] Most efficient way to move a selected range up or down (5 replies)
  234. Help needed for creating Dynamic Oracle Query using Excel VBA and Forms (8 replies)
  235. [SOLVED:] lookup formula with multiple criteria (2 replies)
  236. returning value of data validation (6 replies)
  237. Cell Colouring in VBA (9 replies)
  238. Convert formula's cell reference into value (5 replies)
  239. Why cannot run the code (1 replies)
  240. Identify timezone and convert time to other timezone (19 replies)
  241. [SOLVED:] Finding a date without a search (13 replies)
  242. VB looking at excel file to move files (11 replies)
  243. Folder Access (6 replies)
  244. Help with Date Picker 6.0?? (3 replies)
  245. Need help with Loop?? (1 replies)
  246. Code Security (COM Add-In? .xll? What to do?) (5 replies)
  247. Excel Timestamp format editing (1 replies)
  248. [SOLVED:] Insert a Hyphen at two characters from the end of a String (2 replies)
  249. Vba to move columns with certain headers (6 replies)
  250. changing Listbox based on an other combobox (12 replies)