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 167 168 169 170 171 172 173 174

  1. Macro to import/export data
  2. List ALL Formulas & Conditional Formatting in a WorkBook
  3. Solved: Inserting a Specific Date
  4. Tab Order
  5. Solved: Help Required - Audit Trials using VBA
  6. Manipulating Excel cell comments in VBA and with DB Data
  7. Problem programming routine for conditional copy/paste
  8. [SLEEPER:] Create email with filtered data
  9. [SLEEPER:] Import closed workbook - there are lots of methods but which is best?
  10. Solved: PrintArea and Pagebreak woes
  11. Solved: Naming inserted pictures
  12. SaveAs on 2 Cell Based (Path)
  13. Solved: Delete only today comment?
  14. Get page count of pdf files
  15. [SLEEPER:] Run time error #13 while macro runs
  16. vlookup
  17. macro problem please help
  18. Solved: macro to import data from text file to excel worksheet
  19. Rectification of VBA script
  20. Copy one excel file into another one row at a time
  21. VBA Excel Copy cells within one sheet
  22. reference named range
  23. Delete duplicate merged rows.
  24. Excel Vba Code
  25. VBA code giving error on some system
  26. count no. of matching data in two excel
  27. [SLEEPER:] Select and activate ComboBox entry by macro code
  28. Solved: Named Ranges
  29. how to pick last -1 value of the column
  30. VBA code to change font for email
  31. Removing vbcrlf with a macro
  32. Vlookup using VBA
  33. Help required: segregation of data
  34. Solved: empty cells not allowed
  35. Routine cycling data after automatic database sorting
  36. Solved: events problems
  37. [SOLVED:] save/paste column
  38. Solved: Need the Root Directory of Thisworkbook
  39. Solved: Playing Embedded Wav File
  40. Help with a simple Macro
  41. User form "X" button to call Exit button
  42. Solved: New to VBA - How do I open WORD?
  43. Solved: Correct File Selected
  44. Email with Glitches
  45. Compare the columns in two files and results in a separate column
  46. Display text on cell selection
  47. Cell Identification
  48. Solved: Illusive Macro
  49. Assigning Autofilter values to a variable
  50. how to store comments in a string?
  51. unload userform if greater than certain row
  52. Solved: Formatting Text /Numbers in a Textbox of a Userform
  53. DTPicker has gone AWOL ???
  54. Solved: Sum of sales in a Week
  55. [SLEEPER:] deleting hidden rows or columns that have no data in a specified cell.
  56. Import CSV file data and export it in sql file
  57. Solved: Unhide last row in auto filtered data
  58. [SOLVED:] Restore Cell colores from saved information
  59. [SLEEPER:] Condition copy based on list from different sheet
  60. Populate UF Listbox then send to Spreadsheet
  61. write the name of all excel file in a folder in an excel file
  62. Solved: Merging a specific worksheet from multiple workbooks into one
  63. Solved: Chart Series only use last 4 rows
  64. Programmatically updating VBA macros in old spreadsheets
  65. Using StringIndexOf to return two values
  66. [SOLVED:] Color Row
  67. Conditional Format question
  68. Print result in different worksheet with different number of rows
  69. Hidden Workbook - Now Cant Get Back!
  70. FUNCTION to return values from a closed workbook
  71. Differentiate between sources of results on cells
  72. Open each excel file and then close it.
  73. GetValue work with UNC?
  74. Copy details from the uploaded input file and paste in destination file
  75. Pivot table Items
  76. Solved: Passing Value back to userform
  77. Solved: Help Required - Checking formats of cells
  78. Macro to delete entire Row on Sheet 1 if values found on Sheet 2 matches
  79. Non Excel Application Status
  80. Solved: Need to sum column totals for month. - My Code seems to be rounding cell values.
  81. 3D Lookup - using sumproduct / offset functions?
  82. Help required - alter VBA code
  83. Force data entry in cell b1 if data exists in cell a1
  84. Pricing Tool
  85. Delete if value is 0
  86. [SLEEPER:] Hide the Zero's in a new Window
  87. VBA Code to move files from local folder to web folder
  88. Copy all date of column to another cell of another column
  89. delete rows between 2 named ranges in excel 2003
  90. xl2003 and Win7
  91. Add thick box boarder around data after name change
  92. Skip line loop
  93. Solved: Combined loop and find method between 2 sheets is too slow.
  94. OpenAsTextStrem - only want a certain range
  95. Search for all instances of a string then hide all other rows
  96. Determine last used cell of a column and put formula 3 rows beneath it
  97. Addressing a ListObject Table dynamically
  98. Open to specific Directory
  99. What is the error?
  100. Conditional date copying
  101. macro-copy pictures from comments in a column then paste to another column
  102. [SOLVED:] Loop in for used many columns
  103. Solved: Delete Sheet gone from tabs right click menu...
  104. Solved: copy list from one sheet to another sheet
  105. Solved: Create new tab based on list
  106. Shortcut
  107. Deleting headers from the top of a file, then save
  108. [SOLVED:] Delete duplicate data useing VBA in Excel
  109. beta MOS exam
  110. Change value of the cell below based on criteria
  111. Solved: Delete duplicate data in a Column
  112. Solved: Delete just 2 column
  113. Search Cell for unique number from range
  114. Solved: add - when merge data on cell of column
  115. Excel Macro - click after login to a website
  116. Solved: Data Query
  117. Import *.bas in same directory
  118. How to combine the rows?
  119. Solved: How to combine the rows?
  120. How to save the excel as pdf?
  121. Date entry validation
  122. Solved: updating data regularly between 2 workbooks
  123. Solved: Update drop down view list
  124. Return Value into userform.
  125. Copy Data to latest row of other sheet
  126. Solved: Listbox - List values with one decimal place
  127. [SOLVED:] SumUp Filtered Row
  128. Solved: Filter Records before sending to userform
  129. Solved: Fill Down Formula
  130. Absolute beginner in need of help
  131. Solved: Application.Max problem
  132. Securing a sheet with VBA in excel
  133. Excel VBA Macro event Workbook_BeforeSave
  134. TFS Connection using Excel VBA
  135. PDF tow Excel
  136. Macro to copy the filter data from excel file and copy to other excel file?
  137. Hi experts, how to import csv files into ms Excel using visual basic.
  138. Solved: License information... not found
  139. (Un)Hide columns based on a list
  140. Combine Multiple Worksheets Into 1 New Sheet
  141. enter formulain cell through VBA
  142. Assign a value of a variable to a specific cell
  143. Filtered range - need to row numbers :/
  144. Is it possible to automatically removes spaces, commas, and delimiters using VBA?
  145. Adding a new criteria to a filter
  146. XY Scatter Plot from Pivot
  147. Code doesn't work unless worksheet is active
  148. Solved: Add MS- and delete the 3 of first number
  149. How to do the loop for find text in a particular column ?
  150. Above 65536 Data to be paste
  151. Solved: Find the rows count in in a column where cell value >0
  152. interactive chart
  153. Solved: check column and delete
  154. Paste columns, rows or cells
  155. Vlookup on a sheet with merged cells
  156. insert missing columns
  157. Solved: Paste to latest empty cell
  158. Catenate Help
  159. Solved: VBA not working
  160. Changing numberformat
  161. Autofill down based on two conditions
  162. [SOLVED:] Problem with column
  163. backing up your macros?
  164. Solved: search text in a worksheet then copy the whole column to master sheet
  165. Solved: Unable to close excel
  166. check box
  167. VBA sort rows based on 1 of 2 values in a Field
  168. [howto] Fetch data from txtfile and segregate it into corresponding field.
  169. Can anyone make this more efficient?
  170. Solved: Text to Columns with an extra bit
  171. Help to convert formula into VBa code.
  172. User name pulled from Windows
  173. Can't Add Command Button
  174. Solved: Password Protecting - Command Buttons
  175. Advice on storage data into array
  176. VBA Code Help
  177. Trouble with Vlookup in VBA
  178. Just a Thank You !
  179. IF Range Select not working
  180. Reduce code and return empty if empty
  181. Protect Cell and Range
  182. Solved: Auto Size / Center View Screen
  183. split as per Map sheet
  184. Display Pivot Table values in a userform
  185. Excel data to Word Email Merge
  186. Adding a new line
  187. formula error
  188. Access restriction
  189. Consolidate Files From Mutiple Sub Folders into One Folder
  190. Solved: Mergin two bits of code to format cell
  191. Raise event to unknown object.
  192. Is it possible to copy values from a worksheet to another worksheet using vba?
  193. Concatenate multiple cells to each cell
  194. Solved: XL 2003/Win XP - VBA File Browser -How may I free up Folder access after running code
  195. How to auto populate an excel spreadsheet with data from another spreadsheet?
  196. Solved: Find text in a column then move the row to left
  197. How to create macro which will move data from one worksheet to other worksheet?
  198. Solved: Help required : syntax correction
  199. Navigate to Sheet name from cell Value
  200. Solved: More than 7 Nested IF's
  201. Solved: back to sheet
  202. Trouble making a dropdown work
  203. Sleeper: Variable Range Issue
  204. paste range in powerpoint
  205. Can't Get macro to run in Excel 2010
  206. [SOLVED:] Count unique values based on multiple criteria
  207. Solved: Looking up matching cells
  208. Solved: Color coding rows by market value
  209. [SLEEPER:] Excel Hide/Unhide Sheets based on cell value
  210. Uninstall Excel Utilities
  211. Solved: Send an outlook email by reading from cell values
  212. average based on criteria
  213. restore external links to excel pivottables
  214. Garbage data is copying to other sheets column?
  215. Solved: Pass Multiple Values from A Textbox
  216. User Form to Update data in Another workbook
  217. Solved: Converting Numbers
  218. Appending to Workbook Name
  219. export file as *.xlsb with open password protect
  220. Date within date range
  221. How to update files info [File listed in range with full path]
  222. Custom Document Properties help
  223. Compile error in hidden module
  224. Compare rows with first row and copy the matching records in another sheet.
  225. VBA to Save and close Multiple Notepads
  226. vba to automatically update data and graphs
  227. problem when downloading xlsx file.
  228. Excel to Word table edit - is it possible using VBA?
  229. Using Pivot Tables in Excel to show Qualifications over time
  230. Solved: Copy to another sheet problem .
  231. VBA project not allowing existing excel sessions to open.
  232. Not sure where to put this - VB login form
  233. Change Excel Link Using VBA
  234. Store and modify column letter in a variable
  235. Insert Worksheet
  236. Save as with Variable file location
  237. [SOLVED:] Dynamic range that change variables
  238. Populating Combobox
  239. Replace all comments
  240. Defining dynamic ranges to work across multiple workbooks
  241. Creating Summary from 2 files
  242. Solved: Progress bar till the macro is done
  243. Mailing with Excell vbscript help
  244. number error
  245. Can I increase the speed up without change the code?
  246. IE submit - nearly working
  247. Dynamic Range Help
  248. Solved: Cut and Paste Value to matching Column
  249. Run VBA Code of diffrent sheet Automaticly
  250. Webquery