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. access database tables in Excel (6 replies)
  2. Exclude a word (4 replies)
  3. Validation (1 replies)
  4. Count of cells using VBA (9 replies)
  5. Create Subfiles from a master file using key to split workbooks to seperate files (0 replies)
  6. Data manipulation (1 replies)
  7. I need help edit code clean cell and past (11 replies)
  8. Read pdf content from excel (3 replies)
  9. Solved: Worksheet_Change to concatenate values (8 replies)
  10. aggregate & concatenate (5 replies)
  11. VBA Format vs Range.NumberFormat (6 replies)
  12. input button (5 replies)
  13. ComboBox's linked loop Crash HELP!!! (1 replies)
  14. Populate Variable Array from Range - VBA (4 replies)
  15. Solved: Create Text files for each subject and Date (5 replies)
  16. VBA: get specific folder from the path (2 replies)
  17. Search and Update Records in External Excel File (1 replies)
  18. Solved: VBA that synchronize sheets to another sheet (2 replies)
  19. Lock ectire row by an value via VBA (9 replies)
  20. VBA to import sheets from a workbook in a folder (2 replies)
  21. VBA - Split time range in 10 seconds increments (15 replies)
  22. ActiveX Textbox Help (1 replies)
  23. Trying to write a vba variant to an excel range which consists of a singular row and (3 replies)
  24. Solved: Use input box in a formula (9 replies)
  25. [SOLVED:] Code Fix to Delete Duplicates (2 replies)
  26. Split into 2 rows IF - VBA (5 replies)
  27. unhide\resize enmasse (1 replies)
  28. Find and replace data in a text document (9 replies)
  29. Solved: Useform autopopulate list box on opening the userform (2 replies)
  30. Solved: Autofill Series with a minimum and maximum (2 replies)
  31. I Need Help Edit Code Auto Save Every 5 Minutes (8 replies)
  32. ActiveX Control _Click doesn't work in second window (17 replies)
  33. Show progress on extraction of data from DB (5 replies)
  34. Solved: Conditional Sorting (4 replies)
  35. send login details to web form using Microsoft.XMLHTTP (1 replies)
  36. Solved: userform to populate the list box with values (4 replies)
  37. Solved: Printing code (2 replies)
  38. automatically send email if cell background colour changes (2 replies)
  39. Solved: Copy Rows to another Sheet in another Workbook (4 replies)
  40. Solved: Exiting loop once condition is met (3 replies)
  41. Solved: How to Write Formulas in VBA? (4 replies)
  42. VBA code to click website button to access node (0 replies)
  43. Selection box on Vlookup error (1 replies)
  44. PDF to Excel Import (1 replies)
  45. Solved: Excel file splitter (3 replies)
  46. Returning a date with a function (1 replies)
  47. Sleeper: Loop & Match to copy multiple row of data (0 replies)
  48. Rename external ped files with names given in excel (2 replies)
  49. find last cell with cell reference (3 replies)
  50. Solved: Copying Cell data and formats across two spreadsheets (1 replies)
  51. Solved: How to unlink a TextBox linked to a cell in a worksheet (9 replies)
  52. Call function from .XLSB to .XLAM (2 replies)
  53. Charting Month Year at together (1 replies)
  54. Solved: Hiding Sheet Via Userform (6 replies)
  55. VBA to change filters in pivot one after other (0 replies)
  56. Sound Generation Software (7 replies)
  57. Planing Formula (9 replies)
  58. extract sring from last space (1 replies)
  59. Solved: Remove Duplicates (5 replies)
  60. i need to kill 2 processes (2 replies)
  61. Open multiple workbooks by loop through cells (1 replies)
  62. Filter out Rows with multiple duplications of data (0 replies)
  63. [SLEEPER:] Excel Data Matching Word Tables & Looping (5 replies)
  64. File Browser Return Full Internet Path (1 replies)
  65. sumproduct in vba (8 replies)
  66. VBA to identify unique values (21 replies)
  67. [SOLVED:] Fault in Code, Do I Error code it or write code to account for it? (9 replies)
  68. Solved: Author Name in Excel (4 replies)
  69. Alternative for vlookup.Need help on my code (1 replies)
  70. Solved: Select Tabs using a string (14 replies)
  71. cells that some rows have in common (1 replies)
  72. VBA ignore weekends and holidays. (1 replies)
  73. Solved: please rectify auto row insert (4 replies)
  74. how to loop in vba (7 replies)
  75. Sort columns in VBA (4 replies)
  76. Solved: Add entry into one sheet into a list in another by triggering worksheet change event (3 replies)
  77. creating multiple workbooks and worksheets quicklyA (0 replies)
  78. [SOLVED:] Auto Numbering (1 replies)
  79. multiple criteria for sumifs VBA code (2 replies)
  80. Macro that generates a report of cells' values source (6 replies)
  81. forum searching question (2 replies)
  82. Error ,want help (3 replies)
  83. VBA issue trying to match sets of data (2 replies)
  84. Solved: Is it possible for a function to affect another cell? (13 replies)
  85. [SOLVED:] Group pivot items (6 replies)
  86. [SOLVED:] Convert date to string yyyymmdd (5 replies)
  87. Solved: Chart Macro: Automatically Selecting Labels Range (2 replies)
  88. Sleeper: Save 2 Sheet's - criteria in a particular cell (4 replies)
  89. Solved: Simple Selection Code Question. The readable version. (5 replies)
  90. Solved: Quick Simple Help with Selection Code (0 replies)
  91. Disable or Hide new workpage tab (1 replies)
  92. Copy a range to another workbook (3 replies)
  93. Using variables to reference a range (5 replies)
  94. Solved: Read the URL in column G then paste the company name from website in column H (11 replies)
  95. My macro crashes on a different computer! (5 replies)
  96. Solved: splitting text at Hyphen (4 replies)
  97. Overlapping of Text VBA Problem (4 replies)
  98. Exporting a sheet with macros included (5 replies)
  99. MESSAGE: License information for this component not found (5 replies)
  100. Copying Filtered Items to an Array (7 replies)
  101. Probelm Filtering Pivot Table (0 replies)
  102. Solved: Average Cells Based on Numbers in Array (2 replies)
  103. Random numbers from a range to specific sum of randam values! (6 replies)
  104. Updating Internet Web page from excel (5 replies)
  105. Basic VBA - Active X control to also link to cell value (3 replies)
  106. Solved: Using Union to combine two ranges (8 replies)
  107. it is possible to freeze more than one row in excel? (2 replies)
  108. Solved: Modify Code To Offset by 2 To Destination Sheet (9 replies)
  109. Need help to combine two tables under certain conditions (2 replies)
  110. [SLEEPER:] FolderShortCut (1 replies)
  111. How To Deconstruct Formulas Into VBA (1 replies)
  112. Solved: Split Longitude and Latitude values (6 replies)
  113. [SOLVED:] IF Function Help (10 replies)
  114. Getting cell coordinate from the last cell with text in it in a ranged row (2 replies)
  115. Split words in each cell in range and compare to see if in another range (17 replies)
  116. Add digital signature using excel VBA to PDF (2 replies)
  117. Solved: Help to solve a little mistery (6 replies)
  118. Array formula to extract in-between dates (1 replies)
  119. Nested Formulas to skip 0's? (1 replies)
  120. Solved: Help on selecting unique random words from a list. (3 replies)
  121. vba comments (11 replies)
  122. [SOLVED:] Sort contents in a text file. (13 replies)
  123. Solved: Filter Range Issue. (3 replies)
  124. Solved: VBA Help with Copying Data and Formats from Rows (1 replies)
  125. Solved: Check that an excel file exists (4 replies)
  126. userform with option to Copying & Inserting Rows (0 replies)
  127. data from another workbook and implementing conditions (1 replies)
  128. Calling a function, click a link using VBA (0 replies)
  129. VBA Filtering (0 replies)
  130. Solved: not case-sensitiv alphabetical order for combobox values (2 replies)
  131. Autofilter based on cell from another workbook (0 replies)
  132. Search for character within a value (VBA) (2 replies)
  133. macro execuation to delete folders (1 replies)
  134. into string value into range based on lookup in another workbook (2 replies)
  135. VBA to Change Connection String of all query's in a workbook (6 replies)
  136. Not really sure how to title this... (7 replies)
  137. Checkbox - Automatic Copying to Different Sheet (5 replies)
  138. Solved: Is this a good way to check if a cell contains a valid time? (12 replies)
  139. Pivot Table Field selection (5 replies)
  140. Command Button to combine multiple worksheets into 1 pdf (9 replies)
  141. Get Data Only from Certain Records (1 replies)
  142. Solved: Picture Size (14 replies)
  143. Restricting Save As Options (0 replies)
  144. Need macro for taking data from one sheet and autopopulating another (3 replies)
  145. VBA loop help (1 replies)
  146. Solved: vlookup (5 replies)
  147. How to auto enable circular reference? (1 replies)
  148. Pivot table help please (0 replies)
  149. Sort by Distance to Each Successive Point (7 replies)
  150. Lock specific columns (16 replies)
  151. Need help for a macro to match data in excel! (20 replies)
  152. [SLEEPER:] Excel formula help to check type of leave and calculating total days (2 replies)
  153. Creating index sheet in excel. Help (2 replies)
  154. For Each Loop looping to many times (17 replies)
  155. Help with vba code (1 replies)
  156. Macro printing to refer to cell and named ranges (5 replies)
  157. Solved: Dimension help when closing workbook. (3 replies)
  158. Solved: For Next help (3 replies)
  159. [SOLVED:] Visible Cell .EntireRow.Delete 2010 (7 replies)
  160. Solved: I need help edit code hide rows in excel (7 replies)
  161. Solved: Transferring data from Excel to Access macro (2 replies)
  162. Simple inserting column then titling (3 replies)
  163. Combobox dependencies (2 replies)
  164. Help with form (2 replies)
  165. Solved: Moving data from form to worksheet (2 replies)
  166. Problem with a loop that compares two columns of data (2 replies)
  167. setting source data for a pivot using variables. (1 replies)
  168. Update External Link in Text Box (6 replies)
  169. Solved: VBA Copy and Paste Specific Cells Based On Another Cells Value (11 replies)
  170. Solved: Please explain!! (3 replies)
  171. [SOLVED:] For Loop - increase stop counter due to inserting rows ? (3 replies)
  172. Run-Time Error '424' Object Required (2 replies)
  173. Table of content (4 replies)
  174. Navigate to WebBrowser problem (0 replies)
  175. Automating tables creation with VBA code (1 replies)
  176. Help with conditional values (3 replies)
  177. Ommitting Unused Data on Cell (6 replies)
  178. [SLEEPER:] Trying to copy current worksheet name (5 replies)
  179. GoTo vs Call (12 replies)
  180. Save as csv (1 replies)
  181. Solved: RmDir generates File/Path Access Error (7 replies)
  182. Counting Unique Values to Generate a List of the Top X Largest (1 replies)
  183. function operations (4 replies)
  184. Solved: Refering to a specific control in a class object (2 replies)
  185. Need a loop script to copy from one 'data' workbook' to a template, make some edits, (8 replies)
  186. Need help on reconcile two worksheet (2 replies)
  187. Add List value to hyperlink (5 replies)
  188. Solved: Understanding Date and Time Formats (2 replies)
  189. Automatically create Combobox (1 replies)
  190. Checkout system (2 replies)
  191. INSTR (3 replies)
  192. Solved: Looking for values outside of a range (3 replies)
  193. Conditional Copy Paste Code (1 replies)
  194. Solved: auto complete based on the first and last name (combobox / UserForm) (5 replies)
  195. get html img src filenames by Excel VBA (2 replies)
  196. List Folder Based On Search Word (2 replies)
  197. datatype mismatch in criteria expression (1 replies)
  198. finding 12 numbers that'll give me the most result in a row of an array (1 replies)
  199. [SOLVED:] Writing VBA code to loop (4 replies)
  200. Excel visual basic (ctrl+click) copying clicked cells to new excell file (2 replies)
  201. Track and display multiple changes by different users as comment (2 replies)
  202. Browse to a folder and extract all workbook names to a sheet in a workbook (0 replies)
  203. Need Visual Basic code for macro to select pivot field name indirectly (0 replies)
  204. Solved: Error using file on another computer (2 replies)
  205. Basic Help: Copy value from one sheet to another (1 replies)
  206. Basic Help: Copy value from one sheet to another (1 replies)
  207. Solved: Count Unique Values When Filtered (10 replies)
  208. Scripting Web Form (1 replies)
  209. Solved: double click worksheet event limited to a worksheet range (2 replies)
  210. Import selected cells from multiple WB's to 1 (1 replies)
  211. Matching Co-Ordinates (2 replies)
  212. VBA SetCursosPos with co-ordinates of cell value (6 replies)
  213. How can I add a file to the playlist of VLC when it's already in use (6 replies)
  214. turning off calculation on all worksheets (3 replies)
  215. Solved: User can only save workbook if completed, or close without saving (5 replies)
  216. Sending Emails from Excel Via Outlook 2007 (1 replies)
  217. Solved: Help with labelling of graph (6 replies)
  218. [SOLVED:] Filter on matching data in two columns (6 replies)
  219. Efficient Macro - Suggestions (5 replies)
  220. Help required - please (1 replies)
  221. Question on Target.Parent.Active (1 replies)
  222. Probably an easy question for you VBA pros! (1 replies)
  223. [SOLVED:] Cut and paste records based on multiple criteria (3 replies)
  224. Programming help (0 replies)
  225. Grouped Cells - show and hide groups in code (1 replies)
  226. [SLEEPER:] Sum Till Target is Reached (10 replies)
  227. Election results (19 replies)
  228. VBA for Investment (0 replies)
  229. [SLEEPER:] VBA to extract all images from word file (12 replies)
  230. UserForm to select items from dependent lists (2 replies)
  231. Help please - very new to this (3 replies)
  232. Upon returning research userform,date is reversed MM/dd/yyyy(I.need.DD/mm/yyyy (3 replies)
  233. Copy Paste Code (4 replies)
  234. Mail attachment through EXCEL (0 replies)
  235. Solved: Averaging figures logged in the AM vs PM hours (2 replies)
  236. discret convolution (0 replies)
  237. Combining Spreadsheets by feature (1 replies)
  238. Help using For Next loop to delete ranges (6 replies)
  239. VBA 2010 create PDF from multiple sheets (2 replies)
  240. [SOLVED:] vba code for remove blank cells (9 replies)
  241. How to Extract Title from a Text file and Paste to Excel (4 replies)
  242. Copy\Paste (4 replies)
  243. Drop down problems (3 replies)
  244. Solved: text to column question (8 replies)
  245. Solved: Use VBA to assign assign code/a macro to a custom button added to a toolbar?it (15 replies)
  246. extracting from web (20 replies)
  247. Multiple Actions on each cell in loop (8 replies)
  248. [SLEEPER:] Search (6 replies)
  249. Help with an Export Macro to Excel (3 replies)
  250. Solved: Transposing Irregular Data (7 replies)