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 174

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