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