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