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