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

  1. Copying and sorting rows from multiple tabs to another tab
  2. [SOLVED] Look up value and copy variable coulmn
  3. Specific range date on a code with counting subjects
  4. Format repeated lines in excel with a lighter font
  5. EntireRow.Copy Issues VBA
  6. Create Hyperlink and Copy data from files.
  7. Insert a row and copy data if condition is met
  8. Range.Address length issue
  9. [SOLVED] macro to create a range name
  10. Add column containing an xl-addin function to a table imported from a Web page
  11. Range.Address length issue
  12. Search directory using a *word to find and open the latest zip
  13. Print as a PDF then combine with existing PDF
  14. Using VBA to insert a row if condition is met in Excel
  15. Dynamicaly Linked Cells based on the Month
  16. Searching multiple values
  17. Formatting the data with the help of VBA Macro
  18. copy/paste data from nth column into two columns
  19. How to use VBA to set up equal number of Rows per Page for a worksheet for print
  20. Copy data from "All Levels" sheet to Master Sheet.
  21. Size of Files
  22. EXCEL USER FORM (Update Existing Date and Time)
  23. Combination algorithm for this condition
  24. [SOLVED] Refactoring & issue with row
  25. [SOLVED] An application.EnableEvents issue. Help needed.
  26. [SOLVED] Avoid selection and select in format number
  27. VBA with counting files
  28. How to get a cell property?
  29. [SOLVED] Compare values in 2 columns, if values match copy value in adjacent cell to new colum
  30. Need help comparing numbers and generating a temporary 'no data found' message.
  31. Auto-Filtering A Dynamic Table and Copy-Pasting to Word Template
  32. Compatibility Checker & Recalculate formula Messages
  33. Filter a table using a different name each time and paste the results in a new file
  34. Find corresponding value in database, the copy whole row to update it.
  35. [SOLVED] Function does not work. Where is the mistake?
  36. Help with Split Function
  37. [SOLVED] Need Assistance with Pivot Table Change
  38. Floating box Help
  39. VBA for click on BUTTON Internet DOCUMENT
  40. [SOLVED] Filter a text file and produce a new one
  41. [SOLVED] Need help- Sort columns within rows numerically. Cells contain text as well as number
  42. Extract data to another sheet according to different filtering conditions (using vba)
  43. Combine rows if there is a blank cell under column A
  44. Can't change Range.value
  45. Macro to auto copy a cell and paste it in a particular column
  46. [SOLVED] Formula to Return value when a cell falls between two values
  47. help to apply array formula in the range
  48. Transforming dataset into a different layout (Formula if possible?)
  49. [SOLVED] Question: Passing objects to sub-procedures
  50. Specific range date on this code
  51. [SOLVED] Invalid image error :481
  52. [SOLVED] Opening and editing mutiple csv files
  53. [SOLVED] Excel MDI vs SDI
  54. Find match from range and copy/paste values to destination row where match found
  55. Create Report based on criteria match
  56. VBA code that Unhide sheet that are hidden using (xlSheetHidden)
  57. Excel VBA conditional insert of page breaks
  58. VBA Code to loop once (Do While) Replacing Array, Object Error
  59. [SOLVED] Unable to Control Cursor at End of Script
  60. Copy Cell Values to Columns if Criteria is Matched in VBA
  61. Formula instead of Pivot Table
  62. Reset Cell Value to Zero every day (after midnight)
  63. matching words from transliteration and replacing using vba
  64. [SOLVED] Date Format
  65. [SOLVED] VBA to group and identify
  66. Encryption Decoding VBA String
  67. How prevent open Excel file automatically when open connection to an Excel file
  68. vba code analysing different workbooks
  69. [SOLVED] Downloading images
  70. Macro to auto-copy a cell and paste it in a another cell at particular times
  71. reference cell font color and value
  72. [SOLVED] How to assign a variable value in to another variable
  73. #NAME? Error with VBA
  74. VBA button work 3 activity at one click?
  75. [SOLVED] Save Attachments from Current Open Outlook Email
  76. [SOLVED] Problem with date comparisson
  77. [SOLVED] Macro timing issue
  78. [SOLVED] Data Validation in a MessageBox - VBA
  79. Insert Picture With Cell Reference In Excel VBA Dont Show In Other Computers (Help)
  80. VBA copy and paste with criteria and different sheets
  81. VBA Run-Time Error 13 - Mismatch???
  82. [SOLVED] Explanation VBA code [Activate+Loop]
  83. [SOLVED] VBA Message box to display column titles based upon totals
  84. Run several Fast Fourier Transformations in a row
  85. Googletranslate()
  86. matrix rank
  87. [SOLVED] Run-Time Error '1004"
  88. Problem: Compare two excel files and mark new text.
  89. [SOLVED] Sum Cell range based on Worksheet title with wildcard.
  90. VBA to copy a Specif sheet from multiple other workbooks in MAC
  91. [SOLVED] VBA Inputs restricted to specific decimal ending values
  92. [SOLVED] Is there a consistent way to get a sequential list of controls
  93. [SOLVED] Deleting Ovals - Logic: If they are above row 70
  94. COMBOBOX Change code not working properly
  95. Print reports from a drop-down list in Excel into one pdf
  96. [SOLVED] Dynamic range help for conditional formatting rows
  97. [SOLVED] VBA to resize cells with wrapped text
  98. Seeking help for creating a nested loop with condition
  99. Get Active directory Username Details in Textbox2 based on Textbox1 Value
  100. I want to automatically create pdf and send via outlook email to different addresses
  101. [SOLVED] Doubleclick add row
  102. Help with analysing consistencies in data set
  103. VBA code to click on Image button in IE
  104. Merge files in one folder to a master worksheet and update
  105. [SOLVED] filtering with * as one of the multiple criteria
  106. vba for next loop
  107. [SOLVED] VBA - Use variable from InputBox in formula?
  108. Run-time error -2147467259 (80004005)
  109. [SOLVED] User Defined Function vba
  110. VBA Help, Automatically entering passwords on multiple workbooks
  111. Append an order number in a text file with a string and then save
  112. VBA Nest If Statement help
  113. Images Gallery in UserForm
  114. HOW TO COMBINE 2 MACRO INTO 1
  115. Enter a password for multiple protected work books
  116. VBA FOR INSERTING ROWS
  117. Need help with my VBA Dictionary task
  118. EXCEL FORMULA NOT UPDATING CORRECTLY WHEN COPIED FROM ONE YEAR TO THE NEXT.
  119. Pivot Table, Calculated Item - not working on large file
  120. Excel.Action
  121. VBA in shared workbooks
  122. ASSIGN MULTIPLE VARIABLE FROM SINGLE VALUES IN ARRAY
  123. Excel Won't recognise as date (mm/dd/yyyy)
  124. Text to Rows Macro : Subscript out of range
  125. vba new
  126. Check game numbers
  127. Create text files with file names from excel column
  128. vba add
  129. Check first five characters and replace offset
  130. Deleting rows with specific text
  131. listbox population based on search value
  132. XML substitution of values
  133. Doevent and buttons
  134. [SOLVED] Transfer worksheet to another workbook
  135. Use of the WorksheetFunction INDEX and MATCH
  136. scraping vba dropdownlist
  137. Insert symbol into text box - in the active textbox where the mouse cursor is located
  138. VBA to compare and update data on Master Sheet/workbook from another Sheet/workbook
  139. [SOLVED] Change ActiveCell within a selected range
  140. Size with Chart property of format picture in VBA
  141. [SOLVED] SQLiteForExcel Help
  142. FORMULA TO COMBINE MULTIPLES CELLS
  143. [SOLVED] Excel to Text File
  144. [SOLVED] If values equal zero command.
  145. [SOLVED] Multiple concerns with my Sheets
  146. [SOLVED] Object variable or With block variable not set -Run-Time error 91
  147. Application.FileSearch replacement
  148. [SOLVED] Include 3 sheets only in filtering
  149. Splitting data by range
  150. [SOLVED] Excel Ribbon
  151. [SOLVED] Display 3 donut charts based on combobox
  152. [SOLVED] Visualize state of ADODB recordset in statusbar
  153. [SOLVED] input data from vba userform textbox to a spreadsheet cell depending on the time/date
  154. 1004 error on delete picture on mouseover VBA
  155. [SOLVED] insert formula via loop including cell contents in a range
  156. copy and paste based on a value present in two sheets
  157. execute netsh with "Run as administrator" in VBA
  158. drag & drop merge with copy-paste-code
  159. Macro for a variable range sum if formula
  160. VBA Code for numbers colors-for different format cell criteria
  161. Send a file to the dropbox with a macro
  162. [SOLVED] Setting Header/Footer issues
  163. [SOLVED] Adding line numbers to VBE Code using MZ-Tools
  164. VB Script
  165. [SOLVED] Listview specific rows conditional formatting
  166. Complicated VBA
  167. Macro to create detailed payment schedule using summary list of bank facilities
  168. How to get Percentage
  169. VBA Conditional Formatting
  170. Multiply VBA InputBox value by cell value derived from json API URL Web Query
  171. Hide rows based on username
  172. Index Match and Wildcard *
  173. Header/Footer Print settings optimization
  174. Transponse each n rows + merge rows periodically
  175. [SOLVED] Save customrange to csv file
  176. [SOLVED] Opening unknown File names in known Folder
  177. [SOLVED] need help on using results from formula to use in case macro
  178. Normalising Data in Excel with VBA
  179. Pivot table data sorting in percentage problem
  180. Userform to filter ,add and edit data
  181. Fill Listview form 3 identical sheets (with same headers)
  182. VBA error on clearing cells
  183. VBA: Create a List of Userforms and make check visible one's
  184. [SOLVED] VBA CODE TO INSERT CHECKMARK ON ANOTHER SHEET
  185. VBA COPY PASTE DYNAMIC RANGE EXCEPT HEADERS
  186. Check combos values and add if not already added
  187. LISTDATA MISSING FROM COMBOBOX PROPERTIES
  188. Custom Save Button
  189. [SOLVED] Having trouble performing a few tasks in VBA, possibly need a loop?
  190. [SOLVED] vba userform textbox Value from date picker (Monthview)
  191. [VBA] (Challange) Match dates between two workbooks and export data
  192. Count Listview subitems based on condition
  193. Button Click
  194. [HELP] Make a more complex VLOOKUP formula
  195. Help with find/replace loop.
  196. VBA Dynamic array
  197. [SOLVED] Trying to return Table Column rather than Sheet Column from Find method
  198. Getting max value from a dictionary
  199. Formula to import and sort data from other sheet based on dates
  200. Change ActiveX Image Control from UserForm
  201. [SOLVED] excel macro help
  202. Move file to new folder based on cell value, create folder if not already exist
  203. open workbook
  204. [SOLVED] Userform instructions
  205. VBA save a variable when criteria is met
  206. Populate a cell percentage based on amount of dates in a range of cells.
  207. How to rename TextBoxes on userform
  208. Ignoring Error VBA
  209. ControlTip Text not showing in excel Userform
  210. USERFORM WITH MULTIPLE ENTRY LINES
  211. [SOLVED] Sub Not Defined error when using a renamed combobox
  212. VBA restaurant ordering form
  213. Highlight cells with inputbox
  214. VBA Conditional Format Error 9
  215. [SOLVED] Paste and End(xlRight)
  216. Copy Paste Without Opening The .csv file/s
  217. How to make my combobox invisible
  218. Comparing two columns with empty rows but same data and delete
  219. Allow access to certain sheets in a workbook
  220. Copy And Paste All Rows That Match A Specific Criteria
  221. Copy calculated data ranges in Sheet2 O:O to Sheet1 offset column block areas in C:C
  222. vba example
  223. VBA Row offset when dynamically changing cell value
  224. [SOLVED] Set Worksheet to variable name
  225. Extract Unique List That Meets Criteria
  226. [SOLVED] macro or VBA code "is it possible?"
  227. Long if statements with numbers.
  228. Lookup formula Corresponding value in anywhere in array
  229. [SOLVED] Msg Box Problem
  230. [SOLVED] Remove excess cells
  231. [SOLVED] VBA creating new folders and files
  232. Need Help Re-writing Recorded Macro
  233. Help to separate two codes and place one in a Userform Function
  234. Display CopyFromRecordset result vertically
  235. Timer/StopWatch - How do I make button turn to red and flash when I click Start?
  236. excel stops working and crashes when working with excel user form
  237. INSERT TEXT AND FORMAT AUTOSHAPE
  238. [SOLVED] .AdvancedFilter using an array as the criteria
  239. Array loop
  240. Password protect and unprotect a worksheet/workbook
  241. Lock and unlock lines in worksheet based on usrname
  242. [SOLVED] Insert progressive numbers in a column but every n rows
  243. VBA Counting instances of journeys
  244. [SOLVED] COMBO BOX MISSING, BUT PROPERTIES EXIST
  245. LISTFILLRANGE COMBOBOX PROPERTY NOT WORKING
  246. VBA to check column I and if find data and match the same ID in column A Put Data in.
  247. To set Date filter on pivot via input box when opening a file
  248. Array Formula - More than one wildcard in lookup
  249. Legend Issue
  250. [SOLVED] vba cell event change & call macro combination