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:] Inspecting dates of a Policy period
  2. [SOLVED:] VBA code for tracking tracking updates in a column
  3. [SOLVED:] How to Extract Row reference from chart series
  4. [SOLVED:] Counting conditional format colours, column by column
  5. [SOLVED:] Chage default program to open a filetype?
  6. Extract Specific Text From Middle of a String
  7. Update workbook
  8. [SOLVED:] Suddenly can't do anything in VBA ?? "Access is denied" ??
  9. Copy/Paste Recolored Picture with VBA
  10. Automatic graph generation macro
  11. [SOLVED:] Some explanation requested on converting string to double.
  12. Excel Macro Code Crashing
  13. Hide rows based on results of a drop down box on another sheet.
  14. [SOLVED:] Help with For..Next Loop
  15. Moving highlight scroll bar
  16. Remove duplicates on three criteria
  17. VBA code for extracting three specific number patterns
  18. Opening CSV files disables / uninstalls add-ins
  19. [SOLVED:] Excel data to Word with images
  20. Excel form to save data in Access
  21. [SOLVED:] Can't find out my mistake using a variable
  22. OLEObjects Inside UserForm
  23. Working with dates, ranges, and arrays
  24. Find data from other workbook-Copy All column on row
  25. Excel VBA to open a website and search for specific words in search box
  26. Change graph source data by vba
  27. [SOLVED:] VBA MACRO CODE FOR getting sheet names at once in multiple sheets
  28. ListView at runtime
  29. [SOLVED:] If a cell contains #N/A then copy paste end of row
  30. VBA code to add a line immediately before a footer.
  31. Code to identify the start of an event and then report that time - multiple columns
  32. [SOLVED:] Using Functions in VBA to bring a value to a variable without using the worksheet
  33. Get Word VBA macro variables passed back to parent Excel macro that called it
  34. [SOLVED:] Countifs syntax and use, beginner question
  35. Excel Macro VBA capture dynamic column
  36. Selected Sheet Range copy One after One!
  37. [SOLVED:] Conditional formating using relative references
  38. [SOLVED:] Turn first and last names around and remove middle initial
  39. [SOLVED:] Reading text files without .txt extensions
  40. Use IF or a VBA to check multiple fields and display specific text in a cell?
  41. [SOLVED:] How to show percentages from multiple cells in the caption for one.. userform button
  42. [SOLVED:] Countifs syntax (beginner question)
  43. [SOLVED:] Having problem with autofilter vba
  44. VBA code to sum cells based on text in a cell in the same row but different column
  45. VBA errors
  46. [SOLVED:] VBA MACRO CODE FOR GROUPING THE DATA BASED ON 2 HOURS TIME...
  47. VBE I/O Errors, Out of Memory, and crashing of Excel due to duplicate VB code
  48. VBA code to identify folder based on folder name given in a excel sheet
  49. Excel to Outlook help
  50. VBA code to list all folder names in excel
  51. Set Tab Order
  52. VBA to N-DS
  53. Consolidation of 5 worksheets into a single master sheet
  54. calculate 2 datetime and returning to days and hours
  55. [SOLVED:] Start Command Button from different sheet
  56. Replace Cell Ref in Formula with Value
  57. help with VBA to classify and highlight row based on value of cell
  58. help with VBA to classify and highlight row based on value of cell
  59. help with VBA to classify and highlight row based on value of cell
  60. Help big project due
  61. Semi-Generic Bar charts
  62. Need Help with Error Message
  63. 2007 Menu Issue
  64. Calculate Average Handling Time, without a timer??
  65. [SOLVED:] Return data not duplicated via formula?
  66. Hyperlinks in a body of a Task
  67. [SOLVED:] FileSearch VBA error - please help!
  68. [SOLVED:] formulas business days (automatic list)
  69. Carry text formatting between chart titles
  70. [SOLVED:] Help to duplicate a range on one tab to another multiple times based on a cell value
  71. Getting data from web
  72. [SOLVED:] Searching multiple columns and returns the values in excel vba
  73. return a value into a vlookup cell
  74. [SOLVED:] Importing share price data (open, high, low, close & volume) from website
  75. RegEx Newbie
  76. [SOLVED:] I need help merging workbooks (1 worksheet in each) into a summary workbook.
  77. [SOLVED:] Beginner: Application.Caller for a shape
  78. Help with a search and copy funktion
  79. [SLEEPER:] Filter pivot tables with one pivot table with multiple value selection
  80. VBA Code De-bugging in 2010 excel
  81. SFTP Error
  82. Text File Import w/ Variable File Name
  83. Sleeper: Ignore If statement if condition equates to error
  84. [SOLVED:] Separating piece of file names into three different column
  85. How to append Signature File in Lotus Notes??
  86. Macro todelete a chart if it has zero values using VBA
  87. [SOLVED:] VBA Multiple Sheet Formatting
  88. [SOLVED:] Application.FileSearch in Office 2010
  89. Downloading an Excel file from a website
  90. Calculating Difference of Workdays
  91. [SOLVED:] AutoFilter criteria help
  92. [SOLVED:] When is data removed from the clipboard? Can I avoid copying a range for each paste?
  93. Exclude specific worksheet from existing code
  94. [SOLVED:] Can this be done in a formula?
  95. VBA Yearly Extract
  96. [SOLVED:] how do I change file extension on VBA that I already use
  97. Merging Data From Workbooks macro
  98. Mid() mismatch
  99. [SOLVED:] Select, Zip, and Email Excel files
  100. [SOLVED:] Can you clear ALL .OnKey assignments at once?
  101. Recore new macro tool - automatically start on opening
  102. custom views with a protected worksheet
  103. [SOLVED:] Stability Issues in VBA macro
  104. hyphen in code
  105. Need a macros that read a range of cells, determine low value, then do something else
  106. Excel 2007 to Excel 2010 Incompatibility
  107. Using multiple checkboxes to hide and show specific columns Excel 2010
  108. switching between running Programs or Alt+tab
  109. Output From and to document numbers and missing number for each branch in given range
  110. Need help editing this macro code
  111. Run macro in all worksheets
  112. [SLEEPER:] Selected Slicer Value to Populate Cell
  113. [SOLVED:] Print two different worksheets from two files within one folder
  114. vlookup question
  115. Anyone Used LockXLS?
  116. Help creating lotus email with attachments from excel look up list
  117. [SOLVED:] Search rows on one or more criteria
  118. [SOLVED:] Date format issues with date picker on form
  119. Create separate word docs with data from xls
  120. [SOLVED:] Can a Add-in detect when you save a different workbook?
  121. [SOLVED:] Listing Conditional Formatting on Separate Sheet or Workbook
  122. need help with VBA for copying highlighted rows
  123. [SOLVED:] loop thru rows and populate a cell based on another cell's content
  124. [SOLVED:] Conditioning the names in a cell
  125. [SOLVED:] Clearcontents method of range class failed
  126. Copy files listed in Excel from one directory to another...?
  127. programmatically add reference and module in one macro
  128. How to Convert XLM Files to Excel VBA Workbook/File?
  129. Array Into Outlook Messages
  130. [SOLVED:] VBA Stacking cells on top of each other
  131. Compare and Copy
  132. If function wont distinguish between letters and numbers.
  133. [SOLVED:] cmBox.setfocus doesn't give cmBox focus. Why?
  134. How to make all MsgBox and InputBox pop up in the same part of the screen.
  135. EXCEL 2010: Macro is not working
  136. Create a Loop Until using VBA
  137. How do I set .MarkerBackgroundColor in a chart to a ThemeColor with TintAndShade?
  138. I Need assistance with popup calendar macro in excel 2010
  139. problem with VBA when I open Excel automatically
  140. select and delete row based on a cell's value
  141. Creating Dynamic Named Ranges for Dependent Data Validation Lists
  142. Beginner's Question on IF function in VBA
  143. Add blank rows to fill a page
  144. VB, Input Boxes and Printer Selection
  145. formula using VBA
  146. Sort not working anymore
  147. VBA to copy from a web browser
  148. Using a percentage in VBA
  149. Combining Workbooks with different file extensions
  150. destination name problem when error handeling... Please Help!!!
  151. [SOLVED:] Find PN then trim all spaces
  152. Run time error 1004 Select methof of Worksheet class failed
  153. [SOLVED:] macro to take information from. xml file and put it in. xls file
  154. [SOLVED:] Row deletion..!! Reverse case...
  155. Find match copy paste from another closed workbook
  156. [SOLVED:] Find word insert formula
  157. Copy row from one sheet to other sheet
  158. Can anybody help me?
  159. [SOLVED:] More precise number formats with "$" symbol?
  160. How to paste data into next available blank row
  161. InputBox OK and Cancel Button Problem
  162. Close Workbook Only if Completed
  163. How to fill down to a certain length and delete everything before it
  164. Consulting work recommendations
  165. Userform Populated with range from another excel file
  166. vlookup query using VBA
  167. Automatically populating data when a certain column is filled
  168. get Zip codes from web based on address in cell excel VBA
  169. [SOLVED:] Lookup Value in Range for an If Statement
  170. [SOLVED:] Help Using Excel Month Function
  171. Compare two workbooks and generate a report for the differences.
  172. copy and pasting pivot graphs in different worksheets into a new worksheet
  173. [SOLVED:] Class Modules - a few questions
  174. run Word script from Excel with multiple open documents
  175. Need VBA help duplicating certain rows and manipulating data on these rows
  176. [SOLVED:] Banding Formats
  177. How to shade rows with three different colours
  178. [SOLVED:] delay in a macro?
  179. Consolidate worksheets with specific requirements
  180. Include theme colors in an add-in
  181. VBA Code For Appending to the text file
  182. Macro becoming slower
  183. Copy range and paste depending on the selected checkbox
  184. How Do I Get An Excel Sheet That Validates And Then Emails?
  185. [SOLVED:] Colour cell in column F if any value in cloumn J
  186. Excel Module to find() and assign variables
  187. Check a list of names, if a worksheet exists move on, if not, create one
  188. [SOLVED:] VBA to create Table of Content but EXCLUDE xlSheetHidden andxlSheetVeryHidden
  189. Pivot Table Link Help
  190. [SOLVED:] Compile error: Type mismatch: array or user-defined type expected
  191. Vba Pivot table
  192. Sleeper: Finding and adding up values
  193. [SOLVED:] Help with excel formula
  194. Copy Range from active row to new sheet
  195. [SOLVED:] Help with formula please
  196. consolidate with two criteria uisng VBA
  197. [SOLVED:] Compare two lists First Name Last Name - If both match add Email Address
  198. VBA to filterthen copy cells from sheet1 then paste vlaue to sheet2 destinated cells
  199. change event
  200. Update master workbook if does not match multiple columns
  201. EXCEL: Data Validation With Case Sensetive.
  202. [SOLVED:] Access to info in Status Bar when in autofiltermode
  203. Referencing a column in AVERAGEIFS function in excel
  204. [SOLVED:] Type Mismatch Error 13 in Using Range and Offset
  205. Need VBA code to display 1st PRIME number greater than value (N)
  206. VBA worksheet change event
  207. Automate capturing a particular columns using VBA
  208. Error handling not working
  209. [SOLVED:] vlookup help needed
  210. [SOLVED:] Excel is forcing numbers on me!
  211. IF and OR .... Can't seem to work it out.
  212. [SOLVED:] Data Entry UserForm for Excel 2007
  213. place 0 before numbers in a string
  214. highlight entire rows when two cells in row are populated
  215. [SOLVED:] Finding matches coloring them and the color of the sheets
  216. Convert Word document in HTML via Excel
  217. populate word doc
  218. Reorganizing data
  219. Macro to pull calendar appointments from outlook into excel
  220. [SOLVED:] Repeat Procedure
  221. Specifying filter according to date
  222. Blank cell not really empty when copy and paste from different projectsheets
  223. Is this possible in VBA ????? ( rexx interpret command)
  224. [SOLVED:] Copy down values with VBA
  225. [SLEEPER:] Find columns based on header names and make the column proper
  226. [SOLVED:] vba to check if folder exists in SharePoint and if not then create folder
  227. Vlookup Error
  228. [SOLVED:] Vba Cut Paste By Criteria
  229. [SOLVED:] Find "PR" in column O then color cell and msgbox
  230. Open a txt file
  231. [SLEEPER:] Wildcards with Index Match Match
  232. VBA vlookup value not formula
  233. [SOLVED:] Microsoft Delpoyment Summary legit?
  234. [SOLVED:] Iterate Directory's Opening Workbook
  235. Creating a Macro to sort data
  236. Create Combined Table from 2 Tables
  237. [SOLVED:] Using Items sequence numbers in order
  238. match multiline textbox item to coumn B3 in excel
  239. Write a total number of hours each month into appropriate cell
  240. On Error Issues
  241. Run-time error '429': ActiveX component can't create object
  242. [SOLVED:] Is Variable Allocated
  243. [SOLVED:] Macro needs to recognize existing filename
  244. Looping through and Deleting data in Pivot chart
  245. [SOLVED:] Extracting values from cell where total has been rounded
  246. [SOLVED:] Code Not Iterating Each Worksheet
  247. Sheet Reference error
  248. [SOLVED:] Tab Button Control
  249. [SOLVED:] Formula
  250. Writing a loop with an offset and storing value in code while summing