View Full Version : excel answers


  1. How to make comparison chart to display two varying sets of data.
  2. Excel - how to make conditional formatting permanent?
  3. Conditional formatting and Date Difference in VBA
  4. Error 1004 on second line trying to set value or formatting of cell or range
  5. Finding Exact Difference between Three Numbers
  6. Crystal Reports & Excel VBA
  7. How to create macro to copy worksheet and paste values only
  8. How do I link commandbuttons to combobox selection?
  9. How to create a Macro that runs on a selection of cells
  10. Create a clickable button in Excel that opens a blank email in outlook but attaches t
  11. Copy past on multiple criteria like dates and center
  12. Excel Macro Runs Great But Have to Close Multiple Sheets
  13. Many data in excel document
  14. Desktop organization
  15. Excel 2016 3D Maps Timelines and Time Series
  16. Use a string to represent a range object
  17. How to get data back from excel sheet?
  18. Excel vba problem help!!!
  19. I was only sorting Excel data
  20. controling graphs and Charts
  21. Textbox problem with khmer unicode
  22. Exel file after restoration.
  23. using macros to open a file whose path can be varied
  24. External platforms suitable for hosting Pivot Charts with slicers
  25. Expand and Collapse Rows
  26. How do I filter data using one of two different fields?
  27. How do I compare two worksheets, and get the results in other worksheets?
  28. Excel cannot open .xlsx format file
  29. Error handling on hyperlinks to folders (VBA)
  30. Change Language (for all of office products, including word)
  31. Merge multiple workbooks into one
  32. Excel VBA VLookup assitance
  33. Excel Array issues
  34. Error loading query data to excel spreadsheet-[datasource.Error}ODBC:Error{42S22][ibm
  35. Sorting Problem (maybe)
  36. unexpected error while runing data analysis on excel 2013
  37. Convert string to Control in VBA
  38. Excel List VBA Question
  39. Fetch size of the file in excel sheet
  40. Database.xls' is in a different format
  41. Creating a macro to save files based on text in cells
  42. Delete cells based on conditional formatting color
  43. VBA AutoFilter with variable in Criteria
  44. AES Encryption Algorithm for VBA EXCEL
  45. Sorting Traditional Chinese Characters differs from 2003 and 2013
  46. Analysing data from multiple row records
  47. Help looping thru multiple workbooks to merge data into Masterr worksheet
  48. How to fix Run-time Error 52 for Microsoft Excel 2003?
  49. Open Spreadsheet as modal Datasheet form in Excel, is it possible ?
  50. Need help activating a newly downloaded CSV
  51. doubt on calculating difference vba/excel
  52. I need help on If, Mactch and Index function returning error
  53. Linking tables to make Pivot Table Excel 2010
  54. How to set 3 attempts in VBA Excel
  55. Plotting 3 variables on 1 graph
  56. Excel VBA Code Help needed please - Still learning
  57. Excel file error?
  58. Find a single zero, special charcters and return row number
  59. Highlight cell if
  60. VBA: Loop hangs up after one pass
  61. Using If Function in VBA for different conditions and Different criteria
  62. Append 0 character in cell value along with cell values in Excel
  63. Find out the TOTAL number of “Principal” and “Vice Principal” working in ONE particul
  64. #Ref! error - how to solve
  65. Cannot open the file in excel
  66. Strange Date Format
  67. Excel Row copy through VBA
  68. Need VBA to click link on website and open new form without logging out
  69. every time I run the programme below, I get Compile Error 'End if without blockif'
  70. Remove any number of spaces before and after slash
  71. Use Enter key to navigate in special way
  72. Diasble Ctrl + Alt + Delete
  73. EXCEL Q: How to Color Shapes Based off Date Ranges in Various Cells?
  74. Corrupt Excel File
  75. Vlookup with criteria
  76. Copy specific rows to other sheet
  77. Method 'Range of object '_Global' failed
  78. Disable editing from a microsoft query
  79. Making Railway Time table in excel using combo boxes & Text Boxes
  80. How do I get imported data to refresh each time the Excel file opens?
  81. error with "ElseIf"
  82. Pivot data from consistent tables across several sheets (tabs)
  83. Object Error
  84. MACRO<> Pick a number from excel and go to web page copy text nad paste it into excel
  85. How do I change the font size of an option button form control?
  86. VBA in Excel
  87. Referencing Tabs in Excel without Manually Input
  88. A sheet I have been using will not open.
  89. Date filter for all periods
  90. Total Hours Productivity within 8 hours a day
  91. help with this visual basic code from my excel file
  92. Probability and distribution Problem?
  93. How to Create a Multi-Select Listbox in Excel Worksheet
  94. Running total to sum text boxes in a form
  95. What does this: '! mean in Excel
  96. Inventor - barcode formula help
  97. Error Message on Connection Failure
  98. Create graphs, loop through columns
  99. Autofill based on text box input
  100. Find Text And Replace Entire Line in Notepad with New Text
  101. I don't know why I get a type mismatch( cmbcountry.AddItem rs.Fields(0) )
  102. failure move-function: low respons
  103. Populate spreadsheet with month, day and 24 hr time in half hour increments
  104. Dates entered as dd/mm/yyyy in VBA UserForm are stored incorrectly
  105. How can i pull data from web into excel cell?
  106. resolving wasp labeler system error 3061 too few parameters
  107. #NAME? error
  108. how to block the cells that is uneditable
  109. Calling a SQL Server Stored Proc that contains a CREATE TABLE
  110. please help me excel vba for gtalk
  111. Converting yyyy-mm-dd to yyyy-mm
  112. To Do list help - to add two more columns to the current code
  113. How to inactivate an Excel built-in function
  114. how to create a database by just clicking a command button
  115. Using a counter within a name in VBA
  116. How to export the file uploaded on Sharepoint site using Excel VBA
  117. Moving values from one excel to another search based on string
  118. How to Hide powepoint file using VBA
  119. Errors while creating Charts in Excel VBA 2010
  120. Excel 2010 Macro not working on Windows 7 but same works perfectly on XP
  121. Runtime error 1004 Document Not Saved
  122. How to open excel in read only mode?
  123. I need help with setting up a lookup table, or another way to do this
  124. Plotting Data According to Time
  125. Assign text to slides
  126. Whats wrong with my code? Keep getting arguments not optional error
  127. Using COUNTIFS for counting multiple criteria
  128. VBA code randomly stopping
  129. Finding last row with data working for column A, but not B or C
  130. "Object Required" error during Excel Solver Loop
  131. Difference between millitary date/time in standard time
  132. Create button to copy values over worksheets
  133. How do you add 2 numbers together in VB from a worksheet?
  134. Macro for PivotTable Field List Options
  135. Varied Job Schedule, Excel
  136. VBA to Replace "-" to "_" in excel sheet name
  137. How to use excel VBA to SQL query and compare data?
  138. After changing to a new worksheet, vba excel breaks down
  139. I need a macro to delete rows in various worksheets
  140. save an excel file (with multiple linked sheets ) as values only
  141. What does ### mean in Excel?
  142. Excel Macros