PDA

View Full Version : Excel Help



Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 [153] 154 155 156 157 158 159 160 161 162 163 164 165 166 167

  1. Vba Code to open multiple files from a specific directory
  2. Form showing odd sizes
  3. How to consolidate data from multiple sheets into a master excel
  4. Index/Return cell references from table array based on "Yes"/"No" response
  5. [SOLVED] Wrong result of my macro!
  6. VBA Combobox for vlookup
  7. [SOLVED] loop through files in a folder based on a condition
  8. Replacing Text evenly from 1 sheet to another sheet
  9. Formatting table in worksheet
  10. [SOLVED] Bold First Name in a VBA generated Email
  11. [SOLVED] Convert text in alphanumeric string to lower case
  12. [SOLVED] Returning an element from an array of subclasses
  13. Control Panel using a userfom and hide workbook
  14. How to rename a bunch of files in the same folder using an Excel VBA code?
  15. Import HTML Data into excel
  16. [SOLVED] COUNTIF code then insert copied cells
  17. [SOLVED] listbox1 to listbox2
  18. [SOLVED] Issue with button
  19. [SOLVED] Why are my formulas changing automatically?
  20. [SOLVED] Non Regular Sequential Numbering
  21. [SOLVED] Outcome is not as expected - code might be wrong
  22. VBA To search for a WorksheetSheet and a Column in that sheet.
  23. Excel charts as jpgs to specific powerpoint
  24. help creating a repricing tool with defined parameters
  25. email automation
  26. Mail Merge Excel however instead of Print Need save as
  27. ID matching with Name and sub six hours work time calculation
  28. [SOLVED] Copy row data from one workbook to another based on row header name
  29. vba - copy workbook 300 times once user selects folder
  30. [SOLVED] Line Break Validation
  31. Pull Date by Criteria for Visible cells only
  32. Office Automation: Excel executng Word VBA
  33. Paste column format only through iteration
  34. VBA event to detect an Autofill Scrolling?
  35. [SOLVED] Using concatenate to reference a named range
  36. [VBA] set range find() -> finds wrong value
  37. Iterate 2 dropdown lists and move to all the new tabs to new workbook
  38. Save Active Word Doc with URL File Path
  39. [SOLVED] Split First, Middle and Last Name
  40. Finding the last modified date of an excel sheet
  41. Avoid code repetition by calling the common code from another sub
  42. Dsum and Data Tables
  43. [SOLVED] Looping through a Range of Data
  44. Loop through all Pivot tables in a worksheet and filter visability VBA
  45. VBA Code problem for Excel 2016 on a mac
  46. [SOLVED] lookup formula to sum percent
  47. VBA Code to attach (multiple) file(s)
  48. Minimize-Maximize-Resizing-Scrolling in a Userform
  49. [SOLVED] how to loop search to show multiple entries in listbox
  50. What am I doing wrong here?
  51. Range of inputs and graphing of result
  52. VBA Code running in f8 but not f5
  53. [SOLVED] Dim problem
  54. [SOLVED] Remove duplicates (runtime error 5)
  55. [SOLVED] automated data query
  56. [SOLVED] Sum Values Assigned to a Name
  57. Copy data from multiple single-worksheet workbooks into another workbook
  58. [SOLVED] Loop to copy and paste first cell of repeated values
  59. Loop for substitution
  60. Combine Data in Mutiple Columns into Rows
  61. Sheet_change is not worked
  62. Extract single row from multiple workbooks
  63. [SOLVED] Return Multiple Listbox Selection
  64. Need help with Timesheet Workbook I know exactly what I need !
  65. [SOLVED] Create outlook appointementes only on "check" rows
  66. macro to send multiple emails with all attachements from specific folder
  67. my excel vba stop running when i run the userform and not responding
  68. loading a txt file into excel win works fine. Loading txt on a mac doesn't work.
  69. copy and paste a certain number of times
  70. Vlook from Closed workbook taking a lot time
  71. what is wrong with my update button code excel vba
  72. [SOLVED] Validate cells in column A with info from other columns
  73. Improve efficiency of VBA Code
  74. [SOLVED] Getting Run Time Error 5 on String?
  75. Returning the Caption Property for active controls in an email body
  76. search for multiple value using FORMS
  77. VBA_Pivot table capture in array and reapply
  78. [SOLVED] Concatenation with double quotes and comma for the selected list of values
  79. how to get data from an array table with two different values
  80. Need help moving many fields of data from the master sheet to several other sheets
  81. [SOLVED] Error Handling (runtime error 1004)
  82. Filter the entries of Combobox
  83. [SOLVED] Excel 2010 run time error 91': Object variable or with block ...
  84. [SOLVED] Arrangement of values in groups
  85. Performing count and max commands on multiple groups of rows
  86. [SOLVED] Validation Code Problem
  87. It is possible deleting rows in lisboxt datagrid with active sheets displayed vba exc
  88. Outlook vba help - Folder Picker
  89. [SOLVED] VBA-split data into multiple worksheets based on column
  90. it is possible to save individual sheets as a separate file?
  91. How to Merge Cells Specially
  92. [SOLVED] Help to faster this script for moving Duplicates
  93. How to speed up VBA Code
  94. VBA - Set data list
  95. [SOLVED] Split Cells into rows but with two columns
  96. INDEX MATCH in VBA over different data files
  97. VBA to copy a new sheet based on active sheet
  98. [SOLVED] Color cells from previous colored cells in different column
  99. [SOLVED] Showing two expected values together with an IF function
  100. Restoring default Styles in Excel
  101. [SOLVED] MS MapPoint and MS Excel, plot latitude and longitude on a map
  102. Type missmatch error
  103. [SOLVED] Array of Email Addresses
  104. Find empty cell in one spreadsheet and then paste information from another
  105. Array match Only 1 RedimPreserve
  106. Replace text in email body from the excel
  107. VBA for designing your sheet
  108. xlsm file opens and immediately closes
  109. VBA code for conditional cell merging
  110. Run-time error 438: Object doesn't support this property or method (VBA), Office 2010
  111. SUMPRODUCT with additional sums/ adds
  112. [SOLVED] Conditional Statements & Nested If/Then in VBA
  113. [SOLVED] Copy and Paste Problem
  114. VBA Question
  115. [SOLVED] Need help figuring out what went wrong
  116. VBA Code-csv file into excel- from general to text
  117. VBACode to show autofilter criteria just show result as <>, even though filter is set
  118. Insert Vba macro to Sheet 3 using another macro.
  119. How to run external software run multiple files after each other using VBA (in Excel)
  120. macro to extract specific data from text file to excel sheet
  121. Array Question - basic
  122. Detecting Barcode Scanner input vs input by hand
  123. Allocating buyers based on expertise and performance
  124. Edit to "colour to chart" macro - to cycle through workbook
  125. Counting Used Rows In Column - Best Method?
  126. [SOLVED] Formula returning false when it shouldn't
  127. [SOLVED] Help with equation that has several inputs which vary in value.
  128. Excel 2016 Crashes
  129. [SOLVED] Send all files in folder vba
  130. Filtering numbers according to certain ratios
  131. VBA SUM Formula help
  132. [SOLVED] VBA/Excel change value of a cell in multiple worksheets from a range in another workb
  133. VBA Help needed
  134. SaveAs to SharePoint not working in Excel 2013
  135. [SOLVED] VBA Userform using Danish CPR Numbers
  136. [SOLVED] Color Coding Stops After I get to # 65,282
  137. VBA help loop until & IF formula
  138. How to make multiple, non adjacent cells hidden based on cell value code
  139. [SOLVED] Array Output
  140. Excel-How to concatenate data in multiple dynamic number of rows and multiple columns
  141. Public Variable won't pass
  142. Komplex If-Loop
  143. [SOLVED] MoveAfterReturnDirection
  144. [SOLVED] VBA exel programming: how to make a automatically filled up by filling up other cell
  145. Help with IE Button Click - SHDocVw
  146. Save textbox to specific cell based on combobox seletection
  147. [SOLVED] How to do loop in the function?
  148. Dependent between 2 dropdown columns
  149. Paste from Clipbaord
  150. Stock Locator Inventory System-Issue with locator
  151. Listbox not showing Data
  152. [SOLVED] Having trouble with renaming files in subfolders of subfolders
  153. [SOLVED] Select row based on multiple textbox values
  154. Excel Userform DatePicker Default Format to be Blank
  155. Traverse all images in workbook
  156. Forecasting
  157. Distribute Numbers Evenly, With Conditions
  158. VBA - Export as PDF and overwrite existing PDFs
  159. Copy multiple workbooks & multiple sheets into single workbook with multiple sheets
  160. [SOLVED] Adjust/Sync Table columns number Base on a Pivot Table Columns Size
  161. [SOLVED] VBA - Copy with validatation
  162. [SOLVED] Gradual Zoom?
  163. [SOLVED] Copy data block from one workbook to another .. should be easy
  164. Security
  165. [SOLVED] Dependencies and Dates
  166. Merge duplicates with cell color
  167. [SOLVED] Automatically group the cell based on the words that appear in it
  168. click button via vba
  169. Check Values in Array for Matches
  170. [SOLVED] VBA Help please - Find First Row of Data?
  171. [SOLVED] VBA Loop
  172. input box to define formulas contraints
  173. Send Email separating by specific recipient
  174. Need Excel VBA help to loop in folder, execute several tasks and save filesAs
  175. [SOLVED] VBA Code Modifcation To Insert a New Row and Fill out with Data As Per Existing Code
  176. clearing data using range(cells)
  177. [SOLVED] PRINT EMAILS WHERE SUBJECT MATCHES CELLS IN EXCEL
  178. Summary of cash book day wise
  179. Excel VBA - Check excel file names and change if necessary
  180. [SOLVED] Create a new function to find a date or next date on a selected range
  181. [SOLVED] Excel VBA help....please :)
  182. [SOLVED] Variable Not Defined, Excel 2013 & 2007
  183. How to compare different values either by formula or vba
  184. How to return entire output from Array to Excel sheet in one go
  185. Update value in a column from another worksheet depending on the date in a range
  186. VBA Coloring Cells Based on Value
  187. VBA for printing files listed in excel
  188. Perform Sum in vba code
  189. Prining from VBA not coming out in the correct size, please help me
  190. [SOLVED] Copy and paste total row with engineer name and headings to a new worksheet
  191. Refer to a cell in another worksheet (macro)
  192. VBA - open corrupted file - excel 2010
  193. Sharing Interest Dynamically
  194. Aktivate/ deactivate check box
  195. Add a Calculated filed in pivot table to calculate percentage of adjacent column
  196. Auto fill from multiple rows & cells
  197. [SOLVED] Please Help. Rank Formula Macro
  198. [SOLVED] VBA code for sum function for filtered columns
  199. Summing up values in label captions
  200. How to split categorical data in Excel
  201. [SOLVED] Macro to skip rows that have blank cells
  202. Spllit the data customer wise and email id should come in A1 Column.
  203. Using the Custom UI to create a custom ribbon Addin for Excel
  204. formula help
  205. [SOLVED] Timed Message Boxes not handling code in between
  206. [SOLVED] Brining in 2 inputs incrementally & 3 others from lists.
  207. VBA to email each sheet in a workbook
  208. Help with date and time formats
  209. VBA for AUDITING
  210. [SOLVED] Problem with Userform input to Worksheet (Excel 2013)
  211. Prevent Blank Rows When applying filters
  212. [SOLVED] How to DIM script itself?
  213. [SOLVED] Help with solving a maze in VBA Excel
  214. [SOLVED] if not found record after 1st criterial in Advanced Filter - then move to next if
  215. VBA to email each sheet in a workbook
  216. [SOLVED] Copy from Excel to Powerpoint to create a report
  217. [SOLVED] Deleting multiple cells based on value found
  218. VBA to copy / autofill data, where am i going wrong?
  219. Excel 2016 VBA Error 400
  220. [SOLVED] Hidden Object Range Failure in Worksheet Calculate
  221. [SOLVED] overflow error in range.find
  222. counts ships between instances of picked number
  223. Lock ComboBox/ MsgBox as Error
  224. Quick Question (hopefully) - Possible to create a front sheet for analysing data?
  225. proper variable type
  226. [SOLVED] Consolidating data from multiple workbooks with varying ranges
  227. [SOLVED] VBA Dir and HTTP Directories Equivalent
  228. VBA SQL Query from Cell
  229. Same Userform, Different Lines
  230. Multiple Linear Progression, logging and VBA
  231. Excel Clarification
  232. Market- making algorithm
  233. SUMPRODUCT formula does not add up negative numbers.
  234. Conditional Formatting with Multiple Criteria
  235. Excel Userform - how can I send an HTML email using data from the userform with image
  236. VLookup
  237. Transferring Data between sheets to main record sheet.
  238. Data Tabulation
  239. code for sum function
  240. [SOLVED] Sorting by custom aplphabet
  241. File renaming
  242. [SOLVED] IF-ElseIF-Else macro seems to be disconnected
  243. VBA Loop on Overly Coded Macro
  244. Else without If Problem
  245. [SOLVED] TextBox - Named Range Dynamic Search
  246. Programming Scroll Button on Mouse
  247. [SOLVED] Show Random Numbers Looping on a UserForm
  248. VBA to carry out Simpson's Rule for Tabulated (Equispaced) Data
  249. excel vba change cell color based on a number value in a range
  250. [SOLVED] VBA Error run time 1004: Application-defined or object-defined error