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

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