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. Custom XLAM ribbon question
  2. Accessing Hidden Sheets Via Hyperlink
  3. Every time i run the macro it has different values, need help please
  4. Last saved issue
  5. [SOLVED:] How to write VBA code to auto insert the last row occupied into Master Sheet
  6. [SOLVED:] Write an IF statement relating to 2 different worksheets
  7. Copy function from workbook to another in VBA
  8. [SOLVED:] Ctrl-C selection in memory - how work with it by VBA Excel code?
  9. Date Variable Showing 12:00:00 AM, Why?
  10. [SOLVED:] Combining Static Series and Dynamic Series in a Dynamic Chart Issues
  11. [SOLVED:] Unwanted selection change
  12. Can you customise the results from comparing two worksheets?
  13. If-statement with relative values
  14. Sleeper: Adding a certain number of cells between sets of data based on a comparison
  15. Help with copy paste code
  16. Convert from Text to Columns Doesn't Work if Source is Modified
  17. Values are not copying over as entered on one sheet to another.
  18. Identifying file type in excel
  19. [SOLVED:] Excel coordinate projection - distance and bearing
  20. VBA to copy url from excel sheet and open in webpage and copy source to notepad
  21. [SOLVED:] Search for data highlighted in red return it and return the data in next two columns
  22. [SOLVED:] PivotTable.DrillDown and filtering the output
  23. insert six rows at specific points
  24. [SOLVED:] Autofilter latest event date
  25. [SOLVED:] Store special cells in one range
  26. [SOLVED:] code for copy and paste
  27. [SOLVED:] Re allocate Named Range addresses
  28. New to Macros - file naming issue
  29. Save active sheet only as pdf + Increment the invoice number + print active sheet
  30. Creating an xml file from each row in excel
  31. VBA Error - Missing 4 columns Data after copying
  32. [SOLVED:] When using open text file how to tell if the file existed, or a file was created?
  33. Adding comboboxes in a loop
  34. File folder to single spreadsheet
  35. Get the heights related data in row D
  36. [SOLVED:] Extract the formulas of each cell in range - VBA
  37. Populating PDF document with Excel vba
  38. Excel Function -Address
  39. [SOLVED:] Select from Cube Through VBA
  40. Customised spell check in VBA
  41. [SOLVED:] ActiveSheet.Previous.Select
  42. [SOLVED:] need help gettng macro to run faster! please!!!
  43. Combine Multiple Worksheets w/ Different Headers Into One Worksheet
  44. VBA: Match string and color substring
  45. [SOLVED:] VBA: Chart with Combobox
  46. Copy and combine files using VBA
  47. [SOLVED:] Unmerge cells across rows only not across columns
  48. [SOLVED:] Message in Every Cell
  49. VBA code for extracting report from Outlook Mails
  50. Adding functionality to an existing Excel Workbook (example pictures included)
  51. How Do I Filter In Excel Using TextBox?
  52. Compare values inside the range (sheet1) and copy the row to new sheet (sheet2)
  53. [SOLVED:] Summing of columns into specified cell loop
  54. Help in Pivot
  55. [SOLVED:] UserForm VLOOKUP to get Data and Change one Column
  56. [SLEEPER:] pivot table - sort items with different order for each parent item
  57. Auto Save excel file to another Computer on the network
  58. [SOLVED:] Help with updating formula's with VBA
  59. [SOLVED:] loading a variant array
  60. [SOLVED:] Help with code on language translation file
  61. [SOLVED:] Adding a Scroll Option to The Text Boc Functionality
  62. [SOLVED:] Need VBA to arrange data Cell adress data please!!
  63. [SOLVED:] Macro to Set Page to Print in Particular Range & Adding a Company Logo
  64. data transfer
  65. Formatting, Highlighting Travel Times Conflicts
  66. Need VBA to create inputbox for multiple values & filter multiple columns
  67. [SOLVED:] Text Size Issues in Text Box
  68. Macro to copy excel recordset and insert in to Database based on a condition
  69. [SOLVED:] Rename text file with new name
  70. Userform- Populating Dependent List Help
  71. [SOLVED:] Progress Bar for macro
  72. VBA - SAP 'Save As' dialogue box
  73. [SOLVED:] VBA to fill up website form and upload file path via “Browse” buttton
  74. Macro to Copy certain WS's based on Key to a New WB and email
  75. Code suggestions required.
  76. Significance Testing Macro
  77. [SOLVED:] Loop through column data and delete or copy based on value given
  78. Labor Tracking / Time Tracking
  79. [SOLVED:] Project Planner Not Working
  80. [SOLVED:] How to export and save each worksheet as new workbook in Excel?
  81. Help with pulling names from online database
  82. [SOLVED:] IF, AND, OR Nesting - Part of it not working
  83. [SOLVED:] MACRO: SaveAs Cell Value File Name (Pull Two Cells within Worksheet as File Name)
  84. [SOLVED:] Module Level Variable Loses Value
  85. [SOLVED:] Sort by row based on column value
  86. [SOLVED:] How do I set passwords and how to save as a certain name for a file
  87. File size reduction
  88. [SOLVED:] Alternatives to MINIFS (Minimum IF's)
  89. Required Email generated with signature and attachments
  90. VBA Macro to copy multiple charts from one excel file to a word bookmark locations
  91. Import data from different files and sheets into file with corresponding data cells
  92. [SOLVED:] Array limits?
  93. Open all CSV files in folder, and merge to one master file.
  94. [SOLVED:] Copy range to blank cell
  95. [SOLVED:] Remove symbol
  96. [SOLVED:] Extract part of a line and paste in another cell
  97. [SOLVED:] Create 2 Dimensional Array from "For" Loop
  98. Find out row and column range
  99. Vba Compile Error :(
  100. Get (some of) Excel Clipboard contents via Windows clipboard "XML Spreadsheet" format
  101. [SOLVED:] Angles between 2 lines
  102. [SOLVED:] Modified a function that is called in another function, now getting runtime error?
  103. [SOLVED:] Save Outlook attachment into an Excel cell, as OLEObject in VBA
  104. [SOLVED:] Pull specific data based on If statements
  105. [SOLVED:] Handling Formula Errors & Formula Length Limit
  106. Subscript out of range
  107. VBA to update a table from another table
  108. Run macro on all files
  109. [SOLVED:] Split function in vba
  110. excel vba macro to apply filter multiple column using header names
  111. userform icon in taskbar problem in win10 office 2016 bit 32
  112. [SOLVED:] need macro added to current to automatically move to next row for next search and
  113. [SOLVED:] Need help with Question, is it possible to Call modules to work or loop through?
  114. [SOLVED:] Select working(Active) range with mouse
  115. vba adding image after clicking on the textbox
  116. [SOLVED:] VBA function to return MySQL Data
  117. Help with filter by date
  118. [SOLVED:] Break up column A content between column A and B
  119. Find and Change Values
  120. [SOLVED:] Format Issue
  121. VBA code running too slow in Excel 2013
  122. [SOLVED:] VBA code attach an excel file to outlook with a variable file path
  123. Autofilter failed
  124. [SOLVED:] VBA Code assistance to separate a workbook into several different files.
  125. Function to update a cell in another worksheet giving #1004 error
  126. [SOLVED:] Running Macros from ComboBox with Items from a Range
  127. VBA: referencing cell in one worksheet and using it as range start for another sheet
  128. Reading and Writing to dat file via forms
  129. [SOLVED:] VBA code to cycle through sheets
  130. [SOLVED:] How to send email in excel using content in word as email body
  131. [SOLVED:] Take out space
  132. [SOLVED:] Convert to a number
  133. [SOLVED:] Copy and Move files to existing Sub-folders based on filename/Sub-folders's Name
  134. Change marker size for all series in a plot (VBA)
  135. VBA To Check That Value Appears In Single Cell Range Before Starting Macro
  136. Run-Time error "7" out of memory
  137. Compare two strings for similarity or highlight differences in Excel
  138. [SOLVED:] How to Send a HTML Email using Word Email Template using Excel Macro
  139. [SOLVED:] Simple for each loop problem
  140. Trying to copy a macro into another workbook
  141. Can you speed up my vba that copy and pastes the header amongst worksheets?
  142. [SOLVED:] Auto Save excel workbook every 5 minutes
  143. Subscript out of range
  144. [SOLVED:] Looping through ActiveX checkboxes and adding items to ActiveX List Box
  145. [SOLVED:] Highlighting a cell if there is a match with another cell
  146. [SOLVED:] Pivot Table Error with VBA Code
  147. VBA Use hidden cell to run IF Statement
  148. [SOLVED:] Populating colums based on cell value and conditions
  149. [SOLVED:] Two rankings
  150. Empty a Module within Excel 2016 …
  151. Disable Overtype / Insert Ability in VB Editor for Excel 2016 …
  152. Add Data Field in Pivot Table
  153. Export all the sheets in excel to images individually files
  154. [SOLVED:] vba help on vlookup
  155. [SOLVED:] Need help duplicating a row (if not already duplicated)
  156. [SOLVED:] VBA FILTER
  157. [SOLVED:] VBA VLOOKUP ON Historic trades
  158. Search string in two columns in different excel sheets and copy the matching data
  159. [SOLVED:] Procedure Too Large - Compile Error
  160. [SOLVED:] Sort/ transfer data
  161. USER-FORM FILTER DATA EDIT
  162. VBA Conditional Formating
  163. modifying function cohort/matrix of ratings migration
  164. [SLEEPER:] Vertical Column with possibility to filter
  165. [SOLVED:] vba Double for each Loop combining task
  166. VBA code for lookup table
  167. MSO File Picker Help
  168. [SOLVED:] #Name? error for TextJoin UDF
  169. VBA Macro - Use relative ranges to graph
  170. [SOLVED:] VBA code mysteriously timing out
  171. [SOLVED:] Searching with recursion
  172. [SOLVED:] Unzip files to a folder udf
  173. Move cells to another worksheet
  174. Macro to convert from Paste Bottom-Up to Top-Down?
  175. [SLEEPER:] VBA code in Cash Flow forecast
  176. [SOLVED:] Need help with Do While Loop or If this AND that then....
  177. [SOLVED:] Move File to Folder if filename matches foldername
  178. how to make CommandButton1.Rotation = 90 in office 2016
  179. Advance Filter using VBA
  180. Control strings
  181. adding selected rows into a sheet with a specific selection
  182. vba help to copy specific colulmn.. from a sheet
  183. If Formula not working as expected
  184. VBA getElementById doesn't work correctly
  185. Macro is not recording sheet protection password
  186. Change Sheet name
  187. [SOLVED:] Copy and Paste Macro help please
  188. [SOLVED:] Loop thru all sheets and copy a value
  189. Timer + Stop Watch
  190. RTF field in Excel by keeping formatting
  191. [SOLVED:] Can't call several subs in a macro
  192. Identify employees late login
  193. Sleeper: VBA If formula help
  194. [SOLVED:] Delete zeros
  195. Cell Value Confusion.
  196. [SOLVED:] Macro To copy and paste data from a list to corresponding worksheet and cells
  197. create and store pdf, attach to email and send, with loop
  198. Subscript out of range and SaveAs Method error
  199. Quote Generator - Advice
  200. [SOLVED:] sum of variable range stop working
  201. Trying to copy all sheets into one combined sheet
  202. VBA Help, to Pick first Column Data and its file name
  203. [SOLVED:] is it possible: If Me.Controls("CommandButton" & i).clicked
  204. [SOLVED:] Shorten loop using boolean
  205. Getting Problems in Making a Query from SharePoint
  206. VBA code to delete rows based on value
  207. [SOLVED:] FileSystem Object, Folder.Files.Count Does Not Match Files.Item Count
  208. [SOLVED:] For Loop does not seem to be working
  209. VBA Code to Run Other VBA Codes in Multiple Workbooks
  210. Dividing data records fairly into clients based on categories and amounts
  211. [SOLVED:] Monitoring Remote Workbook for Changes
  212. [SOLVED:] How to display a chart on a certain position (e.g. centre of screen).
  213. What are your favorite Excel VBA automation success stories?
  214. Vba code for partial transpose
  215. [SOLVED:] Help with formula please
  216. [SOLVED:] how can i save userform settings
  217. Parsing data to several sheets
  218. [SOLVED:] Countif using arrays
  219. [SOLVED:] IF then
  220. [SOLVED:] Blank cell
  221. [SOLVED:] VBA code to paste data to a row with today's date in column A in another sheet
  222. [SOLVED:] Insert Pics Macro Not Working on All Cells unless name manually typed in
  223. [SOLVED:] Selection not displayed when combobox item is selected
  224. [SOLVED:] VBA check if a specific value has been entered into range
  225. Subscript out of range and SaveAs Method error (Revised)
  226. Encrypt password for database access
  227. select radio buttons in IE
  228. Using RANK on a range of data - need an exception
  229. [SOLVED:] combine selected worksheet into one worksheet
  230. Cell locking macro not working
  231. Need code to merge PDF files in a folder using adobe acrobat
  232. A neat timesaver for Immediate ("debug") Window - abbreviations
  233. Rewriting Referenced Data for VBA Pivot Table
  234. [SOLVED:] VBA to operate on an external drive + files dispatching in folders
  235. Hide Worksheets dependant on domain name
  236. [SOLVED:] Coloring rows through value in column
  237. [SLEEPER:] VBA Function - Last Row
  238. [SOLVED:] Excel VBA to Transpose lists
  239. VBa code to transfer rows base on a sequential number
  240. Writing a macro to capture values on a spreadsheet and add them to totals on another
  241. Using checkboxes to copy rows from one sheet to another in the same relative order
  242. index match between 2 workbooks
  243. Macro to Convert Flat Data to Database - Amendment to existing code required
  244. [SOLVED:] One Row.Delete works, another doesn't
  245. [SOLVED:] Format data in Excel with subtotal
  246. Web scraping with complex chronological events
  247. [SOLVED:] Table transpose
  248. Compress four rows into one row
  249. VBA to stop pivot tables refreshing before power queries with autorefresh
  250. [SOLVED:] Filter On Date With Headers