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. Update chart when adding new sheets of data
  2. VBA to delete first 3 characters and keep cell formatting
  3. assign a cell value to a variable vba loop
  4. Sleeper: Found connection problem when run VBA to direct connect Oracle Database
  5. [SOLVED:] sort and extract text to another excel file
  6. Update Cost on a smaller spreadsheet from costs on a larger spreadsheet.
  7. identifying duplicates on each row
  8. Activate this popup html
  9. Retrieve price from another wb instead of different sheet? code complete except exter
  10. [SOLVED:] Find text paste text in message box next cell
  11. Compare two sheets and exclude existing in the second sheet
  12. Need a macro for copy pasting with transpose
  13. [SOLVED:] Combine strings and place in separate sheet
  14. Copy & Paste
  15. [SOLVED:] VBA save as function as new workbook
  16. If cells starts with a number and exceeds a certain number of characters
  17. VBA: Counting an "if" loop to get average.
  18. [SOLVED:] PROCESSING External Excel Files
  19. [SOLVED:] Subscript out of range
  20. [SOLVED:] change word spacing in a messagbox
  21. Calculation incomplete message issues
  22. [SOLVED:] Conditional Formatting
  23. Generate workbook
  24. Unpivot data?
  25. [SOLVED:] Code runs when VBA Editor is open, but doesn't work when closed
  26. VBA Macro button to open a folder derived from the (partial) name in a selected cell
  27. Sum/ABS
  28. size of photo based on the height of row and make center based on the column width
  29. [SOLVED:] Find and Replace macro is not working
  30. VBA: Am i doing something wrong with While...wend?
  31. [SOLVED:] stripChar is not working
  32. macro to select different sheet tabs
  33. [SOLVED:] If Elseif to toggle
  34. Conbining IF Then Conditions in Excel
  35. convert date/number
  36. [SOLVED:] How to copy sheets from workbook to new open workbook and rename new workbook accordi
  37. [SOLVED:] Multiple buttons using a single macro
  38. Save Document's most recent version
  39. Studying VBA for Excel and getting frustrated by objects/properties...
  40. [SLEEPER:] Frightened to tunnel!
  41. [SOLVED:] Stuck with defining range for calculation
  42. [SOLVED:] Excel 4 Macro Page.Setup Error
  43. Macro to delete line in excel after third / sign.
  44. Help needed: Vlookup formula with a dynamic range
  45. [SOLVED:] Needs Help With Conditional Renaming for Several Tabs
  46. Need he;p with code error, .SaveAs
  47. [SOLVED:] STRUGGLING VLOOKUP in VBA
  48. Checking for multiple conditions
  49. Excel picture object chart paste in specific ppt as per slide name/number through VBA
  50. [SOLVED:] Needs Help With Calling All Tabs
  51. Needs help with VBA for 2 specifics detailed functions
  52. Pivot Table Filter Button - VBA HELP
  53. Excel Macro to copy data from a specified multiple ranges of a workbook to another wb
  54. Need help for copy columns to new sheet with new order and two or more criteria
  55. [SLEEPER:] Linear/nonlinear Optimization with Solver
  56. Problems writing data to worksheet
  57. [SOLVED:] how to remove saturday and sunday when calculating start dates
  58. Copy rows from Outlook to Excel
  59. Insert a picture in an multiple image control with one click based on dropdown list
  60. VBA code to copy data from one sheet and paste it in a specific location
  61. [SOLVED:] Highlight Duplicates
  62. [SOLVED:] VBA Page Break Issue
  63. VBA Lock rows upon checkbox click on multi-sheets
  64. [SOLVED:] Need advice with manuals and instructions
  65. Avoiding the DocumentsPane to show up on startup
  66. [SOLVED:] Need Help With Input Box To Open File in Specified Path
  67. [SOLVED:] Select Sheets Array If
  68. FSO Object used in VBA code?
  69. [SOLVED:] How to create a list out of wide table
  70. [SOLVED:] Switch between Putty and Xshell using same Loginbutton
  71. Run Regression on Filtered Data Set
  72. [SOLVED:] Needs Help With For Next Loop
  73. Combine Excel sheets w/ same name into one
  74. This code takes 5 seconds to run. Any suggestions on how to get that down to 3?
  75. [SOLVED:] Run-Time error when saving
  76. [SLEEPER:] Code retrives https:// in Windows Explorer instead of windows explorer drive
  77. [SOLVED:] Qucik help
  78. Need help combining multiple sheets into a single summary page
  79. restore workbook after Application.Visible = False
  80. Place formulae on each row where dates meet criteria
  81. How can I chart the moon data against the tide data
  82. [SOLVED:] Importing data from a MySQL database
  83. Need Help With Automating Data Validation Selection
  84. VBA to merge specific sheet of different workbooks into one multisheet master file
  85. Need help with VBA code for entering cell value based on another cell value
  86. Efficient coding with Loop
  87. Need Help - Find Variable Text from Cell B in Cell A, then Bold/Color.
  88. [SOLVED:] Format Cells based on start & end date!
  89. Calculate Percent Error
  90. Optimize macro performance
  91. Unmerge VBA with dates
  92. Could I have done this quicker?
  93. [SOLVED:] Format decimal places based on columns from same row
  94. How to analyze big data with Excel
  95. [SOLVED:] DATE DIFF function in years
  96. [SLEEPER:] Matching Algorithm - Gale Shapley, Almost complete - Excel Matching
  97. Alternative for sendkey
  98. [SOLVED:] Shared excel userform
  99. [SOLVED:] Display MsgBox "Macro is running" when macro is running
  100. [SOLVED:] "orientaion" parameter in vba SORT
  101. [SOLVED:] Generate multiple TXTs files
  102. [SOLVED:] find/retrieve price from closed WB and copy to current workbook
  103. [SOLVED:] Need Help in making minor modification to an excel vba code.
  104. Help creating a file joining different other files
  105. copy and paste into next blank cell of table
  106. [SOLVED:] Range changes values unexpectedly as code executes
  107. Creating and Save new workbook based on cell value
  108. [SOLVED:] Excel and splwow64.exe issues
  109. [SOLVED:] Function in VBA (Excel) - Want a dynamic behavior depending on parameter
  110. [SOLVED:] Workbook open from specific folder
  111. Transpose Data Blocks To the Right
  112. select item with macro
  113. VBA code for determing if worksheets (OR) cells within a worksheets are protected?
  114. Method 'SaveAs' of object '_Workbook' failed
  115. [SOLVED:] VBA copy and paste Vlookup
  116. [SOLVED:] Need Help With Show/Hide Check Boxes
  117. [SOLVED:] Autofill Destination Offset
  118. [SOLVED:] Extract matching data values and copy to new location
  119. [SOLVED:] Subscript out of range problem
  120. Copy data from another worksheet if it doesn't exist in current worksheet
  121. [SOLVED:] Want to load Red colored text from a cell into an array
  122. [SOLVED:] Print Userform
  123. [SOLVED:] Highlight the first row in every data block
  124. [SOLVED:] Highlight duplicate data blocks
  125. [SLEEPER:] Work hours between 2 dates(not working -VBA)
  126. [SOLVED:] VBA User Form To Select Column To Copy Cells Into If Destination Is Blank
  127. [SOLVED:] Coding Efficiency (2)
  128. Excel Table of Contents/Summary Help
  129. VBA code to determine if a specific excel-based tool is used as add-in and locked?
  130. How to copy an entire row from 1 sheet to another
  131. Subtotal at each PageBreak
  132. Help with VBA code in data entry form
  133. [SOLVED:] VBA to dynamically select EACH block/range of cells on a worksheet, then copy/paste?
  134. ICOLOR TAB
  135. Create Summary sheet from multiple tabs & run macro on certain tabs
  136. VBA to relocate XML blocks
  137. Modification of VBA code
  138. [SOLVED:] Find and Replace based on Selection only
  139. move files from one folder to another whose file names are listed in an excel file
  140. [SOLVED:] De-selecting cells after Paste
  141. ActiveX Combo Box and Pivot Table using Visual Basic Issue
  142. VBA code to generate report based on criteria
  143. [SOLVED:] Even Vectors - Panel Data
  144. Numbering a unique sort
  145. [SOLVED:] Renaming inserted Object
  146. Excel to Pdfs Not saving correctly
  147. How to correct this error
  148. Can I “include” another file or module in a sub or function?
  149. [SOLVED:] NEED A LOOP TO COPY DATA
  150. Get data from two worksheets using form
  151. [SOLVED:] Cell selection issue
  152. Adjust macro (problem)
  153. [SOLVED:] Database or object is read-only
  154. Hi , how to select sheets
  155. [SOLVED:] Isolating errors 2
  156. [SOLVED:] Copy/paste values in column if condition is met
  157. [SOLVED:] Save workbooksheet as .CSV with some variables
  158. [SOLVED:] How to modify this code to place the checkbox in the first cell of each column?
  159. Locking Cell Format
  160. [SOLVED:] Date filter in table
  161. [SLEEPER:] Using Marlett for optional selections - multiple ranges
  162. Filter Pivot table by each customer and auto email invoices unpaid
  163. VBA for binking Text inside a Shape in Excel
  164. [SOLVED:] Need help with Macro VBA code in Excel
  165. How do I move files into latest created subfolder
  166. Sleeper: How do I break a link after saving to new workbook
  167. Skip heading rows with Range Offset
  168. [SOLVED:] Vba code to copy and paste dynamic range from mulitple workbooks to one workbook
  169. [SOLVED:] Message bar detection.
  170. Moving different rows data to one row based on criteria to optimise on printing
  171. Export Crystal Report to pdf
  172. [SOLVED:] Data Validation
  173. Minsweeper VBA code Problem
  174. Excel report generation and export to pdf
  175. Auto click OK button
  176. [SOLVED:] Help with macro to set vertical alignment in Excel without affecting text indents
  177. [SOLVED:] Spell Check in Excel-Auto Select First Recommendation Using VBA
  178. VBA: How to use listbox properly.
  179. Exporting an multidimensional array from an Ecxel file to a new Excel file (.xls)
  180. Still Stuck On A loop
  181. [SOLVED:] Optimizing Copying Sheets & Printing
  182. [SOLVED:] help for homework
  183. [SOLVED:] Function to get list of Excel files in a folder
  184. Converting Excel File to CSV
  185. [SOLVED:] Template
  186. Mails from excel
  187. [SLEEPER:] MonthView DatePicker default to current date
  188. [SOLVED:] using conditional format to change font if column has a number greater than or equal
  189. Copying real time data in excel using VBA
  190. convert gregorian date
  191. VBscript for data matching
  192. Condition should applied if columns total value is not match
  193. [SOLVED:] When stepping through, code doesn't stop after this "paste" command...why?
  194. [SOLVED:] Form selection
  195. Activate sheet which contains date
  196. Excel automation error on VBA Code modification using VBA
  197. [SOLVED:] Numbering Duplicates Consecutively
  198. VBA Copy Sheets to New Workbook
  199. VBA to save excel file (downloaded from server) to specific folder
  200. Code to detect duplicate cells in Excel
  201. VBA adding numbers up to a certain range
  202. Simple and Basic VBA question.
  203. VBA macro for dependents
  204. Linking multiple sheet columns into one master sheet column
  205. Format Column Labels
  206. Worksheet_Change ( No Responese )
  207. Table
  208. Change Color If Selected Cells Edited
  209. Looking for a free software/tool to perform analysis on excel data....
  210. [SLEEPER:] Problem with DCOUNT + Problem while copying data from range to listbox
  211. Need help with INDIRECT formula
  212. [SOLVED:] Help to build a data collecti searching from many Workbooks
  213. [SOLVED:] Help needed resolving Compile Error: Expected End Sub issue
  214. Hiding and then Unhiding Rows on Excel sheet based on if a checkbox is unchecked?
  215. HELP! - Print All Options (Loop) On A Drop Down List after Refreshing Excel Add In
  216. Hiding columns based on cell values in column
  217. Rank for Top 5 after two criteria match excel formula
  218. "Run-Time Error 91" trying to run Login Code
  219. Write selected items on form to range
  220. Protect radio buttons on a sheet with VBA
  221. FILTER EXCEL PER COUNTRY & CREATE MULTIPLE WORKBOOKS
  222. Add and Sort
  223. Chart series don't extend
  224. Creating a VBA code for a cell with a dropdown list to allow multiple selections
  225. Assistance resolving Runtime 1004 error
  226. Multiple conditional formatting to the same range
  227. [SOLVED:] Using End(xlToLeft) in Sheets with Tables
  228. [SOLVED:] Stuck trying to figure out this macro
  229. Calendar userform ( datepicker )
  230. [SOLVED:] Execute Macro on Cell Change
  231. VBA Userform match issue
  232. vlookup separate workbooks and sum the results
  233. Nested if statement, loop or something else
  234. Sorting arrays
  235. [SOLVED:] VBA Copy & Paste Based on a Condition in Another Column
  236. [SOLVED:] For Loop goes thru all sheets but doesn't execute code?
  237. Double run problem
  238. Search multiple keywords to filter column
  239. [SOLVED:] In merged file, re-name sheets to include part of workbook name that they came from?
  240. [SOLVED:] if find specify word copy all the row to anther sheet
  241. Trying to replicate MAX function in SAS
  242. Speed up the loop process (Copy paste Value)
  243. [SOLVED:] Split text in different cells after each Dash
  244. Sorting table with Duplicates
  245. Slicer changing chart styles
  246. vba excel dir loosing file name in looping
  247. Modifying datasource using VBA in Power Pivot
  248. Excel Userform with Checkbox value, How to return to Checkbox value in Winword
  249. [SOLVED:] How to use an Array instead of a Loop to clear contents of blank cells? - Speed Issue
  250. [SOLVED:] Excel macro, combine cells based on same merged row i different column