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

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