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. How to test for characters in a specific set?
  2. [SOLVED:] Combine two macros on the same sheet
  3. [SOLVED:] Compare Multiple Columns in Multiple Sheets and Merge differences
  4. Adding a unique watermark to a PDF from Excel
  5. Need help formatting an email generated from excel to outlook.
  6. EXCEL 2013 DEPENDENT CELLS
  7. find min value of specific designation
  8. Copy and paste multiple data from Excel to Internet Explorer
  9. VBA - Run same code for each row but increment values?
  10. Populate the text2 box with the expiration date of 30 working days
  11. Store specific rows in an array
  12. [SOLVED:] One Function: Different Formulas for Different Inputs
  13. Refreshing connection
  14. Copy Filtered Visible Data from one workbook to another workbook with Filtered Field
  15. [SOLVED:] Conditional Formatting and Data Validation.
  16. Is it Possible to Run Goal Seek on array elements within VBA?
  17. [SOLVED:] Flexible address for autofill
  18. Table Creation in EXCEL
  19. Unknown external link to macro-workbook problem
  20. [SOLVED:] Pivot Table Flexible Source
  21. List related information comparison, based on list matching
  22. time format a text box in excel userform
  23. Extracting excel files only from 3rd subfolder and only from certain folders
  24. Need help with VBA and copying rows
  25. Transferring Data from Outlook to Excel
  26. Drop time info from CSV import
  27. [SOLVED:] How do you create nested classes in VBA Classes in Excel?
  28. Need help in accelerating a process(too many loops)
  29. Copy data from Multiple WBs without Duplicates
  30. window of search in the userform
  31. ExcelVBA - Opening files with certain conditions
  32. [SOLVED:] Excel VBA : how to merge cells in winword table with for... next
  33. Fast Data Search Method With Userform
  34. [SOLVED:] Data Replacement
  35. Get table of information from website
  36. [SOLVED:] Check if cells match but ignore the spaces.
  37. [SOLVED:] Need Help passing a userform.texbox object to a sub
  38. [SOLVED:] help with If statement that counts
  39. [SOLVED:] VBA macro for deleting not matching values
  40. [SOLVED:] Excel VBA : How to break the file Path
  41. Excel VBA: Consolidating data with existing data each time macro is run
  42. VBA Code - Insert Pagebreak in Selected Cells (Range)
  43. [SOLVED:] Find/Replace in Excel
  44. [SOLVED:] Excel Button IE Automation
  45. [SOLVED:] Need Help for pasting data for 2 columns instead of 1 column
  46. Copying text from Word to Excel with VBA
  47. Vertical line pointing to fixed Date
  48. Determine ScaleHeight of an image
  49. Highlight missing or duplicated cells
  50. VBA Script to fill in missing data
  51. Best way to capture digits to left of decimal place?
  52. Conversion of formula to userform or button
  53. [SOLVED:] Hex Colors Display in Excel Wrong - RGB
  54. acceleration of a macros formation of data on new sheet
  55. [SOLVED:] Retrieve data by downloading a text file from a site
  56. Runtime Error 1004: Attempting to Mirror Cells
  57. VBA access embedded window data from html
  58. Copy from Merged Cell to individual cell
  59. Ribbon tool
  60. Copy from different workbook
  61. VBA code just need one line...?
  62. Not able to access a text field using getElementbyID
  63. ActiveX Checkbox VBA Code Help
  64. Based on cell value highlight cell and transfer data from one to another sheet
  65. Convert date format
  66. Print PDF on Back Side of First Sheet of Excel File
  67. Determine the position of a screentip
  68. VBA Code Assistance
  69. [SOLVED:] Msg Box restarting every 5 seconds
  70. [SOLVED:] Formula Error (Not using VBA Code)
  71. populate userform listbox with pivotRowField items
  72. [SOLVED:] Reload combobox contents after saving file
  73. VBA Help, Getting error: 'That name is already taken. Try a different one'
  74. [SOLVED:] Macro is being driven on different worksheets
  75. [SOLVED:] Finding Angular Misclosure and then Balancing Angles
  76. VBA help in coding
  77. Get unique items and sum total on userform
  78. Open Zip file with many other named files and months within folder
  79. MAcro Help
  80. Macro to Unhide Column, Print, Hide Cell
  81. [SOLVED:] Run-time error '1004': Method 'SaveAs' of object'_Workbook' failed
  82. How can I copy 2 sheets and Paste everything but the Formulas
  83. VBA listbox change event
  84. using public variables in userforms
  85. [SOLVED:] Sumproducts problem
  86. [SOLVED:] Split some sentences by 'vbKeyEnter'
  87. [SLEEPER:] Userform help
  88. [SOLVED:] Worksheet_Change
  89. Copy value on a monthly basis from a website and update excel workbook
  90. [SOLVED:] Image control and load picture
  91. [SOLVED:] Selected Sheets Count
  92. How can I compress the all winword images by Excel VBA coding
  93. [SOLVED:] Removing duplicates from cells across rows, not down columns, without deleting rows
  94. [SOLVED:] Need Help restructuriing Macro that highlights dups to highlight also partial
  95. 2 issues with Macros (Printing Pages & Not copying data when worksheet is Blank)
  96. [SOLVED:] Identify unique items in column and delete row
  97. [SOLVED:] Way to speed up this newbie's simple recalc/copy/paste loop?
  98. [SOLVED:] Mac excel shortcut to select all rows till end
  99. Macro to Automate a school timetable workbook
  100. textbox format
  101. [SOLVED:] Why does the "Format shape" window appear when i run a macro?
  102. VBA to Copy and Past from One Sheet to Another
  103. Changing values based on offset values
  104. Vlookup Error with Negative Value Range
  105. Error Trying to send email via Excel
  106. [SOLVED:] Need help gettin this macro to run faster, Please!
  107. Overriding Disable copy/paste code
  108. [SOLVED:] transfer of information from identical excel files and identical sheets of accumulati
  109. [SOLVED:] VBA Regex
  110. [SOLVED:] ListBox1_Click to select an item on a worksheet
  111. Reading 1st row of a CSV file into Array without opening it
  112. [SOLVED:] VBA macro for comparing 4 columns and highlight
  113. Transform data from vertical to horizontal
  114. Changing Combo Box Selection Value
  115. Show column heading and corresponding value based on dropdown selection
  116. range: from active cell to last cell in current column (discontinuing)
  117. [SOLVED:] Sorting Columns into Tables
  118. [SOLVED:] Insert picture name in worksheet change
  119. vba loop to find and change value in textbox on userform
  120. Decode Base64 to String in VBA to Excel cell
  121. Copy & Paste Dynamic Range to New Worksheet
  122. [SOLVED:] Excel VBA refer to a userform by variable to address it
  123. [SOLVED:] Coding Help for Range Calculations
  124. Runtime 91 error on userform populating one input box on webpage
  125. [SOLVED:] Replace Number In A Column With A Different Number
  126. Function Error
  127. VBA to merge / unmerge identified rows when target is used
  128. [SOLVED:] IF formula in Macro for entire row
  129. Facing problem with update the record
  130. [SOLVED:] datevalue error - #Value
  131. Custom Sort Parts List - VBA
  132. Interact with Internet Explorer open tabs - VBA
  133. Consolidating multiple worksheet into one by finding Column Name
  134. [SOLVED:] Multiple Excel sheets update
  135. [SOLVED:] DDD.MMSS to DDD-MM-SS
  136. [SOLVED:] Copy values from loop and paste in different worksheet
  137. Gmail Login failed (Web Scraping)
  138. [SOLVED:] Help getting a Macro to work!!
  139. How to put timestamp on a cell using a button VBA
  140. Listboxes with filtered data > import data from table to userform?
  141. Cell Anchoring in VBA??
  142. [SOLVED:] Time Loop
  143. VBA - help assigning varibles
  144. [SOLVED:] Compare data between two sheets
  145. IN Statement in VBA
  146. [SOLVED:] no idea
  147. VBA: VLOOKUP with LOOP
  148. Positioning labels within chart
  149. MACRO: IF THEN Statement (Multiple Criteria Match then Copy)
  150. Add additional step to macro
  151. help with dynamic offset
  152. Outputting to more than one cell at the one time in VBA
  153. [SOLVED:] VBA: Index/Match
  154. Copy row to exisiting tab and then delete
  155. [SOLVED:] Copy entire row to new tab if a cell contains certain text
  156. Limiting the number of checkboxes to be selected
  157. Create if statement: if value exists then create new sheet
  158. [SOLVED:] Autofilter in Macro not working!
  159. Change file extensions
  160. VBA Print to PDF Button code issues with multiple users
  161. SubTest Help for debugging
  162. Macro Formula with dynamic ranges
  163. Prevent Copying Worksheets
  164. Please help me with this excel generator
  165. Word Document Data to Excel Spreadsheet code/macro
  166. Consolidate multiple workbooks and worksheets from a folder
  167. [SOLVED:] How to unzip with VBA?
  168. Mapping userform checkbox value to Outlook
  169. Help is multiple nested IF statements using range objects
  170. Filename Variable
  171. [SLEEPER:] VLOOKUP, INDEX and MATCH formatting problem
  172. [SOLVED:] MERGE 2 DİFFERENT VBA CODE
  173. [SOLVED:] ActiveX Label
  174. [SOLVED:] Code That Creates Names based on the Sheet Name
  175. download company URL's & company names across multiple pages from web (Web scraping)
  176. VBA REPLACE CURRENT CELL WITH CURRENT MONTH AND TEXT
  177. Last Occurence of last month Transaction using Index sumproduct
  178. Help me for ListBox ListFillRange
  179. [SOLVED:] Need Way to move certain data when certain column is updated
  180. Question about Copy and paste DataObject in excel worksheet
  181. [SLEEPER:] VBA Import Text Line by Line to formatted Cells
  182. Save SVG image as png or jpg format from a website
  183. [SOLVED:] Combobox question
  184. [SOLVED:] Procedure for merging common values in same column
  185. could not get single (last) element while looping through class name (web scraping)
  186. [SOLVED:] identify Highlight Overlap dates
  187. Parsing websites
  188. [SOLVED:] Change multiple Form Control Button captions from a list on another worksheet
  189. Use conditional statement to sum column values and paste to new worksheet
  190. [SOLVED:] Highlight two sets of cells based on selection.
  191. Shuffleboard tournament math
  192. [SOLVED:] Ranking the rows without sorting
  193. VLookup to skip blank cell
  194. Create New Folders - Input Box
  195. [SOLVED:] Index Match Over Multiple Worksheets
  196. Merge Only Visible Worksheets
  197. Passing selections from a drop down box to loop in sub procedure
  198. [SOLVED:] Importing data from Word to Excel in non-continuous fields
  199. [SOLVED:] Listbox Multiselect issue
  200. [SOLVED:] code not calculating storage charge correctly
  201. Highlighting row containing specific word in specific column
  202. Find Max Value in one worksheet and return the value to a cell in another
  203. I simply can't do it alone (simple VBA macro to search and find), please help!?
  204. [SOLVED:] Download Attachment from Email and extract Data
  205. [SOLVED:] Autofilter problem
  206. List Box - Application.run Macros
  207. What is the best way to combine multiple workbooks into one?
  208. Count down timer help
  209. [SOLVED:] Separate files and save them in PDF format
  210. [SOLVED:] Concatenate Two Cells in a third cell
  211. Pivot table to refreash and ask for new filter dates
  212. Sleeper: Error in VBA Excel
  213. "For Loop" to Change "Chart title" based on sequential cells
  214. VBA Classes
  215. Merging of files where columns are the same
  216. How to relate. OPTION BUTTONS
  217. Loop to concatenate cells
  218. Copy Highlighted Cell to Another Worksheet
  219. [SOLVED:] Formula to Display Several Strings of Text in a Cell
  220. [SOLVED:] List Box - Reset Button - Search Filter Clear
  221. Excel And Perfmon
  222. Macro for removing 2 letters word
  223. [SOLVED:] Macro not copying down lines
  224. Creating a message box with multiple options
  225. [SOLVED:] Public procedure to sort similar rows
  226. Group data on one table based on information in another table
  227. Manual calendar
  228. Active Cell and Timers - Fix References
  229. [SOLVED:] Help sorting numbers in listbox in ascending order
  230. VBA Find & Replace based on cell reference within a range
  231. [SOLVED:] No Pair
  232. Select different cells in several sheets.
  233. use excel vba to select an item in a Kendo grid in IE
  234. Userform with Combobox launched from Worksheet
  235. How To Detect Click On Zoom In Status Bar?
  236. Copy Range Until Last Cell With Data
  237. [SOLVED:] MouseMove event for disabled controls.
  238. Excel SmartArt Organizational Chart - Name and Title
  239. Interfacing with local 'virtual' server
  240. [SOLVED:] Find Match, Copy/Paste to a closed worksheet in workbook
  241. [SOLVED:] help with validation
  242. VBA code fastest highlight of unique values
  243. How to copy rows from a sheet to ather sheets in the same workboouk with criteria
  244. Split Workbook Into Multiple Workbooks
  245. VBA - Importing External Data from Txt Files
  246. [SOLVED:] copy data in specific columns to another sheet
  247. Need a little help please
  248. Excel will lock specific area based on a date
  249. Find last match in date sorted list using index match with multiple conditions
  250. Sales in the fortnight