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

  1. Solved: Sum unique values in a range
  2. VBA export of cells with variable range
  3. Save Excel to PDF one page wide
  4. Code to automatically add new email address to a table
  5. Histograms in excel 2013
  6. book
  7. Value field appearing above row labels pivot table
  8. Download Data From Internet using Excel macro
  9. Solved: Using VBA to Log In Members with a Username and Password stored within the Workbook.
  10. Manipilating an ASCII string in VBA
  11. Retrieve data from Access
  12. Solved: Date Format
  13. Solved: VBA issue
  14. Solved: Inserting cell value in formula
  15. Solved: Option to extend trend line on graph
  16. Using Index Match, adding to the bottom of the row those that are missing
  17. time and date in the excel cell
  18. Worksheet entry help
  19. graph /objects protection/unprotect
  20. Solved: Change/Update Defined Names 'Ranges' (multiple) in Name Manager
  21. by click on cell of column a the color of row change
  22. Extract Data From Alibaba Website
  23. Solved: VBA, checkbox, reporting and sum
  24. Solved: Skip cells
  25. Problems with merge fields
  26. Solved: Using Statemant CASE to delete rows in multiple sheets
  27. Solved: Rainflow Three-Point Algorithm
  28. Solved: can I change some options when using PrintForm !!!!
  29. pulling data from multiple sheet on to one sheet with specific value
  30. Importing data from a website into Excel
  31. Problem in replacing macro
  32. VBA to extract data from file in use
  33. Trying to copy paste and delete a row
  34. [SOLVED] Export to PP
  35. Solved: Cut data before first space
  36. Solved: Code for Protecting a Specific Sheet in a Workbook with a Password on Exit
  37. Help Building A Fully Functioning Excel Add-In
  38. Help transfer from ListBox to worksheet non ajacent columns
  39. Solved: Finding a variable cell on another sheet for a formula
  40. Solved: Overflow Error in Code
  41. Working with three workbooks
  42. Pasting data from Excel into multiple Notepad Sessions
  43. Split worksheet into multiple tabs
  44. Histogram help
  45. Using Excel Solver
  46. Need to create VBA to transfer data in between workbooks
  47. Import several text files into an excel file with macro
  48. Compile Error Variable Not Defined
  49. Lost on VBA HELP!
  50. Check SharePoint if file exists
  51. Solved: [Solved] Need Help About Check Boxes
  52. Automated Macros
  53. Conditionally Format cells in a row based on the sum of the previous nth cells.
  54. Sorting an array from small to large with an error twist!
  55. Hostname to IP
  56. vba code import table excel to mysql
  57. Autimatize worksheet names
  58. Solved: Automatically Open Files On Folder Select
  59. Solved: Learning!
  60. Compare, Match And Copy Data Row
  61. VBA OF EMAIL FROM EXCEL
  62. Application Defined or Object Defined Error
  63. on each page, highlight the first cell on column A
  64. Solved: Save As Web Page plz plz help
  65. Counting Unique Values across multiple rows
  66. Macro Speed Up - Help
  67. VBA on a MAC
  68. Excel, VBA, Send Email
  69. Solved: Help transfer from Multi Column ComboBox to worksheet non ajacent columns
  70. Compare & Fill Data Help Needed !
  71. Solved: Call CMD.EXE and send instructions
  72. Scrape data from website to excel - VBA
  73. Any suggestions on making this code faster
  74. Solved: Range("FilterArea")
  75. Save Breakpoints
  76. Add Dynamic Option and loop to my code
  77. VBA CODE - SEARCH AND COPY
  78. Initializing a userform from another userform?
  79. Query SQL through VBA
  80. footer
  81. non vba save as dialogue box
  82. SUMPRODUCT double counting
  83. VBA Code - Autofill with a Dynamic Range
  84. Cells(x,x) = 1 ?
  85. Check for a condition in a Do Unil Loop
  86. Save text file as unicode from Excel VBA
  87. Consolidate Data Using VBA
  88. Operation with dates
  89. How to best count?
  90. Find Duplicates and Highlight Row in Red
  91. Uncheck Chckbox in Protected Sheet
  92. VBA export of specific rows
  93. VBA code to open folders and pdf file inside the folders
  94. How to extract filename from a folder which is on a netwrok drive
  95. Excel VBA macros - webquery
  96. VBA to auto-add rows to 3 Tables (or one and auto-resize 2)
  97. Refresh data in closed excel workbook
  98. Export array values to Excel
  99. Formulate average count of DISTINCT records
  100. Create sheet if it doesn't exist problem
  101. Need Some Change In Count Macro Running Code
  102. New to VBA, trouble with an If Else Then statement
  103. Auto Name a workbook
  104. Date -> numeric translation issue
  105. looking help
  106. VBA Set cell value under last row
  107. Duplicate data sets multiple times in VBA
  108. GoalSeek by VBA
  109. Create Unique Values List From Named Range
  110. [SOLVED] Export worksheet to new workbook and restore original sheet
  111. Deselecting a single pivot table item which is referenced in a specific cell
  112. help with complicated formula
  113. Excel Property Window While Saving
  114. Need Help with calculating an array of numbers...
  115. Highlight a specfic column when spread sheet opens
  116. [SOLVED] multi-VLOOKUP From an Array in VBA
  117. Code to unprotect wbaproject
  118. xlRepairFile
  119. VBA Comparison between 2 sheets that return a 3rd sheet with differences
  120. Trouble with calculations in Excel table
  121. Lotus Notes Mailbox Size/Quota from Excel VBA
  122. clearing ranges from COPIED sheet
  123. Login into a website through Excel
  124. [SOLVED] Understanding the Syntax of Hyperlinks.Add
  125. Active Cell Address move to left when enter key is Enter
  126. fill range based on Month
  127. Asking for a different sheet name if current input already exists
  128. Printing Embedded PDFs from Excel Workbook
  129. Format from last Row Up
  130. Alternative to Application.Ontime
  131. Open word document
  132. Excel 2010 Print Blank Page
  133. VBA Sum If Calculation
  134. Custom function help (Probably just me being stupid!)
  135. help to Copy symbols indicators as per range parameter set.
  136. #Value Error Using UDF Within Worksheet
  137. Copy cell content and and paste to specific cell as a comment.
  138. Pairing Co-ordinates
  139. Enter text base on cell value/text referencing a dynamic list
  140. .xla Add-In Mechanics and Custom Ribbon Creation
  141. Deleting Rows using VBA macro
  142. [SOLVED] Copy Excel range & paste in PPT as [Pastespecial - M.O. Excel Worksheet(Code) Object]
  143. Highlighting Repeating Number Pairs
  144. Move cursor to image named material and then go to sub menu Material AVaialbility
  145. Copy Rows based on 1 criteria showing in Multiple columns
  146. Help with a VBA macro - merge multiple workbooks in one workbook with source names
  147. VBA: How to search new sheet for a defined variable, then copy values back to sheet
  148. VBA - MouseMove Event Code to Display Text after Hovering
  149. Column headers throws errors
  150. Insert Rows based on 2 Criteria
  151. [SOLVED] List cells containing references to files, i.e. containing formulas with broken links
  152. VBA Code to move files to another folder
  153. Copy cell contents to another sheet at a particular cell address
  154. Need help with Inputbox function and If Statement
  155. Confirm Message Before Deleting Rows
  156. Is there a before_insert_row event?
  157. Highlighting, freezing and scrolling
  158. Save sheet as csv to specific network folder
  159. time calculation formula
  160. Best Way to Create Options Menu for an add-in?
  161. VBA Copy and Paste data to another sheet(with a date and day)?
  162. vba to run a macro on multiple excel files in a folder
  163. worksheet function match syntax issue
  164. Setcell to blank if results of a formula are null, based on checkbox conditition
  165. Need Help with a Looping Issue
  166. VBA Compile Error: Ambiguous name detected
  167. [SOLVED] Query doesn't work in Excel 2010
  168. Macro to paste on a hidden sheet
  169. [SOLVED] Maximum and minimum tide levels for every day
  170. VBA Variant Array issues with Excel
  171. VBA code to open IE in non-protected mode
  172. Help making my search look in 2 sheets?
  173. Close active workbook if multiple workbooks are open/ close excel if only one open
  174. MAX date problem
  175. VBA Dynamic Named Ranges & Page Formatting
  176. Rolling Calculation
  177. [SOLVED] VBA Paste Cells With Specific Text String to Specific Sheet
  178. [SOLVED] Populate Hyperlinks in ListBox
  179. Macro that generates new work sheet with people and tasks they perform
  180. Loop through columns and vlookup
  181. VBA Dynamic Ranges & Sheet Formatting
  182. [SOLVED] Combining multiple range as target cell
  183. VBA Autofill Method of Range Class Failed
  184. [SOLVED] pass two workbooks into sub module
  185. Load Formula from another sheet
  186. vba script to convert datetime string to date format
  187. Show and Hide a UserForm using a String as the UserForm Name
  188. [SOLVED] Create copy of WB
  189. [SOLVED] Edit Listbox Items
  190. [SOLVED] Run-time Error 5 "Invalid Procedure Call or Argument"
  191. conect 3 tabales in Table4 in diferent worckbook
  192. Connect to Oracle with Excel VBA and store results of query?
  193. [SOLVED] How to replace the FileSearch application in Excel 2010
  194. Shifting and combining columns using VBA
  195. Vlookup Dynamic Criteria
  196. VBA TO MOVE DATA FROM ROW INTO COLUMNS BASED ON CERTAIN CRITERIA
  197. Macro that generates new worksheet with a dependent worksheet name
  198. changing Listbox based on an other combobox
  199. Vba to move columns with certain headers
  200. [SOLVED] Insert a Hyphen at two characters from the end of a String
  201. Excel Timestamp format editing
  202. Code Security (COM Add-In? .xll? What to do?)
  203. Need help with Loop??
  204. Help with Date Picker 6.0??
  205. Folder Access
  206. VB looking at excel file to move files
  207. [SOLVED] Finding a date without a search
  208. Identify timezone and convert time to other timezone
  209. Why cannot run the code
  210. Convert formula's cell reference into value
  211. Cell Colouring in VBA
  212. returning value of data validation
  213. [SOLVED] lookup formula with multiple criteria
  214. Help needed for creating Dynamic Oracle Query using Excel VBA and Forms
  215. [SOLVED] Most efficient way to move a selected range up or down
  216. VBA Finding String on Webpage
  217. Solution to find overlapping rectangles given co-ordinates
  218. [SOLVED] VBA Insert Formula On Multiple Sheets
  219. Compare Date from a Column Cells in alternate Columns Cells
  220. several handlers with same piece of code
  221. [SOLVED] Opening files on network drive
  222. ActiveWorkbook.SaveAs on Mac OS X
  223. [SOLVED] array formula that will index a horizontal array
  224. Copying Data from One Sheet to Different Sheets
  225. VBA importing data from .txt
  226. Substract hours when inicial time is before midnight and end time is after
  227. Application.OnTime not getting canceled
  228. Excel VBA to copy and move files
  229. [SOLVED] VBA text file write not working on close and open
  230. [SOLVED] VBA Not InStr
  231. Rotating employees and where to working
  232. [SOLVED] VBA Round To 2 Decimal Places
  233. VBA Insert Formula At The End Of Row
  234. [SOLVED] Shorten vba if Statements
  235. Number format
  236. Clear contents
  237. Download Files in Excel Using VBA
  238. Search a Column for a specific Value and Place in Another sheet
  239. [SOLVED] VBA Change Cell Formats
  240. [SOLVED] a better approach
  241. [SOLVED] VBA MACRO CODE FOR GENERATING DAYS NUMBERING
  242. sending mails from outlook using html tables with excel cell reference
  243. [SOLVED] Copy from one workbook then paste into one other
  244. Help: Dynamically Formatting Line Graph
  245. Help: Dynamically Formatting Line Graph
  246. Randomly Assign Number Without Repeating The Same Number Twice
  247. To pull text files (attachments) from Outlook and format them in Excel
  248. A Data Cleaning Macro - Clean, Trim and CHAR(160)
  249. [SOLVED] Vlookup and Type mismatch error
  250. Clear contents in multiple range and multiple sheets