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. Restrict Replace Module
  2. [SOLVED:] Vba look for certain value and copy certain cell value in the same row
  3. VBA to search for different value in all worksheets and then write down where they ar
  4. Create user input box for range row in Excel
  5. [SOLVED:] Table Of Contents - Help required to customize the code
  6. vba help - show Top 3 performer
  7. HELP!! CHALLENGING: FINDING BEST PATH TO TAKE
  8. [SOLVED:] VBA Check for multiple cell values and copy the cell in column A
  9. Finding the best rank of places to find the best path (using geographical coordinates
  10. VBA/Macro to insert rows based on drop downlist selection
  11. Help Required in Create and Open Folder and Track Changes
  12. VBA Help - Auto generate multiple rows base on cell value
  13. [SOLVED:] Filter a txt file based on an Excel template
  14. [SOLVED:] VBA Macro - pull two data sets, in the same column, to a separate spreadsheet
  15. Delete Columns with blank or zero in total
  16. automatic sort of a table, return to last used cell
  17. [SOLVED:] VBA for find values in range in multiple worksheets, copy values to UserForm
  18. [SOLVED:] VBA Macro - Import data from different excel file for a given value
  19. [SOLVED:] Standard CTRL+C in ListBox
  20. [SOLVED:] filter and sum values based on three selection from dropdown
  21. [SOLVED:] Looking in subfolders instead of root folder only
  22. COPY CERTAIN COLUMN IF ROW CONTAINS CERTAIN DATA FROM EXCEL TO WORD
  23. [SOLVED:] Search Textbox
  24. [SOLVED:] Fields mandatory
  25. [SOLVED:] Difference between two 2D Arrays in VBA
  26. SUMIFS with Multiple criteria using Variables
  27. sum only red fonts
  28. [SOLVED:] Find each occurrence of a set of numbers in column and highlight the rows that contai
  29. Can’t find project or library - Microsoft Forms 2.0 ticked in error?
  30. amending code copy data from sheet to multiple without repeating
  31. [SOLVED:] Create a Hardcoded Workbook Copy
  32. [SOLVED:] Help required in replacing InputBox with Select any one option
  33. [SOLVED:] Run-time error '13' after several succes runs
  34. [SOLVED:] Help Required : Highlight a part of text with in a cell (case sensitive problem)
  35. [SOLVED:] Left align text in joined cells
  36. VBA Exponential Smoothing
  37. [SOLVED:] How far is the first occurrence of a coloured cell
  38. [SOLVED:] Run Submacro If It Contains Data
  39. Limit Detailed amounts based on original balance
  40. [SOLVED:] Help : Apply formula to selected cells
  41. Replace XML Null values
  42. [SOLVED:] Help : Join String with Delimiter - need to have the option of downward or rightward
  43. [SOLVED:] How to compare two arrays row by row?
  44. [SOLVED:] VBA code to speed up and automate multiple account, multiple site stock movements
  45. [SLEEPER:] How to parse json GET request with VBA?
  46. Advanced find mewthod with copying values
  47. Copy data from folder and sub folder to master workbook base in sub folder names
  48. [SOLVED:] Passing variables between modules
  49. Help with some code?
  50. [SLEEPER:] Found max number
  51. [SOLVED:] Highlight Cell With Search Values
  52. Please Help ( vba combobox code )
  53. Need Help with VBA code - Excel
  54. Automatic changing of cell colors
  55. Convert numbers into words for printing checks
  56. [SOLVED:] Execute submacro a set number of times until criteria is met
  57. Macro to create a database
  58. Web scrapping vba
  59. [SOLVED:] Search for specific words in worksheet and make bold
  60. Vba search function not pulling links through.
  61. Adding and Compressing(SizeKb) Image to Comments Field
  62. [SOLVED:] VBA Conditional Formating - Cell 1 format based on Cell2 <= other worksheet cell3
  63. Count left alignment cell
  64. VBA form - Choose an item from 2 list boxes to select one row
  65. [SOLVED:] Need some help with the Regular Expression
  66. Populate fields based on the filter
  67. PasteSpecial options
  68. [SOLVED:] Condition Base Min & Max
  69. [SOLVED:] Extract Value from Text
  70. [SOLVED:] Search worksheet for multiple strings of text, then delete those rows
  71. Help to moving file to another folder, using partial filename
  72. Log the results
  73. I want to copy and paste a chart together with its linked-to data?
  74. [SOLVED:] Advanced locked Filtering data
  75. Sleeper: Filtering by some specific value
  76. [SOLVED:] Copying Down Formulas to New Row
  77. [SOLVED:] Predict Date of Enlistment
  78. Prevent VBA from activating the sheet when it updates a chart.
  79. [SOLVED:] Stop macro running if row empty
  80. [SOLVED:] Help : Stop Application.onTime before this workbook close
  81. Left/Right formula not working
  82. Copy Paste Selected Rows
  83. Excel Macro help
  84. Data to blank cell
  85. Paste without source file name
  86. Extracting specific lines from multiple text files and save it in a single excel shee
  87. Blinking Cells when I reach a certain value
  88. Automatic update of pivot table wiht error - EXCEL
  89. Paste data to another tab based on meeting criteria
  90. VBA code to filter a specific column
  91. RE: Pivot filter Month selection - Automatic Population in respective column
  92. Move Files from current folder to a new subfolder specified in a column
  93. How to search through multiple worksheets and display the results to your listbox
  94. [SOLVED:] Help : Replace O365 Dynamic Arrays Dashboard with VBA Codes
  95. [SOLVED:] A simple VBA "for each" loop with "call" function issue
  96. help with UDF Function
  97. How can I use the VBA-Excel function NORMINV with variables?
  98. [SLEEPER:] Filling out specific cells thanks to a UserForm
  99. range sort horizontal range
  100. Error in user form
  101. [SOLVED:] Smaller font size for a part of the cell value in loop
  102. Need help with loop, concatenate and trim in Excel, VBA
  103. [SOLVED:] Search in multiple columns while Autofiltering - Excel VBA
  104. VBA Dynamic Loop in Columns and Rows to find and copy values
  105. How can I add a condition in my loop that does not work?
  106. compatibility vba 2016 VS vba 2019
  107. Help required for the mentioned modification in the attached code -Manpower scheduler
  108. help debugging macro for my daily time tracker - copy/paste sheet at front of wk_book
  109. [SLEEPER:] 2019 VBA: How to move files based on first or first two characters
  110. [SOLVED:] macro to fill a form and save one file per row in document
  111. [SOLVED:] Target.Cells.Count - Change to Read a Range - VBA
  112. Help - Macro to add data to workweeks
  113. [SLEEPER:] Basic VBA code Help
  114. Array loop through multiple rows/columns, find result, then repeat.. Help Needed!
  115. Delete duplicates from VBA Combobox
  116. [SOLVED:] Is it possible to make it faster? VBA copy and paste when condition is met
  117. [SOLVED:] Change column
  118. Creating new Files based on some excel columns values
  119. [SOLVED:] how make rowsources for multiple combobox from multiple sheets in the same colums
  120. [SOLVED:] How to Create Interactive Dashboard Tiles
  121. Slow code
  122. [SOLVED:] Search data on another sheet using VBA
  123. Userform Dependent List Boxes
  124. dividing a number into a given range
  125. [SOLVED:] Unchecked checkbox if cell is blank
  126. Blinking Cells when I reach a certain value
  127. [SOLVED:] with VBA create a function that accepts arguments in an excel sheet
  128. [SOLVED:] A Dashboard with my first independent codes - Request for review by other members
  129. AN error 481: Invalid pictur
  130. [SOLVED:] Check if data is already exist before adding a new data
  131. remove rows and columns
  132. Create a procedure with combination of keys
  133. [SOLVED:] Want VBA Textbox information to show VBA MsgBox
  134. VBA UDF required
  135. [SOLVED:] VBA for create new folder based on multiple cells values
  136. how to make '"table" stay in the same page?
  137. [SOLVED:] Multiple textboxes that only accepts numeric value
  138. VBA Excel - Use UserForm even if the sheet is protected
  139. VBA Excel - Update Data using UserForm
  140. VBA editing automatically comments in protected sheet
  141. Copy cells in col. B, D and F if there is contents in cells in col. D
  142. Last row is not advancing in worksheet
  143. Custom Dialog Box "Show" method causes runtime Error on some Excel installations
  144. Filter data - date range and customer
  145. [SOLVED:] Find And Replace with Increment Number Excel VBA
  146. VBA for copying values with ActiveCell.Offset
  147. Excel - Formula to stop counting based on another cell
  148. VBA to Insert a character in a specific position in a cell
  149. Calling a macro within a macro
  150. [SOLVED:] exclude folder paths list
  151. VBA to add prefix in Human Interface Device RFID tag reader
  152. CLEARING A LISTBOX AND PRINTING LISTBOX CONTENTS
  153. Merge different Excel worksheet from different workbooks into one workbook
  154. [SOLVED:] Date Entry Not Being Correctly Interpreted
  155. [SOLVED:] How to Create UDF
  156. VBA - Macro - EXCell getting it to insert a formula (offset)
  157. VBA Excel - Filter selection “wrong” row
  158. Data validation - does not save =OFFSET(lista_rep!$C$5,0,0,COUNTA....
  159. VBA userform multiple textbox
  160. [SOLVED:] Split number from an alpha numeric invoice reference and highlight duplicate
  161. [SLEEPER:] Hidden rows
  162. SUM multiple COLUMNS DATA with common HEADER NAME
  163. [SOLVED:] Determing if a time of day falls between time of shift
  164. VBA Split Cell to Array + VLookUp for Array
  165. [SOLVED:] Create a list in column G if specific text found in cells in column A
  166. Input box and sheet
  167. [SOLVED:] Formula help to list items based on criteria
  168. Copying Data Between Sheets
  169. Converting / reading a cell while filtering ( double .. Ccur ... )
  170. Saving file in specific location
  171. [SLEEPER:] WHat I am doing wrong....
  172. [SOLVED:] Split words from text string and count occurrence of each word in a range in excel
  173. [SOLVED:] Load Item In Combobox with Diffrent color (Depended cell Color)
  174. [SOLVED:] Macro to match cells in a range with those in another column.
  175. Copying information from listbox into textboxes in new form
  176. [SOLVED:] Trying to create a Macro to filter a set of data for streamlined work (See descpt)
  177. [SOLVED:] SEARCH COPY AND LINK THE RESULT
  178. EXCEL VBA to show images as comments
  179. how to get value of page, where exact cell is?
  180. Identify / return name of Visible Chart Only
  181. [SOLVED:] Search string multiple sheets copy row to new sheet
  182. [SOLVED:] Please Help with Code
  183. Subtracting a cell from hard coded values (on weekly basis)
  184. [SOLVED:] Excel Chart. Display rows based on check boxes
  185. [SOLVED:] Audit plan for next 3Yrs : Mark X based on audit frequency and previous audit quarter
  186. Copy data from one sheet to new - but paste only values without formating and links
  187. [SOLVED:] Loop through column and conditionally subtract
  188. Why Excel commandbutton macro is too slow?
  189. Graph two data tables in one graph
  190. Help with weighted averages for scorecard
  191. [SLEEPER:] Combine recursive listing with excluded code
  192. Type mismatch when using Application.WorksheetFunction.Match
  193. Based on the Location & Quantity, Locations to be grouped & corresponding sum
  194. VBA Help - Reference to a Table & Vlookup
  195. [SOLVED:] two way dependent dropdowns.. possible?
  196. [SOLVED:] LISTING FILES IN FOLDER - INCORRECT ORDER
  197. [SOLVED:] Transpose Data In Columns
  198. fifo vba code please
  199. Newbie needs help please
  200. Change Pivot Table Date Filter to Cell Reference
  201. Conditional Format Macro help
  202. [SLEEPER:] Vba To Refresh Specific External Connections
  203. Email Active workbook with updates made
  204. Multiple conditions for 3 consecutive ListBox - How to make it work?
  205. [SOLVED:] Subscript error when finding next blank row in added worksheet
  206. VBA Excel paste special speed reduces over time while looping
  207. [SOLVED:] Is there a way to insert a permanent VBA userform to excel
  208. VBA Edit Links
  209. [SOLVED:] Adding on to existing macro, Need IFS function and filter
  210. [SOLVED:] Several Groups of ActiveX Option Buttons - How to Identify Selected Button in Each
  211. IF Then ElseIf Else Statement macro
  212. add a new row based on selected on combobox and copy data
  213. [SOLVED:] Best way to use lookup to find last value in column of another sheet
  214. [SOLVED:] Round Up the answer to a calculation which is being performed in VB
  215. vbModeless question
  216. [SOLVED:] Pop-up Message Box when certain values are inputted in Column A
  217. extracting a string from a line of text
  218. [SOLVED:] ActiveX Option Buttons No Longer Function After Hide Then Unhide Rows
  219. VBA Calender - Add Date to Text Value instead of Activecell
  220. VBA XLOOKUP to use text before semicolon
  221. Importing csv data from multiple source files into a master workbook into resp sheets
  222. Dependant ActiveX comboboxes filtering multiple pivot tables Issue
  223. HMAC SHA1 algorithm
  224. [SOLVED:] check calculation state on workbook open
  225. Help me to pull random samples from the data source using VBA
  226. How to copy values from multiple cells into one row in SAP
  227. [SOLVED:] VBA code for deleting "FALSE" functions
  228. Can anybody please show me how to loop the following macro until a cell is empty
  229. [SOLVED:] How to refer to an existing Worksheet Name
  230. [SOLVED:] Run-time error 438: Object doesn't support this property or method
  231. [SOLVED:] Flag if Value
  232. [SOLVED:] Runtime Err 91
  233. [SLEEPER:] ReTry
  234. C# to VBA macro in excel
  235. [SOLVED:] run time error 13 Type mismatch
  236. [SOLVED:] run time error 1004 Pastespecial method of range class failed
  237. [SOLVED:] Run time error 424 object required
  238. Excel VBA Code help
  239. Help with Excel Macro to computer investment return
  240. HIDE UNHIDE automatically in others sheets
  241. Autofilter in Multiple sheets - copy to new workbook - save workbook by field name
  242. [SOLVED:] VBA Help in Cash flow forecast
  243. Transaction Rate show up
  244. [SLEEPER:] Userform refresh after change source cell
  245. VBA script to insert new rows based on data in other cells, then rearrange data
  246. Excel Maximum Rows
  247. [SOLVED:] Code not Executing in Immedate Window--Copy and Paste are Disabled
  248. [SOLVED:] TRANSACTION RATE NOT SHOWING
  249. [SOLVED:] Function to Pass Workbook and Worksheet objects giving Type Mismatch Error 13
  250. Need Help Highliting Some String in Cell and Columns With Macro!