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

  1. Adapt code to move files to a subfolder of the same name
  2. Launch Website and log in
  3. [SOLVED] Automatically Hyperlink Text in a Cell, based on another Cell
  4. VBA for entering data into a webpage from excel 2010
  5. Any add-In available that can convert my excel sheet and word file to pdf
  6. [SOLVED] With...With end condition not working referencing a range
  7. [SOLVED] SPINBUTTON RIGHT TO LEFT
  8. [SOLVED] Loop macro - copy, paste, run macro
  9. Arrays 101
  10. split alt+enter values of a cells into multiple cells
  11. [SOLVED] Macro to highlight certain cells highlighting too much
  12. Problem linking two sheets
  13. [SOLVED] Split names with no space:
  14. From word file names to excel database
  15. [SOLVED] Having a date take effect at a specific time of day
  16. [SOLVED] Problem with split
  17. [SOLVED] Excel to Email with Attachment, based on different names & then folders
  18. Help With Mac VBA script SaveAs
  19. Coping with duplicates being created by code splitting worksheets into separate files
  20. Excel VBA Help: Checking String Values of Two Columns for Equality
  21. Accessing Web Service From Excel 2013 with Input Parameters
  22. [SOLVED] Array with month
  23. Add items from Comboxes to Listbox
  24. extract numbers
  25. Help with Error Handling
  26. Put Data From Excel 2010 Into Web Page Field
  27. Whats the best way to delete the lines i just copied and pasted over (code inside)
  28. [SOLVED] Click on Cell, Pop-up with input, put answers into a cell
  29. [SOLVED] Active X "Missing" error when others attempt to use file
  30. [SOLVED] Help me with syntax of the code...anyone?
  31. Financial Functions
  32. Set fs = Application.FileSearch within 2003 Macro no longer valid?
  33. Button to Search Subfolders for files
  34. [SOLVED] Shorten code
  35. [SOLVED] Drop down changes value of another drop down
  36. Smart Dropdown Search
  37. [SOLVED] Need help with simple syntax error
  38. Find 1st cell under header, and fill down vs adjacent column
  39. Creating and using an Excel VBA framework
  40. [SOLVED] VBA To convert Formula(s) to Value(s) to track serial numbers
  41. Microsoft Calendar Control 8.0
  42. [SOLVED] LABEL AND PLANNING SCHOOL MAP
  43. [SOLVED] Select a found file and open in explorer
  44. [SOLVED] Insert values before hiding column
  45. Disable Protect/Unprotect button on the ribbon
  46. VBA macro for running multiple macros in multiple worksheets in the same workbook!
  47. [SOLVED] How can I populate data from other sheets onto my main sheet, one below the other?
  48. VBA in MS Office 2016
  49. [SOLVED] Filter based on cell value
  50. Multiple combo box usage
  51. [SOLVED] picture in userform
  52. VBA Schedule help
  53. merge by vba
  54. Lookup text and insert value
  55. [SOLVED] Combining Duplicates
  56. Ranges
  57. [SOLVED] Macro to fill formula in reverse
  58. Working sync update code - need to add some help logging changes made
  59. VBA to filter data in a source file using data from another workbook then create new
  60. [SOLVED] Computing IRR & NPV with dynamic range
  61. [SOLVED] ADODB Connection Problem?
  62. Macro Help
  63. Adding a password to a worksheet converted to PDF
  64. VBA UerForm : Match and Vlookup multi value in combobox
  65. [SOLVED] VBA - Create button and his event in a classe
  66. [SOLVED] VBA or not? Absolute value question
  67. [SOLVED] Formula being replaced with result
  68. [SOLVED] Inserting multiple rows based on criteria and copy-paste new data
  69. How to import one sheet from Closed file to open sheet
  70. How to get a list of *runnable* macros
  71. VLookup from table 1 to appear in table 2
  72. LISTBOX : search by first letter
  73. [SOLVED] creating a macro to edit protected workbooks
  74. Database/List Manipulation
  75. Rookie: Working with Private Subs
  76. Error in Validation.Add - Application define or Object defined error" in Excel 2013
  77. HTML VBA Help: Cannot Press Search on a website through VBA
  78. Sheet to array
  79. Basic Help
  80. Casting a data field to number
  81. [SOLVED] VBA SUM() with pop-up window to select range
  82. copy and paste only certain rows macro
  83. Need help deleting rows based on cell criteria
  84. [SOLVED] help on merged cells...
  85. Time Line Chart
  86. [SOLVED] Need help naming a worksheet based off another worksheet in VBA
  87. Input boxes to change row each time
  88. Open new window within current
  89. validating textbox input upon TAB or ENTER
  90. [SOLVED] Upgrading from 2003 to 2013 and sharing workbook.
  91. FLIGHT OF USERFORM
  92. Help with multiple values for search
  93. Need to convert it to Word VBA
  94. Multiple IF's in "Insert function" bar
  95. [SOLVED] Listbox and Combobox Problem
  96. Split Pdf based on the sheets state Code by excel/Access vba
  97. Goal Seek function and Range
  98. Copy/Insert union of subranges into existing worksheet
  99. Using XMLHTTP to upload a file to API
  100. Search and match data from multiple workbooks
  101. Smoothing data
  102. Referencing location based on Cell data
  103. close MAPI session using VBA
  104. [SOLVED] XIRR Problem
  105. Extract xml elements from mutiple urls into Excel
  106. VBA vertical major grid lines do not want to format as stated below
  107. VBA USERFORM : listbox show data only ID selected
  108. Search for multiple values
  109. eliminate part of formula via macro
  110. [SOLVED] Copying Formulas into a range where blanks exist.
  111. USERFORM COMPLICATED
  112. [SOLVED] Macro to copy data based on criteria - Percentage - For sampling
  113. Temp Lock Workbook while form data is submitted to worksheet
  114. [SOLVED] Delete Duplicate data
  115. Increase range size by one cell each run
  116. [SOLVED] Set an object as the outlook inbox
  117. HELP_Excel chart with X and Y values in the same series.
  118. [SOLVED] how to save excel sheet in a text file?
  119. [SOLVED] Finding Duplicate in Long Numbers
  120. VBA web warning messages
  121. Web selector
  122. VBA Excel 2010 - interact with a website done in java
  123. [SOLVED] Hide Unhide with a twist
  124. VBA Code to Rename Folders
  125. Excel Addin Compatibility Problems with 2013, Invisible ActiveX Control
  126. Saving Worksheet as PDF
  127. [SOLVED] Macro Autofill with Loop and Delay
  128. [SOLVED] Create different file
  129. VBA : SEARCHING problem
  130. [SOLVED] Need help with a loop
  131. [SOLVED] Summing growing range
  132. Editing text in a SmartArt shape via a drop-down list
  133. add/fix vba reference
  134. [SOLVED] Excel to return looked up values from drop down list?
  135. Excel Userform VBA code to submit to worksheet
  136. [SOLVED] Copy Paste Data from Sheet 1 to Sheet 2
  137. Log date time and user
  138. External Links - How to remove user name?
  139. interpolation
  140. How to concatenate several cells
  141. [SOLVED] Set Integer to a Value
  142. [SOLVED] appear pictures in userform
  143. Saving Excel Selection as A PDF document
  144. [SOLVED] Saving Selection Ranges on difrant sheets as One PDF
  145. Find seven columns that come before last column.
  146. [SOLVED] Merge Excel Files in Folder into Bottom of Current Worksheet
  147. [SOLVED] hide, unprotect, unhide, protect
  148. VBA help! drop down selected - copy and paste data
  149. Lookup from unique data
  150. [SOLVED] Extracting Date from a string of Text - VBA Coding Help
  151. [SOLVED] Delete Cell contents when data is added to another cell within a range
  152. [SOLVED] Excel VBA Code to Open a .txt file and loop through every single words
  153. How to delete each empty row in a spreadsheet
  154. Problems with formatting a scatter chart using macros
  155. [SOLVED] Copy matching data from many workbooks to summary workbook
  156. Unable to capture all the rows
  157. [SOLVED] Symbol - VBA reference - Need help!
  158. [SOLVED] Re-arrange a columns data without sorting.
  159. [SOLVED] Returning Row number in data sort
  160. Maclaurin Series
  161. [SOLVED] Excel VBA Automation with the use of .BAT File - Task Scheduling your work
  162. [SOLVED] Delete First Duplicate Row
  163. [SOLVED] Storing wav files in a workbook.
  164. Looking for a way to export sheet with pictures/shapes
  165. [SOLVED] ExportAsFixedFile Error
  166. [SOLVED] Search String in Text Files
  167. For Existing and New files: CREATE & UPDATE file on different USB drives
  168. Replacing text in the formula in one part of a worksheet
  169. filter response (convolution)
  170. [SOLVED] Excel Macro - Copying data from one workbook to another
  171. Complicated Macro Help Required!
  172. [SOLVED] Colour Entire Row Base on the Value of Two Other Cells
  173. copying row + 1 row above and copying row + 1 row below
  174. Poor display in listbox
  175. [SOLVED] Advance Filter Criteria
  176. [SOLVED] [Excel VBA] Run-time Error 91 : Object variable or With block variable not set
  177. [SOLVED] Find values within strings from a predefined list
  178. error 1004 unable to get pastespecial property of range class
  179. [SOLVED] All of code is not being executed
  180. [SOLVED] Finding last row with data to send Mass Email
  181. VBA to Test Outcomes of Drop Down Selections
  182. [SOLVED] Conditional Formatting with three criteria
  183. If Statements in VBA
  184. [SOLVED] Offscreen print
  185. repetative code
  186. Copy fields from workbooks to a master workbook
  187. Breaking out a pivot table to new workbooks
  188. Before Print Issue
  189. [SOLVED] xlsm or xltm file extension
  190. Square to link
  191. Ontime vba opens another workbook that is not requested
  192. [SOLVED] Exporting Multiple Sheets as Excel & PDF
  193. Rolling Average in VBA with multiple columns
  194. Excel exceeding maximum number of connections to outlook
  195. vba code to find row base on some conditions without using a loop or filter
  196. Delete Rows that meet a Criteria
  197. Current dates in cells C2:U65000 when values in cells range A2:A65000 changes
  198. copy cells with just text not the formulas
  199. Drop Down list Show/hide rows
  200. Delete Workbook_Open code before Saving
  201. Looping through a range and assigning the row # to a variable when found
  202. Search multiple columns in another Workbook for value
  203. Excel VBA to tick a checkbox in the website if condition are met.
  204. [SOLVED] Searching for duplicates in column
  205. [SOLVED] SQL Query giving crazy results when executre from VBA ( Excel )
  206. Filter using VBA
  207. VBA Find
  208. Scrape data from HTML/Javascript dynamic tables using VBA
  209. [SOLVED] Produce a word doc for each unique record in a worksheet
  210. VBA clearing cells based on a selection
  211. [SOLVED] Help with Sentence Case
  212. run-time error 91
  213. Calender control
  214. End time button gets Inactive when workbook closed and reopened
  215. [SOLVED] Loop to next different range
  216. Unable to set the visible property of the pivot item class
  217. File Multi - User password
  218. Excel VBA nested if statements
  219. [SOLVED] Button action invoking specific cells
  220. [SOLVED] Retreive row numbers back into userform
  221. How to copy a picture from Excel to word
  222. [SOLVED] calculate date after 34 days and if attended clinic
  223. [SOLVED] Macro to Segregate values from cell and copy paste
  224. Hide/ unhide specific number of cells in a known range.
  225. [SOLVED] formula to calculate difference between 2 days excluding weekend or other holidays
  226. Extracting data from word to excel
  227. Open excel template in existing workbook
  228. so my data starts on row 7 (headers row 6)....i first filter for "M" in column B then
  229. [SOLVED] budget calendar, help handeling February date overlaps
  230. Macro to split one file into many based on criteria !!!
  231. Finding a Search String in Multiple Sheets and copying Rows to a new sheet
  232. Copy specific worksheets to a new workbook and save based on Assoc name
  233. [SOLVED] HLOOKUP not in all columns or something else?
  234. Urgent: VBA code to automatically generate new worksheet
  235. Help finding Table after text in Word Document
  236. MACRO Help
  237. Update Row with Visible cells in Column
  238. VBA to open list of hyperlinks in non-default browser?
  239. Image Embedded ? How to access
  240. script remove the toolbar from excel
  241. [SOLVED] Macro to segregate data in different sheet with some criteria
  242. [SOLVED] Write and Read on cmd with VBA
  243. [SOLVED] VBA No Longer Enabled for XLA or XLAM
  244. [SOLVED] Copy From 1 Workbook To Others
  245. Compare the values in the column and display the results in another column
  246. automatic macro initiation under conditions
  247. [SOLVED] Columnheads does not display in listbox!
  248. Excel Addin
  249. Copy and paste data from one worksheet to another with a unique criteria
  250. [SOLVED] Copy down if font = bold