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]

  1. [SOLVED] VBA progress bar help
  2. VBA Code will not update as target cell is updated using a formula
  3. Excel 2007 VBA: Having trouble ungrouping a newly loaded object
  4. [SOLVED] Display count of months in year which has 31 days in Message Box
  5. Move files from different folders to single folder and delete the original files
  6. vba help - to make sumifs formula dynamic
  7. [SOLVED] Loop through UserForm Controls and perform Different actions depending on ...
  8. Link organs in an array to shapes as they are created
  9. Target cell vs specific cell
  10. [SOLVED] ComboBox Function Lost
  11. [SOLVED] Userform textbox skipped in tab order after re-enabling - unwanted behaviour
  12. Userform problem : makes excel crash
  13. Need to modify "BeforeSave" vba code
  14. Searching for Macro
  15. Arrays in VBA errors
  16. Listbox and name manager comparison
  17. How to a reference to a new sheet in same workbook
  18. Sum function in other sheet
  19. Maximum Limit for MMULT()
  20. [SOLVED] Sorting one Column in a Table
  21. [SOLVED] RE: VBA auto filter Iterate through each criteria
  22. Hilbert Curve VBA
  23. [SOLVED] VBA error: Run time error "424":Object require(pull data from HTML Element)
  24. fixing show message when open workbook from dialog to copy data
  25. [SOLVED] if cell value in range = "code" then copy paste value to last used row another sheet
  26. Finding Keywords from Text String - Formula
  27. CommandButton1_automatically update the date in ("A") column
  28. Insert new row for breakdown detail data
  29. Put NA on cells with dates before indicated start week
  30. text in cell in condition
  31. [SOLVED] How to copy the most current file from one folder to another
  32. Need help to Code VBA using the combination of text and date format
  33. Hundreds of sheets, trying to loop through and extract specific columns
  34. find replace
  35. [SOLVED] Value from UserForm to Worksheet - Accounting format - (How to?)
  36. VBA - Count # of cells in Column B that are greater in value than in Column A
  37. Last update field formula on Google sheet
  38. Calendar to bring the Leave Type from Leave Data to Calendar
  39. Total dummy when it comes to VBA, so hoping someone can help!
  40. Filter based on two columns
  41. [SOLVED] adjusting code search files into folder and sub folder
  42. [SOLVED] VBA - hiding column based on value of cell
  43. Excel VBA problem on application.inputbox that returns range
  44. [SOLVED] How to remove rows based on filters?
  45. [SOLVED] Calculating between 2 worksheets
  46. Copying a Value to an Addess Reference which is Nested in Another Cell
  47. Convert a formula to UDF Function
  48. [SOLVED] Stacked Chart Percentages
  49. Change all Workbook Connection Strings
  50. Assigning a value to the specified cells?
  51. Perform action with dynamic ActiveX button
  52. [SOLVED] transferring a column from sheet to sheet with the help of button
  53. Single & Double-Click a Shape Object
  54. Transfer the values from one sheet to another by adding them to below of previous row
  55. Search in Excel specific word, delete all rows who does not have that word
  56. Excel VBA to create a series of new pivot tables
  57. Compare two sets of data with multiple conditions
  58. Looking to condense data with quantity totals
  59. VBA Code to pull data dynamically from multiple sheet tabs
  60. How to subtract number of hours from 24 hour timezone in alphanumeric format
  61. create uninterrupted sequences of 2,3,4,5,6,7,8. from 01 to 25 goal.
  62. Does Excel 2007 SP3 work without issue on Windows 10?
  63. Validata Lists using offset, match and counta formulas - Different Sheets
  64. [SOLVED] Return to Cell in Column A after entering value in Column Z
  65. VBA to arrange response value in large database
  66. Text Wrapping - Stuck for a solution
  67. Count number of users active each mont
  68. VBA - Opening File with Yesterday's Date
  69. Roster Automation
  70. Put NA on week dates IN RANGE
  71. Transpose 1 Column to Multiple Rows/Columns
  72. [SOLVED] VBA -Identify blank fields for user form before submitting -Force User to add data
  73. VB on Time
  74. Duplicating Multiple sheets to all workbooks in folder
  75. VBA Copy paste Images from one cell to another cell on a different sheet
  76. [SOLVED] Find column header
  77. [SOLVED] Changing numbers with scientific notation (E+) in pivot table created by VBA
  78. OLAP pivot table vba filtering using VisibleItemsList
  79. Copy data range to a new workbook
  80. Adding a sum total to a Ron de Bruin VBA to email workbooks
  81. [SOLVED] Formula assistance required.
  82. [SOLVED] VBA to Find Maximum Value in a Range
  83. [SOLVED] Dynamic Array not Resizing
  84. [SOLVED] 3 columns matched create report
  85. Combine specific sheets from multiple workbooks into 1 workbook.
  86. [SOLVED] copying images from one folder and pasting in another based on schedule in excel file
  87. VBA Help
  88. User Form error
  89. [SOLVED] Anomaly With Formula
  90. [SOLVED] Object Required Error when Selecting Range
  91. Index Match to Determine Paste Location
  92. Advice needed to speed up Painting code based on defined colors.
  93. Automatically Printing Autofilters / loop through all filter values then print vba
  94. Convert Excel range into HTML table
  95. Excel pivot fields recognition issue
  96. How do I link a cell to 2 non-bold cells and 1 bold cell and keep that formatting?
  97. [SOLVED] sum data based on dates from sheet to another
  98. [SOLVED] Using Application.Run
  99. Copying vales with their number format from Excel into a word table
  100. Insert Multiple Picture into excel thru vba
  101. Dynamic dropdownlist from productlist
  102. [SOLVED] Help to amend vba to highlight any cells where file paths do not exists
  103. Worksheet object onClickEvent with changing cells issue
  104. Refresh item data in IRibbon combo box
  105. vlookup from Last Modified File in Folder
  106. Assistance needed for converting formula in Array VBA.
  107. transfer if there are no blank cells
  108. XML Map Export and Save
  109. Folder and cell value
  110. Error checking on existing roster
  111. [SOLVED] Highlight minimum value ignoring 0
  112. Loop Vlookup for each cell in range from another worksheet
  113. Updating VBA code to Paste Values only
  114. [SOLVED] loop through range inserting sum formulas based on start and end indicators (text)
  115. If Checkbox is checked, display message... If checkbox is unchecked, do nothing
  116. 'Cascading' comboboxes
  117. create a cubic grid shell in VBA
  118. Pivot Table Copy Paste 5 Days in a Row
  119. Convert Text to cells Sentences by Punctuation Marks
  120. Adding and Activating Reference
  121. packing list serial number generator for boxes
  122. Concatenate Values
  123. Update image/replace image from excel to PowerPoint
  124. 2007 VBA: Trying to rename individual shapes within a duplicated group.
  125. 2007: Issue with graphics shifting when saving to a PDF.
  126. Help with Debugging Code
  127. open file with vba
  128. [SOLVED] 2007 Formula: Trying to locate a numeric value in a square named range.
  129. Export to PDF (specific sheets) if cells in Input sheet are >0, if condition is met
  130. [SOLVED] Count number of occurrences via combobox in user form
  131. Excel VBA with Advanced Filter Error messages
  132. help needed to calculate dates and time together
  133. Create New Folder Based on Cell Name and Copy Files into it
  134. Macro or form based solution for attached excel sheet
  135. Help to check string of file name, if meet will copy valu to master workbook
  136. Workbook open event not working
  137. Macro wont run on duplicate columns
  138. [SOLVED] AutoFilter Percent Values +-5%
  139. [SOLVED] Sequentially Number Search Using an Array
  140. Intellisense working Sporadically
  141. [SOLVED] Use dropdown to populate other cells
  142. Vlookup to delete entire row on another worksheet
  143. random selection from a growing range
  144. [SOLVED] VBA Coding Help for Conditional Formatting
  145. [SOLVED] Fuzzy Lookup add-in VBA
  146. [SOLVED] Looping through Dates to Determine in Date Falls Between Other Dates
  147. If statement help
  148. Search for Strings Listed in Column A and Insert Offset values in B
  149. Finding IDs
  150. Is there any way to create a macro to keep doing nonlinear regressions?
  151. Auto populate table from another worksheet
  152. Multiple find and replace in Excell sheets
  153. Syntax To QuickSort A Range Of Numbers In An Array
  154. [SOLVED] Copy, Rename and validate multiple excel files
  155. 2007 VBA: Cannot figure out recursion to show all possible paths in a 4 x 4 grid.
  156. Run macro run by itself
  157. Basic question - create and fill X new rows based on instances of character in cell
  158. Excel VBA data transfer between workbooks
  159. Importing Multiple .Txt Files Into Excel Based on the Date Last Modified in VBA
  160. Counting the number of times a string appears on a filtered worksheet.
  161. Creating identifying numbers
  162. Importing text file into Excel but worksheet names are too long!
  163. [SOLVED] IF condition is not working with formula
  164. [SOLVED] Make code more efficient
  165. Exiting Command Prompt window from Excel
  166. Create a new folder based on cell and copy list of file into created folder
  167. fixing error code get folder names and files names
  168. VBS for Check the zide and move files
  169. "Run-time error '1004' with .xlt file
  170. [SOLVED] Date Not Filtering Correctly
  171. Run-time error 1004: The extract range has a missing or invalid field name
  172. Open specific worksheet and hide all other worksheet
  173. [Question] Dynamic amount of averages
  174. Extracting data from excel VBA
  175. Filtering a DefinedName that a ComboBox pulls from within a VBA Form
  176. Add-In Buttons Delete When Excel Closes
  177. SaveAs2 fileformat/encoding not working ???
  178. Help about sorting rows and assigning a new field automatically?
  179. VBA code to copy data from Excel by rows to multiple text files
  180. Highlights Rows when there is specific data in cell & Latest Balance Get Auto Color
  181. [SOLVED] RE: copy paste entire pivot data Using VBA
  182. [SOLVED] Excel formula syntax
  183. (Question) Make Subtotal ignore ="" Cells
  184. Easy! Need some help, Delete Line from txt file
  185. Change String
  186. Find & Replace - All worksheets except one and with different Target column
  187. Filter Listbox value marching with Combobox value
  188. Auto-expand text rows in protected worksheet - can I do it?
  189. Looking to make this macro Faster
  190. [SOLVED] SUMPRODUCT HELP?
  191. [SOLVED] Need assistance copying Cells that just contain certain data
  192. Excel VBA Multiple loops
  193. Disable or deactivate "Clear All" & "Clear Formats" from tools bar
  194. [SOLVED] Copy, Find Match in another worksheet, and then Paste Range
  195. Call shortcut only in specific column
  196. Run time error 438
  197. [SOLVED] Locate a set value and copy the value in the cell that's below it
  198. Code to loop through ws only works on active sheet
  199. [SOLVED] User forms - Alternatives to Me.Field = "Value"
  200. VBA help for sales report
  201. Use Macro on Teams/Sharepoint/Onedrive
  202. [SOLVED] Userform search is not working after delete any record
  203. Making a dynamic list.
  204. VBA Help - Code for Report Updates
  205. Populate in listbox
  206. Vlookup not working when Table array refers to a cell with variable
  207. Scroll Bar (Form Control) Offset Table - Sync Scroll Bar Pos. Across Multiple Sheets
  208. Could use some VB help with dealing with combo box data from a Union All query
  209. Last save time
  210. Like Operator
  211. Filter/paste rows by months in the near future
  212. [SOLVED] Need VBA Help With the following info
  213. [SOLVED] Convert Excel Cell Text in Bold or Italic to HTML Tags/Convert Cell Line Breaks
  214. Upper Case
  215. VBA conks out on very simple code
  216. [SOLVED] VBA Index Match across two worksheets
  217. [SOLVED] Help: fill the certain range based on cell value
  218. VBA help on pulling data from an external workbook
  219. Use a master list to run a macro that opens, extracts, and closes multiple workbooks
  220. Expand VBA code to search Column & Paste Cells to Other Sheet
  221. Type Mismatch error when there is no type mismatch
  222. How to create a macro that puts today's date and time in cell
  223. VBA Disbale Copy&Paste in target range (not complete sheet/workbook)
  224. Drag tool to adjust formulas correctly
  225. How to fix a messed Excel sheet and make a proper format?
  226. Extract and move records , then delete from master sheet
  227. VBA help - Function for checking and opening a workbook
  228. VBA Macros 438 runtime error
  229. VBA Sum Array Formulas
  230. [SOLVED] Custom Sort On Column
  231. Xlsm file problem
  232. VBA Time Stamp for single cell entry
  233. VBA code to open workbooks in a folder, create new sheet, paste headers and formulas?
  234. Change alignment
  235. [SOLVED] Object Required Error in UnHiding rows
  236. [SOLVED] VBA code to calculate dates from an event
  237. Macro to find best way to combine numbers to equal a certain sum