PDA

View Full Version : Excel Help



Pages : 1 2 3 [4] 5 6 7

  1. Macro To Browse Select File And Import Specific Data
  2. Limit Cells That Are To Be Printed Or Exported To PDF Document Or Hide Columns
  3. Macro For Converting Text And Actual Dates From DMY to MYD
  4. VBA Code For Extracting Data From Webpage In HTML5
  5. AverageIf Finding Average Of Corresponding Values Matching A Specific Value
  6. Change Data Series In Chart Using Drop-Down List
  7. Protect Or Unprotect Sheet Only If Password Matches
  8. Hide The Range But Show Without Hiding The Chart Graph Series
  9. Transfer Information From One Sheet To Another Based On Criteria
  10. How To Assign Macro To A Shape Or Form Control
  11. Using Sumifs To Check Multiple Criteria On The Same Column
  12. VBA code to delete cell ranges
  13. VBA code message box added
  14. Workbook protected when using this code
  15. IF Condition To Check Whether Absolute Value Is Greater Than Other Absolute Values
  16. Excel 2013 - Picture Compression Macro
  17. Creating Pivots in Excel VBA and Create an Email
  18. Dynamic Dependent Dropdown List Filter
  19. Stock Market Add-In Not Working In Excel 2010
  20. VBA to Copy Data From Other Workbooks Suddenly Fails
  21. Filter And Copy Range From Excel And Paste In PPT Presentation Slides Using Excel VBA
  22. How To Remove or Delete Blank Or Empty Rows After Data Is Transferred
  23. Find Duplicates, 2 Columns, Different Worksheets
  24. Repeating Format Automatically On Scrolling Down To New Page
  25. Embed an Excel Chart into PowerPoint - VBA
  26. USES MORE LEVELS OF NESTING THAN ARE ALLOWED IN THE CURRENT FILE FORMAT
  27. Entering Text In A Shape In PowerPoint PPT Slide Using Excel VBA
  28. Save Workbook File With The Next Incrementing Version Number Index
  29. Transpose A Range Of Cells Using Formula
  30. How To Move Transfer Or Copy Data To A Protected Sheet
  31. Protect All Worksheets Before Closing The Workbook
  32. Position Userform In The Top Left Of The Window
  33. ONE CELL AS RANGE IN VBA INSIDE AN IF STATEMENT
  34. Save Worksheets As Seperate Workbooks Based On Conditions
  35. How To Find The Significance Of Groups Using Excel
  36. Find Numbers From A List Of Numbers And Segregate Odd And Even Ending Digits
  37. Search in tables
  38. Exporting Multiple Worksheets From One Workbook To A New Workbook
  39. Deleting a Row with a specific data shown.
  40. Generate Random Groups Of 3 Digits At Most Two Digits Of The Last 200 Draws
  41. Highlight Cells That Contain Specific Text or Keyword
  42. Random Time Between Fixed Lower And Upper Limits
  43. COUNTIFS and DatedIF Combo
  44. Send Multiple Outlook Mails Using The Same Template
  45. How To Close A UserForm With A CommandButton
  46. Combobox with Dynamic Date Range
  47. Need help to add sheet, rename and update in TOC
  48. How can I make MLOOKUP to ignore blank cells?
  49. Opening Files That Contain Specific Name And Format Certain Columns
  50. User Input requested Search box (floating of static)
  51. Cascading Dynamic Drop-down Filter List With Concatenated Values Result In One Cell
  52. adding entries into combobox with code
  53. Target.Value help in Worksheet_Change
  54. Excel Formula To Distribute An Amount To Different Parts With Different Limits
  55. Create subroutine VBA to replace keyword in a column
  56. VBA To Display Pop Up Alert When Duplicate Entry Is Made
  57. Absolute amount or IF and Greater than Formula Code Required
  58. EXPORT THEN REFRESH AUTOMATICALLY THE PIVOT TABLE
  59. Unhide Rows on Specific Sheets
  60. Pop up calendar/control to select date
  61. How To Select A Sheet Using VBA
  62. Excel Sum Formula
  63. Automatically Archive Historic Or Old Data Based On Ageing Date
  64. Need Help - Quality Check of macro code (Codes Already created)
  65. Finding All Values In A Column That Corresponds To A Specific Text In Another Column
  66. Browse to Select File And Import Specific Data - VBA
  67. VBA code to open folders and pdf file inside the folders
  68. Code to pop up message when there is a variance
  69. Extract Embeded PDF Objects From Workbook And Attach To Email Message
  70. Match And Index Formula To Lookup Data From Table
  71. Drop Down List Or Data Validation List To Insert Text In To Cell Range
  72. Sending Data From User Form To First Empty Row Of Sheets
  73. Lookup Multiple Combination Of Values Across Columns To Find Corresponding A Value
  74. Use Combobox List Instead Of Data Validation Dropdown List
  75. PIVOT CHART
  76. GROUP PIVOT CHART
  77. Items From Column Headers To Be Listed In ComboBox
  78. I'm Finding Formulas Really Hard
  79. Display A Custom Benchmark Line Across Graph Plot Area
  80. Rearrange A Delimited Column Of Data In To Separate Rows With Fixed Number Of Columns
  81. Creating A Filtered Subset Of A Data Table Using Controls Instead Of Slicers
  82. Table Or Array That Can Auto Fill In Column Information Based On Two Cells Text Value
  83. Random Numbers
  84. Copy Range into Powerpoint
  85. Vertical and Horizontal Lookup Using Match And Index Function
  86. Combining specific data from multiple excel sheets to a master sheet
  87. Compare Date Columns In Excel And Pull The Latest Date
  88. Create target for particular tools group
  89. Remove Unprintable Non-Blank Cells Having Zero Length Contents
  90. Calculating data from other Worksheets
  91. Changing Picture Using Data Validation
  92. Hide Unhide Picture And Cell Content Using CheckBoxes
  93. How To Change Date Based On Time Using Formula
  94. Customizing Right-Click Context Menu In Excel For CommandBars Cell Row And Column
  95. How To Copy Data By Worksheet Name
  96. Align Bar Chart With Corresponding Data In Source Range
  97. Transfering Data From Userform To Sheet Under Relevant Column And Row
  98. SUMIF COUNTIF To Look For More Than One Keyword
  99. Fetch Data From Access Database Using SQL Only If All The Where Criteria Is Selected
  100. Add Horizontal Axis Label To A Scatterplot When The 'Edit' Button Is Disabled
  101. Automate Compact And Repair In Access 2010
  102. Sort Data By Multiple Columns And Delete Some Rows Based On Criteria
  103. VBA Confirm Message Before Deleting Row
  104. Add SubTotals To Data Table Based On Date
  105. Send Automatic Reminder Mails Row By Row Based On Status
  106. Get Data For Specific Date From Across Multiple Sheets
  107. Converting text to an email address hyperlink
  108. Code To Insert Chart And Delete Charts Using VBA
  109. Extract Unique Values Based On Dependant Combobox Selections
  110. SUM Values From Across Different Sheets Based On Multiple Criteria
  111. To Paste special by value
  112. Rounding Number to Nearest Nth Multiple
  113. Merging And Grouping Rows And Corresponding Data In Table That Meet Specific Criteria
  114. Need to Filter Content of a Sum Column in a Pivot Table
  115. Icon set based on another cell value or condition.
  116. TO convert Excel entire workbook in csv format
  117. Formula for break up score
  118. Macro to change month and year on all sheet
  119. Find Or Lookup The Dynamic Position Of A Value Based On Value In Another Cell
  120. How To Create Dynamic Oracle Query Using Excel VBA And Forms
  121. using Grouping in protected sheets
  122. Shorten VBA Code By Removing Redundant Superfluous Code
  123. VBA To Delete Rows Based On Value Criteria In A Column
  124. Conversion Of Data In Column To One Cell
  125. DELETE PAST FORMULA IN EMPTY CELLS
  126. USING COUNTIF IN VBA
  127. How Get Value From A Cell Range Using VBA
  128. Update Linked ComboBox List Based On Change In Another ComboBox Selection
  129. Compare Date from a Column Cells in alternate Columns Cells
  130. How To Use Or Pass A Dynamic Reference In An Array Formula
  131. Block User From Editing The Combo Box Text Value
  132. Data Validation With Dynamic List Of Sheet Names
  133. Extracting the sheet name only (as a string) from a formula to another cell
  134. Extracting Piece Of Text Having Specific Pattern From A Larger Text String
  135. Opening Last Working Day's File And Copying And Pasting Into Different File
  136. Fill ComboBox With Values From Corresponding Dynamic Column Based On Value Selected
  137. VBA To Separate One Long Row Data Into Multiple Rows Of Fixed Columns
  138. All Excel Files Opening In The Same Window
  139. Enable And Disable Controls Based On Selection In Previous Combo Box
  140. VBA Macro To Open And Modify Files By Looping Through Files In Folder
  141. VBA Macro Consolidate Data From Discontiguous Cells In Multiple Sheets To One Master
  142. Group Data From Multiple In To Single Cell Based On Criteria Seperated By Delimiter
  143. How to make this VBA code attach a workbook instead of a worksheet to an email
  144. VBA code help - several actions in one code + declaring and using a variable
  145. Macro to transfer data from open workbook to closed workbook with accumulation
  146. MouseOver/MouseHover Event On Autoshapes
  147. Covert SQL Code to VBA
  148. Excel frequencies formulation
  149. data entry to correct cell range...code needs help
  150. Copy data from multiple workbooks into separate tabs
  151. VBA To Compare Multiple Cells
  152. VBA Macro To Fill Missing Items In A Sequence Of Values Based On Criteria
  153. Run Access Macros From Excel Or Run A Macro In MS-Access From Excel VBA
  154. Superscripting A Portion Of Text In Data Label Of A Chart
  155. Excel to Powerpoint VBA Code
  156. What's the best approach: Need multiple queries displayed on Excel on the same page
  157. VBA To Extract Certain Rows From A Text File
  158. Merge Two Spreadsheets In To One Sheet Based On Matching Column
  159. Run SQL In MS-Access From Excel VBA
  160. Concatenate cells with 5 characters each column but ignore if blank
  161. changing code from using Combobox to optionbuttons
  162. Moving row to different sheets depending on number in column A
  163. how to get adobe to print multipul pages of list from a list of PDF drawings in excel
  164. Countdown Timer in Excel
  165. Pivot Table multiple filter exceptions
  166. listbox`s always change size when i close and re-open up workbook
  167. Remove Or Delete Rows Having Zero Or Negative Values In A Column
  168. IF STATEMENT BASED ON EQUAL VALUES IN RANGE
  169. Insert blank rows based on cell value
  170. how to equalize the value of an "alphabet" to "zero"
  171. Extend the macro to a selection of cells...
  172. Consolidate Excel Workbooks With Different Table Structures To A New Master File
  173. Insert Value When A Conditin is Met
  174. fill in cells according to selected optionbutton
  175. Copy pivottables subtotal to new sheet.
  176. If Conditions are met, It wil transfer to another worksheet.
  177. Adapt VBA Code With Adjusment Range
  178. Create folder and copy 2 sheets
  179. Compare two columns to sheet3 based on condition
  180. PASTING FROM ONE WORKSHEET TO ANOTHER INTO NEXT FREE ROW
  181. Min, Max, Average Vba for Situation
  182. no color in rows which have the Total or Grand Total
  183. Auto E-mail For Due Date Reminder Using Outlook
  184. Excel VBA Run-time error '13' Type mismatch
  185. formula help
  186. Copy data from 1 excel workbook to another based on certain criteria
  187. Find max value and second largest in a row and return column header
  188. Multiple Lookup And Return All Values Concatenated With Delimiter
  189. How to insert multiple filters to filter one persons name from different column
  190. Export Excel Range To PPT As An Excel Table Not As Picture Using VBA Macro
  191. Conditional Formatting Shading by Group When Filtered
  192. get conditional formatting color of a cell
  193. How to hide columns based on drop down selection
  194. MACRO CODE TO KNOW MONTH and QUATER
  195. HELP Import data from attached HTML file to excel
  196. Merge Workbooks to Master Workbook
  197. Complex Formula, Error 504-Can't find where I went wrong
  198. When choosing an image according to the number in a cell to show marked
  199. How To Add Numbers Having Beginning And Ending Trailing Space
  200. Excel macro sending commands to another application, pasting results into Excel
  201. Pull data within the work sheet and save as master sheet with pulled sheet name.
  202. Improving Speed Comparing Multiple Columns
  203. get an error if i press calculate-1 button without entries in the 4 Labels in Red
  204. Fill Combobox Based On Values In Adjacent Column
  205. Split Master Workbook In To Individual Files And Attach To Separate Mails
  206. how to reference a specific worksheet on vba code
  207. Merge spreadsheets from 2 files into new workbook
  208. Convert selected file to XML and save.
  209. USER FORM ISSUES: Clear data from various ranges using checkboxes and other issues.
  210. Insert Missing Dates By Comparing Two Lists Of Dates
  211. Random Unique Value Generator Based On Sample Size And Maximum Items Limit
  212. Worksheet Tab Name Based on Cell Value
  213. Compare Two Ranges Of Values Or Lists Of Items Where The Text Is Not Exact Match
  214. Change Data Validation List Based On Value In Cell
  215. Excel selection of data based on the data in another cell
  216. Xml Mapping in Excel Macro
  217. Excel macro
  218. Macro To Enable Disable Or Lock Unlock A Checkbox After An Action Is Performed
  219. Mouse Scroll in Userform using Excel VBA 7
  220. AutoFiltering Data COlumns
  221. Command Button to update the multiple line items in a TextBox
  222. VBA code to copy/paste the formatting of the entire workbook.
  223. Dynamic creation of headers
  224. A code to show colour in cell from list
  225. Formula Vs FormulaR1C1 To Pass Calculation Range Through VBA
  226. Macro For Sending Multiple Attachments In Bulk Mail Via Outlook
  227. Macro to delete Non Duplicate Records
  228. Macro to fetch csv files
  229. Set Pivot Table SubTotal Display Property To False
  230. VBA HELP - LOOP THROUGH FILES
  231. Macro to fetch csv file and edit the file
  232. How To Shorten Superfluous Code From Recorded Macro
  233. populate default values in cell of a csv file
  234. Lock Cells Based On Interior Colour Including Conditional Fomatting
  235. Formula Based Excel Calendar With Custom Start Month
  236. Create csv with appended data
  237. Delete blank rows
  238. Remove Duplicates From Across Multipe Columns In A Single WorkSheet
  239. Calendar dates not populating correctly
  240. Macro to split excel file into seperate files and then email
  241. Clear ID CARD with commandbutton
  242. Formula To Search The Last Occurance Of A Number Series
  243. Choose A Salutation Based On Time Using VBA
  244. copy special cells with values and formats
  245. Use Resize to select adjacently with multiple cells selected
  246. Missing Numbers Range VBA
  247. Strange behavoiur of Workbook_Open() and Worksheet_Activate() events
  248. Marco to send email via MAC (Outlook is working fine)
  249. VBA Code To Ask User With Yes No Cancel Message Box Before Protecting Cells
  250. Macro Running Very Slow When Applying Data Validation In Cells