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