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

  1. List File Hyperlink
  2. Please Help !! Code Needs Slight Modification
  3. VBA Code- Insert formula up to last row
  4. [SOLVED] Need Help: Formula to get the amount (number) only out of text
  5. Excel Macro not working properly (missing data pasted using macro)
  6. Excel Array formula
  7. How to remove cells leading ' s when cvs (comma separated) file is imported in Excel.
  8. Some problems by using two userforms
  9. Copy paste first row with correct cell reference
  10. Slicers:Extract selected & unselected items to a Range
  11. Combining matching values.
  12. VBA Adding Table Row - Quick Fix Help!
  13. [SOLVED] Selecting ONLY filtered cells NOT all the active cells in a column
  14. [SOLVED] Excel Macro Run-time error '1004': Selected method of Range class failed
  15. Hello, how to distribute content to a cell by various cells automatically.
  16. [SOLVED] Find a string and clear cell's contents to the right
  17. error parsing text files in directory using excel 2010 vba
  18. Filter all sheets by filtering one sheet
  19. Quartiles with N/A
  20. Filter
  21. [SOLVED] Lock (freeze?!) objects
  22. Private VBA Apply to all New Worksheets
  23. Consolidating Multiple Sheets into One File
  24. [SOLVED] Filter on today's date
  25. [SOLVED] Workbook.Open Event not working correctly
  26. Splitting Sheets
  27. Macro for counting frequencies
  28. VBA String Range Detection
  29. [SOLVED] Merging multiple worksheets into one
  30. Simple computation to record the difference between consecutive cells over a range
  31. Need help creating VBA code for interpolation (kinda)
  32. [SOLVED] Improve Multiple loop code
  33. VBA: Compare 2 cells from different workbook and publish the text right or wrong
  34. [SOLVED] How can I use a current worksheet rather than creating a new one?
  35. Delete rows based on a condition
  36. copy-paste from one Excel file to the other VBA
  37. Conditional macro in Excel based on two or more conditions
  38. Prevent duplicates for 2 sheets + msgBox
  39. [SOLVED] conditionally sum values based on the TOTAL of multiple columns being greater than 0
  40. fill in sequence number
  41. Get data from a PDF...VBA
  42. [SOLVED] Text Box not Displaying
  43. VBA Expert Wanted! >> Populate Table by Cycling Through Sheets
  44. Retaining the Macro code for disabling Save option in Excel
  45. [SOLVED] IF / OR Statement
  46. [SOLVED] Delete table last row
  47. [SOLVED] Transponse help
  48. [SOLVED] Formula - Sumif,sumifs, aggregate
  49. User Defined Function Call Error
  50. [SOLVED] Returning the Desktop Path
  51. Vlookup/Index match, Vba code for two sheets in a Workbook
  52. Pasting Rows from one Table to another
  53. Cell Split or add Rows Excel VBA Leave Plan
  54. [SOLVED] Creating a new row problem
  55. Use Find Method to Clear Groups of Cells in Column When First Cell Marked "DELETE"
  56. VBA problem can anybody help
  57. Macro to Convert text to Number to last cell in the range
  58. Excel userform to search find and return data
  59. VBA Shift One Row Down.
  60. Help....for Changing Vba Code in a Pivot for Filtering a Criteria.
  61. Assigning a cell value to a variable - between different workbooks
  62. Excel file which listed new for any update information
  63. Macro to Copy data from Input sheet to Output sheet based out few criteria
  64. AutoFilter and Copy - Paste
  65. [SOLVED] Listview in userform to show data entred by textboxes and comboboxes
  66. Run-time error "91":
  67. Exit from Sub which is called from another Sub
  68. [SOLVED] Seletion problem in listbox (Userform)
  69. TextBox Has Numericals, Value is String of Hexadecimals
  70. place grid in parsed xlsx
  71. How can I copy and image file from Access Table to Excel?
  72. Reset Sub Workbook_BeforeClose
  73. add date to the column during update in worksheet
  74. Urgent: Help Needed With INDIRECT Formula
  75. [SOLVED] Create Outlook 2013 Calendar items without duplicates
  76. [Solved] Referring to a String within Quotations
  77. [SOLVED] Excel MultiLine Textbox to Access Database - MultiLine lost in the Access Database
  78. Code for multiplying 2 values based on search
  79. Help with worksheet_change
  80. date issue for excel file
  81. Pivot Table expand/collapse buttons
  82. [SOLVED] Help with Loop
  83. Importing Data from Closed Workbook
  84. [SOLVED] SUM IFS (Vba)
  85. ISNA alternative
  86. Data Comparison between master workbook and another workbook
  87. Creating list of Unique values in offset cells
  88. Cycling through filters
  89. Pivot error
  90. [SOLVED] Array declaration question - "myArray()" versus "myArray"
  91. CMD.exe window keeps "taking over" when looping
  92. Copy email id & contact numbers from multiple resume which is in word file
  93. Formating date delimiters in real time
  94. XML Source data format change, Macro's no longer working
  95. [SOLVED] vb to copy and paste based on criteria
  96. VBA formula
  97. Copy Charts from Excel to power point 2007 and save as.
  98. Looping a macro until the formula within the macro results in an acceptable output
  99. Multiple Command Buttons & results in a new sheet.
  100. Open a file from browse window and perform VLOOKUP
  101. [SOLVED] AdvancedFilter displaying Unique values.
  102. google poly line encoding in excelR
  103. [SOLVED] Unable to locate named range in code
  104. How to avoid Circular reference in a Range
  105. [SOLVED] Transformation of data with macro
  106. [SOLVED] save one large file as separate text files
  107. Syntax for unique values
  108. [SOLVED] Filter Data Using Macro
  109. [SOLVED] Modification to copy VBA code
  110. [SOLVED] VBA: Importing data from one worksheet to another returns "TRUE"
  111. [SOLVED] Aligning a chart textbox with a variable datapoint
  112. [SOLVED] write data consecutively if certain cell is not empty
  113. [SOLVED] Application.FileSearch Help
  114. Help: How to Find and Replace VBA Code with VBA Code?
  115. VBA to copy down information into blank row
  116. How to Allocate ER Credit with VBA
  117. What if analysis in Median (formula help required)
  118. Loop for copying values from excel file to fill sentences in Word
  119. [SOLVED] SUMIF with Left criteria VBA
  120. 2003 sorting code not working in 2010
  121. [SOLVED] Max Row Index for an Array
  122. [SOLVED] Excel 2010 How to Create a Custom Toolbar and Distribute to 50+ Users
  123. Using VBA to send emails via outlook using excel cells
  124. Establishing comm link with Eicon Aviva from Excel VBA
  125. [SOLVED] Use Cell Value to go offset to another cell
  126. [SOLVED] Auto-remove duplicates from dynamic list
  127. [SOLVED] Find and Open an email in Outlook
  128. [SOLVED] Odd error when comparing times with "dateadd"
  129. Code to sum columns in lastrow +1
  130. how to get the directory (file save) when the macro is run the first time in the day
  131. I need help with this VBA exam example
  132. Macro to Transpose data
  133. Can you help fix this macro?
  134. [SOLVED] VBA Edit to Search Range
  135. [SOLVED] Nested Loop in VBA
  136. [SOLVED] Employee schedules, 15 minutes interval table [working/slow; need alternative ideas]
  137. Excel Recursive function through XML file
  138. [SOLVED] Pivot Table VBA
  139. Prompt/Store value based on a selection/entry
  140. Create different text files from parts of a range
  141. Using vba to automate a Microsoft Word document with data imported from a Excel sheet
  142. Copy-Paste rows from multiple worksheets into a new workbook based on unique id
  143. Defining Dynamic Named Ranges with VBA
  144. Macro to combine columns without formulas
  145. nervous! How To Import Data From SQL Query To VBA Coding?
  146. Return Last April using VBA
  147. search in another excel file with VBA
  148. [SOLVED] TRYING TO UNDERSTAND HOW EXCEL VBA MACROS AND USER FORMS ARE LINKED TO EXCEL FILES
  149. Conditional wrap line - VBA Excel
  150. Linear programming using solver in Excel 2000
  151. VBA code for entering a formula not as expected
  152. VBA Multi Select ListBox Issues
  153. Revising a code that inserts a new option column upon execution of an option button
  154. VBA: Text from Excel to Word with formatting
  155. Userform calls other userform, then populate worksheet
  156. Linking Content of Wkbk1 to Wkbk2, Extract filtered information into table in wkbk2
  157. Help with VBA code Transfer excel range to Word bookmark
  158. how to open protected view excel file using VBA macro
  159. PDF Data to Excel Adobe XI
  160. Develop a macro to solve below problem
  161. How do I copy Internet Most Visited Places shortcuts to an Excel sheet ?
  162. [SOLVED] How to set the SubTotal TotalList using a variant instead of an array
  163. [SOLVED] Advise on "Best" or "Better" practices
  164. [SOLVED] Pulling specific lines from a text file into Excel
  165. Pull data from webpage
  166. VBA Help - Excel Range (text) to Word Bookmark
  167. [SOLVED] via code to use to 6, 8, 12 sheets
  168. Help vba code for a formula in two cells
  169. [SOLVED] Vlookup using Vba code across two tabs
  170. Create Summary
  171. Create new sheet
  172. How to Pass an array of implement(ed) object(s) to a sub/function?
  173. Help with a code for a picker
  174. Split certain cells to multiple sheets IF value
  175. [SOLVED] macro to take values from range to slicers
  176. Vba to insert text in range of cells
  177. If dropdown only contains one option, automatically show that option - How????
  178. Return the value below the cell that contains a specific string
  179. I Need an Array Formula?
  180. Data from Excel to Word 07 Bookmark
  181. [SOLVED] import txt or csv delimited parts into different excel sheets
  182. Look up records in Access from Excel and copy data to cell
  183. Date Validations using VBA code
  184. Loop within a loop vba
  185. Determine if all files in a folder were created today
  186. excel says it cant find the file I just DoubleClicked
  187. [SOLVED] User Form .SetFocus Help
  188. Build new Nested Loop in VBA
  189. [SOLVED] How to add a label to one selected data point in an xy scatter chart
  190. Sort on multiple dynamic columns using excel VBA
  191. [SOLVED] Open Latest Outlook email by Received Date
  192. create a worksheet based on description
  193. VBA Form inserting dates in the wrong format
  194. [SOLVED] VBA Set Variable equal to macro function
  195. [SOLVED] Max value in array and return adjacent column (similar to offset/match in excel)
  196. SaveAs xlText (tab delimited text): delete empty line at the end
  197. [SOLVED] VBA Sheet Protection Failing
  198. Copy and Enter Current Record Displayed in Userform a # of Times to WS
  199. Excel Duplicates
  200. Moving sheets to a new workbook
  201. VBA CODE- Match 2 cells and display the result
  202. Error When Testing Collection for Key Exists
  203. [SOLVED] FSO filtering on the fly
  204. [SOLVED] Change Numbers to Words
  205. VBA Importing a sheet from a closed excel workbook
  206. Multi-step workbook/sheet automation with VBA, macros, INDEX MATCH combination
  207. [SOLVED] Add Dates to Printed Header
  208. Concatenate in VBA
  209. Excel 2013 - VB Script to save and e-mail form
  210. [SOLVED] [VBA] Pasting data in Word looping for no apparent reason
  211. [SOLVED] PivotTable field name is not valid when changing source data
  212. VBA Code - Lookup column1 in Column2
  213. How to Shell to other Application with excel vba
  214. [SOLVED] Question with FSO filtering - snb
  215. VBA Calling/Application.run with dynamic inputs + error handling
  216. HELP with Formula to calculate Interest Rate
  217. Running a PDF file from Excel
  218. PROBLEM WITH SCROLL BOX INSIDE A FORM
  219. [SOLVED] Custom Function Needed for Evaluating Performance
  220. Saving Row as Text file - Concatenate & Line Breaks Not Working
  221. [SOLVED] How can I remove duplicates from a dynamic range?
  222. Small Script Edit - Pasting value in front of data set
  223. [SOLVED] Cannot unlink word header
  224. Delete row based upon Date
  225. Running macros while logged off
  226. [SOLVED] Copy value of cell if date matches the date of another sheet
  227. Problem to create an indexed array - M(1 to 1, 1 to 4){i}
  228. [SOLVED] VBA Code: If not in column A then Replace
  229. [SOLVED] Dynamically Color Coded excel rows
  230. Turning Auto Calcs into Run by Button
  231. Merge and Append 95 Workbooks into One Workbook
  232. [SOLVED] Move data from one sheet to another and export
  233. [SOLVED] VBA Code to Insert a Row
  234. Copy sheets from file to another but Not Copying those that already exist in 2nd file
  235. Move cell values and buttons up from application caller
  236. [SOLVED] Clear contents before replacing text
  237. Search through a number of files for keywords and return associated data. help!
  238. Userform With Multiple Independent Combobox (delete row when not match)
  239. VBA Excel data to Powerpoint
  240. [SOLVED] index match function & IF to exclude few values
  241. Color issue confusing me
  242. Help putting border around a range
  243. [SOLVED] Add a sort filter to existing code
  244. Compare 2 multi-arrays and isolate duplicate into 3rd array
  245. Help with code to determine whether two strings are in a cell
  246. VBA Code - If Code #1234 found in ColumnA then result code 5678 return in ColumnC
  247. VBA Code: Use keyboard keys in VBA coding
  248. [SOLVED] VBA/VBE Weird behavior when deleting a code line in a sub using a different sub
  249. How to Go to Next Row on a UserForm
  250. [SOLVED] Finding the Sum of Numbers between words in the entire workbook.