Log in

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
  1. Combine recursive listing with excluded code (124 replies)
  2. Help with weighted averages for scorecard (10 replies)
  3. Graph two data tables in one graph (1 replies)
  4. Why Excel commandbutton macro is too slow? (8 replies)
  5. Loop through column and conditionally subtract (9 replies)
  6. Copy data from one sheet to new - but paste only values without formating and links (4 replies)
  7. [SOLVED:] Audit plan for next 3Yrs : Mark X based on audit frequency and previous audit quarter (9 replies)
  8. [SOLVED:] Excel Chart. Display rows based on check boxes (2 replies)
  9. Subtracting a cell from hard coded values (on weekly basis) (5 replies)
  10. [SOLVED:] Please Help with Code (15 replies)
  11. [SOLVED:] Search string multiple sheets copy row to new sheet (2 replies)
  12. Identify / return name of Visible Chart Only (0 replies)
  13. how to get value of page, where exact cell is? (0 replies)
  14. EXCEL VBA to show images as comments (19 replies)
  15. [SOLVED:] SEARCH COPY AND LINK THE RESULT (0 replies)
  16. [SOLVED:] Trying to create a Macro to filter a set of data for streamlined work (See descpt) (3 replies)
  17. Copying information from listbox into textboxes in new form (5 replies)
  18. [SOLVED:] Macro to match cells in a range with those in another column. (2 replies)
  19. [SOLVED:] Load Item In Combobox with Diffrent color (Depended cell Color) (2 replies)
  20. [SOLVED:] Split words from text string and count occurrence of each word in a range in excel (20 replies)
  21. WHat I am doing wrong.... (10 replies)
  22. Saving file in specific location (2 replies)
  23. Converting / reading a cell while filtering ( double .. Ccur ... ) (12 replies)
  24. Copying Data Between Sheets (2 replies)
  25. [SOLVED:] Formula help to list items based on criteria (4 replies)
  26. Input box and sheet (3 replies)
  27. [SOLVED:] Create a list in column G if specific text found in cells in column A (3 replies)
  28. VBA Split Cell to Array + VLookUp for Array (9 replies)
  29. [SOLVED:] Determing if a time of day falls between time of shift (4 replies)
  30. SUM multiple COLUMNS DATA with common HEADER NAME (5 replies)
  31. [SLEEPER:] Hidden rows (5 replies)
  32. [SOLVED:] Split number from an alpha numeric invoice reference and highlight duplicate (2 replies)
  33. VBA userform multiple textbox (2 replies)
  34. Data validation - does not save =OFFSET(lista_rep!$C$5,0,0,COUNTA.... (10 replies)
  35. VBA Excel - Filter selection “wrong” row (1 replies)
  36. VBA - Macro - EXCell getting it to insert a formula (offset) (6 replies)
  37. [SOLVED:] How to Create UDF (12 replies)
  38. [SOLVED:] Date Entry Not Being Correctly Interpreted (21 replies)
  39. Merge different Excel worksheet from different workbooks into one workbook (3 replies)
  40. CLEARING A LISTBOX AND PRINTING LISTBOX CONTENTS (1 replies)
  41. VBA to add prefix in Human Interface Device RFID tag reader (0 replies)
  42. [SOLVED:] exclude folder paths list (37 replies)
  43. Calling a macro within a macro (2 replies)
  44. VBA to Insert a character in a specific position in a cell (13 replies)
  45. Excel - Formula to stop counting based on another cell (2 replies)
  46. VBA for copying values with ActiveCell.Offset (9 replies)
  47. [SOLVED:] Find And Replace with Increment Number Excel VBA (3 replies)
  48. Filter data - date range and customer (5 replies)
  49. Custom Dialog Box "Show" method causes runtime Error on some Excel installations (14 replies)
  50. Last row is not advancing in worksheet (4 replies)
  51. Copy cells in col. B, D and F if there is contents in cells in col. D (1 replies)
  52. VBA editing automatically comments in protected sheet (1 replies)
  53. VBA Excel - Update Data using UserForm (0 replies)
  54. VBA Excel - Use UserForm even if the sheet is protected (5 replies)
  55. [SOLVED:] Multiple textboxes that only accepts numeric value (7 replies)
  56. how to make '"table" stay in the same page? (0 replies)
  57. [SOLVED:] VBA for create new folder based on multiple cells values (0 replies)
  58. VBA UDF required (4 replies)
  59. [SOLVED:] Want VBA Textbox information to show VBA MsgBox (2 replies)
  60. Create a procedure with combination of keys (0 replies)
  61. remove rows and columns (6 replies)
  62. [SOLVED:] Check if data is already exist before adding a new data (3 replies)
  63. AN error 481: Invalid pictur (1 replies)
  64. [SOLVED:] A Dashboard with my first independent codes - Request for review by other members (8 replies)
  65. [SOLVED:] with VBA create a function that accepts arguments in an excel sheet (1 replies)
  66. Blinking Cells when I reach a certain value (0 replies)
  67. [SOLVED:] Unchecked checkbox if cell is blank (2 replies)
  68. dividing a number into a given range (4 replies)
  69. Userform Dependent List Boxes (9 replies)
  70. [SOLVED:] Search data on another sheet using VBA (5 replies)
  71. Slow code (5 replies)
  72. [SOLVED:] How to Create Interactive Dashboard Tiles (5 replies)
  73. [SOLVED:] how make rowsources for multiple combobox from multiple sheets in the same colums (12 replies)
  74. Creating new Files based on some excel columns values (0 replies)
  75. [SOLVED:] Change column (5 replies)
  76. [SOLVED:] Is it possible to make it faster? VBA copy and paste when condition is met (5 replies)
  77. Delete duplicates from VBA Combobox (3 replies)
  78. Array loop through multiple rows/columns, find result, then repeat.. Help Needed! (1 replies)
  79. Basic VBA code Help (1 replies)
  80. Help - Macro to add data to workweeks (1 replies)
  81. [SOLVED:] Target.Cells.Count - Change to Read a Range - VBA (1 replies)
  82. [SOLVED:] macro to fill a form and save one file per row in document (3 replies)
  83. 2019 VBA: How to move files based on first or first two characters (6 replies)
  84. help debugging macro for my daily time tracker - copy/paste sheet at front of wk_book (0 replies)
  85. Help required for the mentioned modification in the attached code -Manpower scheduler (1 replies)
  86. compatibility vba 2016 VS vba 2019 (4 replies)
  87. How can I add a condition in my loop that does not work? (0 replies)
  88. VBA Dynamic Loop in Columns and Rows to find and copy values (1 replies)
  89. [SOLVED:] Search in multiple columns while Autofiltering - Excel VBA (2 replies)
  90. Need help with loop, concatenate and trim in Excel, VBA (5 replies)
  91. [SOLVED:] Smaller font size for a part of the cell value in loop (7 replies)
  92. Error in user form (5 replies)
  93. range sort horizontal range (5 replies)
  94. Filling out specific cells thanks to a UserForm (0 replies)
  95. How can I use the VBA-Excel function NORMINV with variables? (3 replies)
  96. help with UDF Function (35 replies)
  97. [SOLVED:] A simple VBA "for each" loop with "call" function issue (3 replies)
  98. [SOLVED:] Help : Replace O365 Dynamic Arrays Dashboard with VBA Codes (2 replies)
  99. How to search through multiple worksheets and display the results to your listbox (1 replies)
  100. Move Files from current folder to a new subfolder specified in a column (4 replies)
  101. RE: Pivot filter Month selection - Automatic Population in respective column (6 replies)
  102. VBA code to filter a specific column (0 replies)
  103. Paste data to another tab based on meeting criteria (3 replies)
  104. Automatic update of pivot table wiht error - EXCEL (0 replies)
  105. Blinking Cells when I reach a certain value (4 replies)
  106. Extracting specific lines from multiple text files and save it in a single excel shee (2 replies)
  107. Paste without source file name (4 replies)
  108. Data to blank cell (0 replies)
  109. Excel Macro help (2 replies)
  110. Copy Paste Selected Rows (1 replies)
  111. Left/Right formula not working (18 replies)
  112. [SOLVED:] Help : Stop Application.onTime before this workbook close (3 replies)
  113. [SOLVED:] Stop macro running if row empty (2 replies)
  114. Prevent VBA from activating the sheet when it updates a chart. (0 replies)
  115. [SOLVED:] Predict Date of Enlistment (53 replies)
  116. [SOLVED:] Copying Down Formulas to New Row (9 replies)
  117. Sleeper: Filtering by some specific value (0 replies)
  118. [SOLVED:] Advanced locked Filtering data (0 replies)
  119. I want to copy and paste a chart together with its linked-to data? (1 replies)
  120. Log the results (29 replies)
  121. Help to moving file to another folder, using partial filename (0 replies)
  122. [SOLVED:] Search worksheet for multiple strings of text, then delete those rows (29 replies)
  123. [SOLVED:] Extract Value from Text (3 replies)
  124. [SOLVED:] Condition Base Min & Max (2 replies)
  125. PasteSpecial options (2 replies)
  126. Populate fields based on the filter (8 replies)
  127. [SOLVED:] Need some help with the Regular Expression (2 replies)
  128. VBA form - Choose an item from 2 list boxes to select one row (0 replies)
  129. Count left alignment cell (2 replies)
  130. [SOLVED:] VBA Conditional Formating - Cell 1 format based on Cell2 <= other worksheet cell3 (14 replies)
  131. Adding and Compressing(SizeKb) Image to Comments Field (2 replies)
  132. Vba search function not pulling links through. (4 replies)
  133. [SOLVED:] Search for specific words in worksheet and make bold (1 replies)
  134. Web scrapping vba (0 replies)
  135. Macro to create a database (3 replies)
  136. [SOLVED:] Execute submacro a set number of times until criteria is met (4 replies)
  137. Convert numbers into words for printing checks (1 replies)
  138. Automatic changing of cell colors (1 replies)
  139. Need Help with VBA code - Excel (7 replies)
  140. Please Help ( vba combobox code ) (1 replies)
  141. [SOLVED:] Highlight Cell With Search Values (4 replies)
  142. found max number (1 replies)
  143. Help with some code? (1 replies)
  144. [SOLVED:] Passing variables between modules (8 replies)
  145. Copy data from folder and sub folder to master workbook base in sub folder names (0 replies)
  146. Advanced find mewthod with copying values (0 replies)
  147. How to parse json GET request with VBA? (3 replies)
  148. [SOLVED:] VBA code to speed up and automate multiple account, multiple site stock movements (26 replies)
  149. [SOLVED:] How to compare two arrays row by row? (16 replies)
  150. [SOLVED:] Help : Join String with Delimiter - need to have the option of downward or rightward (18 replies)
  151. Replace XML Null values (0 replies)
  152. [SOLVED:] Help : Apply formula to selected cells (2 replies)
  153. Limit Detailed amounts based on original balance (4 replies)
  154. [SOLVED:] Run Submacro If It Contains Data (23 replies)
  155. [SOLVED:] How far is the first occurrence of a coloured cell (2 replies)
  156. VBA Exponential Smoothing (8 replies)
  157. [SOLVED:] Left align text in joined cells (4 replies)
  158. [SOLVED:] Help Required : Highlight a part of text with in a cell (case sensitive problem) (2 replies)
  159. [SOLVED:] Run-time error '13' after several succes runs (3 replies)
  160. [SOLVED:] Help required in replacing InputBox with Select any one option (2 replies)
  161. [SOLVED:] Create a Hardcoded Workbook Copy (11 replies)
  162. amending code copy data from sheet to multiple without repeating (4 replies)
  163. Can’t find project or library - Microsoft Forms 2.0 ticked in error? (22 replies)
  164. [SOLVED:] Find each occurrence of a set of numbers in column and highlight the rows that contai (4 replies)
  165. sum only red fonts (5 replies)
  166. SUMIFS with Multiple criteria using Variables (4 replies)
  167. [SOLVED:] Difference between two 2D Arrays in VBA (10 replies)
  168. [SOLVED:] Fields mandatory (9 replies)
  169. [SOLVED:] Search Textbox (2 replies)
  170. COPY CERTAIN COLUMN IF ROW CONTAINS CERTAIN DATA FROM EXCEL TO WORD (1 replies)
  171. [SOLVED:] Looking in subfolders instead of root folder only (9 replies)
  172. [SOLVED:] filter and sum values based on three selection from dropdown (18 replies)
  173. [SOLVED:] Standard CTRL+C in ListBox (7 replies)
  174. [SOLVED:] VBA Macro - Import data from different excel file for a given value (3 replies)
  175. [SOLVED:] VBA for find values in range in multiple worksheets, copy values to UserForm (5 replies)
  176. automatic sort of a table, return to last used cell (2 replies)
  177. Delete Columns with blank or zero in total (2 replies)
  178. [SOLVED:] VBA Macro - pull two data sets, in the same column, to a separate spreadsheet (5 replies)
  179. [SOLVED:] Filter a txt file based on an Excel template (11 replies)
  180. VBA Help - Auto generate multiple rows base on cell value (3 replies)
  181. Help Required in Create and Open Folder and Track Changes (2 replies)
  182. VBA/Macro to insert rows based on drop downlist selection (4 replies)
  183. Finding the best rank of places to find the best path (using geographical coordinates (3 replies)
  184. [SOLVED:] VBA Check for multiple cell values and copy the cell in column A (6 replies)
  185. HELP!! CHALLENGING: FINDING BEST PATH TO TAKE (1 replies)
  186. vba help - show Top 3 performer (3 replies)
  187. [SOLVED:] Table Of Contents - Help required to customize the code (7 replies)
  188. Create user input box for range row in Excel (1 replies)
  189. VBA to search for different value in all worksheets and then write down where they ar (6 replies)
  190. [SOLVED:] Vba look for certain value and copy certain cell value in the same row (3 replies)
  191. Restrict Replace Module (12 replies)
  192. [SOLVED:] Requesting help to correct the codes (4 replies)
  193. Conflicting Code (Add Row & Move Row to another Worksheet) (5 replies)
  194. How to move data between date rows using VBA? (5 replies)
  195. [SOLVED:] Paste to next empty row in another workbook (3 replies)
  196. [SOLVED:] VBA to add new row above and include formatting (2 replies)
  197. save from template to range value name workbook (1 replies)
  198. Sum with integer (5 replies)
  199. [SOLVED:] Delete Hidden Rows when Filter applied (2 replies)
  200. [SOLVED:] VBA Sum function NOT calculating small values (3 replies)
  201. Converting three calculators in a workbook into one with a dropdown box (hardcoded) (7 replies)
  202. Disable SAVE/SAVE AS and Make Savable Again after Username and Password (12 replies)
  203. Array of unique values in a Column range (18 replies)
  204. VBA (1 replies)
  205. Formula Assistance Required (2 replies)
  206. [SOLVED:] Creating an 11 digit number (14 replies)
  207. Macro to copy a cell value and put in different worksheet (0 replies)
  208. What function should I use? (7 replies)
  209. Truncate Data in Excel VBA to prompt Pass or Fail (6 replies)
  210. Auto Filter Data from Multiple Worksheets Using only One Combobox (6 replies)
  211. Trouble sorting as part of a Macro (5 replies)
  212. Generating a table of events based on a calendar on a different worksheet (2 replies)
  213. Is there a way to protect or lock my macro? (2 replies)
  214. How to hide/unhide worksheets based on cell value? (0 replies)
  215. excel to pdf print (10 replies)
  216. [SOLVED:] HELP - Calculate Based on Dynamic Variables (What-if Scenario) (5 replies)
  217. [SOLVED:] Debugging VBA built on Excel2013 not working on v2016 (3 replies)
  218. VBA Code Copy&Paste Request (5 replies)
  219. [SOLVED:] RE: Pivot table creation in existing sheet- VBA issues (19 replies)
  220. VBA look for cell next to first blank, copy and paste (3 replies)
  221. Macro to find best way to combine numbers to equal a certain sum (3 replies)
  222. [SOLVED:] VBA code to calculate dates from an event (2 replies)
  223. [SOLVED:] Object Required Error in UnHiding rows (6 replies)
  224. Change alignment (4 replies)
  225. VBA code to open workbooks in a folder, create new sheet, paste headers and formulas? (4 replies)
  226. VBA Time Stamp for single cell entry (1 replies)
  227. Xlsm file problem (7 replies)
  228. [SOLVED:] Custom Sort On Column (7 replies)
  229. VBA Sum Array Formulas (13 replies)
  230. Sleeper: VBA Macros 438 runtime error (1 replies)
  231. [SOLVED:] Function for checking and opening a workbook (6 replies)
  232. Extract and move records , then delete from master sheet (0 replies)
  233. How to fix a messed Excel sheet and make a proper format? (1 replies)
  234. [SOLVED:] Drag tool to adjust formulas correctly (1 replies)
  235. [SOLVED:] VBA Disbale Copy&Paste in target range (not complete sheet/workbook) (3 replies)
  236. How to create a macro that puts today's date and time in cell (7 replies)
  237. Type Mismatch error when there is no type mismatch (2 replies)
  238. Expand VBA code to search Column & Paste Cells to Other Sheet (3 replies)
  239. Use a master list to run a macro that opens, extracts, and closes multiple workbooks (4 replies)
  240. VBA help on pulling data from an external workbook (3 replies)
  241. [SOLVED:] VBA Index Match across two worksheets (2 replies)
  242. VBA conks out on very simple code (15 replies)
  243. Upper Case (2 replies)
  244. [SOLVED:] Convert Excel Cell Text in Bold or Italic to HTML Tags/Convert Cell Line Breaks (32 replies)
  245. [SOLVED:] Need VBA Help With the following info (4 replies)
  246. Filter/paste rows by months in the near future (0 replies)
  247. [SOLVED:] Like Operator (2 replies)
  248. Last save time (8 replies)
  249. Could use some VB help with dealing with combo box data from a Union All query (5 replies)
  250. Scroll Bar (Form Control) Offset Table - Sync Scroll Bar Pos. Across Multiple Sheets (5 replies)