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. Transfer data to another worksheet only if "Column A" has any value entered
  2. Cleanup and fix vba code help
  3. [SOLVED:] Data Duplication Problem
  4. Solved: VBA formula relating 2 worksheets
  5. UserForm help
  6. Solved: questionnaire
  7. ListBox1 & ListBox2 & ListBox3 one criteria for Filter
  8. Solved: Conditional column delete based on multiple criteria
  9. [SLEEPER:] Array Help
  10. Solved: Select Case problem
  11. Cumulative addition - Vb
  12. Solved: Date display
  13. display differnt cell protection message
  14. Move row if text is in column matches string
  15. Solved: Checking the value of mulitple checkboxes
  16. Cells blocked with permission to change
  17. Solved: Compare column with multiple sheets
  18. copy from excel to ppt office 2007
  19. Bin2Hex Method between Worksheets
  20. [SOLVED:] Random Choice From Array
  21. VBA: How do I use a Variable Name in a formula
  22. Solved: error
  23. Solved: Delete records for the current month
  24. Pivot Table - Pivot Fields Orientation.Position giving me an error
  25. Update the VBA code in a XLA file
  26. Sort with Multiple columns using VBA
  27. Unique Values
  28. Remove the default Excel menubar
  29. VBA code to look for files and put result in an array
  30. Copy ranges
  31. OleObject file Access in an Excel file
  32. Change Event Handling for a cell and for a combo box in Excel 2010
  33. Why won't this simple code work anymore?
  34. Solved: Deleting source data used for drop down list?
  35. Macro to retrieve the value based on the column value in another
  36. Solved: Determine the Quarter for a Date based on a condition
  37. Stock qoutes date deviating.
  38. How to capture user last key press using VBA in Excel?
  39. [SOLVED:] Create custom submenu using commandbar
  40. Parsing excel value into SAP BW Analyzer 7.x
  41. Zip a file via VB?
  42. Create Text Files for each cell value
  43. Solved: Reference Visible Cells within a Range
  44. variable range giving runtime error 1004
  45. Solved: Auto Filter by month of activecell, and subtotal result in a msgbox
  46. How can I search with Listview and Array ??
  47. Copy mode is giving error
  48. Macro to Import Text files in Folder into Excel
  49. Solved: Excel 2007 If today is Monday show the previous Friday's date
  50. [SOLVED:] Read HUGE text file and copy to excel
  51. remove <100&10
  52. Solved: How to specify range using contents of cells?
  53. Solved: Sum every other visible cell via VBA
  54. macro don't work normally
  55. Save as to 2003 .xls
  56. Consolidating excel files with different rows and columns?
  57. delete rows in the sheets
  58. Dynamic range calculations on other worksheets
  59. Need Guidance for learning VBA and macros
  60. Solved: Need VBA Code to search one WS from another WS
  61. Copying cells from 2 row/Pasting into new column
  62. Solved: Cycling through Workbooks
  63. message to delete value in cell
  64. Solved: Formatting Output As Double Digits
  65. How to find out which Form Control button on worksheet has been clicked?
  66. Solved: Protecting code
  67. Solved: Optimize programming
  68. Excel heatmaps
  69. * excape doesn't work in macro
  70. Need micros coding for applying values.
  71. Code hangs if not find the any data in Master sheet
  72. Send Email (Lotus Notes) Creating Temp File Problem
  73. Email lotus notes send sheet
  74. Import data as value to a master sheet
  75. Same concept hide and full screen
  76. hide 0 values in pivot table
  77. Show selected months in Pivot table
  78. Solved: Used range code
  79. Extracting Specific Text from Email!!
  80. Solved: batch macro to delete rows
  81. Need help on excel graph for the given scenario
  82. Highlight the columns being used to AutoFilter a range
  83. Count the Cells
  84. conditional column range
  85. VBA Error Handling Help
  86. creating a Copy/paste macro from one sheet to another assigning buttons
  87. IsFileOpen Error "53" in 2003
  88. Password TextBox in UserForm
  89. Solved: division with zero
  90. Error Handling in VBA
  91. Automatically choose which file to open?
  92. Can you intercept a keystroke during a long loop
  93. vba cell format strikthrough and red
  94. Solved: vba : Syntax modification help required
  95. Organizing People Using VBA / Excel?
  96. Solved: Sync Loading Bar with actual Process
  97. can this be simplified with a loop?
  98. code Transpose whole workbook
  99. VBA: create separate sheets based on cell value
  100. renaming all files in folder & subfolder with name & date
  101. Solved: vlookup skip blank or 0 cells and find match
  102. Copy Paste sheet Range to another worksheet
  103. VBA form events
  104. Solved: Automate Several Sheets
  105. Solved: Rename worksheets based cell value
  106. Solved: Passwords part 1
  107. Passwords part 2
  108. Solved: msgbox display
  109. Solved: Array Query
  110. Check date is between 2 dates
  111. Adding a ScrollBar to a dynamic UserForm
  112. Posting value to Cells from VBA, where Cell are protected?
  113. Solved: Take User form data to new worksheet
  114. Excel VBA code to Correct Day ?
  115. VBA events part 2
  116. Putting values on cell based on cell colors
  117. dropdown menu
  118. Selection criteria
  119. Solved: code to work for 12 TextBoxes of a form
  120. find end of the...
  121. Importing and formatting text files
  122. How to exclude hidden rows/columns while executing a VB code
  123. Strange behavior for my VBA code (HELP)
  124. Group cells
  125. Array Help2
  126. calendar??
  127. Formting and Adapting
  128. data validation
  129. Solved: vlookup problem
  130. Copy into new workbook based on cell info and other questions
  131. search a specift text and concatenate with another row
  132. Is it possible to migrate data using visual basic in excel with other systems?
  133. csv import
  134. merging worksheet with forced repetition
  135. Pivot Table Help
  136. CountIf and only different values
  137. Look up for a value in a worksheet and store it in a variable
  138. Loop Thru Textboxes - Help....
  139. Calling a Stored Proc from VBA
  140. Solved: help on tranposing data from column
  141. Solved: Take Userform data to new worksheet
  142. [SOLVED:] If file is open or if file exist
  143. Solved: paste to match destination formatting
  144. Solved: inputbox not keying value
  145. UI and Cell Event Routines?
  146. Attached sheet as Email Body
  147. VBA to change content at the click of button
  148. click a link in a webpage
  149. Excel-VBA
  150. VBA Code to copy only the Pivot Data from a Pivot Table with out Grand Totals
  151. Solved: create worksheets from column values
  152. Solved: Search, Edit and Re-insert
  153. Can I use MD5 encryption in my Excel VBA Project?
  154. Runtime error
  155. VBA: Msg Error if Duplicate
  156. Solved: Listbox, should be simple!
  157. Solved: Tab sheet Name In the Sell
  158. Pivot table filtering according to current year
  159. Click Listbox how to show more picture ?
  160. how to get unmatched records from database tables ?
  161. [Q] Save Sheet Box prompted
  162. Prob with vba code in 2007 and giving error after i installed 2010
  163. Worksheets problem
  164. Excell-PPT shape handling problem
  165. Solved: copy reference without link from copyed file
  166. Append text from adjacent cell to an existing cell for all rows in worksheet
  167. Check Range
  168. Pasting excel tables one after another in word file using VBA
  169. Solved: Extract words
  170. Solved: Use cell value in formula as Dynamic Range
  171. How to make an Excel Macro globally available?
  172. How to access the literal content of a cell, regardless datatype
  173. Urgent Help - Macros to Insert Rows in 2 Sheets simultaneously
  174. Solved: date format question
  175. UserForm text box info passing to cells
  176. Hyperlink and copy sheet based on specific criteria
  177. Find Contents of cell
  178. Solved: Insert New Range Name
  179. [SOLVED:] Deleting text from right side of an individual cell
  180. CODE FOR JOB
  181. Error Handling Stuck in a Loop
  182. how to make an "isletter" class in vba?
  183. Excel to Auto cad block attributes
  184. Solved: check number of words
  185. REAL VALUED ROOT OF A POLYNOMIAL_newton raphson algorithmn_VBA
  186. Sorting a Listbox Data in VBA
  187. Solved: Delete sheets
  188. Last cell in range
  189. Solved: Does this make sense?
  190. Link Excel cell text to autocad text by VBA
  191. Solved: Phantom Pictures/Images
  192. append text file
  193. Return Value from Dialog
  194. index match example
  195. Mark cell as complete
  196. Move data from world to excel
  197. Multiple Row Totals Based On Pivot Table
  198. highlight activecell in combo box
  199. Summary
  200. [SLEEPER:] Worksheet_Change and RTD Link
  201. Solved: unable to get the transpose property
  202. Solved: Hyperlink to folder
  203. running some macros automatically
  204. Hyperlink to folder
  205. Delete all hyperlinks and the associated sheets
  206. password protection difference
  207. [SOLVED:] Automating IE to get data from a website
  208. Solved: sumproduct question
  209. Solved: Exclude Sheet names from list
  210. error code, run time error '424
  211. Solved: Painting cells meeting conditions VBA
  212. Solved: VB to keep all border
  213. Solved: Instructions Following a Called Script
  214. Solved: sumproduct question 2
  215. Solved: Dynamic Drop Down List Freezing
  216. Solved: Creation of Pivot Tables has errors ):
  217. Solved: Populate Combo box with shortened list
  218. Delete the last row that was filled
  219. Variable question
  220. Delete blank row after words and print in pdf
  221. Solved: Simpliest Way to Reconcile Checkbook
  222. Solved: Reference a Range in a different Worksheet
  223. Solved: IsNull Function Not Functioning
  224. [SOLVED:] Need to extract a few items from 250 XML Files in a Tree View, to a Spread Sheet
  225. Initialize Multiple Textboxes
  226. Add new items to list
  227. Userform Dynamic TextBoxes/Labels/Checkboxes and SQL Insert
  228. Help Me!!!
  229. [SOLVED:] Text to Columns or something similar
  230. [SOLVED:] Regular Expression Replace
  231. Top 20
  232. "Freeze" some rows with highlighting
  233. Solved: Syntax Rectification Required
  234. Solved: VBA code for removing blank cells in a list
  235. Need help with VBA code for hiding across multiple ranges
  236. Multiple Sheet Consolidator into one MasterSheet
  237. Solved: Action code 2 only in cells
  238. lookup or match
  239. filter, select and mail search results
  240. Restrict two macro run at same time
  241. Inside ListBox Sorting Problem..
  242. Macro Menu
  243. Recquired Conditional VBA solution for moving data as per diffrenet cell value
  244. =today(),now()
  245. Solved: How to have function run on both tabs
  246. Count no. of item copied.
  247. Solved: Returning a value into a textbox without Decimal Places Shown
  248. Sleeper: Conditional VBA solution for moving data as per diffrenet cell value
  249. Sort columns based on named range
  250. Solved: Copy Worksheets Based on &quot;View&quot;