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. [SOLVED:] Selected Sheets Count (3 replies)
  2. [SOLVED:] Image control and load picture (0 replies)
  3. Copy value on a monthly basis from a website and update excel workbook (4 replies)
  4. [SOLVED:] Worksheet_Change (5 replies)
  5. [SLEEPER:] Userform help (4 replies)
  6. [SOLVED:] Split some sentences by 'vbKeyEnter' (6 replies)
  7. [SOLVED:] Sumproducts problem (4 replies)
  8. using public variables in userforms (3 replies)
  9. VBA listbox change event (1 replies)
  10. How can I copy 2 sheets and Paste everything but the Formulas (11 replies)
  11. [SOLVED:] Run-time error '1004': Method 'SaveAs' of object'_Workbook' failed (2 replies)
  12. Macro to Unhide Column, Print, Hide Cell (2 replies)
  13. MAcro Help (3 replies)
  14. Open Zip file with many other named files and months within folder (0 replies)
  15. Get unique items and sum total on userform (5 replies)
  16. VBA help in coding (0 replies)
  17. [SOLVED:] Finding Angular Misclosure and then Balancing Angles (6 replies)
  18. [SOLVED:] Macro is being driven on different worksheets (11 replies)
  19. VBA Help, Getting error: 'That name is already taken. Try a different one' (1 replies)
  20. [SOLVED:] Reload combobox contents after saving file (6 replies)
  21. populate userform listbox with pivotRowField items (4 replies)
  22. [SOLVED:] Formula Error (Not using VBA Code) (6 replies)
  23. [SOLVED:] Msg Box restarting every 5 seconds (5 replies)
  24. VBA Code Assistance (2 replies)
  25. Determine the position of a screentip (1 replies)
  26. Print PDF on Back Side of First Sheet of Excel File (0 replies)
  27. Convert date format (3 replies)
  28. Based on cell value highlight cell and transfer data from one to another sheet (0 replies)
  29. ActiveX Checkbox VBA Code Help (14 replies)
  30. Not able to access a text field using getElementbyID (0 replies)
  31. VBA code just need one line...? (4 replies)
  32. Copy from different workbook (7 replies)
  33. Ribbon tool (4 replies)
  34. Copy from Merged Cell to individual cell (6 replies)
  35. VBA access embedded window data from html (0 replies)
  36. Runtime Error 1004: Attempting to Mirror Cells (5 replies)
  37. [SOLVED:] Retrieve data by downloading a text file from a site (4 replies)
  38. acceleration of a macros formation of data on new sheet (5 replies)
  39. [SOLVED:] Hex Colors Display in Excel Wrong - RGB (3 replies)
  40. Conversion of formula to userform or button (3 replies)
  41. Best way to capture digits to left of decimal place? (5 replies)
  42. VBA Script to fill in missing data (0 replies)
  43. Highlight missing or duplicated cells (41 replies)
  44. Determine ScaleHeight of an image (3 replies)
  45. Vertical line pointing to fixed Date (0 replies)
  46. Copying text from Word to Excel with VBA (3 replies)
  47. [SOLVED:] Need Help for pasting data for 2 columns instead of 1 column (4 replies)
  48. [SOLVED:] Excel Button IE Automation (6 replies)
  49. [SOLVED:] Find/Replace in Excel (10 replies)
  50. VBA Code - Insert Pagebreak in Selected Cells (Range) (4 replies)
  51. Excel VBA: Consolidating data with existing data each time macro is run (9 replies)
  52. [SOLVED:] Excel VBA : How to break the file Path (3 replies)
  53. [SOLVED:] VBA macro for deleting not matching values (3 replies)
  54. [SOLVED:] help with If statement that counts (20 replies)
  55. [SOLVED:] Need Help passing a userform.texbox object to a sub (13 replies)
  56. [SOLVED:] Check if cells match but ignore the spaces. (1 replies)
  57. Get table of information from website (1 replies)
  58. [SOLVED:] Data Replacement (1 replies)
  59. Fast Data Search Method With Userform (1 replies)
  60. [SOLVED:] Excel VBA : how to merge cells in winword table with for... next (0 replies)
  61. ExcelVBA - Opening files with certain conditions (1 replies)
  62. window of search in the userform (1 replies)
  63. Copy data from Multiple WBs without Duplicates (8 replies)
  64. Need help in accelerating a process(too many loops) (18 replies)
  65. [SOLVED:] How do you create nested classes in VBA Classes in Excel? (3 replies)
  66. Drop time info from CSV import (22 replies)
  67. Transferring Data from Outlook to Excel (0 replies)
  68. Need help with VBA and copying rows (13 replies)
  69. Extracting excel files only from 3rd subfolder and only from certain folders (4 replies)
  70. time format a text box in excel userform (5 replies)
  71. List related information comparison, based on list matching (2 replies)
  72. [SOLVED:] Pivot Table Flexible Source (3 replies)
  73. Unknown external link to macro-workbook problem (1 replies)
  74. Table Creation in EXCEL (2 replies)
  75. [SOLVED:] Flexible address for autofill (12 replies)
  76. Is it Possible to Run Goal Seek on array elements within VBA? (0 replies)
  77. [SOLVED:] Conditional Formatting and Data Validation. (6 replies)
  78. Copy Filtered Visible Data from one workbook to another workbook with Filtered Field (0 replies)
  79. Refreshing connection (4 replies)
  80. [SOLVED:] One Function: Different Formulas for Different Inputs (14 replies)
  81. Store specific rows in an array (1 replies)
  82. Populate the text2 box with the expiration date of 30 working days (2 replies)
  83. VBA - Run same code for each row but increment values? (3 replies)
  84. Copy and paste multiple data from Excel to Internet Explorer (6 replies)
  85. find min value of specific designation (4 replies)
  86. EXCEL 2013 DEPENDENT CELLS (6 replies)
  87. Need help formatting an email generated from excel to outlook. (0 replies)
  88. Adding a unique watermark to a PDF from Excel (1 replies)
  89. [SOLVED:] Compare Multiple Columns in Multiple Sheets and Merge differences (16 replies)
  90. [SOLVED:] Combine two macros on the same sheet (6 replies)
  91. How to test for characters in a specific set? (8 replies)
  92. Quick way for removing rows (4 replies)
  93. [SOLVED:] Remove duplicates from Rows with the last Row only as reference (9 replies)
  94. Autocomplete value entered into a cell from a list in another workbook (0 replies)
  95. Specify which folder to open when using Get Open Filename (1 replies)
  96. (Single Workstation) Error, how to reset? Macros via Ribbon UI aren't firing... (0 replies)
  97. VBA - HIDE/UNHIDE Rows Based on Output of a Formulated Cell (5 replies)
  98. Deleting All True Empty Rows in a worksheet (4 replies)
  99. Repairing & rebuilding workbook error (3 replies)
  100. Transfer row from list box to another sheet VBA (1 replies)
  101. VBA code for multiple column loop - help please!!! (4 replies)
  102. Copy sheet to new workbook (4 replies)
  103. Looping Mirrored Cells between Worksheets (6 replies)
  104. Relative Paths within Excel for CSV imports (1 replies)
  105. Should be a simple fix but not sure how to move and tweak my If statement.... (4 replies)
  106. combine mutiple values into single cell based on criteria (1 replies)
  107. It's possible to add a Word document with a customized name? (0 replies)
  108. VBA replaces long number with # sign (Excel 2010) (7 replies)
  109. Export single row from given sheet & append into existing MSAccess table. (0 replies)
  110. [SOLVED:] Copy a column from excel and paste in the "To" section of a new email in Outlook (5 replies)
  111. Automation error (1 replies)
  112. Producing hundreds of Multiple Regression analysis scenarios simultaneously (4 replies)
  113. [SOLVED:] similar cells - grouping (2 replies)
  114. [SOLVED:] ListBox Object -- Inconsistent behavior (sometimes unresponsive?) (7 replies)
  115. [SOLVED:] callback an EditBox in the Ribbon (2 replies)
  116. sorting among workbooks (1 replies)
  117. [SOLVED:] Date Format in VBA (2 replies)
  118. Union range vs Arrays (error out of range) (1 replies)
  119. Help--Can't extract data from Mysql using cell content as select condition (2 replies)
  120. Sleeper: Gap in between the words in excel (2 replies)
  121. How to capture the lock time and event of System by vba? (1 replies)
  122. [SOLVED:] Macro for Conditional Formatting (1 replies)
  123. Highlight and popup message Between employee dates are overlap using (vba) (0 replies)
  124. [SOLVED:] Assign value to pie chart (8 replies)
  125. [SOLVED:] Copy Data from one sheet to New Workbook with the New Header Name (7 replies)
  126. Remove Duplicate Row IF Older (3 replies)
  127. Decorate my sheet as an interface (7 replies)
  128. [SOLVED:] Recon between two spreadsheets across various columns (24 replies)
  129. [SOLVED:] Update column of selected items in Multi Select Listbox (13 replies)
  130. Problems with xl2007 (1 replies)
  131. get file paths based on name criteria from folder (1 replies)
  132. user form(vba macro) (0 replies)
  133. excel file saving issues (3 replies)
  134. [SOLVED:] How to get the index of ActiveChart (2 replies)
  135. [SOLVED:] copy rows if number doesn't exist in all worksheet (26 replies)
  136. Sleeper: Get duration of mp4 files (5 replies)
  137. VBA query while inspecting element on webpage (0 replies)
  138. Rename files using criteria in Excel (10 replies)
  139. [SOLVED:] Input cell value based on multiple dropdown list to populate (3 replies)
  140. UDF calculation very slow in excel 2016 (faster in 2010) (1 replies)
  141. Excel - Identify Shapes by Content (9 replies)
  142. How to fix this problem? "unable to set the visible property of the pivotitem class" (1 replies)
  143. [SOLVED:] Countif or Similar Help Required and advise on Named Ranges (0 replies)
  144. [SOLVED:] UDF called by another UDF sees Caller as an Object (7 replies)
  145. [SOLVED:] New-work-assignment / Sort data (20 replies)
  146. [SOLVED:] Need help with an vba macro for excel that adding an 0 in a number combination (12 replies)
  147. Excel comments: a registered macro that doesn't work (0 replies)
  148. Arrays Compare (1 replies)
  149. Paste multiple formatted word paragraphs into single Excel cell (0 replies)
  150. Error during import from webpage -> *** requires a JavaScript enabled browser. (0 replies)
  151. [SOLVED:] Changing a cell font color upon cell entry & exit (5 replies)
  152. VBA - Excel Assistance on consolidating multiple workbooks into one (0 replies)
  153. [SOLVED:] Combining Data from multiple worksheets to a printable worksheet (6 replies)
  154. [SOLVED:] Help with SaveAs PDF (2 replies)
  155. Fill Formula Down Column when Rows Inserted (0 replies)
  156. VBA UserForm Movement limit (0 replies)
  157. [SLEEPER:] How to pick one webpage each from a collection of web page list!!! (0 replies)
  158. formula error while cut/copy of cell contents (2 replies)
  159. [SOLVED:] Transpose non organized data (5 replies)
  160. Excel templates and save as workbook (4 replies)
  161. Run Time Error 13 (Type Missmatch) (5 replies)
  162. [SOLVED:] VBA Pivot Table- Datafields Horizontal to Vertical (2 replies)
  163. [SOLVED:] Is MsgBox Suitable ? (4 replies)
  164. FormatConditions.add to change cell color when something is entered (0 replies)
  165. [SOLVED:] VBA Code to filter a list, then create new list in a new column (4 replies)
  166. [SOLVED:] Named Ranges - Same code, but one is cast as Variant and the other a Range? (7 replies)
  167. [SOLVED:] Application Defined or object Defined Error 1004 after every cell update (3 replies)
  168. [SOLVED:] Is possible to show the UserForm of another Excel file? (2 replies)
  169. [SOLVED:] Retrieve data(Time, From, subject, category) from Outlook inbox to Execl (19 replies)
  170. dynamic way of Filter and delete (6 replies)
  171. [SOLVED:] Setting the date as dd/mm/yyyy from a combined field (3 replies)
  172. Open File for Output hangs (1 replies)
  173. Fliter listbox using checkbox (2 replies)
  174. finding last column used and insert new data weekly (3 replies)
  175. [SOLVED:] Problems with GetSetting function (9 replies)
  176. Find values (4 replies)
  177. [SOLVED:] Index & Match formula error (2 replies)
  178. [SOLVED:] Excel Worksheet_SelectionChange event not firing at all? (on both Office 2013 & 2016) (2 replies)
  179. [SOLVED:] To Uppercase (2 replies)
  180. [SOLVED:] Pivots auto sort and dollar sign needs to be added (4 replies)
  181. [SOLVED:] Sorting in Excel VBA (3 replies)
  182. Filter Data and Copy to new worksheet (2 replies)
  183. Splitting multiple worksheet (0 replies)
  184. Automating Data Retrieval From Terminal Emulator (OutsideView) with VBA (0 replies)
  185. VBA error with parsing JSON (23 replies)
  186. [SOLVED:] Importing worksheets and retaining file order (0 replies)
  187. VBA to loop through each row and subtract if conditions met (2 replies)
  188. [SOLVED:] Process too long for counting received,sent mails etc. with Outlook (35 replies)
  189. Formula producing mixed results, may required VBA (2 replies)
  190. [SOLVED:] return the value from 'A' which has the largest sum of values in 'B' (7 replies)
  191. [SOLVED:] Baffled by Runtime Error 1004 - Help Please (4 replies)
  192. [SOLVED:] grabbing error values (1 replies)
  193. Identify keyboards with vba 7 (Excel)? (2 replies)
  194. VBA code to store and count data filtered by other columns (9 replies)
  195. Error connecting to MySQL using VBA (3709 error) (4 replies)
  196. Passing an item and its key to another collection (2 replies)
  197. [SOLVED:] (HELP) add multiple process to my code (7 replies)
  198. [SOLVED:] Listbox - calculation based on selections (4 replies)
  199. Vba to highlight the cell and remove duplicates (3 replies)
  200. Creating a dynamic piechart (8 replies)
  201. Trying to only retrieve files that i do not already have (3 replies)
  202. [SOLVED:] Excel VBA -Comparing Two arrays (9 replies)
  203. Excel vba code to automate IE. (0 replies)
  204. Excel VBA to count the ADDITIONAL comments added to a cell (3 replies)
  205. VBA Help: Date/Time Stamp functionality (5 replies)
  206. Help with time if/then in VBA (2 replies)
  207. [SOLVED:] VBA Code - setting cell background color doesn't hold with different selection. (2 replies)
  208. [SOLVED:] merge 2 VBA enabled worksheets to 1 sheet (0 replies)
  209. [SOLVED:] Create a new workbooks for each Unique value (4 replies)
  210. [SOLVED:] VLOOKUP with variable workbook and worksheet names in macro (7 replies)
  211. VBA Error/Trapping/Identification (11 replies)
  212. Hyperlink (2 replies)
  213. Can't add new item to the listbox while running the userform (4 replies)
  214. [SOLVED:] Formula for placing ascending and descending numbers (5 replies)
  215. Codes working for 2 templates but not the 3rd (6 replies)
  216. [SOLVED:] VBA Formatting Help (3 replies)
  217. [SOLVED:] VBA Question on InputBoxes to Fill Cells on Worksheet (4 replies)
  218. VBA Insert array formula base on criterias (5 replies)
  219. [SOLVED:] VBA Calculation (4 replies)
  220. VBA Converter Required (0 replies)
  221. Multiple Entry Dependent Drop Down Macro (1 replies)
  222. [SOLVED:] Compare 2 colums of different sheet and copy values for matching data (3 replies)
  223. create filenames from the values in a MS Excel spreadsheet (3 replies)
  224. [SOLVED:] Search a pdf file depended on textbox value in multiple folders and subfolders (3 replies)
  225. [SOLVED:] help about my code (get data) (3 replies)
  226. staffing rotation in excel (3 replies)
  227. VBA code to find current user default download folder, then open a specific file (8 replies)
  228. Save worksheet as pdf using cell value and loop through work sheets (1 replies)
  229. Initiating a new instance of a class object (3 replies)
  230. XMLHTTP - communicate with server - not working on Japanese OS (1 replies)
  231. Macro to copy row, base in condition, into the botton of the table (0 replies)
  232. For...Each + Merging Cells Leading to Error 2042 (Type Mismatch)? (1 replies)
  233. Help subtracting sales from order (5 replies)
  234. [SOLVED:] Type Mismatch Error (2 replies)
  235. [SOLVED:] Can someone tell me why this doesn't work. (3 replies)
  236. How to amend this code in order to copy the inserted comment also? (5 replies)
  237. Excel Error when arguments with multiple parameters are passed (1 replies)
  238. How to extract specified data to the other worksheet? (2 replies)
  239. Copy Data without Activating a Tab (3 replies)
  240. [SOLVED:] Dynamically call function in sheet's VBA module (4 replies)
  241. VBA - Consolidating information from one sheet from multiple workbooks in the same ma (2 replies)
  242. [SOLVED:] Error 1004 (11 replies)
  243. [SOLVED:] VBA question on counters (3 replies)
  244. [SOLVED:] Reposition cursor in cell that contains the error (7 replies)
  245. [SOLVED:] Default to current date in textbox (3 replies)
  246. [SOLVED:] Copying entire row from Sheet1 to Sheet2 if values in multiple cells matches (2 replies)
  247. [SOLVED:] Last User Save (2 replies)
  248. Limiting User Entry on A Userform Combobox NOT working (6 replies)
  249. Not enough memory + Excel 2016 (11 replies)
  250. Pasting the contents from one sheet to a row after the last active row on another (3 replies)