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