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

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