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