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