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