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