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. Solved: VBA to select Filter Criteria
  2. VBA for Outlook
  3. Solved: Delete Column if row is blank
  4. Return Lowest Value of Row = todays date.
  5. Solved: Delete same rows
  6. VBA Macro for copy dates in new sheet(s)
  7. Find and replace text in Powerpoint from Excel
  8. Solved: Copy the latest row of sheet A to another sheet
  9. Solved: Converting Strings to Conditions
  10. Crystal Reports
  11. Solved: Replace part of a formula with its calculated value
  12. Code need help ... thanks
  13. Solved: how to prevent macro name visible to user.
  14. Solved: Question about User Defined Functions
  15. VBA Script to get Commision Amt
  16. Solved: Convert String?
  17. Solved: Hide Rows under the criteria above
  18. Solved: AutoRun the script
  19. Solved: simple If statement help
  20. Create formulas using multiple pop-up input boxes?
  21. Hyperlinks and Cell references
  22. VBA Prevent Duplicate Entry via Input Box Help
  23. Solved: Prep many tabs for new year of data
  24. Custom filters
  25. Solved: code to insert data to cell
  26. Special characters on macros
  27. VBA Error when inserting file into Word
  28. Create Outlook email to send out
  29. Subscript out of range (Error 9)
  30. why cant i see the message box on screen?
  31. Copy 2 sheet from 1 workbook to another workbook
  32. Create macro that inserts variable number of rows into tables
  33. Solved: Explicit Range References Keep Changing
  34. Insert colums and fill down - Variables
  35. VBA Internet Explorer Radio Button Help Needed
  36. Programme in VBA, help
  37. [SLEEPER:] Macro value "Text" linking to input cell value of another sheet
  38. [SLEEPER:] Pass Range param from custom function
  39. Getting Password Prompt while exiting vba project..
  40. Update Master File from other workbook
  41. Solved: producing multiple records from a list
  42. vlookup, find and relace the column headers
  43. Inserting Row above filtered data
  44. [SOLVED:] Linear Interpolation
  45. Concatenate two columns in a sheet
  46. problem with date formula
  47. Colour cells using VBA
  48. Use logical OR in ADO parameters
  49. Split the Files based on a Cell Ref - Problem
  50. Automation of outlook mails based on the excel list
  51. Sleeper: Combine data from several worksheets into one with conditions
  52. Solved: VBA to Zip a file
  53. Solved: running dynamic data range from xml workbook into specific worksheet
  54. Solved: 6 month moving tracker
  55. Need formula to arrange column data into different rows
  56. [SLEEPER:] control wordpad from Excel using VBA
  57. Reduce the size of macro enable file
  58. Excel not picking libraries from where it is instructed to pick from
  59. Macro to copy and paste in another Worksheet
  60. [SOLVED:] Combine Formula
  61. VBA Web Query
  62. Date validation in VBA
  63. userform search
  64. Loop not working
  65. Microsoft Office Excel has encountered a problem and needs to close...
  66. Solved: Loop just in activesheet rather than all worksheets
  67. newline data entry
  68. Solved: Invalid cell references generated from macro
  69. Solved: Color on userform
  70. Solved: Filter using dates
  71. Open external file as administrator
  72. Need VBA Code rectification
  73. Solved: not finding workbook
  74. Calculate a week later and then to fall always on Monday.
  75. ms progress bar 6.0
  76. open cash drawer using USB printer
  77. Solved: Set a permanent reference to powerpoint
  78. Help , copy cells with condition
  79. Track changes insert column/row
  80. Solved: Change text string
  81. Solved: VBA and Email
  82. Question about Sort Events
  83. Vba send outlook email
  84. Autofiltered values to a new sheet
  85. prevent your from changing filter
  86. vba to find data in excel
  87. Excel 2007 - export data from Excel to Word 2007
  88. Solved: Why am I getting an error?
  89. VBA Form Opt. buttons scoring
  90. For/Next and custom formatting
  91. Macro to Paste Cells when Column A=0
  92. Bi-Monthly date calculation and results as the column header
  93. Solved: sumif/countif for 'older'
  94. Solved: Inserting new rows
  95. Excel add-in problem, workbook.
  96. Split a cell into multiple cells
  97. PDF into Exce. KB doc
  98. Solved: nasted if/sumproduct help
  99. move rows to another worksheet
  100. [SOLVED:] Counter in Range
  101. Solved: Calculate the cell type that value to calculate
  102. How to automatically create excel templates and send via email
  103. Solved: macro doesn't work anymore
  104. 255 Character Limit when copying worksheet
  105. Solved: Emailing by broker
  106. Solved: Error on VBA Code in 600000 Row
  107. txt to xls excel macro help
  108. Solved: Export a column to text file of certain name
  109. TAB Order Workbook on KB
  110. Solved: only partly activity in Evene_Change
  111. matching with a particular error
  112. link two workbooks
  113. Create multiple workbooks
  114. request formula
  115. [SOLVED:] For Loop help
  116. Solved: Modifying code to select specific data
  117. External Links issue
  118. Updating my CSV File
  119. highlight Cell
  120. Solved: what are these filter things called and how do you add them
  121. How can I formate the date in a text box on a user form.
  122. Solved: VBA Coding Question
  123. Conditional Formatting in VBA
  124. Excel Wont Open Full Screen
  125. compare few columns of data
  126. Solved: How to comparing two columns
  127. Solved: if its not broke... recreate it, using userforms
  128. VBA Basics - automating the process of running commands down thousands of rows
  129. is there an opposite of 'selectedsheets'
  130. Search another spreadsheet to populate userform
  131. Anyone see the compile error?
  132. Error 642 in Word Automation and Style that is not applied
  133. Code Optimisation: Name new sheets from a merge after the filename?
  134. Problem with UDF
  135. [SOLVED:] 65536 Row Problem
  136. Solved: Merging Duplicate
  137. Gathering data from one book for summary in another
  138. Import Active X fields in word doc to Excel
  139. Solved: Error Message when trying to highlight specific cell
  140. Problem on Merging
  141. Solved: Insert Delete Rows Help.
  142. delete rows that do not contain a defined set
  143. Solved: Vlookup in other workbooks fail
  144. Solved: Delete Dash on each cell
  145. Solved: Spreadsheet not updating when I open it daily?
  146. save combobox list to array
  147. Solved: Set Font Color of Cell(s)
  148. Solved: problem with array loop
  149. [SOLVED:] Text in a Triangle Drawing Object
  150. Delete rows based on dynamic data range
  151. Macro to search for string in multiple worksheets and display results
  152. Append rows to existing workbook in different folder and save in different location
  153. Multiply
  154. Solved: copy the first row on sheet to lastest blank row of another Sheet .
  155. VBA Project - Registration process
  156. Importing data from XL file has two sheets
  157. total value of a column in all the sheets to be consolidated in another worksheet
  158. Quick Find of most recent date/time without having to sort.
  159. Solved: Need Help Hiding Columns
  160. [SOLVED:] Criteria based counting
  161. Need Help using array(i) with user form label
  162. Returning Maximized WindowState with QueryClose_
  163. Solved: Clear Content of a4:q900 if=0
  164. Solved: Copy Some cells from row 10 depending on which cells are selected in the active row.
  165. Sleeper: Compare Column Value copy cell
  166. Solved: Compare the active row, to row 10
  167. UK Date Format not US
  168. updata e graph in ppt with excel data using vba in ppt
  169. Checking URL's
  170. Custom Get Open File Dialog
  171. Need help to create a series of covariance matrices in my worksheet
  172. File Browse InitialFileName not working on one Excel 2007 machine only
  173. Solved: Copy Xrows from WrkBk to New WrkBk
  174. Solved: Label and textbox on microsoft Forms 2.0 Frame
  175. Solved: Befuddled
  176. [SLEEPER:] Protect created or saved file as encrypt documents with my user name only
  177. Needed help on copying the data from .csv file to another excel sheet
  178. Delete Rows In A Sheet
  179. Reply to Closed Thread!
  180. Creating a detailed pivot from an existing master pivot
  181. Parse data from Excel to IE using VBA
  182. Solved: Re-arranging Data
  183. PDF Tracker Help!
  184. [SOLVED:] Find cells that contain a string, extract it, then cocatenate to value in Col 15
  185. Macro for CheckBox
  186. Collation of error.
  187. Row index and first three characters in VBA
  188. Trigger macro when user opening any excel file
  189. text format cells be treated as text
  190. Need Help Searching Folder/SubFolder, then Copying to different Folder
  191. Trouble creating a macro for multiplying matrices
  192. Solved: Button movement
  193. Determining if 'End Mode' is on
  194. Solved: Todays Date and Time
  195. Excel 2003 - Prevent Comments in protected locked cells
  196. List all function, properties and classes
  197. Macro to compare excel sheets and add missing data
  198. [SOLVED:] Find number then +1
  199. Solved: Autofilling select sells
  200. Skipping part of a code
  201. Solved: Autofilter: using * in criteria for zip codes
  202. VBA test
  203. Compare two workbook and copy column content if match.
  204. Outlokk MAcro to Maintain the text formating
  205. Delete Specific Lines from Text File
  206. VBA Excel .OCX Control
  207. Error 0: subscript out of order when populating an array
  208. Invalid or Unqualified Reference
  209. Solved: linking userforms
  210. Force users to classify documents before close
  211. Solved: VBA Shortcut - Paste Values, Formats, Both
  212. [SOLVED:] Column Autochange?
  213. Solved: Running a sub based on the value in a cell
  214. Excel 2010 and HPC Compute Cluster
  215. userform combox based on previous selection
  216. Seeking assistance on automating some functions in Excel
  217. Rewriting/Improving Formula
  218. KeyPres, KeyUp, KeyDown - Debug.Print KeyCode
  219. Pivot Table Filter works in 2007, it doesn't in 2003
  220. Excel VBA Error Report
  221. Criteria based macro
  222. Solved: help
  223. Solved: Copying Filtered Data
  224. compare mulitple columns and the status in another column based on the the criteria
  225. Solved: Speed up excel code
  226. A final push
  227. Refresh button to update value of cell?
  228. Solved: Help to copy the formula
  229. Solved: advisor name entered in one cell to auto populate their managers name in other cell
  230. Inserting columns using VBA
  231. Selecting: Just part of a string in a cell
  232. [SOLVED:] staff / alternative
  233. Please help in auto data classification based on mapping
  234. [SOLVED:] Advanced filter - vba method 'range' of object '_worksheet' failed
  235. Calculate only the given range.
  236. Urgent :How to FAST write large recordset in to a text file?
  237. How to add a Custom menu TAB for Seperate work book
  238. How to combine the text into one cell?
  239. Solved: VBA to assign positions for outputs
  240. Excel & Word Mail Merge
  241. Combining data with duplicate rows
  242. Solved: Populating Combobox with Filtered Data
  243. Send a fax
  244. Extract Substring, Ignore Substring for rest of txt, collect data while creating Data
  245. Solved: Save email in drafts
  246. Solved: Alert - When 3 conditions are met on the same row
  247. Error while saving with reference to another workbook in footers
  248. Excel printing continues paper printing
  249. Solved: .Find and activate a Visible Cell within a Filtered Range
  250. VBA / Formula approach