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:] Lookup formula not returning the correct result
  2. [SOLVED:] Userform is not displaying anything when i change a "box" to visible or not visible
  3. [SOLVED:] Worksheet SelectionChange Error - Target.Address - if statement
  4. Script not working after moving data to SharePoint
  5. [SOLVED:] Help: Capture file location on the first opening of a workbook/workbook open event
  6. Column getting truncated
  7. Open and Close Workbooks | best Practices
  8. Excel file always opens in read-only mode when opening from sharepoint
  9. [SOLVED:] How to create a values only copy of WB while keeping formatting and filters in tact?
  10. Excel VBA folder-search-tool
  11. [SOLVED:] Application Visible with more than 1 workbook
  12. [SOLVED:] mismatch when sum values in multiple textboxes
  13. [SOLVED:] Cumulative based of criteria
  14. [SLEEPER:] Opened Workbooks are still opened after executing Macro (Workbook.Close doesn't work)
  15. HELP!! can't figure out details for a file-combining macro
  16. Not Getting Sum Result From All Sheets
  17. expenses compared to the budget
  18. Market data and charts
  19. copy with loop double variable
  20. [SOLVED:] Date Help
  21. Macro for inserting rows if value
  22. [SOLVED:] Multi-sheet procedure
  23. [SOLVED:] How to Change the Value of a Cell based on the values of two other cells
  24. [SOLVED:] Zero Out Column if another column has a certain qualifier
  25. [SOLVED:] Create Summary
  26. How to prevent duplicate value
  27. Shell Command results in Runtime Error 5 - but path appears to exist
  28. [SOLVED:] Countif in VBA Module
  29. [SOLVED:] Compile Error Syntax Error
  30. Add the value taken from the user to my range for ActiveX ComboBox
  31. Loop Through Data Validation List and Copy Values Given By Each Item
  32. [SOLVED:] Re-Arrange Columns after Import
  33. [SOLVED:] Is it possible to store range objects in an variant array?
  34. [SOLVED:] clear dependant drop down boxes
  35. [SOLVED:] VBA code to pull in data from SQL table
  36. copy information with vba
  37. [SOLVED:] Deleting Worksheet Stops Script
  38. Pull SQL Data into Excel by Date Range
  39. Setting tab order, adding ability to stop/start code and refine functionality
  40. Macro Or Command To Change Photo In Excel - Urgent Weekend Help Needed
  41. Data validation and manipulating input
  42. [SOLVED:] Check if within multiple ranges check problem
  43. [SOLVED:] Compile Error Private WithEvents oCbarEvents As CommandBars and Private Sub Worksheet
  44. strAddress = .ActiveCell.Address Run-time error 438 when switching sheets
  45. [SOLVED:] Delete Rows if Cost Code Bucket is Zero
  46. SUMIFS on multiple rows and columns, based on a mapping
  47. File Selection- if user cancels- End Sub Then call macro1
  48. How to split a big text file (with more than 500000 lines) in to smaller files
  49. [SOLVED:] Conditional Format:Need to compare 2 cells with any other 2 cells for the same number
  50. wrap broken lines in one line in a given text or log file
  51. Copy text from text file between keyword in rows.
  52. [SOLVED:] insert auto serial number in user form
  53. [SOLVED:] storing processed data
  54. [SOLVED:] Textbox within a Frame in UDF unable to take focus. Why not?
  55. [SOLVED:] looping through functions
  56. Helper columns to solve problem
  57. search and copy the line
  58. Help to remove duplicate strings from table
  59. VBA script updating values other sheet
  60. [SOLVED:] Formula with OR condition does not return expected result
  61. How to close all the hyperlinked files automatically?
  62. Array loop values
  63. Make a declared variable equal to values from multiple cells
  64. [SOLVED:] HOW TO CONCATENATE: IF(condition;result string;result string) result string?
  65. Sleeper: Find a Partial Match from Location Sheet
  66. [SOLVED:] 3 questions regarding VBA Excel
  67. [SOLVED:] Expanding the range
  68. [SOLVED:] need Code to select value from dropdown list using numeric values
  69. [SOLVED:] MkDir and "Path Not Found" Run-time error 76
  70. Criteria based lookup
  71. Instant change between one textbox to another.
  72. Insert Multiple Image and name image in Userform
  73. Copy and paste styles of diagram
  74. [SOLVED:] VBA Excel - reduction of lines
  75. Copy and paste specific ranges
  76. [SOLVED:] create Summary report from information on the DATA Tab.
  77. Checkboxes and filters
  78. [SOLVED:] Copy Data from one workbook to another - based on tab name
  79. [SOLVED:] VBA Userform macro help for range dates
  80. [SOLVED:] Search for name and letter matches and split equally
  81. Search for a match files using value from selected cell in Folder or Subfolders
  82. Return latest result for work schedule
  83. [SOLVED:] Every time you open the UseForm, it generates a new code
  84. Image embed
  85. [SOLVED:] AutoComplete doesn't recognize Cell A1, it starts getting information from the second
  86. check if serial number is repeated
  87. Can someone recommand an obfuscator for xlsm?
  88. Doppelte Einträge zusammenfassen
  89. [SOLVED:] How to range table "t" from ActiveSheet "Charts"?
  90. [SLEEPER:] How to convert number of color to RGB?
  91. [SOLVED:] how to force users to enable macros
  92. [SOLVED:] IF Countif and Textjoin - Help required
  93. [SOLVED:] Help for viable registration solution and code improvement
  94. [SOLVED:] How to pull information from different columns of data from the same row?
  95. Help needed- Analysis of splitting of orders
  96. Need vba to code to split data depends upon col I:I and col J:J
  97. VBA Help on drop down list
  98. HLEP!! I need help modifying this code.
  99. insert selected row from listbox to excel table
  100. Worksheet Change Referencing Cell in Another Sheet
  101. Automatically delete rows after time period using time stamp (have partial code)
  102. Excel counts a blank as zero. Why not leave it as a blank?
  103. [SOLVED:] Cross section by matching column and row headings
  104. Filter values ​​from a table and display them in different textboxes
  105. Price List Comparator
  106. Filter By Multiple Criteria then match results to different workbook & paste new data
  107. A search code with three possible results
  108. [SOLVED:] How to save multiple selected information from a LISTBOX?
  109. Making code more concise - VBA scrape information
  110. [SOLVED:] Pivot table
  111. VBA Code for pasting today's date into a text box
  112. [SLEEPER:] VBA Email TO Cell that contains IF formula
  113. Vlookup to ListObject "Table copy, paste"
  114. [SOLVED:] Saving is not creating a new record line, but saving over it
  115. [SLEEPER:] VBA Help to change Form of Smart Art Nodes
  116. [SOLVED:] Finding Shape types WITHOUT selecting the shape ?
  117. How do I get one cell color to change based on another cell color that changes?
  118. Why do macros work once and then stop? Example is included
  119. [SOLVED:] Putting Values with Leading Zeros Into CSV file
  120. Copy data from user selected source file to current open workbook
  121. Using the TEXT function and Concatenate function in one formula
  122. How to Solve using CurrentRegion if cells in Table is Protected
  123. Copying values from one column in a sheet to another column in another sheet once.
  124. [SOLVED:] VBA - function Vlookup
  125. Can I add cell info into a comment box via a formula?
  126. VBA - Range of object _ Global failed
  127. [SLEEPER:] Error on saving workbook to dektop synced with OneDrive
  128. Lookup to add Products from one table to another VBA
  129. code to setup crop dimension
  130. Does anyone else have this error 1004?
  131. Picture shows in userform with search
  132. [SOLVED:] Fastest way to transform data
  133. [SOLVED:] show multiple separate information
  134. Retrieve formulas and autocomplete
  135. [SLEEPER:] Loop between two tables to sum their matches
  136. VBA - Problem in .range
  137. Log Scale graph in excel
  138. [SOLVED:] Formula to FIND specific TEXT within a worksheet
  139. how to create a portfolio Optimimizer using VBA
  140. [SOLVED:] Move data around in workbook
  141. Item number with current month
  142. Linear interpolation with lookup of two values
  143. Using VBA Set for workbook and worksheet
  144. VBA Code for Highlighting Cells based on If then Rules
  145. Create a Userform with a Textbox and link it to a Cell or Table
  146. VBA Code for PDF of Vibile Sheets in array
  147. Method 'SaveAs' of object'_Workbook failed
  148. [SOLVED:] Keycode 13 only for textbox input on userform
  149. [SOLVED:] Conditional Formatting borders around cells with formulas
  150. [SOLVED:] Making a function based on Find having IF
  151. Simple code that refreshes link to another excel file with Password
  152. [SOLVED:] Sort range from one empty row to the next empty row Custom
  153. [SOLVED:] Repeat Search Function
  154. [SOLVED:] Formula to format the cell? (so text gets enough space)
  155. Reference a cell.
  156. [SLEEPER:] Macro not working for fetching data from Active Directory
  157. After user clicks 'Notify', do this
  158. Unrecognized text on different computer
  159. [SLEEPER:] Compare the selected item of a listbox with a table
  160. errors on Macro code for consolidation
  161. How can we use VBA/Macros Excel for solving this interesting simulation question?
  162. [SOLVED:] Help with simplifying my background substraction (data analysis)
  163. Transferring data workbook to workbook
  164. Sleeper: VBA using Loop
  165. Sorting two way pivot table with VBA?
  166. Sleeper: Linear interpolation in Excel
  167. Sorting and cutting part of the sort into a new tab
  168. [SOLVED:] Msg error: "Exception from HRESULT:0x800401A8" when refreshing reports automatically
  169. [SOLVED:] Extract a number from text in cell using VBA
  170. [SOLVED:] IF Else statement not executing properly
  171. [SOLVED:] Pin Folder to Windows Explorers Quick Access in VBA
  172. VBA code
  173. [SOLVED:] Code only doing it for cell not entire column
  174. [SOLVED:] Can a Header
  175. Precedents arrows state
  176. Haven't encountered this before, what does it mean?
  177. Dynamic update for each userform textbox through looping
  178. How to make a macro work in selected worksheets and how to fix a macro error from CF
  179. Help duplicating from one cell onto multiple rows
  180. Modeless Form Closing
  181. [SOLVED:] Problem in concatenate
  182. Macro called from Menu no longer responding
  183. Break record row into multiple rows
  184. [SOLVED:] Can't loop a macro
  185. Insert Row & copy and paste formulas in new row
  186. [SOLVED:] Lookup values from a range with partial non-ordered keyword strings
  187. Creating a VBA to find and delete duplicate values within Excel workbook
  188. Reformat found data and count equal 'strings'
  189. Insertion range depends on meeting conditions
  190. [SOLVED:] How to add row in second Sheet using ActiveCell in first sheet?
  191. [SOLVED:] Impossible to insert
  192. Editable listview items
  193. VBA - Prompt To Save Excel File In Variable Location
  194. help with the debug
  195. [SOLVED:] Help to fine tune the codes | transform data, delete blank rows and then autofill
  196. Removing leading letters in a text using VBA
  197. Add some cell values as notes
  198. [SOLVED:] How to assign a worksheet change codes to a button to refresh the values
  199. Range Address Variables
  200. VBA Macro Sort Range
  201. Fiter, Copy and Paste unique values in the next available row of another workbook
  202. [SLEEPER:] Replacing hyperlinks with find and Replace
  203. Copy the last 3 columns
  204. [SOLVED:] VBA code to search on folder and sub folder for file named in worksheet
  205. How to cycle through control sheet in workbook
  206. [SOLVED:] Combinng Ranges into One
  207. Macro That Inserts a New Row and Defines Formulas to Cells
  208. Move To Top Of The Sheet
  209. Crossposting VBA Question - Overlapping Text Boxes with all Shapes
  210. Adding label for msoDropdown control type
  211. [SOLVED:] Copy the Last Row Within a Range and Paste to Last Row in Another Sheet
  212. Cannot get Application Caller to work
  213. excel help
  214. Function behaving differently
  215. Hide/unhide columns
  216. Noob question about Do-Until Loops
  217. DO NOT Copy Data Under Table/ Copy Data from Table to Table
  218. macro to add or subtract date and time from yyyymmdd_hhmmss format
  219. Need help with sending multiple .bcc from range in excel
  220. [SOLVED:] VBA doesn't compares correctly via greater than string comparison
  221. [SOLVED:] Multiple Individual Exclusive Checkboxes with data validation Macro (code here)
  222. [SOLVED:] autofocus on userform after print out
  223. [SLEEPER:] VBA - Flat Text Import Changes
  224. Filter for suffix [x] when a comparing file has _x suffix
  225. [SOLVED:] Help with Code to splitting values into 2 columns
  226. [SOLVED:] Small VBA Macro: introduce cell text into a CountIF formular and get output
  227. [SOLVED:] Shape Colors Updated per Cell Value (150 cells and shapes)
  228. Using a class module for several userforms, identify which userform is active
  229. [SOLVED:] vba code if lastrow is full, it errors out
  230. vba print 2 ranges in one page
  231. Transfer data from one work to another
  232. [SOLVED:] Scale display vba code
  233. [SOLVED:] Delete rows with previous dates
  234. [SOLVED:] Copy Multiple Range on Multiple Sheets.
  235. [SOLVED:] Code searches entire workbook-Need only specific coulmn + keep formatting after Paste
  236. [SOLVED:] Change active page of Vision object in Excel
  237. VBA Form Source List
  238. [SLEEPER:] How to calculate a route / find waypoints between start and destination
  239. Transfer specific columns from sheet to another
  240. [SOLVED:] Refresh custom formulars that checks background color and output as 1 or 0 (File here
  241. Convert ASCII code back to text with StrConv + vbUnicode (VBA)
  242. Quick VBA Question - Adding Another Condition - Use ElseIf?
  243. Need Help converting columns to YML format
  244. [SOLVED:] Help needed to count duplicates but derived by a column of values
  245. [SLEEPER:] A macro to show and hide specific rows in specific worksheets
  246. Finding duplicates in 6 columns by excel VBA
  247. [SOLVED:] Vlookup in Different Workbook - Sheet Looping
  248. Delete Button on UserForm won't Cooperate (Run-time error ‘1004’, Range Class Failed)
  249. Can Not Seem to Get If and ElesIf Statement to Work Correctly
  250. sampling -VBA code