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:] Simplify Code?
  2. [SOLVED:] Duplicate Entire row if cell value >15
  3. [SOLVED:] Dynamic Sort Range. How to code
  4. Batch protect multiple sheets
  5. Application.FileSearch substitute in excel 2010
  6. My Macro sits and spins
  7. ★ Copying paragraphs from other documents with interface
  8. [SOLVED:] Highlight Lowest Value in a column
  9. Copy/Paste Function not working properly in Loop
  10. Search Outlook attachments for specific content before sending new e-mail
  11. [SOLVED:] Making Your Own Date Format
  12. [SOLVED:] Listview sort when column header clicked
  13. [SOLVED:] VLOOKUP help
  14. Multiple text file importing
  15. How to use Excel to upload a file to web
  16. Search Dir for Workbook and worksheet and add either as required
  17. [SOLVED:] Delete Columns based on the font colour in row 1
  18. [SOLVED:] IF Statement in VBA with Offset
  19. Converting a range to a table and then creating a pivot table through a series of WBs
  20. EXCEL VBA - PUSH DATA AND REFRESH
  21. Data validation list for-loop wont go to next
  22. Code to close workbooks
  23. Get all occurrences of data from text file using VBA
  24. table filtering and sorting
  25. [SOLVED:] New to VBA, Need help outputting a list of the TextBox names from my 1st project
  26. Worksheet Data Input and Data Handling
  27. DISPLAY SUBTOTAL and SUBTOTAL % in PIVOT TABLE
  28. Reverse a matrix on VBA
  29. [SOLVED:] VBA to ignore login request?
  30. macro to Create a Output file based on Input file
  31. Transpose from .txt files
  32. Count Cells in Range Containing Specific Value
  33. [SOLVED:] Count Spaces Between Values
  34. Steer me in the right direction?
  35. Need help on the code i have created for Ping tool on vb script.
  36. Pivot Table: Difference From ... question
  37. New Comment Arrow
  38. [SOLVED:] loop through all public declared variables in a module
  39. Help on existing macro
  40. [SOLVED:] Pick the fillcolor of a cell
  41. Delete columns based off of formula in another cell
  42. Copy range in row based on criteria and paste to another row based on criteria
  43. [SOLVED:] Run JavaScript and Get Return
  44. [SOLVED:] Trying to create a PivotTable with VBA, constantly getting an error.
  45. How to use VBA to apply filter to a pivot table
  46. [SOLVED:] If filtered rows are Yellow then delete else ignore and remove filter
  47. [SOLVED:] Worksheet Change Event has gone AI :o
  48. Nurse Scheduling Help
  49. Using an IF and IN statement in VBA
  50. [SOLVED:] IF different from blank then
  51. [SLEEPER:] R-Code to VBA Conversion
  52. VBA Macro a filter that consolidates and displays information in different tables
  53. [SOLVED:] Select/Move Rows to New Sheet Based on Date
  54. VBA for Sorting Table
  55. [SOLVED:] Problem Macro
  56. building an array
  57. Cell Value
  58. [SOLVED:] use variables in excel 2010 vba with batch file
  59. VBA code to copy differing range of cells depending on sheet name
  60. Extract text files from zip files and import contents to Excel
  61. [SOLVED:] loop certain columns
  62. Help with consolidating date on a worksheet from other worksheets
  63. Inserting pictures (bmps) from Macros into location of current cell (variable cell)
  64. Toggle newly inserted row based on criteria
  65. [SOLVED:] AutoFilter Previous Months Data
  66. Static Workbook but dynamic sheet - Indirect lookup
  67. Alternative for large data reporting
  68. [SLEEPER:] Find and Replace VBA using Userforms
  69. [SOLVED:] Random Variables
  70. Put comment with IF
  71. Cant use match to find cell (date) i have just copied!?
  72. auto transfer multiple rows from one excel to another
  73. Looking for some help to find "missing" letter groups
  74. [SOLVED:] Open a Workbook with path
  75. [SOLVED:] Compile Error: Expected: line number or label or statement ....
  76. How to copy a column from one worksheet to another if the Active sheet is different
  77. Finding a non-unique value and take max in another column
  78. [SOLVED:] Return value from Custom Ribbon
  79. [SOLVED:] How to sort a list of numbers and eject one special number of this list?
  80. [SOLVED:] Edit Current Selected Cell
  81. Find Matches for a Range of multiple criteria?
  82. Opening URL with Fragment Identifier from VBA Excel
  83. [SOLVED:] How can I fix my autofilter if criteria not met?
  84. Sleeper: How to color code a row if range of columns are blanks
  85. Highlighting all row with same date
  86. [SOLVED:] Splitting one column into serveral columns
  87. [SOLVED:] Pivot AddDataField - All data the same as first column
  88. Function that searches the maximum of numbers which is smaller or equal 0.75.
  89. VBA to convert formulas to value
  90. Add/select multiple files
  91. Adding a 2nd Macro
  92. Extract data into multiple cells
  93. [SOLVED:] Userform ComboBox loaded from Access
  94. Macro to insert a row if defined value not available
  95. [SOLVED:] Copying from PDFs - Only pastes last file?
  96. [SOLVED:] Data Transfered but not to Target sheet
  97. Loop through Range and copy rows based on multiple criteria
  98. [SOLVED:] Alternate way to move a file
  99. copy-paste area with objects, formulas and values
  100. receive positive or negative numbers
  101. Count number of rows in a pdf?
  102. How to change the forecolor in charts?
  103. Copy one range from multiple files.
  104. VBA code help needed
  105. How to determine 7 calendar days?
  106. [SOLVED:] Produce a word doc for each column_Docvariable+UBOUND function
  107. [SOLVED:] Save Current WS as Workbook to Selected File Path
  108. Need Help changing outputs in Excel Workbook
  109. Sleeper: Creating a one-dimensional array from a list on Excel.
  110. I need some help printing an array from a set of values on a worksheet.
  111. [SOLVED:] Userform VLOOKUP
  112. To get a output from table based on condition
  113. VBA code to add formula to blank cell
  114. [SOLVED:] VBA Row (Couinter) Assigning Problem
  115. Clearing contetn of cells
  116. Nightingale Rose Diagram - how to add wedge outlines
  117. how to protect vba code in excel
  118. Merge PDF files created by Foxit from Excel
  119. [SOLVED:] Help Writing Code That is Conditional on Shading of Cell
  120. [SOLVED:] .Rows.Count not working correctly?
  121. I am having a problem with the Application.Sumif function in vba
  122. [SOLVED:] Show userform from another userform
  123. create report from text in spreadsheet
  124. VBA: Problem clicking button on second page of a website form
  125. [SOLVED:] Creating a VBA Script to save in a current month's folder (create folder as needed)
  126. write variable in vba to text file
  127. [SOLVED:] Merging Multiple excel files into a master file
  128. [SOLVED:] Greater than >8 then MsgBbox
  129. Convert DD. December yyyy string into date?
  130. Produce multiple spreadshets based on columns
  131. [SOLVED:] How to define the Key in the sort method of a range
  132. Reading variable from combo box
  133. [SOLVED:] How to open word using excel if not already open?
  134. [SOLVED:] List Files and Folders
  135. VBA many functions
  136. Loop inside if statement with listindex
  137. Chart in Userform
  138. VBA code identify rows that have exceeded a certain value in a cumulative chain
  139. MsoAutoShape Binding Problem
  140. [SOLVED:] Merging two spreadsheets using a script and creating html language
  141. Macro to combine data under 3rd and 4th Column if condn satisfy for 1st , 2nd column
  142. Chart in userform without creating a image temporary file
  143. Don't want to over write file ?
  144. Lookup functions ? how to sovle this issue ??? help me please
  145. Conditional Data
  146. Sleeper: Alternative for GetElementsByTagName for filling a xmlnodelist
  147. How to remove an element from a nodelist.
  148. # of Thursdays-Fridays in a month
  149. Simple task but cant find a solution
  150. Bootstrapping-Random sampling with replacement
  151. Please help - Procedure too long in VBA
  152. Exporting Camera Snapshots
  153. looping help for copying data from a range and paste in another cell
  154. Delete data in closed workbook?
  155. [SOLVED:] checking if some specific workbook is open; if not then it should be opened.
  156. [SOLVED:] Run Time Error 13 - Type Mismatch Frustration
  157. Look @ My Code - Aggregates CSV Files Into Single Spreadsheet - 2 Issues
  158. Save Workbook as HTML
  159. UDF Several SUMIF optimination
  160. [SOLVED:] How can I fix my autofilter?
  161. VBA for a calculation where the range is dynamic
  162. [SOLVED:] Changing name and range of horizonal and vertical axis in a stacked bar chart
  163. Add current value to running total
  164. Need help with a complicated Concatenation and Abbreviation Macro
  165. Find two cross reference data points
  166. [SOLVED:] Search column header and copy
  167. vba code for excel list of folder name, subfolder directory, file name and revision
  168. Wrong date VBA
  169. VBA help to create summary table from a range of data.
  170. Vlookup macro replaced with an array
  171. [SOLVED:] Shell and Wait - 32 bit and 64 bit
  172. Excel VBA Charts to powerpoint
  173. Can macro simulate data?
  174. [SOLVED:] Update a previously recorded row.
  175. [SOLVED:] Problem with For and Cells
  176. [SOLVED:] Excel 2010 VBA - Issues with Drop Down box with Table Interface
  177. Array Item used correctly
  178. Scanning through multiple sheets and copying based on Header.
  179. Excel 2010 Macro Security
  180. [SOLVED:] Placing Image - Different on another computer
  181. Vba code for 3 pivots in one sheet
  182. [SOLVED:] Match Function Help Trying To Match Against All Worksheets In Workbook
  183. appending textbox info from a userform to a worksheet as a comment
  184. Calling a Sub from another Sub()
  185. Load zip structure in a treeview (vba)
  186. hyperlink to run macro not working
  187. Copy a Table from outlook msg body to Excel on receiving mail
  188. [SOLVED:] Need help with this VBA code
  189. [SOLVED:] Are multiple hyperlinks to run multiple macros within a single sheet possible?
  190. Obfuscate a SHEET?
  191. Loop excel files and sort it in a tree diagram
  192. [SOLVED:] Different size in a joined string
  193. [SOLVED:] copy specific worksheet in xlsx as text file
  194. [SOLVED:] Delete All Rows except Row Containing Text and Row Above
  195. [SOLVED:] Pasting specific cells in A different order
  196. Desperately lost in VBA code
  197. [SOLVED:] Generate an table Index
  198. Disable copy paste code not working if data is copy pasted from different workbooks
  199. [SOLVED:] Help in fixing LinkedIn code
  200. Extract data from Multiple excel files
  201. For in columns Range
  202. [SOLVED:] Delete row based on date and cell value
  203. [SOLVED:] Radio Buttons on User Forms
  204. Help: Auto Calculate Macro
  205. Problem with VBA code - simulating profit and loss from delta hedging.
  206. [SOLVED:] Deleting an Entire Row
  207. Add Date to all files in a folder
  208. SpecialCells(xlCellTypeConstants).select shows unexpected behavior (for me)
  209. Search button
  210. Absolute/Relative Workbook hyperlinks?
  211. [SOLVED:] Clear textbox along with cell contents
  212. Import value from adjacent cell in another workbook if cell meets criteria
  213. [SLEEPER:] Writing macros to calculate mutual fund performances
  214. Issue with Space in Path for Output File
  215. [SOLVED:] Multiple Monte Carlo Simulations
  216. Simple IF statement help
  217. [SOLVED:] Help with database in excell
  218. Combine Macros
  219. Populate Excel -Output Tab based on Input Tab
  220. Need help copy cell based on other column value
  221. Create Multiple Excel Files from One file
  222. [SOLVED:] Is it posible to "paste" a Dutch translation of an Ecel formula in a cell
  223. File name with some changing numbers
  224. [SOLVED:] Help Required to make code run faster
  225. [SOLVED:] Different sum
  226. [SLEEPER:] Extracting Data From Specific Cells From Each File Form A Netwrok Folder
  227. [SOLVED:] Summarising trading positions
  228. Auto filter criteria
  229. [SOLVED:] Click on Summary Tab to set Filter in detail Tab
  230. Copy several pivot tables to new worksheet
  231. [SLEEPER:] Is it possible to convert a database with VBA macro in web page?
  232. [SOLVED:] How to use auto filter in excel vba?
  233. How to dynamically place a VBA code to a Output excel file?
  234. [SOLVED:] Run macro for selected rows
  235. Suddenly Can't find project or library on something that has been working for weeks
  236. [SOLVED:] Trouble saving as PDF
  237. How to divide two values from a pivot table
  238. [SOLVED:] Copying values between two matching values...
  239. [SOLVED:] Save File in New Created Folder
  240. Trouble with code to grab data from multiple sheets and filter and list
  241. List File Hyperlink
  242. Please Help !! Code Needs Slight Modification
  243. VBA Code- Insert formula up to last row
  244. [SOLVED:] Need Help: Formula to get the amount (number) only out of text
  245. Excel Macro not working properly (missing data pasted using macro)
  246. Excel Array formula
  247. How to remove cells leading ' s when cvs (comma separated) file is imported in Excel.
  248. Some problems by using two userforms
  249. Copy paste first row with correct cell reference
  250. Slicers:Extract selected & unselected items to a Range