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

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