PDA

View Full Version : Excel Help


Pages : 1 2 3 4 5 [6] 7
  1. Correcting an excel sheet after exporting from crystal report
  2. Help with VBA timin issue on task scheduler
  3. Grouping column containing Number values into specific subgroups
  4. Split Upper / Lower case + concatenate rows
  5. Redistributing OR Split Column Info Into Separate Rows
  6. Nested if isblank, or, and excel function.
  7. File Name previous/next
  8. Need help to modify the VBA code
  9. Apply filter and delete rows thru Messege Box
  10. Identifying Zero-to-Non-Zero Value and vice versa
  11. Macro to Auto Run When Excel Cell Data Changes
  12. Drop Down List with Default Value & Color
  13. Import row data from multiple worksheets to generate a report using vba
  14. add an addition cell colour to coding
  15. Split Text In To Segments Of Upto X Characters And At The Space Between Words
  16. Rename tab on cell value from another worksheet
  17. VBA Macro To Open A File And Extract Data From Specific Columns
  18. Excel gaps and alphabetization
  19. repeating one number
  20. UserForm ComboBox error
  21. Excel Sheet Correction
  22. Lock Or Unlock Entire Row Depending On Value In Each Cell In A Column
  23. macro to hide and unhide columns and rows
  24. Formula To Remove Part Of Text Based On It's Position In A Sentence
  25. VBA Code for User Form
  26. Monthly Chart with Values & Percentages
  27. macro to drag and fill formula til the time stamp match
  28. Formula To Display Numbers In Custom Format
  29. References lost: extrenal and internal sheet names
  30. Button to export data to a master file
  31. filter for multiple text
  32. Viewing cell values in ribbon, not reference cells nor final value.
  33. How to get incremental volume reference to the time interval
  34. to get one complete vba code from gathering vba codes and formulla
  35. to get one complete vba code from gathering vba codes and formulla ...
  36. Project Explorer Strangeness
  37. INDEX formula not working
  38. changing arrangement of data to new style
  39. inserting a row(empty) afther each 4 rows of my data
  40. Single calendar (Userform) for multiple textboxes
  41. Concatenate Two Or Multiple Columns In To One Based On Multiple Criteria
  42. Inconsistent "greater than" and "less than" calculations
  43. Code Or Command To Open XLSM Files And Close And Save As CSV
  44. Find Duplicate Values In A Column And Identify Position In Next Column
  45. Splitting userform text onto different rows
  46. Get Date prior to Actual Date
  47. Remove the Index References table and continue to show the CF
  48. VBA How to pass formatted text from Excel to MS Word
  49. Choose folder, loop thru files to copy data & paste in new master workbook
  50. Vlookup-Concatenate results
  51. Validating PAN NUMBER Indian Format
  52. Search by word and replace with Date from another sheet!
  53. convert formula to a number
  54. VBA - Code if pivot column header gets changed every day
  55. Excel VBA to copy and paste columns
  56. Split the contents from single cell into multiple cell in excel 2010
  57. VBA Coding for English/Spanish Google Translation Error
  58. Lock Cells after date passed - VBA Code
  59. Remove blank in drop list
  60. Need Help to Restructure the table
  61. Determine why basic syntax errors out in Excel 2013
  62. Return a comment based on values in another cell
  63. How to delete a worksheet from multiple files
  64. DELETING ROWS IN SPREADSHEET BASED ON CRITERIA IN ANOTHER SHEET
  65. How to Active Drill Up and Drill Down Option in pivot Table Analyze Tab
  66. [For Loop] Apply Exchange Rate Calculation to Cells
  67. VBA to Merge Multiple Workbooks with Multiple sheets into one master sheet
  68. Email message from Excel
  69. List of criterea to exclude
  70. Create a sorted list of uniques based on 2 columns
  71. Round the custom range of row
  72. Revisiting Redistribute a Delimited Column Of Data into Separate Rows
  73. Dynamic Reference to Another Worksheet
  74. Consolidation Values only
  75. How To Clear Undo List Stack In Excel
  76. SUMPRODUCT function with heaps of IFS
  77. Automatic Email from an Excel Cell Data Entry
  78. Email with outlook using vba
  79. Remove first character then compare to another cell
  80. copy data and paste it in another sheet
  81. copy data and paste it in another sheet
  82. Select till row destination
  83. Conditional Selection of cells and its row
  84. Special concatenation
  85. Want to Send emails by clicking an email hyperlink in the excel sheet
  86. I need help writing VBA code
  87. How To Limit The Word Length Or Number Of Characters In A Cell
  88. Autosize the height of a pivot chart based on the number of filtered values
  89. Why is this code returning a Runtime error 13 Type mismatch?
  90. Capture the "Last Modifed" date from FilePicker
  91. Macro to Delete Rows of Extraneous Data
  92. Initial capital customized
  93. Extract numbers from text into multiple columns
  94. request for macro to find information in various cells
  95. Unique Concatenate Range, multiple rows, Index Match Mutliple Criteria
  96. Extract Time from a Date&time cell
  97. List Files In Folder & Subfolders Using DIR
  98. Formula with 3 arguments
  99. Code to condition format the cell colors and font colors of a range values
  100. Divide Rest of the Columns using Column A values
  101. Change the text within a cell to the text within another cell and paste in another co
  102. Pull text from the left of a character to the right of the next character foun
  103. Worksheet Duplication Code Help
  104. Excel 2010 Unique Count in Pivot Tables with Helper Cells/Columns and Sumproduct
  105. Change Cell Color - Date
  106. VBA Code To Run Through A Column And Email Blanks
  107. Sumproduct and Sumif in vba in large datasheet
  108. Excel VBA Macro To Repeat Records Based On User Value In InputBox
  109. Remove Parts to URL
  110. E-mail Jewish / Civil Date Converter
  111. Jewish / Civil Date Converter
  112. Multiple IF's Formula Help!!
  113. Search Criteria / Formula
  114. Getting data with web query and rearrange the data
  115. Visible range from UDF having filtered Listobject columns as argument
  116. UNPIVOT crosstab sheet using SQL and get count of items.
  117. TAT Calculation
  118. populate control from named range stored in addin
  119. Resize Image To Excel Window Size And Scale To Fit Automatically
  120. Counting font color of conditionally formatted cells
  121. Breaking excel tab into multiple worksheets and maintaining 2 header rows
  122. DATA SHEET UPDATE INFO CODE
  123. Outlook Email Send Only Ranges Selected Instead of The Entire Sheet
  124. How to send emails from excel vba (with attachment) using outlook
  125. Merge worksheets into one worksheet
  126. Disable Selection Of Some Items In MultiSelect ListBox
  127. Dir Function not returning next file after Custom Function called
  128. Send emails with worksheet attachment to multiple email addresses
  129. Conditional string population between sheets
  130. Lock TextBox From Selecting Or Copying Text But Allow Scroll
  131. Extract Date and time from the Text Column
  132. Calculate Difference Between Start Date Time And End Date Time
  133. Alternatives SUMPRODUCT ISO
  134. Extract Time in 24H format from Date and time.
  135. Convert Hours and Minutes From Separate Columns Into Time
  136. VBA Macro To Create An Excel File With Same Sheet Name As Workbook Name
  137. All Data Validation Message Boxes Appear in Same Location Despite Cell Selected
  138. Excel VBA/Macro Help required URGENT
  139. Sort an array based on another array - VBA
  140. Send email from Excel custom list using outlook
  141. Display language "long date"
  142. Serial number to date formula
  143. Continue the calculation but stops at 99 *
  144. How to populate all the rows in one column based on one cell value
  145. Macro to Identify Amounts Based on Criteria Value
  146. Code Required to calculate number of days worked, normal overtime and holiday overtime
  147. Combine worksheet one after another from folder
  148. hi need a code for vb to transfer excel live data to notepad daily
  149. Family Link
  150. Use a Loop to Copy Certain Sets of Sheets to New Workbooks
  151. Re: Defining multiple variables in VBA
  152. Copy data from one sheet to another sheet
  153. Highlight and popup message Between employee dates are overlap using (vba)
  154. Highlight Overlap dates
  155. Excel text conversion formula question
  156. Format four digit number to put decimal after first two digits
  157. Need to Track the Utilization of Excel Dashboard
  158. Formula Editor/Bar in UserForm TextBox?
  159. VBA Macro to open a file and extract data
  160. Need help costumizing a graphic
  161. send Reminder Email to Outlook if cell value reached
  162. Need to modify VBA code to import data from other workbook
  163. Fiscal Year Quarter Formula
  164. trying to simplify this formula
  165. SUMIF with dates
  166. Conditional Sum Based On Time
  167. CONCAT into one cell based on 2 values
  168. Convert Text from .txt to columns in excel
  169. Vlookup, Index, Match formula needed for a search criteria
  170. Macro to Create a Combined Sheet from Multiple Sheets
  171. VBA to upload image over another image
  172. Restrict data within the Cell (Data Validation)
  173. How to arrange cells like this?
  174. Append Table data to another table
  175. How to name Excel worksheet based on min-max in column
  176. Set Length of Worksheet Name
  177. VBA Code Error
  178. Select Column and Identify First and Last non blank cell value per segment (Range between Blanks)
  179. All possible on/off combos of 4 variables
  180. Generating numbers from a number list
  181. Import TXT files without VBA
  182. Export data (text) Excel to Ms Word Format
  183. Subtotal with Filtering
  184. How to search google news using cell values in microsoft excel 2010/2016?
  185. How can you convert this VBA with use Scripting Dictionary, so it becomes fast.
  186. How To Avoid Using Too Many OR and AND Functions In VBA
  187. Jump to Last Used Cell in a Column?
  188. any recommendation for best tutorial to learn scripting dictionary in VBA?
  189. add zero to cells with cells with less that 8 characters
  190. Sum the same cell across multiple sheets - variable number of sheets
  191. Code to copy the active WS before a specific WS in the WB
  192. Time Counter
  193. Selection range
  194. Find text and replace
  195. How search two values and concatenate the result from one column !!!
  196. Help in SUMIF Formula
  197. iam getting Vba erro1004
  198. apply NumberFormat
  199. create invoice with user form
  200. How to automate look up of id numbers in a spreadsheet from a .csv
  201. Excel vba paste range into email body as picture
  202. Multiple sheet splitting
  203. How to turn Automatic Completion on/off in Excel 2007
  204. complete page numbers
  205. VBA - Set User rights (formats, structure)
  206. Urgent support needed. Multiple emails, multiple Excel workbooks, at once.
  207. VBA For each row in visible selection
  208. Make macro create unique files only once.If files exist amend them.
  209. Copy data from Unique files into Masterfile all the files in the same folder.
  210. VBA Worksheet Buttons: Form controls Command Buttons verses ActiveX controls Command Buttons
  211. Excel 2003. ActiveX controls embedded in worksheet not working, then can’t even insert them. *SOLVED*
  212. If condition: help needed
  213. Connect Excel to oracle database
  214. Toggle Between RowSource Items And List Items In A ComboBox Based On Criteria
  215. Automatic sort due date and send email
  216. Identifying the last duplicated string
  217. Link spin button or scroll button to chart.
  218. Userform Vba code to subtrack and Generate new ID
  219. Vba button Comparison data between two file or two tabs
  220. Misc. Leonardo1234 rider@1234 vixer. Highlighting. Simple Early stuff. Avinash Introduction
  221. Please help me
  222. How to Get & Use Worksheet Name in Excel2007 Macro
  223. VBA to Send Email Requests from Master List Array
  224. Insert Different Picture into Multiple Sheets
  225. Fill Columns based on open date
  226. Delete entire column if a specific string is found in a row.
  227. Move values in rows at the end of the preceding row *SOLVED*
  228. custom ribbon how to access checkbox
  229. Top N Value using Slicer
  230. VBA Code: Copy and Paste Range if requirements met
  231. Conditional Formatting of Dates (Multiple Criteria)
  232. Use OFFSET function to define the x-axis range in a chart
  233. Formula to find text pattern across multiple cells in a row.
  234. Cannot read chart object (x,y) values when hovering mouse over chart using overlaid shapes
  235. Mail Merge with Variable Table Length
  236. Lookup First URL From Google/Bing Search Result
  237. Open userform2 and register if the user is opening the workbook for the first time.... *SOLVED*
  238. How to populate the column 3 under this condition??
  239. Remove Hard Carriage Return And Leading And Trailing Spaces
  240. Fill Column Based on Actual Time
  241. Use VBA to automate entry of schedule, scores
  242. Transpose rows to column and join table
  243. Extract Data From Text File Using VBA
  244. Formula To Get Best Bowling Stats From Wickets Taken and Runs Conceded [Cricket Bowling]
  245. Excel VBA - Problem downloading first image from google (Most fail, others repeat)
  246. PARCOURIR UNE COLONNE ET COMPARER LES VALEURS EN VBA
  247. Vlookup on multiple matches
  248. VBA Simple Copy and Paste between two workbooks based on criteria
  249. Modify the VBA code to exclude text only leave logo from signature
  250. Apply formula Calculation by VBA Value ="to Forumula"