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. Opening/getting data from different excel file
  2. Solved: Merge Excel file through validation
  3. Consolidate data
  4. Solved: Scale graph absolutely
  5. Solved: Transpose column A to rows
  6. Solved: Adding worksheet to blank workbook
  7. Macro to search active cell value and look for it in word docs saved in a folder
  8. Solved: Using vlookup if the lookup value is not in the first column
  9. Prevent Calculation Running While Saving
  10. Call MS Access function in module via Excel
  11. Changing the font in the fluent ribbon
  12. File download without knowing the full url / redirect
  13. Solved: sum only certain columns
  14. Last Updated Alert
  15. Solved: Making a Range non-editable
  16. Disabling of cutcopypaste for a few cells in a worksheet
  17. Solved: Finding Min & Max values by week, month and year
  18. Automatically insert rows at varied intervals
  19. Add different password(S) to worksheet(s) from workbook
  20. Solved: Saving File - Automated File Naming
  21. Solved: Date Formatting help
  22. Amend VBA Code to include extra worksheet(s)
  23. Solved: Count cells with 3 requirements
  24. Solved: Counting number of times a code has been executed
  25. Import mutiple files from a folder to excel files
  26. Solved: Hi-Lite a cell based on value in another cell
  27. Copy formula down the column
  28. Solved: Excel to Outlook - late binding?
  29. Solved: Data Export
  30. Solved: countif with multiple criteria
  31. Solved: Min of 4 Nos,returning >0 values
  32. Automatically Generate Reports from Excel Template
  33. Solved: If statement - Cell starts with Number
  34. Solved: hyperlink question
  35. Solved: Formatting cells with times
  36. Solved: How to get AVERAGE of range into a cell
  37. Solved: How to export an excel chart as a jpeg
  38. Solved: Search for text as part of a cell
  39. How can I create an Object and send by email?
  40. Merge & compare excel formula
  41. VBA multiple ranges
  42. Solved: Values to Text
  43. Solved: Send button value as arguement to macro
  44. Search for repeated characters
  45. Passing Parameter to Excel for SQL Report
  46. need to automate date of last data entry
  47. Form Close help
  48. Solved: Pulling Data from several sheets to one - Macro
  49. Solved: Format cell when condition fulfilled
  50. Solved: conditional population of cell
  51. Clone Remover
  52. Solved: How do I identify the type of graphic object that is currently selected?
  53. Excel save file
  54. Solved: Read only password
  55. Multiple copies of Active Worksheet
  56. VBA Find from EXCEL replace to WORDS HELP !!!!
  57. How to call sub(which is personal.xls) in activeworksheet.
  58. convert to pdf to excel using vba
  59. Solved: copy and paste macro - simple, right?
  60. Selecting Column Until End of Another Array
  61. Can complete VBA code be exported to a different WKBK
  62. How do I preserve the user's Clipboard while he's accessing my form?
  63. Running Macro on Muliple Files
  64. Solved: Match help
  65. Limit data field in PIVOT TABLE
  66. How to detect a digital certificate
  67. VB copy & paste help .......pleased
  68. Copy Paste Values
  69. Solved: IF THEN COMMAND
  70. Using two Userforms.
  71. Solved: Help for FY problem
  72. Solved: Importing space delimited text files
  73. Solved: Sending Long to Clipboard or any other way to get it to Word from Excel?
  74. Solved: maximum function with #na value
  75. Solved: Ranking Data in List
  76. Solved: Check my code please to find next blank row
  77. SaveAs with embedded Word document - OLEObjects
  78. Solved: Conditional Format to a Linked Cell
  79. Using Excel to look at charts
  80. How to convert dates in my Sub
  81. Solved: Setting a Range as a Class Property
  82. Copy and paste count by last row
  83. Critical Thinking Challenge
  84. Solved: Test if rows are hidden
  85. Solved: How do you modules to calculate?
  86. My Excel Crashes on Close
  87. Solved: Outlook Email Blast from Excel
  88. Solved: Calculate "Current Month Average"
  89. Inserting Carriage returns in Message Boxes
  90. Solved: SUMPRODUCT across multiple sheets
  91. Solved: Set Value of Merged And Centered Cells
  92. Solved: Reference another Excel workbook without Activating it
  93. Solved: calculate percentages using sumproduct?
  94. Merge / Combine Multiple workbooks
  95. Using Excel 07 for complex web queries?
  96. Userform Spinbutton to advance row and refresh
  97. Paste the content from Excel to UserForm -> TextBox
  98. Solved: Function Required for Mega Formula
  99. copy contents of csv files
  100. Solved: Filter by Date Selection?
  101. Aligning a chart to cells code
  102. Solved: Parsing a field
  103. Solved: Point And Figure Chart
  104. Solved: validate Combo boxes
  105. Solved: Max Value and the date it occurred?
  106. Using name ranges with sumproduct?
  107. FTP an Excel File
  108. Hide Checkboxes based on last column
  109. Changing named range in loop
  110. Solved: Max Values - Formula solution
  111. need help in excel sort
  112. tracking changes
  113. Fill down formula with data pivot change
  114. Solved: import and split a text file into worksheets by year
  115. Problems creating large numbers of sheets
  116. How to format cells in one row
  117. Solved: Using Comments to Document Formula
  118. How to avoid displaying a warning box on save?
  119. Solved: Filtering Columns
  120. Solved: Complete excel sheet on command
  121. Filter the specific data and find the difference
  122. Sequence two or more loops - VBA code
  123. Check Version & Download Latest
  124. macro to perform selective addition
  125. MULTIPLE CONDITIONAL FORMAT WITH FORMULA IN PIVOT TABLE
  126. How to exit print preview mode?
  127. Solved: Charts automation using vba, works with Excel 2007 but error with 2003.
  128. populate list/combobox without duplicates
  129. Get email address of the user log from excel vba
  130. How to add only 1 worksheet from an Add-in
  131. Merging two sheets
  132. Solved: Workbook Save Flag
  133. Can i use arrays here?
  134. Solved: getting values from files with changing names
  135. Solved: Problem in append data to next column
  136. Last Saved Information
  137. Solved: clear clipboard before closing excel
  138. How to create in excel a form with a menu?
  139. Modify Variables in One Workbook from another Workbook?
  140. Copy/Move Worksheet
  141. Solved: Unmerge cells & Auto-fills
  142. save function not working properly
  143. Right Click Menu of Sheet tab
  144. inserting rows
  145. Problem pasting a Picture into an image control
  146. File Access
  147. Formulas to measuer four two criterias
  148. Solved: Fill the blank cell
  149. Can't name a command button with code
  150. Solved: Delete sheet greyed out
  151. cell reference from one sheet to another
  152. Vb Error Prompt
  153. Solved: Worksheet Function Compile Error
  154. Solved: Advanced Filter with empty cells
  155. ZIP the files using VBA
  156. Select last active cell, offset (-50, 0) copy
  157. VBA Error Subscript Out of Range
  158. VBA combo-box printing pdfs
  159. Forget Password
  160. Solved: Help with random sampling code
  161. How to inser Row using VB
  162. How to remove protection password using Macro
  163. Solved: Where did the 07 known issues thrd go?
  164. Select Unique values from a coulmn
  165. Solved: Custom toolbar for use in all instances of Excel
  166. Custom data transfer based on criteria
  167. Solved: Excel VBA Groupwise (File names)
  168. how to add columns from other excel files
  169. Solved: Summing tasks for a Month period
  170. update master worksheet from multiple workbooks
  171. Solved: Multiple option buttons on user form
  172. Solved: Populate Combobox with spreadsheet col
  173. Solved: Prevent users from entering "Essential Position" in more than one worksheet
  174. Solved: VBA to hide unrequired sheets?
  175. Synchrinizing excel file
  176. Solved: Special Cells - Count
  177. Solved: Calling a sub procedure using variables from another sub procedure
  178. Loop Conditional Statement through 2 columns and Copy/Paste from corresponding column
  179. Solved: Find Replace Macro for Selection
  180. countdown timer
  181. Macro for refresh
  182. My macro stops half way through because of a dialog box
  183. Reading .txt Files
  184. Solved: How to see when was a workbook last time opened
  185. save as csv file codepage problem
  186. Button loses connection to macro when I "Save As".
  187. Solved: function to calculate average
  188. Dynamic Sheets
  189. If statement for Cells.Find
  190. Solved: Update worksheet data through userform
  191. Solved: move data in Excel
  192. Calculating Days and Inactivating the columns
  193. Solved: Vlookup Sum help
  194. Countname function
  195. Solved: calculating a %, based on the bg color of a cell
  196. txt list function excluding zero
  197. Display special values in Column B
  198. VBA userforms, control is command button is visible
  199. Pasting a worksheet to another worsheet in another workbook
  200. Capturing headings of frequent data
  201. Can you use variable to change caption on command button
  202. Irregular do loops
  203. Displaying data from worksheet range in listbox
  204. Solved: VBA saving macro
  205. Solved: Insert Rows basis value in Cell
  206. Solved: WITH statement must be inside Do...Loop?
  207. Graph Whole Row but automatically omit columns with no data and do not graph these
  208. random columns to be copied
  209. Solved: For Statement Inside Select Statement
  210. Solved: Help to imrove the coding
  211. Solved: Copy entire row to new worksheet on found cell
  212. how to do multiple vlookups?
  213. VBA to Set a sheetname as a Variable and call from another workBook
  214. Only allow one input at any given time
  215. Solved: How to hide Formulas
  216. Help with storing varaible value to use later
  217. Solved: Split 1 Cell into 2 cells
  218. Solved: switching between yes and no using data validation
  219. Quickly Delete or Hide Rows if Column N is blank
  220. 2 sheets, matching many:1 date fields, copy value if true
  221. Using Countif in VBA
  222. Solved: Fill an Array based on Range Values
  223. Solved: Lost Focus
  224. Solved: Remove Excel Userform Using VBA
  225. filtering data from two or more sheets
  226. Solved: Two Vlookup's in one cell
  227. Find & Replace VBA help
  228. Recovering conditional Formatting after running Macro
  229. Solved: Copy row with condition thru userform
  230. click link in web page
  231. I want to send a pic as an email attachment
  232. Paste Picture based on cell value
  233. Solved: Creating Dynamic Named Range
  234. Error: 'Cannot find project or library'. 2002/200 compatibility error?
  235. Solved: Create Validation List In Next Cell
  236. Solved: Error Handler: Pass the Calling Macro Info
  237. Solved: Don't allow user to delete formula in Validation
  238. Copy columns based on cell value
  239. Solved: Auto Numbering Requirement
  240. Determining if a date meets a criteria
  241. Paste to unused field
  242. Solved: Array help?
  243. Get values from excel in other machine
  244. Solved: Is this a Vlookup problem?
  245. Solved: Copy fixed 3 cells from multiple files with 1 or 2 or 3 sheets
  246. Solved: Save only if path is true
  247. Find and Delete Multiple Rows based on Criteria
  248. macro help
  249. multiple questions about listboxes
  250. Solved: Possible Vlookup or Index/Match formula help