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. XML Source data format change, Macro's no longer working (21 replies)
  2. Formating date delimiters in real time (1 replies)
  3. Copy email id & contact numbers from multiple resume which is in word file (0 replies)
  4. CMD.exe window keeps "taking over" when looping (8 replies)
  5. [SOLVED:] Array declaration question - "myArray()" versus "myArray" (3 replies)
  6. Pivot error (16 replies)
  7. Cycling through filters (1 replies)
  8. Creating list of Unique values in offset cells (13 replies)
  9. Data Comparison between master workbook and another workbook (10 replies)
  10. ISNA alternative (0 replies)
  11. [SOLVED:] SUM IFS (Vba) (1 replies)
  12. Importing Data from Closed Workbook (1 replies)
  13. [SOLVED:] Help with Loop (21 replies)
  14. Pivot Table expand/collapse buttons (2 replies)
  15. date issue for excel file (6 replies)
  16. Help with worksheet_change (6 replies)
  17. Code for multiplying 2 values based on search (3 replies)
  18. [SOLVED:] Excel MultiLine Textbox to Access Database - MultiLine lost in the Access Database (7 replies)
  19. [Solved] Referring to a String within Quotations (2 replies)
  20. [SOLVED:] Create Outlook 2013 Calendar items without duplicates (7 replies)
  21. Urgent: Help Needed With INDIRECT Formula (1 replies)
  22. add date to the column during update in worksheet (3 replies)
  23. Reset Sub Workbook_BeforeClose (4 replies)
  24. How can I copy and image file from Access Table to Excel? (1 replies)
  25. place grid in parsed xlsx (1 replies)
  26. TextBox Has Numericals, Value is String of Hexadecimals (3 replies)
  27. [SOLVED:] Seletion problem in listbox (Userform) (13 replies)
  28. Exit from Sub which is called from another Sub (8 replies)
  29. Run-time error "91": (3 replies)
  30. [SOLVED:] Listview in userform to show data entred by textboxes and comboboxes (37 replies)
  31. AutoFilter and Copy - Paste (3 replies)
  32. Macro to Copy data from Input sheet to Output sheet based out few criteria (5 replies)
  33. Excel file which listed new for any update information (4 replies)
  34. Assigning a cell value to a variable - between different workbooks (5 replies)
  35. Help....for Changing Vba Code in a Pivot for Filtering a Criteria. (2 replies)
  36. VBA Shift One Row Down. (3 replies)
  37. Excel userform to search find and return data (1 replies)
  38. Macro to Convert text to Number to last cell in the range (11 replies)
  39. VBA problem can anybody help (1 replies)
  40. Use Find Method to Clear Groups of Cells in Column When First Cell Marked "DELETE" (40 replies)
  41. [SOLVED:] Creating a new row problem (4 replies)
  42. Cell Split or add Rows Excel VBA Leave Plan (4 replies)
  43. Pasting Rows from one Table to another (2 replies)
  44. Vlookup/Index match, Vba code for two sheets in a Workbook (2 replies)
  45. [SOLVED:] Returning the Desktop Path (3 replies)
  46. User Defined Function Call Error (11 replies)
  47. [SOLVED:] Formula - Sumif,sumifs, aggregate (3 replies)
  48. [SOLVED:] Transponse help (6 replies)
  49. [SOLVED:] Delete table last row (1 replies)
  50. [SOLVED:] IF / OR Statement (2 replies)
  51. Retaining the Macro code for disabling Save option in Excel (10 replies)
  52. VBA Expert Wanted! >> Populate Table by Cycling Through Sheets (4 replies)
  53. [SOLVED:] Text Box not Displaying (5 replies)
  54. Get data from a PDF...VBA (2 replies)
  55. fill in sequence number (6 replies)
  56. [SOLVED:] conditionally sum values based on the TOTAL of multiple columns being greater than 0 (4 replies)
  57. Prevent duplicates for 2 sheets + msgBox (1 replies)
  58. Conditional macro in Excel based on two or more conditions (2 replies)
  59. copy-paste from one Excel file to the other VBA (0 replies)
  60. Delete rows based on a condition (4 replies)
  61. [SOLVED:] How can I use a current worksheet rather than creating a new one? (2 replies)
  62. VBA: Compare 2 cells from different workbook and publish the text right or wrong (3 replies)
  63. [SOLVED:] Improve Multiple loop code (19 replies)
  64. [SLEEPER:] Need help creating VBA code for interpolation (kinda) (2 replies)
  65. Simple computation to record the difference between consecutive cells over a range (4 replies)
  66. [SOLVED:] Merging multiple worksheets into one (18 replies)
  67. VBA String Range Detection (5 replies)
  68. Macro for counting frequencies (6 replies)
  69. Splitting Sheets (6 replies)
  70. [SOLVED:] Workbook.Open Event not working correctly (15 replies)
  71. [SOLVED:] Filter on today's date (9 replies)
  72. Consolidating Multiple Sheets into One File (7 replies)
  73. Private VBA Apply to all New Worksheets (6 replies)
  74. [SOLVED:] Lock (freeze?!) objects (3 replies)
  75. Filter (6 replies)
  76. Quartiles with N/A (1 replies)
  77. Filter all sheets by filtering one sheet (5 replies)
  78. error parsing text files in directory using excel 2010 vba (5 replies)
  79. [SOLVED:] Find a string and clear cell's contents to the right (4 replies)
  80. Hello, how to distribute content to a cell by various cells automatically. (0 replies)
  81. [SOLVED:] Excel Macro Run-time error '1004': Selected method of Range class failed (4 replies)
  82. [SOLVED:] Selecting ONLY filtered cells NOT all the active cells in a column (2 replies)
  83. VBA Adding Table Row - Quick Fix Help! (1 replies)
  84. Combining matching values. (12 replies)
  85. Slicers:Extract selected & unselected items to a Range (0 replies)
  86. Copy paste first row with correct cell reference (2 replies)
  87. Some problems by using two userforms (6 replies)
  88. How to remove cells leading ' s when cvs (comma separated) file is imported in Excel. (3 replies)
  89. Excel Array formula (2 replies)
  90. Excel Macro not working properly (missing data pasted using macro) (2 replies)
  91. [SOLVED:] Need Help: Formula to get the amount (number) only out of text (3 replies)
  92. VBA Code- Insert formula up to last row (2 replies)
  93. Please Help !! Code Needs Slight Modification (0 replies)
  94. List File Hyperlink (2 replies)
  95. Trouble with code to grab data from multiple sheets and filter and list (3 replies)
  96. [SOLVED:] Save File in New Created Folder (7 replies)
  97. [SOLVED:] Copying values between two matching values... (4 replies)
  98. How to divide two values from a pivot table (1 replies)
  99. [SOLVED:] Trouble saving as PDF (4 replies)
  100. Suddenly Can't find project or library on something that has been working for weeks (5 replies)
  101. [SOLVED:] Run macro for selected rows (16 replies)
  102. How to dynamically place a VBA code to a Output excel file? (2 replies)
  103. [SOLVED:] How to use auto filter in excel vba? (8 replies)
  104. [SLEEPER:] Is it possible to convert a database with VBA macro in web page? (0 replies)
  105. Copy several pivot tables to new worksheet (1 replies)
  106. [SOLVED:] Click on Summary Tab to set Filter in detail Tab (3 replies)
  107. Auto filter criteria (3 replies)
  108. [SOLVED:] Summarising trading positions (6 replies)
  109. [SLEEPER:] Extracting Data From Specific Cells From Each File Form A Netwrok Folder (6 replies)
  110. [SOLVED:] Different sum (1 replies)
  111. [SOLVED:] Help Required to make code run faster (14 replies)
  112. File name with some changing numbers (4 replies)
  113. [SOLVED:] Is it posible to "paste" a Dutch translation of an Ecel formula in a cell (14 replies)
  114. Create Multiple Excel Files from One file (3 replies)
  115. Need help copy cell based on other column value (8 replies)
  116. Populate Excel -Output Tab based on Input Tab (1 replies)
  117. Combine Macros (12 replies)
  118. [SOLVED:] Help with database in excell (6 replies)
  119. Simple IF statement help (6 replies)
  120. [SOLVED:] Multiple Monte Carlo Simulations (3 replies)
  121. Issue with Space in Path for Output File (5 replies)
  122. [SLEEPER:] Writing macros to calculate mutual fund performances (1 replies)
  123. Import value from adjacent cell in another workbook if cell meets criteria (2 replies)
  124. [SOLVED:] Clear textbox along with cell contents (8 replies)
  125. Absolute/Relative Workbook hyperlinks? (14 replies)
  126. Search button (3 replies)
  127. SpecialCells(xlCellTypeConstants).select shows unexpected behavior (for me) (23 replies)
  128. Add Date to all files in a folder (14 replies)
  129. [SOLVED:] Deleting an Entire Row (4 replies)
  130. Problem with VBA code - simulating profit and loss from delta hedging. (1 replies)
  131. Help: Auto Calculate Macro (3 replies)
  132. [SOLVED:] Radio Buttons on User Forms (17 replies)
  133. [SOLVED:] Delete row based on date and cell value (5 replies)
  134. For in columns Range (1 replies)
  135. Extract data from Multiple excel files (2 replies)
  136. [SOLVED:] Help in fixing LinkedIn code (18 replies)
  137. Disable copy paste code not working if data is copy pasted from different workbooks (0 replies)
  138. [SOLVED:] Generate an table Index (2 replies)
  139. Desperately lost in VBA code (2 replies)
  140. [SOLVED:] Pasting specific cells in A different order (2 replies)
  141. [SOLVED:] Delete All Rows except Row Containing Text and Row Above (3 replies)
  142. [SOLVED:] copy specific worksheet in xlsx as text file (32 replies)
  143. [SOLVED:] Different size in a joined string (5 replies)
  144. Loop excel files and sort it in a tree diagram (0 replies)
  145. Obfuscate a SHEET? (11 replies)
  146. [SOLVED:] Are multiple hyperlinks to run multiple macros within a single sheet possible? (2 replies)
  147. [SOLVED:] Need help with this VBA code (10 replies)
  148. Copy a Table from outlook msg body to Excel on receiving mail (1 replies)
  149. hyperlink to run macro not working (2 replies)
  150. Load zip structure in a treeview (vba) (2 replies)
  151. Calling a Sub from another Sub() (6 replies)
  152. appending textbox info from a userform to a worksheet as a comment (1 replies)
  153. [SOLVED:] Match Function Help Trying To Match Against All Worksheets In Workbook (2 replies)
  154. Vba code for 3 pivots in one sheet (2 replies)
  155. [SOLVED:] Placing Image - Different on another computer (1 replies)
  156. Excel 2010 Macro Security (2 replies)
  157. Scanning through multiple sheets and copying based on Header. (9 replies)
  158. Array Item used correctly (8 replies)
  159. [SOLVED:] Excel 2010 VBA - Issues with Drop Down box with Table Interface (6 replies)
  160. [SOLVED:] Problem with For and Cells (2 replies)
  161. [SOLVED:] Update a previously recorded row. (16 replies)
  162. Can macro simulate data? (5 replies)
  163. Excel VBA Charts to powerpoint (1 replies)
  164. [SOLVED:] Shell and Wait - 32 bit and 64 bit (37 replies)
  165. Vlookup macro replaced with an array (3 replies)
  166. VBA help to create summary table from a range of data. (7 replies)
  167. Wrong date VBA (4 replies)
  168. vba code for excel list of folder name, subfolder directory, file name and revision (4 replies)
  169. [SOLVED:] Search column header and copy (4 replies)
  170. Find two cross reference data points (2 replies)
  171. Need help with a complicated Concatenation and Abbreviation Macro (5 replies)
  172. Add current value to running total (3 replies)
  173. [SOLVED:] Changing name and range of horizonal and vertical axis in a stacked bar chart (12 replies)
  174. VBA for a calculation where the range is dynamic (2 replies)
  175. [SOLVED:] How can I fix my autofilter? (7 replies)
  176. UDF Several SUMIF optimination (3 replies)
  177. Save Workbook as HTML (7 replies)
  178. Look @ My Code - Aggregates CSV Files Into Single Spreadsheet - 2 Issues (2 replies)
  179. [SOLVED:] Run Time Error 13 - Type Mismatch Frustration (6 replies)
  180. [SOLVED:] checking if some specific workbook is open; if not then it should be opened. (5 replies)
  181. Delete data in closed workbook? (6 replies)
  182. looping help for copying data from a range and paste in another cell (1 replies)
  183. Exporting Camera Snapshots (1 replies)
  184. Please help - Procedure too long in VBA (13 replies)
  185. Bootstrapping-Random sampling with replacement (3 replies)
  186. Simple task but cant find a solution (9 replies)
  187. # of Thursdays-Fridays in a month (0 replies)
  188. How to remove an element from a nodelist. (0 replies)
  189. Sleeper: Alternative for GetElementsByTagName for filling a xmlnodelist (1 replies)
  190. Conditional Data (3 replies)
  191. Lookup functions ? how to sovle this issue ??? help me please (2 replies)
  192. Don't want to over write file ? (1 replies)
  193. Chart in userform without creating a image temporary file (1 replies)
  194. Macro to combine data under 3rd and 4th Column if condn satisfy for 1st , 2nd column (7 replies)
  195. [SOLVED:] Merging two spreadsheets using a script and creating html language (2 replies)
  196. MsoAutoShape Binding Problem (2 replies)
  197. VBA code identify rows that have exceeded a certain value in a cumulative chain (1 replies)
  198. Chart in Userform (1 replies)
  199. Loop inside if statement with listindex (4 replies)
  200. VBA many functions (1 replies)
  201. [SOLVED:] List Files and Folders (20 replies)
  202. [SOLVED:] How to open word using excel if not already open? (6 replies)
  203. Reading variable from combo box (0 replies)
  204. [SOLVED:] How to define the Key in the sort method of a range (9 replies)
  205. Produce multiple spreadshets based on columns (1 replies)
  206. Convert DD. December yyyy string into date? (6 replies)
  207. [SOLVED:] Greater than >8 then MsgBbox (10 replies)
  208. [SOLVED:] Merging Multiple excel files into a master file (4 replies)
  209. write variable in vba to text file (5 replies)
  210. [SOLVED:] Creating a VBA Script to save in a current month's folder (create folder as needed) (2 replies)
  211. VBA: Problem clicking button on second page of a website form (4 replies)
  212. create report from text in spreadsheet (2 replies)
  213. [SOLVED:] Show userform from another userform (8 replies)
  214. I am having a problem with the Application.Sumif function in vba (5 replies)
  215. [SOLVED:] .Rows.Count not working correctly? (6 replies)
  216. [SOLVED:] Help Writing Code That is Conditional on Shading of Cell (4 replies)
  217. Merge PDF files created by Foxit from Excel (2 replies)
  218. how to protect vba code in excel (12 replies)
  219. Nightingale Rose Diagram - how to add wedge outlines (1 replies)
  220. Clearing contetn of cells (2 replies)
  221. [SOLVED:] VBA Row (Couinter) Assigning Problem (1 replies)
  222. VBA code to add formula to blank cell (4 replies)
  223. To get a output from table based on condition (1 replies)
  224. [SOLVED:] Userform VLOOKUP (2 replies)
  225. I need some help printing an array from a set of values on a worksheet. (2 replies)
  226. Sleeper: Creating a one-dimensional array from a list on Excel. (1 replies)
  227. Need Help changing outputs in Excel Workbook (0 replies)
  228. [SOLVED:] Save Current WS as Workbook to Selected File Path (3 replies)
  229. [SOLVED:] Produce a word doc for each column_Docvariable+UBOUND function (5 replies)
  230. How to determine 7 calendar days? (1 replies)
  231. VBA code help needed (1 replies)
  232. Copy one range from multiple files. (3 replies)
  233. How to change the forecolor in charts? (1 replies)
  234. Count number of rows in a pdf? (2 replies)
  235. receive positive or negative numbers (7 replies)
  236. copy-paste area with objects, formulas and values (0 replies)
  237. [SOLVED:] Alternate way to move a file (2 replies)
  238. Loop through Range and copy rows based on multiple criteria (1 replies)
  239. [SOLVED:] Data Transfered but not to Target sheet (2 replies)
  240. [SOLVED:] Copying from PDFs - Only pastes last file? (1 replies)
  241. Macro to insert a row if defined value not available (5 replies)
  242. [SOLVED:] Userform ComboBox loaded from Access (3 replies)
  243. Extract data into multiple cells (1 replies)
  244. Adding a 2nd Macro (0 replies)
  245. Add/select multiple files (0 replies)
  246. VBA to convert formulas to value (9 replies)
  247. Function that searches the maximum of numbers which is smaller or equal 0.75. (1 replies)
  248. [SOLVED:] Pivot AddDataField - All data the same as first column (2 replies)
  249. [SOLVED:] Splitting one column into serveral columns (4 replies)
  250. Highlighting all row with same date (0 replies)