PDA

View Full Version : Microsoft Excel


Pages : [1] 2 3 4 5 6 7 8 9 10

  1. Copying and pasting discontinuous cells
  2. Select active cell
  3. Wordsearch function
  4. Run a Macro when a cell is selected
  5. checking whether a value is within a range
  6. Vlookup and if
  7. Find Next Empty Row
  8. Calculation Issues
  9. Formula to return the decimal of a Value
  10. Format number as text on multiple files import to a Single Workbook
  11. rearrange columns in all the sheets based on column header
  12. Data Type Mismatch in Excel ODBC
  13. Child, Mother, Father
  14. String Function in Excel ODBC
  15. Data between dates
  16. Parsing text strings to words
  17. Charts Issue With 2 X Axis
  18. Refresh pivot on start-up
  19. Get Min & Max date from Pivot table field
  20. Compare values and move data to new sheet.
  21. CONCATENATE - limits?
  22. Set "Save As" file path
  23. Clear contents of cell if clicked, then repopulate if nothing is entered
  24. modify cell contets
  25. Generic DISTINCT question, but I'm querying XLS
  26. VBA form - search and export row
  27. Data/String into an Excel Cell using VB
  28. Check for a value in a cell - find match in sheet2
  29. If Function with Time Format
  30. If formula (Scratching my brain)
  31. Column counts w/Look up cells & #N/A
  32. Counting instances of specific value
  33. Creating individual logins for mulitple worksheets (VBA),
  34. Marco to hide blank rows
  35. Check boxes
  36. Find Duplicate; Copy; Paste
  37. is it possible to access/write database ms access 2003 .mdb at the same time?
  38. Excel links to TimeSlips (Paradox) and QuickBooks?
  39. VLookup to find data from filtered rows
  40. personal function
  41. Linking Access DB to Excel via MSQuery (VBA Question),
  42. Help on PivotTable..
  43. Subtract Datetime
  44. How to get current path then do the linking
  45. multiple rows of text from notepad
  46. SUM column totals when there's #N/A
  47. Forcing column datatypes, but allowing user entry
  48. Can't see message bar with security warning
  49. Replacing the False in vLookup with a Dash
  50. Macro to identify & consolidate same value cells
  51. Workday function to find specific date ?
  52. Minimising the Ribbon
  53. Using vba for custom formulas
  54. Excel SendKeys CTRL+TAB
  55. Insert file path in footer
  56. Code exection & Worksheet functions - synchronous or asynchronous ?
  57. Assigning Range - Relative reference Vs Worksheet reference
  58. Iterate Code Modules
  59. Egregious hyperlink behaviour
  60. Multi Page control
  61. Sendkeys
  62. Find records
  63. Help with Pivot Table - Source data & Calculated items
  64. Lookup array of values
  65. Reference Label on Worksheet
  66. excel game
  67. Excel VBA Function...Can someone explain this function to me?
  68. Convert Excel2007 database to Works 9.2 database?
  69. =SUMPRODUCT((Data1!$B$1:$B$500="March")*(Data1!$C$ 1:$C$500="New York"),(Data1!$E$1:$E
  70. conflict between auto save&close macro and show/hide sheets macro
  71. Excel error help
  72. number to string
  73. Tweeks to improve macro
  74. Please Help!!!!
  75. Basic excel query!
  76. MS Excell - Nested If issue -Amateur
  77. Horizontal axis stuck to 0 line
  78. Horizontal Match
  79. Opening an Excel file from network
  80. Query help
  81. Stop a Macro Running twice
  82. using offset?
  83. Long string in Excel cutting off in mail merge
  84. Data Validation Problem
  85. Print preivew from page # doesnt work
  86. Call up excell workbook from with DB through on Click
  87. pass values from excel worksheet to VBA array
  88. SUMIF function returns no result
  89. Tab Color If Statement
  90. how to insert null record in excel sheet
  91. CSV over 200,00 rows but Excel 2007 not importing
  92. Help with monstrous formula from H*ll
  93. UBound: Type mismatch in VBA function
  94. sorting data in more than 3 columns
  95. Restrict / Provide access to users to a macro through a sql database list.
  96. Userform in Excel with Remember Password and User id option or check button
  97. Bloomberg Copy Screen/Excel VBA Problem
  98. Create ageing periods (eg 0-30, 60-90 etc) Excel 2003
  99. if formula to check if the number is in a certain range
  100. Querying MS Access data from Excel
  101. Rowsource for userform in Excel add-in not working
  102. Income Oppertunities from Home
  103. Function to get the current path/directory
  104. returning a cell's address from the results of a VLOOKUP
  105. Formulas not updating for no apparent reason
  106. Selecting Subgroup based on specific Group
  107. Parse Name from one sheet to another
  108. CUMULATIVE COUNTIF...sorta
  109. userform cascading combo box
  110. macro to select row
  111. Getting dd/mm/yyyy mask to apply to an InputBox
  112. Date format problems in excel
  113. Adding numerical values of letters
  114. Problem with Move Selection After Enter
  115. Excel - Importing External Data
  116. DOS Command/Batch File: Syntax to call variables
  117. Prevent leaving Excel window while code runs
  118. referencing multiple worksheets
  119. Taking data from three workbooks combining into one workbook.
  120. Referencing External Workbooks
  121. Line Weight
  122. Filter a multi demensional array?
  123. VBA help on .AutoFilter results
  124. Open form to specific record, create new record if it does not exist
  125. Read Range values to array
  126. Excel Date conversion
  127. How can I stop this template from locking up
  128. Webbrowser Help
  129. help with Connection string for Progress 9.1D
  130. If statement to delete rows ending at last row
  131. Several macro files running at the same time - will it cause conflict?
  132. Get an instance of a sheet from codename string?
  133. Autofill Problem
  134. Set order of sheets in a work book
  135. Grouping and unGrouping colums
  136. create array from range of cells
  137. Count Multiple Columns
  138. Formula When Exported From Access Doesn't Work
  139. Need To Create Row Reference Not Knowing The Row
  140. Outer Join and Inner Join with 3 tables in MSQuery (Excel 2003) linking to Sage 50
  141. Printing with Named range faster than Address?
  142. Cycle cells in Given Range
  143. Excel Drop Down List
  144. How do you create a % format type?
  145. Excel 2007 Add-in to save DBF
  146. help in temp tables
  147. copy & paste
  148. VLOOKUP Problem
  149. determine if a sheet name exists
  150. Exporting data to Access using VB
  151. donīt manage to send an image backward ......
  152. Using a Userform to obtain value for use in macro
  153. Link a table to another table?
  154. MS Query using "contains" and "prompt"
  155. Convert number into text
  156. JOIN 2 WS into one
  157. Deleting Multiple Data
  158. Filter a multi demensional array?
  159. Month display on pivot, plus variance column
  160. Resizing an array
  161. Error 438
  162. Data validation depended on IF statement
  163. managing a payroll
  164. Any ppl can help on Database with user form
  165. Filter an collection of objects?
  166. Stop all code from executing
  167. Edit Record In Access from Excel Using VBA
  168. Trouble displaying access table in excel macro
  169. Comparing multiple values and counting if criteria meets
  170. loop control issue
  171. Excel IF and vlookup formulae
  172. Using error handling in excel
  173. Nonprinting characters
  174. INSERT INTO statement having local variable and SELECT statement as parameters in VBA
  175. All the code
  176. returning a variant matrix Subscript out of range (Error 9)
  177. using a matrix
  178. What to use for a string enum? Read only class?
  179. my 1st class what am i doing wrong?
  180. ISNULL? isnull(myArray(1,0),myArray(1,1)
  181. declaring a multidemensional array
  182. color fill
  183. GetSaveAsFileName Question
  184. Grab only numbers out of a text string (MS Access)
  185. Date/Time field export issue
  186. VLOOKUP Formula to return 0 instead of #N/A
  187. Macros
  188. Copy worksheets from multiple workbooks into specific tab in master
  189. Referencing an empty cell in another worksheet elicits "0"
  190. Struggling with use of global Boolean
  191. extact files from oracle into excel
  192. summary of dates
  193. summary of dates
  194. Plotting a graph using HH:MM:SS values
  195. Creating a user adjustable countdown timer
  196. email only a range in excel in lotus notes
  197. question on script
  198. Publish Excel Page to the Web ? ?
  199. multiple math functions
  200. Last cell with entry
  201. Copy, Find, Paste Macro - Urgent
  202. Forumula showing not results
  203. I want 1st page of my printout to have pg 3 not 1 and incr from there
  204. Simple macro loop problem...
  205. Detecting Click Event of Dynamically created controls
  206. Passing arrays to functions?
  207. Grouping Dates in a report
  208. Excel Trouble in displaying large data
  209. #DIV/0! Problem With Formula
  210. Help with FIND function
  211. HELP..Select Entire Row and Use FIND function
  212. Excel VBA macro - how to close the excel application
  213. appending data in workbook
  214. saving conditional formatting
  215. Macro to consolidate records from several excel files into 1 excel file
  216. DOS command script to copy records from multiple excel files into 1 excel file.
  217. Object Error
  218. Not sure if Excel is best solution for my problem
  219. Displaying Unknown symbols in Excel (Square symbols)
  220. Event when i change active sheet
  221. macro help required fairly urgently please :)
  222. String manipulation using VBA
  223. Using MATCH()?
  224. Excel.EXE crashes
  225. change labels to formulas
  226. Macro to Import and format Data from ACCESS
  227. Digital signature in a protected sheet
  228. How To Analyze These Tables?
  229. Find, Select, Copy And Paste Macro - Urgent
  230. nested if's?
  231. yearly plan
  232. excel shortcuts keys
  233. "Application-defined or object-defined error" in Excel 2003
  234. Opening a database of a program
  235. Help: how to lock cells after fulfilling a condition data
  236. Taking Parameters from Excel to MS Query
  237. Issues moving Excel VBA from VISTA to XP
  238. To create a new dialog box
  239. What is the code to prompt user before action is taken
  240. What is the code to prompt user before action is taken
  241. *.txt to excel
  242. Convert MSSQL TSQL to a Formula
  243. Need to Populate Cells in a Row based on a Date Range
  244. Need to add 1 value to specific formula in many cells at the same time
  245. comparing values for 2 rows
  246. Make copy of xml not possible
  247. Comparing times
  248. Problem with macro code in excel
  249. database in excel
  250. Slow saving/then double files w/ diff names