PDA

View Full Version : Excel Help


Pages : 1 2 3 4 [5] 6 7
  1. Extract Only Numbers & TEXT From Text String
  2. VBA code to copy and paste row based on certain criteria
  3. Excel Macro to populate the values in the required cells
  4. LARGE function / Bringing top 5s from Data
  5. MACRO: How to import data from sheets.
  6. add hyperlink with the URL hardcoded in the code
  7. Lookup with multiple criteria
  8. Find All Occurrences Of A Text String Value In All Workbooks In Folder And Sub Folder
  9. Date COlumn AutoFiltering Issue!
  10. Function to remove outlier
  11. Fetch values from merged cells in macro
  12. Convert Series into Range with specified count
  13. Vlookup help needed
  14. Skip empty row and fetch values from other rows
  15. Find The Invoice Shortfall Balancing Amount Using Excel Formula
  16. COUNTIF With Multiple Criteria Across Multiple Columns
  17. Dynamically Expanding Right-Click Context Menu
  18. Month wise calender macro
  19. Q: VBA - using a range of strings as an argument
  20. Userform To Create Individual Charts Based On Selected Date
  21. Macro that creates new column
  22. Attaching and pasting excel sheet in to a new mail
  23. Macro To Print Selected Range
  24. Rotate A Shape In Excel Chart
  25. Restrict User To Enter Permissible Date Range Values Only In TextBox
  26. can be used a single cell for a range of consecutive values?!
  27. Macros to send automatic E-mail remainder prior to an end date.
  28. Label Caption based on Active Cell value
  29. Excel 2010: Formula to work out Salaries per financial year per area
  30. Change Chart Title According To Source Data Selection
  31. Showing Month Abbreviation With Using 2 Characters
  32. find words in a row and format
  33. Great Circle Midpoint of a line segment
  34. Display Corresponding Value From Adjacent Column Based On Change of DropDown ComboBox
  35. How To Protect VBA Project From Unauthorized Access
  36. A Blinking Christmas Tree...
  37. LookUp Value and Concatenate All Found Results
  38. VBA : how copy data cells from workbook to another and paste in columns
  39. chart placed in correct sheet
  40. Transform a VBA module in a compiled Add-In for Excel
  41. Transportation model, linear programming and Solver
  42. Delete data without deleting the formula
  43. Retain set of 4 Days Data, based on Row data in 3 columns, and delete rest
  44. What is difference between Properties and methods in VBA....?
  45. adding Pie Chart option
  46. Copy data from a workbook to another according date entered
  47. Looking at data sheet and then transferring data according to date to fixed range
  48. Adding function without messing up original code
  49. Send Mail From Excel Via Outlook With Attachment And Range As Mail Body
  50. AutoFill in Formula (R1C1 Style) till data found in adjacent column, multiple IF(AND
  51. VBA Macro To Print With Custom From And To Page Numbers
  52. VBA Code To Autofill Formula In Every Nth Row
  53. Save and change data in the same command button
  54. copy mirrored data into the first row that has a blank cell in column A
  55. data transfer does not match up
  56. Understanding the Formula
  57. On Going Calculation
  58. concatenate num
  59. finding first blank row
  60. code not to copy formula
  61. How To Save Data To SpreadSheet From Only TextBoxes In All MultiPages Of A User Form
  62. AutoFilter Not Working By Date Due To Date Format Difference DD/MM/YYYY Vs MM/DD/YYYY
  63. Code not finding unique number causing duplication of data
  64. Application.Screenupdating = False Not Working In Workbooks().Activate In Windows 8
  65. Count unique number in a cell
  66. Count unique number in a column
  67. userform help with code for combobox4
  68. Macro to Sort 4 days data, Keep Sequential Data and Delete rest
  69. Copy paste data based on criteria
  70. sending e mails from excel via outlook at diferent stages depending on cell data
  71. remove date and title from Chart and place above chart
  72. Command Bar Width Property
  73. How many times repeated number in a cell
  74. Loop_Find & Copy to word document
  75. HELP - Vlookup based on 2 criteria.
  76. Vlookup & If
  77. Send Same Email To More Than One Person Or Multiple Recipients
  78. a ongoing 30 day total
  79. passing arrays from Class Module
  80. Sum totals if date meet
  81. how-to-transfer-data-from-excel-into-outlook-in-controled-columns
  82. XML Mapping in Excel Sheet
  83. Lookup Data From Multiple Sheets
  84. Re writing a code?
  85. Insert salutation
  86. setting loop code to check all named sheets
  87. VBA Macro for Bulks and an attachment
  88. Highlight Data Based on Data in Another Column
  89. RefersTo:=Range [transpose(..)]
  90. Gather a group of cells in a single cell based on a condition
  91. select email address from cell and add to cc email
  92. Adding controls at design time through code
  93. Change Shape Color on MouseOver
  94. check if next active row after filter is blank in specific column
  95. Extract, Transpose and Fill automation in a survey
  96. Formatting A Sheet With Fixed Width For Importing HTML File
  97. Trying to create 19 formulas into 1 formula
  98. VBA To Autosize Shape Based On Length Of Text
  99. Sort Range Using VBA And Ignoring Or Discarding Blank Rows
  100. AutoFilter Working But Causing Data Glitch On Another Sheet
  101. Merge Two Tables In To One Using Formula
  102. VLookup Across Multiple Tables By Condition
  103. Merge And Center Only Column Labels Of A Pivot Table
  104. How To Embed An Excel Table In To An Outlook Email Body
  105. change table top row to a different colour with html code
  106. string manipulation
  107. Sum Between Values Within The Same Range
  108. Use SUMIFS on pivot table data
  109. Select A Range Dynamically Based On Count Of Values
  110. vba, .printout set to 1 page only
  111. Find And Move Duplicate Values From One Sheet To Another Worksheet
  112. Drop-down list (with filtering)
  113. VBA Open Module at specific (variable) procedure
  114. Drop-down list of three tables
  115. Split And Separate Data In To Columns Based On Delimiter Using Text To Column
  116. Error when running VLookup
  117. insert line graph for each column separatly with vb
  118. search for data and delete rows containing it
  119. COMBINE AND OR with IF Function in Single Formula
  120. Programmatically unlock VBA Project
  121. Reorder List of Names with Capitalized Last Names
  122. Using autofilters on discontiguois range of cells along a row.
  123. Delete Entire row if cell value does not have either two of specific word
  124. insert line graph for each column separatly with vb
  125. Macro to Automatically Update a sheet based on values in another sheet on daily basis
  126. No. separation
  127. vba to move data from a row to a column
  128. Get The SelectedItem Index Row Number In VBA ListView
  129. multi drop down list
  130. Export And Save Chart As PNG With Custom Sequential Name
  131. Get The Large Number From Range By Skipping Values Based On A Condition
  132. VBA Code for Custom No. Formatting
  133. VBA UserForm Based Calendar Substitute DatePicker Control For All MSO Versions
  134. what shoud i do to have one sheet of every 1hour data & min max data with vb code
  135. VBA Code To Autofit The Row Height Of Merged Cells
  136. VBA to Copy Rows Until Blank Row and Paste Data on First Blank Row
  137. Required an excel formula to combine first and last 3 letters of a text
  138. VBA code to find last entry on a certain date and bring back the text in the adjacent
  139. Paste method fails.
  140. Find the value of the due date falls between two dates
  141. seprate data in rows to columns
  142. Copy/Paste specific data from different pages of same website using VBA code
  143. vba, worksheet visible issue
  144. Compare values between the two columns by condition
  145. Activate A Workbook After It Is Open
  146. Delete Filtered Result, Sort From Specific Row And Delete Entire Row Having No Pairs
  147. VBA To Insert Specific Column Before Every Existing Columns
  148. Select rows with data in column A5 down then resize to 11 columns along (K)
  149. Update Pivot Table Source Data With Dynamic Range Of Non Empty Cells
  150. Problem with line (row) in a macro
  151. Excel 2010 hide Read Only messages
  152. double a number in one columnthat is( row 48) and repeated every 48 row
  153. Delete Filtered Rows Excluding The Header
  154. compare two tables
  155. application.worksheetfunction.vlookup not working for me
  156. importing CSV datas from web login/psw broker account problem
  157. Macro to pull data ranges and comapre them
  158. Combine two IF AND formula
  159. Loop Through Visible Cells In Column And If It Contains Specific Text Sum Next Col
  160. Search Two Ranges To See If The Same String Exists
  161. Add Missing Dates
  162. Pivot Table Calculated Field Question.
  163. Macro to copy data containing numeric values
  164. Consolidate Multiple Workbooks Into One And Push Back Down Updated Data
  165. How To Refer A Cell From Another Sheet + How To Count Instances Of Any Value
  166. VBA To Split A Group Or Set Of Data In Rows In To Columns
  167. VBA Code Breaks During Runtime But Not In Debug Mode
  168. VBA To Close Workbook Based On Cell Value Change And Open New Workbook
  169. VBA To Extract Latest X Number Of Rows From A Range and Paste To Another
  170. Is this codes be translated into Excel?
  171. Change Tab Color base on value of cell % Change
  172. List Folder location & Filenames into a Table and color
  173. How To Bypass A Webquery Error Message
  174. Formula To Sum From Movement To Cummulative Total
  175. Change Color Of Series In A Bar Chart Based On Selection Of DropDowns
  176. Formula To Show The Most Common Or Frequent Day For An Entry
  177. Import data from another workbook reference to its sheet name,
  178. Delete Rows where data is the same but in different columns
  179. Formula To Round Date Time To Decimal Minutes
  180. Hide ProgressBar After Process Loop Is Complete
  181. Enable CommandButton Only By Selecting The Name Of The Procedure In A Dropdown List
  182. How To Stop An OnTime Scheduled Macro Without Getting An Error
  183. Migrate Or Copy Columns Depending On Their Color Based On Conditional Formatting
  184. How To Increase Font Size Of Dropdown Form Control
  185. Get Name Of Sheets Using Formula
  186. Identify Or Highlight Cells Having Formula Using Conditional Formatting
  187. VBA Macro To Save And Copy File To Different Locations
  188. How To Look-up The Opening, Closing, High and Low Values Of A Category
  189. How To Create A Watermark While Printing In Excel Using VBA
  190. Get Hourly Data From Text File After Converting To Excel File
  191. Need an Autofill VBA
  192. Excel Macro to Split Multiple Columns into rows
  193. Formula To Show The Sum Of Filtered List Using SubTotal
  194. How to open,copy and save as .. want to automate
  195. Extract All Synonymous Names In A Range To Another Range Using Formula
  196. Click On Bubble In Bubble Chart To Take User To A Sheet Or Range
  197. Append Fields in an Existing ADO Recordset
  198. Macro to copy value based on name
  199. InputBox OK and Cancel Button Problem
  200. Modification in the Excel to Outlook mail
  201. Macro to show row number and sheet name
  202. VBA To Scroll Through ListBox Using Mouse Scroll Wheel
  203. =MIN(IF(
  204. Copy range and paste depending on the selected checkbox
  205. To change Date format in a disorderly column
  206. Custom Formula based on Rank Remarks
  207. selected colour cell will save / show in new sheet or within the sheet
  208. How To Split Text From A Cell Range Into Different Columns Using Formula
  209. Force user to use date format dd/mm/yyyy on User Form
  210. List box tabbing
  211. Help: Searching and extracting data from rows
  212. Redistribute data from multiple columns into separate rows
  213. Get Error while add new sheet in excel
  214. Change Picture Based On DropDown ComboBox Selection Cell Validation Using Formula
  215. Summarize range of comma delimited values
  216. Long Formula in cell and REF!
  217. excel to send emails to specified addesses determined by due date
  218. Sum of Alternate Columns
  219. Consolidate Multiple Workbooks With Different and Same Column Headers To Master File
  220. Extract Email ID From A List Of Sentences
  221. VBA Macro To Clear Everything Excel Formula And Bold Text
  222. Display macro enable/disable alert in an emailed file.
  223. Get Combination Of Unique Values From N Columns Using Rand Or RandBetween Function
  224. Get List Of All Values Corresponding To A Value In The Adjacent Column
  225. Dynamically Update Chart With Latest X Columns Of Data As New Data Is Updated
  226. Conditionally Manage Multiple Items In Worksheet_Change(ByVal Target As Range) Event
  227. Convert Matrix Style Data into Stacked Rows preserving identifying row values
  228. Sum All Rows And Columns In A Range Where Criteria Matches Across Rows And Columns
  229. Excel VBA Macro To Conditional Delete Rows Across Multiple Sheets
  230. inserting date
  231. Search List of my codes
  232. Date Formatting
  233. How to delete cells' values through a multiselect listbox?
  234. Macro to open and update several workbooks
  235. Macro to produce Thick Border Box
  236. VBA Macro To Find Specific Text And Insert Text Few Rows Below
  237. VBA To Update Or Refresh Listview Items Or Records Dynamically In Userform
  238. Attach File To An Email Using VB Code
  239. Fill Blanks With Averages
  240. Concatenating your Balls
  241. VBA Help for Meeting Plotter
  242. Code to open up files in folder and sub-folder
  243. Prevent Excel From Maximizing When UserForm Is Active
  244. AutoFill Formula To The Last Row With Data
  245. Unique Random Numbers Using Formula
  246. Excel macro to get GAL from outlook.
  247. Custom Cell Format To Display 8 Digit Numeric Value As Date In DD/MM/YYYY Format
  248. Looping Through String Using Excel VBA!
  249. How To Split A Text Based On Two Special Characters
  250. Insert many worksheets and name