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