Log in

View Full Version : Excel Help


Pages : 1 2 [3] 4 5 6 7
  1. Using autofilters on discontiguois range of cells along a row. (3 replies)
  2. Reorder List of Names with Capitalized Last Names (1 replies)
  3. Programmatically unlock VBA Project (2 replies)
  4. COMBINE AND OR with IF Function in Single Formula (4 replies)
  5. search for data and delete rows containing it (2 replies)
  6. insert line graph for each column separatly with vb (1 replies)
  7. Error when running VLookup (12 replies)
  8. Split And Separate Data In To Columns Based On Delimiter Using Text To Column (3 replies)
  9. Drop-down list of three tables (12 replies)
  10. VBA Open Module at specific (variable) procedure (4 replies)
  11. Drop-down list (with filtering) (2 replies)
  12. Find And Move Duplicate Values From One Sheet To Another Worksheet (3 replies)
  13. vba, .printout set to 1 page only (2 replies)
  14. Select A Range Dynamically Based On Count Of Values (1 replies)
  15. Use SUMIFS on pivot table data (1 replies)
  16. Sum Between Values Within The Same Range (5 replies)
  17. string manipulation (5 replies)
  18. change table top row to a different colour with html code (2 replies)
  19. How To Embed An Excel Table In To An Outlook Email Body (3 replies)
  20. Merge And Center Only Column Labels Of A Pivot Table (2 replies)
  21. VLookup Across Multiple Tables By Condition (6 replies)
  22. Merge Two Tables In To One Using Formula (4 replies)
  23. AutoFilter Working But Causing Data Glitch On Another Sheet (2 replies)
  24. Sort Range Using VBA And Ignoring Or Discarding Blank Rows (18 replies)
  25. VBA To Autosize Shape Based On Length Of Text (1 replies)
  26. Trying to create 19 formulas into 1 formula (1 replies)
  27. Formatting A Sheet With Fixed Width For Importing HTML File (1 replies)
  28. Extract, Transpose and Fill automation in a survey (9 replies)
  29. check if next active row after filter is blank in specific column (4 replies)
  30. Change Shape Color on MouseOver (1 replies)
  31. Adding controls at design time through code (1 replies)
  32. select email address from cell and add to cc email (1 replies)
  33. Gather a group of cells in a single cell based on a condition (3 replies)
  34. RefersTo:=Range [transpose(..)] (1 replies)
  35. Highlight Data Based on Data in Another Column (12 replies)
  36. VBA Macro for Bulks and an attachment (1 replies)
  37. setting loop code to check all named sheets (9 replies)
  38. Insert salutation (6 replies)
  39. Re writing a code? (2 replies)
  40. Lookup Data From Multiple Sheets (6 replies)
  41. XML Mapping in Excel Sheet (1 replies)
  42. how-to-transfer-data-from-excel-into-outlook-in-controled-columns (1 replies)
  43. Sum totals if date meet (7 replies)
  44. passing arrays from Class Module (1 replies)
  45. a ongoing 30 day total (1 replies)
  46. Send Same Email To More Than One Person Or Multiple Recipients (0 replies)
  47. Vlookup & If (6 replies)
  48. HELP - Vlookup based on 2 criteria. (7 replies)
  49. Loop_Find & Copy to word document (3 replies)
  50. How many times repeated number in a cell (5 replies)
  51. Command Bar Width Property (2 replies)
  52. remove date and title from Chart and place above chart (2 replies)
  53. sending e mails from excel via outlook at diferent stages depending on cell data (2 replies)
  54. Copy paste data based on criteria (7 replies)
  55. Macro to Sort 4 days data, Keep Sequential Data and Delete rest (5 replies)
  56. userform help with code for combobox4 (3 replies)
  57. Count unique number in a column (3 replies)
  58. Count unique number in a cell (3 replies)
  59. Application.Screenupdating = False Not Working In Workbooks().Activate In Windows 8 (5 replies)
  60. Code not finding unique number causing duplication of data (8 replies)
  61. AutoFilter Not Working By Date Due To Date Format Difference DD/MM/YYYY Vs MM/DD/YYYY (4 replies)
  62. How To Save Data To SpreadSheet From Only TextBoxes In All MultiPages Of A User Form (2 replies)
  63. code not to copy formula (5 replies)
  64. finding first blank row (2 replies)
  65. concatenate num (3 replies)
  66. On Going Calculation (2 replies)
  67. Understanding the Formula (4 replies)
  68. data transfer does not match up (18 replies)
  69. copy mirrored data into the first row that has a blank cell in column A (0 replies)
  70. Save and change data in the same command button (4 replies)
  71. VBA Code To Autofill Formula In Every Nth Row (1 replies)
  72. VBA Macro To Print With Custom From And To Page Numbers (1 replies)
  73. AutoFill in Formula (R1C1 Style) till data found in adjacent column, multiple IF(AND (6 replies)
  74. Send Mail From Excel Via Outlook With Attachment And Range As Mail Body (1 replies)
  75. Adding function without messing up original code (5 replies)
  76. Looking at data sheet and then transferring data according to date to fixed range (16 replies)
  77. Copy data from a workbook to another according date entered (2 replies)
  78. adding Pie Chart option (2 replies)
  79. What is difference between Properties and methods in VBA....? (1 replies)
  80. Retain set of 4 Days Data, based on Row data in 3 columns, and delete rest (10 replies)
  81. Delete data without deleting the formula (3 replies)
  82. Transportation model, linear programming and Solver (0 replies)
  83. Transform a VBA module in a compiled Add-In for Excel (5 replies)
  84. chart placed in correct sheet (2 replies)
  85. VBA : how copy data cells from workbook to another and paste in columns (4 replies)
  86. LookUp Value and Concatenate All Found Results (5 replies)
  87. A Blinking Christmas Tree... (2 replies)
  88. How To Protect VBA Project From Unauthorized Access (2 replies)
  89. Display Corresponding Value From Adjacent Column Based On Change of DropDown ComboBox (7 replies)
  90. Great Circle Midpoint of a line segment (0 replies)
  91. find words in a row and format (5 replies)
  92. Showing Month Abbreviation With Using 2 Characters (11 replies)
  93. Change Chart Title According To Source Data Selection (4 replies)
  94. Excel 2010: Formula to work out Salaries per financial year per area (1 replies)
  95. Label Caption based on Active Cell value (1 replies)
  96. Macros to send automatic E-mail remainder prior to an end date. (1 replies)
  97. can be used a single cell for a range of consecutive values?! (3 replies)
  98. Restrict User To Enter Permissible Date Range Values Only In TextBox (4 replies)
  99. Rotate A Shape In Excel Chart (3 replies)
  100. Macro To Print Selected Range (3 replies)
  101. Attaching and pasting excel sheet in to a new mail (2 replies)
  102. Macro that creates new column (1 replies)
  103. Userform To Create Individual Charts Based On Selected Date (3 replies)
  104. Q: VBA - using a range of strings as an argument (1 replies)
  105. Month wise calender macro (2 replies)
  106. Dynamically Expanding Right-Click Context Menu (1 replies)
  107. COUNTIF With Multiple Criteria Across Multiple Columns (9 replies)
  108. Find The Invoice Shortfall Balancing Amount Using Excel Formula (1 replies)
  109. Skip empty row and fetch values from other rows (1 replies)
  110. Vlookup help needed (15 replies)
  111. Convert Series into Range with specified count (3 replies)
  112. Fetch values from merged cells in macro (3 replies)
  113. Function to remove outlier (1 replies)
  114. Date COlumn AutoFiltering Issue! (3 replies)
  115. Find All Occurrences Of A Text String Value In All Workbooks In Folder And Sub Folder (2 replies)
  116. Lookup with multiple criteria (0 replies)
  117. add hyperlink with the URL hardcoded in the code (2 replies)
  118. MACRO: How to import data from sheets. (3 replies)
  119. LARGE function / Bringing top 5s from Data (1 replies)
  120. Excel Macro to populate the values in the required cells (10 replies)
  121. VBA code to copy and paste row based on certain criteria (8 replies)
  122. Extract Only Numbers & TEXT From Text String (9 replies)
  123. Macro Running Very Slow When Applying Data Validation In Cells (1 replies)
  124. VBA Code To Ask User With Yes No Cancel Message Box Before Protecting Cells (2 replies)
  125. Marco to send email via MAC (Outlook is working fine) (1 replies)
  126. Strange behavoiur of Workbook_Open() and Worksheet_Activate() events (4 replies)
  127. Missing Numbers Range VBA (2 replies)
  128. Use Resize to select adjacently with multiple cells selected (1 replies)
  129. copy special cells with values and formats (1 replies)
  130. Choose A Salutation Based On Time Using VBA (4 replies)
  131. Formula To Search The Last Occurance Of A Number Series (2 replies)
  132. Clear ID CARD with commandbutton (3 replies)
  133. Macro to split excel file into seperate files and then email (0 replies)
  134. Calendar dates not populating correctly (2 replies)
  135. Remove Duplicates From Across Multipe Columns In A Single WorkSheet (27 replies)
  136. Delete blank rows (5 replies)
  137. Create csv with appended data (0 replies)
  138. Formula Based Excel Calendar With Custom Start Month (2 replies)
  139. Lock Cells Based On Interior Colour Including Conditional Fomatting (11 replies)
  140. populate default values in cell of a csv file (2 replies)
  141. How To Shorten Superfluous Code From Recorded Macro (5 replies)
  142. Macro to fetch csv file and edit the file (6 replies)
  143. VBA HELP - LOOP THROUGH FILES (1 replies)
  144. Set Pivot Table SubTotal Display Property To False (1 replies)
  145. Macro to fetch csv files (2 replies)
  146. Macro to delete Non Duplicate Records (2 replies)
  147. Macro For Sending Multiple Attachments In Bulk Mail Via Outlook (9 replies)
  148. Formula Vs FormulaR1C1 To Pass Calculation Range Through VBA (5 replies)
  149. A code to show colour in cell from list (4 replies)
  150. Dynamic creation of headers (0 replies)
  151. VBA code to copy/paste the formatting of the entire workbook. (1 replies)
  152. Command Button to update the multiple line items in a TextBox (10 replies)
  153. AutoFiltering Data COlumns (2 replies)
  154. Mouse Scroll in Userform using Excel VBA 7 (1 replies)
  155. Macro To Enable Disable Or Lock Unlock A Checkbox After An Action Is Performed (3 replies)
  156. Excel macro (5 replies)
  157. Xml Mapping in Excel Macro (1 replies)
  158. Excel selection of data based on the data in another cell (2 replies)
  159. Change Data Validation List Based On Value In Cell (14 replies)
  160. Compare Two Ranges Of Values Or Lists Of Items Where The Text Is Not Exact Match (1 replies)
  161. Worksheet Tab Name Based on Cell Value (2 replies)
  162. Random Unique Value Generator Based On Sample Size And Maximum Items Limit (3 replies)
  163. Insert Missing Dates By Comparing Two Lists Of Dates (24 replies)
  164. USER FORM ISSUES: Clear data from various ranges using checkboxes and other issues. (11 replies)
  165. Convert selected file to XML and save. (7 replies)
  166. Merge spreadsheets from 2 files into new workbook (2 replies)
  167. how to reference a specific worksheet on vba code (3 replies)
  168. Split Master Workbook In To Individual Files And Attach To Separate Mails (0 replies)
  169. Fill Combobox Based On Values In Adjacent Column (5 replies)
  170. get an error if i press calculate-1 button without entries in the 4 Labels in Red (11 replies)
  171. Improving Speed Comparing Multiple Columns (6 replies)
  172. Pull data within the work sheet and save as master sheet with pulled sheet name. (2 replies)
  173. Excel macro sending commands to another application, pasting results into Excel (1 replies)
  174. How To Add Numbers Having Beginning And Ending Trailing Space (2 replies)
  175. When choosing an image according to the number in a cell to show marked (0 replies)
  176. Complex Formula, Error 504-Can't find where I went wrong (1 replies)
  177. Merge Workbooks to Master Workbook (6 replies)
  178. HELP Import data from attached HTML file to excel (6 replies)
  179. MACRO CODE TO KNOW MONTH and QUATER (4 replies)
  180. How to hide columns based on drop down selection (2 replies)
  181. get conditional formatting color of a cell (2 replies)
  182. Conditional Formatting Shading by Group When Filtered (2 replies)
  183. Export Excel Range To PPT As An Excel Table Not As Picture Using VBA Macro (6 replies)
  184. How to insert multiple filters to filter one persons name from different column (2 replies)
  185. Multiple Lookup And Return All Values Concatenated With Delimiter (4 replies)
  186. Find max value and second largest in a row and return column header (1 replies)
  187. Copy data from 1 excel workbook to another based on certain criteria (2 replies)
  188. formula help (2 replies)
  189. Excel VBA Run-time error '13' Type mismatch (5 replies)
  190. Auto E-mail For Due Date Reminder Using Outlook (4 replies)
  191. no color in rows which have the Total or Grand Total (4 replies)
  192. Min, Max, Average Vba for Situation (1 replies)
  193. PASTING FROM ONE WORKSHEET TO ANOTHER INTO NEXT FREE ROW (1 replies)
  194. Compare two columns to sheet3 based on condition (2 replies)
  195. Create folder and copy 2 sheets (10 replies)
  196. Adapt VBA Code With Adjusment Range (2 replies)
  197. If Conditions are met, It wil transfer to another worksheet. (5 replies)
  198. Copy pivottables subtotal to new sheet. (6 replies)
  199. fill in cells according to selected optionbutton (6 replies)
  200. Insert Value When A Conditin is Met (3 replies)
  201. Consolidate Excel Workbooks With Different Table Structures To A New Master File (3 replies)
  202. Extend the macro to a selection of cells... (4 replies)
  203. how to equalize the value of an "alphabet" to "zero" (4 replies)
  204. Insert blank rows based on cell value (13 replies)
  205. IF STATEMENT BASED ON EQUAL VALUES IN RANGE (3 replies)
  206. Remove Or Delete Rows Having Zero Or Negative Values In A Column (3 replies)
  207. listbox`s always change size when i close and re-open up workbook (6 replies)
  208. Pivot Table multiple filter exceptions (1 replies)
  209. Countdown Timer in Excel (4 replies)
  210. how to get adobe to print multipul pages of list from a list of PDF drawings in excel (2 replies)
  211. Moving row to different sheets depending on number in column A (1 replies)
  212. changing code from using Combobox to optionbuttons (24 replies)
  213. Concatenate cells with 5 characters each column but ignore if blank (2 replies)
  214. Run SQL In MS-Access From Excel VBA (4 replies)
  215. Merge Two Spreadsheets In To One Sheet Based On Matching Column (10 replies)
  216. VBA To Extract Certain Rows From A Text File (4 replies)
  217. What's the best approach: Need multiple queries displayed on Excel on the same page (1 replies)
  218. Excel to Powerpoint VBA Code (1 replies)
  219. Superscripting A Portion Of Text In Data Label Of A Chart (6 replies)
  220. Run Access Macros From Excel Or Run A Macro In MS-Access From Excel VBA (6 replies)
  221. VBA Macro To Fill Missing Items In A Sequence Of Values Based On Criteria (10 replies)
  222. VBA To Compare Multiple Cells (4 replies)
  223. Copy data from multiple workbooks into separate tabs (3 replies)
  224. data entry to correct cell range...code needs help (2 replies)
  225. Excel frequencies formulation (1 replies)
  226. Covert SQL Code to VBA (6 replies)
  227. MouseOver/MouseHover Event On Autoshapes (6 replies)
  228. Macro to transfer data from open workbook to closed workbook with accumulation (6 replies)
  229. VBA code help - several actions in one code + declaring and using a variable (1 replies)
  230. How to make this VBA code attach a workbook instead of a worksheet to an email (2 replies)
  231. Group Data From Multiple In To Single Cell Based On Criteria Seperated By Delimiter (1 replies)
  232. VBA Macro Consolidate Data From Discontiguous Cells In Multiple Sheets To One Master (9 replies)
  233. VBA Macro To Open And Modify Files By Looping Through Files In Folder (15 replies)
  234. Enable And Disable Controls Based On Selection In Previous Combo Box (2 replies)
  235. All Excel Files Opening In The Same Window (1 replies)
  236. VBA To Separate One Long Row Data Into Multiple Rows Of Fixed Columns (10 replies)
  237. Fill ComboBox With Values From Corresponding Dynamic Column Based On Value Selected (1 replies)
  238. Opening Last Working Day's File And Copying And Pasting Into Different File (7 replies)
  239. Extracting Piece Of Text Having Specific Pattern From A Larger Text String (7 replies)
  240. Extracting the sheet name only (as a string) from a formula to another cell (9 replies)
  241. Data Validation With Dynamic List Of Sheet Names (2 replies)
  242. Block User From Editing The Combo Box Text Value (8 replies)
  243. How To Use Or Pass A Dynamic Reference In An Array Formula (2 replies)
  244. Compare Date from a Column Cells in alternate Columns Cells (4 replies)
  245. Update Linked ComboBox List Based On Change In Another ComboBox Selection (8 replies)
  246. How Get Value From A Cell Range Using VBA (5 replies)
  247. USING COUNTIF IN VBA (1 replies)
  248. DELETE PAST FORMULA IN EMPTY CELLS (1 replies)
  249. Conversion Of Data In Column To One Cell (6 replies)
  250. VBA To Delete Rows Based On Value Criteria In A Column (1 replies)