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

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