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