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 168 169 170 171 172 173 174

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