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

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