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. VBA to stop pivot tables refreshing before power queries with autorefresh
  2. [SOLVED:] Filter On Date With Headers
  3. Error copying multiple worksheets using VBA
  4. [SOLVED:] Copy Paste to visible cells only with different sheets / workbooks
  5. Sending Email with Email body in a cell keeping the formatting.
  6. [SOLVED:] Query Table - Extract Data From Text File by Column - TextFileColumnDataTypes
  7. Pivot table help
  8. Web Vba issue
  9. [SOLVED:] Excel Slow performance
  10. Unable to click on button HTML
  11. Named Ranges.!
  12. [SLEEPER:] Import data from excel files with specific file name into another excel sheet
  13. [SOLVED:] Results of OptionButtons by GroupName
  14. [SOLVED:] VBA Help with Macro to autofit visible columns starting at row 4
  15. Exporting excel worksheet to word keeping exact formatting
  16. VBA - update entry in other workbook if ID matches
  17. Replace a text with a future data
  18. [SOLVED:] Using a Variable in a named range
  19. Simple EXcel Macro help
  20. [SOLVED:] In Automatic Calculation Mode, spreadsheet still does Manual Calculation??
  21. table and charts in full screen
  22. VBS Program Debug
  23. [SOLVED:] concatenate formula
  24. CX-Server CDMDDE Visual Basic Macro Errors
  25. VBA userform combobox and vlookup to fill another cells
  26. OCR Data extraction with VBA from Web site HELP!
  27. [SOLVED:] Code for pasting according to criteria
  28. Code to update a KPI based on a worksheet
  29. Compile Error: User-defined type not defined
  30. Convert to PDF, SaveAs, Attach to Outlook Email
  31. Disable New Excel Auto-save Feature(Not auto recovery)
  32. [SOLVED:] Matching a string with a partial string using match function
  33. Any ideas on how to improve this Userform
  34. [SOLVED:] Help on filtering an excel based Column C and send email for every filtered item
  35. [SOLVED:] Individual zoomfactor for each sheet
  36. Sort Text and Consolidate
  37. Handle Spelling Errors
  38. [SOLVED:] Help with Index Match function!
  39. Some VBA help please
  40. [SOLVED:] how can do this: if any userform closed(x) then mainform.show
  41. [SOLVED:] Userform output range
  42. Color chart caption with VBA
  43. ListBox dependent on 2 ComboBox (ComboBox1&2) selections
  44. Unique ID for new userform's entries
  45. application.windows object
  46. [SLEEPER:] How can i open external excel file by using button in userform
  47. Use Getopenfilename function to browse the file.
  48. Code for pasting as per criteria
  49. [SOLVED:] Please Help. trying to check for specific text in cell value :S
  50. VBA for color coding a cell based on values in other cells
  51. Macro for form control/LOCKED CHECKBOX FOR CERTAIN DOMAN USER
  52. [SOLVED:] Copy Paste Values from multiple workbooks to multiple sheets in one workbook
  53. Linked tables and Slicer in Excel
  54. Error Message: Cannot open file -- File Format/Extension Error -- Troubleshooting
  55. [SOLVED:] Display Print Dialog with "Selection" as Default
  56. [SOLVED:] Detecting Duplicate entries
  57. VBA code help (current code too slow and freezes)
  58. VBA Lookup?
  59. VBA To Combine A Combination of Values To Get One Target Value
  60. VBA: Copy Cell to another and remove last 2 characters
  61. [SOLVED:] SUMIFS with sum range dependent on another cell value
  62. [SOLVED:] If statement with non numeric cells
  63. [SOLVED:] VBA Code to open a folder when ctrl + right click is pressed
  64. [SOLVED:] Address SPLIT
  65. ExportedUI File to EXE File.
  66. Check if Attachments was added
  67. [SOLVED:] Delete row if cell is not a number
  68. How to set cookies using web browser userform
  69. Filtering Column with Multiple Criteria
  70. [SLEEPER:] Joint different set of data
  71. VBA - Macro has to run twice for it to work.
  72. Comparison for Reconciliation
  73. Compare a column of data on one ws to another ws and append non-match data
  74. Graphing on a MAC With VBA
  75. Public Variables in Object Modules
  76. [SOLVED:] Splitting data from one column into other 4 columns in excel
  77. Dynamic pivot table
  78. VBA Code to link to Oracle
  79. [SLEEPER:] Copy, paste and sum data from multiple worksheets to one worksheet
  80. vba for keeping first 4 characters and removing duplicates
  81. [SOLVED:] Help with paste special
  82. [SOLVED:] Populate ListBox from Multiple sheets
  83. Excel Threads in Windows
  84. code for copying from multiple files and paste in master file
  85. [SOLVED:] Move matching rows to existing sheets
  86. [SOLVED:] Format Shape menu appears after a printpreview.
  87. Allocation of Data - URGENT HELP
  88. VBA macro to set up dynamic print area
  89. [SOLVED:] Looking for help to identify matches across multiple columns
  90. VBA to copy range from one sheet to another.
  91. [SOLVED:] Time Conversion
  92. Generating an array, and using Vlookup to loop through this array (VBA)
  93. [SOLVED:] BeforeSave loops and workbook closes
  94. Method 'Copy' of object'_Worksheet' failed PROBLEM
  95. VBA Get a value from a cell and compare to multiple conditions ElseIf
  96. [SOLVED:] automatically consolidate data from different sheets to 1 combined sheet
  97. [SOLVED:] Create a Project Scheduler With Excel
  98. Sleeper: Converting Index Match function to VBA code
  99. Reverse INDEX and MATCH
  100. VBA Code to link spreadsheet data
  101. [SOLVED:] Condensing code - Using Arrays for Loops
  102. [SOLVED:] Adding new lines in multiple spreadsheets
  103. Find list of words occurred
  104. Attendance Spreadsheet - Custom point reduction
  105. VBA: Folder & File Lister
  106. [SOLVED:] Copy + Paste to Last Row based on Last Row of adjacent Column
  107. [SOLVED:] Copy column from one sheet to another then sort and remove multiple delimiters
  108. [SOLVED:] Help with limiting VBA range
  109. Copy whole frame content to worksheet
  110. Graph Data Labels - how to avoid line break
  111. [SOLVED:] Pivot Table grouping
  112. [SOLVED:] Linear interpolation
  113. Filter Value from Column and paste selection as value in another Sheet VBA
  114. Addition of cells as path
  115. [SOLVED:] Sorting Rows by certain columns using VBA (or not?)
  116. [SOLVED:] Change Textbox and Combobox Back Color
  117. VBA Code optimization- Speed up this Macro
  118. Dataset updates changing the pivot table
  119. Copy rows and column headings to new workbook based on cell value
  120. Create a list of unique values from multiple workbooks
  121. VBA pull first 4 digits until the bottom of the data
  122. [SOLVED:] Rearranging Words within a Cell
  123. [SOLVED:] generate random and unique value of cells
  124. [SOLVED:] VBA Lookup, how to return multiple columns?
  125. Referencing List, how can i find the closest match?
  126. from a formula to a macro
  127. [SLEEPER:] Copying & pasting data using file path
  128. VBA/Excel Workbook Help
  129. [SOLVED:] Clear cell after Worksheet_Change Analysis
  130. [SOLVED:] Help! edit multi-cells with conditions. Thank all of you!
  131. [SOLVED:] Index/Match with multiple criteria
  132. Excel VBA Listbox with additional item number column
  133. Restrict entry to textbox
  134. Coloring range of cells under colored cels
  135. Display Data from Two Sheets
  136. Re: Track Changes - Text and Formulas with user name and time stamp
  137. [SOLVED:] VBA for picking only one value from an SQL base
  138. HELP: VBA Listbox - highlight selected states of AU and display some basic info
  139. insert formula - Run-time error '1004' - Application defined or object-defined error
  140. [SOLVED:] Insert picture into image control
  141. CHOOSE with HLOOKUP
  142. Userform Listbox Filter using comboBox
  143. [SOLVED:] Set Columns Names in ListBoxes
  144. Search Matching Value
  145. Copy selective columns from one worksheet to another in the same workbook
  146. [SOLVED:] Median with a Condition on Text Selection that Differs Only by Ending Number
  147. VBA to insert SUMIFS formula with row number updated when inserted
  148. [SOLVED:] Assistance with bringing specific items from text file into Excel
  149. [SOLVED:] VBA for Excel: automated correction of wrong decimal separator
  150. Filter the microsoft date and time picker control output
  151. Search and replace
  152. Copy to new WorkSheet and name as specific dates
  153. VBA that allows sorting of data by user
  154. DropBox getting dropdown menu from filtered table
  155. [SOLVED:] Need VBA Help!
  156. how to move xls files in same named folders by vba
  157. Looping through code
  158. Need an advice for VLOOKUP function in VBA
  159. VBA Code required to see if workbook is opened or not.
  160. [SOLVED:] Email Range in Body of Email - Not pasting the data
  161. Macro captures scrap and submits it to another book. Please Help improve.
  162. [SOLVED:] Macro to update macro buttons
  163. Search for file name in all drives
  164. Use VBA to send XML API
  165. [SOLVED:] Form Control Listbox help
  166. [SOLVED:] Linear interpolation. retrieving the wrong data.
  167. VBA how to: Multi line text in cell to column
  168. Formula for counting most frequent values
  169. User form Help
  170. [SOLVED:] Need an advice for Insert new Row in other Sheet in VBA
  171. [SOLVED:] Combining multiple Named Ranges into one
  172. Macro breaking when any edits to sheet are made
  173. [SOLVED:] Using String variables within a formula in VBA
  174. Help create Macro remove multi-lines duplicate characters
  175. VBA: Copy and Past between different instances
  176. VBA to create-rename new sheets in a workbook and export them individually as CSV
  177. VBA please Support
  178. [SOLVED:] Date Series Fill
  179. Dynamic diagramm
  180. [SOLVED:] Best way to hide rows depending on cell value?
  181. [SOLVED:] About WorkSheet_Change Event VBA
  182. [SOLVED:] Detect the same value on cell and merge them
  183. the color of cells
  184. VLOOKUP to the left
  185. Merge Multiple Workbooks into One
  186. Project Explorer taking up full screen
  187. Application Error
  188. [SOLVED:] VBA Copy formula x times to the right based on value in cell
  189. Export to XML
  190. [SLEEPER:] Remove Duplicate VBA
  191. sub that creates two arrays month and dayslnMonth
  192. Sumproduct across ranges with varying sum values
  193. [SOLVED:] Need help with VBA conditional VLOOKUP on another file
  194. Run-time error 1004
  195. problem with data extraction with VBA from Web site
  196. Copying a section if item from a drop down list is selected
  197. VBA: Copy row to the last line of data
  198. [SOLVED:] Excel Userform Directory - search button using checkboxes
  199. [SOLVED:] Need an advice for searching function
  200. [SOLVED:] Edit new code to allow update of posiitional references to be edited by user.
  201. [SOLVED:] Finding the length of elements in a 2D array
  202. Help with creating duplicate sheets, combo box are linked together
  203. [SOLVED:] Need a help with loading data using class module (Derivative & Portfolio)
  204. Combo box Duplicates
  205. [SOLVED:] Array formula?
  206. VBA current cell value = another cell value if criteria met
  207. Error after RmDir !!
  208. [SOLVED:] Change Cell Value As Part Of Copy/Paste Operation
  209. Extract data from text file to Excel sheet
  210. add supplier & customer
  211. [SOLVED:] array filling with multiple unique names
  212. Toggle Button copy same toggle instructions
  213. [SOLVED:] the remove method in Collection and Select Case
  214. [SOLVED:] Change a range of cells based on value in specific cell using VBA code
  215. [SOLVED:] What determines the size of the userform other than screen resolution?
  216. [SOLVED:] Beginner help on creating excel visual tool through VBA
  217. Finding Duplicates in Two Columns
  218. Looping through columns to merge files into a PDF
  219. Combox Depending on others
  220. Sum? sumif? sumproduct?
  221. autogenrate id in userform
  222. Need to filter data and create new workbooks
  223. match supplier name in form with standard supplier name
  224. [SOLVED:] Using VBA to save a xlsm file (Excel 2013)
  225. Need some help with a macro
  226. [SOLVED:] Find and replace multiple values in Excel using VBA
  227. [SLEEPER:] Loop inside a function to retrieve data
  228. [SOLVED:] Run time error 13 Type mismatch
  229. Read multiple .txt files and copy specific text to excel
  230. Excel VBA to import txt file AND automatically insert rows
  231. problem with getelementsby...
  232. vba code not working
  233. VBA CODE showing result as #VALUE!
  234. [SLEEPER:] Excel formula
  235. Generate random number of strings that are stored in an array .
  236. [SOLVED:] -- (Double Unary)
  237. alternative to VLOOKUP for large range
  238. vba consolidation of specific sheets data and Pasting in specific Master sheets
  239. [SOLVED:] Chinese Encode in VBA
  240. [SOLVED:] Clearing a merged range of 4 columns and 2 rows
  241. Find Text String in Range then copy cell into another range
  242. Formula to check for embedded object and return a checkmark
  243. [SOLVED:] Create table for each name in specific column
  244. Storing row numbers
  245. Help with coding for labels
  246. [SOLVED:] Save Each Worksheet to Individual PDF
  247. Sort using part of cell value
  248. [SOLVED:] Multiple users
  249. [SOLVED:] Remove permanent comment from cell
  250. Migrated to Office 365 from Office 2016 - MACRO no longer functions