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
  1. [SOLVED:] Extract files in a folder containing contents in column A and move them to own folder
  2. Copy the last category and insert custom text
  3. [SOLVED:] Change destination folder
  4. How to use uppercase in an additional column?
  5. [SOLVED:] How to convert Index(match.. (Left(Right...)..)..) into VBA (excel)
  6. [SOLVED:] Filling array bas on vba formula
  7. [SOLVED:] Else statement in loop
  8. CommandButton Back Colour is not set on WorkBook Open
  9. [SOLVED:] Help with Find and replace code
  10. [SOLVED:] Userform command button does not respond when calling userform from custom ribbon
  11. [SOLVED:] SQL query using where with multiple criterias
  12. How to post predefined cell value to active cell
  13. [SOLVED:] Make BackUps of files Using Excel List
  14. Excel Help -
  15. Refer to Excel collections in VBA with a "variable" name?
  16. VBA Assistance needed - lookup, match and copy command
  17. Module to Calculate from Two Tables
  18. VBA to Search More than One Worksheet in a Workbook
  19. Daily Dose Of Excel
  20. "Can't find project or library" error
  21. Macro to compare sheetname from one workbook with another and take actions depending
  22. [SOLVED:] VBA Sort Data Descending Order in two tables
  23. Text file import texttocolumns vs querytable.add
  24. Trying to find a way to find matching values, their row number and update whole rows
  25. [SOLVED:] VBA macro for print out
  26. I want to copy a value from a previous sheet, every day.
  27. One Macro for Copy/Paste, Formula, Colouring and Hyperlinking for at home
  28. group by column
  29. [SOLVED:] VBA Loop through column, copy specific cells, and stop when i meets a red cell? HELP
  30. ActiveSheet.Pictures.Paste runtime error
  31. Getopenfilename - File dialog hidden
  32. Important security change by Microsoft
  33. [SOLVED:] Converter Function
  34. Value out row based on a cell value
  35. How to Structure Conditional Statement for an Array
  36. [SOLVED:] Merging Error
  37. [SOLVED:] Sending and receiving ASCII commands in excel
  38. How to replace specific formulas by values and then generate several xlsx/pdf filenam
  39. [VBA - UserForm] Change "Status" cells in all duplicated rows at the same time
  40. vba partial names variables
  41. [SOLVED:] Filter month based on file name contains months
  42. VBA code to delete and replace this month's data
  43. Declare function no longer works
  44. [SOLVED:] Vlookup across Workbook
  45. [SOLVED:] Overflow Error Trying to Calculate Percentages
  46. [SOLVED:] VBA comparison with ActiveCell.Offset
  47. Hello, I have tree macros and I want to link two of them: 1. The first one( Report m
  48. Looking to paste without changing the format of the cells pasted into
  49. [SOLVED:] Fiscal Date year changes automatically
  50. How to use VBA for multiple rows? Now I have code for 1 row.
  51. [SOLVED:] tooltip macro
  52. Tricky situation in excel (
  53. [SOLVED:] How to save a macro excel?
  54. [SOLVED:] Intercept an splwow64.exe error
  55. [SOLVED:] How To Change VBA Copy Rows "X" Number of Times
  56. My script opens a large workbook - too slow - any fixes?
  57. [SOLVED:] VBA: Find the position of occurrence of text in sentence
  58. Using VBA to copy data to new sheet and find data from other sheets
  59. vba add worksheet checkboxes
  60. [SOLVED:] VLOOKUP Error : Need a VBA to copy matching row cell data in sheet1 from sheet2
  61. [SOLVED:] No Intellisense for "Sheets" Object in Excel VBA?
  62. [SOLVED:] Using a function with part of an array
  63. [SOLVED:] Excel VBA if condition then copy other cells to another worksheet
  64. Linear Interpolation
  65. Add/Remove pivot fields via macro- Help req to change existing code
  66. create treeview with 2 columns
  67. [SOLVED:] VBA: If number found in column B:C in excel sheet reduce numbers by -1
  68. [SOLVED:] Highlight Pay Dates on Userform Calendar
  69. Cannot use that command on overlapping selections- delete row code
  70. [SOLVED:] VBA Find string and add hyperlink
  71. [SOLVED:] Truncate number to two decimal places without rounding
  72. Take several screenshots one after another of a table
  73. [SOLVED:] Method value of object range failed.
  74. VBA: concatenate multiple cell data
  75. Copy column, copy list from another document and use that to replace multiple values
  76. insert only the first 4 images from folder
  77. [SOLVED:] vba combobox list on Userform has blanks
  78. [SOLVED:] ListBox mirror TextBox and Copy to Excel Table
  79. Workbook & Worksheet referencing
  80. Running Total SUM Based on Criteria
  81. Force switch the language to ENG
  82. [SOLVED:] Delete duplicate value for same date and other look up value.
  83. [SOLVED:] VBA function with 3 arguments in 3 cells to the left of entered cell
  84. Loping through each worksheet with an exception
  85. [SOLVED:] Excel 365 - Forms Control
  86. [SOLVED:] Compile Error Object Required (Excel VBA)
  87. Copy certain columns of data from 2 worksheets that are auto-filtered to 1 summary wo
  88. [SOLVED:] EXCEL export creating double quotes
  89. Copy rows according to value of cells selected according to the value of other cells
  90. VBA Code to Track Changes in Excel Sheet
  91. How to return to the original active cell?
  92. Copy true number in another column
  93. [SOLVED:] Multiplier (VBA)
  94. VBA Code for Next Business Day
  95. Coding help for a complete VBA Beginner
  96. Conditional Formatting (Macro)
  97. [SOLVED:] Autofill NOT COPYING formula
  98. [SOLVED:] Merge two tables into one - VBA help?
  99. Count successful create blank row
  100. VBA code to switch system language to English
  101. [SOLVED:] apply distinct formulas to autocomplete different columns in a specific table
  102. Combine Multiple Csv Files Into one Worksheets with file name as header
  103. Faster way to delete rows based on criteria?
  104. [SOLVED:] Copy Insert Row At Start End Or Middle with different Columns same row range
  105. [SOLVED:] Showing numbers in 1000's, but not rounded
  106. Code for IF statement referencing two more sheets and color formatting
  107. [SOLVED:] For each sheet in between two sheets criteria - VBA
  108. How to Sort Excel File (2013) with 4 or 5 Keys in VBA
  109. [SOLVED:] Userform: Combining 2 values into 1 record
  110. Add worksheet change event to all sheets during runtime_new
  111. Ticked check boxes that create a new list - VBA?
  112. Macro creating Comma separated Key
  113. [SOLVED:] excel not multiplying correctly
  114. Infinite FOR EACH loop when second application opened
  115. multiple pivot tables to a worksheet using Excel
  116. [SOLVED:] Transpose group of numbers from a column with guided logic by a second column
  117. [SOLVED:] Unable to Run Macro for Excel Sheet to Format
  118. [SOLVED:] Question: Clear Data within Range VBA
  119. Connection to DB2 DAtabase
  120. [SOLVED:] Not Working: Code to Clear ActiveX Check Boxes
  121. [SOLVED:] Adding seven days to a specific date, but it must always be the following Monday
  122. VBA for Excel Kanban tool
  123. Issue: When selecting a ActiveX Checkbox my screen flickers.
  124. [SOLVED:] Highlight row if two matches are found
  125. [SOLVED:] Convert a formula
  126. How to recall a VBA function in Power Pivot Model?
  127. [SOLVED:] Macro Debug Help
  128. Insert data at the end of page or last
  129. [SOLVED:] VBA Help - Match x and y axis, and pull data
  130. [SOLVED:] Merge variable text
  131. Identify combined and individual user codes and divide them in seperate cells - VBA
  132. [SOLVED:] Data Consolidation with VBA
  133. [SOLVED:] Creating a Message Box in Excel VBA
  134. copy cells from all sheets to one main sheet
  135. [SOLVED:] Error in finding last row with data
  136. Use VBA to PDF Multiple other files from Excel
  137. VBA code does not perform any action
  138. [SOLVED:] Sum values in 1D arrays on different sheets - new sheets added annually
  139. [SOLVED:] VBA to modify another VBA
  140. [SOLVED:] getopenfilename path in listbox?
  141. Data consolidation from multiple PDFs to excel
  142. [SOLVED:] Find Empty Cell in Range From Bottom Up
  143. Excel to Word - Remove Pages where bookmarks are not used
  144. Populating Content Controls in Word document from Excel workbook (same names)
  145. [SOLVED:] Autofilter and create new workbook loop
  146. VLOOKUP with VBA to loop and paste multiple images in result table
  147. [SOLVED:] Add table from pdf to excel macro
  148. [SOLVED:] UserForm.Show method not supported? Created UserForm using code
  149. [SOLVED:] VBA Runtime Error 9 - Trying to copy same sheet from multiple workbooks
  150. [SOLVED:] VBA to set Azure label
  151. [SOLVED:] 2016 Excel VBA Code for Locking a Cell after Data Entry
  152. [SOLVED:] How To Save, Rename, and Send Multiple Sheets, As Separate Attachments In Outlook
  153. VBA Combine PNG/JPG to an animated Gif
  154. [SOLVED:] Loop through All worksheets and change to Proper case
  155. [SOLVED:] Sorting sections within large table
  156. [SOLVED:] loop sum
  157. Sleeper: VBA function "sub not defined"
  158. Problem with Application.OnTime
  159. Need help with TAT calculation
  160. Need help with NETWORKDAYS.INTL()
  161. sum columns form each sheets to one column in Main sheet
  162. [SOLVED:] Transposing a vertical table into a horizontal table
  163. How to use part of filename without changing the filename
  164. SLOW VBA (20+ minutes) with many loops and VLOOKUPS. Help please.
  165. [SOLVED:] Finding a specific file across several subfolders?
  166. Comparing Two Workbooks Error
  167. a macro to Copy from multiple sheets to a new workbook without macro
  168. Having a daily data entry sheet that autopopulates into a pivot table.
  169. [SOLVED:] VBA find&replace with conditions
  170. Add two arrays A and B with dimensions n×m.
  171. [SOLVED:] Insert a function to delete any words with less than 3 characters in a VBA code
  172. [SOLVED:] dependent dropdown list
  173. [SOLVED:] Need code to copy data from closed workbook
  174. [SOLVED:] Loop through inserting row from one sheet to another, at least 2 loops needed?
  175. [SOLVED:] Geometric Brownian Motion Help
  176. Counting repetitions of string of words to counting group of words in one cell
  177. Macro to consolidate data from different files in a folder
  178. Deleting duplicate values from two different columns
  179. Loop on Single cell
  180. [SOLVED:] record # if data in other columns in same row
  181. Hello friends. Please help ! COUNTIF formula ?
  182. Help! What is wrong? My code is not looping!
  183. [SOLVED:] Need help with text to column like formulas
  184. VBA: What can cause of truncation of significant digits double precision variable?
  185. Object required error in dictionary
  186. VBA Macro: Text Split by defined # of characters - word dropping issue
  187. [SOLVED:] VBA to Update Excel Workbook Properties
  188. Selecting Sheets based on a VBA array
  189. [SOLVED:] message appears in adjacent column when name appears in column A
  190. How can I change the default chart callout color? - text & border?
  191. [SOLVED:] VBA help to move all images from a cell, not folder?
  192. [SOLVED:] RE: Excel Formula to update Account number based on signage using mapping key
  193. RE: Insert/Embed outlook mail using vba Excel
  194. Sleeper: How can I automate arranging cell values by repeating and transposing values
  195. [SOLVED:] Creating date and time stamp
  196. Discrete Time Conversion Problem
  197. [SOLVED:] Adding odd numbers in VBA
  198. [SOLVED:] VBA - Concatenate columns with delimiter
  199. Finding last cell in a column
  200. [SOLVED:] VBA - Copy Paste data to another sheet based on criteria
  201. [SOLVED:] Sum entire column by like IDs
  202. [SOLVED:] BUILD A SET OF DATA BASED ON SOME FILTERS
  203. [SOLVED:] VBA how to use date to write file name in PDF
  204. Setting a Dynamic Table Range in a VBA
  205. VBA - Copy and Paste Data Base into an existing Sheet
  206. [SOLVED:] clear last line
  207. Simplifying Code
  208. VBA to make 1st column of a text to columns operation "CLEAN"
  209. MoveLast ERROR
  210. [SOLVED:] clear last but one line to a userform
  211. Import image from path in adjacent cell
  212. VBA Code to copy data from two sheet ,paste into corresponding sheet
  213. [SOLVED:] Filter function to pull results based on drop down non VBA solution
  214. VBA - Convert data table into a long list (multiple columns)
  215. [SOLVED:] VBA - Clean up a table with returning values
  216. Extending the data range of a scatter chart by dragging.
  217. [SOLVED:] Please Help! Code For Option Buttons in Excel VBA User Form
  218. EXCEL VBA VLookUp
  219. [SOLVED:] Application.Caller return value
  220. General VBA Inquiry
  221. [SOLVED:] Adding VBA Conditional Formatting
  222. [SOLVED:] Please Help! Code For Multiple Checkbox Returning to One cell in Excel VBA User Form
  223. Macro that updates values in a function
  224. [SOLVED:] userform indirect alternative
  225. VBA error
  226. [SOLVED:] Copy Heading number in condition
  227. VBA script works when stepped through, but not when run in realtime
  228. [SOLVED:] Merging TXT files in a current worksheet using VBA
  229. Excel on Android
  230. Connection to cloud based SQL Server database using VBA
  231. [SOLVED:] ComboBox display incorrect text
  232. Excel VBA and arrays
  233. [SOLVED:] Sending emails with attachments
  234. using application.getopenfilename keeps opening new app
  235. [SOLVED:] Lookup Values from List and Copy data unde headings VBA
  236. [SOLVED:] Writing trig equations in Excel
  237. List Box, runtime error
  238. Please help me to update array between 2 sheets
  239. Making Program work with different number formats
  240. Find Text Within A Row, Then Copy Information Below That Cell To Second Worksheet
  241. [SOLVED:] Dependant dropdown error
  242. [SOLVED:] How to maintain a consolidated checklist for preparing dashboard
  243. [SOLVED:] IIF function in Excel 365
  244. Join two pieces of code
  245. I'm trying to perform two validations on a range of cells at the same time
  246. [SOLVED:] VBA Autofilter Loop
  247. [SOLVED:] Adding Conditional Formatting using AND
  248. [SOLVED:] Macro to split data based on the value from specific column
  249. Nasty spreadsheet
  250. [SOLVED:] Variable look up fields based on Value from different cell.