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

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