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 168 169 170 171 172 173 174

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