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