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

  1. macro search
  2. Lookup value in Table
  3. Extract data from MS Access table using excel macro.
  4. Rand() in excel 2000
  5. How can I put multiple codes in 1 sheet?
  6. Picking only records based on po #.
  7. Time capture activity require.
  8. Solved: How to Delete Data on the other sheet using VBA?
  9. OLE created workbook vs User Created
  10. Solved: stops all other macros except this one
  11. Solved: Test if Folder Exists
  12. Check box question
  13. Solved: Selecting Row with variable
  14. 'merge' sheet and adding new sheets; shname()
  15. how to Delete Data Row with use of VBA code
  16. Solved: Protect and unprotect worksheet change
  17. initial value for listview from excel
  18. Automatically Update/Populate Listbox based on selections of other listbox
  19. Solved: Enter a cummulative value into a cell
  20. Copy and Paste in Filter
  21. Copying rows in range based on criteria
  22. emailing cell range
  23. How to only keep duplicate values
  24. Save to new workbook and delete a specific sheet
  25. Solved: find the letter for the last colomn
  26. Solved: VLookup in VBA
  27. Solved: ISERROR VBA CODE
  28. Solved: Formulas are not being copied correctly
  29. Solved: How to delete columns that go through an area with merged cells
  30. Solved: Multipage/Treeview Expansion problem
  31. Solved: Working with a Filtered Dataset
  32. External Formula
  33. Solved: put a range into a variable
  34. Min,Max,First and Last Values within Time window
  35. hiding formulae in excel 2007
  36. Solved: Changing Arrays
  37. Solved: populate multicolumns of listview
  38. VBA - Dodgy IF statement results from certain numbers
  39. How To Write Find Function Using Macro
  40. Solved: Insert Rows, AutoFilter, xlCellTypeVisible
  41. working with ranges of merged cells
  42. Copy/Paste if cell contains "123" characters
  43. SaveAs and Fileformat
  44. A faster/more efficient way?
  45. Solved: Run Macro on Cell Change
  46. Scanning data series and plotting based on data
  47. Solved: Combining 1 Cell from sheets into List
  48. Delete Rows when Condition is met
  49. remote update of code
  50. Solved: Clear Contents on Workbook Close
  51. Solved: Does VBA need a pause inserted
  52. Adjusting macro to loop through criteria
  53. What are CUBES when used in Excel
  54. Solved: How to show a Calendar in Combo cube dropdown on a excel Userform.
  55. highlight specific cells in active row/column
  56. Using a case statement
  57. public object module error
  58. Solved: Questions regarding Excel vs VBA
  59. How to define workbook is open in which process
  60. How can i plot a Graph on Microsoft Excel?
  61. Solved: Need help exporting data based on listbox selection
  62. Save Excel using VBA
  63. Solved: Auto open macro help
  64. Solved: Add negatives?
  65. Solved: Similar case
  66. Solved: Listbox Related Question
  67. Solved: Combobox data to listbox or textbox?
  68. Data mapping from one excel workbook to another excel workbook
  69. Solved: Create backup to another location
  70. How to filter data with a multi-selection listbox
  71. Solved: IF Statement Limit Reached
  72. Solved: Delete zeros
  73. Filter not work with xl2007?
  74. How to colour an entire row, on row number click
  75. Solved: referencing specific worksheets in vba
  76. Number format of cell which contains formula
  77. Solved: macro to Delete entire row based on a criteria.
  78. Solved: macro to replace error formula cells in a column with some other text or number.
  79. Solved: A macro to saveas a worksheet as a new workbook
  80. Solved: Accessing specific sheet by password box
  81. cells contain hidden values
  82. Excel Status bar will not update
  83. how to open a existing worksheet from certain folder and creating new workbook
  84. sort columns via listview
  85. Solved: lookup function in VBA
  86. VBA script in excel! help
  87. Solved: If Esle..If VBA
  88. Solved: Unexpected error.
  89. Costing schedules
  90. Solved: Finding Last Visible Row
  91. New worksheet using template based on cell values
  92. At a loss for direction..
  93. Poll of numbers HELP!
  94. Computing 99% of COl M while cell is in filtered mode.
  95. Analysis of Amount based on following criterion.
  96. Solved: Changing Text in Buttons
  97. Copy Cell From Workbook and Paste to Another Workbook's Cell
  98. Solved: Referencing Another Sheet in Workbook
  99. Inserting a row or a column
  100. Next row down
  101. =OFFSET(EntrySht!$B$9,1,0,COUNTA(EntrySht!$B:$B)-1,1) working functionality require.
  102. Deleting the row that contain the text " Dismantle"
  103. line breaks & spaces
  104. Solved: Finding the Correct Value
  105. accessing gmail attachments
  106. Checking ref # status based on sheet2 ref #.
  107. Excel 2003 question ( using If )
  108. Solved: Where can I find a VBA guide?
  109. Excel 2003 VBA help
  110. How to copy different excel worksheets in one workbook?
  111. Solved: IF/ ELSEIF Help
  112. Solved: list data from 53 sheets
  113. Solved: 2 sheet search
  114. Solved: Sort Question
  115. Run Time Error 1004
  116. Solved: reference to a sheet
  117. Filter date from multiple Pivot tables
  118. Function or UDF
  119. Formula Help
  120. Best Place for Subs
  121. Solved: Excel AutoSum
  122. Solved: Auto Protection
  123. If filename is in sheet, return true/false?
  124. Finding the difference of two dates based on criterion.
  125. Automatically saved into the drop-down list and show edit comments
  126. Hiding column need to be unhide.
  127. Solved: Help on alpha numeric subraction...
  128. Speeding up a loop, that does an action when encounters a value
  129. Solved: Call Sub Help
  130. Groupwise attachment loop
  131. Problem with coding Sub
  132. Solved: Excel Formulas based on Lowest cost
  133. Solved: Update records without looping?
  134. Arrange columns of names & addresses into rows
  135. Need to test if Worksheet Name Exists
  136. Formula VBA Help
  137. Solved: Play .wav sound file when userform opened
  138. Solved: Error: 1004 - Application-defined...
  139. Solved: How will I modify a VBA code that will only calculate the last populated row?
  140. How to get currently logged on user's account name?
  141. Solved: .Copy Destination (Error)
  142. Problem with Date Filter between two dates
  143. Solved: How to troubleshoot error on my macro?
  144. data fram pdf
  145. Trim bug?
  146. Email macro stops after sending first email
  147. Solved: Extract data from text file
  148. Solved: How to open sheets as hidden
  149. Sorting and removing duplets
  150. executing T-sql stmts in Excel VBA
  151. Copy Records to Worksheets based on value
  152. display records by office
  153. Activate Excel Window
  154. Solved: Hiding Cells
  155. A rather nasty COUNTIFS statement issue
  156. Dynamically change size of Array
  157. Solved: Do a .Replace on an inactive sheet
  158. Need help with events in HTML Table - Excel 2007
  159. Solved: Write number as string
  160. display records by office
  161. Solved: combobox on the fly
  162. download file
  163. Help needed on variable workbook name.
  164. Solved: How to protect your VBA codes?
  165. Solved: How to change color of Form Control Button?
  166. Refining ListBoxes
  167. How do I do a best fitting line on Microsoft excel?
  168. Need help with MkDir form Cell
  169. Printing all worksheets in a workbook as a single file..
  170. Solved: Help needed with VBA for Alt+F11
  171. Solved: Drop Down Box -
  172. Solved: I want to add a textbox on the chart
  173. Excel Look up data in a access database
  174. VBA and cell references
  175. How to parse HTML file from VBA code into Excel ?
  176. Solved: Cell Reference
  177. Solved: Use of AddShape to add circle
  178. Object visibility?
  179. Resize Pictures
  180. Solved: Looping Goal Seek Function
  181. UserFrom ListBox FilterInPlace on inactive sheet
  182. Solved: Import External data into Excel
  183. Delete a worksheet without losing Formula reference
  184. Solved: looking for the correct sheet and fill in the value refer to date
  185. Problem saving as macro-enabled workbook
  186. Excel to open and run Access Macro
  187. Solved: Pivot Refresh Problem
  188. Delete rows if cell less than 4
  189. How to remove the blank space which is present at the end of the value in a cell
  190. Solved: how to stop duplicat data entry
  191. Solved: Password entry visible
  192. ByRef ByVal
  193. Multiple If statements with multiple date range
  194. Solved: If / Statement
  195. Select multiple rows based on selected column
  196. Solved: VBAProject (PERSONAL.XLS) Stays Open Forever?
  197. Solved: Keep common inputbox in background
  198. Solved: Can This be Simplified?
  199. Solved: Worksheet ListBox Selection
  200. Populating a Userform Textbox on userform open!
  201. Macro required for ALT+TAB keys
  202. Solved: Count weekly offs based on day of week
  203. loop to delete the row and replace the value in cell having problem
  204. Listbox selection and deselection triggers in userform
  205. Multiple selection from the cell.
  206. Solved: Unlocking several VBAProjects
  207. Delete the warning message.
  208. Solved: Division with remainder
  209. Use VBA to populate a VLOOKUP formula - then move that worksheet to another workbook.
  210. manual recalculation not for all sheets in wb
  211. Solved: UserForm List Box Problem
  212. excel multiple workbooks
  213. Case Statement
  214. Combining multiple excel workbooks in to a single sheet
  215. Solved: Protection Issue?
  216. Solved: Delete Row Skipping
  217. Hide "View" menu
  218. Comparing cells within a column
  219. Process bar
  220. Solved: Populating a listbox
  221. How to open workbook in another computer
  222. Solved: Input/Output text files fill in variables
  223. fill in the value accoding the date
  224. Solved: How to formulate sumifs based on weeknum?
  225. How to attached font when save Excel 2007 into Excel 2003 format
  226. Sending email from within Excel (.From) issue
  227. Data from Excel (macros) to Word using VBA
  228. Solved: Delete row
  229. Unable to get the SaveAs property of the Workbook class
  230. expand selection starting from dynamic range
  231. [SOLVED] Hiding rows in a function
  232. Solved: VBA Code - Adding value to Comments
  233. can i define the Public contant WB and Sheet name for use in form ,macro and sub?
  234. Solved: prevent worksheet deletion.
  235. Solved: loop through selected cell
  236. How to use AutoIt to Open Excel and Enabe Macro
  237. Solved: counting
  238. Solved: is there a paste special for this data?
  239. Solved: Changing d/m/yyyy format in workbook
  240. Solved: Word Constants
  241. Solved: auto-fill webpage search form
  242. Query regarding worksheet function (Count IF) using in Excel VBA
  243. VBA - Populating Arrays Inside of Structures
  244. Solved: Hide columns not appearing in Sheet 3
  245. VBA Project help and overflow error
  246. Solved: Transpose table of data
  247. Solved: Computer identification
  248. Solved: Exit behaviour for last field in a frame
  249. Solved: Search for Tab
  250. Solved: Missing Add-in