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. Strings and Variables
  2. [SOLVED] Test Pivot Table
  3. VBA Pivot Table creation looks different than manual creation
  4. [SOLVED] Function working within Sub but not in spreadsheet
  5. [SOLVED] List box looses Blue 'highlight' when changing forecolor
  6. Generate Shapes, Align, Group, Cut and Paste
  7. Macro to find and replace based on different text within one cell
  8. Web query Looping from table selection
  9. [SOLVED] UserForm that Stays Visible on Screen When Scrolling
  10. Compare data from two workbooks
  11. [SOLVED] How to check if value starts with text
  12. [SOLVED] ListBox_Click event fires without clicking
  13. excel help
  14. Macro to copy values from one sheet to another based on specific conditions
  15. Reference specific text strings despite being repeated elsewhere?
  16. [SOLVED] Macro to delete all rows between two different text stings in column A
  17. Problem with copying the text format.
  18. How to execute a VBA program and halting another VBA code till the old program ends
  19. [SOLVED] Very omplicated calculation of hours worked (PLEASE HELP)
  20. Redim Preserve Change LBOUND
  21. How to insert a formula in a dynamic range using VBA
  22. [SOLVED] VBA - Change code to work on whole workbook
  23. [SOLVED] Difficulty using KeyPress Command
  24. need a vba code HELLLLLPPPPPP
  25. How to generate Sum formula in excel
  26. Populating a Cell with a Table
  27. [SOLVED] Type Mismatch Error Confusion
  28. Checkbox make values to textbox
  29. save and close an excel sheet when I press the Windows + L buttons
  30. Problem between macro event and SpinButton
  31. Unable to get pivottable property of class
  32. Saving Screenshots in excel
  33. Select number of rows based cell value
  34. VBA VLOOKUP
  35. macro prompt?
  36. [SOLVED] Run-time error '445' - Object doesn't support this activity
  37. VBA Macro Help - Extract from Multiple Closed Workbooks
  38. Import particular data from book1 to book2
  39. Help with text file row count - only want the last 13 rows
  40. [SOLVED] Sum Up Cells Value When Specific Value Match
  41. Userform with changeable headers/ listboxes to opt for creating reports from Excel DB
  42. Selective listing of files in a folder
  43. copy filtered data into different worksheet
  44. [SOLVED] Load data from TXT to Excel sheet (numbers with decimal get like text)
  45. Macro Help - Pasting
  46. vba code To Save Copy As Cell.Value
  47. [SOLVED] Find average of all values between two index match values in table
  48. Need help with my code as it doesnt seem to be appearing
  49. Avoid duplication in copying
  50. Combobox from external database, not working
  51. invalid or unqualified reference
  52. Color Code Data According by Categories
  53. Using a barcode scanner with Excel
  54. filter multiple columns simultaneously using Vbscript
  55. [SOLVED] Accessing Excel Tab data from Button
  56. A variable SUM formula in excel
  57. Excel 2013 Macros Click-Activated Shapes
  58. Writing to a cell in a loop
  59. Help with the meaning of this code
  60. Macro to remove marker line and border
  61. How to find and use the maximum value in VBA code
  62. [SOLVED] Can I use an excel sheet to calculate in a vba program?
  63. Convert Table to Calendar (Wincalendar functionality)
  64. Creating a form to filter data?
  65. VBA EXCEL : HELP ON FIND/REPLACE
  66. Checking Excel background image with VBA
  67. NEW TO VBA...Need Help..driving me nuts
  68. Excel formula help
  69. course analysis from bitcoins with VBA
  70. Advice needed to speed this code.
  71. I need to count the amount of weeks a piece of text has appeared since last change
  72. Hyperlink to specific sheets in workbook based on drop down selection
  73. Macro to pull outlook info based on excel values
  74. Join Error
  75. [SOLVED] How to export variable from textbox into a cell after clicking on a button?
  76. VBA excel help
  77. merge worksheets
  78. How can I refresh a webpage in VBA before downloading it?
  79. Need to copy from all sheets from all workbooks
  80. VBA code to copy / paste values only + auto change cell value
  81. Runtime 1004 error
  82. Save As Help
  83. [SOLVED] How to extract date range into multiple rows?
  84. Why is the default value of UserInterfaceOnly False?
  85. Macro To Add DSN
  86. Procedure Too Large
  87. [SOLVED] vba or formula to find number of duplicates in a range
  88. Why is the sub or Function not defined for the following code
  89. [SOLVED] Help Needed! Macro to pull if cell does not equal criteria
  90. VBA matching, data manipulation across different worksheets
  91. [SOLVED] Filter and copy to WorkSheet help
  92. New VBA Code
  93. [SOLVED] Applying a multiplication by macro on a column
  94. [SOLVED] Problem using keyPress command
  95. Populate vlookup formula 1Million item
  96. Auto updating of worksheets in an Excel Workbook
  97. Last entry in a Column
  98. Percentage covered by values using VBA
  99. [SOLVED] Pivot Table Grand Total
  100. VBA Current region minus header and last column
  101. [SOLVED] Creating Sheets from Cell Value IF Only!
  102. [SOLVED] vba to loop through multiple worksheets and paste specific data based on a date
  103. A day longer than 24 hours
  104. [SOLVED] Can this Conditional Formatting Code be simplified
  105. Creating indivisual diaries from master rota
  106. Hyperlink from a cell in another sheet. Not quite working for me.
  107. [SOLVED] Macro for copy/paste values for only that row where the change is made
  108. VBA macro to hide rows based on cell value
  109. VBA to Find & Fill a cell based on row & column headers?
  110. IE WEBSITE FILE UPLOAD
  111. VBC Excel to find latest creation date zip within folder, then open CSV file embedded
  112. Auto Data Display by Scanning. Please help
  113. [SOLVED] Using Userform with Date Picker to Select Data Range in Excel
  114. Lable the last know person to entra data to a cell from a list of names, populate dat
  115. [SOLVED] Easy If-Than code for comparison of multiple values doesn't return correct value
  116. Textfile loop to find/replace characters
  117. Save as Types
  118. Pivot find and replace
  119. [SOLVED] Types inside a Type
  120. Spreadsheet Consolidation based on specific path
  121. [SOLVED] Help needed with VBA to auto insert pic into comment
  122. Remove string in text files
  123. [SOLVED] Clear multi - select Listbox
  124. [SOLVED] match delete vba
  125. VBA - Auto Select Sheet, Save & Close after 1 hour
  126. [SOLVED] Vba find and replace with loop
  127. [SOLVED] Excel Loop WITH Function
  128. [SOLVED] Preserve exact formula, monthly analysis for full year
  129. VBA to Search both Email subject and/or Email Body in Outlook
  130. Intermittent errors after running macro varying number of times
  131. Macro wont work with a cell which is updateing by formular
  132. vba help
  133. VBA wont run unless through the editor
  134. [SOLVED] Error when using variable when connecting to SQL from Excel
  135. hide rows based on highlighted cell in column
  136. Copy and Paste based on cell value
  137. ODBC connection if not on users PC
  138. Is it possible at all?
  139. Using Range.Find to search another Open Workbook
  140. [SOLVED] What is wrong with my VBA code?
  141. Several If statements inside For Loop
  142. Embedded HTML Image Issues
  143. Combining parts of 3 workbooks
  144. [SOLVED] If range contans "0", mark as incomplete
  145. Values lookup in two different tables
  146. [SOLVED] Empty Row Deletion
  147. VBA to Add 3 Aligned Footers with Custom Formatting and Text
  148. Order Assignment Problem
  149. Directing SendKeys to the Correct Application
  150. Help -needed call named range based on cell value
  151. What Do You Think About This?
  152. [SOLVED] Excel Book Recommendations
  153. [SOLVED] Clear activex listbox selection
  154. [SOLVED] Goal Seek without Cell Reference
  155. Compares different rectangular areas and highlights equal values
  156. VBA
  157. [SOLVED] pulling data from a csv file based on specific dates
  158. VBA Cloudera Hadoop connection
  159. Merging PDFs and Allowing for Filling of Adobe Fields
  160. Help Understanding Code
  161. Different references for same formula (more complicated than it sounds)
  162. Put Excel image to PowerPoint in specific location?
  163. SUM of Values by Region and District
  164. Copy Multiple sheet as SaveAs
  165. MATCH VALUE FROM TAB2 and UPDATE TAB1-CONDITIONAL
  166. VBA: adjusting pivot table per macro
  167. VBA to collect data from Pivot
  168. [SOLVED] How to connect to a RECORDSET
  169. [SOLVED] Loop through URLs, save source
  170. Help with #Value! errors
  171. [SOLVED] How do I have a cell value displayed on my user form?
  172. [SOLVED] Apply different format to each column of selection
  173. Counting rows in clipboard
  174. [SOLVED] Loop through combinations and add only Even & Odd numbers together within each.
  175. Adjust placement of copy paste to suit last row of previous paste
  176. Count texts in two colums and if no match write data
  177. Count number of mondays
  178. (VBA) error adding Title and Subtitle to PowerPoint Slide
  179. Excel 2013 VBA Import Dynamic Range from other Workbook
  180. Setting a range object & applying table style
  181. [SOLVED] How to replace a path in the code by a variable?
  182. Excel Userform Listbox VBA Help
  183. Enabling Content in access db with Excel VBA
  184. [SOLVED] Excel 2013>VBA>Function>Sum Visible Columns
  185. VBA code to prompt user to select file folder but still keep the file name...
  186. excel 2016 splitting datasets creating new separate sheets
  187. [SOLVED] Generate 5/50 lottery combination with selected odd sum or by even sum!!
  188. Macro for copy & paste data from worksheets if path of file changes
  189. [SOLVED] Assigning values from a table
  190. Display Data from Sheet
  191. [SOLVED] VBA Loop - If Cell is not empty then....
  192. HELP!!! Fastest code in consolidating columns with different headers
  193. Conditional Formatting not pasting correctly with macro
  194. [SOLVED] Excel 2013>VBA>Function>Average Visible Cells Horizontally
  195. Using Vlookup to set ranges for Loop, not sure how to integrate it.
  196. [SOLVED] Do While Method to append data
  197. Generate 3 sets combinations, which 3 sets sum match: to request target sum
  198. [SOLVED] Copy complete folder to another folder
  199. [SOLVED] Trying to name ranges over a number of columns
  200. [SOLVED] Excel 2013>VBA>PageSetup>User Defined Formula>Interference
  201. [SOLVED] Trying to get a range of cells to show up in my Combo Box
  202. Run-time Error '1004' - Method 'Open' of object 'Workbooks' failed
  203. [SOLVED] Using wildcards to filter list - help
  204. [SOLVED] Saving filename exists
  205. VLOOKUP formula with subtotals
  206. [SOLVED] Excel Margins
  207. Lotus Notes - VBA
  208. [SOLVED] File copy wont copy to the right folder.
  209. VBA to trigger input box when criteria in data found
  210. Help with Data in Column A and Shift...
  211. [SOLVED] Move files & folders from one location to another from excel
  212. [SOLVED] Check if activecell is in a column with date in the header in any table
  213. [SOLVED] Copy data from excel and paste it in to a word template at different places
  214. [SOLVED] Schedule code to run at a set time and then at intervals thereafter
  215. Skip first sheet in For Each loop?
  216. VBA -- Call Function Not Running Macros Properly
  217. Help With Recursive Formula
  218. VBA Find and Replace from Excel Range
  219. 90% there - Maybe paste as picture instead to esure cond format?
  220. [SOLVED] Create list of files in a folder and link to them in Excel
  221. Microsoft Dynamics AX
  222. ComboBox lag
  223. [SOLVED] Currentregion and autofilter Help
  224. HELP!!! Need a VBA code to get a table from a site
  225. [SOLVED] Date Problem showing as 42463 ?
  226. [SOLVED] Require total in column B of positive & negative values
  227. Excel Search Function
  228. [SOLVED] VBA loop to do multiple cut, transpose pastes within a loop, then repeat.
  229. [SOLVED] Dynamically Copy and Paste
  230. month end variance analysis
  231. Filter A Range And Chart It
  232. [SOLVED] VBA Array Function - Return Array from Range without Blanks
  233. [SOLVED] VBA - Filename Checker?
  234. [SOLVED] Need some very basic help
  235. Search and copy macro with search criteria
  236. Need macro that creates new rows and copies matching info from sheet 1 to Sheet 2
  237. [SOLVED] Need to change code in bottom line
  238. [SOLVED] Excel/Word/Access
  239. [SOLVED] VBA filter
  240. [SOLVED] Aligning two tables
  241. [SOLVED] Insert row & total other columns
  242. if unique of column A b c then count ifs
  243. Help with excel and word. Sounds easy, but its not.
  244. Runtime error 13 : Excel vba pivot - please help
  245. Formula getting a cell's data from another worksheet.
  246. [SOLVED] VBA Code Required
  247. Using VBA to Copy Multiple Workbook Filenames into their Workbooks
  248. [SOLVED] Displaying numbers in fractions, not decimal (when concatenating)
  249. using array to add 1 hour to column A
  250. [SOLVED] Delete filter outcome