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

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