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

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