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