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. combobox to populate listbox (7 replies)
  2. Generate path of a file in column and send email as attachment based on a cell value (5 replies)
  3. [SOLVED:] Count filled Cell where having number Only (6 replies)
  4. Copying a (variable) range from multiple worksheets to a summary worksheet (4 replies)
  5. Scrolling down flowchart (3 replies)
  6. Macro to find a word and select a range based in their position (2 replies)
  7. Copy my files + Date (3 replies)
  8. VBA- Skipping word in column of data and displaying result in other sheet (26 replies)
  9. Macro for copying specific values from one excel file to another (0 replies)
  10. VBA merge without creating new sheet (11 replies)
  11. [SOLVED:] vba macro code for filtering from the given numbers. (3 replies)
  12. [SOLVED:] Proper syntax to sort columns (only identified in variable) (8 replies)
  13. Using datevalue with different languages (3 replies)
  14. [SOLVED:] delete all sheets and charts except "Input" (4 replies)
  15. [SOLVED:] dayly data to weekly data (4 replies)
  16. [SOLVED:] TextBox Editor (2 replies)
  17. [SOLVED:] VBA Separate monthly data into weekly data (5 replies)
  18. Search for a string with " char. (3 replies)
  19. Error code 438 (10 replies)
  20. [SOLVED:] Loop Data validation list item and generate PDF for each (14 replies)
  21. VBA getElementsByTagName Issues (7 replies)
  22. Excel dashboard based on Outlook data with events (4 replies)
  23. [SOLVED:] R1C1 and using variable in array formula (4 replies)
  24. Can Excel run this big SQL? (23 replies)
  25. Sending email from Excel (1 replies)
  26. [SOLVED:] Why is this loop not working? (4 replies)
  27. Navigate Webiste and click on link/button using vba (4 replies)
  28. Running Macro when Data Valaudation Cell Changes (3 replies)
  29. Pasting into cell changes format - can this be stopped? (4 replies)
  30. VBA To Send Warning When The User Hasnt Worked In The Workbook For X Minutes (20 replies)
  31. What's the best approach: Need multiple queries displayed on Excel on the same page (8 replies)
  32. [SOLVED:] Mismatch error (9 replies)
  33. Simple Link to Access code (1 replies)
  34. [SOLVED:] selecting the newest date (4 replies)
  35. [SOLVED:] update pivot dynamically based on range in separate worksheet (9 replies)
  36. [SOLVED:] Chart title not updating (5 replies)
  37. [SOLVED:] On Error Close Worksheet (6 replies)
  38. SumIf Dynamic Range (7 replies)
  39. [SOLVED:] Force user to save as new file and NOT overwrite MASTER file (4 replies)
  40. [SOLVED:] Match numbers and highlight (2 replies)
  41. Run Access Macros in Excel (1 replies)
  42. Import Table With No ID From Internet (1 replies)
  43. Count Number of Targets Reached (2 replies)
  44. [SOLVED:] Working With Specific Named Ranges (8 replies)
  45. User form, VBA and timediff (4 replies)
  46. Listing folder names in a column (11 replies)
  47. [SOLVED:] Excel data import once only and save as new file (2 replies)
  48. I need good examples how to traverse xml file (0 replies)
  49. Run macro from an already open workbook (6 replies)
  50. help with uniquevalue function (1 replies)
  51. Clear contents (8 replies)
  52. Displaying an SQL Select Statement Help (2 replies)
  53. [SLEEPER:] VBA runtime crash - Listrows.add (2 replies)
  54. Create Time Log Based on Workbook.Activate/Deactivate events (11 replies)
  55. Dumb question - onLoad? (9 replies)
  56. Excel weird behavior when connecting through ADODB (4 replies)
  57. [SOLVED:] Set a variable based on another variable (3 replies)
  58. [SOLVED:] VBA Create Unique Distinct List From Three columns (3 replies)
  59. [SOLVED:] Need code to merge PDF files in a folder using adobe acrobat X (48 replies)
  60. Help please (2 replies)
  61. Sending emails with attachments from excel (1 replies)
  62. Display a simple Access Database onClick (6 replies)
  63. want to compel user to enter data to both col B and then col C if data is in col A (3 replies)
  64. [SOLVED:] Vlookup: Wildcard in Reverse (7 replies)
  65. Help with ActiveX installs (date picker)? (1 replies)
  66. [SOLVED:] Compare/match name list in sheet with sheet names and delete extra names from list (20 replies)
  67. [SOLVED:] vba macro code for counting total days above 32 degrees, 33, 34, and goes on.. (11 replies)
  68. Generate number when userform information is submitted (3 replies)
  69. RETURN COLUMN SUMPRODUCT (5 replies)
  70. Copy data to other sheet (4 replies)
  71. Saving A Excel Macros File (4 replies)
  72. [SOLVED:] Data connections have been disabled (4 replies)
  73. Excel Crashes and macro runs slow (14 replies)
  74. [SOLVED:] manipulating bmp files (11 replies)
  75. [SOLVED:] IF / AND within VLOOKUP formula (3 replies)
  76. [SOLVED:] SUMIF formula (4 replies)
  77. (Help) Moving row with the macro (7 replies)
  78. Can not run SQL update statement (1 replies)
  79. [SOLVED:] Macro running but populaing wrong cells (5 replies)
  80. Window 8 PutInClipboard error (6 replies)
  81. VBA Code to select value from Popup dropdown (2 replies)
  82. VBA Multiplication Formula (2 replies)
  83. [SOLVED:] Look for specific date (5 replies)
  84. [SLEEPER:] Consolidate data from multiple excel files into single file (1 replies)
  85. [SOLVED:] Copy data to other sheet (3 replies)
  86. checking for duplicates and deleting duplicates (2 replies)
  87. VBA and SQL - help with update statement (1 replies)
  88. Prompt for narrative on saving spreadsheet (7 replies)
  89. copy paste macro (4 replies)
  90. need help to copy rows to a new sheet depend on a cell value (5 replies)
  91. help to Write a code to put value copy two tyms and columb values to row (2 replies)
  92. [SOLVED:] select the first value from data validation list (20 replies)
  93. Clear contents in multiple range and multiple sheets (2 replies)
  94. [SOLVED:] Vlookup and Type mismatch error (7 replies)
  95. A Data Cleaning Macro - Clean, Trim and CHAR(160) (49 replies)
  96. To pull text files (attachments) from Outlook and format them in Excel (0 replies)
  97. Randomly Assign Number Without Repeating The Same Number Twice (17 replies)
  98. Help: Dynamically Formatting Line Graph (1 replies)
  99. Help: Dynamically Formatting Line Graph (0 replies)
  100. [SOLVED:] Copy from one workbook then paste into one other (4 replies)
  101. [SLEEPER:] Sending mails from outlook using html tables with excel cell reference (0 replies)
  102. [SOLVED:] VBA MACRO CODE FOR GENERATING DAYS NUMBERING (11 replies)
  103. [SOLVED:] a better approach (10 replies)
  104. [SOLVED:] VBA Change Cell Formats (1 replies)
  105. Search a Column for a specific Value and Place in Another sheet (3 replies)
  106. [SLEEPER:] Download Files in Excel Using VBA (0 replies)
  107. Clear contents (3 replies)
  108. Number format (3 replies)
  109. [SOLVED:] Shorten vba if Statements (4 replies)
  110. VBA Insert Formula At The End Of Row (5 replies)
  111. [SOLVED:] VBA Round To 2 Decimal Places (2 replies)
  112. Rotating employees and where to working (27 replies)
  113. [SOLVED:] VBA Not InStr (12 replies)
  114. [SOLVED:] VBA text file write not working on close and open (6 replies)
  115. Excel VBA to copy and move files (1 replies)
  116. Application.OnTime not getting canceled (2 replies)
  117. Substract hours when inicial time is before midnight and end time is after (2 replies)
  118. VBA importing data from .txt (5 replies)
  119. Copying Data from One Sheet to Different Sheets (1 replies)
  120. [SOLVED:] array formula that will index a horizontal array (2 replies)
  121. ActiveWorkbook.SaveAs on Mac OS X (0 replies)
  122. [SOLVED:] Opening files on network drive (1 replies)
  123. several handlers with same piece of code (2 replies)
  124. Compare Date from a Column Cells in alternate Columns Cells (0 replies)
  125. [SOLVED:] VBA Insert Formula On Multiple Sheets (8 replies)
  126. Solution to find overlapping rectangles given co-ordinates (6 replies)
  127. VBA Finding String on Webpage (0 replies)
  128. [SOLVED:] Most efficient way to move a selected range up or down (5 replies)
  129. Help needed for creating Dynamic Oracle Query using Excel VBA and Forms (8 replies)
  130. [SOLVED:] lookup formula with multiple criteria (2 replies)
  131. returning value of data validation (6 replies)
  132. Cell Colouring in VBA (9 replies)
  133. Convert formula's cell reference into value (5 replies)
  134. Why cannot run the code (1 replies)
  135. [SOLVED:] Identify timezone and convert time to other timezone (19 replies)
  136. [SOLVED:] Finding a date without a search (13 replies)
  137. VB looking at excel file to move files (11 replies)
  138. Folder Access (6 replies)
  139. Help with Date Picker 6.0?? (3 replies)
  140. Need help with Loop?? (1 replies)
  141. Code Security (COM Add-In? .xll? What to do?) (5 replies)
  142. Excel Timestamp format editing (1 replies)
  143. [SOLVED:] Insert a Hyphen at two characters from the end of a String (2 replies)
  144. Vba to move columns with certain headers (6 replies)
  145. changing Listbox based on an other combobox (12 replies)
  146. Macro that generates new worksheet with a dependent worksheet name (1 replies)
  147. [SOLVED:] Transpose data from row into columns based upon certain criteria (15 replies)
  148. Vlookup Dynamic Criteria (7 replies)
  149. Shifting and combining columns using VBA (2 replies)
  150. [SOLVED:] How to replace the FileSearch application in Excel 2010 (3 replies)
  151. Connect to Oracle with Excel VBA and store results of query? (2 replies)
  152. conect 3 tabales in Table4 in diferent worckbook (0 replies)
  153. [SOLVED:] Run-time Error 5 "Invalid Procedure Call or Argument" (4 replies)
  154. [SOLVED:] Edit Listbox Items (2 replies)
  155. [SOLVED:] Create copy of WB (2 replies)
  156. [SOLVED:] Show and Hide a UserForm using a String as the UserForm Name (16 replies)
  157. [SOLVED:] vba script to convert datetime string to date format (18 replies)
  158. Load Formula from another sheet (2 replies)
  159. [SOLVED:] pass two workbooks into sub module (2 replies)
  160. VBA Autofill Method of Range Class Failed (3 replies)
  161. [SOLVED:] Combining multiple range as target cell (3 replies)
  162. VBA Dynamic Ranges & Sheet Formatting (2 replies)
  163. Loop through columns and vlookup (1 replies)
  164. Macro that generates new work sheet with people and tasks they perform (6 replies)
  165. [SOLVED:] Populate Hyperlinks in ListBox (4 replies)
  166. [SOLVED:] VBA Paste Cells With Specific Text String to Specific Sheet (11 replies)
  167. Rolling Calculation (8 replies)
  168. VBA Dynamic Named Ranges & Page Formatting (4 replies)
  169. MAX date problem (5 replies)
  170. Close active workbook if multiple workbooks are open/ close excel if only one open (4 replies)
  171. Help making my search look in 2 sheets? (1 replies)
  172. VBA code to open IE in non-protected mode (0 replies)
  173. VBA Variant Array issues with Excel (2 replies)
  174. [SOLVED:] Maximum and minimum tide levels for every day (8 replies)
  175. Macro to paste on a hidden sheet (3 replies)
  176. [SOLVED:] Query doesn't work in Excel 2010 (13 replies)
  177. VBA Compile Error: Ambiguous name detected (2 replies)
  178. Need Help with a Looping Issue (4 replies)
  179. Setcell to blank if results of a formula are null, based on checkbox conditition (3 replies)
  180. worksheet function match syntax issue (3 replies)
  181. vba to run a macro on multiple excel files in a folder (5 replies)
  182. VBA Copy and Paste data to another sheet(with a date and day)? (3 replies)
  183. Best Way to Create Options Menu for an add-in? (5 replies)
  184. time calculation formula (8 replies)
  185. Sleeper: Save sheet as csv to specific network folder (1 replies)
  186. Highlighting, freezing and scrolling (1 replies)
  187. Is there a before_insert_row event? (6 replies)
  188. Confirm Message Before Deleting Rows (1 replies)
  189. [SLEEPER:] Need help with Inputbox function and If Statement (7 replies)
  190. Copy cell contents to another sheet at a particular cell address (0 replies)
  191. VBA Code to move files to another folder (13 replies)
  192. [SOLVED:] List cells containing references to files, i.e. containing formulas with broken links (29 replies)
  193. Insert Rows based on 2 Criteria (1 replies)
  194. Column headers throws errors (10 replies)
  195. VBA - MouseMove Event Code to Display Text after Hovering (5 replies)
  196. VBA: How to search new sheet for a defined variable, then copy values back to sheet (1 replies)
  197. Help with a VBA macro - merge multiple workbooks in one workbook with source names (2 replies)
  198. Copy Rows based on 1 criteria showing in Multiple columns (1 replies)
  199. Move cursor to image named material and then go to sub menu Material AVaialbility (3 replies)
  200. Highlighting Repeating Number Pairs (20 replies)
  201. [SOLVED:] Copy Excel range & paste in PPT as [Pastespecial - M.O. Excel Worksheet(Code) Object] (14 replies)
  202. Deleting Rows using VBA macro (2 replies)
  203. .xla Add-In Mechanics and Custom Ribbon Creation (3 replies)
  204. Enter text base on cell value/text referencing a dynamic list (3 replies)
  205. Pairing Co-ordinates (1 replies)
  206. Copy cell content and and paste to specific cell as a comment. (2 replies)
  207. #Value Error Using UDF Within Worksheet (8 replies)
  208. help to Copy symbols indicators as per range parameter set. (12 replies)
  209. Custom function help (Probably just me being stupid!) (5 replies)
  210. VBA Sum If Calculation (19 replies)
  211. Excel 2010 Print Blank Page (1 replies)
  212. Open word document (5 replies)
  213. Alternative to Application.Ontime (3 replies)
  214. Format from last Row Up (3 replies)
  215. Printing Embedded PDFs from Excel Workbook (2 replies)
  216. Asking for a different sheet name if current input already exists (1 replies)
  217. fill range based on Month (9 replies)
  218. Active Cell Address move to left when enter key is Enter (0 replies)
  219. [SOLVED:] Understanding the Syntax of Hyperlinks.Add (6 replies)
  220. Login into a website through Excel (2 replies)
  221. clearing ranges from COPIED sheet (2 replies)
  222. Lotus Notes Mailbox Size/Quota from Excel VBA (1 replies)
  223. Trouble with calculations in Excel table (3 replies)
  224. VBA Comparison between 2 sheets that return a 3rd sheet with differences (1 replies)
  225. xlRepairFile (3 replies)
  226. Code to unprotect wbaproject (4 replies)
  227. [SOLVED:] multi-VLOOKUP From an Array in VBA (3 replies)
  228. Highlight a specfic column when spread sheet opens (5 replies)
  229. Need Help with calculating an array of numbers... (6 replies)
  230. Excel Property Window While Saving (6 replies)
  231. help with complicated formula (60 replies)
  232. Deselecting a single pivot table item which is referenced in a specific cell (0 replies)
  233. [SOLVED:] Export worksheet to new workbook and restore original sheet (3 replies)
  234. Create Unique Values List From Named Range (4 replies)
  235. [SOLVED:] GoalSeek by VBA (4 replies)
  236. Duplicate data sets multiple times in VBA (7 replies)
  237. VBA Set cell value under last row (2 replies)
  238. looking help (4 replies)
  239. Date -> numeric translation issue (5 replies)
  240. Auto Name a workbook (13 replies)
  241. New to VBA, trouble with an If Else Then statement (4 replies)
  242. Need Some Change In Count Macro Running Code (3 replies)
  243. [SLEEPER:] Create sheet if it doesn't exist problem (7 replies)
  244. Formulate average count of DISTINCT records (4 replies)
  245. Export array values to Excel (10 replies)
  246. Refresh data in closed excel workbook (3 replies)
  247. VBA to auto-add rows to 3 Tables (or one and auto-resize 2) (1 replies)
  248. [SLEEPER:] Excel VBA macros - webquery (12 replies)
  249. How to extract filename from a folder which is on a netwrok drive (6 replies)
  250. [SLEEPER:] VBA code to open folders and pdf file inside the folders (32 replies)