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. [SOLVED:] Transpose non organized data (5 replies)
  2. Excel templates and save as workbook (4 replies)
  3. Run Time Error 13 (Type Missmatch) (5 replies)
  4. [SOLVED:] VBA Pivot Table- Datafields Horizontal to Vertical (2 replies)
  5. [SOLVED:] Is MsgBox Suitable ? (4 replies)
  6. FormatConditions.add to change cell color when something is entered (0 replies)
  7. [SOLVED:] VBA Code to filter a list, then create new list in a new column (4 replies)
  8. [SOLVED:] Named Ranges - Same code, but one is cast as Variant and the other a Range? (7 replies)
  9. [SOLVED:] Application Defined or object Defined Error 1004 after every cell update (3 replies)
  10. [SOLVED:] Is possible to show the UserForm of another Excel file? (2 replies)
  11. [SOLVED:] Retrieve data(Time, From, subject, category) from Outlook inbox to Execl (19 replies)
  12. dynamic way of Filter and delete (6 replies)
  13. [SOLVED:] Setting the date as dd/mm/yyyy from a combined field (3 replies)
  14. Open File for Output hangs (1 replies)
  15. Fliter listbox using checkbox (2 replies)
  16. finding last column used and insert new data weekly (3 replies)
  17. [SOLVED:] Problems with GetSetting function (9 replies)
  18. Find values (4 replies)
  19. [SOLVED:] Index & Match formula error (2 replies)
  20. [SOLVED:] Excel Worksheet_SelectionChange event not firing at all? (on both Office 2013 & 2016) (2 replies)
  21. [SOLVED:] To Uppercase (2 replies)
  22. [SOLVED:] Pivots auto sort and dollar sign needs to be added (4 replies)
  23. [SOLVED:] Sorting in Excel VBA (3 replies)
  24. Filter Data and Copy to new worksheet (2 replies)
  25. Splitting multiple worksheet (0 replies)
  26. Automating Data Retrieval From Terminal Emulator (OutsideView) with VBA (0 replies)
  27. VBA error with parsing JSON (23 replies)
  28. [SOLVED:] Importing worksheets and retaining file order (0 replies)
  29. VBA to loop through each row and subtract if conditions met (2 replies)
  30. [SOLVED:] Process too long for counting received,sent mails etc. with Outlook (35 replies)
  31. Formula producing mixed results, may required VBA (2 replies)
  32. [SOLVED:] return the value from 'A' which has the largest sum of values in 'B' (7 replies)
  33. [SOLVED:] Baffled by Runtime Error 1004 - Help Please (4 replies)
  34. [SOLVED:] grabbing error values (1 replies)
  35. Identify keyboards with vba 7 (Excel)? (2 replies)
  36. VBA code to store and count data filtered by other columns (9 replies)
  37. Error connecting to MySQL using VBA (3709 error) (4 replies)
  38. Passing an item and its key to another collection (2 replies)
  39. [SOLVED:] (HELP) add multiple process to my code (7 replies)
  40. [SOLVED:] Listbox - calculation based on selections (4 replies)
  41. Vba to highlight the cell and remove duplicates (3 replies)
  42. Creating a dynamic piechart (8 replies)
  43. Trying to only retrieve files that i do not already have (3 replies)
  44. [SOLVED:] Excel VBA -Comparing Two arrays (9 replies)
  45. Excel vba code to automate IE. (0 replies)
  46. Excel VBA to count the ADDITIONAL comments added to a cell (3 replies)
  47. VBA Help: Date/Time Stamp functionality (5 replies)
  48. Help with time if/then in VBA (2 replies)
  49. [SOLVED:] VBA Code - setting cell background color doesn't hold with different selection. (2 replies)
  50. [SOLVED:] merge 2 VBA enabled worksheets to 1 sheet (0 replies)
  51. [SOLVED:] Create a new workbooks for each Unique value (4 replies)
  52. VLOOKUP with variable workbook and worksheet names in macro (7 replies)
  53. VBA Error/Trapping/Identification (11 replies)
  54. Hyperlink (2 replies)
  55. Can't add new item to the listbox while running the userform (4 replies)
  56. [SOLVED:] Formula for placing ascending and descending numbers (5 replies)
  57. Codes working for 2 templates but not the 3rd (6 replies)
  58. [SOLVED:] VBA Formatting Help (3 replies)
  59. [SOLVED:] VBA Question on InputBoxes to Fill Cells on Worksheet (4 replies)
  60. VBA Insert array formula base on criterias (5 replies)
  61. [SOLVED:] VBA Calculation (4 replies)
  62. VBA Converter Required (0 replies)
  63. Multiple Entry Dependent Drop Down Macro (1 replies)
  64. [SOLVED:] Compare 2 colums of different sheet and copy values for matching data (3 replies)
  65. create filenames from the values in a MS Excel spreadsheet (3 replies)
  66. [SOLVED:] Search a pdf file depended on textbox value in multiple folders and subfolders (3 replies)
  67. [SOLVED:] help about my code (get data) (3 replies)
  68. staffing rotation in excel (3 replies)
  69. VBA code to find current user default download folder, then open a specific file (8 replies)
  70. Save worksheet as pdf using cell value and loop through work sheets (1 replies)
  71. Initiating a new instance of a class object (3 replies)
  72. XMLHTTP - communicate with server - not working on Japanese OS (1 replies)
  73. Macro to copy row, base in condition, into the botton of the table (0 replies)
  74. For...Each + Merging Cells Leading to Error 2042 (Type Mismatch)? (1 replies)
  75. Help subtracting sales from order (5 replies)
  76. [SOLVED:] Type Mismatch Error (2 replies)
  77. [SOLVED:] Can someone tell me why this doesn't work. (3 replies)
  78. How to amend this code in order to copy the inserted comment also? (5 replies)
  79. Excel Error when arguments with multiple parameters are passed (1 replies)
  80. How to extract specified data to the other worksheet? (2 replies)
  81. Copy Data without Activating a Tab (3 replies)
  82. [SOLVED:] Dynamically call function in sheet's VBA module (4 replies)
  83. VBA - Consolidating information from one sheet from multiple workbooks in the same ma (2 replies)
  84. [SOLVED:] Error 1004 (11 replies)
  85. [SOLVED:] VBA question on counters (3 replies)
  86. [SOLVED:] Reposition cursor in cell that contains the error (7 replies)
  87. [SOLVED:] Default to current date in textbox (3 replies)
  88. [SOLVED:] Copying entire row from Sheet1 to Sheet2 if values in multiple cells matches (2 replies)
  89. [SOLVED:] Last User Save (2 replies)
  90. Limiting User Entry on A Userform Combobox NOT working (6 replies)
  91. Not enough memory + Excel 2016 (11 replies)
  92. Pasting the contents from one sheet to a row after the last active row on another (3 replies)
  93. [SOLVED:] Replace certain cells in rows with values from same rows but in different column (2 replies)
  94. [SOLVED:] Setting a found item to a Variable (7 replies)
  95. [SOLVED:] "Run-time error '1004' on code to remove the ellipsis (...) character from a column (10 replies)
  96. [SOLVED:] How to find which columns are being used in active chart (3 replies)
  97. [SOLVED:] Need Some Help with SumProduct (7 replies)
  98. disable cells DataValidation (3 replies)
  99. Two Workbooks - Search for Values in Workbook 2, Copy and Paste in Workbook 1 (0 replies)
  100. [SOLVED:] Create a new sheet / workbook for all Unique values (Including Pictures / Images) (4 replies)
  101. Making a leave tracker with VBA (5 replies)
  102. AverageIfs Dynamic Formula -Criteria Not Working? (3 replies)
  103. Everytime I open my excel file open this file as new excel instance (3 replies)
  104. Select added value from dropdown menu, program output (1 replies)
  105. [SOLVED:] Got Excel< 2007? Test if "Action Will Reset Project" (5 replies)
  106. Index / Match / and search for result between two dates and a little bit more complex (2 replies)
  107. Excel custom data validation with drop down list (7 replies)
  108. VBA Loop help (Error Loop without Do) (5 replies)
  109. [SOLVED:] Grab data between two dates using arrays (7 replies)
  110. VBA (3 replies)
  111. VBA (1 replies)
  112. paste special values for multiple pivots (1 replies)
  113. Compare if any changes then highlight (12 replies)
  114. [SOLVED:] Average values within time range for matching header (8 replies)
  115. [SOLVED:] Formula to calculate AVERAGE but only to last used row in a grid. (3 replies)
  116. VBA auto outlook 2016 to send e-mail based off criteria (0 replies)
  117. ComboBox change for multiple comboboxes (4 replies)
  118. [SOLVED:] duplicating range (4 replies)
  119. Modify VBA code for Advanced Filtering (10 replies)
  120. Simplifying and looping VBA (2 replies)
  121. VBA to search in sheet1, match data in sheet2, return search results in sheet1 (14 replies)
  122. [SOLVED:] Copy values only not the formats. (4 replies)
  123. Object required (Error 424) (5 replies)
  124. Concatenate Multiple Cells (19 replies)
  125. [SOLVED:] Copy sheet and paste values - VBA (1 replies)
  126. [SOLVED:] Combine two arguments into one. (6 replies)
  127. [SOLVED:] Fill Series of Sequential Numbers in Column A Based on Last Value in Column B - VBA (1 replies)
  128. Code error 9. Create a workbook and worksheets in relation with variables (2 replies)
  129. Using different Range in the body of email based on row criteria - Appointments (11 replies)
  130. disable close "X" button (4 replies)
  131. ThisWorkbook.SaveAs fails at second attempt (20 replies)
  132. [SOLVED:] How to reuse variable value across Private modules (7 replies)
  133. userform menu problem (3 replies)
  134. [SOLVED:] Linking Label Caption To Textbox (11 replies)
  135. path string in cell (5 replies)
  136. [SOLVED:] A text box in excel that contains a Picture taken from a file (3 replies)
  137. Convert table of contents to another format (5 replies)
  138. run msgox at certain times of the day only if a specific workbook is still open (1 replies)
  139. VBA select/send email based off criteria (2 replies)
  140. How to check for conflicts in a schedule? (0 replies)
  141. Can't get code to loop through worksheets (4 replies)
  142. VBA code to lock the active sheet (2 replies)
  143. Time of creation of shape (4 replies)
  144. Active X component cant create object (2 replies)
  145. [SOLVED:] Find unique records between 2 sheets and delete (3 replies)
  146. WORKDAY #VALUE ERROR (2 replies)
  147. Range not selecting correctly? (2 replies)
  148. Read outlook emails copy to excel. (9 replies)
  149. Run "x" number of random draws and calculate totals against a pre-defined set. (1 replies)
  150. Delete duplicate rows if they do not contain a specific word (5 replies)
  151. Compare 2 different excel sheets (3 replies)
  152. [SOLVED:] VBA Celloffset function in For Each Cell function not work (4 replies)
  153. For loop delete entire row if cell is blank (1 replies)
  154. Looping to find difference in time within string (5 replies)
  155. Copy Worksheet to another Workbook - VBA (2 replies)
  156. [SOLVED:] Help Loop and Count if more than one unique (2 replies)
  157. [SOLVED:] Combine worksheets and move row and columns (0 replies)
  158. [SOLVED:] Left & Copy (3 replies)
  159. small logic is missing (auto mail) (1 replies)
  160. Cumulative sum based on a condition (2 replies)
  161. [SOLVED:] If Cell is Highlighted -> Copy Row and Paste in Sheet2 (9 replies)
  162. Extracting the URLs from a tweet (18 replies)
  163. [SOLVED:] Delete row if it contains a certain word or phrase - and use array (2 replies)
  164. [SOLVED:] Compare two lists of numbers (3 replies)
  165. Get multiple values from sheet and assign to textboxes (1 replies)
  166. [SOLVED:] VBA Code to Match US Region to the State that is entered (61 replies)
  167. Problem with Folder Picker (4 replies)
  168. Data Merge - Identify Rows Not Pulled Over from Sheet2 into Sheet1 - VBA (1 replies)
  169. VBA code to subtract the time diferences in the userform. (5 replies)
  170. Path/File Access Error - Replacing text in xml with text from excel (0 replies)
  171. Corrupt data in workbook? (2 replies)
  172. [SOLVED:] Template SaveAs on First Open (1 replies)
  173. How to check if a cell contains something or not (4 replies)
  174. [SOLVED:] Filtering unique data & Remove duplicate rows & save unique record range in new book (14 replies)
  175. Pls correct my code (sending mails) (5 replies)
  176. Nested Loop to create multiple series in a single chart. Where did I go wrong?? (4 replies)
  177. [SOLVED:] Time Rounding VBA (Custom Function?) (10 replies)
  178. Some last problems with barcode prog. ' SetFocus, Barcode Length ,Autosave' (6 replies)
  179. Macro to create new sheets when master is updated (4 replies)
  180. Copy Used Row (1 replies)
  181. Help Needed: Picking Shortage Corresponding Date (0 replies)
  182. [SLEEPER:] VBA Books/Courses For A Novice (4 replies)
  183. [SOLVED:] Code To Save Worksheets As Individual .txt But Only The First 9 Columns Of Each sheet (6 replies)
  184. new logic need to add to the code (1 replies)
  185. Filtering out a specific range and pasting it a row below (3 replies)
  186. ListBox on Userform doesn't refresh (3 replies)
  187. VBA help (1 replies)
  188. [SOLVED:] Filling in blank cells with data from another workbook - VBA (7 replies)
  189. Matching multiple values from different column (1 replies)
  190. Toggle to Hide Rows (2 replies)
  191. VBA Paste As Values (3 replies)
  192. Moved: VBA: Picture in Word-Header? Position? (2 replies)
  193. Merging columns (2 replies)
  194. Select Case Function on a CommandButton/ToggleButton (4 replies)
  195. Retrieve value based on selection (1 replies)
  196. Data validation (1 replies)
  197. [SOLVED:] Combining two sets of data into one - vlookup, comparing part numbers - advanced VBA (3 replies)
  198. Multiple column select in VBA (6 replies)
  199. [SOLVED:] QR-reader to Excel (with time stamp) (6 replies)
  200. Vba help for a lookup table (1 replies)
  201. Help VBA using excel function help (2 replies)
  202. Removing duplicates from multiple columns (23 replies)
  203. [SOLVED:] VBA - Extracting 3 Text Lines From Text files (26 replies)
  204. hide and protected sheet macro not working (2 replies)
  205. VBA ONE TO ONE AND MANY HIGHLIGHTED (0 replies)
  206. [SOLVED:] Start Loop Rows From - Row 10 on wards - Listing Files (8 replies)
  207. obtain distinct rows based on three columns (2 replies)
  208. [SOLVED:] Delete any row which does not have any cells which are conditionally formatted (11 replies)
  209. VBA code to sort, compare, and line up two lists of data. (1 replies)
  210. Need help reconstructing macros on this file in my description please!!! (5 replies)
  211. [SOLVED:] Declared Variable not selecting the correct range (8 replies)
  212. Copy down text in columns until next part number - VBA Code (5 replies)
  213. Sum if Index Match with multiple criteria (6 replies)
  214. Help with duplicate matches when using Index(Match( (0 replies)
  215. avoid iterations (0 replies)
  216. Loop for certain text in cell - delete cells and shift up (3 replies)
  217. [SOLVED:] SPLIT STRING issue with array if element not found (10 replies)
  218. how do I save as .xlsx using xcell compiler (5 replies)
  219. create workbooks based on a given template using data in a table (2 replies)
  220. [SOLVED:] Need Help constructing a vba counts rows between data and. Please (3 replies)
  221. [SOLVED:] Why is "1D050" numeric? (6 replies)
  222. [SOLVED:] Returning Description Based on Field Value (2 replies)
  223. [SOLVED:] Looping For Duplicates In 2 Dynamic Columns (Odd Issue) (4 replies)
  224. [SOLVED:] Exporting Worksheet Code Modules - Export Code As Worksheet Name (8 replies)
  225. Data Validation (4 replies)
  226. VBA help to convert unstructure data to structured data (0 replies)
  227. [SOLVED:] Add 1 row below a selected cell using a user input box (3 replies)
  228. i want to validate users entered value with existing range in another sheet (1 replies)
  229. [SOLVED:] Search with Criteria on Userform (1 replies)
  230. Rename Current PDF file name using Excel Sheet List (2 replies)
  231. Random Sequencing (8 replies)
  232. Learning VBA Variables (2 replies)
  233. Email alert not firing with VBA even though the condition is satisfied. (3 replies)
  234. Copy and pasting time calculations (1 replies)
  235. Formula working wrong, I can't identify why. (0 replies)
  236. VBA: Help me write a code in vba (5 replies)
  237. Make userform stay on top of all windows when macro is fired (22 replies)
  238. [SOLVED:] trying to pull dynamic webquery data (1 replies)
  239. Syntax for Evaluate SumProduct in VBA (6 replies)
  240. trying to finish my vbaproject barcodescanner (25 replies)
  241. Help me to correct the vba (2 replies)
  242. Drag Drop Reorder part of Row .. Excel (1 replies)
  243. Logging other PC programs via VBA excel (1 replies)
  244. Update data entry for all future months (not a single month) (0 replies)
  245. Copy Leading Numeric Values, then Remove (7 replies)
  246. The BIG DATA Challenge - Match cells on BIG DATA Sheet (LOOP take 4 Hrs !) (27 replies)
  247. Problem in Executing the Code (4 replies)
  248. Create multidimensional array from several non adjacent table columns (3 replies)
  249. [SOLVED:] Split files and attach them to an email (0 replies)
  250. Open multiple password protected workbooks in a folder (4 replies)