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