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