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. Sharing Interest Dynamically (5 replies)
  2. VBA - open corrupted file - excel 2010 (1 replies)
  3. Refer to a cell in another worksheet (macro) (2 replies)
  4. [SOLVED:] Copy and paste total row with engineer name and headings to a new worksheet (1 replies)
  5. Prining from VBA not coming out in the correct size, please help me (1 replies)
  6. Perform Sum in vba code (3 replies)
  7. VBA for printing files listed in excel (3 replies)
  8. VBA Coloring Cells Based on Value (3 replies)
  9. Update value in a column from another worksheet depending on the date in a range (3 replies)
  10. How to return entire output from Array to Excel sheet in one go (4 replies)
  11. How to compare different values either by formula or vba (1 replies)
  12. [SOLVED:] Variable Not Defined, Excel 2013 & 2007 (4 replies)
  13. [SOLVED:] Excel VBA help....please :) (4 replies)
  14. [SOLVED:] Create a new function to find a date or next date on a selected range (8 replies)
  15. Excel VBA - Check excel file names and change if necessary (2 replies)
  16. Summary of cash book day wise (2 replies)
  17. [SOLVED:] PRINT EMAILS WHERE SUBJECT MATCHES CELLS IN EXCEL (2 replies)
  18. clearing data using range(cells) (1 replies)
  19. [SOLVED:] VBA Code Modifcation To Insert a New Row and Fill out with Data As Per Existing Code (2 replies)
  20. Need Excel VBA help to loop in folder, execute several tasks and save filesAs (1 replies)
  21. Send Email separating by specific recipient (0 replies)
  22. input box to define formulas contraints (1 replies)
  23. [SOLVED:] VBA Loop (5 replies)
  24. [SOLVED:] VBA Help please - Find First Row of Data? (4 replies)
  25. Check Values in Array for Matches (5 replies)
  26. click button via vba (0 replies)
  27. [SOLVED:] Automatically group the cell based on the words that appear in it (10 replies)
  28. Merge duplicates with cell color (2 replies)
  29. [SOLVED:] Dependencies and Dates (5 replies)
  30. Security (2 replies)
  31. [SOLVED:] Copy data block from one workbook to another .. should be easy (3 replies)
  32. [SOLVED:] Gradual Zoom? (8 replies)
  33. [SOLVED:] VBA - Copy with validatation (7 replies)
  34. [SOLVED:] Adjust/Sync Table columns number Base on a Pivot Table Columns Size (5 replies)
  35. Copy multiple workbooks & multiple sheets into single workbook with multiple sheets (3 replies)
  36. VBA - Export as PDF and overwrite existing PDFs (2 replies)
  37. Distribute Numbers Evenly, With Conditions (3 replies)
  38. Forecasting (7 replies)
  39. Traverse all images in workbook (2 replies)
  40. Excel Userform DatePicker Default Format to be Blank (3 replies)
  41. [SOLVED:] Select row based on multiple textbox values (1 replies)
  42. [SOLVED:] Having trouble with renaming files in subfolders of subfolders (2 replies)
  43. Listbox not showing Data (2 replies)
  44. Stock Locator Inventory System-Issue with locator (1 replies)
  45. Paste from Clipbaord (1 replies)
  46. Dependent between 2 dropdown columns (4 replies)
  47. [SOLVED:] How to do loop in the function? (8 replies)
  48. Save textbox to specific cell based on combobox seletection (2 replies)
  49. Help with IE Button Click - SHDocVw (9 replies)
  50. [SOLVED:] VBA exel programming: how to make a automatically filled up by filling up other cell (6 replies)
  51. [SOLVED:] MoveAfterReturnDirection (7 replies)
  52. Komplex If-Loop (2 replies)
  53. Public Variable won't pass (4 replies)
  54. Excel-How to concatenate data in multiple dynamic number of rows and multiple columns (1 replies)
  55. [SOLVED:] Array Output (3 replies)
  56. How to make multiple, non adjacent cells hidden based on cell value code (7 replies)
  57. VBA help loop until & IF formula (3 replies)
  58. [SOLVED:] Color Coding Stops After I get to # 65,282 (2 replies)
  59. [SOLVED:] VBA Userform using Danish CPR Numbers (3 replies)
  60. SaveAs to SharePoint not working in Excel 2013 (0 replies)
  61. VBA Help needed (10 replies)
  62. [SOLVED:] VBA/Excel change value of a cell in multiple worksheets from a range in another workb (1 replies)
  63. VBA SUM Formula help (2 replies)
  64. Filtering numbers according to certain ratios (2 replies)
  65. [SOLVED:] Send all files in folder vba (2 replies)
  66. Excel 2016 Crashes (2 replies)
  67. [SOLVED:] Help with equation that has several inputs which vary in value. (11 replies)
  68. [SOLVED:] Formula returning false when it shouldn't (32 replies)
  69. Counting Used Rows In Column - Best Method? (2 replies)
  70. Edit to "colour to chart" macro - to cycle through workbook (9 replies)
  71. Allocating buyers based on expertise and performance (2 replies)
  72. Detecting Barcode Scanner input vs input by hand (4 replies)
  73. Array Question - basic (2 replies)
  74. macro to extract specific data from text file to excel sheet (9 replies)
  75. How to run external software run multiple files after each other using VBA (in Excel) (1 replies)
  76. Insert Vba macro to Sheet 3 using another macro. (1 replies)
  77. VBACode to show autofilter criteria just show result as <>, even though filter is set (1 replies)
  78. VBA Code-csv file into excel- from general to text (2 replies)
  79. [SOLVED:] Need help figuring out what went wrong (16 replies)
  80. VBA Question (1 replies)
  81. [SOLVED:] Copy and Paste Problem (12 replies)
  82. [SOLVED:] Conditional Statements & Nested If/Then in VBA (1 replies)
  83. SUMPRODUCT with additional sums/ adds (1 replies)
  84. Run-time error 438: Object doesn't support this property or method (VBA), Office 2010 (5 replies)
  85. VBA code for conditional cell merging (1 replies)
  86. xlsm file opens and immediately closes (7 replies)
  87. VBA for designing your sheet (2 replies)
  88. Replace text in email body from the excel (1 replies)
  89. Array match Only 1 RedimPreserve (7 replies)
  90. Find empty cell in one spreadsheet and then paste information from another (1 replies)
  91. [SOLVED:] Array of Email Addresses (8 replies)
  92. Type missmatch error (5 replies)
  93. [SOLVED:] MS MapPoint and MS Excel, plot latitude and longitude on a map (11 replies)
  94. Restoring default Styles in Excel (4 replies)
  95. [SOLVED:] Showing two expected values together with an IF function (2 replies)
  96. [SOLVED:] Color cells from previous colored cells in different column (0 replies)
  97. VBA to copy a new sheet based on active sheet (11 replies)
  98. INDEX MATCH in VBA over different data files (3 replies)
  99. [SOLVED:] Split Cells into rows but with two columns (10 replies)
  100. VBA - Set data list (8 replies)
  101. How to speed up VBA Code (12 replies)
  102. [SOLVED:] Help to faster this script for moving Duplicates (4 replies)
  103. How to Merge Cells Specially (12 replies)
  104. it is possible to save individual sheets as a separate file? (9 replies)
  105. [SOLVED:] VBA-split data into multiple worksheets based on column (6 replies)
  106. Outlook vba help - Folder Picker (0 replies)
  107. It is possible deleting rows in lisboxt datagrid with active sheets displayed vba exc (13 replies)
  108. [SOLVED:] Validation Code Problem (6 replies)
  109. Performing count and max commands on multiple groups of rows (2 replies)
  110. [SOLVED:] Arrangement of values in groups (3 replies)
  111. [SOLVED:] Excel 2010 run time error 91': Object variable or with block ... (8 replies)
  112. Filter the entries of Combobox (7 replies)
  113. [SOLVED:] Error Handling (runtime error 1004) (13 replies)
  114. Need help moving many fields of data from the master sheet to several other sheets (4 replies)
  115. [SLEEPER:] How to get data from an array table with two different values (0 replies)
  116. [SOLVED:] Concatenation with double quotes and comma for the selected list of values (17 replies)
  117. VBA_Pivot table capture in array and reapply (1 replies)
  118. search for multiple value using FORMS (0 replies)
  119. Returning the Caption Property for active controls in an email body (11 replies)
  120. [SOLVED:] Getting Run Time Error 5 on String? (10 replies)
  121. Improve efficiency of VBA Code (16 replies)
  122. [SOLVED:] Validate cells in column A with info from other columns (12 replies)
  123. what is wrong with my update button code excel vba (6 replies)
  124. Vlook from Closed workbook taking a lot time (4 replies)
  125. copy and paste a certain number of times (2 replies)
  126. [SLEEPER:] Loading a txt file into excel win works fine. Loading txt on a mac doesn't work. (1 replies)
  127. my excel vba stop running when i run the userform and not responding (37 replies)
  128. macro to send multiple emails with all attachements from specific folder (2 replies)
  129. [SOLVED:] Create outlook appointementes only on "check" rows (1 replies)
  130. Need help with Timesheet Workbook I know exactly what I need ! (6 replies)
  131. [SOLVED:] Return Multiple Listbox Selection (12 replies)
  132. Extract single row from multiple workbooks (2 replies)
  133. Sheet_change is not worked (5 replies)
  134. Combine Data in Mutiple Columns into Rows (2 replies)
  135. Loop for substitution (1 replies)
  136. [SOLVED:] Loop to copy and paste first cell of repeated values (14 replies)
  137. Copy data from multiple single-worksheet workbooks into another workbook (1 replies)
  138. [SOLVED:] Sum Values Assigned to a Name (3 replies)
  139. [SOLVED:] automated data query (1 replies)
  140. [SOLVED:] Remove duplicates (runtime error 5) (1 replies)
  141. [SOLVED:] Dim problem (4 replies)
  142. VBA Code running in f8 but not f5 (2 replies)
  143. [SOLVED:] Range of inputs and graphing of result (8 replies)
  144. What am I doing wrong here? (11 replies)
  145. [SOLVED:] how to loop search to show multiple entries in listbox (8 replies)
  146. Minimize-Maximize-Resizing-Scrolling in a Userform (1 replies)
  147. VBA Code to attach (multiple) file(s) (7 replies)
  148. [SOLVED:] lookup formula to sum percent (2 replies)
  149. VBA Code problem for Excel 2016 on a mac (5 replies)
  150. [SOLVED:] Loop through all Pivot tables in a worksheet and filter visability VBA (4 replies)
  151. [SOLVED:] Looping through a Range of Data (3 replies)
  152. Dsum and Data Tables (3 replies)
  153. Avoid code repetition by calling the common code from another sub (6 replies)
  154. Finding the last modified date of an excel sheet (15 replies)
  155. [SOLVED:] Split First, Middle and Last Name (20 replies)
  156. Save Active Word Doc with URL File Path (14 replies)
  157. Iterate 2 dropdown lists and move to all the new tabs to new workbook (0 replies)
  158. [VBA] set range find() -> finds wrong value (4 replies)
  159. [SOLVED:] Using concatenate to reference a named range (3 replies)
  160. VBA event to detect an Autofill Scrolling? (3 replies)
  161. Paste column format only through iteration (4 replies)
  162. Office Automation: Excel executng Word VBA (14 replies)
  163. Pull Date by Criteria for Visible cells only (1 replies)
  164. [SOLVED:] Line Break Validation (6 replies)
  165. vba - copy workbook 300 times once user selects folder (0 replies)
  166. [SOLVED:] Copy row data from one workbook to another based on row header name (10 replies)
  167. ID matching with Name and sub six hours work time calculation (1 replies)
  168. Mail Merge Excel however instead of Print Need save as (8 replies)
  169. email automation (2 replies)
  170. help creating a repricing tool with defined parameters (5 replies)
  171. Excel charts as jpgs to specific powerpoint (3 replies)
  172. VBA To search for a WorksheetSheet and a Column in that sheet. (2 replies)
  173. [SOLVED:] Outcome is not as expected - code might be wrong (22 replies)
  174. [SOLVED:] Non Regular Sequential Numbering (5 replies)
  175. [SOLVED:] Why are my formulas changing automatically? (3 replies)
  176. [SOLVED:] Issue with button (4 replies)
  177. [SOLVED:] listbox1 to listbox2 (3 replies)
  178. [SOLVED:] COUNTIF code then insert copied cells (4 replies)
  179. Import HTML Data into excel (2 replies)
  180. How to rename a bunch of files in the same folder using an Excel VBA code? (6 replies)
  181. Control Panel using a userfom and hide workbook (3 replies)
  182. [SOLVED:] Returning an element from an array of subclasses (2 replies)
  183. [SOLVED:] Convert text in alphanumeric string to lower case (7 replies)
  184. [SOLVED:] Bold First Name in a VBA generated Email (9 replies)
  185. Formatting table in worksheet (4 replies)
  186. Replacing Text evenly from 1 sheet to another sheet (8 replies)
  187. [SOLVED:] loop through files in a folder based on a condition (4 replies)
  188. VBA Combobox for vlookup (1 replies)
  189. [SOLVED:] Wrong result of my macro! (13 replies)
  190. Index/Return cell references from table array based on "Yes"/"No" response (14 replies)
  191. How to consolidate data from multiple sheets into a master excel (5 replies)
  192. Form showing odd sizes (5 replies)
  193. Vba Code to open multiple files from a specific directory (4 replies)
  194. Userfom to count items and show clicks and percentage vs target (3 replies)
  195. Automatic Refresh causing paste issues (6 replies)
  196. Problem With Macro (3 replies)
  197. Copying two ranges and transposing one of them (1 replies)
  198. [SOLVED:] Toggle "select objects" instead of cells ?? (25 replies)
  199. [SOLVED:] Inputbox with date used as European style (1 replies)
  200. Filter quantity of the commodity code from total data and minus decesing ??? (2 replies)
  201. [SOLVED:] Add Unequal Amount of Data To Two Columns of UserForm List Box (6 replies)
  202. Sumif from pivot table (1 replies)
  203. [SOLVED:] Align List Boxes On User Form Using a Loop (2 replies)
  204. Create Power point presentation from multiple excel files (3 replies)
  205. Product List Search Function (3 replies)
  206. File properties using FSO and Dir (19 replies)
  207. Update Another Sheet with Results of Formula w/Multiple Criteria (10 replies)
  208. [SOLVED:] Excel Code Help, Loop related (5 replies)
  209. Getting a Macro in Power Point to skip update if and excel sheet is open (3 replies)
  210. Data transfer depending on the empty cells (4 replies)
  211. [SOLVED:] Fill Userform Text Box From Worksheet (2 replies)
  212. Copy formula/row range down to a value specified by another cell? (4 replies)
  213. VBA - Email notification when job added to list. (15 replies)
  214. [SOLVED:] Copy data from rows to other worksheets (2 replies)
  215. [SOLVED:] Copy a single field from Access to Excel (1 replies)
  216. API Help Needed (3 replies)
  217. [SOLVED:] Copy certain worksheets from one workbook to another while keeping format (2 replies)
  218. [SOLVED:] vba help on declaring varible (3 replies)
  219. Ifnumber & Search with mulitple Conditions (1 replies)
  220. VBA too long-winded help needed. (9 replies)
  221. [SOLVED:] Worksheet collections in formula? (2 replies)
  222. Best method to check range completion before running rest of program. (2 replies)
  223. VBA-Extract only number from a string (4 replies)
  224. Excel 2016 .CopyPicture (1 replies)
  225. Convert Userform with a scrollbar into pdf (0 replies)
  226. SUM for a dynamic table (3 replies)
  227. [SOLVED:] Transferring data to a summary spreadsheet (2 replies)
  228. Excel VBA IMAGE help! (12 replies)
  229. vba consolidation of specific sheets data and Pasting in specific Mater sheets (1 replies)
  230. Hyperlink function reference multiple cells? (1 replies)
  231. Transferring Userform data to excel (6 replies)
  232. VBA Userform Precedence (20 replies)
  233. [SOLVED:] Break text (3 replies)
  234. Copying certain rows of worksheet into new worksheet depending on date (1 replies)
  235. When changing Row B in Sheet 2 automatically do sorting with Row B in Sheet 1 (5 replies)
  236. [SOLVED:] Copying only values in VBA (3 replies)
  237. Repeat code for each row (4 replies)
  238. CopyRow help for multiple tabs (1 replies)
  239. First VBA project summary file please help (3 replies)
  240. [SOLVED:] VBA outlook (3 replies)
  241. Pivot Table not updating after Cut and Pasting Values to Data WS (1 replies)
  242. [SOLVED:] Open Folder with Comma and Ampersand in Name (9 replies)
  243. IF function in VBA - Can't COPY (6 replies)
  244. Help w/Offset Paste (2 replies)
  245. Populate Form Label Captions from Worksheet (2 replies)
  246. Ink Signature to cell (3 replies)
  247. VBA Macros Copy Paste Seed Up Help (3 replies)
  248. Time stamp in a fixed cell when content of specific cells in row are changed (8 replies)
  249. Class Does not suppor automation or does not support expected interface (1 replies)
  250. Deleting Data from Database using VBA (1 replies)