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