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

  1. Delete the list from UserForm
  2. Drop down list without blank cell
  3. Data copy from other sheet based on cell value
  4. Issue with code to check whether an excel file is open or not
  5. VBA Help - Avoid triggering a Change Event on Delete
  6. Best Approach to Do This Report
  7. Creating Multiple Tables Using Loop in VBA. I still want to add new sheets and add
  8. [SOLVED] VBA code excel
  9. Get Msgbox in a table
  10. [SOLVED] Question about excel instances locked down if spreadsheet hidden while using a form
  11. [SOLVED] Moving Rows
  12. Lock cells and paste values based on a cell value
  13. VBA help, export from Excel to text file, insert delimiter
  14. Help with hiding rows based on content of a cell
  15. [SOLVED] Extract Multiple Rows into a Limited Template based on Multiple Criterias
  16. [SOLVED] Recalculate the cells in a column to achieve a set SUM value
  17. Excel vba crashes?
  18. [SOLVED] Help Debugging Short VBA Formula
  19. Using Excel VBA Get the "Page Number" of Table current cells in Winword.
  20. [SOLVED] VBA Copy Paste Formula
  21. 2 different lists
  22. [SOLVED] Excel VBA MsgBox NOT closing
  23. [SOLVED] VBA loop formula explanation?
  24. [SOLVED] Listbox export
  25. Variation on dynamic Linked Cells code
  26. Grouping - VBA
  27. Excel Hide - Unhide Columns With Userform
  28. [SOLVED] Range A1 notation
  29. Touch Screen Programming
  30. [SOLVED] Creating Array from cells givin error " Subscript out of range"
  31. Excel VBA - Copying to specific column
  32. [SOLVED] Custom Ribbon Add Additional Tab
  33. Using Hyperlink to open a hidden sheet - not working
  34. Using userform VBA to create a list
  35. [SOLVED] Macro to clear data but keep formula
  36. [SOLVED] Copy userform info to worksheet row based on 2 criteria
  37. Can't open new workbook
  38. [SOLVED] Find - replace
  39. Reverse date Import from .csv file
  40. Stuck with block if without end if, totally lost.
  41. please help in vba macro--Compare and merge data given in parent child hierarchy
  42. [SOLVED] DataPoint = NormInv(rand(), MeanNow, 1#) fails in VBA
  43. Dashbored where he take stairs
  44. If condition for check all the rows
  45. [SOLVED] looping from one worksheet to the next fails
  46. DTPicker select date to display in Text box
  47. Unique values from dynamic list
  48. Image viewer with images control
  49. VBA - what is Chr(1)
  50. [SOLVED] Timestamp difference in Millisecond
  51. [SOLVED] Listbox Selection not working with 1 result
  52. [SOLVED] Help with Formula
  53. [SOLVED] Flashing cell
  54. VBA userform output storing number as text
  55. Live data output
  56. Page setup when selected items are sent to print Preview
  57. TextBox SetFocus Problem on UserForm
  58. [SOLVED] Compound interest rate with leap year
  59. [SOLVED] Auto unformatting of output filename with leading zeroes
  60. Finding a value in my table
  61. [SOLVED] Compare 2 columns from separate sheets and create new sheet with data from both
  62. Copy certain cells to new sheet based upon a different cell?
  63. Conditional Format
  64. Fill in the data with date range
  65. Leading zeroes depending on file name
  66. Adding message and loop to input box password
  67. excel vba to outlook email
  68. help with vba loop inside listbox & search value
  69. Word recovery and mapping vba
  70. Renaming Worksheets Using VBA
  71. Merge cells based on the cell value updated on other column
  72. MACRO filter column based on reference criteria copy, paste and repeat
  73. Autofilter List Exists
  74. [SOLVED] VBA code for consolidating/transf data from multiple worksheets in one Template sheet
  75. Issue with VBS - wscript and saving multiple files
  76. How to switch between worksheets while VBA is running?
  77. [SOLVED] Multiple Filters of Pivot Table
  78. VBA: search for multiple words
  79. Using Solver with a macro
  80. userform comobox question
  81. [SOLVED] Pull Latitude from XML and keep Double
  82. [SOLVED] PivotTable.DrillDown and filtering the output based on target column data type
  83. userform textbox save file path in cell as hyperlink
  84. Vlookup open file on background
  85. [SOLVED] Excel Formula to Link Totals from Newly Created Tabs to Summary Sheet
  86. [SOLVED] Formula help
  87. When would you execute doevents more than once?
  88. how to check if already exist in db
  89. move to end of the procedure
  90. Loop through a collection of controls
  91. [SOLVED] Go To Next Filter
  92. VBA for consolidating data without duplicates
  93. [SOLVED] Converting Tables Into ListObject
  94. search by header column in VBA and copy corresponding column
  95. [SOLVED] Error: Application-defined or object-defined when trying to hide row
  96. In VBA transfer data from one spreadsheet to another based on new date
  97. Group of Functions
  98. Workbook.BeforeSave Event on Mac Office
  99. If condition is not met, go back to start of code VBA
  100. VBA Looking for a Better solution than iCol for next loop
  101. when importing data VBA code changes values ​​of the original ​​book
  102. [SOLVED] Macro Run-time Error '1004' Application-defined or object-defined error
  103. I need VBA for my work. Thanks for all helps
  104. adjusting code search by combobox
  105. vba adding up time with spin control & text box with userfirendly output
  106. VLookup Duplicating Data
  107. Conditional Outline Borders Based on Criteria
  108. Pasting range from Source ab to Destination tab based on name
  109. [SOLVED] Parent / Child Relationships
  110. how to lookup combo box into textbox in excel VBA
  111. [SOLVED] VBA Input Box
  112. Removing parts before each item
  113. Help reversing calculations.
  114. [SOLVED] Create a border around a range for specific criteria
  115. [SOLVED] Worksheet_BeforeDoubleClick
  116. VBA coding for Excel problem
  117. Reference to Lists in another workbook
  118. Question about clear, clear contents
  119. Export pivot table to individual PDF
  120. [SOLVED] Match Error 2042
  121. Make code more variable
  122. VBA userform listbox - hard set range to specific sheet
  123. Setting Linked cell to another work sheet
  124. [SOLVED] sort data within the same cell
  125. Copy cell data from one protected file to another
  126. [SOLVED] IF Statement using VBA
  127. Macro IF statements
  128. [SOLVED] AverageIfs to compare AM vs PM hours
  129. Parse rows to sheets
  130. [SOLVED] VBA Conditional formatting - multiple adjacent cells if specific text on left
  131. Remove "Filters" from Macro Script
  132. PDF creating and past copy different folder
  133. How can I write VBA macro for bchain() and bdh()?
  134. VBA Pasting values to different cells in the same named range
  135. Overcoming ADO Recordset 64 Characters limitation for Fields
  136. Importing Images/Pictures/Shapes from a Closed Excel Workbook
  137. VBA to compare values in 2 cells and post a value in another
  138. [SOLVED] A Class Module to store Images from a folder for later reuse in Workbook Excel VBA
  139. Using Index Match with an unknown range
  140. VBA - capacity smoothing
  141. MACRO/VBA - Extract unique values to different worksheet that meets a criteria
  142. Extract unique values from column based on criteria
  143. Automatically updating date cell unless row is blank
  144. COUNTIF Column based in VBA
  145. How can I modify this code to use a cell value when naming the new workbooks?
  146. [SOLVED] Merge multiple Excel files into ONE WORKSHEET
  147. [SOLVED] Filling one Cell from another Cell
  148. Caculate From One Cell & a Dimension Table
  149. Changing column types
  150. Trying to Sort "Multiple Rows" together
  151. VBA form question
  152. Resizing a table to size 1 row
  153. [SOLVED] Single column into matrix
  154. VBA to check if cell changed
  155. [SOLVED] Loop a sort function
  156. URGENT HELP PLEASE Copying same data to multiple rows
  157. Import data to excel
  158. adjusting code calling data in worksheet
  159. If Pivot Item = "" then skip
  160. Out of memory - find and replace part of hyperlink
  161. vba Help - extract Matching value
  162. Extract Crossing new Sheet
  163. Selecting Pivot Table Range with Dynamic Data
  164. [SOLVED] Using Structured Cell References
  165. Select cells with input box and unlock them in a protected worksheet
  166. EXCEL syntax isue
  167. Macro to compare two workbook
  168. Combining Multiple Worksheets with Same Table Headers
  169. [SOLVED] Editing part of a string
  170. [SOLVED] Embedded Templates
  171. Search and Extract related data from TXT file and append into Excel
  172. Ensure that only unique values are extracted
  173. Looping Through Pivot Items
  174. vba excel macro for print button
  175. VBA Printing only columns with data
  176. [SOLVED] VBA function - Inputting multiple cells instead of a complete range of cells?
  177. Seeking help to make cell ranges dynamic
  178. Seperate Data by trade ID and Date
  179. [SOLVED] Modifying existing form - how to add date picker
  180. Speed Up VBA Macro
  181. Help?! Run-time error 6 overflow
  182. Noob to vba - loop not looking at all
  183. [SOLVED] Declaring a variable using part of a filepath name
  184. VBA macro to copy from various sheet to a new file
  185. Auto copy and paste query table
  186. [SOLVED] Use a variable for subroutine name
  187. [SOLVED] Keep 1 Record every 5 duplicate
  188. [SOLVED] Data type mismatch with VBA Range.Copy & Range.PasteSpecial
  189. Changing first name to initial only, adding second initial and combining repeats
  190. [SOLVED] Why does my Array only fill half way?
  191. Case with boolean
  192. [SOLVED] byref argument type mismatch
  193. Lookup a date range by Matching a column data set in a table & fetch respective data
  194. I need VBA code
  195. Formula for sale
  196. VBA: Export to PDF combination of cells
  197. Find and Replace not working
  198. [SOLVED] VBA code to prompt message " file in use" please wait
  199. VBA Code needed. if more than 90 days, Message Box Expired, Elseif still valid
  200. [SOLVED] Seek matching text in cells and if match found enter info in third cell
  201. Cell Address Goal Seek
  202. Converting DOS Commands to VBA Function
  203. List Files (Specific File Type) from Folder & Sub-folders to Excel w/ VBA
  204. [SOLVED] Week number instead of Day Dates
  205. [SOLVED] VBA code for vlookup in multiple worksheets
  206. [SOLVED] Applying conditional formatting on range of criteria dependent cells
  207. Reveal all matches with FIND function
  208. Automatically fill calender
  209. Macro toggle button
  210. Copy Paste Shapes from one worksheet to another using Clipboard - Excel VBA
  211. Copy data from one workbook to another using VBA
  212. If conditions are met, copy to new worksheet
  213. Trying to reference a range of cells inside of a table and call a function OnChange
  214. Insert row with template row of formulas
  215. VBA Macro Named Pipe IPC
  216. ".findformat.font.Italic=false" code needed
  217. VBA Code Help Needed
  218. How to transfer data from an array to a matrix?
  219. [SOLVED] PLS Help For Each loop (detailed info of the problem)
  220. Transferring data from a table on one sheet to another and appending the existing dat
  221. VBA To Autofill a formula across multiple specific columns
  222. Macro for saving active work books to new file type
  223. Create Powerpoint Slides and Add Titles and links
  224. [SOLVED] VBA: If And Then Else Run-Time error '13'
  225. How to offset a curve in VBA
  226. EXCEL 360 vba code print hidden excel sheets
  227. Changing ActiveX control properties based on cell text
  228. info macro for MAC OS import html jpeg
  229. conditional formating
  230. [SOLVED] Can't refer to Add-in Worksheet for Goal Seek function
  231. Vlookup in VBA: Creating dynamic List and lookup Multiple Values
  232. [SOLVED] VBA import from csv - copy into existing cells rather than insert new
  233. Final Results of VBA Loop overwriting all previous iteration results
  234. Split the data into multiple excel Files based on the column Filters
  235. Conditional sum with DATE in VBA
  236. [SOLVED] Code Not called on button click
  237. 2 column condition move duplicates to new sheet
  238. Search specific Numbers with Different criteria
  239. COPY AND PASTE OF DATA
  240. [SOLVED] Nesting MsgBox gives Syntax Error?
  241. [SOLVED] VBA: Select cell thats two columns ahead and make changes to it (and current cell)
  242. Transfer Multiple Data From Multiple Rows to one Column (Transpose form)
  243. [SOLVED] A Question on VBA input box
  244. Identifying Declining Sales by Sku
  245. Finding a value by date and time. Quickly without looping.
  246. Editable Auto Numbering
  247. delete entire row
  248. Insert cell at specific rows by string
  249. Part of a string
  250. Code for copy/paste from list to new sheets