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. Solved: Average Cells Based on Numbers in Array
  2. Probelm Filtering Pivot Table
  3. Copying Filtered Items to an Array
  4. MESSAGE: License information for this component not found
  5. Exporting a sheet with macros included
  6. Overlapping of Text VBA Problem
  7. Solved: splitting text at Hyphen
  8. My macro crashes on a different computer!
  9. Solved: Read the URL in column G then paste the company name from website in column H
  10. Using variables to reference a range
  11. Copy a range to another workbook
  12. Disable or Hide new workpage tab
  13. Solved: Quick Simple Help with Selection Code
  14. Solved: Simple Selection Code Question. The readable version.
  15. Sleeper: Save 2 Sheet's - criteria in a particular cell
  16. Solved: Chart Macro: Automatically Selecting Labels Range
  17. [SOLVED:] Convert date to string yyyymmdd
  18. [SOLVED:] Group pivot items
  19. Solved: Is it possible for a function to affect another cell?
  20. VBA issue trying to match sets of data
  21. Error ,want help
  22. forum searching question
  23. Macro that generates a report of cells' values source
  24. multiple criteria for sumifs VBA code
  25. [SOLVED:] Auto Numbering
  26. creating multiple workbooks and worksheets quicklyA
  27. Solved: Add entry into one sheet into a list in another by triggering worksheet change event
  28. Sort columns in VBA
  29. how to loop in vba
  30. Solved: please rectify auto row insert
  31. VBA ignore weekends and holidays.
  32. cells that some rows have in common
  33. Solved: Select Tabs using a string
  34. Alternative for vlookup.Need help on my code
  35. Solved: Author Name in Excel
  36. [SOLVED:] Fault in Code, Do I Error code it or write code to account for it?
  37. VBA to identify unique values
  38. sumproduct in vba
  39. File Browser Return Full Internet Path
  40. [SLEEPER:] Excel Data Matching Word Tables & Looping
  41. Filter out Rows with multiple duplications of data
  42. Open multiple workbooks by loop through cells
  43. i need to kill 2 processes
  44. Solved: Remove Duplicates
  45. extract sring from last space
  46. Planing Formula
  47. Sound Generation Software
  48. VBA to change filters in pivot one after other
  49. Solved: Hiding Sheet Via Userform
  50. Charting Month Year at together
  51. Call function from .XLSB to .XLAM
  52. Solved: How to unlink a TextBox linked to a cell in a worksheet
  53. Solved: Copying Cell data and formats across two spreadsheets
  54. find last cell with cell reference
  55. Rename external ped files with names given in excel
  56. Sleeper: Loop & Match to copy multiple row of data
  57. Returning a date with a function
  58. Solved: Excel file splitter
  59. PDF to Excel Import
  60. Selection box on Vlookup error
  61. VBA code to click website button to access node
  62. Solved: How to Write Formulas in VBA?
  63. Solved: Exiting loop once condition is met
  64. Solved: Copy Rows to another Sheet in another Workbook
  65. automatically send email if cell background colour changes
  66. Solved: Printing code
  67. Solved: userform to populate the list box with values
  68. send login details to web form using Microsoft.XMLHTTP
  69. Solved: Conditional Sorting
  70. Show progress on extraction of data from DB
  71. ActiveX Control _Click doesn't work in second window
  72. I Need Help Edit Code Auto Save Every 5 Minutes
  73. Solved: Autofill Series with a minimum and maximum
  74. Solved: Useform autopopulate list box on opening the userform
  75. Find and replace data in a text document
  76. unhide\resize enmasse
  77. Split into 2 rows IF - VBA
  78. [SOLVED:] Code Fix to Delete Duplicates
  79. Solved: Use input box in a formula
  80. Trying to write a vba variant to an excel range which consists of a singular row and
  81. ActiveX Textbox Help
  82. VBA - Split time range in 10 seconds increments
  83. VBA to import sheets from a workbook in a folder
  84. Lock ectire row by an value via VBA
  85. Solved: VBA that synchronize sheets to another sheet
  86. Search and Update Records in External Excel File
  87. VBA: get specific folder from the path
  88. Solved: Create Text files for each subject and Date
  89. Populate Variable Array from Range - VBA
  90. ComboBox's linked loop Crash HELP!!!
  91. input button
  92. VBA Format vs Range.NumberFormat
  93. aggregate & concatenate
  94. Solved: Worksheet_Change to concatenate values
  95. Read pdf content from excel
  96. I need help edit code clean cell and past
  97. Data manipulation
  98. Create Subfiles from a master file using key to split workbooks to seperate files
  99. Count of cells using VBA
  100. Validation
  101. Exclude a word
  102. access database tables in Excel
  103. Solved: Add autofilter to data on a worksheet that is not the active sheet
  104. Conditional Formatting and VB
  105. Find the largest value in a column, then copy and paste to a different workbook
  106. After send email, write column already sent
  107. Sorting columns containing checkboxes by values in header row
  108. Insert Row in new workbook
  109. Help to copy and paste based on cell values
  110. Help to execute a word macro within a excel macro
  111. Solved: Last 10 Rows of a Range from a Closed Workbook
  112. need to concentrate on VBA itself
  113. Sleeper: Copy values using auto filter more criteria with macro
  114. Solved: Filter Guide on "X" criterion on the "Y" result tab "Z" and "V"
  115. Solved: vba to insert formula using variable
  116. Vlookup issue - How to change the source file without affecting vlook
  117. Get current web page title and output to cell
  118. Userform help
  119. copy value and insert new row then paste
  120. VBA: Compile Error: "Invalid qualifier"
  121. unable to set the currentpage property of pivot in vba
  122. Timer counter
  123. Solved: Arrary Function, Not updating Correctly on Different Sheets
  124. Solved: Lock unprotected cells, if a cell is changed - VBA
  125. Solved: Excel forces text into date format
  126. Allow end users to delete multiple rows within a range only - VBA
  127. Excel form that attaches file
  128. Solved: VBA Program to Compare 4 Columns in Excel (Required)
  129. Create "draggable" series name for chart created in VBA
  130. Solved: Excel Workbook Not saving
  131. Creating an excel Save As button in a workbook.
  132. Show Equation of Referenced Cell
  133. Built my excel app but it's super slow
  134. Solved: How to fast write Excel VBA array contents to a text file!
  135. Search and Replace Macro for .txt files modification
  136. Solved: Using find and copy, but only want it to search in 1st column
  137. Exporting specific data to seperate files
  138. General Excel Question
  139. Downloading URL to SaveAs in Directory
  140. Change Font and Size in Excel Footer
  141. Creating a form on an excel worksheet and posting it to a data sheet in the same wkbk
  142. [SOLVED:] Multiple selection in Data validation list
  143. Error Handling inconsistent?
  144. If a cell is NA then lock sheet - VBA
  145. Find Page numbers on one sheet (footer) and paste on cells in a different sheet
  146. Solved: Finding % usage of a word - w/filtering
  147. Solved: Create files and change properties
  148. VBA error 1004- Glitch or Coding Error?!
  149. Compare Column
  150. naming charts
  151. only local SQL databases?
  152. Vba Code Automatically Sort Large To Small
  153. Global Address Link
  154. Solved: Creating and Sorting a Dynamic Range
  155. extract data from pdf to excel
  156. searching data if id of column matches
  157. [SOLVED:] Copy info of a name range
  158. Include Filename in the Modified Macro
  159. Solved: data from Word form to excel sheet
  160. Send email based on a date
  161. Solved: Question Box on Flowchart
  162. inserting multiple drop down menus
  163. Solved: Code to search for a Value in a Range
  164. Translate index-match function to vba code
  165. Pivot Table and Formula
  166. help please ASAP type mismatch error
  167. Copy from notepad and paste in Excel cells
  168. Bulk Email address verification through macro?
  169. VBA to consolidate multiple excel files into one
  170. How show msgbox in created Word Document
  171. Could you tell me what is Excel VBA?
  172. To count values in a changeble range
  173. auto saving a file using a number value from a cell in the spreadsheet
  174. Sleeper: Capture old value of cell before change!
  175. Problem with declaring variables
  176. Enable grouping and Ungrouping in Protected Sheet - VBA
  177. Date Separater
  178. [SOLVED:] Enable users to click"+" to group/ungroup in a protected sheet - VBA
  179. Staying on Current Sheet
  180. Macros to Import Keyword file
  181. Validating repeated values, then bring the result to another cell
  182. How to move a cells value to a diffrent sheet with a check box
  183. Solved: Need VBA code to split quantities based on availability in another table
  184. VBA to autofilter on current date
  185. Merge “Paste Values only” VBA code with “force macros” VBA code and place the code in
  186. Solved: vba auto row insert and revert back
  187. Auto-insert comment, auto insert date and time
  188. First Factor Formula
  189. Pop-up Error Message
  190. Naming Array
  191. [SOLVED:] Object Required For Parameter
  192. Solved: Another Dynamic Range Question
  193. Combining "Force users to enable macros in a workbook" and "Disable Cut, Copy, Paste"
  194. Solved: Problem with Proper Case
  195. VBA script to move files from one folder to 3 and populate list of files
  196. Solved: VBA help
  197. Find all black cells in a range
  198. Pictures - Grouping and Flip
  199. [SLEEPER:] Close IE using Caption Name
  200. Refresh Data Connections in VBA then Message Box
  201. Solved: Make a Summary Sheet
  202. Linking Combo boxes
  203. Multiple goal sheek code error
  204. Detecting Multiple Active Sheets
  205. Solved: Sum a column B where column A is the same in two different sheets
  206. WHATS IT TAKE TO GET A ANSWER
  207. HELP!
  208. Solved: Dir function skipping the first file
  209. Solved: match 2 columns and display 3rd column value
  210. Axis Rounding (decimals, tens, hundreds, etc.)
  211. How to count number of red color in a row
  212. Solved: Use Index, Match, and Max VBA
  213. Loop through files in a directory and delete if not currently in use
  214. How to find exact substring within a cell
  215. Solved: Help Importing multiple XML files - VBA
  216. Conditional Paste
  217. [SOLVED:] How to write a vba code
  218. Load text files to ONE sheet
  219. SUM variable range LOOP
  220. Loop to combine data in 2 columns and insert string every 145 combinations
  221. Function to Return an Array
  222. Problem with IE automation - getElementsByTagName
  223. Finding data in a range
  224. Solved: Send Data to different workbook
  225. Solved: Removing a item from a listbox
  226. Solved: Storing Values/Data beyond a subroutine
  227. Solved: Pull data from other sheets
  228. Solved: Lock Cells (Excel 2010)
  229. [SLEEPER:] Pulling custom footer from another sheet, to only appear on *final* page
  230. Help - Automate Pivot Filter Changes
  231. Solved: Continue Macro after Error Handler
  232. Solved: Delete a six-row block which occurs every n rows
  233. Two doubts on some (i think) simple codes
  234. Cashflow Present Value Calculation
  235. [SLEEPER:] Pivot relationships
  236. [SOLVED:] Check for presence of VBA Procedure in all modules
  237. Who has a file open on SharePoint
  238. animated chart
  239. Working with text for a report
  240. Code for not add the data in Sheet2 if all cells in range in Sheet1 are not filled
  241. Solved: Sum unique values in a range
  242. VBA export of cells with variable range
  243. Save Excel to PDF one page wide
  244. Code to automatically add new email address to a table
  245. Histograms in excel 2013
  246. book
  247. Value field appearing above row labels pivot table
  248. Download Data From Internet using Excel macro
  249. Solved: Using VBA to Log In Members with a Username and Password stored within the Workbook.
  250. Manipilating an ASCII string in VBA