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

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