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