PDA

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

  1. Solved: Tricky formula help?
  2. Solved: Mandatory fields
  3. Solved: VBA help... Gaining access to training or information
  4. Code to match two sheets and display differences
  5. Undo option
  6. How to hide the workbook while exeuting macro?
  7. Solved: Find Empty column
  8. Challenging Macro to reverse the function of an existing macro
  9. Extract certain data from file.
  10. Formula help for counting indexed cells?
  11. Finding Unique ID Number & Fill the Cells
  12. Format Msgbox
  13. Merge all unique values into one in a required column
  14. Data Extraction
  15. Solved: Problem in auto loading toolpak add-in
  16. need help protecting source code..
  17. Refresh Data
  18. Datediff in vba
  19. Solved: Merging two columns as a unique column
  20. Grabbing the cell value before it is changed (or on cell selection)
  21. macroto recreate fucntion of grey ADD/REMOVE button onto blue ADD/remove button
  22. Solved: How to make the mouse Scroll locked
  23. Excel
  24. Solved: Copy a file to the users desktop
  25. Copy a sheet from all workbooks in a folder
  26. Write To Web Page
  27. Solved: Validating a textbox
  28. How to disable the selection of Workbook
  29. Validating an entry against a database
  30. Disable 'Save' and 'Save As' dialogs
  31. Trying to call access functions in excel
  32. Solved: trying to import csv in macro from web.
  33. Solved: Password Protecting particular rows in excel
  34. Solved: move records
  35. Subtotal calculation using Macro
  36. Solved: Sumproduct (Formula not working correctly)
  37. 2nd Userform amend posted worksheet to not show UFC Column B
  38. Ideas to speeds up PivotTable VBA
  39. removing 0's macro based on columns
  40. Solved: If cell = "" then highlight cell
  41. Solved: Replacing Text
  42. DRJ's conditional formatting
  43. Showing Formula with values in other language
  44. Looping/Copying/Other
  45. Solved: Matching
  46. Save File Without Showing Window
  47. Solved: Charting Macro Problem
  48. Alignment of new data and add boarders
  49. Workbooks.Open using network path
  50. Copying Data to Specific Tab
  51. insert comments from countif
  52. Solved: autofilter question
  53. Compare Sheet1 and Sheet2 Results in Sheet3
  54. Cell Formatting
  55. Solved: Check and copy rows
  56. Solved: send sheet
  57. Conting consective cells based on criteria
  58. Solved: Edit MP3 tags in Excel / VBA
  59. determining user domain account (AD) from VBA
  60. Solved: Using For Loop to get info from Text box
  61. Solved: How to loop through the columns???
  62. How to check the data column and empty column???
  63. Solved: The use of [] brackets for assigning values or arrays
  64. worksheets order + protection
  65. workbook_open: simple question
  66. compile error
  67. Clear constants in a selection
  68. Solved: Match function
  69. Select last 30 cells
  70. Solved: Formula in VBA code - modification requested to avoid Error
  71. Solved: Floating listbox to navigate within a single worksheet
  72. Solved: Process checklist
  73. Check if a Dynamic Array has been ReDim'ed...
  74. [HELP] Charts.Add and Range
  75. userform review function
  76. Display HTML code in Form textbox
  77. problem with filter condition
  78. Append File Names to an Existing List of File Names
  79. Un-wanted audio alert
  80. Solved: Extract info of a point on a chart
  81. Solved: To edit data using UserForm
  82. How to plot on a image file embedded in excel
  83. creating a chart using VBA
  84. Do While Loop Help
  85. Solved: Search Form Help
  86. Solved: Check contents of cells in header row
  87. Code to install addin feature
  88. Solved: copy data in sheet1 and paste in sheet2
  89. Solved: Reverse code on a macro
  90. Solved: Use a variable to reference a control?
  91. Solved: Advance Filter & Last Rows Sum
  92. detele unnecessary rows
  93. Solved: Using Treeview Control
  94. Userform as a variable and moving data
  95. Solved: Removing All Duplicates
  96. Solved: Scrollbar Control Reverse counting
  97. Solved: Refer to Range Names on Different Worksheets
  98. Solved: past due report
  99. Solved: Filter Combo Box Value
  100. Solved: Use textbox to display data related to the child node
  101. Solved: MenuMaker - disabling menu items
  102. code tweaking
  103. Solved: VLOOKUP resuts
  104. Show user form
  105. excel programming issues
  106. Loop thru range, find and copy data to matching sheets
  107. Solved: How to Identify Worksheet Name for Each Range
  108. Permutation two
  109. Solved: Extracting specific data
  110. Solved: How to Rename a Defined Name
  111. insert data in dialog box...
  112. Query data from two databases
  113. Solved: Help in finishing the code
  114. Solved: Problem with Date Format
  115. Advanced Filter Creating Named Range?
  116. A sound on conditional formatting
  117. Solved: Run Time Error 13 & Format Func in userform
  118. ADODB, SQL, INSERT - force the type of inserted data
  119. Solved: Enter password as *****
  120. Control Treeview
  121. Ungrouping all Row and Column ranges in workbook
  122. Solved: Set Worksheet Name and Locate Range Info
  123. Update macro to add tan border as shown in worksheet example
  124. Solved: Sorting by month of year
  125. Solved: Highlight the entire row on click
  126. Solved: Get average table for each month in Column L
  127. Attaching Objects Code
  128. Solved: Hide Columns Form
  129. Solved: Using String in a cell as reference for a cell
  130. Convert data for Pivot Table
  131. Copy data to new sheet to remove duplicates
  132. Solved: How to get a URL address from the cell value
  133. Solved: file generation + naming from a variable
  134. Solved: CountIF based on logical operators
  135. Solved: How to Format Font in Middle of String?
  136. Solved: range question
  137. Solved: VBA - Get Range of a Range ??? How?
  138. Solved: Mousemove event with shape
  139. cannot createobject using "internetexplorer.application"
  140. Solved: Tool allocation forecast with multiple IF statements
  141. Listbox RowSource Requires Range or String
  142. Open multiple files as workbooks
  143. VBA macro code to find last worked row or column
  144. Filling Mandatory Cells in Excel
  145. Show running time of macro
  146. Solved: Remove commas and spaces in the middle of a string
  147. Solved: Count tabs in Workbook
  148. Macro to generate random number then User needs to guess that value
  149. Solved: List box items selected but wrong message
  150. COUNTIF for more than 1 thing on the same formula
  151. Close out without saving
  152. writting sum function in VBA
  153. nested If statement
  154. making define name ranges to work for other worksheets
  155. Solved: Fill down formula
  156. Solved: Last used cell
  157. Solved: Help with macro
  158. Solved: Incorporating a version number (incremental) in filename
  159. Macro to ask to find file
  160. Solved: Top 3 highest values in range
  161. 2 different color at the same cell?
  162. Flashing Cell
  163. Tidying up the code and adding functionality
  164. Solved: Index / Match Multiple Criteria Issue
  165. Flow chart
  166. Solved: Hide Buttons in code?
  167. Text to Columns question
  168. Reading Word files and search for key words
  169. Solved: save location
  170. find data from one workbook to another workbook
  171. Solved: Preventing a user from saving a file as a different name.
  172. Solved: Incrementing to next record
  173. Solved: getting the file not found error
  174. Reposting as original attachment was corrupt
  175. Solved: Workbook_Open view in 100% zoom
  176. create moviedatabase, search IMDB.com
  177. Formula for cell value
  178. Running macro periodically
  179. Extracting Unique Values from a Column
  180. Macro replacing text in each row by column
  181. charting with vba
  182. Blink Control
  183. Error Checking
  184. creating graphs from vba form
  185. Solved: Copy Cell Values from Non-adjacent columns
  186. How to obtain properties of graphical "line"
  187. Make decisions
  188. Solved: Looping through Columns
  189. Format display in the comboBox
  190. Add week ending date to newly created and renamed sheet?
  191. Working with Multiple Appls Simultaneously
  192. Solved: Extract and convert Data to new sheet
  193. Return top 5 From a tabel of data
  194. Open files with wildcards
  195. Solved: VBA code to create / insert macro
  196. Solved: worksheet_change event does not trigger on copy/paste
  197. Enter File Path in Webform then Submit
  198. Automation error - Element not found
  199. Solved: can't name darn worksheet!
  200. Solved: Searching specific text in cells in a column
  201. Protect excel workbook
  202. Use Do While instead of For/Next
  203. Solved: How does this work?
  204. howto convert a excel file to a htlm file inclusive macro's
  205. Solved: Disabling cut copy paste on certain cells
  206. MACROS
  207. Sumproduct Error
  208. Last Active Row - Help modifying for Column
  209. Solved: Make me look like an Excel/VBA Rockstar....
  210. Error message when combining all excell wkbks in a folder using macro
  211. Desperately need VBA code help
  212. [SOLVED] email via outlook from excel
  213. Fill Remaining Chart Percentage
  214. Solved: Getting data from web site
  215. Macro screw ups
  216. Solved: Need help removing a menu bar created in excel 2003
  217. more than 2 dims in an array?
  218. question on a constant + loop on a range
  219. Compare Data
  220. loop + array: complex for me :(
  221. Solved: Updating Charts in VBA with listbox
  222. Solved: Populate Combobox in userform
  223. Solved: How to pause a macro
  224. How to add a row in different files?
  225. Solved: Inserting Formulas With Loops
  226. Solved: TextBox formula
  227. if any cell in a row = > 70 Generate email Alert
  228. Solved: Insert row with formatting and formulas
  229. stop macro from replacing existing price and UCF cost assigned to a customer to zero
  230. Sort excel and get top 10 and bottom 10 rows
  231. Excel send to mail recipients help
  232. How can you stop users from opening a file twice.
  233. Excel vs Access VBA
  234. Converting Criteria Listed in Excel For Data Validation
  235. Report on a Count of Colours Cells by Unique Row and by Column.
  236. Merging two worksheets
  237. New column through existing ones
  238. Solved: Combine Cells in multiple sheets into 1 sheet
  239. Solved: How can I delete all Queries in workbook?
  240. Solved: Data input from message box
  241. Solved: Download EXE files using VBA
  242. retrieving data in a list according to 3 criteria
  243. Solved: Disable One Procedure While Another Runs Then Enable Again
  244. Reversing a Macro
  245. Solved: Saving a copy of a spreadsheet, external file?
  246. Checking entries to see if it is a valid entry
  247. Directory/Folder listing
  248. Copy and Add to Range
  249. Little help with Autofill please
  250. Lookup code - I am missing something from my code!!