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. Combining data with duplicate rows
  2. Solved: Populating Combobox with Filtered Data
  3. Send a fax
  4. Extract Substring, Ignore Substring for rest of txt, collect data while creating Data
  5. Solved: Save email in drafts
  6. Solved: Alert - When 3 conditions are met on the same row
  7. Error while saving with reference to another workbook in footers
  8. Excel printing continues paper printing
  9. Solved: .Find and activate a Visible Cell within a Filtered Range
  10. VBA / Formula approach
  11. Solved: Copy only part of items
  12. Automatically sharing specific data to other workbooks
  13. Solved: Saving as xls
  14. Help with creating Excel VBA Password system
  15. Please Help - Stupid Mistake
  16. Web query help
  17. Copy values from another workbook
  18. running macros
  19. Solved: Restart macro after blank cell
  20. Help with Search
  21. Scripting Dictionnary - key is already associated with an element of this collection
  22. Format isn't working
  23. Naming the created worksheet?
  24. Solved: Fax
  25. Hide and unhide rows by selecting a letter from a userform ComboBox
  26. Update macro application search to V2007
  27. Solved: Selecting multiple cells
  28. How to make a ComboBox select a specific value when i enter the workbook ?
  29. Extract ChildNodes' value from Website to Excel
  30. Solved: import record from text file & match with record in excel
  31. Solved: CC another person on an email
  32. Solved: Moving document to recycle bin
  33. Solved: Filling certain Cells
  34. Solved: Excel function: Sumproduct to match certain veriables with a date parameter
  35. Solved: Dont email if no attachment exists
  36. Problem Hiding Rows Based on CheckBox Event - Reaching Maximum Limit
  37. Solved: Use a function to access DB
  38. Solved: Formatting issues
  39. Solved: Paste & Delete Via VBA
  40. Excel VBA for Longtitude and Latitude Help Please!!!
  41. Solved: Changing Range of sources for chart
  42. Automatic Create report using data from another sheets in excel
  43. Question / Challenge - Lorenz Cipher Excel
  44. Solved: Arrange Columns based on header values
  45. Solved: VBA to do job of lookups
  46. Need help in Excel Macro
  47. Disable Arrow Keys
  48. Split the files based on the Specific Column and update the Row Count
  49. Solved: Merge/join cells if same ID
  50. total characters in a cell
  51. Referencing certain cells to send emails out
  52. Solved: Removing Defined Names in Worksheet
  53. Solved: Multi page form refreshing data
  54. Solved: highlighting matching cells
  55. Excel compare data
  56. SAVE EMAIL ATTACHMENT TO EXISTING WORK BOK
  57. Solved: Resize a table
  58. Selecting Range Names from a Table with Vlookup
  59. filling date
  60. select 3 columns
  61. Solved: Append text to a cell with color
  62. Solved: List file names and directory
  63. Help in VBA-Excel needed
  64. fill dates
  65. Range("Cells(a,b),Cells(a,b)").Select is not work
  66. VBA Copy All Rows With Today's Date in a Cell
  67. creat chart
  68. data
  69. VBA and vlookup
  70. Solved: linking with word
  71. export to csv
  72. Make highlighed cells Bold using VBA
  73. Importing data into Excel based on Month
  74. Moving cells to another sheet
  75. Multidimensional array problem
  76. Selecting two sheets with workbook_beforeprint
  77. Excel 2003 Sortfields VBA runtime error 438
  78. Reset Autofilter and Unselect specific numbers
  79. VBA to stack pivot table data
  80. Copy Data from Certain Cells in Multiple Workbooks to One Master Worksheet
  81. VBA Command to Find Invoices designated as NotPrinted and place invoice number into c
  82. Solved: Apply Data Validation to a Named Range
  83. Define String from Cell Cell Value
  84. Solved: vba ignore if statement in optiobutton
  85. Check the entire row and delete duplicate values
  86. Solved: E-Mail from Address found in Worksheet
  87. Solved: XLDs CFColorIndex and Chart sheets
  88. Formulas becoming values
  89. find and sort
  90. Help with cell formatting
  91. Solved: Help with modifying error bars via VBA
  92. Need help with Hyperlink question
  93. VBA VLookup Function
  94. Set focus on check box value and not on caption
  95. Excel Object Model and Embedded Word Document
  96. Excel timeclock data vba help
  97. Solved: sort multi dimensional array
  98. Why does this Previos Cell code some times error, most of the time not ?
  99. Search for cells with comments and cocatatenate to Col(N)
  100. VBA code to use Other Programs with Excel
  101. VBA code to click submit button in ie after checkbox is checked
  102. Excel Mail Merge
  103. Slot Machine help in VBA
  104. Chart with user-defined range
  105. Time Comparison
  106. Solved: Global Search/Replace in Formulas
  107. Complicated issue dealing with large file maintenance
  108. Solved: Allocations for CSV
  109. Solved: Function to copy sheet to new file
  110. Solved: Import XML Attribute Data To Worksheet
  111. Solved: Uploading a ComboBox from a Column in Excel
  112. Solved: Use VBA to create a named range
  113. macro for charting
  114. macro for charting
  115. Checklist automation from Outlook Senders
  116. Transferring formula to vba
  117. String lookup to get month
  118. Solved: Borders to all the used cells for all worksheets in a workbook
  119. Solved: Adjust Macro Range To 2 Columns.
  120. Solved: For Each and Pivot Table items?
  121. Need Code to Unhide Rows
  122. code will not work when I change the name
  123. Windows 7 external file open
  124. Unable to solve using macro
  125. Solved: Finding 2nd instance of a colored row seems to be much slower than it should be.
  126. Solved: Finding a Date in a Range
  127. Vlookup text values
  128. chart to be created in new sheet This macro creates chart in the worksheet same as da
  129. Solved: Copy worksheet to new workbook and more
  130. Rename files at unzip!
  131. issue reading from a .csv file
  132. Problem with formula
  133. Not work for upload file when the Window Language format - VBA
  134. Solved: How to: Function > Calculate sumof and divide
  135. Solved: Progressbar
  136. conditional formatting with vba
  137. data conversion
  138. paste text into chart
  139. Solved: get a list of files from Directory order by the date modified
  140. Solved: Macro inserting colon in time returning #value! in output column
  141. Solved: I need help with InStr and searching a string for characters
  142. Conditional formatting
  143. Solved: Inserting more than one value into a single cell in an excel worksheet using VB.
  144. Converting sheet based stopwatch to a userform
  145. Solved: Turning Off Error Alerts, of sorts
  146. Solved: VBA code launching problem
  147. Calendar problem
  148. I need to create several random files
  149. Solved: execute code on the lines with data in column "B"
  150. Excel 2007 Ribbon Problem...
  151. User Defined Functions
  152. thisWorkbook.Save going to TMP file
  153. select last 20 cells
  154. Filter by value in cell to the left.
  155. Solved: Build Dynamic String into Cell
  156. Worksheet_calculate runs based on every formula in sheet
  157. Insert New Rows Between Rows
  158. Solved: VBA code to count blank cells in a dynamic range
  159. Right click
  160. Solved: Transferring the Userform Textbox Values To a Single Cell As Comment Indicator
  161. Deleting Rows when using for each cell in loop
  162. Solved: Sum 'A' if there's any digit into string in 'B'
  163. Solved: Personal.xls vs xla
  164. Working with Oracle CLOB DataType
  165. Building third large table which consists of matched rows of two smaller tables
  166. Solved: Image on Command Button
  167. Solved: Compare and insert missing Row Values Problem
  168. Solved: replace all values in column with combobox selection
  169. Copy Picture generates Insufficient Resources error
  170. Solved: GoTo in VBA
  171. Image Viewer in VBA?
  172. fuzzy search macro
  173. A function to monitor changes on the data
  174. Solved: Using find function
  175. Pivot Table with both Compact & Classic Layouts
  176. Macro Help
  177. Need help with macro to detect if cell value changes from current value
  178. Help needed with small issues in function
  179. Error in calling function
  180. Macro Code Overwrites Previous Data
  181. Solved: Step Backwards through range
  182. VBA code to "Save" for dialog box
  183. Solved: Look for Values in Range
  184. How to keep an excel file from being copied
  185. VBA code to read and update text file
  186. Unzip only "text" files in a particular folder
  187. Solved: Worksheet_Change vs Worksheet_BeforeDoubleClick
  188. extract html data (not in table) from website to excel
  189. Solved: Excel 2007 vba - Filter criteria problem
  190. How to create a macro that opens a webpage and introduces text into a form !
  191. Autofill range in formula
  192. Workbook Revision Update Onload?
  193. Solved: Comparing Between 2 Workbooks and Inserting Missing Data
  194. Copy Cells and keep Source Formatting
  195. points on a graph
  196. help needed with lookups & conditions
  197. Excel Access Log VBA
  198. Solved: need help to display workhours in days:hours:minutes
  199. moving objects from excel to PowerPoint can not turn lock aspect ratio off
  200. A simple printing pages depending on cell value
  201. Solved: vlookup problems
  202. Scroll to column via Combobox
  203. Looking for a faster way to autohide rows
  204. Error occuring then code is already launched
  205. Error occurs then the code is already launched
  206. vba sumifs
  207. Solved: Auto Hyperlink to Folders
  208. Solved: Check if today is a specific date that falls on certain weekday regardless of year
  209. Excel VBA Error 'Excel Ran out resources' - Reg
  210. macro loop through 2 worksheets
  211. Unlock all VBA projects
  212. MERGING SHEETS
  213. help with user forms
  214. Set Pie Chart & Pie Chart Tags to be Same
  215. New here: I have som questions about Excel and VBA
  216. VBA APPOINTMENT BODY
  217. Difference between .responsetext and .document
  218. Writing a macro within an exel document
  219. Solved: Convert exponential format to a number ?
  220. Browse a Folder and Populate Listbox with Folder Items
  221. Hide and unhide the worksheets in vba with dialog box
  222. Solved: Excel countif multiple criteria
  223. Merge all data in column just to 1 cell
  224. go to
  225. Solved: extract data from website to excel
  226. Solved: Delete dash with space
  227. Solved: compare 1 cell with 5 cell
  228. Solved: Date format
  229. VBA to automate a process
  230. Solved: hyperlink a cell to a textbox
  231. Search for row, check and count max match with another range
  232. Subscript out of range
  233. Excel VBA and CUDA
  234. PLEASE Help with Looping
  235. Solved: Macro to convert num to char
  236. using formula in coding
  237. Search and Compare
  238. Using ADO to import Data
  239. Solved: Compare 2 sheets and delete matched rows
  240. Dates
  241. Solved: Listbox value as input
  242. Wanna sb can do sth would help!Ty in advanced anyways.
  243. Prob in substitution
  244. Solved: move data with * symbol to another sheet
  245. Solved: macro to sum each row if have same value
  246. copy found data to other cloumn
  247. Solved: Run time error 91
  248. Solved: formula to collection
  249. How check if add ins run?
  250. Combination