Log in

View Full Version : Excel Help


Pages : 1 [2] 3 4 5 6 7
  1. DATA SHEET UPDATE INFO CODE (0 replies)
  2. Breaking excel tab into multiple worksheets and maintaining 2 header rows (1 replies)
  3. Counting font color of conditionally formatted cells (2 replies)
  4. Resize Image To Excel Window Size And Scale To Fit Automatically (5 replies)
  5. populate control from named range stored in addin (8 replies)
  6. TAT Calculation (5 replies)
  7. UNPIVOT crosstab sheet using SQL and get count of items. (0 replies)
  8. Visible range from UDF having filtered Listobject columns as argument (5 replies)
  9. Getting data with web query and rearrange the data (1 replies)
  10. Search Criteria / Formula (2 replies)
  11. Multiple IF's Formula Help!! (8 replies)
  12. Jewish / Civil Date Converter (0 replies)
  13. E-mail Jewish / Civil Date Converter (0 replies)
  14. Remove Parts to URL (4 replies)
  15. Excel VBA Macro To Repeat Records Based On User Value In InputBox (2 replies)
  16. Sumproduct and Sumif in vba in large datasheet (1 replies)
  17. VBA Code To Run Through A Column And Email Blanks (1 replies)
  18. Change Cell Color - Date (2 replies)
  19. Excel 2010 Unique Count in Pivot Tables with Helper Cells/Columns and Sumproduct (1 replies)
  20. Worksheet Duplication Code Help (5 replies)
  21. Pull text from the left of a character to the right of the next character foun (6 replies)
  22. Change the text within a cell to the text within another cell and paste in another co (9 replies)
  23. Divide Rest of the Columns using Column A values (8 replies)
  24. Code to condition format the cell colors and font colors of a range values (5 replies)
  25. Formula with 3 arguments (3 replies)
  26. List Files In Folder & Subfolders Using DIR (3 replies)
  27. Extract Time from a Date&time cell (4 replies)
  28. Unique Concatenate Range, multiple rows, Index Match Mutliple Criteria (3 replies)
  29. request for macro to find information in various cells (2 replies)
  30. Extract numbers from text into multiple columns (17 replies)
  31. Initial capital customized (17 replies)
  32. Macro to Delete Rows of Extraneous Data (4 replies)
  33. Capture the "Last Modifed" date from FilePicker (6 replies)
  34. Why is this code returning a Runtime error 13 Type mismatch? (8 replies)
  35. Autosize the height of a pivot chart based on the number of filtered values (2 replies)
  36. How To Limit The Word Length Or Number Of Characters In A Cell (1 replies)
  37. I need help writing VBA code (3 replies)
  38. Want to Send emails by clicking an email hyperlink in the excel sheet (0 replies)
  39. Special concatenation (32 replies)
  40. Conditional Selection of cells and its row (1 replies)
  41. Select till row destination (2 replies)
  42. copy data and paste it in another sheet (1 replies)
  43. copy data and paste it in another sheet (1 replies)
  44. Remove first character then compare to another cell (4 replies)
  45. Email with outlook using vba (1 replies)
  46. Automatic Email from an Excel Cell Data Entry (1 replies)
  47. SUMPRODUCT function with heaps of IFS (3 replies)
  48. How To Clear Undo List Stack In Excel (2 replies)
  49. Consolidation Values only (1 replies)
  50. Dynamic Reference to Another Worksheet (1 replies)
  51. Revisiting Redistribute a Delimited Column Of Data into Separate Rows (5 replies)
  52. Round the custom range of row (1 replies)
  53. Create a sorted list of uniques based on 2 columns (5 replies)
  54. List of criterea to exclude (3 replies)
  55. Email message from Excel (1 replies)
  56. VBA to Merge Multiple Workbooks with Multiple sheets into one master sheet (2 replies)
  57. [For Loop] Apply Exchange Rate Calculation to Cells (1 replies)
  58. How to Active Drill Up and Drill Down Option in pivot Table Analyze Tab (2 replies)
  59. DELETING ROWS IN SPREADSHEET BASED ON CRITERIA IN ANOTHER SHEET (1 replies)
  60. How to delete a worksheet from multiple files (3 replies)
  61. Return a comment based on values in another cell (5 replies)
  62. Determine why basic syntax errors out in Excel 2013 (2 replies)
  63. Need Help to Restructure the table (0 replies)
  64. Remove blank in drop list (3 replies)
  65. Lock Cells after date passed - VBA Code (1 replies)
  66. VBA Coding for English/Spanish Google Translation Error (2 replies)
  67. Split the contents from single cell into multiple cell in excel 2010 (13 replies)
  68. Excel VBA to copy and paste columns (4 replies)
  69. VBA - Code if pivot column header gets changed every day (2 replies)
  70. convert formula to a number (5 replies)
  71. Search by word and replace with Date from another sheet! (4 replies)
  72. Validating PAN NUMBER Indian Format (3 replies)
  73. Vlookup-Concatenate results (1 replies)
  74. Choose folder, loop thru files to copy data & paste in new master workbook (2 replies)
  75. VBA How to pass formatted text from Excel to MS Word (2 replies)
  76. Remove the Index References table and continue to show the CF (1 replies)
  77. Get Date prior to Actual Date (5 replies)
  78. Splitting userform text onto different rows (1 replies)
  79. Find Duplicate Values In A Column And Identify Position In Next Column (3 replies)
  80. Code Or Command To Open XLSM Files And Close And Save As CSV (1 replies)
  81. Inconsistent "greater than" and "less than" calculations (1 replies)
  82. Concatenate Two Or Multiple Columns In To One Based On Multiple Criteria (1 replies)
  83. Single calendar (Userform) for multiple textboxes (3 replies)
  84. inserting a row(empty) afther each 4 rows of my data (9 replies)
  85. changing arrangement of data to new style (3 replies)
  86. INDEX formula not working (1 replies)
  87. Project Explorer Strangeness (1 replies)
  88. to get one complete vba code from gathering vba codes and formulla ... (0 replies)
  89. to get one complete vba code from gathering vba codes and formulla (2 replies)
  90. How to get incremental volume reference to the time interval (0 replies)
  91. Viewing cell values in ribbon, not reference cells nor final value. (1 replies)
  92. filter for multiple text (0 replies)
  93. Button to export data to a master file (0 replies)
  94. References lost: extrenal and internal sheet names (1 replies)
  95. Formula To Display Numbers In Custom Format (1 replies)
  96. macro to drag and fill formula til the time stamp match (4 replies)
  97. Monthly Chart with Values & Percentages (7 replies)
  98. VBA Code for User Form (1 replies)
  99. Formula To Remove Part Of Text Based On It's Position In A Sentence (4 replies)
  100. macro to hide and unhide columns and rows (1 replies)
  101. Lock Or Unlock Entire Row Depending On Value In Each Cell In A Column (1 replies)
  102. Excel Sheet Correction (1 replies)
  103. UserForm ComboBox error (4 replies)
  104. repeating one number (6 replies)
  105. Excel gaps and alphabetization (1 replies)
  106. VBA Macro To Open A File And Extract Data From Specific Columns (2 replies)
  107. Rename tab on cell value from another worksheet (6 replies)
  108. Split Text In To Segments Of Upto X Characters And At The Space Between Words (2 replies)
  109. add an addition cell colour to coding (2 replies)
  110. Import row data from multiple worksheets to generate a report using vba (9 replies)
  111. Drop Down List with Default Value & Color (1 replies)
  112. Macro to Auto Run When Excel Cell Data Changes (5 replies)
  113. Identifying Zero-to-Non-Zero Value and vice versa (4 replies)
  114. Apply filter and delete rows thru Messege Box (11 replies)
  115. Need help to modify the VBA code (8 replies)
  116. File Name previous/next (3 replies)
  117. Nested if isblank, or, and excel function. (5 replies)
  118. Redistributing OR Split Column Info Into Separate Rows (4 replies)
  119. Split Upper / Lower case + concatenate rows (11 replies)
  120. Grouping column containing Number values into specific subgroups (2 replies)
  121. Help with VBA timin issue on task scheduler (5 replies)
  122. Correcting an excel sheet after exporting from crystal report (6 replies)
  123. Insert many worksheets and name (4 replies)
  124. How To Split A Text Based On Two Special Characters (10 replies)
  125. Looping Through String Using Excel VBA! (15 replies)
  126. Custom Cell Format To Display 8 Digit Numeric Value As Date In DD/MM/YYYY Format (2 replies)
  127. Excel macro to get GAL from outlook. (2 replies)
  128. Unique Random Numbers Using Formula (8 replies)
  129. AutoFill Formula To The Last Row With Data (2 replies)
  130. Prevent Excel From Maximizing When UserForm Is Active (1 replies)
  131. Code to open up files in folder and sub-folder (7 replies)
  132. VBA Help for Meeting Plotter (0 replies)
  133. Concatenating your Balls (26 replies)
  134. Fill Blanks With Averages (3 replies)
  135. Attach File To An Email Using VB Code (3 replies)
  136. VBA To Update Or Refresh Listview Items Or Records Dynamically In Userform (4 replies)
  137. VBA Macro To Find Specific Text And Insert Text Few Rows Below (6 replies)
  138. Macro to produce Thick Border Box (14 replies)
  139. Macro to open and update several workbooks (0 replies)
  140. How to delete cells' values through a multiselect listbox? (3 replies)
  141. Date Formatting (1 replies)
  142. Search List of my codes (6 replies)
  143. inserting date (5 replies)
  144. Excel VBA Macro To Conditional Delete Rows Across Multiple Sheets (3 replies)
  145. Sum All Rows And Columns In A Range Where Criteria Matches Across Rows And Columns (5 replies)
  146. Convert Matrix Style Data into Stacked Rows preserving identifying row values (8 replies)
  147. Conditionally Manage Multiple Items In Worksheet_Change(ByVal Target As Range) Event (2 replies)
  148. Dynamically Update Chart With Latest X Columns Of Data As New Data Is Updated (5 replies)
  149. Get List Of All Values Corresponding To A Value In The Adjacent Column (23 replies)
  150. Get Combination Of Unique Values From N Columns Using Rand Or RandBetween Function (10 replies)
  151. Display macro enable/disable alert in an emailed file. (6 replies)
  152. VBA Macro To Clear Everything Excel Formula And Bold Text (2 replies)
  153. Extract Email ID From A List Of Sentences (11 replies)
  154. Consolidate Multiple Workbooks With Different and Same Column Headers To Master File (1 replies)
  155. Sum of Alternate Columns (4 replies)
  156. excel to send emails to specified addesses determined by due date (1 replies)
  157. Long Formula in cell and REF! (2 replies)
  158. Summarize range of comma delimited values (1 replies)
  159. Change Picture Based On DropDown ComboBox Selection Cell Validation Using Formula (12 replies)
  160. Get Error while add new sheet in excel (1 replies)
  161. Redistribute data from multiple columns into separate rows (3 replies)
  162. Help: Searching and extracting data from rows (3 replies)
  163. List box tabbing (1 replies)
  164. Force user to use date format dd/mm/yyyy on User Form (5 replies)
  165. How To Split Text From A Cell Range Into Different Columns Using Formula (1 replies)
  166. selected colour cell will save / show in new sheet or within the sheet (1 replies)
  167. Custom Formula based on Rank Remarks (14 replies)
  168. To change Date format in a disorderly column (10 replies)
  169. Copy range and paste depending on the selected checkbox (2 replies)
  170. =MIN(IF( (4 replies)
  171. VBA To Scroll Through ListBox Using Mouse Scroll Wheel (14 replies)
  172. Macro to show row number and sheet name (6 replies)
  173. Modification in the Excel to Outlook mail (1 replies)
  174. InputBox OK and Cancel Button Problem (5 replies)
  175. Macro to copy value based on name (2 replies)
  176. Append Fields in an Existing ADO Recordset (3 replies)
  177. Click On Bubble In Bubble Chart To Take User To A Sheet Or Range (2 replies)
  178. Extract All Synonymous Names In A Range To Another Range Using Formula (2 replies)
  179. How to open,copy and save as .. want to automate (2 replies)
  180. Formula To Show The Sum Of Filtered List Using SubTotal (6 replies)
  181. Excel Macro to Split Multiple Columns into rows (2 replies)
  182. Need an Autofill VBA (12 replies)
  183. Get Hourly Data From Text File After Converting To Excel File (7 replies)
  184. How To Create A Watermark While Printing In Excel Using VBA (4 replies)
  185. How To Look-up The Opening, Closing, High and Low Values Of A Category (1 replies)
  186. VBA Macro To Save And Copy File To Different Locations (4 replies)
  187. Identify Or Highlight Cells Having Formula Using Conditional Formatting (4 replies)
  188. Get Name Of Sheets Using Formula (3 replies)
  189. How To Increase Font Size Of Dropdown Form Control (6 replies)
  190. Migrate Or Copy Columns Depending On Their Color Based On Conditional Formatting (9 replies)
  191. How To Stop An OnTime Scheduled Macro Without Getting An Error (1 replies)
  192. Enable CommandButton Only By Selecting The Name Of The Procedure In A Dropdown List (4 replies)
  193. Hide ProgressBar After Process Loop Is Complete (4 replies)
  194. Formula To Round Date Time To Decimal Minutes (1 replies)
  195. Delete Rows where data is the same but in different columns (8 replies)
  196. Import data from another workbook reference to its sheet name, (4 replies)
  197. Formula To Show The Most Common Or Frequent Day For An Entry (3 replies)
  198. Change Color Of Series In A Bar Chart Based On Selection Of DropDowns (3 replies)
  199. Formula To Sum From Movement To Cummulative Total (6 replies)
  200. How To Bypass A Webquery Error Message (4 replies)
  201. List Folder location & Filenames into a Table and color (6 replies)
  202. Change Tab Color base on value of cell % Change (8 replies)
  203. Is this codes be translated into Excel? (1 replies)
  204. VBA To Extract Latest X Number Of Rows From A Range and Paste To Another (8 replies)
  205. VBA To Close Workbook Based On Cell Value Change And Open New Workbook (4 replies)
  206. VBA Code Breaks During Runtime But Not In Debug Mode (14 replies)
  207. VBA To Split A Group Or Set Of Data In Rows In To Columns (6 replies)
  208. How To Refer A Cell From Another Sheet + How To Count Instances Of Any Value (1 replies)
  209. Consolidate Multiple Workbooks Into One And Push Back Down Updated Data (6 replies)
  210. Macro to copy data containing numeric values (11 replies)
  211. Pivot Table Calculated Field Question. (2 replies)
  212. Add Missing Dates (8 replies)
  213. Search Two Ranges To See If The Same String Exists (17 replies)
  214. Loop Through Visible Cells In Column And If It Contains Specific Text Sum Next Col (2 replies)
  215. Combine two IF AND formula (0 replies)
  216. Macro to pull data ranges and comapre them (2 replies)
  217. importing CSV datas from web login/psw broker account problem (1 replies)
  218. application.worksheetfunction.vlookup not working for me (3 replies)
  219. compare two tables (1 replies)
  220. Delete Filtered Rows Excluding The Header (5 replies)
  221. double a number in one columnthat is( row 48) and repeated every 48 row (1 replies)
  222. Excel 2010 hide Read Only messages (1 replies)
  223. Problem with line (row) in a macro (1 replies)
  224. Update Pivot Table Source Data With Dynamic Range Of Non Empty Cells (2 replies)
  225. Select rows with data in column A5 down then resize to 11 columns along (K) (2 replies)
  226. VBA To Insert Specific Column Before Every Existing Columns (7 replies)
  227. Delete Filtered Result, Sort From Specific Row And Delete Entire Row Having No Pairs (6 replies)
  228. Activate A Workbook After It Is Open (4 replies)
  229. Compare values between the two columns by condition (2 replies)
  230. vba, worksheet visible issue (1 replies)
  231. Copy/Paste specific data from different pages of same website using VBA code (1 replies)
  232. seprate data in rows to columns (2 replies)
  233. Find the value of the due date falls between two dates (2 replies)
  234. Paste method fails. (1 replies)
  235. VBA code to find last entry on a certain date and bring back the text in the adjacent (7 replies)
  236. Required an excel formula to combine first and last 3 letters of a text (3 replies)
  237. VBA to Copy Rows Until Blank Row and Paste Data on First Blank Row (2 replies)
  238. VBA Code To Autofit The Row Height Of Merged Cells (6 replies)
  239. what shoud i do to have one sheet of every 1hour data & min max data with vb code (2 replies)
  240. VBA UserForm Based Calendar Substitute DatePicker Control For All MSO Versions (4 replies)
  241. VBA Code for Custom No. Formatting (2 replies)
  242. Get The Large Number From Range By Skipping Values Based On A Condition (2 replies)
  243. Export And Save Chart As PNG With Custom Sequential Name (10 replies)
  244. multi drop down list (4 replies)
  245. Get The SelectedItem Index Row Number In VBA ListView (2 replies)
  246. vba to move data from a row to a column (3 replies)
  247. No. separation (12 replies)
  248. Macro to Automatically Update a sheet based on values in another sheet on daily basis (4 replies)
  249. insert line graph for each column separatly with vb (2 replies)
  250. Delete Entire row if cell value does not have either two of specific word (1 replies)