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

  1. Solved: Copying a file when the source file is open.
  2. function variables show on sheet
  3. Multiple criteria, one value
  4. Object Required
  5. Indicating calendar
  6. Solved: Sort and search on a table
  7. Excel Template mode
  8. how to combine GetItems() - syntax
  9. retrieve data from web
  10. Solved: Combine Few Sheets to one summary sheet
  11. Worksheet Calculate Question
  12. Delete freeform from spreadsheet
  13. problem with if, then, else
  14. Simple input and data problem
  15. Module to Delete rows by multiple column criteria
  16. Batch File Renamer
  17. Skipping Cells on a Loop
  18. View Calendar
  19. Solved: Get selected Date
  20. Solved: Delete freeform positioned over chartobject
  21. Solved: Msgbox if Something is Entered Different from Values in Combobox
  22. Passing user defined range into function?
  23. Solved: blink cell
  24. Solved: Lookup and use left characters
  25. Better way to copy text files to a daily report?
  26. Workbook being deleted
  27. User Form Question
  28. Moving sheets in a workbook
  29. Check for Empty Controls in Userform
  30. Solved: Replace function
  31. Excel Date formatting problem
  32. cdate type mismatch
  33. Solved: is there a limit on expressions in IF Conditions in Excel VBA
  34. Solved: perfect weight
  35. AutoFit Columns
  36. Clean and Proper difficulties
  37. help to decrease processiong time vba
  38. Solved: Multiple output function
  39. Solved: changing textboxes' properties programmatically in a userform
  40. Class problems
  41. Modify sheet2
  42. Solved: Multiple force entry
  43. VBA code to convert Excel file(including hiddenfiles)
  44. Last visible row or column in a worksheet
  45. vba
  46. how to copy data (some of them) and copy in an other sheet)
  47. Solved: Convert to function
  48. Solved: Display currency value in red
  49. Solved: Filter problem
  50. Solved: read text file question
  51. Graphing help in excel vb
  52. populate cbo box
  53. combine cells with VBA
  54. fill cells with vba
  55. Make dictionary
  56. Synchornize Excel sheets
  57. Solved: Process Summary Report from Array of Data
  58. Solved: Help on environ validation before opening file
  59. Solved: Excel Crashing Problems HELP
  60. Break for next loop
  61. Problems making VBA code to create start, pause & resume command
  62. Formula problem
  63. Formula problem
  64. Insert rows using a macro button.
  65. Solved: Cells highlighted during selection.
  66. Long hyperlink bypass
  67. Searching and autofiltering the result on the same worksheet.
  68. highlight all text in textbox - only fix
  69. Solved: hlep to create a back up workbook vba
  70. VBA code to create list of conditional formatted ranges
  71. Finding multiple words up to 10 different columns
  72. Blank Userform?
  73. Solved: Paste Range Of Cell Values From Formulas ??
  74. Solved: Autofilter and Copy Data to new workbook
  75. Solved: Count words equal between 2 cells
  76. Open email template files based upon combo box values
  77. Conditional formating based on Value = Range
  78. Solved: A variable within a variable (within a variable?)
  79. How use same code in other excel workbooks
  80. Solved: Dynamic Custom Header/Footer
  81. Code to loop through cells and find component of Formula
  82. Formula R1C1
  83. Name a Range
  84. Excel only runs my sub procedure once?
  85. Solved: Delete all the tabsheets with their names
  86. Solved: Sum or Sumproduct help
  87. Copy and Paste Macro
  88. Solved: Table of Contents
  89. How to randomise looping of variables
  90. Activating a column based in the other column value
  91. Unhide specifc row based on cell
  92. Redundancy search and paste
  93. WinHttp.WinHttpRequest question
  94. Copy and rename named cells in a sheet to another sheet
  95. Time limit
  96. Excel 2000 textbox help
  97. Search for a string and then sort by that column
  98. VB Macro?
  99. Need Help
  100. Solved: Change overall chart font
  101. Compare values of two range of cells and copy entire row
  102. Solved: Update dynamically created controls?
  103. Deny Access to the VBE?
  104. Solved: Need help to save file at User selected folder
  105. Using Excel macros outside of Excel
  106. VBA Delete Entire Rows Based On The Value Of Single Cell
  107. Delete rows in spreadsheet that are not needed
  108. List codes with the same conditions
  109. help to check several conditions on sheet
  110. Editing Data from web recorded Macro
  111. VBA Run-Time Error only on program close
  112. Solved: Problem with listbox and date
  113. Solved: Recognize mutiples and add rows
  114. Solved: Date format
  115. Speed up macro by doing calculations in memory
  116. Assigning values to ComboBox items?
  117. Filter data and copy to another worksheet
  118. Solved: VBA to copy general spreadsheets from one workbook to another
  119. HTML table into Excel
  120. Solved: script to highlight autofilter header
  121. Time limit
  122. Reaching into word from excel
  123. Solved: Shared Workbook: Check for another file
  124. Solved: creating custom toolbar
  125. Viewing The Same Workbook on Two Computers
  126. Call Sub 'GoTo' Point?
  127. index if VBA
  128. move sheets without links
  129. Solved: copy rows on criteria
  130. copying worksheets to workbooks
  131. Automate Getting to MS Query Wizard
  132. Excel keeps calculating - Table:1, 2...
  133. VBA Find question
  134. Suffle array and
  135. code modification needed
  136. Solved: I Need to Restrict The number of worksheets in Excel
  137. Solved: Advanced consolidation help!!
  138. Solved: Paste on exact conditions
  139. Combining Multiple Workbooks and creating separate workbooks with multiple tabs
  140. BeforeDoubleClick compatibility Excel 2010
  141. Solved: lookup date
  142. Do until you no longer firnd "#"
  143. VBA error
  144. Solved: Why this code not works?
  145. UDF with text as input without quotations?
  146. Solved: Save Options
  147. Solved: Copy/Paste
  148. Print Sheets In Time Order
  149. Activate other file
  150. the macro will stop automatically when the time it spent exceeds 3 minutes
  151. Another - Combining Multiple Workbooks Into One Workbook w/ Mutiple Tabs
  152. Solved: Help on deleting previous pict before placing new one vba
  153. split cell value ( Name & Number separately)
  154. Inverse Percentage
  155. Problems in a simple billing tool!
  156. change columns title name
  157. Creating multiple workbooks based on naming scheme
  158. Need Help coding a Dropdown List in a Cell
  159. Query information from certain records
  160. Multipage Active Tab
  161. User defined function does not maintain input ranges from proper worksheet
  162. Solved: Determine if file is run remotely?
  163. Excel 2007 Vba Question
  164. Cell text as pivottable filter
  165. Convert 5-sec period data into 5-min period data
  166. Solved: Remove Data from Pivot Table
  167. Simple VBA operation
  168. Solved: Creating new worksheets with same cell size
  169. SOAP Calls In Excel 2007/2010
  170. Solved: VBA To Unwrap Text In All Cells
  171. Solved: Wrap text in a VBA text box
  172. Locking Code to a Specific Machine
  173. Date format
  174. Solved: IP address
  175. Solved: Shift cells right?
  176. Solved: vba to filter report based on date/month
  177. Copy Spreadsheets with a specific name to another workbook
  178. Autosum unfixed range above
  179. locked cells
  180. Auto-filter and select row
  181. Trying to consolidate spreadsheets
  182. Macro for WS/WB comparisons, and copy/paste two cells based on matches
  183. Solved: To insert formula in specific cell with VBA
  184. Solved: Macro: copying across several worksheets
  185. add rows
  186. no blinking when running and progress bar
  187. Solved: Copying a sheet from a different workbook
  188. Code function
  189. Solved: Open CSV website?
  190. Import historical stock quotes
  191. Searching contents of a Visual Foxpro Database from Excel
  192. World clock excel
  193. VBA Loop using solver
  194. Solved: Import column c !
  195. Remove duplicate rows and retain the first duplicate row
  196. Creating a master Data sheet pulling information from each sheet in book
  197. Send Outlook Email from Excel
  198. Looking up data in a price file
  199. Question on creating a shared spreadsheet with user login and password
  200. Picture input via VBA in Excel 2007
  201. Passing values to a Font object
  202. Solved: Help Writing VBA code
  203. Solved: Need to get Part# from string
  204. Solved: Use data in closed workbook
  205. Solved: Excel Formula to determine calls
  206. Solved: Call the sheets double click event in another workbook
  207. VBA Code to perform inner join on 2 worksheets.
  208. Solved: overflow and failed vlookup
  209. How to create a Dynamic List on a Separate Worksheet
  210. Solved: Get rid of single rows
  211. Solved: Only run this command if Excel version is above 2003
  212. data of pending transactions
  213. Unable to read formula cells value
  214. Compare Monthly, Quarterly, YTD, Prior Year, etc Financial Statements
  215. Cannot paste anything in module
  216. [help]Change from Unicode to word
  217. Hide two rows at a time!!!
  218. copy-paste data from multiple files ( .xls ) from multiple folders
  219. Newbie charting help
  220. Solved: sum specific data
  221. Solved: dont save a window
  222. Comparing the string in excel vba
  223. Question with Forms in VBA
  224. Data input into Internet Form with Frames
  225. File Organizer
  226. Solved: Basic TOC
  227. Solved: Combining VBA Code to an array
  228. Search workbook as you type
  229. Need a Macro to do Daily task
  230. Loop Help
  231. Solved: VLOOKUP REFRESH
  232. Solved: Changing date from day to Month
  233. Create Excel Object 2003 or 2007
  234. Solved: Prevent Workbook from closing
  235. VBA / Macro -- Retreiving Unique Records
  236. Solved: Recognizing quarters
  237. Solved: FileSearch
  238. Time and #div/0 error.
  239. Solved: How to make Userform input data into a specific (hidden) sheet?
  240. How to stop opening a dialogue box?
  241. How to write VBA code to Link to another workbook.
  242. formula in the end of the page
  243. Solved: ActiveWorkbook.SaveAs xlsm help!
  244. set print area if needed over multiple pages
  245. Solved: Listbox Loop in Query update
  246. Addin auto run
  247. execute macro in another workbook, only works when interactive
  248. Best (and smart) way to do ListBox Filter
  249. VBA code for pivot-filter
  250. Cell format verification