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

  1. Help With the VLOOKUP
  2. Formula Trouble
  3. Is it possible to auto-calculate as well as autopopulate a graph
  4. Macro for gantt chart update
  5. Solved: String Question
  6. VBA to find a directory
  7. copy data from excel to word without mail merge
  8. Solved: Non-VBA Solution: Identify Text String from Table and Return Text String
  9. Set to default browser
  10. Copy, Paste Special and Insert
  11. Solved: worksheet change event
  12. Solved: Detecting a Running Application
  13. trim & dates
  14. Solved: Copy based on multiple condition
  15. Code to print folders, subfolders and files
  16. Solved: VBA alternative to a look up table
  17. Solved: Calculation of an UDF
  18. What's wrong with this code?
  19. Excel 2007 find last column in table
  20. Make a cicle
  21. Solved: Challenging Question* Need excel macro to send email based on a choosen number
  22. Solved: Mysterious macro running on Excel file close?
  23. COMPARE 2 XL WORKBOOKS & PASTE DATA
  24. CTRL + Break
  25. Solved: Cells vs Range
  26. Rich Text Box
  27. Using wildcard in folder name
  28. [SOLVED] List data
  29. Solved: CheckBox Help
  30. Basic question on cell comparison
  31. Conditional formating of rows
  32. Scrollbar controlling several Textboxes?
  33. OWC11 Spreadsheet component Undo Error
  34. Lookup Macro Help
  35. Print active sheet from printpreview-excel 2007
  36. Solved: SUMIF attempting to interrogate cell properties in "criteria" portion of the syntax
  37. VBA Code to check if shared document is locked for editing
  38. If blank column, paste to the next column VBA
  39. Excel VBA for creating Folders
  40. request for complex examples for combination of function
  41. Solved: excel 2003 conditional formatting
  42. Refresh Sheet1 or workbook periodically
  43. Solved: Delete Row based on Column Criteria (with looping)
  44. populate combobox using array
  45. Add lines in excel comments through VBA
  46. Solved: When a row inserted, add one to highest Value in Col N, & add -1 to Col B value
  47. Print Visible data rows
  48. Can I block an .xlsm from being converted when it's open in Excel 2003
  49. "Out of Memory" error thrown when Formula contents length exceeded
  50. Solved: Programmatically naming an offset cell....
  51. Filter several pivot tables for same value
  52. Blank Columns
  53. Solved: Autofill formula VBA needed
  54. SOLVED: Send email using vbs without attachment
  55. Solved: Userform value problem
  56. count instances if within 30 days
  57. Get javascripts from a URL with VBA
  58. Detecting the class in a span
  59. Reading Data from Excel 2007 (?????)
  60. Replacing columns and rows default names
  61. Solved: Is it possible to enter a UDF into a cell and replace it w a native Excel formula?
  62. Collating data into a consolidated view
  63. Formula Update
  64. Solved: how do I save an xls as an xlsx after changes are made in VBA?
  65. Array help
  66. Solved: Need Zip code `
  67. Why doesn't this work in a loop?
  68. Compare one number with list of numbers
  69. VBA Module
  70. Modify code to run on multiple files
  71. Autofill issue
  72. Solved: What is wrong with this code???
  73. Solved: Cell Value As String
  74. Append data in master file from 4 different files
  75. Solved: Restrict Special Charachters
  76. Very complicated, copy and paste sheets in a loop
  77. Solved: Change Path -- ActiveWorkbook.path
  78. list all running programs
  79. Copy to last row with unspecified column
  80. Solved: Cell Reference
  81. excel connection
  82. Simple question...
  83. Sum columns in table excel 2007
  84. Copy Array of Values
  85. Problem with Changing formula
  86. Get Cells to flash based on a condition
  87. Solved: Adding conditional formatting VBA
  88. Solved: Message box for offset column
  89. Open Gmail
  90. Solved: Floating command bar position
  91. LOOKUP?? how to find data (stuck on project..please help)
  92. Solving a problem within VBA without using solver
  93. Solved: Delimiter saving each tab to its own .txt file
  94. HyperLinks to specific Location in another App.
  95. Solved: download complete
  96. Carriage Return Quote Delete Macro
  97. Solved: Emailing From Excel Using an Outlook Template
  98. Help from Guru needed
  99. Solved: get all the names in the column
  100. UDF randomize an array
  101. Macro to trim and convert in excel
  102. Solved: Print Settings
  103. Looping through workseets issue
  104. Solved: cutting date into variables
  105. Need quick help with some VBA issues (image sizing)
  106. Multiple If statements in 1 column
  107. Help With VBA in Excel ? Writing a function using probabilities ?
  108. How do I Insert 2 or more rows with a copy from one other row?
  109. Split Cell Content Into Two Columns
  110. Sharing a macro that is created by me
  111. Solved: What's wrong???
  112. A Short Formula Please - Excel
  113. iterate till equilibrium reached
  114. Solved: variable ProperCase
  115. Solved: Address
  116. Solved: Match Name find Row No then copy values to sheet2
  117. Solved: VBA Code, who can help?
  118. Solved: Embedded Spread Sheet
  119. Macro: look up another field and pull the data not matched
  120. Created a Drop Down Box based on certain criteria!
  121. Solved: InputBox Help
  122. Solved: How to Throttle SMTP Traffic
  123. How to delete a Empty column?
  124. problem with excel 2010 slicers
  125. Solved: Code for vba to replace below formula
  126. Solved: Data Validation List shortcoming(s)
  127. Form position
  128. Solved: How many substrings returned by Split() ?
  129. Solved: CNTL + N
  130. Solved: Total sum of Time in a column
  131. looking for value position in table
  132. Solved: caption SaveAs location
  133. on change event according to pivot table
  134. Does VBA Lose Variable Definitions and/or Values between Subs?
  135. excel - checkbox
  136. Solved: Label display
  137. Solved: conditional formatting
  138. Solved: Set Msgbox with Default number?
  139. Solved: Add a WebService reference to an Excel 2010 sheet
  140. Compare dtmDate with a value in column A
  141. Data Validation C2*D2 = E2
  142. Modifying Code for Whole to Flash
  143. Change all pivot table data sources
  144. Generating one .TXT archive from the Sheet.
  145. Solved: Activate certain sheet based on cell content
  146. Control Inputbox as number only?
  147. Copying the entire workbook to a new workbook
  148. Check Cell for Blank
  149. Solved: Macro's slowing down my spreadsheet
  150. Override the built in SAVE
  151. Application.Volatile Method
  152. Need some newbie help with Cell validation
  153. Solved: Click on protected sheet
  154. Reordering rows where sort is not effective
  155. set calendar to open at a specified date.
  156. Solved: Not sure how to fix this loop? Help Please
  157. Forgot the password I gave to protect a part of sheet
  158. Error: Object Variable or With block variable not set
  159. Userform Validation - Unique Names & Numbers
  160. Can anyone improvise this data and chart?
  161. Which FileFormat code (enumeration) for XL 97-2003 ?
  162. Data Validation - "A" and 2 number and 2 letters
  163. Solved: Fill by number of rows
  164. Macro: Need to find all unmatched Data
  165. Solved: Delete row if default value
  166. Assign Value to Variable Type Range
  167. Solved: slow macro
  168. how to use VLOOKUP only for blank cells in column A
  169. Excel VBA Access
  170. Lock Cell Format?
  171. Solved: Open workbook to last Friday of current week
  172. Solved: Unable to change the name of this cell
  173. Solved: display worksheets in combo box except...
  174. ref range to replace sheet name
  175. Solved: copy worksheet with referencing old worksheet
  176. Macro's for printing
  177. Convert String To Date
  178. Solved: General questions on excel objects...
  179. Messagebox to remind user of 12 day limit
  180. Solved: Loop with Go to steps?
  181. Getting a 0 When Dividing
  182. Loop through folder of Excel files and copy sheet from one set into another
  183. Macro: Move Cells where QTY is in upper percentile
  184. Solved: An error with setting a wb. Why?
  185. Solved: copy and rename sheet in sequential order
  186. Lock Cell after value updates to specific value
  187. Select sheets based on name
  188. Loop web query
  189. Solved: How to import multiple sheets from different files in same folder to main workbook
  190. Creating an OnClick event for an autopopulated userform
  191. Writing a .CSV file (.txt) from a Sheet
  192. Solved: Delete Row Based On Value
  193. Solved: Shortcut to run macro
  194. Set a value from different sheet in other sheet
  195. efficient way of comparing whats already in a collection
  196. Solved: Summing to a target
  197. Want to use vb YES/NO question box
  198. .xlsm row restrictions?
  199. Copy And Compare vs Switch And Compare
  200. xlt question
  201. Solved: Dynamic Procedure call
  202. Find and delete
  203. Embedded Spread Sheet - Span to next page
  204. Loop A Script
  205. Solved: Hide/Show Rows based on % character in cell
  206. Macro names changed in V2007
  207. Print Macro and Cell to Populate from table Help!
  208. Solved: Excel keeps freezing for about 5-7 seconds
  209. Solved: Excel VBA to select rows after Pivot Table
  210. VBA to automatically run
  211. Solved: Test for empty directory - odd result
  212. Solved: Formula to return latest date
  213. Solved: Display following year in combo box
  214. Can you force code to run in order?
  215. Eliminate unwanted data...
  216. Macro help!
  217. Split Text file data
  218. Solved: Why i get Vba Error in this code??
  219. Dynamic Array
  220. data validation - number or number / 2
  221. Solved: Calendar pop up with date AND time
  222. Linking 2 Combo Boxes Together?
  223. Not Sure How To Title This
  224. Font red and Bold specific dates returned on email sent.
  225. auto set page break to last row with data
  226. Solved: Making Scripts More Efficient
  227. Help on merging wbksheets
  228. Format Percentage Problem
  229. Excel Lookup Problem
  230. Can I use vba to set page breaks and fit the sheet’s data to 3 pages?
  231. Solved: Lose formula reference in active cell
  232. Read date and time from active cell to a date picker
  233. Solved: Display logo pasted to worksheet as icon on desktop shortcut
  234. Solved: Add name to combo box
  235. Solved: "If FileExist" isn't seeing the file
  236. dissable richt click page setup
  237. Hovering text not disappearing after click
  238. Solved: select previous sheet that I viewed
  239. Integer & String
  240. Solved: Relying on Exit Sub too much
  241. Solved: create notepad
  242. How to Lookup data from different sheets to single workbook
  243. Solved: IF Statement doesn't work
  244. Solved: Date format changing when pushed to SQL Server
  245. Solved: Delete rows if cells in multiple columns are blank
  246. Generating a simple report based on some criteria
  247. Remove conditional formatting but keep format
  248. Solved: VSTO
  249. User Form
  250. Change cell color from user form