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

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