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