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