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:] TRANSACTION RATE NOT SHOWING
  2. [SOLVED:] Function to Pass Workbook and Worksheet objects giving Type Mismatch Error 13
  3. Need Help Highliting Some String in Cell and Columns With Macro!
  4. Copy & Append Paste from various workbooks into one master
  5. Password to save worksheet as new workbook
  6. Excel 2016 VBA on MAC to Open A File
  7. [SOLVED:] Code only copies certain column.
  8. [SOLVED:] Add extra worksheet
  9. [SOLVED:] VBA Help - Run-time error '-2147417848 (80010108)': Method 'Value' of object 'Range'
  10. Copy Rows with Certain Values
  11. fastest way to copy multiple range to multiple sheets
  12. [SOLVED:] Loop thru validation list - filter multi sheets - generate individual files
  13. [SOLVED:] Count based on two criteria from different columns
  14. [SOLVED:] File Format and Extension Don’t Match
  15. help with vba code
  16. [SOLVED:] Splitting large range of data into multiple cost center outputs in txt-format
  17. date Macro
  18. [SOLVED:] VBA to Limit what Columns a User can View--Question about Security
  19. VBA-Import text file of yesterday's date which is the file name
  20. Why will macro will move pdfs and xlsxs but not msgs?
  21. Need Help Creating a Macro
  22. lookup between different worksheet.
  23. [SOLVED:] Extract dates from a cell containing a string of data
  24. [SOLVED:] Fill in a row until bottom of the table
  25. Help needed for layout display after calculation.
  26. [SOLVED:] Cell is equal to another cell until you write something in it
  27. [SOLVED:] SharePoint and SaveCopyAs method
  28. Read all Excel files in a folder and edit them via UI
  29. [SOLVED:] Hide rows with option buttons
  30. regexp to find multiple instances of the same structure term?
  31. Nested classes with dynamic array
  32. Export to CSV with New Name and Time Stamp
  33. [SOLVED:] How to know form Option button name or number
  34. [SOLVED:] Macro help - matching times to periods
  35. Transpose using VBA
  36. Swap last and first word in a sentence in an excel column
  37. [SOLVED:] Merge Workbooks into one - Help in Folder Picker
  38. A function that crashes: Compile Error: Procedure too large
  39. VBA to open excel-sheets, updating link, saving and closing
  40. [SOLVED:] Hide rows when check box selected
  41. Hi. Need to copy/cut rows from sheet to another at top of dataset
  42. Problem with Charts
  43. UP/DOWN/INSERT/DELETE macros part of line
  44. [SOLVED:] Move Duplicates to Result Sheet
  45. Extracting data from json api
  46. [SOLVED:] Hyperlink formulas in VBA code - one is working and one is not
  47. VBA - conditional copying different column ranges
  48. How to move data from one variable to another
  49. Can you lock one filter in a pivot table?
  50. Help with VBA Macro
  51. [SOLVED:] Help : Compare texts in two columns in the same row and get the similarity percentage
  52. [SOLVED:] create sheets based on extensions files and copy to each months
  53. Update a new sheet from Userform
  54. VBA - seet 1 cell value (H2) to copy paste in activecell column c sheet 2
  55. Import Second Excel file
  56. [SOLVED:] help for VBA conditional formating count on correct color
  57. Search for a file in folder and subfolders (mac version)
  58. [SOLVED:] search files across multiple sheets and open & highlight
  59. [SOLVED:] UCase Help
  60. delete blank cells in every row individually
  61. Axis Ticklables to ObjectThemeColor
  62. [SOLVED:] error 1004 - VBA Delete column
  63. Not Working : VBA : Create folder and access files from One Drive
  64. With PivotTable: Count consecutive days that meet a criteria
  65. [SOLVED:] Difficulty Changing Data with a Hyphen "-"
  66. vba for mac book pro
  67. Loop through column, range.copy to another sheet based on cell value
  68. [SOLVED:] Pivot Tables: error in 'Field.CurrentPage = NewCat'
  69. How to Handle Blank cell value in VBA
  70. [SOLVED:] editing VBA code
  71. How to read in server name, software name and version from a text file
  72. Help : Date Picker in VBA user form and view data from data entry wb
  73. Find the duplicate from one work book and remove the duplicates in another workbook
  74. Rows to hide and unhide based on two columns
  75. Find Specific Word from the cell by referring a list (VBA)
  76. [SOLVED:] Not Working : Worksheet_Change Event
  77. Excel VBA shift selected cells in various columns up/down for a specified number cell
  78. Import, Filter and Sort Multiple Columns
  79. Collecting Data From Multiple Users
  80. VBA and Excel Formula
  81. [SOLVED:] Trying to make specific cell contents bold
  82. [SOLVED:] Search column for specific value, then delete rows found, leaving the first instance
  83. [SOLVED:] Request help to find missing dates in a date range for the user
  84. [SOLVED:] Highlight Matching Text in different cells
  85. Office 365: Application.CommandBars("Workbook Tabs").ShowPopup issues
  86. [SOLVED:] VBA Text Comparisons Identifying Differences
  87. [SOLVED:] How to do sequencing number after rows duplicated
  88. [SOLVED:] Not Working : Opening an Excel workbook from SharePoint in edit mode from a user form
  89. Autofilter help needed - encountering Autofilter method of range class failed error
  90. [SOLVED:] Trying to allow a TextBox entry on UserForm store in variable
  91. Print sales transaction receipt error
  92. VBA Help with Multiple If conditions
  93. Excel 2019: Range.Find(Number) Trouble
  94. [SOLVED:] Superscript in a Function
  95. [SOLVED:] Formula to collect charges
  96. [SOLVED:] Comma separated list from columns
  97. VBA help to stop one code from affecting another
  98. [SOLVED:] Searching for multiple texts within a cell (InStr)
  99. product csv from sheets
  100. VBA Command
  101. [SOLVED:] Change format of ConvertDegrees function
  102. [SOLVED:] Not Working : Sum of Hours
  103. Create a loop in VBA to copy data out of different files
  104. [SOLVED:] Slow Calculation of Sum Row
  105. [SOLVED:] Calculate the SUM from One Place to Another
  106. [SOLVED:] convert cells in worksheet to values
  107. [SOLVED:] Vba Array Shuffle Giving an Error and Lost Datas!
  108. VBA Code/Macro for Extracting data from Sheet 1 to Sheet 2
  109. Help required to extract data from rows to column in Excel2013
  110. [SOLVED:] Not Working : Load data from excel in user form and update / delete
  111. Compare with two column and return value or highlight match word(s)
  112. Combination data types
  113. [SOLVED:] Format date within formula in VBA
  114. How to apply VBA formula to stop row height from readjusting ? (Excel File)
  115. VBA Application.Run for Running Macros-with-Parameters Stored Inside an Excel Cell
  116. Keeps overwriting my output
  117. [SOLVED:] Userform with calendar month code to bold 2 inputbox result day label value
  118. [SOLVED:] pushbutton and countif/deletes
  119. [SOLVED:] Simple read file macro in Excel VBA on Mac OS X
  120. [SOLVED:] Syntax error - can't see why!
  121. [SOLVED:] ClearContents of merged cells?
  122. Concatenate in VBA?
  123. CREATE WORKBOOKS FROM TEMPLATE WORKSHEET AND TABLE OF DATA
  124. Help : take out numbers from a string after a specific word till next space or comma
  125. Office 365 - Using ComboBox / Text Box & Lists from Dynamic Tables
  126. Excel VBA - causing issues
  127. [SOLVED:] Cannot get two subs to run together
  128. Remove duplicated rows with VBA
  129. [SOLVED:] Need Help Creating a Macro
  130. Office 365 - Select Dynamic Sheet Names in Array
  131. [SOLVED:] Office 365 - Remove All Tables, ListBox & Macros from a Dynamic Range of Worksheets
  132. Sensitivity Analysis
  133. Statistical confidence plot in Excel
  134. [SOLVED:] Protect Workbook (Lock Certain Cells) and still have VBA run on unlocked cells??
  135. [SLEEPER:] VB Editor Menu Keyboard Shortcut Assignments Change with Macro / Code …
  136. VBA Formula for Splitting Property Address to Multiple Columns
  137. [SOLVED:] Select Sheets Starting with "XXXX" and Remove Macro from Sheet
  138. Copy some data from one Sheet to another and create a list
  139. Click IE Popup window
  140. [SOLVED:] VBA “folder” sorter
  141. how can i create userform using simpson rule for a function in excel vba
  142. How to get the number of instances of a class
  143. [SOLVED:] Exel crash when VBA frames manipulation
  144. Import XML to worksheet with mapped schema
  145. [SOLVED:] Change sheet tab color automatically based on cell values
  146. Sumif with integer and from another sheet
  147. Copying and pasting values into a table below the previous entry for many days
  148. [SOLVED:] copy data with pushbutton
  149. Find Form Controls with Value not set
  150. Auto Update Excel Data
  151. Help VBA CODE to include negatives in the loop calculation
  152. [SOLVED:] Count Dates in a List of dates for every employee for every month
  153. Selection Change where a merged cell is involved
  154. Close and save changes in one workbook from another.
  155. delete folders on search
  156. [SOLVED:] VBA to Delete Duplicate Info on Same Date
  157. Worksheet_Change multiple ranges and different formulas
  158. VBA to merge multiple workbooks with demarcation
  159. VBA Macro Causing Excel to Freeze When 2nd Copy of Sheet Added to Workbook
  160. show and hide photos with formula
  161. Matching the data.
  162. Copying sheets and updating values from a main sheet
  163. [SOLVED:] Cannot control the popup window
  164. Macro to Look for Specific text in other workbook and report value in cell beneath it
  165. Conditionally Filter chart categories according to the x-axis labels
  166. [SOLVED:] Close All Instances Of Excel Without Saving Any Changes
  167. [SOLVED:] Need help fixing/understanding Macro
  168. Vba : copy Transpose in 2 differents rows
  169. Efficient Way of Copying Data from an Input Sheet to a Database
  170. Shift pattern conversion
  171. [SOLVED:] Shared Workbooks with Hidden Tabs
  172. listview background color
  173. [SOLVED:] Counting the occurrence of each entry in a column
  174. [SOLVED:] Excel cannot access 'ExcelVB'
  175. Script not Running
  176. Need Help Finding Specific Cells and Determining if there are values in it or not
  177. Merge Workbooks based on Number of Row of Data
  178. Vba if iserror issue with vlookup
  179. EXCEL VBA - Dependent FORM Drop Downs & Excel Tables
  180. [SOLVED:] Date Increasing
  181. [SOLVED:] To Copy and Split the Name to First and Surname from Another Workbook
  182. Excel Formula : =MIN(IF)
  183. VBA Bold Text
  184. what's going wrong with the code
  185. What's wrong with this code?
  186. Automate a Pivot Using VBA
  187. vba help - Count only Alphabets from a string using Regular expression
  188. How to close it
  189. RE: SAP scripts VBS loop - Help required
  190. To automatically create a variable number of worksheets, name them and the enter the
  191. VBA: ActiveSheet started spitting out 1004 out of nowhere
  192. VBA Excel - Conditional Formatting in Table based on group
  193. Concatenate with ";" if values of 3 columns are same
  194. Conditional If in VBA
  195. [SOLVED:] Export to single PDF from matrix of range and sheets
  196. [SOLVED:] Help : Highlight the row basis of a cell selection and restore on selectin change
  197. [SOLVED:] Range("R1C1") gives error
  198. Extract data from automatic pivot table
  199. [SOLVED:] VBA Code for IndexMatch Function not working without error
  200. [SOLVED:] ORDER OF PDF MERGING - PLEASE HELP
  201. Sleeper: How to dynamically add data into a new column to the right
  202. VBA how do you change the thickess of a line using AddLine
  203. [SOLVED:] VBA Loop Control Variable Issue / Question
  204. [SOLVED:] Add between 10% to 20% random to numbers in cloumn F
  205. [SOLVED:] Date -Time not populating correctly
  206. [SOLVED:] Help Required : Random Sampling of Data
  207. Paste Excel Range into Powerpoint
  208. Display succeeding column data while skipping blank cells
  209. [SOLVED:] Multiple errors in VBA trying to get HTML elements by Class & Tag
  210. VBA Code to Disable Insert Header & Footer on Ribbon
  211. Removing Specific Fill Colors
  212. HinstancePtr vs Hwnd?
  213. [SOLVED:] Take subheading and move to front of each row
  214. How to Declare Object Variable with Direct Memory Access?
  215. Help to filter list
  216. [SOLVED:] VBA To Insert A new Row with Specific formatting
  217. [SOLVED:] Macro removes editing options selected when re-protecting worksheet after macro runs
  218. Using SumIF with Cell.Interior.ColorIndex on another WorkSheet
  219. assistance from experts to fixing theses codes
  220. [SOLVED:] Save Worksheet Tabs as Seperate PDF Files to Folder
  221. One PDF with Print Page Order - A variation
  222. [SOLVED:] VBA to Print the Comments of a single cell
  223. variable = worksheet (=>expected identifier)
  224. VBA to loop through sheets in workbooks in a file directory and add missing columns
  225. VBA Clipboard Statement
  226. Using Excel to send e-mails through IBM Notes
  227. Printing multiple workbooks into pdf
  228. VBA Add slide to the end of the presentation
  229. Print a sequence of sheets
  230. ODBC Refresh Connection String Error in VBA / Run Time Error 1004
  231. Exporting from Word Textboxes to Excel
  232. Tracking equipment run times with multiple starts/stops
  233. Remember selected cells in other worksheet
  234. [SOLVED:] VBA to use Selection.Address in a formula
  235. HIDE COLUMN BASE ON CELL VALUE OF ZERO AND 1
  236. extract OLE image from access to file by running sql adobd from vba excel
  237. for loop in vba
  238. VBA to Hide and Show rows based on multiple ranges provided
  239. checking for duplicates when creating macro to move data into master sheet
  240. Can't output values to cell
  241. Move csv file to new folder
  242. Drop down multi select while also changing what is shown in the cell
  243. VBA to Extract digit and text from two different columns of excel
  244. How to get mainserver ping response on userform
  245. InsertVBComponent not working
  246. [SOLVED:] VBA - Formatting Height of two Merged rows
  247. [SOLVED:] Cumuative Sum
  248. Help with loop and MID function
  249. VBA for multiple files with date - maximum values
  250. Casting Couch