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. Import multiple files into a single sheet
  2. Solved: Copy subtotal values
  3. Solved: Code Modify
  4. Delete Rows : urgent
  5. Solved: Dynamic Conditional Formatting
  6. 'For' loop
  7. Solved: Count number of cells and export to Word
  8. Solved: Validate Input Data in Userform
  9. Solved: Save current workbook to filename in format dd.mm.yy+string variable
  10. Loop through listView & update checkbox
  11. Opening A Sheet From A Combobox
  12. UDF to calculate moving average
  13. CANT SHUTDOWN EXCEL.EXE PROCESS
  14. Convert sql to vba code
  15. Solved: Several issues with my code
  16. Solved: VBA Email - Reply to Address
  17. Advance Filter
  18. Solved: Dynamic List of Worksheet Names based on criteria
  19. Solved: Copy & Paste and Adjust Data
  20. Copy & Paste data from column I
  21. Want to convert a Date
  22. Switch to an Active web browser windows with specific title
  23. Categorize Deadlines Based On Past Due/Period Remaining
  24. Comparing lists in columns?
  25. Solved: Userform query
  26. Solved: Colour entire row
  27. Solved: Timing my macro
  28. EXCEL CHARTS
  29. Solved: subtract date/time formatted fields
  30. Accessing Addin functions with VBA
  31. Calculating installments left
  32. Can't get PasteSpecial to work
  33. Solved: fill blank/black cells with 0
  34. Solved: Copy more than one sheet to new workbook
  35. Calculating project time
  36. Run Command When Push Print Button?
  37. Solved: Getting Rid of an Annoying Feature in Excel
  38. Getting date format in comboboxes?
  39. Solved: VLOOKUP Help
  40. Time and column spacing
  41. Want to halp USEFORM
  42. How to change mixed case names to proper case?
  43. Solved: Force Hide Formula Bar
  44. Validating values of a column in a file from another file
  45. Solved: Script out of Range on Variant Array
  46. Solved: Problem when trying to use close method of workbook object
  47. Sum not correct
  48. Modify a macro
  49. Solved: Dynamical generate name ranges
  50. Find and replace (Excel&Word)
  51. Logging into website
  52. Solved: Amend Macro in worksheet Cashflow Yearly
  53. Solved: SearchWord Help
  54. Solved: VLOOKUP AND COLUMN FUNCTION
  55. Solved: Alternative to "vlookup" function
  56. Solved: Tricky copy and paste macro
  57. Solved: Automatically Update graph
  58. ploting the graph according to the sheet selected
  59. ploting the graph according to the sheet selected
  60. Rowheight plus a little bit more
  61. Solved: Delete Rows that contain X in column Y?
  62. Modifying the existing graph
  63. Solved: Beep in Excel
  64. How to select changing cells within a column
  65. How to paste X in column A according to the length of column B
  66. Amend Forumla
  67. Solved: Return a Range in a function
  68. Debug Help with a Delete button
  69. Viewing records in workbook\worksheet form
  70. Email/Excel/based on a condition
  71. Solved: Ranges as arguments in a VBA function called from the formula bar
  72. Solved: between dates in vba
  73. Dcount Last Character In Column
  74. Solved: List all files in folders
  75. Solved: Summing Macro
  76. Solved: Add To Code
  77. Solved: ListView control with images
  78. Data shifts on adding new customers
  79. FONT COLOUR DROP DOWN ON CELL
  80. A program to delete certain cells
  81. Solved: IF THEN COMMANDS??
  82. Solved: Vb New Line
  83. Chnage formula to ONLY allow column D and K
  84. Email Run-time error predicament
  85. Problems with Saving permissions
  86. Networkdays Formula
  87. Solved: Find cell and return value as string
  88. VBA Cell value mutiplication
  89. Solved: Need help with Loop routine to enable 20+ checkboxes
  90. Solved: excel2000 question
  91. Solved: Save As an Excel using VB
  92. Count non-hidden cells in a pivot table
  93. setting a workbook as a constant
  94. Hide value in Listbox if 2nd Column = 0
  95. Solved: 2 dimensional dictionary object
  96. excel spreadsheet to .EXE
  97. Solved: sum values based upon 2 conditions
  98. SUM/COUNT CELLS BY FILL COLOUR
  99. Solved: Very Custom Program
  100. Processing XSD schemas using VBA
  101. Double Entries
  102. Solved: Populate Listbox with Mulitple Columns
  103. Copy data from web
  104. Solved: Leave TextBoxes Blank
  105. Solved: Hide Row Based On First Few Letters
  106. Solved: Change PivotTable Data Field in VBA
  107. Solved: It's late, please help simplify this formula
  108. Error's want to help
  109. Copy variable range and copy to another sheet
  110. Solved: Save as Filename with a variable text
  111. Set SummaryRow format
  112. Combine2 Name Colums to Create emails
  113. Help with Replace Function
  114. Edit a cell depending on previous choice.
  115. Solved: Available Resources issue
  116. Solved: Vlookup from data in unopened file?
  117. Solved: variable not defined in
  118. How to enter date into pop up, which enters into spreadsheet
  119. How to compare the difference between 2 excel files
  120. Create request
  121. Last Duplicate Value in Column
  122. VB code
  123. Solved: Followhyperlink code
  124. Solved: Custom Formats
  125. Copy data from Multiple to SINGLE worksheet.
  126. Pivot Page fields to new sheets
  127. greatest date and time
  128. Solved: adding locked cells via macro
  129. Solved: Copy range from one sheet to another
  130. Solved: Copy row of sheet2 (if data does not match sheet1).
  131. Advancedfilter Delete Row(s)
  132. IF STATEMENT TO extract result
  133. Solved: Alter Code To Allow Spread Sheet To Close
  134. Insert today's date, save file and close
  135. Excel Signing Invalid because of XLA location change
  136. Insert column
  137. How to delete all rows that don't have a specific name - e.g. "XYZ"
  138. Number format Question?
  139. Run macro automatically when a cell value changes
  140. Select check box on web page
  141. highlight cells between two dates in cluding the cells with the dates
  142. Font color
  143. Help using Excel as a database
  144. How to give a dataset corresponding ranges?
  145. Print when Command button is pushed
  146. Solved: Message Box Input calls Tab Name
  147. Solved: Loop for Value True/ Copy 4 cells to other sheet
  148. VBA Question - How to find the contents of one cell in another worksheet?
  149. Solved: Macro Problem - Hanging
  150. Solved: copy sheet and change formula reference
  151. Solved: Removing numbers from a text block
  152. Sinking worksheet together
  153. Formula Error
  154. Code to allow A Customers ID to only go in a spread up to 3 times?
  155. Place in first empty textbox?????????
  156. Placing in the same row as a spefic customer
  157. UDT Question
  158. Solved: Save button
  159. Solved: How can i?? Press a button and it will make a calculation of +30days!
  160. Solved: What can i do when it says not a legal object name.. and then wont let me do anythin?
  161. Solved: Save button
  162. When using a combo bow to select a row
  163. Solved: find duplicate entries in colunms
  164. Solved: Edit code to change cell value
  165. Solved: Loop through sheets
  166. Solved: Restrict Menus & Right Click Menus & short keys
  167. Solved: How can I create linked Vlookup data from multiple closed workbooks
  168. Find and Replace Page Down in excel
  169. Multiple Charts To Multiple Slides
  170. conditional adding through sheets in a loop. Novice.
  171. Solved: Jump to last worksheet
  172. Runtime error in macro
  173. Solved: Save in both Excel 2003 and 2007
  174. Solved: Remove ' from text
  175. Simplify Code
  176. Duplicate Master freeware utility?
  177. Custom Sort
  178. Sort, Page Break and Page Header according to cell values in different worksheet
  179. Solved: Passing variables through properties
  180. Sub or Function for IF ...
  181. Split text between cells Help Needed
  182. collection issue with custom type variable
  183. Solved: move sheets to new book (array)
  184. Copy and paste data after printing
  185. Solved: Partial String ListBox search to populate another ListBox
  186. New Excel Application
  187. Solved: Green if zero, Red if not
  188. Subtotals using Macro ...
  189. Notification when macro is executed
  190. Solved: Notification when macro is executed
  191. Solved: How do you return / pass values?
  192. When looping through sheets remove subtotals only works on first
  193. Solved: Combining macros
  194. Using a combo box to select a named worksheet
  195. Command Button to save, print and clear
  196. How to delete a row if it contains a word?
  197. Solved: Code change to allow for Data table changes
  198. Solved: Loop through one column on any sheet in workbook....
  199. CommendBox
  200. Solved: Feeling dumb today!!!
  201. Getting Data from an Excel Spreadsheet object to a normal excel spreadsheet
  202. Solved: Add Border if Statement
  203. Count coloured cells and display result in table.
  204. Group 2 cells like in a userform.
  205. Excel Right Click Menu Always Up
  206. rectangle question
  207. Solved: Saving As Text adds double quotes to some lines!
  208. VBA for time display
  209. Check if a file on the web exists
  210. Controlling Internet Explorer's "Print pop-up"
  211. Clipboard is full
  212. Solved: move up
  213. Random number generation
  214. Summing a column based on two criteria in other columns
  215. Listview help
  216. Pass a named range into function issue
  217. How to find the last duplicate value
  218. Solved: Problem auto-installing VBA add-in
  219. Formatting entire row based on text in first column
  220. Combobox Visibility After Drop List Selection
  221. Help! I'm working with two spread sheets
  222. [Help Please]Parsing parameters to event
  223. If no dependents msgbox and resume loop
  224. C&P all data of all the sheets/workbooks in a folder.
  225. Execel, OLEObjects (buttons) sometimes not firing, triggering
  226. Excel Macro Help Please
  227. problem using a function from an external library in vba
  228. Solved: Variable Columns Lengths
  229. Solved: Create a worksheet for each value in Column A
  230. Split string into multiple parts no bigger than 240 chars?
  231. Solved: alpha-numeric 2
  232. Solved: case yes-no, can the code be smaler?
  233. Easy! How to make a button that generates a random number?
  234. Solved: using a worksheet function in vba
  235. Solved: Sum and compile list of entries
  236. Solved: any value in a range = 0 then return 0 ?
  237. Solved: From one array to another
  238. Solved: problems saveing two copies.
  239. Solved: Userform buttons to enter numbers into textbox
  240. Solved: problem of structure
  241. copy range, skip empty cells
  242. Solved: Fast Compare using Filter
  243. Alternative to Eomonth formulae question
  244. Solved: make a dynamic if statment?
  245. Solved: Special Transpose
  246. From one sheet to another...
  247. loop + offset/resize problem
  248. Extracting certain data to another sheet
  249. Macro Security
  250. worksheet is not picked up in Vba