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

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