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:] Need help restructering Macro for specific result, Please (5 replies)
  2. vlookup within for loop vba (1 replies)
  3. Macro to replace part of a formula with result (14 replies)
  4. [SOLVED:] Clear all cells vba (4 replies)
  5. Run time error 91 (2 replies)
  6. Multi ComboBox2 and TextBox how to update this whit less code (5 replies)
  7. Transposing multiple columns into one column while repeating the names (33 replies)
  8. [SOLVED:] Extract & paste the filename into another workbook (1 replies)
  9. [SOLVED:] CF in Pivot Table (12 replies)
  10. Combobox: Optionbutton dependent lists (8 replies)
  11. Well versed in formulas but NOT VBA Code - Help a noob! (2 replies)
  12. [SOLVED:] Pivot Time? (2 replies)
  13. Userform Errors (12 replies)
  14. Find function (2 replies)
  15. loop through checkboxes (10 replies)
  16. Need help in excel vba (3 replies)
  17. Pause VBA loop until sheet is recalculated (6 replies)
  18. Populate data from 2 columns (0 replies)
  19. [SOLVED:] Create a workbook from a worksheet and name it from a list (0 replies)
  20. Exporting Query from Access to Excel - Inconsistent Results (2 replies)
  21. [SOLVED:] Excel 2010 vs. 2016 Functions won't Work (1 replies)
  22. Userform Multiple WebBrowser issue Excel 2010 (0 replies)
  23. Basic VBA Help with Ifs, fors, and relative referencing (8 replies)
  24. [SOLVED:] How to suppress JavaScript errors when loading a webpage into a WebBroswer control (1 replies)
  25. Not getting response in soap service call from excel vba (5 replies)
  26. [SOLVED:] Lookup or Index Match Formula (10 replies)
  27. [SOLVED:] VBA merge excel sheets into new sheet with some conditions (20 replies)
  28. Help With For Loop (4 replies)
  29. [SLEEPER:] How can we convert arabic numbers to English number using VBA in Excel? (2 replies)
  30. VBA Code to go through one column cells, I don't have range, I have only one column? (14 replies)
  31. Macro to expand SUMPRODUCT Formula (1 replies)
  32. Need Help: Changing Sheet Index Property in VBA code (8 replies)
  33. PivotTable not functioning (4 replies)
  34. calculate salary for specific record (1 replies)
  35. Copy multiple tables from multiple sheets to a master list sheet (0 replies)
  36. [SOLVED:] Need help creating a macro that produces a dual cursor (2 replies)
  37. Terminology (2 replies)
  38. [SOLVED:] How to display Elapsed time on a Excel User Form ( Using Excel 2007) (2 replies)
  39. Salary calculation problem (4 replies)
  40. Produce report on new page with current date (4 replies)
  41. Copy File List - Show Which Files Were Copied Succesfully (1 replies)
  42. vba column to pivot table converted field (1 replies)
  43. Validate Date and Compare Amounts (6 replies)
  44. VBA code Problem (2 replies)
  45. macro to copy exel data to powerpoint (0 replies)
  46. rounding number problem in vba (1 replies)
  47. reorganizing cell data on a diferent sheet (2 replies)
  48. Compare ID and Header Two Worksheets (2 replies)
  49. VBA function for representing click on ribbon icon (command bar) icon (1 replies)
  50. Fill Down, but not locked into one value. (2 replies)
  51. [SOLVED:] Excel splash screen not working while macro runs (4 replies)
  52. Remove page info in cell (3 replies)
  53. [SOLVED:] Searching in specific sheets problem (15 replies)
  54. Find nearest greater value (1 replies)
  55. Problems using For Loops and Find function (1 replies)
  56. [SOLVED:] List 4 number combinations (2 replies)
  57. [SOLVED:] Need Help with a Conditional Format (5 replies)
  58. Macro to copy data from all the files in folder and paste in single sheet (1 replies)
  59. Macro to copy data rom all the files in folder and paste in single sheet (5 replies)
  60. Automatically move to next sheet and perform Macro (2 replies)
  61. [SOLVED:] VBA remove specific characters in cell (6 replies)
  62. Automation error during mail merge in Excel VBA (4 replies)
  63. Immediate window for changing dates (7 replies)
  64. [SOLVED:] need help please in contructing a macro for excel, please! (22 replies)
  65. VBA Varible IF Statement (14 replies)
  66. [SLEEPER:] Lock Cells based on criteria (1 replies)
  67. Formula Chart vs smae chart without specific item (2 replies)
  68. Visible cells (2 replies)
  69. [SOLVED:] VBA to delete cells based on cell selected and move cells up (2 replies)
  70. How to get the data from website (javascript) to excel by using vba (2 replies)
  71. Macro of copy and paste loop (1 replies)
  72. When macro tries to modify a chart in a protected sheet (UserInterfaceOnly) -> Error# (1 replies)
  73. [SOLVED:] need help to construct vba to label order of value in a cell and rslt to nxt col plea (3 replies)
  74. Excel VBA to open Word doc, then populate, then Save it as PDF (5 replies)
  75. [SOLVED:] sync 2 seperate gps times in two different columns (22 replies)
  76. [SOLVED:] Vba code that creates an input mask for a password ***** in an input box (7 replies)
  77. Count number of occurrences of text in the same cell separated by ";" (2 replies)
  78. Assistance with data counting in VBA (4 replies)
  79. Need Help Duplicating dates in a column, with a VBA. Please (3 replies)
  80. Need help hi lighting numbers with formulas in a cell (17 replies)
  81. Create command buttons based on sheet names in UserForm1 (7 replies)
  82. [SOLVED:] Small problem with my code (4 replies)
  83. Extracting data from a Sheet-VBA Help (2 replies)
  84. [SOLVED:] Copying, naming, and saving a master workbook (7 replies)
  85. Web Scraping - Why does the code stop? (1 replies)
  86. [SOLVED:] Excel 2013>VBA>Array>Fill with loop (3 replies)
  87. [SLEEPER:] Dynamic tax calculator (18 replies)
  88. [SOLVED:] 424 Error, but object is in place (7 replies)
  89. Macro to loop through solver and post results to separate sheet (0 replies)
  90. Set Range to Existing Range Name based on criteria (28 replies)
  91. Dynamic Conditonal Statements Help (5 replies)
  92. [SOLVED:] Find max min of subsets only after Instruction given (9 replies)
  93. Populate 2nd tab by taking data from 1st tab (6 replies)
  94. Import sheets (1 replies)
  95. Select multiple sheets now not working (2 replies)
  96. [SOLVED:] Change picture depending on choice (3 replies)
  97. [SOLVED:] Select case debug error (23 replies)
  98. Lookup value in column and get result from relevent page (2 replies)
  99. Returning multiple results with Index/Match (15 replies)
  100. [SOLVED:] need help understanding How to invert number. please (7 replies)
  101. Saving and merging Word docs from Excel Sheet (0 replies)
  102. Automating Tasks in Excel via VBA (6 replies)
  103. .AllowMultiSelect = True works intermittently (2 replies)
  104. Function Simpification (5 replies)
  105. How to check the code of a macro which calculates the value of a certain cell? (12 replies)
  106. How to delete entire row if specific column has ANY data in it? (4 replies)
  107. excel vba multiple charts in new sheet (1 replies)
  108. Help, User input dynamic array (8 replies)
  109. [SOLVED:] Out of memory (7 replies)
  110. [SOLVED:] NEED with either fixing formual or preferably a macro to do this procedure. Please! (15 replies)
  111. Paste as Unique values and paste dynamic cell formulas too (0 replies)
  112. [SOLVED:] Addtional condition in array formula (6 replies)
  113. [SOLVED:] How do I convert text or string to time format using excel vba? (3 replies)
  114. Range of Rows filtered by column data (2 replies)
  115. [SOLVED:] Dynamic Array using Redim Preserve VS large static array? (9 replies)
  116. [SOLVED:] Excel 2013>VBA>UserForm>TextBox>Name as variable (5 replies)
  117. VBA to delete empty rows (8 replies)
  118. vba for each worksheet loop (4 replies)
  119. Finding duplicate values (1 replies)
  120. Count consecutive cells (rows) with same value (5 replies)
  121. VBA Password Prompt Appears on Exit from Excel (0 replies)
  122. [SOLVED:] Need Help restructuring this Macro for large amount of data. Please (9 replies)
  123. Disabling Cut Copy Paste in Excel 2013 not working (0 replies)
  124. [SOLVED:] Determining number of rolls to delete (3 replies)
  125. Create a wizard for Users (0 replies)
  126. how to do this with vba? a difficult question (1 replies)
  127. Sending SMS through VBA (1 replies)
  128. [SOLVED:] UserForm does not show ... Runtime error (4 replies)
  129. Excel 2013>VBA>Match>Wildcard (8 replies)
  130. [SOLVED:] VBA Conditional Formatting not Applying (3 replies)
  131. Pasting into an existing column (7 replies)
  132. Cell referencing in formula (2 replies)
  133. [SOLVED:] VBA Code to enter different formula if value is different (12 replies)
  134. Hyperlink Help (4 replies)
  135. How to Loop? (5 replies)
  136. [SOLVED:] Hide row if cell contains... (3 replies)
  137. MsbBox code help (2 replies)
  138. Copy UserForm text box values to another workbook (3 replies)
  139. VBA code for message box popup if data already exist. (10 replies)
  140. VBA for workbook path sending in an email (3 replies)
  141. VBA script to auto send e-mail using closed Excel Workbook (0 replies)
  142. Can't Get Userform to Pop Up After Deleting Worksheet (6 replies)
  143. Run code if hyperlink clicked falls in target range (8 replies)
  144. VBA works in one workbook but not another (6 replies)
  145. How to call Auxiliary Functions (2 replies)
  146. Copying an entire row and pasting it on next row (loop) (2 replies)
  147. Stepped through with no issues...but still obtained an error? (2 replies)
  148. need a 2 input solver (1 replies)
  149. Excel 2013>VBA>AutoFilter>Multiple Fields Multiple Criteria (2 replies)
  150. [SOLVED:] I need to remove the offset (22 replies)
  151. Comparison between two worksheets and find the difference (1 replies)
  152. Else If - Do Nothing (2 replies)
  153. [SOLVED:] Page in multipage form dont show picture, comand button and so on after swapping (5 replies)
  154. [SOLVED:] Problem with pasting a concatenate value using VBA (9 replies)
  155. Please configure my code with automatic filter (1 replies)
  156. [SOLVED:] VBA: copy/pastespecial between workbooks (2 replies)
  157. [SOLVED:] Detect listbox item is numeric problem (2 replies)
  158. Stacking columns from several worksheets into a new worksheet (6 replies)
  159. Excel 2013>VBA>Named Range>Display filtered range in listbox (1 replies)
  160. Print sheets based on partial sheet name? (3 replies)
  161. VBA Script to Copy Excel Chart to Word not working in later versions of Word (1 replies)
  162. [SOLVED:] Range " does not contain" - code (12 replies)
  163. macro to copy excel to powerpoint (0 replies)
  164. VLookup in VBA returning an empty string Why I was expecting the value I was serching (8 replies)
  165. 'Unique Filter' applied on look back for multiple entries (2 replies)
  166. From a form - write todays date and a variable value in the next available row (3 replies)
  167. How do i select a table range in VBA (3 replies)
  168. [SOLVED:] Problem with Macro (2 replies)
  169. Macro to copy the 0 number (8 replies)
  170. Consolidate and remove duplicate (3 replies)
  171. Data Validation / Indirect help (0 replies)
  172. Import Multiple Text Files from a folder to multiple worksheets (6 replies)
  173. [SOLVED:] Script to desseminate broker statement into trade journaling software (11 replies)
  174. [SOLVED:] Change Layout of Column chart (1 replies)
  175. Transferring Data Between Sheets (Excel VBA) (2 replies)
  176. If first conditions is NOK else go to second condition (4 replies)
  177. [SOLVED:] Need help restructuring code tohighlight numerical data w/o special characters please (12 replies)
  178. VBA code to apply to whole workbook (1 replies)
  179. vba to append data by sheets name (6 replies)
  180. [SOLVED:] Toggle Visibility of the Drop Down of A Specified Table Column (10 replies)
  181. Help with workbook source and textbox value (5 replies)
  182. Help with Reusing file name (0 replies)
  183. [SOLVED:] Need Help in contructing a Macro the returns frequ. of searched data in chart,please! (8 replies)
  184. Open Workbook when the workbook name is combination of cells (3 replies)
  185. How to sort numbers and strings at once? (22 replies)
  186. [SOLVED:] Run Time Error when I click on a button twice (11 replies)
  187. [VBA] Query an Outlook Distribution List from Excel (0 replies)
  188. [SOLVED:] VBA to copy row if cells contain value (9 replies)
  189. move email from a frolder to different folder from Desktop (0 replies)
  190. [SOLVED:] Sending e-mail from Excel with Outlook behaving badly (2 replies)
  191. VBA to auto filter based on 4 criterias (2 replies)
  192. VBA to autofilter between dates in one column based on text value in another cell (1 replies)
  193. Replace Multiple Carriage Returns with Single Carriage Returns (9 replies)
  194. [SOLVED:] Excel 2013>OFFSET>Count visible columns in a row that are >0 (3 replies)
  195. [SOLVED:] Problems with hidden rows (6 replies)
  196. [SOLVED:] How do I create a macro that allows me to show and hide rows with only one button? (2 replies)
  197. [SOLVED:] VBA :FORMAT AS TABLE BASED ON ENTERED DATA (5 replies)
  198. [SOLVED:] VBA to open file with date and partial name (13 replies)
  199. [SOLVED:] Macro to automatically paste the selected column into another sheet (23 replies)
  200. [SOLVED:] need help constructing a vba macro by using a key chart to reanslate number combin to (8 replies)
  201. [SOLVED:] Save Workbook As .txt File With Delimiter (10 replies)
  202. [SOLVED:] Help, i need to create a command button for saving selection as txt file (4 replies)
  203. [SOLVED:] Need help restructuring or recreating VBA code Please! (23 replies)
  204. Copy a range of cells (9 replies)
  205. [SOLVED:] Copying multiple sheets with varying numbers of rows to one sheet. (8 replies)
  206. [SOLVED:] Need help with constructing a macro that counts dates as one day. (6 replies)
  207. [SOLVED:] Issue consolidating data to another worksheet (3 replies)
  208. Select range on Row until last empty cell (4 replies)
  209. Macro help to copy from Excel into email without duplicating info (1 replies)
  210. [SOLVED:] VBA & OLAP Pivot:Code to set report filter pvt field with items from another pvt tabl (6 replies)
  211. Compile error (8 replies)
  212. Copy Data from One Sheet to another Specific sheet (16 replies)
  213. Open outlook new email and attach most recent file from directory (9 replies)
  214. Dynamic gradient chart background (1 replies)
  215. [SOLVED:] Custom Formatting (7 replies)
  216. Help with Macros for Conditional display (3 replies)
  217. [SOLVED:] Exit Do after search item no longer found in a range (3 replies)
  218. Need help wth a Macro (9 replies)
  219. Split data based on criteria (2 replies)
  220. [SOLVED:] Need help constructing VBA code to enter selected letter into cell after data already (3 replies)
  221. [SOLVED:] VBA multiple Goal Seek depending and selection (2 replies)
  222. [SOLVED:] Deleting rows based on values of cells in TWO different columns (2 replies)
  223. [SOLVED:] Moving Data around in a Row. (2 replies)
  224. [SOLVED:] Windows activate + Todays date (2 replies)
  225. Filter large files without opening (10 replies)
  226. [SOLVED:] Find and open latest csv file in given directory (23 replies)
  227. Find external links within code (0 replies)
  228. Navigation With Firefox (0 replies)
  229. [SOLVED:] Populating specific cell with data from a userform when an option button is selected (3 replies)
  230. Drill Down Pivot Same Page (0 replies)
  231. [SOLVED:] Linking to cells in another sheet with VBA - Can my code be improved? (11 replies)
  232. Calculate distance between point and rectangle (30 replies)
  233. Transpose Horizontal Table (8 replies)
  234. Macro to check value, open file, copy value, loop through range. (4 replies)
  235. [SOLVED:] Addressing problem in loop (11 replies)
  236. [SOLVED:] Need help with constructing a vba code, please! (7 replies)
  237. Check Points within Rectangles (22 replies)
  238. [SLEEPER:] Email Sending Userform problem (12 replies)
  239. Macro to Find Cells by Color and Copy to Different Worksheet (1 replies)
  240. Nested IF Statements - Please Help to Resolve (2 replies)
  241. [SOLVED:] VBA Excel clear cells causes error 400 (2 replies)
  242. Excel to ask what activity I am doing every hour (1 replies)
  243. Excel vba to open ie ribbon (1 replies)
  244. Consolidating worksheets into one and paste special (3 replies)
  245. [SOLVED:] VBA Excel - Collections unexpected answer (10 replies)
  246. Excel 2013 -> need help having two macro's in a workbook - already have one running (3 replies)
  247. [SOLVED:] Excel 2013>VBA>Sheets>Array (5 replies)
  248. [SOLVED:] Excel 2013>VBA>Clipboard (3 replies)
  249. Custom VBA Column to Row Insert and Transpose (4 replies)
  250. [SOLVED:] How do I lock the contents of a moving cell? (2 replies)