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

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