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

  1. Restrict two macro run at same time
  2. Inside ListBox Sorting Problem..
  3. Macro Menu
  4. Recquired Conditional VBA solution for moving data as per diffrenet cell value
  5. =today(),now()
  6. Solved: How to have function run on both tabs
  7. Count no. of item copied.
  8. Solved: Returning a value into a textbox without Decimal Places Shown
  9. Recquired Conditional VBA solution for moving data as per diffrenet cell value
  10. Sort columns based on named range
  11. Solved: Copy Worksheets Based on "View"
  12. Macro to import/export data
  13. List ALL Formulas & Conditional Formatting in a WorkBook
  14. Solved: Inserting a Specific Date
  15. Tab Order
  16. Solved: Help Required - Audit Trials using VBA
  17. Manipulating Excel cell comments in VBA and with DB Data
  18. Problem programming routine for conditional copy/paste
  19. Create email with filtered data
  20. Import closed workbook - there are lots of methods but which is best?
  21. Solved: PrintArea and Pagebreak woes
  22. Solved: Naming inserted pictures
  23. SaveAs on 2 Cell Based (Path)
  24. Solved: Delete only today comment?
  25. Get page count of pdf files
  26. Run time error #13 while macro runs
  27. vlookup
  28. macro problem please help
  29. Solved: macro to import data from text file to excel worksheet
  30. Rectification of VBA script
  31. Copy one excel file into another one row at a time
  32. VBA Excel Copy cells within one sheet
  33. reference named range
  34. Delete duplicate merged rows.
  35. Excel Vba Code
  36. VBA code giving error on some system
  37. count no. of matching data in two excel
  38. Select and activate ComboBox entry by macro code
  39. Solved: Named Ranges
  40. how to pick last -1 value of the column
  41. VBA code to change font for email
  42. Removing vbcrlf with a macro
  43. Vlookup using VBA
  44. Help required: segregation of data
  45. Solved: empty cells not allowed
  46. Routine cycling data after automatic database sorting
  47. Solved: events problems
  48. save/paste column
  49. Solved: Need the Root Directory of Thisworkbook
  50. Solved: Playing Embedded Wav File
  51. Help with a simple Macro
  52. User form "X" button to call Exit button
  53. Solved: New to VBA - How do I open WORD?
  54. Solved: Correct File Selected
  55. Email with Glitches
  56. Compare the columns in two files and results in a separate column
  57. Display text on cell selection
  58. Cell Identification
  59. Solved: Illusive Macro
  60. Assigning Autofilter values to a variable
  61. how to store comments in a string?
  62. unload userform if greater than certain row
  63. Solved: Formatting Text /Numbers in a Textbox of a Userform
  64. DTPicker has gone AWOL ???
  65. Solved: Sum of sales in a Week
  66. deleting hidden rows or columns that have no data in a specified cell.
  67. Import CSV file data and export it in sql file
  68. Solved: Unhide last row in auto filtered data
  69. Solved: Restore Cell colores from saved information
  70. Condition copy based on list from different sheet
  71. Populate UF Listbox then send to Spreadsheet
  72. write the name of all excel file in a folder in an excel file
  73. Solved: Merging a specific worksheet from multiple workbooks into one
  74. Solved: Chart Series only use last 4 rows
  75. Programmatically updating VBA macros in old spreadsheets
  76. Using StringIndexOf to return two values
  77. Color Row
  78. Conditional Format question
  79. Print result in different worksheet with different number of rows
  80. Hidden Workbook - Now Cant Get Back!
  81. FUNCTION to return values from a closed workbook
  82. Differentiate between sources of results on cells
  83. Open each excel file and then close it.
  84. GetValue work with UNC?
  85. Copy details from the uploaded input file and paste in destination file
  86. Pivot table Items
  87. Solved: Passing Value back to userform
  88. Solved: Help Required - Checking formats of cells
  89. Macro to delete entire Row on Sheet 1 if values found on Sheet 2 matches
  90. Non Excel Application Status
  91. Solved: Need to sum column totals for month. - My Code seems to be rounding cell values.
  92. 3D Lookup - using sumproduct / offset functions?
  93. Help required - alter VBA code
  94. Force data entry in cell b1 if data exists in cell a1
  95. Pricing Tool
  96. Delete if value is 0
  97. Hide the Zero's in a new Window
  98. VBA Code to move files from local folder to web folder
  99. Copy all date of column to another cell of another column
  100. delete rows between 2 named ranges in excel 2003
  101. xl2003 and Win7
  102. Add thick box boarder around data after name change
  103. Skip line loop
  104. Solved: Combined loop and find method between 2 sheets is too slow.
  105. OpenAsTextStrem - only want a certain range
  106. Search for all instances of a string then hide all other rows
  107. Determine last used cell of a column and put formula 3 rows beneath it
  108. Addressing a ListObject Table dynamically
  109. Open to specific Directory
  110. What is the error?
  111. Conditional date copying
  112. macro-copy pictures from comments in a column then paste to another column
  113. Solved: Loop in for used many columns
  114. Solved: Delete Sheet gone from tabs right click menu...
  115. Solved: copy list from one sheet to another sheet
  116. Solved: Create new tab based on list
  117. Shortcut
  118. Deleting headers from the top of a file, then save
  119. Solved: Delete duplicate data useing VBA in Excel
  120. beta MOS exam
  121. Change value of the cell below based on criteria
  122. Solved: Delete duplicate data in a Column
  123. Solved: Delete just 2 column
  124. Search Cell for unique number from range
  125. Solved: add - when merge data on cell of column
  126. Excel Macro - click after login to a website
  127. Solved: Data Query
  128. Import *.bas in same directory
  129. How to combine the rows?
  130. Solved: How to combine the rows?
  131. How to save the excel as pdf?
  132. Date entry validation
  133. Solved: updating data regularly between 2 workbooks
  134. Solved: Update drop down view list
  135. Return Value into userform.
  136. Copy Data to latest row of other sheet
  137. Solved: Listbox - List values with one decimal place
  138. Solved: SumUp Filtered Row
  139. Solved: Filter Records before sending to userform
  140. Solved: Fill Down Formula
  141. Absolute beginner in need of help
  142. Solved: Application.Max problem
  143. Securing a sheet with VBA in excel
  144. Excel VBA Macro event Workbook_BeforeSave
  145. TFS Connection using Excel VBA
  146. PDF tow Excel
  147. Macro to copy the filter data from excel file and copy to other excel file?
  148. Hi experts, how to import csv files into ms Excel using visual basic.
  149. Solved: License information... not found
  150. (Un)Hide columns based on a list
  151. Combine Multiple Worksheets Into 1 New Sheet
  152. enter formulain cell through VBA
  153. Assign a value of a variable to a specific cell
  154. Filtered range - need to row numbers :/
  155. Is it possible to automatically removes spaces, commas, and delimiters using VBA?
  156. Adding a new criteria to a filter
  157. XY Scatter Plot from Pivot
  158. Code doesn't work unless worksheet is active
  159. Solved: Add MS- and delete the 3 of first number
  160. How to do the loop for find text in a particular column ?
  161. Above 65536 Data to be paste
  162. Solved: Find the rows count in in a column where cell value >0
  163. interactive chart
  164. Solved: check column and delete
  165. Paste columns, rows or cells
  166. Vlookup on a sheet with merged cells
  167. insert missing columns
  168. Solved: Paste to latest empty cell
  169. Catenate Help
  170. Solved: VBA not working
  171. Changing numberformat
  172. Autofill down based on two conditions
  173. Solved: problem with column
  174. backing up your macros?
  175. Solved: search text in a worksheet then copy the whole column to master sheet
  176. Solved: Unable to close excel
  177. check box
  178. VBA sort rows based on 1 of 2 values in a Field
  179. [howto] Fetch data from txtfile and segregate it into corresponding field.
  180. Can anyone make this more efficient?
  181. Solved: Text to Columns with an extra bit
  182. Help to convert formula into VBa code.
  183. User name pulled from Windows
  184. Can't Add Command Button
  185. Solved: Password Protecting - Command Buttons
  186. Advice on storage data into array
  187. VBA Code Help
  188. Trouble with Vlookup in VBA
  189. Just a Thank You !
  190. IF Range Select not working
  191. Reduce code and return empty if empty
  192. Protect Cell and Range
  193. Solved: Auto Size / Center View Screen
  194. split as per Map sheet
  195. Display Pivot Table values in a userform
  196. Excel data to Word Email Merge
  197. Adding a new line
  198. formula error
  199. Access restriction
  200. Consolidate Files From Mutiple Sub Folders into One Folder
  201. Solved: Mergin two bits of code to format cell
  202. Raise event to unknown object.
  203. Is it possible to copy values from a worksheet to another worksheet using vba?
  204. Concatenate multiple cells to each cell
  205. Solved: XL 2003/Win XP - VBA File Browser -How may I free up Folder access after running code
  206. How to auto populate an excel spreadsheet with data from another spreadsheet?
  207. Solved: Find text in a column then move the row to left
  208. How to create macro which will move data from one worksheet to other worksheet?
  209. Solved: Help required : syntax correction
  210. Navigate to Sheet name from cell Value
  211. Solved: More than 7 Nested IF's
  212. Solved: back to sheet
  213. Trouble making a dropdown work
  214. Variable Range Issue Variable Range Issue Range Issue
  215. paste range in powerpoint
  216. Can't Get macro to run in Excel 2010
  217. Solved: Count unique values based on multiple criteria
  218. Solved: Looking up matching cells
  219. Solved: Color coding rows by market value
  220. Excel Hide/Unhide Sheets based on cell value
  221. Uninstall Excel Utilities
  222. Solved: Send an outlook email by reading from cell values
  223. average based on criteria
  224. restore external links to excel pivottables
  225. Garbage data is copying to other sheets column?
  226. Solved: Pass Multiple Values from A Textbox
  227. User Form to Update data in Another workbook
  228. Solved: Converting Numbers
  229. Appending to Workbook Name
  230. export file as *.xlsb with open password protect
  231. Date within date range
  232. How to update files info [File listed in range with full path]
  233. Custom Document Properties help
  234. Compile error in hidden module
  235. Compare rows with first row and copy the matching records in another sheet.
  236. VBA to Save and close Multiple Notepads
  237. vba to automatically update data and graphs
  238. problem when downloading xlsx file.
  239. Excel to Word table edit - is it possible using VBA?
  240. Using Pivot Tables in Excel to show Qualifications over time
  241. Solved: Copy to another sheet problem .
  242. VBA project not allowing existing excel sessions to open.
  243. Not sure where to put this - VB login form
  244. Change Excel Link Using VBA
  245. Store and modify column letter in a variable
  246. Insert Worksheet
  247. Save as with Variable file location
  248. Dynamic range that change variables
  249. Populating Combobox
  250. Replace all comments