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