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

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