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. Code for copy/paste from list to new sheets
  2. - Office 365 - ListBox MultiPage
  3. VBA code not executing and excel have to be shut down by endtask
  4. VBA SORT ORDER CRASHES EXCEL
  5. vb dynamic print data in worksheet based on selected from listbox
  6. Autofilling sequential numbers counting from inputted number in a userform
  7. VBA Help splitting data based on a ID #
  8. [SOLVED] Offset in a double nested loop.
  9. Copied Excel Macro to VBA code.
  10. How to combine hidden sheets using VBA
  11. VBA Do While Loop Question
  12. Dynamic Hyperlink VBA
  13. [SOLVED] Need to show and hide named ranges based on cell value
  14. [SOLVED] VBA - Pivot table and charts - Automation
  15. Match worksheet function in VBA searching on multiple criteria
  16. Looking for a VBA code/Macro to Export Pivot Data into a CSV File on click of button
  17. VBA Excel : Boolean loop to check last full column
  18. [SOLVED] VBA Excel: Ranges
  19. Excel VBA upload via SFTP
  20. Multi selection list
  21. How do I search a spread sheet for a time
  22. Excel Camera Tool
  23. [SOLVED] Clear Row contents based on color or cell value
  24. COUNTIFS in VBA with data on multiple sheets
  25. Loop through slicers in PivotTable/PivotChart and export to PowerPoint?
  26. Formatting question
  27. VBA Hierarchy
  28. How do i add a string in a column like "1 week" or "12 months" into cell with a date
  29. VBA in excel : making a Stock list
  30. Delete Image
  31. [SOLVED] Help on Moving file to another folder, using partial filename
  32. Looping through worksheets to sort
  33. Auto save workbook when locked cell is modified
  34. Need help (If Statement)
  35. Azure Connection via VB error
  36. fixing summing and subtracting among sheets in the same range
  37. programatically added controls do not show up
  38. Help me please! Basic Excel macro!
  39. SetFocus with Frames not Working
  40. vba, how to code to select cell after certain filter field
  41. [SOLVED] Excel VBA Userform Comboboxes not populating with external data range
  42. Copy Rows data to column
  43. [SOLVED] Replace table with Userform
  44. Getting script Error 9 Run time error while declaring variable of Sheet
  45. HELP! Cant figure out how to modify code based on new requirement
  46. Create an array removing duplicates from list but keeping last occurence
  47. [SOLVED] Calendar Times Not in Order
  48. [SOLVED] VBA entering a nested formula with text
  49. Replace non-contiguous column range with Offset column range in Chart SeriesCollectio
  50. Advice on 'OnTime'
  51. [SOLVED] Conditional Format Calendar Events
  52. VBA - Macro to open a file based on part of text in cell
  53. [SOLVED] Named Ranges Error - Please help!
  54. [SOLVED] Update Schedule Sheet with Jobs
  55. Cell back color
  56. [SOLVED] Copy Workbook Name
  57. [SOLVED] Error 13 - Mismatch in UserForm update Application.Match with mixed Data
  58. Keep a timestamped log when any worksheet is unprotected?
  59. Parse text to array
  60. Stop save if table has empty cells
  61. On time assistance required
  62. [SOLVED] Use the same Variable in the module
  63. Cell equal value new value of active cell which is a drop down
  64. Query
  65. Run macros on whole workbook
  66. VBA Code to highlight Odd and Even numbers
  67. populate combo box with conditions
  68. Creating a Search Concat for Sharepoint files
  69. Copy files from one Location to another
  70. VBA to move JPGs from sub-folders to destination folder using a list
  71. Consolidate Pivot Table Cache - VBA
  72. [SOLVED] Formatting issues
  73. Help automatically refreshing a year using VBA
  74. [SOLVED] Create new column
  75. Having troubles with XlFillDefault
  76. [SOLVED] Conditional expression
  77. from mastersheet to other sheets (find the last blank raw)
  78. Early vs. Late Binding
  79. VBA for inserting Rows with conditions
  80. [SOLVED] Advance filtering unique records
  81. [SOLVED] insert data for open positions
  82. VBA for New Format
  83. Customer Statement of Account
  84. [SOLVED] notification by vba
  85. [SOLVED] Need help copying cells from one sheet to another..
  86. [SOLVED] Combine countifs & Subtotal
  87. When changing the active worksheet - need VBA that will make it's chart display?
  88. [SOLVED] Moving data between two sheets VBA
  89. How to copy and insert shapes with increase in series of text inside of shape ie 1,2,
  90. copy and paste question
  91. How to get dates of all mondays between 2 dates?
  92. Copy & Paste to the next empy cell. (Vba Code not Working)
  93. [Beginner] Select and Cut with conditions
  94. [SOLVED] Macro Copy & Paste: Numeric to Alphanumeric
  95. Vba code on looping
  96. [SOLVED] VBA to select cell in active row
  97. vba find the latest date and a corresponding value
  98. Looping Through Two Columns
  99. [SOLVED] First Login Last Logout - Formula
  100. Coming to the dark Side
  101. For Each Then Next
  102. Run time error '1004' Cannot access 'Macroed-Upload_Temp.xlsx'
  103. Creating dynamic List on Workbook Startup
  104. VBA MACRO Button click using a class instead of ID
  105. Set Last Modified date & time to preset value on Save or Save As
  106. Macro to autofilter data from several sheets in workbook and copy to new worksheet
  107. VBA to add numbers in columns from various workbooks
  108. Copy to new workbook and remove blank rows
  109. code running on more than 1 sheet
  110. [SOLVED] Copy files by name from a folder to another
  111. [SOLVED] Creating a single Table with different formulas Excel VBA
  112. [SOLVED] Excel keeps calculating
  113. [SOLVED] Split Cell into multiple column via VBA
  114. Basic VBA Function to calculate the volume of a cone
  115. sumifs filtered data
  116. [SOLVED] Excel Formula to compare between actual values and target values
  117. Only the string
  118. [SOLVED] Formula to fill down used range
  119. [SOLVED] Part of a string
  120. [SOLVED] Putting a time limit on QueryTable.Refresh
  121. [SOLVED] Write part of 2D Array to Sheet
  122. [SOLVED] Data Validation based on Condition(s) in Excel VBA
  123. [SOLVED] Change font size of rows in a range with bold letters
  124. [SOLVED] index/match based on variable range
  125. Cut Data Once It Has Been Selected
  126. How to pull XML data into another excel sheet using VBA?
  127. Conditional Formatting using formula as condition
  128. Trim rows in multiple sheets
  129. Add Table to Data Model (Pivot Table)
  130. VBA script to search a text in google maps
  131. [SOLVED] Insert Picture from Directory on Cell Value Changed by Formula
  132. Split comma to rows
  133. After clicking the linked cell to move back linked cell without using F5+Enter
  134. Writing array to sheet
  135. [SOLVED] How to set currency with different starting values
  136. Text in textbox only updates once
  137. [SOLVED] Complete data of a master table without overwriting given data
  138. Hyperlink warning message
  139. 3 Reference Formulas Not Returning a Result
  140. [SOLVED] Hide textbox with selected item in combobox
  141. [SOLVED] concatenate variable values
  142. Building up sentence variable within cells
  143. VBA Pasting from table to different sheets without using sheets("x").Select HELP!!!
  144. Duplicate Values in Data Validation
  145. [SOLVED] Hide specific rows in various worksheets depending on Summary worksheet cell value
  146. [SOLVED] Find Last Value (not first)
  147. [SOLVED] select next emtpy column
  148. [SOLVED] Excel - Make user opened file the active workbook
  149. [SOLVED] Excel - Edit contents of a string
  150. VBA Help using value in sheet 1 to hide unhide row in sheet 2
  151. [SOLVED] Autofit last column in a table
  152. [SOLVED] Issue creating pivot table from table data
  153. PDF to excel
  154. [SOLVED] help to apply array formula in vba
  155. [SOLVED] update listbox
  156. [SOLVED] sum digits
  157. [SOLVED] find listbox column Average
  158. VBA Newbie looking for linear or polynomial fit to missing dats
  159. Importing multiple files to excel
  160. [SOLVED] PIVOT TABLE TROUBLES - Code runs on one workbook but not the other
  161. I need help on scrolling down web pages through vba query tables
  162. [SOLVED] Loop through listbox to insert to sheet
  163. [SOLVED] Get All Most Recent Dates per Month in a Single Column VBA
  164. Rename the add-in caption on menu bar
  165. User Form
  166. VBA to make formula for parent child
  167. [SOLVED] Ordering worksheet tabs in a specific order
  168. [SOLVED] Delete rows when copying table
  169. [SOLVED] VBA - Disable/ activate command button depending on Text box value
  170. [SOLVED] Conditional Formatting on a table based on a different table VBA
  171. Sorting Help
  172. Calendar with userform input stores irrelevant data to its table
  173. Graphical hiearchy
  174. Problem comparing dates in VBA
  175. [SOLVED] Delete worksheet activex listbox
  176. Using userforms
  177. VBA - Search For Value Across Multiple Worksheets
  178. Importing files will format data
  179. [SOLVED] simple password protection with User Form, with possibility user can change Passwort.
  180. [SOLVED] Progress Bar VBA
  181. Getting selected items in embedded listbox
  182. Macro works via step through but does not on button click
  183. Vba, How can code the excel file to save as only and disable to save directly file
  184. PDF Merger Sequence
  185. [SOLVED] Searchable listbox - Multi column - additem to second column only works first time
  186. [SOLVED] Changing Data Layout Excel VBA
  187. [SOLVED] loop and sum
  188. Return specific cell in that row using row number
  189. Creating a Pivot Table Based on Two Tables
  190. [SOLVED] error on Password User form by workbook Entry
  191. Workbook.SaveAs function, appends number to similar named files
  192. Simple If Statement: Comparing function argument
  193. Worksheet Change event not working unless cell is manually changed
  194. Save As function randomly replaces my file path, Error 1004
  195. Header/Footer sticking to other ranges
  196. Computing Monthly Weighted Average
  197. Applying VBA code written in module to all sheets in workbook
  198. [SOLVED] vba code for an interface
  199. Command button to go to another sheet with drop button click
  200. get Sunday's date between 2 dates
  201. export and print multipe specific sheets as pdf
  202. Making new EXCEL file with value only by copy from other excel
  203. How to Copy-Paste from a dynamic range to fixed one based on cell value using VBA?
  204. Gantt...mouse over
  205. Decipher Macro
  206. Excel chart links in office 2007
  207. HELP with Conditional VLOOKUP
  208. RC FORMULA HELP
  209. [SOLVED] Automatic Timestamp Insertion Application.Undo
  210. Save multiple ListBoxes to PDF
  211. [SOLVED] Change Excel's own user forms, is it possible?
  212. Improve Efficiency of VBA Code
  213. VBA Macro to add values by date
  214. Reading text files and assigning values
  215. [SOLVED] Invalid picture
  216. Generate Condition CSV File
  217. Revising A VBA Code
  218. Master file detail list
  219. Filter Specific data
  220. Import .txt File with normal Space Delimiters
  221. Replace kill command with save command and be able to format date
  222. Click Login button using VBA
  223. Chart legend entries delete reappear
  224. Macro Undo Command
  225. [SOLVED] COPY/PASTE SPECIFIC DATA INTO GROUPS ON NEW SHEET
  226. [SOLVED] Excel filter not working due to blank values in the column
  227. Data separation
  228. VBA multiple SQL queries
  229. copy and rename a folder and its contents based on a cell value.
  230. [SOLVED] VBA 2007: How to get object name when inserted in order to delete later
  231. Help with vba chart
  232. copy and paste value with condition
  233. [SOLVED] Excel 2007: Trying to change images' rotation after loading without selecting first
  234. [SOLVED] Clear all items in listbox column
  235. inputbox vs excel shift + space shortcut
  236. [SOLVED] Formulas: If(AND( , OR(NOT(COUNTIF now working correctly
  237. [SOLVED] Check if Value Exists in Another Sheet
  238. refreshing sheet "under" modally shown useform
  239. Use VBA code in a locked worksheet
  240. Copy specific data from a row based on value in column A
  241. Deleting Duplicates based on Active condition
  242. Getting Key value from last occurrence of another table
  243. Using Find function in VBA
  244. split counting
  245. Select last empty row with header
  246. AutoFill Only Specific Cells
  247. Need help with Objective Type questions (Quiz)
  248. Cant get VBA Code to work. Would appreciate help.
  249. copy paste the data if condition matches
  250. Set statement