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

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