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

  1. Adding Slide in Powerpoint via Excel VBA
  2. Creating automatic chart using other sheet's data?
  3. need help leaning or restructuring macro for highlighighting duplicates on large data
  4. [SOLVED] Getting last modified date shown in footer and cell
  5. Counting Consecutive numbers > 100 in a column by multiple criteria
  6. Macro does not copy to the next row on the destination sheet
  7. complex slicer
  8. Preventing closing a workbook
  9. Need to build a macro with the following logic. Don't know how to start!
  10. [SOLVED] requesting help on restructuring code to work on extracting data w. int color red
  11. Need Help VBA Find Certain Value
  12. If statement to copy data to correct row
  13. Angle of a trend line
  14. [SOLVED] Updating PT Slicers is Causing Macro to Fail
  15. [SOLVED] VBA Makro Load Data from Website with Java Script
  16. Time delay Stock Data
  17. [SOLVED] Macro not finding next available blank line
  18. Copy rows to new tab based on column value
  19. Only FOR JULY (07-01-18 to 07-31-18 ) as per formula available in cell
  20. Converting a logic in R to Excel VBA
  21. [SOLVED] Export data to workbook with criteria with few selected columns(not all rows)
  22. Jumping to intermittent last cells in a column
  23. Sports scheduling helper
  24. Bring picture to front
  25. Excel VBA macro to paste values
  26. [SOLVED] Next without For error
  27. Excel file open by specific ID number
  28. [SOLVED] Replacing a Date Extracted From a String
  29. Develop VBA program to find and divide numbers
  30. [SOLVED] How to Reference a String in a Cell
  31. Protect & Unprotect Sheet in AutoCall Macro
  32. Excel VBA attaching print area as PDF
  33. Loop through folder to fill a table
  34. Adding to a Cell Which Time Decays
  35. forgot the password of Excel
  36. [SOLVED] Delete after coma when spicify workd does not exists
  37. CONDITIONAL FORMATING IF CELL HAS ROUND FORMULA
  38. Message in cell when criteria is met
  39. Split Data in Column A into Separate Workbooks
  40. VBA program to find the number 15
  41. Repeat VBA code for each cell
  42. VBA Help to Reverse a String without StrReverse function
  43. EDITTING THE LIST FROM COMBOX AND CHANGE TO NEW VALUE
  44. opening 2010 file in VBA
  45. VBA Macro To Scan Headers and Paste Them Into Specific Column On Master Template
  46. VBA to extract & combine data from multiple excel file from a specific folder
  47. Excel 2010 / VBA/ problem with code to create listbox in userform
  48. [SOLVED] VBA copy from a variable sheet
  49. VBA - copy specific cells with criteria to multiple workbooks (get filename from cell
  50. Excel VBA Don't show Sampling - Output range will overwrite existing data
  51. search for a string in a column on a different worksheet
  52. VBA Error handling
  53. Help with VBA code to copy formatting into clipboard
  54. [SOLVED] Radar Scoring
  55. VBA to Auto-populate the Sheet "Protect" password field(s)
  56. VBA Set File path to a cell reference in the workbook
  57. VBA Print area problem
  58. VBA changes "Rows" to "rows"
  59. create and print files automatically
  60. VBA Assistance Needed
  61. Delete duplicates based on partial match
  62. help with select case
  63. [SOLVED] Delete row if cell entries in 4 columns match
  64. Help with VBA Code
  65. Lookup and return Names for Duplicate Orders
  66. Splitting Uneven Text Strings
  67. Divide number under certain conditions
  68. Formula with named ranges not working
  69. Insert the different picture into all worksheets
  70. Shorten
  71. Extracting data from .txt file to excel using vba
  72. Form Controls Reset to Default on Worksheet
  73. [SOLVED] Loop to match headers on separate sheets, copy and paste revisited
  74. VBA IE automation: error on getting iframe
  75. Grade calculator this should be easy fix
  76. VBA is it possible to use a integer like function with cells
  77. Importing data from multiple files by VBA
  78. 1 Email, Multiple Recipients, No Duplicates
  79. VBA Code needed to insert rows based on pricepoints
  80. VBA code. Copy certain cells with a number of conditions
  81. Duplicate entire workbook into 3 copies and leave only specific sheets in the copies
  82. Google Maps Static API in Excel
  83. Excel Formula/Macro: Fetch data from multiple rows and columns with a single key
  84. Can't get my code to offset
  85. Copy Columns in Selected Sheets to a New Table with the data
  86. [SOLVED] intersect range and table.listcolumn - need to find if cell is in table column
  87. Select Multiple entry and remove in dropodown in excel vba
  88. Vba data for chart
  89. Named Range Help - Excel 2013
  90. [SOLVED] Copying data with changing rows.
  91. [SOLVED] Conditional Formatting range selection
  92. Converting columns to rows
  93. VBA Convert textnumber to number format
  94. Find and format only specific text/numbers
  95. Copy several cells into one cell
  96. [SOLVED] Match Overlap Date Range and multiple criteria - Need to match extra criteria
  97. Deleting cell contents based on a partial formula.
  98. Range setting for sort
  99. [SOLVED] Issuing retrieving an "hour value" from worksheet using VBA
  100. [SOLVED] Matching 2 columns
  101. [SOLVED] Transpose Data In Columns
  102. How can I get my second range to transfer as an offset?
  103. [SOLVED] Save to Network drive using UNC format
  104. VBA Code that deletes entire row if "Received" is selected from Drop-Down List
  105. How to increment a column with a selected range
  106. Help with filling out webform from excel sheet
  107. how to further divide out how this is saved?
  108. Copying Rows based on two columns having matching data
  109. Excel file only to open on designated computers
  110. Formula Evaluation In Excel
  111. Excel VBA: Format and change cell value based on specific values in cell
  112. Excel VBA Seek Error Solution
  113. Auto-Size Pasted Picture/Snippet to Fit Cell Height and Width
  114. [SOLVED] Count Rows From Specific Column - Row Number
  115. [SOLVED] Userform for Project closing
  116. Simple Copy and Update Cell Value Every Minute
  117. Sending emails with data from cells (including bcc)
  118. Copying data from one worksheet to another base on the header name.
  119. Runtime 1004 Error SaveAs Workbook Failed
  120. Lookup or match
  121. Add a cell reference in newly created worksheets created by VBA indexed by row
  122. Adding or deleting rows from Table depending of data
  123. Generating a checkbox corresponding to the each worksheet on click
  124. Track Changes not working properly
  125. [SOLVED] Counting The item that separate by | character
  126. Copy/Paste/Rename values between two workbooks if certain conditions are met
  127. Quick Question About XlDown
  128. Macro For Printing Labels
  129. Search multiple values in column A and create sheets based on value name
  130. [SOLVED] Insert Values into - Offset Cells Array
  131. [SOLVED] Export Sheets as CSV and Keep Workbook Open
  132. [SOLVED] Delete a filtered auxiliary column while maintaining the filtered range.
  133. VBA help - not sure which getelement to use for scraping website
  134. [SOLVED] If Column A ıs Empty and if Column I has a data copy them to Column A ..
  135. Add a cell reference in newly created worksheets created by VBA indexed by row
  136. VBA Code - Referencing to a Different Sheet
  137. Combine multiple pdf files into one file using Excel
  138. Open several files from list of paths
  139. [SOLVED] Using form control checkboxes to clear ranges on other pages- VBA Excel
  140. Userform | write new row for ComboBox and TextBox entries ONLY when user adds content
  141. [SOLVED] copy data between worksheets based on list selection
  142. Sub or Function not defined compile error help
  143. How to unhide a sheet - xlveryhidden
  144. Accessing File Properties in an audio file
  145. [SOLVED] Loop to find cell, then using that cell reference to clear a range
  146. innerHTML not returned?
  147. [SOLVED] When Ranks change in a Range
  148. Issues with using autofill in vb macro
  149. [SOLVED] Find ALL cells containing multiple words then display a corresponding cell
  150. Array Problem (Swapping array value based on determined row)
  151. Formula on MS Exel sheet Vlookup ,H_lookup , For Entropy and enthalphy
  152. Intermittent issue with a UDF, Google address extractor.
  153. Get row of Checkboxes
  154. [SOLVED] Dynamically adding check boxes based on worksheet name, updating error
  155. [SOLVED] VBA to create a folder and move
  156. [SOLVED] Cut and past a selected row to another worksheet
  157. Best way for deploy excel with .net dll reference
  158. How to show the last row in this code
  159. Userform Read only to Read/Write
  160. How to use image recognition for finding buttons on an internet explorer page?
  161. Cash flow analysis: Help selecting a cell based on a certain $ threshold
  162. How to return data from a complex nested populated VBA Array
  163. [SOLVED] VBA to check and delete the entire row
  164. [SOLVED] Struggling with Countifs formula
  165. [SOLVED] How to Get Array Length...
  166. Wrong number of arguments or invalid property assignments in Excel ->word
  167. [SOLVED] Issue with References
  168. Excel/VBA app hangs up temporarily when tabbing past last unlocked cell
  169. Extract product-price from URL in Excel VB
  170. extraction of key entities using VBA
  171. GetData from multlipe Closed files with multilpe ranges to one file and specific rang
  172. Filter and delete rows based on value from a cell
  173. Open closed protected excel workbook from other workbook with SQL statement
  174. Copy Rows - If it Contains a Word Listed in Column A Data Table
  175. [SOLVED] Advice re class modules
  176. [SOLVED] Search & Index
  177. Filter excel data without hiding a Graph
  178. Pivot table with 2 sheets
  179. VBA help please
  180. Subtract values in column VBA
  181. 2010 macro runs slow in 2016 and display result is different
  182. [SOLVED] Looping through all possible combinations of two ranges
  183. Find Text and Extract
  184. How to restrict user from using old versions of excel
  185. "Compile error: Method or data member not found" assistance
  186. Need to compare two string columns based on similarities and return a value
  187. Data Validations and Indirect
  188. VBA to autofilter with Array
  189. How to protect workbook with force user to enable macro code
  190. [SOLVED] Data Validation formula issues
  191. Range in macro
  192. VBA scripting for PDF
  193. VBA novice needing help!!
  194. Please help me. Import data from a scripted web page
  195. [SOLVED] Formatting issue when putting data into charts
  196. Copy worksheet to another workbook
  197. round formula vba
  198. VBA range.value and looping issues with selecting a range of cells
  199. Move to next column in a loop
  200. [SOLVED] autorun marcos if condition is met
  201. IF(AND statement works - changing to an IF( and IF(OR causes a False - also is there
  202. [SOLVED] Delete the Value in Sheet 2 that does not exist in Sheet 1
  203. Mean of a MOVING Range
  204. Filter pivot item by date - type mismatch
  205. HELP Excel VBA Easy Code Popup MISSING!!!
  206. Formula Using A Variable in File & Pah
  207. Autopopulating columns until one column reaches a certain value, then stopping
  208. Searching for Multiple Values using Match and Index
  209. Default Insert Hyperlink by VBA input box
  210. Add New Column & Formula & Bold Indicated Value after Last Column
  211. Reset Input Sheet
  212. Find value in another sheet and get cell value in same row
  213. QR Code creation
  214. [SOLVED] Pasting columns to the next blank columns
  215. Stop calculating a column once the date has passed
  216. VBA to ZIP and password protect individual folder in the path.
  217. Hi I need to amend this code
  218. [SOLVED] Needed help in running the macro very urgent
  219. Application.FileDialog(msoFileDialogFolderPicker) with Network Folder Path
  220. Numeric value mysteriously appearing in the VBA editor immediate window.
  221. Create csv files for rows corresponding to each ID in excel using VBA
  222. Problem sorting each table in workbook
  223. [SOLVED] IF statment looking at 2 different cells
  224. VBA macro help
  225. Unlimited Sub ()
  226. Looping through folder with excel files, extract specific cells values to master file
  227. How to Application.FileDialog(msoFileDialogFolderPicker) for https:// Sharepoint file
  228. VBA Code Help with Command Button
  229. Loop record macro though all worksheets
  230. Excel VB Attachment available or not and Email sending Log
  231. MATCHING CODE
  232. Excel macro to Automatically generate the data and save file
  233. MACRO to Copy all Sheets from Folder
  234. need macro to update Master Calendar file copying data from numerous identical files.
  235. copy data from .csv file to other excel files
  236. [SOLVED] Need to highlight the entire rows once duplicate values found in two separate columns
  237. [SOLVED] Help with an Excel VBA Script (Excel 2010)
  238. [SOLVED] Add words to a list in column A relative to a list of selected names in column B
  239. [SOLVED] Runtime error
  240. [SOLVED] Macro to subtotal A2 until blank cell - cany anyone please help?
  241. [SOLVED] Macro to copy cell without leaving cell
  242. Find numbers whose sum is a number given
  243. [SOLVED] Speed up Macro
  244. Max characters allowed on status bar?
  245. Move files with path as argument
  246. Copy and Export to CSV of Pivot Table output results
  247. Export to file with different extensions
  248. Variable declaration
  249. Random with critaria
  250. Copying and sorting rows from multiple tabs to another tab