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

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