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. Move rows that meet criteria of sheet from multiple workbooks to other workbook (VBA)
  2. Identifying Duplicate E-mail Addresses with Different First and Last Names
  3. [SOLVED:] VBA Help - Code to create a copy of a macro enabled workbook
  4. Passing Excel macro variable to access macro
  5. [SOLVED:] macro stops if no data in filterd criteria
  6. [SOLVED:] VBA to replace numerical data with Alphnumerical data.
  7. VBA date
  8. [SOLVED:] Checkbox populated by worksheet cells via userform
  9. [SOLVED:] Filter columns from negative values for Histogram Chart
  10. [SOLVED:] Sum values between two specified dates
  11. [SOLVED:] Help to convert COUNTIFS to VBA
  12. [SOLVED:] testing for correlation matrix
  13. excel vba error 91 object variable or with block variable not set
  14. Frustrated need help with Email code Excel, Lotus, Attachements
  15. Errors dumping an Array to a range in a table
  16. Need explanation to save file as
  17. END IF WITHOUT BLOCK IF
  18. Choosing/listing from existing database
  19. [SOLVED:] Loop through folder only opens one file
  20. Paste Special: PasteSpecial method of Range class failed
  21. Run-Time Error '1004' Delete method of Range class failed
  22. Extract data with one criteria and no duplicate
  23. Date picker
  24. Creating workbooks/sheets based on a tables in a master workbook
  25. copy data from a range in sheet into rows in another sheet
  26. Listing text files based on search value - returns multiple instances of same record
  27. [SOLVED:] Help with Pasting Values
  28. Passing one function to another
  29. Get the first instance of a value from a range
  30. [SOLVED:] Captilize Select Characters Within A Cell
  31. VBA to download images in web
  32. Using Excel VBA i want to protect a range of cells but other cells should be editable
  33. Converting LEFT and RIGHT with FIND formulas to VBA macros including IFERROR
  34. Help for VBA Code as too much time while processing
  35. Finding blank cells in named range and input 0
  36. Sort files by date in a folder and then use this ordered list to open the files
  37. [SOLVED:] Run Same VBA Macro Code On Multiple Sheets
  38. Vlookup with multiple results
  39. run time error '1004' Help!!!!
  40. Error with Protect and Unprotect through VBA
  41. HTTP Response cookies not retrieved in results for XMLHTTP request in EXCEL Macro
  42. [SOLVED:] Workbook closes "by itself" when some macros run or other workbooks opened.
  43. Checking if other sheets in the workbook contain the same content as a defined cell
  44. [SOLVED:] Match Funtion VBA
  45. How i can exit from compo box after select ?
  46. Change Excel sheet Tab colour when date entered in a cell
  47. Restrict Duplicate Values in a Row using excel VBA
  48. VBA Coding needs advice - To Simplify
  49. [SOLVED:] Copy Values from an array into sheet tab names
  50. Copy-paste extracted data in values to reference sheet (VBA)
  51. [SOLVED:] Clear Contents VBA
  52. Need help creating a formula for multiple sheets of data that will tie into a chart
  53. Daily Data for Entire Year - vba userform
  54. Excel to PPT --- can't detect error in loop
  55. Need Help: Check Sheet Name Exists Before Creating New W/ Same Name
  56. Sleeper: Best way to add a column to a range with offset of n
  57. Choose Invoice Number from a userform combobox and copy data to invoice output
  58. Vba İnformation About The Array() Cells() Property
  59. [VBA] How to trigger a macro with a letter key without "Ctrl"
  60. [SOLVED:] How to avoid to continue searching (on the same sheet) if specific word is found
  61. Advice required to run code faster
  62. Solver VBA code for multiple sheets
  63. [SOLVED:] Conditional Formatting Formula
  64. Solver VBA code for different objective function cells
  65. [SOLVED:] How to populate data from one sheet to another?
  66. [SOLVED:] Filter question
  67. Deleting worksheets with specific name ??
  68. Runtime Error 1004
  69. [SOLVED:] Looping formula
  70. Loop data is not recognized
  71. Different charts in one diagram: chart modification problem
  72. [SOLVED:] Need vba macro to highlight duplicates in a column
  73. [SOLVED:] VBA Calculate Event
  74. [SOLVED:] Copy and Paste Data from One Tab to Another
  75. Loop Through SubFolders Task - Merge Files as Folder Name
  76. [SOLVED:] VBA appears to be missing something please help!!
  77. VBA for highlighting needs revising
  78. Track changes to a column, not when rows are inserted and deleted
  79. Edit rows with userform textboxes and coboboxes
  80. Help with code
  81. [SOLVED:] Delete Sheet Macro Crashes Excel
  82. VBA error on copying workbooks from file location
  83. Help on Excel Project
  84. relative range / Offset within a sum - how to change the range summed
  85. auto scale every chart in a worksheet based on each charts x and y axis min and max v
  86. [SOLVED:] VBA codes clashing
  87. Creating Chart Via VBA
  88. Analog clock with Chart
  89. Windows 10 MISSING: Microsoft Windows Common Controls 6.0 (SP6)
  90. Macro that will consolidate multiple worksheets regardless of worksheet name
  91. Store image in VBA?
  92. [SOLVED:] Copy + Find + Past (2 Files)
  93. [SOLVED:] Excel VBA Date Issue Transfer from one worksheet to another
  94. Extracting Left function -String into Columns
  95. [SOLVED:] How to Compare a textbox entry to a column and find duplicates?
  96. Macro to copy specific data from sheet A to sheet B
  97. [SOLVED:] Mailbatch with 2 different bodies based on cell
  98. [SOLVED:] VBA to merge data and place - between each data from five columns
  99. [SOLVED:] Change event problem
  100. [SOLVED:] Select Active cell to top cell
  101. [SOLVED:] Remove Array Elements
  102. [SOLVED:] Help inserting a variable in to a formula
  103. Lay Dutch Test of dynamic subsets
  104. help, a system to check inventories
  105. Help - Selective look up needed
  106. Copy-paste data from source file to master workbook
  107. Match a string with a string that includes a wildcard (*) excel?
  108. Stock Historic prices on button click
  109. VBA macro for highlighting datain range based on selecting data in another
  110. How to make a dynamic table(dynamic rows and columns) using VBA code
  111. Need Help With Excel Formula
  112. Find yyyymm in date column
  113. Hello masters of VBA... here I am a newie for VBA with a question - please help
  114. VBA to jump to range in contained in a SUMIFS formula
  115. [SOLVED:] Searching selected range (offset) for values in external workbook range
  116. Excel VBA add new list item in SharePoint List
  117. [SOLVED:] Worksheet_SelectionChange(ByVal Target As Range)
  118. Arrays
  119. If statement checking last digit and modifying time
  120. Please Help with VBA code
  121. Macro take multiple screenshots and save in excel
  122. Stephen Bullen's Resize (Userform)
  123. How to Parse Based on Varying SubStrings
  124. [SOLVED:] Trouble Grouping Label and Shape
  125. [SOLVED:] DateDiff in listview excel
  126. [SOLVED:] Sum of cells in a row on other sheet, column reference based on selected number range
  127. Timesheet Help
  128. [SLEEPER:] Macro to savecopyAs multiply based on filter
  129. Simple excel macro if then condition to manipulate column values
  130. Need to copy specific text from open word doc, to excel in a row
  131. Conditional Formatting from one row to another
  132. [SOLVED:] Select Case Conditional Formatting VBA
  133. Convert a value to suit an Excel Speedo's segmented variable scale
  134. How to skip an empty cell in a column ?
  135. [SOLVED:] Save a certain sheet as PDF and name it from a range within the sheet
  136. Data Distribution
  137. Pivot Table from dynamic range
  138. [SOLVED:] Need Help with Userform Progress Bar
  139. Clear Slicers Using VBA
  140. Sleeper: Copy filtered table
  141. Help Needed
  142. Using Index Match in VBA Project
  143. ActiveDocument.Close error
  144. Extracting data from different worksheets in desired format-Part 2 (Editing formula)
  145. Macro copy worksheet to workbook and row offsets
  146. [SLEEPER:] How to generate a dynamic range using VBA code
  147. Populate form ListBox from range
  148. How to recover A corrupted Excel 2003 file
  149. Reading data from Word document; selecting line after table
  150. Assigning variable to table or table name
  151. Need help to convert formula to VBA code
  152. Numbers format preventing calculation to be implemented
  153. Split the Workbook into different files based on SPECIFIC DATA VALUES
  154. Help on macro to fetch data from one sheet and post on the other
  155. Several VBA questions / index match
  156. [SOLVED:] combining several VBA subs
  157. Running macro on another workbook
  158. iserror and lookup not working combined
  159. [SOLVED:] search excel cells for value and input corresponding value in adjecent cell
  160. [SOLVED:] Search string and return file name and Path
  161. if iserror match not functioning
  162. [SOLVED:] Removing middle initials with space in last name
  163. Date Calculation Inside TextBox Vba
  164. Sleeper: Comparing pivot table and adding value to cell
  165. Help with inputting the value in the back sheet using VBA code
  166. Query Access database with parameters on Excel sheet.
  167. How to set focus back into the textbox after an error message?
  168. Using a userform with a for loop
  169. [SOLVED:] Excel to Word Macro Merge File Select Help
  170. [SOLVED:] vlookup array values
  171. [SOLVED:] Sheet Buttons Flashing When Mouse Over Userform
  172. Update cell value on sheet change
  173. Geometric Brownian Motion simulation?
  174. Update cell on sheet change - w/correct file
  175. Logging into a website
  176. Find and add missing value
  177. [SOLVED:] Label in Frame, catch caption with click error!
  178. Repeating a string using VBA button
  179. Calculating differences in exchange rates - FIFO method VBA
  180. Msgbox when textbox not filled but on choice (yes/no)
  181. [SOLVED:] Help with authoirisation list please
  182. Macro to find numbers in a single column
  183. Macro to find numbers in a single column
  184. Overflow error on VBA Module
  185. Simple VBA query
  186. Excel File Recovery
  187. Copy range into a image in Outlook
  188. Macro Automatically SUM upper data when entering new data
  189. Get TIME format to match?
  190. [SOLVED:] error in VBA lookup code
  191. power function in VBA
  192. Applying Border to symbols in Excel VBA
  193. formula to check different between 2 dates within same month in range
  194. Open workbook with one password close with another from a list??
  195. [SOLVED:] Confused between Date and Today
  196. Play embedded wav file when workbook opens
  197. Hide Excel Tabs-Heading-Formula Bar on Opening
  198. Update data from mapping table to another worksheet
  199. [SOLVED:] Align all shapes to the center of their cell
  200. lookup problem
  201. Error Handling for data scraping
  202. Matching data from two different sheets
  203. Add Active X Command Button to sheet and keep Userform Open
  204. Help with Sub
  205. [SOLVED:] Something missing from code
  206. Flip an image in a userform?
  207. Download images from the excel and save to a Folder
  208. [SOLVED:] VBA Syntax to run sql statement with where and order by
  209. Copy data in disperce cells from multiple excel workbooks..?
  210. Copy Pivot Table From One Workbook To Another
  211. [SOLVED:] Listing unique vales in a range with blank cells
  212. Listing values assosciated with headings on a worksheet
  213. Macro to enter filepath on click browse button
  214. Extract specific columns from DBF to Excel
  215. Copy Data From One Sheet to Another with Input Box
  216. [SOLVED:] Group shapes in a single cell without select
  217. 1004 Error Copying and Pasting Range
  218. [SOLVED:] Issue with Mass-Email Excel macro
  219. Copy to multiple sheet based on cell value criteria
  220. ActiveCell.Value=replace........not putting range in new column.
  221. Non Looping For Next Loop
  222. VBA Fill arrays from sheet | SUMIFS | create & fill table based on multiple criteria
  223. How to increment Alpha numeric Value
  224. Populate (string) array from sheet
  225. Help with code to export excel to text file with number format
  226. VBA export filename and path
  227. How to leave just the text I want in a cell.
  228. Consolidating Order Sheet
  229. VBA CODE HELP ...if you have time!!!
  230. [SOLVED:] How to get the absolute column number of given cell value from the range C2:K2
  231. Custom Menu/Macro Library
  232. [SOLVED:] VBA find the FIRST real row
  233. [SOLVED:] Run-Time Error "1004" LOOPS!
  234. Match index with closest previous date
  235. Trendline for y-values
  236. [SOLVED:] Excel 2013 ActiveX Combo Boxes Macro Glitch
  237. How to make a solver VBA code in a dynamic range
  238. [SOLVED:] Compiling a List to a Seperate Sheet
  239. VBA code to remove text from a column
  240. vba code for getting the filename for another worksheet on a newfile worksheet
  241. Match 1st ?? in column vertically, if Yes, then see if 2nd ?? matches horizontally?
  242. Macro to loop through Web Queries and enact a second macro once each page loads
  243. How to find and use the maximum value in VBA
  244. read Tag property without opening file
  245. Strings and Variables
  246. [SOLVED:] Test Pivot Table
  247. VBA Pivot Table creation looks different than manual creation
  248. [SOLVED:] Function working within Sub but not in spreadsheet
  249. [SOLVED:] List box looses Blue 'highlight' when changing forecolor
  250. Generate Shapes, Align, Group, Cut and Paste