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