PDA

View Full Version : Excel Help



Pages : 1 2 [3] 4 5 6 7

  1. Double click can edition in ListView
  2. Conditional Formatting using formula.
  3. Message Box Pop-Up "yes or no"
  4. Excel 2007 - Freeze Pane without lines
  5. Split Row Data In To Multiple Columns Based On Delimiter
  6. Delete Rows Based on Conditions
  7. Conditional Format Cell Based on 'No Match' in Another Range(row).
  8. View Code is disabled in Excel
  9. Chosing Attachment Based On Condition Before Sending Mail In Outlook
  10. How To Send Outlook Email Using VBA
  11. Enter SUM SUMIFS Formula Using VBA
  12. Combine table with dates and values in a new way (special re-sorting)
  13. Maintaining Vouchers in Excel
  14. Alternative to MSCOMCTL.ocx
  15. Print Nth Worksheet To Mth Worksheet using VBA
  16. VBA help in creating a consolidation spread sheet, for multiple files in one folder
  17. Calculate the Hours
  18. Dynamic Worksheet Generator Sheet Copy
  19. Macro Copy Columns and Paste in rows.
  20. Data Sortin_ MS Excel 2010
  21. Adding specfic number to a available number in previous cell.
  22. Find keyword using multiple Text box and combox value
  23. Excel VBA Macro To Dynamically Change Source for Pivot Table
  24. Consolidate Multiple work sheets and save into a specified file
  25. Lookup From Cell Range By Matching Row and Column
  26. Red Green Amber Three Color Conditional Format
  27. Macro for if cell A2 has text then cell B2 must have numeric value.
  28. Match and CountIF Across Multiple Sheets Using Formula
  29. Date Format From Start Day To End Day
  30. Macro stops running if date is not in past...
  31. How do I parse data in excel from every 4 rows to a new column
  32. Macro To Calculate Percentage Allocation
  33. VBA and Depreciation
  34. Formula to rank data where two values are the same
  35. Sequential Lowest Value From Same Column For Each Element
  36. Extracting Numeric Values From Alphanumeric Text
  37. formulas needed please
  38. Lookup Data From Multiple Sheets To Single Sheet Consolidated View Using Formula
  39. Find the last row in a range
  40. Run Time error '9': Subscript out of range
  41. Unable to Get ElementID In VBA IE Automation
  42. Extract Numeric Value From Alphanumeric Text Using VBA RegExp
  43. Need to Delete Multiple Row based on Conditions
  44. Save Processed Files Into Different Another Folder
  45. Save Workbook For Each Change Made In A Range
  46. Macro To Browse Select File And Import Specific Data
  47. How To Make A Calendar In Excel Using Formula
  48. Search for names in a column and row copying purposes
  49. Help- Locking column basis current date.
  50. Formula Following Order Of Calculation BODMAS
  51. Calculate Time Difference Between Time In HH:MM
  52. Find Minimum Value After Data Is Normalized
  53. Comparing Account Number
  54. One userform and 60 Combo Boxes
  55. VLookUp Value From One Sheet To Another Sheet
  56. Find the highest then lookup result
  57. Change Display Range Based On Change of Dropdown Values
  58. Macro to delete trailing X's
  59. Autofilling in VBA through the last row
  60. Good tutorial Excel 2013 SDK
  61. Assign Shortcut To Macro To Be Available For All Active Workbooks
  62. Calculate Minimum Value Based On Percentage When Denominator Is Different
  63. suggest the mistake in this macro part
  64. Lookup Populate Grouped Information Based On DropDown Selection
  65. List of Dates In DropDown Starting From Today()
  66. SumIf Formula Addition Based On AlphaNumeric Criteria
  67. Change Number Written In Words To Numeric Values
  68. How to Update Daily Log In Another Sheet
  69. Comparing Numbers When One Is Text Format And The Other Is Number Numeric Format
  70. Macro To Delete Numbers With Trailing Character
  71. Find Missing Values By Comparing Two Columns / Find Missing Data In Column
  72. Excel VBA Macro To Open A File Through Browse Dialog Box
  73. Sumproduct Formula To Sum Range With Criteria On Numeric Text
  74. How To Save Macro To Personal Workbook
  75. Set "Access content programmatically" checkbox with vba
  76. How To Protect Hide Formula In Excel
  77. Locking Columns data to be edited.
  78. How To Make A Custom VBA Function Available In All Workbooks
  79. Loop to two columns and Concatenate values
  80. Add Named Ranges To Multiple Workbooks Using VBA
  81. Get Return Value Of Active Cell On Change Of Selection Change
  82. Search and remove values ​​from a list
  83. Split Workbook In To Multiple Files Using Advanced Filter And Unique Values
  84. Print Multiple Sheets With Different Cell Data For Each PrintOut
  85. data Transpose in VBA loop, choose the part I want to import!
  86. Vlookup Multiple Values By Adding Formula With Loop In VBA
  87. VBA Looping Input Range and Output Range
  88. Singe Row to Multiple Row
  89. Lookup All Corresponding Values Match Criteria In Adjacent Column Array Formula
  90. Pass Row and Column Number Index To Refer And Put Value To Cell Range
  91. Macro to copy data in specific Columns
  92. Suggest the mistake in the formula
  93. Create orders log and monthly report for all orders
  94. Macro to copy data where name matches destination workbook
  95. Excel VBA Search For Find Duplicate Values In Two Lists
  96. Nested If Formula With Multiple Conditions
  97. Sum Of The Digits Of Numeric Value In A Cell Range
  98. Lookup On Multiple Columns And Return Result Using Match Index
  99. Split Data in Table To Multiple Rows Based On Delimited Text In Columns
  100. calculate sum of three numbers where the answer should be zero
  101. Linking a table to a text box
  102. Combine Columns From Multiple Sheets To One Sheet
  103. Change Chart Data Source To Different Column Ranges Using VBA
  104. VBA To Hide And Unhide Rows
  105. Use Native Excel Function Lookup Formula In VBA
  106. Macro To Import Data From Multiple Workbook Sheets In A Folder
  107. Pause Between Two Macro Sub Routines
  108. Sum Of The Digits In A Cell Using Formula
  109. VBA - Find Last End Value
  110. Split Text with Delimiter
  111. SQL output from Excel VBA macro
  112. Change chart source based on selection in form control list box in excel
  113. Make cells visible based on Data Validation criteria
  114. Trouble implementing UDF's
  115. Arrows
  116. Enter Today's Date When A Specific Value Is Selected In DropDown
  117. Consolidate Import Data From Same Sheet In Multiple Workbooks In To Single Workbook
  118. Copy Table Range Till Last Row Using VBA
  119. Moving Multiple Files From One Folder To Another
  120. Using excel solver add-in.
  121. Open Multiple Workbooks In Folder And Run Text To Column Using VBA
  122. Macro To Sort Data Ascending and Decending Using VBA
  123. Moving Several Files To Several Folders
  124. Timespan Starting With Active Cell Value Using Input Box Value
  125. Preparing Trial Balance Using Pivot Table
  126. How To Make The Enter Key Make Cell Selection Move To Right In Excel
  127. Error Handling When Range Is Not Defined Properly
  128. Copy Selected Range From One Sheet To Multiple Workbooks Sheets Using VBA
  129. Sumif To Add Cumulative YTD Criteria In The Same Column
  130. Import Data From Multiple Workbooks To Another
  131. Auto Complete for Data Validation
  132. To Fin out Purchases against Closing stock
  133. Sumif On Multiple Columns Using Multiple Criteria By Passing A Range Of Values
  134. Lookup First URL From Google Search Result Using VBA
  135. Sum Depending On Match Between Value And Its Existence In A Table
  136. VBA Code To Highlight Duplicate Values In A Column
  137. Select Sheets For Specific Date By Clicking On A Calendar
  138. Clearing Data from Specific cols
  139. Looking up value accross multiple shhets
  140. Macro To Insert Columns In Excel
  141. Userform problem [Message box for missing entry in opt and chk button]
  142. Extracting Specific Line Of Data From Text File Using VBA
  143. VBA Code To Move A Row To A Different Worksheet Within The Same Workbook
  144. Filter, Split And Move Data For Each Month From Master Workbook To Individual Sheet
  145. Create New Sheet and Copy Formula to New Sheet
  146. Learning To Write Excel Formulas And Functions
  147. Sum Based on Lookup
  148. Transpose A Column Of Data In To A Table
  149. Combobox Not Working In Excel Workbook Shared Mode
  150. VBA To Extract Data From Multiple Tables Based On Critera
  151. Extracting Custom Pattern Consisting of Numbers & Text From Alphanumeric String
  152. Excel VBA Code to Add New Sheets
  153. Find Maximum Value Corresponding To Adjacent Column
  154. Conditional Format Using Formula By Referring To Another Sheet
  155. Add Trailing Count Number For Each Duplicate Value
  156. Split Workbook In To Sheets, Export To Folder and Move File
  157. VBA Macro To Create A New Column Of Unique Values From Another Column Of Duplicates
  158. Unable To Attach File To Outlook Email with VBA
  159. VBA To Create A New Workbook
  160. VBS Code to Pull Email SMTP Address From Outlook And Send Email
  161. Extract Certain Characters From A Text String
  162. How To Assign A Non-contiguous Discontinuous Range To An Array
  163. Splitting and merging files with VBA
  164. Sum Of A Row of Cells In Multiple Columns Based On Criteria And Column Index
  165. Extract Email Details For All Incoming Mails Using VBA In Outlook
  166. Lookup Picture Using Formula Without Using VBA
  167. Distribute Debt Across Time Period Split A Number Based On Another Split Ratio
  168. hard question
  169. Copy Data From Multiple Workbooks To A Master Workbook
  170. VBA Code to email using Globals Address Book
  171. Free memory from object using copymemory Api function
  172. Conditional formatting
  173. Macro To Update Data in Cell Based On Value In Adjacent Cell
  174. VBA Macro To Convert Text To Proper Case
  175. VBA Marco To Copy Excel Files From Sub-Directory To Another Directory
  176. Repeat A Value In A Predefined Number Of Rows Using Formula
  177. Create Invoice From Flat Data Range
  178. Highlight A Cell Using Conditional Format Using Row And Column Index
  179. Add Digital Signature To PDF Using VBA
  180. Create A Dynamic Border Using Excel Native Formula
  181. Sort Data Using Formula To Find Top X
  182. Save Worksheets As New File To Specific Folder
  183. Copy Template Worksheet And Rename With Custom Name
  184. Lookup Formula Not Erroring Out When Value Not Found Looking Up Approximate Value
  185. How To Lock Or Protect Cell Using Data Validation
  186. Reference A Cell Conditionally Using ADDRESS And INDIRECT Functions
  187. Open And Activate Workbook Before Runing Macro
  188. How do I get Vlookup to return multiple matches?
  189. Deduct Highests Scores By Condition
  190. Select Group Of Cells Using Data Validation
  191. VBA To Merge Multiple Workbooks In To Single File With One Sheet Per Workbook
  192. Using Excel To Send Multiple Emails With Attachment Through Outlook Using Mac
  193. Consolidate multiple workbooks from a folder into one master file VBA
  194. Send Bulk Personalized E-Mail Through Outlook Using VBA
  195. Macro To Close All CSV Files
  196. VBA To Extract Email Address From Text
  197. Excel 2013: How To Check How Many Excel Files Are Open
  198. How To Prevent Adding Duplicated Record In A Table Using VBA
  199. Formula To LookUp For Revised Phone Number Having Variable Length Starting Digits
  200. Updating Series Point Values By Clicking And Hovering Over An Interactive Chart
  201. Delete All Empty Cells From Range Using VBA / Remove Blank Cells Using Formula
  202. VBA code to move row to new spreadsheet
  203. VBA Code To Email Multiple Recipients From Excel
  204. How To Remove The Error Value Returned By Formula Using IFERROR function
  205. Solve Block If Without End If Problem
  206. Move data from rows into columns for every unique value
  207. VBA Code To Loop Cells In A Column One By One And Search In Another Sheet
  208. Nth Day Of Week Number Using Formula
  209. Warning Alerts Depending On Time Remaining To Finish Task
  210. Lookup Picture Using Formula Without Using VBA
  211. Delte a specific column and does not delete the top row
  212. Delete Entire Row For All Empty Cells In Column
  213. Data Validation For Selecting Date And Week Number
  214. Lookup Start Date And End Date Range For Specific Date Using Formula
  215. Count Colored Cells Using Excel Formula
  216. How To Create A Graph In Excel
  217. Automatically Copy Range To Another Sheet Up On Change In Value In Adjacent Column
  218. Creating Formulas & Macros
  219. Insert Or Delete Columns Based On User Input
  220. Copy Row To Another Sheet On Change Of Value/Update Value To Another Sheet On Change
  221. Staffing Scheduling HELP Match/Index
  222. VBA Program to Compare 4 Columns in Excel (Required)
  223. Find All Empty Blank Cells Or KeyWord In A Column
  224. VBA Code To Move Data From One Sheet To Another And Delete From Source Sheet
  225. Exporting A Worksheet To A CSV File / Save Workbook As CSV File
  226. Find Duplicate Values Across Sheets Using Formula
  227. Copy A Dynamically Range Depending On Last Filled Non-Empty Cell In That Column
  228. Macro to match identical names and allocate ID's
  229. VBA Loop to Auto Send Emails; How to Format the Body
  230. Multiple Value Return Using Lookup
  231. Ageing Monthly Bracket Calculator
  232. Concatenate Two Or Multiple Columns In To One
  233. Group And Transpose Data Based On Sections of Data
  234. Multiple Column Combination Lookup And Return All Items And Get Count of Items
  235. Move Data Only After All Required Range Cells Have Been Filled
  236. Trying to link Excel data to a Word label template (2010)
  237. How To Use Option Buttons To Switch Between Sheets
  238. Toggle Chart Data Using Option Buttons And Formula
  239. Send Mail Using Lotus Notes With Active Sheet As Attachment Using Lotus Notes
  240. Sort Excel Sheets In Custom Order Based On Value In A List
  241. Copy Row To Another Sheet Depending On Existence Of Specific Value In Specific Column
  242. Copy specific data from an excel template and paste in new workbook
  243. Excel Interacting With Another Non-Office Application
  244. Adjust The Width Of Column Chart Series
  245. Transferring Data From One Worksheet To Another If A Condition Is Met
  246. VBA code for my page causing Excel to Crash to desktop and restart
  247. Find The Lowest Corresponding Value For A Repeated Value
  248. Automated Excel File Creation with VBA
  249. Color A Row Of Cells Using Conditional Format Based On A Value In Cell
  250. VBA Code To Protect Sheet With Only A Few Cells Unlocked