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. Move Files from current folder to a new subfolder specified in a column (4 replies)
  2. RE: Pivot filter Month selection - Automatic Population in respective column (6 replies)
  3. VBA code to filter a specific column (0 replies)
  4. Paste data to another tab based on meeting criteria (3 replies)
  5. Automatic update of pivot table wiht error - EXCEL (0 replies)
  6. Blinking Cells when I reach a certain value (4 replies)
  7. Extracting specific lines from multiple text files and save it in a single excel shee (2 replies)
  8. Paste without source file name (4 replies)
  9. Data to blank cell (0 replies)
  10. Excel Macro help (2 replies)
  11. Copy Paste Selected Rows (1 replies)
  12. Left/Right formula not working (18 replies)
  13. [SOLVED:] Help : Stop Application.onTime before this workbook close (3 replies)
  14. [SOLVED:] Stop macro running if row empty (2 replies)
  15. Prevent VBA from activating the sheet when it updates a chart. (0 replies)
  16. [SOLVED:] Predict Date of Enlistment (53 replies)
  17. [SOLVED:] Copying Down Formulas to New Row (9 replies)
  18. Sleeper: Filtering by some specific value (0 replies)
  19. [SOLVED:] Advanced locked Filtering data (0 replies)
  20. I want to copy and paste a chart together with its linked-to data? (1 replies)
  21. Log the results (29 replies)
  22. Help to moving file to another folder, using partial filename (0 replies)
  23. [SOLVED:] Search worksheet for multiple strings of text, then delete those rows (29 replies)
  24. [SOLVED:] Extract Value from Text (3 replies)
  25. [SOLVED:] Condition Base Min & Max (2 replies)
  26. PasteSpecial options (2 replies)
  27. Populate fields based on the filter (8 replies)
  28. [SOLVED:] Need some help with the Regular Expression (2 replies)
  29. VBA form - Choose an item from 2 list boxes to select one row (0 replies)
  30. Count left alignment cell (2 replies)
  31. [SOLVED:] VBA Conditional Formating - Cell 1 format based on Cell2 <= other worksheet cell3 (14 replies)
  32. Adding and Compressing(SizeKb) Image to Comments Field (2 replies)
  33. Vba search function not pulling links through. (4 replies)
  34. [SOLVED:] Search for specific words in worksheet and make bold (1 replies)
  35. Web scrapping vba (0 replies)
  36. Macro to create a database (3 replies)
  37. [SOLVED:] Execute submacro a set number of times until criteria is met (4 replies)
  38. Convert numbers into words for printing checks (1 replies)
  39. Automatic changing of cell colors (1 replies)
  40. Need Help with VBA code - Excel (7 replies)
  41. Please Help ( vba combobox code ) (1 replies)
  42. [SOLVED:] Highlight Cell With Search Values (4 replies)
  43. [SLEEPER:] Found max number (1 replies)
  44. Help with some code? (1 replies)
  45. [SOLVED:] Passing variables between modules (8 replies)
  46. Copy data from folder and sub folder to master workbook base in sub folder names (0 replies)
  47. Advanced find mewthod with copying values (0 replies)
  48. [SLEEPER:] How to parse json GET request with VBA? (5 replies)
  49. [SOLVED:] VBA code to speed up and automate multiple account, multiple site stock movements (26 replies)
  50. [SOLVED:] How to compare two arrays row by row? (16 replies)
  51. [SOLVED:] Help : Join String with Delimiter - need to have the option of downward or rightward (18 replies)
  52. Replace XML Null values (0 replies)
  53. [SOLVED:] Help : Apply formula to selected cells (2 replies)
  54. Limit Detailed amounts based on original balance (4 replies)
  55. [SOLVED:] Run Submacro If It Contains Data (23 replies)
  56. [SOLVED:] How far is the first occurrence of a coloured cell (2 replies)
  57. VBA Exponential Smoothing (8 replies)
  58. [SOLVED:] Left align text in joined cells (4 replies)
  59. [SOLVED:] Help Required : Highlight a part of text with in a cell (case sensitive problem) (2 replies)
  60. [SOLVED:] Run-time error '13' after several succes runs (3 replies)
  61. [SOLVED:] Help required in replacing InputBox with Select any one option (2 replies)
  62. [SOLVED:] Create a Hardcoded Workbook Copy (11 replies)
  63. amending code copy data from sheet to multiple without repeating (4 replies)
  64. Can’t find project or library - Microsoft Forms 2.0 ticked in error? (22 replies)
  65. [SOLVED:] Find each occurrence of a set of numbers in column and highlight the rows that contai (4 replies)
  66. sum only red fonts (5 replies)
  67. SUMIFS with Multiple criteria using Variables (4 replies)
  68. [SOLVED:] Difference between two 2D Arrays in VBA (10 replies)
  69. [SOLVED:] Fields mandatory (9 replies)
  70. [SOLVED:] Search Textbox (2 replies)
  71. COPY CERTAIN COLUMN IF ROW CONTAINS CERTAIN DATA FROM EXCEL TO WORD (1 replies)
  72. [SOLVED:] Looking in subfolders instead of root folder only (9 replies)
  73. [SOLVED:] filter and sum values based on three selection from dropdown (18 replies)
  74. [SOLVED:] Standard CTRL+C in ListBox (7 replies)
  75. [SOLVED:] VBA Macro - Import data from different excel file for a given value (3 replies)
  76. [SOLVED:] VBA for find values in range in multiple worksheets, copy values to UserForm (5 replies)
  77. automatic sort of a table, return to last used cell (2 replies)
  78. Delete Columns with blank or zero in total (2 replies)
  79. [SOLVED:] VBA Macro - pull two data sets, in the same column, to a separate spreadsheet (5 replies)
  80. [SOLVED:] Filter a txt file based on an Excel template (11 replies)
  81. VBA Help - Auto generate multiple rows base on cell value (3 replies)
  82. Help Required in Create and Open Folder and Track Changes (2 replies)
  83. VBA/Macro to insert rows based on drop downlist selection (4 replies)
  84. Finding the best rank of places to find the best path (using geographical coordinates (3 replies)
  85. [SOLVED:] VBA Check for multiple cell values and copy the cell in column A (6 replies)
  86. HELP!! CHALLENGING: FINDING BEST PATH TO TAKE (1 replies)
  87. vba help - show Top 3 performer (3 replies)
  88. [SOLVED:] Table Of Contents - Help required to customize the code (7 replies)
  89. Create user input box for range row in Excel (1 replies)
  90. VBA to search for different value in all worksheets and then write down where they ar (6 replies)
  91. [SOLVED:] Vba look for certain value and copy certain cell value in the same row (3 replies)
  92. Restrict Replace Module (12 replies)
  93. [SOLVED:] Requesting help to correct the codes (4 replies)
  94. Conflicting Code (Add Row & Move Row to another Worksheet) (5 replies)
  95. How to move data between date rows using VBA? (5 replies)
  96. [SOLVED:] Paste to next empty row in another workbook (3 replies)
  97. [SOLVED:] VBA to add new row above and include formatting (2 replies)
  98. save from template to range value name workbook (1 replies)
  99. Sum with integer (5 replies)
  100. [SOLVED:] Delete Hidden Rows when Filter applied (2 replies)
  101. [SOLVED:] VBA Sum function NOT calculating small values (3 replies)
  102. Converting three calculators in a workbook into one with a dropdown box (hardcoded) (7 replies)
  103. Disable SAVE/SAVE AS and Make Savable Again after Username and Password (12 replies)
  104. Array of unique values in a Column range (18 replies)
  105. VBA (1 replies)
  106. Formula Assistance Required (2 replies)
  107. [SOLVED:] Creating an 11 digit number (14 replies)
  108. Macro to copy a cell value and put in different worksheet (0 replies)
  109. What function should I use? (7 replies)
  110. Truncate Data in Excel VBA to prompt Pass or Fail (6 replies)
  111. Auto Filter Data from Multiple Worksheets Using only One Combobox (6 replies)
  112. Trouble sorting as part of a Macro (5 replies)
  113. Generating a table of events based on a calendar on a different worksheet (2 replies)
  114. Is there a way to protect or lock my macro? (2 replies)
  115. How to hide/unhide worksheets based on cell value? (0 replies)
  116. excel to pdf print (10 replies)
  117. [SOLVED:] HELP - Calculate Based on Dynamic Variables (What-if Scenario) (5 replies)
  118. [SOLVED:] Debugging VBA built on Excel2013 not working on v2016 (3 replies)
  119. VBA Code Copy&Paste Request (5 replies)
  120. [SOLVED:] RE: Pivot table creation in existing sheet- VBA issues (19 replies)
  121. VBA look for cell next to first blank, copy and paste (3 replies)
  122. Macro to find best way to combine numbers to equal a certain sum (3 replies)
  123. [SOLVED:] VBA code to calculate dates from an event (2 replies)
  124. [SOLVED:] Object Required Error in UnHiding rows (6 replies)
  125. Change alignment (4 replies)
  126. VBA code to open workbooks in a folder, create new sheet, paste headers and formulas? (4 replies)
  127. VBA Time Stamp for single cell entry (1 replies)
  128. Xlsm file problem (7 replies)
  129. [SOLVED:] Custom Sort On Column (7 replies)
  130. [SLEEPER:] VBA Sum Array Formulas (13 replies)
  131. [SLEEPER:] VBA Macros 438 runtime error (1 replies)
  132. [SOLVED:] Function for checking and opening a workbook (6 replies)
  133. Extract and move records , then delete from master sheet (0 replies)
  134. How to fix a messed Excel sheet and make a proper format? (1 replies)
  135. [SOLVED:] Drag tool to adjust formulas correctly (1 replies)
  136. [SOLVED:] VBA Disbale Copy&Paste in target range (not complete sheet/workbook) (3 replies)
  137. How to create a macro that puts today's date and time in cell (7 replies)
  138. Type Mismatch error when there is no type mismatch (2 replies)
  139. Expand VBA code to search Column & Paste Cells to Other Sheet (3 replies)
  140. Use a master list to run a macro that opens, extracts, and closes multiple workbooks (4 replies)
  141. VBA help on pulling data from an external workbook (3 replies)
  142. [SOLVED:] VBA Index Match across two worksheets (2 replies)
  143. VBA conks out on very simple code (15 replies)
  144. Upper Case (2 replies)
  145. [SOLVED:] Convert Excel Cell Text in Bold or Italic to HTML Tags/Convert Cell Line Breaks (32 replies)
  146. [SOLVED:] Need VBA Help With the following info (4 replies)
  147. Filter/paste rows by months in the near future (0 replies)
  148. [SOLVED:] Like Operator (2 replies)
  149. Last save time (8 replies)
  150. [SLEEPER:] Could use some VB help with dealing with combo box data from a Union All query (5 replies)
  151. Scroll Bar (Form Control) Offset Table - Sync Scroll Bar Pos. Across Multiple Sheets (5 replies)
  152. Vlookup not working when Table array refers to a cell with variable (3 replies)
  153. Populate in listbox (0 replies)
  154. VBA Help - Code for Report Updates (0 replies)
  155. Making a dynamic list. (3 replies)
  156. [SOLVED:] Userform search is not working after delete any record (2 replies)
  157. [SLEEPER:] Use Macro on Teams/Sharepoint/Onedrive (0 replies)
  158. VBA help for sales report (6 replies)
  159. [SOLVED:] User forms - Alternatives to Me.Field = "Value" (15 replies)
  160. Code to loop through ws only works on active sheet (12 replies)
  161. [SOLVED:] Locate a set value and copy the value in the cell that's below it (13 replies)
  162. Run time error 438 (2 replies)
  163. Call shortcut only in specific column (1 replies)
  164. [SOLVED:] Copy, Find Match in another worksheet, and then Paste Range (2 replies)
  165. Excel VBA Multiple loops (2 replies)
  166. [SOLVED:] Need assistance copying Cells that just contain certain data (7 replies)
  167. [SOLVED:] SUMPRODUCT HELP? (3 replies)
  168. Looking to make this macro Faster (1 replies)
  169. Auto-expand text rows in protected worksheet - can I do it? (1 replies)
  170. Filter Listbox value marching with Combobox value (1 replies)
  171. Find & Replace - All worksheets except one and with different Target column (2 replies)
  172. Change String (1 replies)
  173. Easy! Need some help, Delete Line from txt file (2 replies)
  174. (Question) Make Subtotal ignore ="" Cells (1 replies)
  175. [SOLVED:] Excel formula syntax (2 replies)
  176. [SOLVED:] RE: copy paste entire pivot data Using VBA (13 replies)
  177. VBA code to copy data from Excel by rows to multiple text files (0 replies)
  178. Help about sorting rows and assigning a new field automatically? (1 replies)
  179. SaveAs2 fileformat/encoding not working ??? (3 replies)
  180. Add-In Buttons Delete When Excel Closes (0 replies)
  181. Filtering a DefinedName that a ComboBox pulls from within a VBA Form (0 replies)
  182. Extracting data from excel VBA (2 replies)
  183. [Question] Dynamic amount of averages (5 replies)
  184. Open specific worksheet and hide all other worksheet (6 replies)
  185. Run-time error 1004: The extract range has a missing or invalid field name (1 replies)
  186. [SOLVED:] Date Not Filtering Correctly (16 replies)
  187. "Run-time error '1004' with .xlt file (0 replies)
  188. VBS for Check the zide and move files (0 replies)
  189. fixing error code get folder names and files names (2 replies)
  190. [SOLVED:] Create a new folder based on cell and copy list of file into created folder (1 replies)
  191. Exiting Command Prompt window from Excel (0 replies)
  192. [SOLVED:] Make code more efficient (5 replies)
  193. [SOLVED:] IF condition is not working with formula (9 replies)
  194. Importing text file into Excel but worksheet names are too long! (1 replies)
  195. [SOLVED:] Convert Many Invoice Formats to a Standard Format (116 replies)
  196. Counting the number of times a string appears on a filtered worksheet. (10 replies)
  197. Importing Multiple .Txt Files Into Excel Based on the Date Last Modified in VBA (1 replies)
  198. Excel VBA data transfer between workbooks (11 replies)
  199. [SLEEPER:] Create and fill X new rows based on instances of character in cell (5 replies)
  200. Run macro run by itself (1 replies)
  201. 2007 VBA: Cannot figure out recursion to show all possible paths in a 4 x 4 grid. (6 replies)
  202. [SOLVED:] Copy, Rename and validate multiple excel files (4 replies)
  203. Syntax To QuickSort A Range Of Numbers In An Array (1 replies)
  204. [SOLVED:] Multiple find and replace in Excell sheets (0 replies)
  205. Auto populate table from another worksheet (10 replies)
  206. [SLEEPER:] Is there any way to create a macro to keep doing nonlinear regressions? (1 replies)
  207. Finding IDs (1 replies)
  208. Search for Strings Listed in Column A and Insert Offset values in B (1 replies)
  209. If statement help (1 replies)
  210. [SOLVED:] Looping through Dates to Determine in Date Falls Between Other Dates (9 replies)
  211. [SOLVED:] Fuzzy Lookup add-in VBA (12 replies)
  212. [SOLVED:] VBA Coding Help for Conditional Formatting (2 replies)
  213. random selection from a growing range (3 replies)
  214. [SOLVED:] Vlookup to delete entire row on another worksheet (3 replies)
  215. [SOLVED:] Use dropdown to populate other cells (2 replies)
  216. [SLEEPER:] Intellisense working Sporadically (2 replies)
  217. [SOLVED:] Sequentially Number Search Using an Array (4 replies)
  218. [SOLVED:] AutoFilter Percent Values +-5% (38 replies)
  219. Macro wont run on duplicate columns (2 replies)
  220. Workbook open event not working (14 replies)
  221. Help to check string of file name, if meet will copy valu to master workbook (0 replies)
  222. Macro or form based solution for attached excel sheet (2 replies)
  223. Create New Folder Based on Cell Name and Copy Files into it (5 replies)
  224. help needed to calculate dates and time together (7 replies)
  225. Excel VBA with Advanced Filter Error messages (11 replies)
  226. [SOLVED:] Count number of occurrences via combobox in user form (3 replies)
  227. Export to PDF (specific sheets) if cells in Input sheet are >0, if condition is met (2 replies)
  228. [SOLVED:] 2007 Formula: Trying to locate a numeric value in a square named range. (4 replies)
  229. open file with vba (2 replies)
  230. Help with Debugging Code (0 replies)
  231. 2007: Issue with graphics shifting when saving to a PDF. (6 replies)
  232. Trying to rename individual shapes within a duplicated group. (2 replies)
  233. Update image/replace image from excel to PowerPoint (0 replies)
  234. Concatenate Values (0 replies)
  235. packing list serial number generator for boxes (9 replies)
  236. Adding and Activating Reference (3 replies)
  237. Convert Text to cells Sentences by Punctuation Marks (21 replies)
  238. Pivot Table Copy Paste 5 Days in a Row (0 replies)
  239. create a cubic grid shell in VBA (1 replies)
  240. 'Cascading' comboboxes (2 replies)
  241. If Checkbox is checked, display message... If checkbox is unchecked, do nothing (4 replies)
  242. [SOLVED:] loop through range inserting sum formulas based on start and end indicators (text) (1 replies)
  243. Updating VBA code to Paste Values only (2 replies)
  244. [SOLVED:] Loop Vlookup for each cell in range from another worksheet (2 replies)
  245. [SOLVED:] Highlight minimum value ignoring 0 (7 replies)
  246. Error checking on existing roster (4 replies)
  247. [SLEEPER:] Folder and cell value (0 replies)
  248. XML Map Export and Save (0 replies)
  249. transfer if there are no blank cells (0 replies)
  250. Assistance needed for converting formula in Array VBA. (2 replies)