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

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