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 167 168 169 170 171 172 173

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