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 174

  1. Create a loop in VBA to copy data out of different files (11 replies)
  2. [SOLVED:] Not Working : Sum of Hours (6 replies)
  3. [SOLVED:] Change format of ConvertDegrees function (11 replies)
  4. VBA Command (6 replies)
  5. product csv from sheets (1 replies)
  6. [SOLVED:] Searching for multiple texts within a cell (InStr) (7 replies)
  7. VBA help to stop one code from affecting another (6 replies)
  8. [SOLVED:] Comma separated list from columns (7 replies)
  9. [SOLVED:] Formula to collect charges (4 replies)
  10. [SOLVED:] Superscript in a Function (4 replies)
  11. Excel 2019: Range.Find(Number) Trouble (5 replies)
  12. VBA Help with Multiple If conditions (14 replies)
  13. Print sales transaction receipt error (0 replies)
  14. [SOLVED:] Trying to allow a TextBox entry on UserForm store in variable (10 replies)
  15. Autofilter help needed - encountering Autofilter method of range class failed error (0 replies)
  16. [SOLVED:] Not Working : Opening an Excel workbook from SharePoint in edit mode from a user form (1 replies)
  17. [SOLVED:] How to do sequencing number after rows duplicated (12 replies)
  18. [SOLVED:] VBA Text Comparisons Identifying Differences (2 replies)
  19. Office 365: Application.CommandBars("Workbook Tabs").ShowPopup issues (5 replies)
  20. [SOLVED:] Highlight Matching Text in different cells (3 replies)
  21. [SOLVED:] Request help to find missing dates in a date range for the user (12 replies)
  22. [SOLVED:] Search column for specific value, then delete rows found, leaving the first instance (6 replies)
  23. [SOLVED:] Trying to make specific cell contents bold (5 replies)
  24. VBA and Excel Formula (0 replies)
  25. Collecting Data From Multiple Users (2 replies)
  26. Import, Filter and Sort Multiple Columns (2 replies)
  27. Excel VBA shift selected cells in various columns up/down for a specified number cell (3 replies)
  28. [SOLVED:] Not Working : Worksheet_Change Event (7 replies)
  29. Find Specific Word from the cell by referring a list (VBA) (3 replies)
  30. Rows to hide and unhide based on two columns (2 replies)
  31. Find the duplicate from one work book and remove the duplicates in another workbook (10 replies)
  32. Help : Date Picker in VBA user form and view data from data entry wb (2 replies)
  33. How to read in server name, software name and version from a text file (6 replies)
  34. [SOLVED:] editing VBA code (10 replies)
  35. How to Handle Blank cell value in VBA (2 replies)
  36. [SOLVED:] Pivot Tables: error in 'Field.CurrentPage = NewCat' (31 replies)
  37. Loop through column, range.copy to another sheet based on cell value (1 replies)
  38. vba for mac book pro (0 replies)
  39. [SOLVED:] Difficulty Changing Data with a Hyphen "-" (4 replies)
  40. With PivotTable: Count consecutive days that meet a criteria (6 replies)
  41. Not Working : VBA : Create folder and access files from One Drive (1 replies)
  42. [SOLVED:] error 1004 - VBA Delete column (4 replies)
  43. Axis Ticklables to ObjectThemeColor (0 replies)
  44. delete blank cells in every row individually (2 replies)
  45. [SOLVED:] UCase Help (3 replies)
  46. [SOLVED:] search files across multiple sheets and open & highlight (2 replies)
  47. Search for a file in folder and subfolders (mac version) (2 replies)
  48. [SOLVED:] help for VBA conditional formating count on correct color (8 replies)
  49. Import Second Excel file (1 replies)
  50. VBA - seet 1 cell value (H2) to copy paste in activecell column c sheet 2 (0 replies)
  51. Update a new sheet from Userform (4 replies)
  52. [SOLVED:] create sheets based on extensions files and copy to each months (27 replies)
  53. [SOLVED:] Help : Compare texts in two columns in the same row and get the similarity percentage (11 replies)
  54. Help with VBA Macro (5 replies)
  55. [SOLVED:] Can you lock one filter in a pivot table? (19 replies)
  56. How to move data from one variable to another (5 replies)
  57. VBA - conditional copying different column ranges (2 replies)
  58. [SOLVED:] Hyperlink formulas in VBA code - one is working and one is not (4 replies)
  59. Extracting data from json api (5 replies)
  60. [SOLVED:] Move Duplicates to Result Sheet (2 replies)
  61. UP/DOWN/INSERT/DELETE macros part of line (14 replies)
  62. Problem with Charts (3 replies)
  63. Hi. Need to copy/cut rows from sheet to another at top of dataset (9 replies)
  64. [SOLVED:] Hide rows when check box selected (4 replies)
  65. VBA to open excel-sheets, updating link, saving and closing (0 replies)
  66. A function that crashes: Compile Error: Procedure too large (19 replies)
  67. [SOLVED:] Merge Workbooks into one - Help in Folder Picker (7 replies)
  68. Swap last and first word in a sentence in an excel column (7 replies)
  69. Transpose using VBA (1 replies)
  70. [SOLVED:] Macro help - matching times to periods (4 replies)
  71. [SOLVED:] How to know form Option button name or number (4 replies)
  72. Export to CSV with New Name and Time Stamp (1 replies)
  73. Nested classes with dynamic array (2 replies)
  74. regexp to find multiple instances of the same structure term? (1 replies)
  75. [SOLVED:] Hide rows with option buttons (29 replies)
  76. Read all Excel files in a folder and edit them via UI (2 replies)
  77. [SOLVED:] SharePoint and SaveCopyAs method (1 replies)
  78. [SOLVED:] Cell is equal to another cell until you write something in it (50 replies)
  79. Help needed for layout display after calculation. (7 replies)
  80. [SOLVED:] Fill in a row until bottom of the table (2 replies)
  81. [SOLVED:] Extract dates from a cell containing a string of data (10 replies)
  82. lookup between different worksheet. (2 replies)
  83. Need Help Creating a Macro (11 replies)
  84. Why will macro will move pdfs and xlsxs but not msgs? (2 replies)
  85. VBA-Import text file of yesterday's date which is the file name (1 replies)
  86. [SOLVED:] VBA to Limit what Columns a User can View--Question about Security (2 replies)
  87. date Macro (7 replies)
  88. [SOLVED:] Splitting large range of data into multiple cost center outputs in txt-format (11 replies)
  89. help with vba code (9 replies)
  90. [SOLVED:] File Format and Extension Don’t Match (7 replies)
  91. [SOLVED:] Count based on two criteria from different columns (8 replies)
  92. [SOLVED:] Loop thru validation list - filter multi sheets - generate individual files (2 replies)
  93. fastest way to copy multiple range to multiple sheets (25 replies)
  94. Copy Rows with Certain Values (0 replies)
  95. [SOLVED:] VBA Help - Run-time error '-2147417848 (80010108)': Method 'Value' of object 'Range' (6 replies)
  96. [SOLVED:] Add extra worksheet (5 replies)
  97. [SOLVED:] Code only copies certain column. (6 replies)
  98. Excel 2016 VBA on MAC to Open A File (0 replies)
  99. Password to save worksheet as new workbook (2 replies)
  100. Copy & Append Paste from various workbooks into one master (0 replies)
  101. Need Help Highliting Some String in Cell and Columns With Macro! (2 replies)
  102. [SOLVED:] Function to Pass Workbook and Worksheet objects giving Type Mismatch Error 13 (7 replies)
  103. [SOLVED:] TRANSACTION RATE NOT SHOWING (7 replies)
  104. [SOLVED:] Code not Executing in Immedate Window--Copy and Paste are Disabled (4 replies)
  105. Excel Maximum Rows (6 replies)
  106. VBA script to insert new rows based on data in other cells, then rearrange data (3 replies)
  107. [SLEEPER:] Userform refresh after change source cell (3 replies)
  108. Transaction Rate show up (0 replies)
  109. [SOLVED:] VBA Help in Cash flow forecast (9 replies)
  110. Autofilter in Multiple sheets - copy to new workbook - save workbook by field name (0 replies)
  111. HIDE UNHIDE automatically in others sheets (14 replies)
  112. Help with Excel Macro to computer investment return (2 replies)
  113. Excel VBA Code help (2 replies)
  114. [SOLVED:] Run time error 424 object required (1 replies)
  115. [SOLVED:] run time error 1004 Pastespecial method of range class failed (3 replies)
  116. [SOLVED:] run time error 13 Type mismatch (8 replies)
  117. C# to VBA macro in excel (4 replies)
  118. [SLEEPER:] ReTry (3 replies)
  119. [SOLVED:] Runtime Err 91 (3 replies)
  120. [SOLVED:] Flag if Value (2 replies)
  121. [SOLVED:] Run-time error 438: Object doesn't support this property or method (5 replies)
  122. [SOLVED:] How to refer to an existing Worksheet Name (9 replies)
  123. Can anybody please show me how to loop the following macro until a cell is empty (4 replies)
  124. [SOLVED:] VBA code for deleting "FALSE" functions (16 replies)
  125. How to copy values from multiple cells into one row in SAP (1 replies)
  126. Help me to pull random samples from the data source using VBA (1 replies)
  127. [SOLVED:] check calculation state on workbook open (6 replies)
  128. HMAC SHA1 algorithm (4 replies)
  129. Dependant ActiveX comboboxes filtering multiple pivot tables Issue (9 replies)
  130. Importing csv data from multiple source files into a master workbook into resp sheets (11 replies)
  131. VBA XLOOKUP to use text before semicolon (2 replies)
  132. VBA Calender - Add Date to Text Value instead of Activecell (5 replies)
  133. [SOLVED:] ActiveX Option Buttons No Longer Function After Hide Then Unhide Rows (5 replies)
  134. extracting a string from a line of text (13 replies)
  135. [SOLVED:] Pop-up Message Box when certain values are inputted in Column A (5 replies)
  136. vbModeless question (2 replies)
  137. [SOLVED:] Round Up the answer to a calculation which is being performed in VB (5 replies)
  138. [SOLVED:] Best way to use lookup to find last value in column of another sheet (3 replies)
  139. add a new row based on selected on combobox and copy data (0 replies)
  140. IF Then ElseIf Else Statement macro (17 replies)
  141. [SOLVED:] Several Groups of ActiveX Option Buttons - How to Identify Selected Button in Each (5 replies)
  142. [SOLVED:] Adding on to existing macro, Need IFS function and filter (0 replies)
  143. VBA Edit Links (34 replies)
  144. [SOLVED:] Is there a way to insert a permanent VBA userform to excel (4 replies)
  145. VBA Excel paste special speed reduces over time while looping (0 replies)
  146. [SOLVED:] Subscript error when finding next blank row in added worksheet (3 replies)
  147. Multiple conditions for 3 consecutive ListBox - How to make it work? (5 replies)
  148. Email Active workbook with updates made (1 replies)
  149. [SLEEPER:] Vba To Refresh Specific External Connections (3 replies)
  150. Conditional Format Macro help (2 replies)
  151. Change Pivot Table Date Filter to Cell Reference (2 replies)
  152. Newbie needs help please (1 replies)
  153. fifo vba code please (9 replies)
  154. [SOLVED:] Transpose Data In Columns (8 replies)
  155. [SOLVED:] LISTING FILES IN FOLDER - INCORRECT ORDER (17 replies)
  156. [SOLVED:] two way dependent dropdowns.. possible? (2 replies)
  157. VBA Help - Reference to a Table & Vlookup (3 replies)
  158. Based on the Location & Quantity, Locations to be grouped & corresponding sum (1 replies)
  159. Type mismatch when using Application.WorksheetFunction.Match (9 replies)
  160. [SLEEPER:] Combine recursive listing with excluded code (124 replies)
  161. Help with weighted averages for scorecard (10 replies)
  162. Graph two data tables in one graph (1 replies)
  163. Why Excel commandbutton macro is too slow? (8 replies)
  164. [SOLVED:] Loop through column and conditionally subtract (9 replies)
  165. Copy data from one sheet to new - but paste only values without formating and links (4 replies)
  166. [SOLVED:] Audit plan for next 3Yrs : Mark X based on audit frequency and previous audit quarter (9 replies)
  167. [SOLVED:] Excel Chart. Display rows based on check boxes (2 replies)
  168. Subtracting a cell from hard coded values (on weekly basis) (5 replies)
  169. [SOLVED:] Please Help with Code (15 replies)
  170. [SOLVED:] Search string multiple sheets copy row to new sheet (2 replies)
  171. Identify / return name of Visible Chart Only (0 replies)
  172. how to get value of page, where exact cell is? (0 replies)
  173. EXCEL VBA to show images as comments (19 replies)
  174. [SOLVED:] SEARCH COPY AND LINK THE RESULT (0 replies)
  175. [SOLVED:] Trying to create a Macro to filter a set of data for streamlined work (See descpt) (3 replies)
  176. Copying information from listbox into textboxes in new form (5 replies)
  177. [SOLVED:] Macro to match cells in a range with those in another column. (2 replies)
  178. [SOLVED:] Load Item In Combobox with Diffrent color (Depended cell Color) (2 replies)
  179. [SOLVED:] Split words from text string and count occurrence of each word in a range in excel (20 replies)
  180. [SLEEPER:] WHat I am doing wrong.... (10 replies)
  181. Saving file in specific location (2 replies)
  182. Converting / reading a cell while filtering ( double .. Ccur ... ) (12 replies)
  183. Copying Data Between Sheets (2 replies)
  184. [SOLVED:] Formula help to list items based on criteria (4 replies)
  185. Input box and sheet (3 replies)
  186. [SOLVED:] Create a list in column G if specific text found in cells in column A (3 replies)
  187. VBA Split Cell to Array + VLookUp for Array (9 replies)
  188. [SOLVED:] Determing if a time of day falls between time of shift (4 replies)
  189. SUM multiple COLUMNS DATA with common HEADER NAME (5 replies)
  190. [SLEEPER:] Hidden rows (5 replies)
  191. [SOLVED:] Split number from an alpha numeric invoice reference and highlight duplicate (2 replies)
  192. VBA userform multiple textbox (2 replies)
  193. Data validation - does not save =OFFSET(lista_rep!$C$5,0,0,COUNTA.... (10 replies)
  194. VBA Excel - Filter selection “wrong” row (1 replies)
  195. VBA - Macro - EXCell getting it to insert a formula (offset) (6 replies)
  196. [SOLVED:] How to Create UDF (12 replies)
  197. [SOLVED:] Date Entry Not Being Correctly Interpreted (21 replies)
  198. Merge different Excel worksheet from different workbooks into one workbook (3 replies)
  199. CLEARING A LISTBOX AND PRINTING LISTBOX CONTENTS (1 replies)
  200. VBA to add prefix in Human Interface Device RFID tag reader (0 replies)
  201. [SOLVED:] exclude folder paths list (37 replies)
  202. Calling a macro within a macro (2 replies)
  203. VBA to Insert a character in a specific position in a cell (13 replies)
  204. Excel - Formula to stop counting based on another cell (2 replies)
  205. VBA for copying values with ActiveCell.Offset (9 replies)
  206. [SOLVED:] Find And Replace with Increment Number Excel VBA (3 replies)
  207. Filter data - date range and customer (5 replies)
  208. Custom Dialog Box "Show" method causes runtime Error on some Excel installations (14 replies)
  209. Last row is not advancing in worksheet (4 replies)
  210. Copy cells in col. B, D and F if there is contents in cells in col. D (1 replies)
  211. VBA editing automatically comments in protected sheet (1 replies)
  212. VBA Excel - Update Data using UserForm (0 replies)
  213. VBA Excel - Use UserForm even if the sheet is protected (5 replies)
  214. [SOLVED:] Multiple textboxes that only accepts numeric value (7 replies)
  215. how to make '"table" stay in the same page? (0 replies)
  216. [SOLVED:] VBA for create new folder based on multiple cells values (0 replies)
  217. VBA UDF required (4 replies)
  218. [SOLVED:] Want VBA Textbox information to show VBA MsgBox (2 replies)
  219. Create a procedure with combination of keys (0 replies)
  220. remove rows and columns (6 replies)
  221. [SOLVED:] Check if data is already exist before adding a new data (3 replies)
  222. AN error 481: Invalid pictur (1 replies)
  223. [SOLVED:] A Dashboard with my first independent codes - Request for review by other members (8 replies)
  224. [SOLVED:] with VBA create a function that accepts arguments in an excel sheet (1 replies)
  225. Blinking Cells when I reach a certain value (0 replies)
  226. [SOLVED:] Unchecked checkbox if cell is blank (2 replies)
  227. dividing a number into a given range (4 replies)
  228. Userform Dependent List Boxes (9 replies)
  229. [SOLVED:] Search data on another sheet using VBA (5 replies)
  230. Slow code (5 replies)
  231. [SOLVED:] How to Create Interactive Dashboard Tiles (5 replies)
  232. [SOLVED:] how make rowsources for multiple combobox from multiple sheets in the same colums (12 replies)
  233. Creating new Files based on some excel columns values (0 replies)
  234. [SOLVED:] Change column (5 replies)
  235. [SOLVED:] Is it possible to make it faster? VBA copy and paste when condition is met (5 replies)
  236. Delete duplicates from VBA Combobox (3 replies)
  237. Array loop through multiple rows/columns, find result, then repeat.. Help Needed! (1 replies)
  238. [SLEEPER:] Basic VBA code Help (1 replies)
  239. Help - Macro to add data to workweeks (1 replies)
  240. [SOLVED:] Target.Cells.Count - Change to Read a Range - VBA (1 replies)
  241. [SOLVED:] macro to fill a form and save one file per row in document (3 replies)
  242. [SLEEPER:] 2019 VBA: How to move files based on first or first two characters (6 replies)
  243. help debugging macro for my daily time tracker - copy/paste sheet at front of wk_book (0 replies)
  244. Help required for the mentioned modification in the attached code -Manpower scheduler (1 replies)
  245. compatibility vba 2016 VS vba 2019 (4 replies)
  246. How can I add a condition in my loop that does not work? (0 replies)
  247. VBA Dynamic Loop in Columns and Rows to find and copy values (1 replies)
  248. [SOLVED:] Search in multiple columns while Autofiltering - Excel VBA (2 replies)
  249. Need help with loop, concatenate and trim in Excel, VBA (5 replies)
  250. [SOLVED:] Smaller font size for a part of the cell value in loop (7 replies)