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. How to close it (0 replies)
  2. vba help - Count only Alphabets from a string using Regular expression (5 replies)
  3. Automate a Pivot Using VBA (0 replies)
  4. What's wrong with this code? (2 replies)
  5. what's going wrong with the code (5 replies)
  6. VBA Bold Text (1 replies)
  7. Excel Formula : =MIN(IF) (2 replies)
  8. [SOLVED:] To Copy and Split the Name to First and Surname from Another Workbook (5 replies)
  9. [SOLVED:] Date Increasing (17 replies)
  10. EXCEL VBA - Dependent FORM Drop Downs & Excel Tables (7 replies)
  11. Vba if iserror issue with vlookup (3 replies)
  12. Merge Workbooks based on Number of Row of Data (14 replies)
  13. Need Help Finding Specific Cells and Determining if there are values in it or not (6 replies)
  14. Script not Running (6 replies)
  15. [SOLVED:] Excel cannot access 'ExcelVB' (17 replies)
  16. [SOLVED:] Counting the occurrence of each entry in a column (2 replies)
  17. listview background color (0 replies)
  18. [SOLVED:] Shared Workbooks with Hidden Tabs (2 replies)
  19. Shift pattern conversion (1 replies)
  20. Efficient Way of Copying Data from an Input Sheet to a Database (7 replies)
  21. Vba : copy Transpose in 2 differents rows (2 replies)
  22. [SOLVED:] Need help fixing/understanding Macro (3 replies)
  23. [SOLVED:] Close All Instances Of Excel Without Saving Any Changes (27 replies)
  24. Conditionally Filter chart categories according to the x-axis labels (0 replies)
  25. Macro to Look for Specific text in other workbook and report value in cell beneath it (3 replies)
  26. [SOLVED:] Cannot control the popup window (4 replies)
  27. Copying sheets and updating values from a main sheet (1 replies)
  28. Matching the data. (1 replies)
  29. show and hide photos with formula (0 replies)
  30. VBA Macro Causing Excel to Freeze When 2nd Copy of Sheet Added to Workbook (1 replies)
  31. VBA to merge multiple workbooks with demarcation (9 replies)
  32. Worksheet_Change multiple ranges and different formulas (19 replies)
  33. [SOLVED:] VBA to Delete Duplicate Info on Same Date (1 replies)
  34. delete folders on search (10 replies)
  35. Close and save changes in one workbook from another. (1 replies)
  36. Selection Change where a merged cell is involved (6 replies)
  37. [SOLVED:] Count Dates in a List of dates for every employee for every month (3 replies)
  38. Help VBA CODE to include negatives in the loop calculation (1 replies)
  39. Auto Update Excel Data (0 replies)
  40. Find Form Controls with Value not set (7 replies)
  41. [SOLVED:] copy data with pushbutton (5 replies)
  42. Copying and pasting values into a table below the previous entry for many days (3 replies)
  43. Sumif with integer and from another sheet (1 replies)
  44. [SOLVED:] Change sheet tab color automatically based on cell values (5 replies)
  45. Import XML to worksheet with mapped schema (0 replies)
  46. [SOLVED:] Exel crash when VBA frames manipulation (5 replies)
  47. How to get the number of instances of a class (5 replies)
  48. how can i create userform using simpson rule for a function in excel vba (0 replies)
  49. [SOLVED:] VBA “folder” sorter (8 replies)
  50. Click IE Popup window (0 replies)
  51. Copy some data from one Sheet to another and create a list (7 replies)
  52. [SOLVED:] Select Sheets Starting with "XXXX" and Remove Macro from Sheet (7 replies)
  53. VBA Formula for Splitting Property Address to Multiple Columns (4 replies)
  54. [SLEEPER:] VB Editor Menu Keyboard Shortcut Assignments Change with Macro / Code … (1 replies)
  55. [SOLVED:] Protect Workbook (Lock Certain Cells) and still have VBA run on unlocked cells?? (3 replies)
  56. Statistical confidence plot in Excel (1 replies)
  57. Sensitivity Analysis (0 replies)
  58. [SOLVED:] Office 365 - Remove All Tables, ListBox & Macros from a Dynamic Range of Worksheets (5 replies)
  59. Office 365 - Select Dynamic Sheet Names in Array (15 replies)
  60. [SOLVED:] Need Help Creating a Macro (9 replies)
  61. Remove duplicated rows with VBA (1 replies)
  62. [SOLVED:] Cannot get two subs to run together (5 replies)
  63. Excel VBA - causing issues (3 replies)
  64. Office 365 - Using ComboBox / Text Box & Lists from Dynamic Tables (10 replies)
  65. Help : take out numbers from a string after a specific word till next space or comma (11 replies)
  66. CREATE WORKBOOKS FROM TEMPLATE WORKSHEET AND TABLE OF DATA (3 replies)
  67. Concatenate in VBA? (5 replies)
  68. [SOLVED:] ClearContents of merged cells? (5 replies)
  69. [SOLVED:] Syntax error - can't see why! (12 replies)
  70. [SOLVED:] Simple read file macro in Excel VBA on Mac OS X (0 replies)
  71. [SOLVED:] pushbutton and countif/deletes (22 replies)
  72. [SOLVED:] Userform with calendar month code to bold 2 inputbox result day label value (1 replies)
  73. Keeps overwriting my output (2 replies)
  74. VBA Application.Run for Running Macros-with-Parameters Stored Inside an Excel Cell (20 replies)
  75. How to apply VBA formula to stop row height from readjusting ? (Excel File) (1 replies)
  76. [SOLVED:] Format date within formula in VBA (18 replies)
  77. Combination data types (7 replies)
  78. Compare with two column and return value or highlight match word(s) (2 replies)
  79. [SOLVED:] Not Working : Load data from excel in user form and update / delete (5 replies)
  80. Help required to extract data from rows to column in Excel2013 (3 replies)
  81. VBA Code/Macro for Extracting data from Sheet 1 to Sheet 2 (1 replies)
  82. [SOLVED:] Vba Array Shuffle Giving an Error and Lost Datas! (3 replies)
  83. [SOLVED:] convert cells in worksheet to values (11 replies)
  84. [SOLVED:] Calculate the SUM from One Place to Another (2 replies)
  85. [SOLVED:] Slow Calculation of Sum Row (10 replies)
  86. Create a loop in VBA to copy data out of different files (11 replies)
  87. [SOLVED:] Not Working : Sum of Hours (6 replies)
  88. [SOLVED:] Change format of ConvertDegrees function (11 replies)
  89. VBA Command (6 replies)
  90. product csv from sheets (1 replies)
  91. [SOLVED:] Searching for multiple texts within a cell (InStr) (7 replies)
  92. VBA help to stop one code from affecting another (6 replies)
  93. [SOLVED:] Comma separated list from columns (7 replies)
  94. [SOLVED:] Formula to collect charges (4 replies)
  95. [SOLVED:] Superscript in a Function (4 replies)
  96. Excel 2019: Range.Find(Number) Trouble (5 replies)
  97. VBA Help with Multiple If conditions (14 replies)
  98. Print sales transaction receipt error (0 replies)
  99. [SOLVED:] Trying to allow a TextBox entry on UserForm store in variable (10 replies)
  100. Autofilter help needed - encountering Autofilter method of range class failed error (0 replies)
  101. [SOLVED:] Not Working : Opening an Excel workbook from SharePoint in edit mode from a user form (1 replies)
  102. [SOLVED:] How to do sequencing number after rows duplicated (12 replies)
  103. [SOLVED:] VBA Text Comparisons Identifying Differences (2 replies)
  104. Office 365: Application.CommandBars("Workbook Tabs").ShowPopup issues (5 replies)
  105. [SOLVED:] Highlight Matching Text in different cells (3 replies)
  106. [SOLVED:] Request help to find missing dates in a date range for the user (12 replies)
  107. [SOLVED:] Search column for specific value, then delete rows found, leaving the first instance (6 replies)
  108. [SOLVED:] Trying to make specific cell contents bold (5 replies)
  109. VBA and Excel Formula (0 replies)
  110. Collecting Data From Multiple Users (2 replies)
  111. Import, Filter and Sort Multiple Columns (2 replies)
  112. Excel VBA shift selected cells in various columns up/down for a specified number cell (3 replies)
  113. [SOLVED:] Not Working : Worksheet_Change Event (7 replies)
  114. Find Specific Word from the cell by referring a list (VBA) (3 replies)
  115. Rows to hide and unhide based on two columns (2 replies)
  116. Find the duplicate from one work book and remove the duplicates in another workbook (10 replies)
  117. Help : Date Picker in VBA user form and view data from data entry wb (2 replies)
  118. How to read in server name, software name and version from a text file (6 replies)
  119. [SOLVED:] editing VBA code (10 replies)
  120. How to Handle Blank cell value in VBA (2 replies)
  121. [SOLVED:] Pivot Tables: error in 'Field.CurrentPage = NewCat' (31 replies)
  122. Loop through column, range.copy to another sheet based on cell value (1 replies)
  123. vba for mac book pro (0 replies)
  124. [SOLVED:] Difficulty Changing Data with a Hyphen "-" (4 replies)
  125. With PivotTable: Count consecutive days that meet a criteria (6 replies)
  126. Not Working : VBA : Create folder and access files from One Drive (1 replies)
  127. [SOLVED:] error 1004 - VBA Delete column (4 replies)
  128. Axis Ticklables to ObjectThemeColor (0 replies)
  129. delete blank cells in every row individually (2 replies)
  130. [SOLVED:] UCase Help (3 replies)
  131. [SOLVED:] search files across multiple sheets and open & highlight (2 replies)
  132. Search for a file in folder and subfolders (mac version) (2 replies)
  133. [SOLVED:] help for VBA conditional formating count on correct color (8 replies)
  134. Import Second Excel file (1 replies)
  135. VBA - seet 1 cell value (H2) to copy paste in activecell column c sheet 2 (0 replies)
  136. Update a new sheet from Userform (4 replies)
  137. [SOLVED:] create sheets based on extensions files and copy to each months (27 replies)
  138. [SOLVED:] Help : Compare texts in two columns in the same row and get the similarity percentage (11 replies)
  139. Help with VBA Macro (5 replies)
  140. Can you lock one filter in a pivot table? (19 replies)
  141. How to move data from one variable to another (5 replies)
  142. VBA - conditional copying different column ranges (2 replies)
  143. [SOLVED:] Hyperlink formulas in VBA code - one is working and one is not (4 replies)
  144. Extracting data from json api (5 replies)
  145. [SOLVED:] Move Duplicates to Result Sheet (2 replies)
  146. UP/DOWN/INSERT/DELETE macros part of line (14 replies)
  147. Problem with Charts (3 replies)
  148. Hi. Need to copy/cut rows from sheet to another at top of dataset (9 replies)
  149. [SOLVED:] Hide rows when check box selected (4 replies)
  150. VBA to open excel-sheets, updating link, saving and closing (0 replies)
  151. A function that crashes: Compile Error: Procedure too large (19 replies)
  152. [SOLVED:] Merge Workbooks into one - Help in Folder Picker (7 replies)
  153. Swap last and first word in a sentence in an excel column (7 replies)
  154. Transpose using VBA (1 replies)
  155. [SOLVED:] Macro help - matching times to periods (4 replies)
  156. [SOLVED:] How to know form Option button name or number (4 replies)
  157. Export to CSV with New Name and Time Stamp (1 replies)
  158. Nested classes with dynamic array (2 replies)
  159. regexp to find multiple instances of the same structure term? (1 replies)
  160. [SOLVED:] Hide rows with option buttons (29 replies)
  161. Read all Excel files in a folder and edit them via UI (2 replies)
  162. [SOLVED:] SharePoint and SaveCopyAs method (1 replies)
  163. [SOLVED:] Cell is equal to another cell until you write something in it (50 replies)
  164. Help needed for layout display after calculation. (7 replies)
  165. [SOLVED:] Fill in a row until bottom of the table (2 replies)
  166. [SOLVED:] Extract dates from a cell containing a string of data (10 replies)
  167. lookup between different worksheet. (2 replies)
  168. Need Help Creating a Macro (11 replies)
  169. Why will macro will move pdfs and xlsxs but not msgs? (2 replies)
  170. VBA-Import text file of yesterday's date which is the file name (1 replies)
  171. [SOLVED:] VBA to Limit what Columns a User can View--Question about Security (2 replies)
  172. date Macro (7 replies)
  173. [SOLVED:] Splitting large range of data into multiple cost center outputs in txt-format (11 replies)
  174. help with vba code (9 replies)
  175. [SOLVED:] File Format and Extension Don’t Match (7 replies)
  176. [SOLVED:] Count based on two criteria from different columns (8 replies)
  177. [SOLVED:] Loop thru validation list - filter multi sheets - generate individual files (2 replies)
  178. fastest way to copy multiple range to multiple sheets (25 replies)
  179. Copy Rows with Certain Values (0 replies)
  180. [SOLVED:] VBA Help - Run-time error '-2147417848 (80010108)': Method 'Value' of object 'Range' (6 replies)
  181. [SOLVED:] Add extra worksheet (5 replies)
  182. [SOLVED:] Code only copies certain column. (6 replies)
  183. Excel 2016 VBA on MAC to Open A File (0 replies)
  184. Password to save worksheet as new workbook (2 replies)
  185. Copy & Append Paste from various workbooks into one master (0 replies)
  186. Need Help Highliting Some String in Cell and Columns With Macro! (2 replies)
  187. [SOLVED:] Function to Pass Workbook and Worksheet objects giving Type Mismatch Error 13 (7 replies)
  188. [SOLVED:] TRANSACTION RATE NOT SHOWING (7 replies)
  189. [SOLVED:] Code not Executing in Immedate Window--Copy and Paste are Disabled (4 replies)
  190. Excel Maximum Rows (6 replies)
  191. VBA script to insert new rows based on data in other cells, then rearrange data (3 replies)
  192. Userform refresh after change source cell (3 replies)
  193. Transaction Rate show up (0 replies)
  194. [SOLVED:] VBA Help in Cash flow forecast (9 replies)
  195. Autofilter in Multiple sheets - copy to new workbook - save workbook by field name (0 replies)
  196. HIDE UNHIDE automatically in others sheets (14 replies)
  197. Help with Excel Macro to computer investment return (2 replies)
  198. Excel VBA Code help (2 replies)
  199. [SOLVED:] Run time error 424 object required (1 replies)
  200. [SOLVED:] run time error 1004 Pastespecial method of range class failed (3 replies)
  201. [SOLVED:] run time error 13 Type mismatch (8 replies)
  202. C# to VBA macro in excel (4 replies)
  203. ReTry (3 replies)
  204. [SOLVED:] Runtime Err 91 (3 replies)
  205. [SOLVED:] Flag if Value (2 replies)
  206. [SOLVED:] Run-time error 438: Object doesn't support this property or method (5 replies)
  207. [SOLVED:] How to refer to an existing Worksheet Name (9 replies)
  208. Can anybody please show me how to loop the following macro until a cell is empty (4 replies)
  209. [SOLVED:] VBA code for deleting "FALSE" functions (16 replies)
  210. How to copy values from multiple cells into one row in SAP (1 replies)
  211. Help me to pull random samples from the data source using VBA (1 replies)
  212. [SOLVED:] check calculation state on workbook open (6 replies)
  213. HMAC SHA1 algorithm (4 replies)
  214. Dependant ActiveX comboboxes filtering multiple pivot tables Issue (9 replies)
  215. Importing csv data from multiple source files into a master workbook into resp sheets (11 replies)
  216. VBA XLOOKUP to use text before semicolon (2 replies)
  217. VBA Calender - Add Date to Text Value instead of Activecell (5 replies)
  218. [SOLVED:] ActiveX Option Buttons No Longer Function After Hide Then Unhide Rows (5 replies)
  219. extracting a string from a line of text (13 replies)
  220. [SOLVED:] Pop-up Message Box when certain values are inputted in Column A (5 replies)
  221. vbModeless question (2 replies)
  222. [SOLVED:] Round Up the answer to a calculation which is being performed in VB (5 replies)
  223. [SOLVED:] Best way to use lookup to find last value in column of another sheet (3 replies)
  224. add a new row based on selected on combobox and copy data (0 replies)
  225. IF Then ElseIf Else Statement macro (17 replies)
  226. [SOLVED:] Several Groups of ActiveX Option Buttons - How to Identify Selected Button in Each (5 replies)
  227. [SOLVED:] Adding on to existing macro, Need IFS function and filter (0 replies)
  228. VBA Edit Links (34 replies)
  229. [SOLVED:] Is there a way to insert a permanent VBA userform to excel (4 replies)
  230. VBA Excel paste special speed reduces over time while looping (0 replies)
  231. [SOLVED:] Subscript error when finding next blank row in added worksheet (3 replies)
  232. Multiple conditions for 3 consecutive ListBox - How to make it work? (5 replies)
  233. Email Active workbook with updates made (1 replies)
  234. Vba To Refresh Specific External Connections (3 replies)
  235. Conditional Format Macro help (2 replies)
  236. Change Pivot Table Date Filter to Cell Reference (2 replies)
  237. Newbie needs help please (1 replies)
  238. fifo vba code please (9 replies)
  239. [SOLVED:] Transpose Data In Columns (8 replies)
  240. [SOLVED:] LISTING FILES IN FOLDER - INCORRECT ORDER (17 replies)
  241. [SOLVED:] two way dependent dropdowns.. possible? (2 replies)
  242. VBA Help - Reference to a Table & Vlookup (3 replies)
  243. Based on the Location & Quantity, Locations to be grouped & corresponding sum (1 replies)
  244. Type mismatch when using Application.WorksheetFunction.Match (9 replies)
  245. Combine recursive listing with excluded code (124 replies)
  246. Help with weighted averages for scorecard (10 replies)
  247. Graph two data tables in one graph (1 replies)
  248. Why Excel commandbutton macro is too slow? (8 replies)
  249. Loop through column and conditionally subtract (9 replies)
  250. Copy data from one sheet to new - but paste only values without formating and links (4 replies)