PDA

View Full Version : Excel Miscellaneous


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 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270

  1. Complex Automation Possible?
  2. Text and formula in same cell
  3. Quick check prior to DELETE sheet
  4. Validation Data
  5. Minutes to hours
  6. Avoid Value error
  7. Name from list to be same on other sheet
  8. Copy from multiple workbooks to create a consolidated worksheet
  9. Time delayed macro
  10. Excel Template change to auto naming on openning .xlt
  11. Setting up "crawl"
  12. I want to use the last value in a column for a formula
  13. Autofilter on more than one sheet
  14. Creating a dynamic summary page
  15. I got a Problem. Please help.
  16. Inserting Rows on a Protected Sheet
  17. countif question
  18. Shared Spreadsheet Won't Scroll
  19. Matching Data
  20. Can I use a symbol in an IF formula?
  21. Activecell
  22. Formula to return a corresponding name left of the number.
  23. Merging Data
  24. Comparing Values
  25. Search for data across multiple workbooks
  26. Conditional formating.
  27. protecting text from edit in fillable forms
  28. Formatting
  29. Formulating Different Start/Finish Dates with Man Hours
  30. Tab wont scroll along and down rows when sheet protected
  31. Exclude rows from Autofilter!
  32. Assigning the range of a cell a value
  33. Multiply each cell by 1000
  34. sumif question
  35. Concatenate Between Entries
  36. Formula
  37. Adding username to header
  38. Compile Error
  39. Row Height
  40. How to call a form from excel?
  41. Formula to calculate hours worked
  42. Create worksheet for Renting vs. selling a home?
  43. Leading Zero
  44. E-Mail and Multiple Work SHEETS
  45. Adding the same cell in 50 sheets
  46. Problem wirh #VALUE! error
  47. Fantasy Baseball Spreadsheet
  48. Print exel data using okidata printer
  49. Subtotal/Grand Total Problem
  50. VBA Book Recommendations?
  51. Dynamic Named Range - Moving
  52. Trim oldest entries from text file to allow for new
  53. Counting calendar days, omitting holidays
  54. Selecting sheets in a macro
  55. Pop up comment boxes (but not)
  56. making buttons
  57. Minus figures when using time
  58. Problem with hyperlinks and file paths using Lotus Notes
  59. Any way to open S/Sheets faster over WAN
  60. sorting a list box
  61. Deleting posts???
  62. Locking single sheet in workbook
  63. Multiple Sheets into a Summary
  64. SUMPRODUCT Question
  65. Sample formula
  66. warning message -- update queries
  67. Excel and DSS
  68. assigning consecutive value automatically
  69. Rounding up in Excel
  70. Converting time
  71. Pivot Tables
  72. Changing cell color with an IF statement
  73. Conditinal formating in excel 2007
  74. Match Last and First Name then copy hours
  75. Can I show multiple rows of worksheet tabs
  76. Creating a summary sheet
  77. Updating cells without using worksheet change event?
  78. Formating Question: Placing data from 1 column to several
  79. Excel Date Formatt Issue
  80. Free Rotate Picture
  81. Reading Websites Through Excel
  82. Grouping on left side?!?!
  83. Conditional formatting
  84. Correl Function Confusion
  85. Condtional Formatting with LIKE operator
  86. Format + cell protection
  87. can you create a list from a look up
  88. currency converter
  89. Validation formula
  90. Convert percentage into specific numbers
  91. Button to run a macro
  92. Grouping all values based on a specific Minimum
  93. Excel Function Search - Hide
  94. excel v data bases
  95. Blue screen on workbook open
  96. Pivot Tables
  97. Summarizing Multiples Tab onto 1 Tab
  98. Deleting data from multiple files
  99. Search Text Field
  100. Sumproduct - text
  101. Resizing Text Associated with Checkboxes
  102. Copy just the order number from another Cell.
  103. Data pasted from Another APP
  104. Help with a tab reference/lookup
  105. List Worksheet Names
  106. Worksheet name + Cell
  107. Parsing Month, Day, Year
  108. Conditional Formatting
  109. Months in Cells - change every month
  110. Don't Count Cells Colored Red
  111. Function
  112. Project Tracking Help
  113. SUMIF Assistance...I think
  114. Excel and outlook
  115. convert hyperlink to text
  116. Making a time sheet
  117. Hyperlinks in Cells
  118. Formula to add up cells with certain characters
  119. conditional formating
  120. generate graphs for each row
  121. Making file size smaller
  122. Seperating Name Field into First Name and Last Name
  123. Excluding rows from autofilter?
  124. automatically format cell based on another cell's format
  125. Need help with COUNTIF method
  126. Adding Data after Drop Down
  127. 'Home Key' Function
  128. Pivot Table order problem
  129. if statement to identify UpperCase items
  130. Function Question
  131. Auto deletion of rows in Excel 2003
  132. Searching for Hard Format Codes
  133. How to have one cell return abbreviated text from another cell?
  134. IF this THEN.....that!
  135. Using drop-down validation category to autopopulate another worksheet
  136. Function / Formula Help
  137. Need Macro to change list of name.com to hyperlinks with http://
  138. Pivot Table Help
  139. If statement to display color
  140. IF/ELSE Statement
  141. formatting datetime, US vs. UK
  142. Conditional Summation
  143. IF Contains text, then color....
  144. Add scrolling to a presentation
  145. autofilter giving me jip??!
  146. Calculate weeks between two dates (working Days)
  147. Pivottable, fill all rows
  148. Formatting? problem
  149. Dynamic Ranges Problem
  150. Sending a chart sheet from excel via outlook
  151. Export access to excel
  152. That Excel to PDF thing
  153. Any Excel to PDF pros out there?
  154. Error message at start of Excel
  155. Formula question
  156. retain print properties to all sheets in book
  157. Multiple lookup and multiple results
  158. Help with Formula
  159. retaining cell layout when copying
  160. Need IF statement to report 1 or 0 so I can sum
  161. Workbook_Open() sub
  162. Locking Cell Formats?
  163. Removing All Hyperlinks
  164. Pivot table text colour
  165. Excel reference / conslidate / report help.
  166. Change colour of text
  167. Refreshing data import issue
  168. If Else - Vlookup
  169. Cell Formatting
  170. using the OR function in arrays
  171. Mark up price list
  172. Conditional Formatting for repeated values
  173. Help with using dates in formulas
  174. VLOOKUP a hyperlink
  175. Import Web Query from site with Password
  176. Cash Flow Forecasting
  177. Alter imported data
  178. Column that remains stationary on screen
  179. Simple Number Issue?
  180. How to make a reference absolute
  181. Pivot tables: combining data from 2 columns into one field
  182. generate logarthmic spaced values
  183. Importing data into Excel spreadsheet
  184. Need VLOOKUP to miss blanks
  185. How to store records with more than 255 fields of data
  186. Slow opening of Excel spreadsheet containing VBA macros
  187. Synchronize exceldocuments
  188. Need Help with a Formula...
  189. Language Translation with Excel
  190. Adjustable Rate Mortgage Restrict Range
  191. Stop Excel from Scrolling to bottom of list
  192. Calculate minutes
  193. Sumif formula error - adding two column values together
  194. 2007: Macros enabled but 'record macro' is grayed out
  195. Toolbar buttons disable
  196. Conditional if statement
  197. IF statement w/multiple conditions
  198. Excel Formula
  199. Help with Auto-complete
  200. Macro Code?
  201. Number Conversion
  202. Number Formating Issue
  203. Dbase Files and Excel 2007
  204. Conditional formatting for weekends
  205. transferring calculations from Excel to VBA (to save calculation time)
  206. Formatting Dates
  207. Need help with formula regarding revenue lost
  208. Format cells dialog menu problem
  209. Changing link & formula column
  210. how to copy forumlas between worksheets
  211. Update only sheets
  212. Mystery Dates
  213. Creating UserId from User's Name
  214. Cell Dependaent on Drop Down Help
  215. Help with copying formulas
  216. Help with a Dates question
  217. Excel Pasting
  218. Football fixture generator?
  219. Images moving and resizing when printing
  220. Row height and spacing
  221. Summing based on specified criteria
  222. Index function?
  223. Writing number instead of string to text file
  224. Formula help needed
  225. inputs in select cells
  226. conditional format one column
  227. office web components
  228. Sorting
  229. Formula Assistance
  230. PROPER Formula Meeting With Postcode Problems
  231. question on copy and paste
  232. Sort data in Pivot Table
  233. Automatically display 2 sheets when opening a workbook?
  234. merging cells together
  235. Data Form in a Macro
  236. Tracing the contents of a cell to a sheet
  237. cell color after modify
  238. formula not working the way it should.
  239. Merging data from mutiple columns to one column
  240. Convert 500 Excel worksheets to 500 Access Tables
  241. Autofilter Button Won't Increase..
  242. Does Excel have size limit?
  243. adding area code to phone numbers
  244. Number Sign change
  245. Pasting in Excel
  246. 3 "w" cells,multiply the values next to them
  247. Macro, Array and Hide Problem
  248. list cell problems......
  249. Sumproduct range value
  250. Copy and move file to a new folder: macro