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

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