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

  1. Name and row count for every .xls file in a directory
  2. Importing data from multiple workbooks
  3. Change the image size in terms of the value of a cell
  4. Solved: Removing Empty Rows on Multiple Sheets At The Same Time
  5. dynamic Scaling for charts
  6. convert to feet and inches
  7. Help to create an Excel Employee directory by vba
  8. VBA code to find highest and 2nd highest number based in criteria
  9. Chart Series Format Painter
  10. Expire on Set Date - And Prevent Rolling the Time Back
  11. Solved: add additional data to word document's bookmark in excel
  12. Foreign language
  13. Solved: Click to color
  14. Time Format Help
  15. open 'xl*' files from sub folders without naming them
  16. Text Function
  17. Printing text from textbox and other problems...
  18. Fuzzy matching scoring algorithm
  19. Help Whit Userform add and delete data Listbox!
  20. Text Function
  21. To stop the Printing action when certain criteria is met
  22. Solved: help with below formula.
  23. Adding two blank rows between Teams
  24. range name / reference
  25. filter upon color
  26. Counting the Rows including blank ones
  27. Insert Rows
  28. Looping through cells (contents of cell seperated by commas) and performing vlookups
  29. some rows wanted
  30. Excel 2010 funcres reference issue
  31. Find string starting with...
  32. Autofilter 1 column based on multiple criteria
  33. xla working on xp 2003 / xp 2007 - not working on win7 / 2007
  34. Array formula which ignores blanks and duplicates
  35. Copying Multiple worksheets in Multiple workbooks to one single workbook
  36. List of files in directory by date created
  37. Use Excel To Open Word
  38. Code or conditional formatting
  39. Solved: Grouping Modules?
  40. VBA for looping cell change
  41. Workbooks.Add (force XLSX format)
  42. Solved: Check Box Formula
  43. Sum the total value for that column
  44. Solved: view all exceptions
  45. Why is Excel asking me to save......twice?
  46. Solved: Timer Panel\Please Wait userform Help
  47. Select Range to copy Values to
  48. Export to csv based upon date/time criteria
  49. Solved: Macro to Combine Multiple Workbooks into one Workbook
  50. Help in VBA Coding (do while / loop until)
  51. Autofiltering macro - filters text but not the numbers
  52. Internet Explorer Automation: How to handle connection timeout?
  53. Solved: How to run a macro when user clicks a value in a dropdown box (form control, not UFM)
  54. Solved: Recent session date
  55. Wake up Lan
  56. Agenda using VB or formula?
  57. Macro to format borders within tables in Excel file
  58. Call Two different Macros using IF
  59. Function Module (Display and Send)
  60. Add Background to PDF using Excel VBA
  61. Value of Multi column combobox
  62. Populating worksheet row with listbox values
  63. Getting data from the web
  64. Need some help on the Function
  65. Using IF/ Do Condition with VBA
  66. How to use Userform to input a list of data
  67. Highlighting Row
  68. Solved: Import a single column text file
  69. Populating a range with formulas
  70. Solved: Pulling data from seperate worksheets into cumulative one.
  71. Solved: Detecting / Avoiding Duplicates in a VBA userform.
  72. Solved: Help with Code
  73. Detecting / Avoiding Duplicates in a VBA userform.
  74. Solved: Paste Formats from Above
  75. Solved: call a macro from within another macro works then doesn't
  76. Need help with some VB Programming
  77. Managing Two Cells With Similar Ranges
  78. Solved: Moving cell data
  79. Loop through the date
  80. Solved: Page Breaks in body text
  81. Solved: LOOK CELL IN COLUMN THEN HIGHLIGHT
  82. Solved: Maximum field length
  83. How to get the file name in the folder?
  84. Excel with different sheetname
  85. How to close the particular excel without saving?
  86. Exporting data from content control fields in word to excel 2010
  87. Problem decimal calculation in VBA
  88. Autofill
  89. Solved: EXCEL VBA - drill down feature
  90. Assign Formula Result to variable
  91. Help with VBA Code
  92. Indexing characters in a string
  93. Date issue
  94. access macro from another workbook
  95. Excel 2003: How to disable cell drag and drop when workbook is opened?
  96. Solved: CheckBox Question
  97. Ayuda con registros en Listbox
  98. Solved: Associate values checkbox and sum
  99. Solved: Repeat B2 values based on rows on column A
  100. Copy from one sheet to another
  101. Accessing Range Name Causes Run-Time Error
  102. Solved: VBA to find path for multiple files
  103. Reading Text File into Excel
  104. Chart based on Multiple criteria
  105. Highlight the header being used to AutoFilter a range
  106. results when step through, none when run
  107. UDF Lookup Issue
  108. Solved: Formatting across worksheets
  109. Delete / Clear all Rows begining at Cell "X"
  110. Transfer the data to another sheet
  111. Solved: Replace without looping??
  112. Solved: help needed with vba to delete certain charts
  113. reduce the macro
  114. Open 2 worksheet at the same time
  115. [SOLVED] Create a Desktop Shortcut for New Folder
  116. Solved: Excel Chart: How to Label a Chart Series using VBA
  117. Sum of Array Using Sub procedure and Function
  118. Solved: Looping through wooksheets
  119. [SOLVED] Creating Sequence Numbers
  120. Solved: Understanding VBA Code
  121. Solved: Export a sheet as file
  122. Solved: Selecting cells
  123. Generate Dynamic Diagram
  124. Solved: Need Auto Save once value is entered in cell.
  125. Processing records in VBA
  126. Can you interrupt a data load?
  127. Solved: Adding Time Stipulation to VBA
  128. BLINKING CELL IN EXCEL
  129. highlight a cell based on 2 cells matching
  130. Solved: AuotoFill is slower than using the Range. - Are there other factors to consider?
  131. Import xml to Excel without parsing text or format string in text
  132. Solved: Convert Fractions To Decimals in UserForm
  133. search instr in multiple
  134. VLOOKUP Returning "FALSE" Instead Of Zero
  135. Solved: Need reminder for previous day
  136. Spinbutton and combobox with a listbox help !
  137. Solved: obtain data from 3 input with conditions
  138. Create an alert popup
  139. Unzipping multiple files using VBA - Why is this happening?
  140. Solved: Modify Loop Until IsEmpty
  141. How to set Multiple instr
  142. The sheet selection depends on the variable?
  143. Solved: Comparing columns A and B. Would like to eliminate #NA results.
  144. How to insert value "Small Enterprise (alt)" using VBA Macro
  145. Is this a good way to export what is in a cell?
  146. Extract string from text file
  147. Extract Data from .txt file
  148. date criteria
  149. Creating a report
  150. Help calculating Max of aggregate sum
  151. concatenate multiple rows
  152. Need to generate Open Order Report Filtered By Customer and Due date
  153. Solved: Excel Macro Formula
  154. Solved: adding a prefix letter
  155. Solved: Run Macro on Specific Sheet
  156. Untrapped Error 9 in code
  157. Problems Logging in to a website using Excel
  158. Simple Obfucator?
  159. Combining data from multiple workbooks (specific sheet) into a specific workbook
  160. Create Daily Report From Master Tracker
  161. Solved: Help needed
  162. Solved: Cut and Paste to different cell
  163. How To Set ActiveWorkbook Worksheet in Recordset
  164. compare and get data from many sheets and place it in another sheet
  165. Solved: Control listbox results whit a combobox.
  166. Copy row and one above it loop error?
  167. Sub causing error 9
  168. Activiate function when another cell is triggered from a function such as doubleclick
  169. Importing a .txt file based on file title that is input by user
  170. Solved: Loop not running correctly
  171. Confused with classes a bit
  172. FUNCTION OR CODE TO DIVIDE NUMBERS.
  173. Does Protecting a Project protect against the user selecting the design mode button?
  174. Error '9': Subscript out of range when trying to change codename of a sheet
  175. Run Excel Macros IF...
  176. Solved: Need to use the sheets change event to undo changes made to Cell A1
  177. MACRO for RADIO BUTTON
  178. MsgBox used during On Error Resume Next ?
  179. Looping Vs Non Looping approach
  180. Cells Background Colour Match Help :bow:
  181. Count maximum specific combinations between 12 columns
  182. API call working in Excel 2007 but not 2010!
  183. How to add references & add-ins via VBA
  184. Skill Matrix
  185. Link for help (to not duplicate post)
  186. How to identify method for an assigned shortcut?
  187. VBA Pivot Table Help
  188. Adding a drop down menu
  189. Find Duplicates using VBA
  190. VBA in Excel to Word: Searching and Replacing
  191. Solved: VBA Autofilter call does not work
  192. Can a Userform generate a record #?
  193. short scrip to do a check
  194. Securing a PDF using Excel VBA
  195. Solved: Mailer code depending on variables in columns
  196. Solved: Highlighting a specific Text in excel sheet by macro
  197. Else If Loop
  198. Solved: Need faster code to lock and unlock the activesheet used range.
  199. Solved: Loop problem
  200. Solved: Disappearing Command Buttons (ActiveX and Forms type) when copying sheet...
  201. Solved: Split a Directory into Smaller Directories and Copy the Files Across
  202. Solved: Selecting only certain rows to use in Combobox list
  203. Compile Error: Automation Error
  204. Solved: round down
  205. Can Forms Be Truly Docked?
  206. Solved: Trouble with VBA Code
  207. Delete Row until Data Matches
  208. Map Number Ranges to other Sheets?
  209. pivot table subtotals
  210. How to copy cells/rows with formula?
  211. macro to import data from text file to excel worksheet
  212. SQL WHERE STATEMENT
  213. Automatic Filename from cell info
  214. Alternative to Union Function/Combining Ranges
  215. populate a memo fields
  216. VLOOKUP File Path
  217. Help with Run Time Error 1004 Document Not Saved
  218. Solved: Why is this code not locking the cells in the selected row ?
  219. Run-time error 1004 - on a sort?
  220. Excel VBA code to change the User Interface to default view upon opening
  221. Macro to run advanced filter
  222. VBA code to hide ribbon / menu bar ?
  223. VLookup inside a UserForm
  224. Show a Form During General Recalculations
  225. Looping and Transposing in excel
  226. Solved: Copy found cell, not column
  227. VBA code for backing up excel files
  228. VB code for delete the columns
  229. Sumif macro in Excel for SAPBW Bex reports
  230. Conundrum: looping sheets, matching columns and copying from one workbook to another
  231. Solved: Userform TextBoxes / Inserting Dates
  232. How to open wk3 (1-2-3) with Microsoft Excel 2007
  233. once data input for 2 sheets in different table structure
  234. Complex IF Formula Errors as VBA Code
  235. Macro to Replace Query
  236. Solved: Text File Comparison Question
  237. Search for a folder and return full path.
  238. Skip to next empty cell
  239. Comparison of 2 versions of Excel sheet
  240. Solved: Error when running file in IE7
  241. Remove all Duplicate rows in Excel based on multiple colum
  242. Excel Compatibility 2007 back to 2002
  243. match data in certain ranges
  244. Macro Code for referring to a value in a drop down list
  245. UDFunction triggering on cell refresh vs change in cell value
  246. How to Disable Set Print Area in Excel?
  247. Solved: modify macro to get group of data
  248. Copy Non Error values
  249. consolidate two worksheets. different table structure
  250. Searching through a list