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

  1. Combination
  2. Solved: Excel VBA changing case
  3. Equalities
  4. Get Data from Closed Wrokbook based on Criteria
  5. Conditional format an indentation based upon a formula from separate cell
  6. Solved: create html code from parsed xml data on worksheet
  7. Send email when changes made
  8. hyperlink
  9. Solved: Cdate in range form number => date
  10. Compare 2 VBA Projects (code)
  11. Get details button from a data.
  12. How to speed up this macro? How to use an array?
  13. Split sheet to different files - variable number of rows
  14. Solved: sort data on cell by value order
  15. Solved: Find and Replace not working
  16. click and move
  17. Applying code to entire column
  18. Simple multiplication
  19. Loop until found / user cancels
  20. Solved: Adding another code the original VBA code (Excel 2003)
  21. Export to text file
  22. Macro to combine output of two sheet into one
  23. Speed up a slow code
  24. serial search
  25. Foreign language
  26. Solved: Trying to create a text box in word from excel
  27. Reading/writing MP3 properties with Excel VBA
  28. Excel Calender
  29. Add the file name in the header of the PDF
  30. CrePivot Table To Show All Value/Field Columns
  31. Solved: Updating Data Multipage 2 to Page 1 Combo box
  32. Sort By Value In Cell
  33. Solved: Average if
  34. Shortening VB Code
  35. Merging Cell EntireRow.Insert Excel 2003
  36. Merge all data in 1 cell with format
  37. VBA email - MERGE addresses
  38. VB Code help on Worksheets
  39. Import specific cells from a website table
  40. how to write a vba code to perform complex calculations
  41. Solved: where to put end if
  42. compile error
  43. Paste the file names in a excel sheet
  44. Sumif for text + concatenation
  45. VBA pulling data from a table
  46. Solved: Condtional format but if Cell next displays "Y" condtionalColour should White
  47. Solved: Conditional Formatting Help excel 2003
  48. Solved: Run a macro by refernce to a cell
  49. PasteSpecial
  50. Search in every column for a value in a specific row, then insert a column before IF
  51. FindNext
  52. Solved: Run code when workbook opens
  53. Filling Arrays
  54. Find all possible paths in a Flowchart
  55. Comparison
  56. Solved: Referencing objects
  57. Solved: Select the last used row in a column using VBA
  58. Dates
  59. Excel 2010 VBA Insert new row changes formula
  60. Need Macro to create a Format
  61. Solved: locked method of range failed
  62. How to save webpage as html to drive
  63. Solved: UserForm Radio Buttons
  64. Create blank lines between all current
  65. VBA AND XML
  66. Copy data to Master file from Different Sheets
  67. VBA for Dynamic source data for charts
  68. 3 pairs of If and end if
  69. add message to macro
  70. auto populate with cell change event?
  71. Excel Phonebook
  72. Hiding multiple non-contiguous rows simultaneously and quickly
  73. Solved: Fine Tuning an Application Event
  74. Formula In Entire COlumn
  75. Understanding brettdj multiple goal seek code
  76. Solved: Cell Name as a variable to feed
  77. Solved: Highlight row based on cell value
  78. run Time error '76 -looking for files within Sharepoint
  79. Solved: using array and column data to creat new sheets
  80. Converting Access SQL to EXCEL SQL
  81. NOVICE QUESTION: Referencing Integer Arrays
  82. Solved: Excel Functions VBA
  83. search and count values
  84. auto select
  85. Hide and Unhide rows based on the condition set
  86. backup of file with date
  87. Solved: Borders on a Range of Cells
  88. Multiplying cells in a range only if they have content
  89. Macro - transpose - audit
  90. formula copy
  91. Solved: worksheet event does nothing
  92. Solved: vbs creates .xml from folders - how to run excel macro at end
  93. Solved: Avoid Screen flickering and selection
  94. cell blinking
  95. Solved: Inserting a formula with VBA
  96. Hidden ActiveX Controls Disappearing
  97. Arrange Images relative to each other
  98. Question about Slicers
  99. Solved: Make text in a cell bold
  100. Solved: VBA Code help.
  101. Find and Replace of Formula Result
  102. pivot table automation
  103. extract data from multiples excel files
  104. unable to set focus
  105. userform combobox requirement
  106. Solved: Delete Unused rows in a table
  107. VB ClearContents if add-on (Excel 2003)
  108. Solved: Save as and File Directory
  109. Solved: Create Monthly Calendar using Userform
  110. Converting conditional format to permanent and reference to shapes
  111. Solved: Writing data from workbook to text file
  112. Array function
  113. Real challenge from my professor
  114. VBA drop down and he internet
  115. Excel 2010 fuzzy vlookup add in
  116. Assign Keyboard Shortcut to Ribbon Item Excel 2007
  117. Next and Prev. command
  118. need help with a code
  119. improving class modules with syntax sugar
  120. Solved: Delete Empty cells with condition
  121. match or vlookup help
  122. Dont Change Folder/Zip File after Zipping & Unzipping
  123. Transpose Range on Key
  124. ListBox Index Select
  125. expired workbook
  126. Solved: Producing multiple spreadsheets by running data from excel database
  127. Solved: copy data to another spreadsheet
  128. Solved: Interchanging data on different sheets
  129. Assigning macro to print button code help
  130. Solved: whats the difference
  131. Calculate Correlations Based on Changing Parameters
  132. Plotting an arrow in excel using VBA
  133. Frequently bought together
  134. Cell copy the data to another cell with offset
  135. Solved: UF Count Tally
  136. Error using .Find across worksheets
  137. insert row above button (retrieve position of button)
  138. How to analyze and sort data using VBA
  139. pause and continue
  140. Help with Excel & Office Web Component!!
  141. Solved: Open Txt File and Copy data
  142. Write Hebrew characters to file in VBA
  143. Problem with OnAction
  144. The active cell in a sheet other than the active sheet (VBA Excel)
  145. Pesky users, causing issues with userform
  146. Solved: Help with Pivot Tables
  147. Solved: Extend Range selection Down
  148. Look up values through hierarchies
  149. Solved: Find Last Used Cell In a Table
  150. sumproduct help ..
  151. Solved: Find a string and align left
  152. Data Validation List
  153. Workbook Parameters compare
  154. OnTime Problem ..?
  155. Solved: Looking for a more 'flexible' Match()
  156. Error when set value to an worksheet object
  157. Date Tranformation
  158. sum of mismatch records
  159. Problem in adding record using macro
  160. Solved: merge blank record in first column
  161. Shade Weekends in Calendar
  162. Solved: Find final Row In Mearge TOP Cell
  163. Unselect missing line in "References VBAProject"
  164. How to stop a specific VBA loop??
  165. Solved: Option Buttons in Multipage Form
  166. VB+Excel help
  167. Solved: Choose a folder in a directory if found.
  168. Adding Data Rows into excel using user inputs.
  169. Add value in empty cell always same line column after column
  170. Count of distributors based on criteria
  171. Worksheet_BeforeDoubleClick is not invoked
  172. Solved: Modify Copy to spreadsheet
  173. Autoupdate Dropbox Values
  174. I feel Computer Illeterate
  175. Select column and row(s) and change format
  176. Check Box Issue
  177. Recall data to my userform
  178. populate combobox when workbook is open
  179. Date and time calculation
  180. VBA to logon to Webpage (JSP)?
  181. Import data from website
  182. Combine Data that obviously the same
  183. Solved: Quintiles and Conditional Formatting
  184. Solved: Trim extra characters from Column F
  185. Solved: SumProduct Help
  186. Error of Advanced filter, copy & paste from different worksheets using 1 cmd button
  187. Solved: Using ElseIF
  188. Force user to enable macros
  189. Solved: Blank cells
  190. Solved: More on SumProduct
  191. Solved: Expression not running all the way through
  192. Solved: Paste block of data into certain cells
  193. Allow Group/Ungroup on protected sheet
  194. change the (Worksheet_Change) event for a module (Sub).
  195. Solved: Need help with adding yes/no msgbox to Find Procedure
  196. edit values of a cell through textbox in a user form
  197. Solved: color
  198. replace text/integer within a formula
  199. Solved: Excel VBA Code for higlighting Pass Or Fail profile
  200. Locking Cells
  201. Solved: Macro embedded in workbook
  202. Formatting not alligning properly on macro run
  203. Solved: Delete Duplicate Colums
  204. How to go through a list on two different worksheets comparing values using VBA
  205. Delete all rows under a group
  206. COUNTIF formula with text color
  207. Solved: excel can't calculate formula
  208. VBA Print Range
  209. Obtaining the standard deviation of a range in vba code
  210. Updating Linked Data
  211. Solved: Sheet Protection and Clipboard
  212. Edit macro to pull from column instead of line in macro
  213. Close messages
  214. Extract missing digits
  215. Lookup and Match data
  216. Comparing spreadsheet - VBA almost working..
  217. [SOLVED] Deploying Add-in
  218. Show / Hide part of Tabstrip or Multipage
  219. ActiveCell.Offset in a Data filtered sheet
  220. More Robust Directory List Generator?
  221. need help with simple macros
  222. copy cells to one page from others
  223. Same ComboBox Value to show in 3 other ComboBoxes in Seperate Userforms
  224. How to disable Paste Special->Keep Source Formatting - Excel 2010
  225. Collecting Data
  226. Solved: Close and re-open
  227. userform combobox error
  228. Use PlaySound and control left/right volume independently
  229. VBA Code to copy required data into Separate Sheet
  230. Sum x number of rows
  231. Minimise use of SELECT in macro copying data from one sheet to another
  232. Extract substring
  233. Solved: if-else query
  234. Solved: problem with sum product formula
  235. Auto Email
  236. Solved: How to perform code on all pages except first one
  237. Multiple columns into multiple rows
  238. read write format text files
  239. sort by upcoming date 60 days from today
  240. Solved: combine data from spreadsheet help
  241. find number of work days in month
  242. Remove Duplicates by Date Range
  243. Store Value in A temporary Variable
  244. Solved: Search Through Subfolders of a Selected Folder
  245. Solved: Creating folder with drive selection.
  246. split workbook into 2 by criteria
  247. Find Function - ONLY find what is specified
  248. Solved: Using Dir()
  249. Solved: Formula to extract string help
  250. Solved: Convert formula to Macro; find closest value and return adjacent values