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

  1. Change Pivot Field function from xlCount to xlSum
  2. Solved: Copy.
  3. Creating the Game: Boggle
  4. Solved: Text and Value in 1 cell is it difficult?
  5. If cell = [Word], hilight row
  6. Animation in Excel
  7. Add formula to cell
  8. Application.close information required
  9. Solved: Running two macros on opening
  10. Hint about VBA functions
  11. How to dyamically change which pages will print
  12. Solved: Data Validation on User Form
  13. ComboBox Help!
  14. excel to autocad
  15. Loop through charts
  16. Resetting Color Pallette
  17. Seeking help in creating an excel macro for shutting down pc
  18. Find the cursor position in a string
  19. Coloring depending on the Series
  20. Excel Crash
  21. Solved: Checking if macro run again- same month
  22. How to access menu items of Excel add-in?
  23. Solved: Lookup question
  24. Solved: Adding pre-fixes
  25. Stop code from running when opening
  26. Inter related items
  27. Solved: Applying an Advanced Filter Using VBA
  28. Macros for excel
  29. Create a List based on Cell Values from multiple Sheets & Columns
  30. VBA Code to export formula to cells?
  31. Loop trough workbooks and Paste values
  32. Solved: Sort Not Working When Formatting Applied
  33. Sumif formula
  34. Solved: Displa first item in combo box
  35. Solved: Make Code run only on xls files
  36. Excel - transpose multiple records
  37. VBA Column Looping
  38. Solved: error when looping
  39. Autofilter on row 3
  40. Speeding Up Vlookups
  41. Solved: Option Explicit
  42. Help in sorting in data or macro or simple method.
  43. Write to Module Using VBA
  44. Extending chart series range
  45. Solved: SUMIFS
  46. copy down formula
  47. Merging Cells
  48. Dynamically Specifying Series and X/Y Values of a Chart
  49. Excel Custom Headers and Footer
  50. Converting formula into values.
  51. How to control which vba Excel program has control on computer
  52. Populating Oracle SQL Queries in different Sheets in Excel using VBA code
  53. Webbrowser control
  54. Solved: text box dependent on list box in userform
  55. Solved: ignore files which are blank?
  56. Excel File Properties in Windows Explorer
  57. Macro to countif multiple criteria
  58. Exporting Data into Different Cells at Set Intervals
  59. Solved: other possibilities?
  60. VBA: Identify Last Column with data in a specific Range and copy to next column
  61. unable to set the text property of the characters class
  62. Solved: FindNext
  63. Sending the Email by Excel by searching the Attachment names start with 302568
  64. Bring chart infront of web browser
  65. Import txt files into excel
  66. Solved: insert text in columns with itineration
  67. Solved: Run a macro with inputbox
  68. Solved: Determining size of chart area?
  69. camembert
  70. Trigger Macro by change in formula value within a cell
  71. Solved: label.caption take text from file
  72. Solved: Userform + Range=#value
  73. Staff ID Number format
  74. Solved: Macro processes too much, so Office apps hang until finished! Ideas?
  75. Spin Button
  76. How to Make Handwritten Code or Macros
  77. Solved: Week Number Of The Month
  78. Solved: UDF in Conditional Formating
  79. Interesting Issue With Labeling Data Points
  80. AfterUpdate Event
  81. Solved: Age calculation
  82. Solved: MkDir, multiple directories?
  83. Solved: Animation Control limitations
  84. Enable Macros when opening Worksheet
  85. Solved: Adding text to a cell with CheckBoxes
  86. Solved: Conditional Formatting
  87. Interacting the Search Dialogue Box
  88. Solved: Create on the fly labels with click events
  89. Solved: Comparing two columns of data and outputting the differences
  90. Solved: Arrays with Arrays
  91. Problems with interface design for when long macros process (suggestions welcome!)
  92. Adding to Named Range and Disappearing coloring
  93. Solved: Ending a loop at the bottom of column
  94. Solved: Calculating stock price volatility over and over and over...
  95. Solved: VB code to save file to app directory?
  96. Code to save to a sub folder?
  97. Picking respective value from different col based on a particular value input.
  98. Solved: Show Desktop
  99. Solved: Counting Text with commas
  100. Imported dates
  101. C&P format & formula if certain data entered
  102. Solved: Code to stop all subsequent code and return to userform
  103. Set max value in array item?
  104. How to paste in selected rows of the selected column
  105. Solved: Finding Bad Names
  106. Solved: Data input macro help needed
  107. Plugging time in excel sheet
  108. Report Based on following sample of data
  109. Solved: VeryHiding Sheets after given date
  110. Unhide Hidden Rows
  111. SUMIF IN VBA with external references
  112. VBA - answer "yes" or "no"
  113. Mapping Values
  114. [SOLVED] Circular reference in a formula
  115. How to create a UDF Function?
  116. Referring to an array in many subs
  117. excel formula in vba
  118. Solved: One variable defined as text, the other as integer Problem
  119. Solved: Nested IF function
  120. Restrict Worksheet Scrolling Help
  121. Solved: Question About Circular References
  122. Solved: How to calculate running totals
  123. Invalid references table and copy the valids to another table
  124. Solved: Managing the Case of First Letter
  125. Excel 2000 vs 2003; additional control; substitute
  126. Solved: Macro to sort data ascending
  127. Solved: Keep selected cell centred
  128. Solved: Inserting dynamic range into new table
  129. Solved: (location) inside of the combobox
  130. Solved: Debugging a VBA programm in Visual Basic Editor (VBA Excel )
  131. Solved: FILE DATE
  132. Solved: Finding Matching Date
  133. Solved: Sort Data Based on Value of a Cell
  134. Combining multiple worksheets WITHOUT the same arrangement.
  135. Solved: How modify VBA to split multiple cell?
  136. Solved: Calculating Hours Earned
  137. Create userForm by code
  138. Solved: Listing file/folder attributes from user input
  139. Solved: VLOOKUP in multiple arrays
  140. Autofilter, copy-paste to new sheet
  141. Solved: Problems with running pre-Excel 2007 macros
  142. Adding values
  143. Solved: Help With a Formula
  144. Display percent value
  145. Solved: QueryTable wont work in Excel 2007
  146. Solved: Move columns
  147. VBA Macro for Log File
  148. Solved: Calculating Hours Earned
  149. Solved: translate from Excel in VBA
  150. Instant messenger in EXCEL
  151. INDIRECT VLOOKUP formula problem
  152. mark duplicate row with condition
  153. Solved: Formula Problem
  154. Solved: DELETE LAST
  155. Solved: moltyply times
  156. Center userform using Printform
  157. Column to headings& heading contents to rows
  158. Solved: Populating a userform....
  159. Please Help with Checkbox Alternative
  160. Solved: Copy Sheets to new workbook and save copy
  161. display label as Year & text
  162. Solved: How to assign different face id to macros in a toolbar
  163. Solved: Misserable example....
  164. Solved: Convert time entered on row to ascending dates
  165. loop
  166. pivot table question
  167. Book Recommendation
  168. How to get Combobox2 value if a value is selected in combobox1 in the WorkSheet
  169. Solved: Make Selection on sheet1 that will duplicate on all worksheets
  170. A macro code to check whether any workbook is currently open or not.
  171. Copy Colours
  172. Solved: Date Delete
  173. How to alter Paste Range in VBA
  174. copy transpose
  175. A macro to authorize a user to run another macro.
  176. Extract GPS data from jpeg file properties with VBA?
  177. Solved: How to create a VBA program based on lookup formula
  178. Solved: the number in this cell is formatted as text
  179. Text Format need help
  180. Strange things happening
  181. How to copy only the headers and columns of requested
  182. Calculating 99% in entire cell in Col M. Col M is filtered
  183. Solved: Restrict Saving WorkBook
  184. delete
  185. Holiday and earned time minor problem
  186. windows services in Excel VBA
  187. Solved: Extract data from Website to Excel
  188. How to get this formula shorter
  189. open multiple workbooks and enable macros, then close
  190. Solved: Checkbox control(s)........looping
  191. Paste Especial/Value/Transpose . . .
  192. Take the size of the Array
  193. VBA Date Range Argument
  194. Solved: Need macro to remove text
  195. Solved: Copy Worksheets from one Workbook to Another
  196. VBA code needed for creating references in Excel
  197. Need a code to place Excel charts to Powerpoint (Different Sizes)
  198. create list of references
  199. Partial format of cell
  200. Identify the write mode of a workbook
  201. uneditable comboboxes
  202. Solved: trim function.
  203. Using a defined string in a vlookup
  204. Solved: Change Values
  205. Extract from worksheet into new workbook, for daily reporting.
  206. Solved: Outputting Listbox values AND filtering using those values
  207. Solved: DOUBLE LOOKUP HELP
  208. Splitting summary sheet based on workorder ColA.
  209. Solved: Save As dialog help.......please!
  210. complicated Match
  211. Solved: Populate ListBox with Multiple Rows of Data
  212. Solved: Excel Scatter Graph Horizontal Line
  213. Solved: How to design a code based on excel formula?
  214. Rearrangement of Code & Immediate Windows!
  215. Solved: Email file with password HELP please
  216. Solved: Looping named cells
  217. Solved: FileSearch VBA
  218. Solved: Search all worksheets
  219. Solved: Add another sheet to the search
  220. Arrange sheet data
  221. Lookup from external text file
  222. Multiconditional sort, match and list with exceptions
  223. Populate ComboBox with contents of ListBox
  224. Dynamicly Fill Listbox with column headers?
  225. Solved: Import of csv file fails in 2007 only
  226. Solved: Rearranging columns
  227. Solved: A simple formula would probably do the trick
  228. Copy Data From Orders to Database
  229. Solved: MsgBox - Error
  230. Skipping the Browse For Folder
  231. Solved: Clear cell not entire row
  232. Solved: Class module for two-dimensional array
  233. Solved: Filter worksheet using List Box (multi select) Selections
  234. Nice image import code
  235. Solved: Multiple Column Colour Change
  236. Searching folders
  237. Solved: Reverse find
  238. Solved: Lookup Values Across Tabs and Set Flag
  239. Copy and paste data based on criteria
  240. Solved: Range Copy to different worksheets
  241. Solved: What's wrong with my copy/paste VBA code
  242. Groupwise VBA to Change "From" field
  243. Email files with same names from folder
  244. Solved: Macro "Stautsbar" from ThisWorkbook i want for whole excel
  245. Solved: Date Problem In Chart
  246. Solved: How to stop nuisance warnings
  247. Terminate Excel Process
  248. Cell Format Number Issue
  249. Solved: dual purpose TextBox string
  250. Paste data in clipboard