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