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 168 169 170 171 172 173 174

  1. Using Vlookup between text file & spreadsheet
  2. Solved: Sheets vs Worksheets?
  3. Dynamic charts
  4. Running on the web
  5. Solved: Insert dash in password
  6. Solved: where am i going wrong?
  7. find the text in the cell in column A within the text in column B in the same row
  8. Solved: Need to modify a complex formula in excel 2007
  9. VBA Code help- Paste to next empty cell in another worksheet
  10. How to divide the window screen?
  11. Convert Excel Geographic database to Google Earth KMZ file
  12. Sleeper: VBA Needed to extract from raw data and summarize employee data by project
  13. VBA Needed to populate employee data from data dump
  14. Title and ribbon bar
  15. How to use On Error
  16. Solved: Need to correct this excel formula immediately
  17. There is not enough memory to complete this operation
  18. Exporting into XML from a sheet, and then updating an another sheet using a XML file
  19. Autofiltering data in several sheets and pasting to file with same name as criteria
  20. Msg Box pops up many times
  21. How to retrieve Value in Frame in user form
  22. Automatic Conditional Highlighting Column
  23. Extracting strings from a string
  24. [SOLVED:] VBA needed to extract data from specific cells in different worksheet
  25. Looping thru Multiple Comboboxes
  26. Automatically print certain pages of pdf
  27. Unhiding the 1st two columns in an excel spreadsheet
  28. Compatibility and VBA dropping out
  29. 'Search Engine' Help: String with 2 values
  30. Copying Merged & Unmerged Cells
  31. Solved: Find cell with text and delete if it matches with next one
  32. Importing "relevent" data from excel columns to word doc?
  33. Solved: Runtime error
  34. Solved: VBYesNo Help
  35. vba to cut row to different sheet
  36. average range of data with missing cells
  37. Excel to Sharepoint
  38. Solved: Compile error: sub or function not defined
  39. Help needed Run-Time Error 13: Type missmach
  40. Not able to access elements on a web page
  41. Solved: Check if number has a asterisk
  42. Copy specific tab into wb
  43. VBA Code To Click Button On Web Page
  44. Find term and paste row help
  45. Solved: copy a range uniqe with out empty rows
  46. Solved: Application.Ontime Assistance
  47. Correct NPV function
  48. Help me on this issue....
  49. Solved: Parse a string to Range
  50. Macro to hide blank columns (disregarding header)
  51. Extract Sheets from Workbook
  52. [SLEEPER:] Subtract 30 minutes and round
  53. Need VBA code for selecting row that meets 2 criteria
  54. Find Method (Skipping Rows)
  55. Solved: How to add few sheet name
  56. Problem with code
  57. show a tab when a particular worksheet is activated
  58. Copy two sheets (or more sheets) data into new sheet
  59. TreeView, selected element and all below
  60. VBA Needed? Auto populate cells with hard-coded value
  61. Solved: MODE function to display the most common value present in a particular range of cells
  62. Solved: Change event simply not working
  63. highlight the row after I input something in column a
  64. multiple select combo box
  65. Need to modify a User Defined Function
  66. How implement a summary chart for my Codes below??
  67. Running command button from another workbook
  68. Forecasting
  69. Date function error
  70. How can I write a loop to clear cells evenly spaced apart?
  71. Passing a cell to a sub routine
  72. For loop to fill textfields
  73. Get Specific Cell Values from another Workbook using VBA
  74. Print sheets based on filtered results from multiple workbooks
  75. Code not working when click button is moved
  76. How to solve my combobox bug in Excel-Vba?
  77. Print to Word
  78. [SLEEPER:] Connect to oracledb and export excel file to oracle db
  79. Prevent Restore Down
  80. [SOLVED:] Setting a cell range then hiding rows with a certain value.
  81. Solved: If ... then find next cell where Len() < 2
  82. I can't seem to get Recordsets loaded with data from SQL Server 2008 Express...
  83. Solved: Macro showing subscript out of range
  84. Solved: VBA Help Remove first Character
  85. HELP! Need code to Update and Get new information
  86. Trigger code on cell input
  87. need to find last active row in EXcel
  88. Change comment properties XL2003
  89. Sum values
  90. Solved: Suggestions on Determining the max and min values of a sine wave
  91. pleace help me sort my table.
  92. VBA to Access General Code
  93. Extract values from Text files to Excel
  94. Solved: Userform looping & adding 2nd record to database
  95. Open and Hyperlink in IE and Save as HTML
  96. Is this possible ?
  97. Solved: Help: Need VBA to Copy Each Autoshape Hyperlink to Another Cells
  98. Retrieve data from database onto Excel cells
  99. disable certain cells based on a value of another cell
  100. Solved: automatically select 'Don't Save' if message box pop up
  101. Solved: Inte problems under MSOffice 2010
  102. Export All Excel Charts as Pics to Outlook
  103. Auto filter with protection on
  104. Solved: OLAP Cube issue with Excel 2010
  105. macro help
  106. How to insert a wait timer in for loop
  107. Scraping website
  108. Solved: What is the diffrence between Private Sub and just Sub in a macro
  109. Macro to create variable range sizes to be used in an averaging function
  110. Populate cells based on dropdown selection
  111. Sleeper: Save the workbook without Macro
  112. Runtime Error 9: Subscript out of Range
  113. show formulas in Excel Vba
  114. disable cells based on time
  115. Solved: Copy Multiple sheets with filtered value.
  116. Solved: Change font colour when string found
  117. VBA Replace
  118. Check the status of the HTML form submitted using Excel
  119. Solved: Importing multiple .emf files into excel 2007
  120. [SOLVED:] Controls array
  121. Solved: RowCount
  122. Inserting data from excel to word files?
  123. Verify data is the same or not
  124. Using Office Web Components/Controls in Excel 2010
  125. Solved: Delete Only Visible Rows in Table
  126. "shell" not work in Excel ?
  127. Lock Ranges (Excel 2007)
  128. Add two rows of text in the end of my documents
  129. Solved: open xlsx file with part of name
  130. Solved: Macro to delete duplicate rows on condition
  131. get data from Access database onto Excel
  132. Subscript out of Range
  133. Macro to automatically update variable ranges?
  134. Re-arrange data based on their group
  135. Another Conundrum
  136. read textfile
  137. Find a worksheet by name
  138. SubString help
  139. Read data from a website
  140. Duplicate RowLabel data range between two pivottable
  141. data sorting macro question
  142. Links updates and split workbook CSV
  143. use VBA to covert .xls to .xlsx
  144. Combine specific worksheets and columns with modified generic code
  145. Merge data
  146. open as read only no save prompt
  147. Solved: count the number of ";" in cell
  148. Solved: highlight entire row when click and during editing
  149. Converting Euro Number Format using Substitute Command
  150. Solved: Please help me compile this code
  151. getting data from Access at specific cells of the worksheet
  152. Solved: Chart Labels need to be dynamic?
  153. Solved: Column selection not working properly
  154. Solved: Workbook_beforesave saves file twice
  155. Change pdf name
  156. Solved: fill up cell background colour
  157. Solved: Select from lists
  158. [SOLVED:] Insert button for upload documents
  159. Solved: Last weeks date
  160. sort and paste macro
  161. Solved: Sum a column based on two column values
  162. Solved: Program is slow
  163. Solved: Run macro after leaving a cell
  164. Linking worksheets
  165. Solved: Passing Arrays into Functions problem
  166. copy & paste from webbrowser.
  167. Command button: copy and paste in next available cell on another worksheet
  168. Macro an Outline based on value o:
  169. Sleeper: Urgent Help needed....
  170. [SLEEPER:] Problem with adding OL task code
  171. Activewindow Zoom
  172. Conditional Cell Location
  173. Solved: find/replace in protect worksheet
  174. Updating records in Access from Excel
  175. Solved: Copy, merge and save to a new workbook
  176. Complicated SUMIF situation ):
  177. Solved: Creating multiple charts formatted the same
  178. Set x = CreateObject()
  179. Help With Vba Code! Please
  180. Solved: verifying password in txtbox
  181. How to use datavalidation in VBA
  182. Code will protect but not unprotect
  183. Remove middle characters?
  184. Combining Sheets into one table from different excel files
  185. Solved: RibbonX - Label update
  186. Solved: Part of macro to work from renamed file
  187. VBA to check Range then move if true
  188. ComboBox
  189. Help with "Protect cell or cells on sheet and protecting sheet
  190. Solved: VBA and Macro Tutorial
  191. Create Own User form
  192. Filtering many pivot tables based on one pivot table
  193. Solved: "Cancel" selection causes a break in flow
  194. Solved: Problem Using If Function in VBA
  195. Solved: shorten this code
  196. help with search code on Search and Report All Occurrences of a Word
  197. Loop through multiple columns and rows at once.
  198. k = 5 + 6 + 7 + ... + 14 + 15
  199. VBA code for Excel forums
  200. Solved: scrollbar zoom
  201. Solved: How to reset Drop-Down (combo box)
  202. Solved: Copy selected filtered sheets to a new workbook
  203. Problem with sheet protection
  204. [SOLVED:] Delete shapes before replacing
  205. HELP! what is wrong with my code :(
  206. Excel 2010 chart's error
  207. Solved: Insert text selected from a combobox into cell
  208. Code to operate within the code window?
  209. Help With a Simple Code Please!
  210. Need Hlep with VB Excel Macro Please
  211. Solved: Controlling Data Entry
  212. [SOLVED:] Draw precedent arrows for formulas in a range
  213. Maximum Comment Line
  214. Solved: Userform
  215. Adding multiple series to a graph
  216. getting data from SQL Server to Excel and vice versa
  217. Pivot chart help
  218. Enabling "undo" on "time stamp vba code"
  219. Solved: validate data
  220. Empty Array gives Run Time Error 13 Type Mismatch
  221. [SOLVED:] Change font size.. etc from excel to word
  222. Solved: User Must Fill Certain Cells before Closing
  223. [SOLVED:] Cell C3 changes Textbox
  224. Sleeper: UserForm ComboBox using data
  225. Solved: Call Function by name contined in String Variable and Return Value
  226. Solved: Retrieve a value from the last cell and post it in a textbox
  227. SAP to Excel
  228. Check for new highs in dynamic updating cells
  229. PivotTable Annoyance
  230. Shift up data according to group ID
  231. Solved: Problems with code when not in compatability mode
  232. shapes in Excel VBA
  233. Solved: Username not updating
  234. Excel VBA works inconsistently..Help me please!
  235. Importing Data
  236. Solved: Userform Event (SOLVED)
  237. Solved: Print Data into Form
  238. Solved: User Form Control issue
  239. Macros in Excel
  240. Reference workbook cell to another workbook
  241. Solved: VBA Index/Match Help
  242. Cut&Paste to another Worksheet Based on Cell Value
  243. Multiple Selections for Data Validation - without Macro
  244. Excel manual subtotals
  245. Solved: Save as date
  246. Solved: UserForm event 2
  247. Macros in Excel
  248. Find column (in Excel address) of matching value in array
  249. Copy Images within Selected Cells
  250. Solved: Before Close