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

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