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. List all possible order combinations
  2. [SLEEPER:] Copy Rows - If Column B has the Word Found in a Worksheet List
  3. [SOLVED:] Add to Dynamic List if it doesn't exist
  4. [SOLVED:] Automate Lookup Function to create participant schedules
  5. [SOLVED:] Summarize Data to New Sheet
  6. Polygone färben
  7. Filtered visible cells to Userform as row source.
  8. Create Pivot Table from multiple sheets
  9. [SOLVED:] Storing unique values in array
  10. Toggle Shape Text & Colour On Click - Application.Caller
  11. Advanced Auto Filter Long Text Strings From List Table
  12. [SOLVED:] Excel VBA Project References
  13. Select specific tab in already open instance of Internet Explorer
  14. VBA - select a drop-down in a web
  15. [SOLVED:] Macro help - Autofill multiple cells to dynamic range
  16. [SOLVED:] Associating Unique Variables To HyperLinks In Cell Range
  17. How to switch to the newly created Internet Explore document
  18. [SOLVED:] VBA Help - analyzing rows to create a single column
  19. [SOLVED:] Filter Pivot Results In Crash
  20. [SOLVED:] All Mondays in a date range
  21. Filter Dates to previous month
  22. Userform Personal Workbook - Runtime Dynamic Population - Run Code Module Macro
  23. [SOLVED:] Need to check if a picture exist or not then delete
  24. [SOLVED:] Save embedded PDF file as a separate PDf file
  25. [SOLVED:] Replace text in cell with picture (or insert picture into same cell)
  26. Compare two workbooks and highlight the differences in the third workbook
  27. Simple Copy/Paste - columns from one sheet/workbook - to a different sheet/workbook
  28. Change a variable without effecting other data rows
  29. Add-ins don't work
  30. [SOLVED:] Filling two listboxes
  31. How to edit the color of the cell?
  32. Review for Best Method
  33. Graphics.FromImage VBNet to VBA Excel
  34. Having trouble looping macro through active worksheets
  35. [SOLVED:] Analyzing Customer Comments
  36. Functions in cells prevent finding last cell value in table columns
  37. [SOLVED:] Macros to insert, 'draw' 52 degree lines in excel
  38. [SOLVED:] Calculating number of days between 2 dates
  39. If Function to: Reject based on birthday
  40. [SOLVED:] ImageControl Retrieve Values on Memory
  41. [SOLVED:] Macro for copying flexible ranges as pictures to PPT
  42. [SOLVED:] VBA to stack top row into columns
  43. [SOLVED:] VBA Request
  44. [SOLVED:] Coil spring VB image
  45. Delete duplicate cells on rows
  46. [SOLVED:] Deal with areas by specific string
  47. [SOLVED:] Copy Paste Cell Values - If InString to Different Worksheets
  48. [SOLVED:] Sort each group in descending order
  49. Randomly Sort Teams Button
  50. [SOLVED:] How to use an array to copy filter range into new worksheet?
  51. copying unstriked data
  52. [SOLVED:] Concatanation in a new column
  53. Search Webpage for word
  54. How to Create Function for Matrix Multiplication
  55. Macro to search column, copy row and insert
  56. [SOLVED:] Change date Format
  57. VBA codes to extract pdf files to excel
  58. [SOLVED:] Inserting Image on several worksheets in same workbook
  59. [SOLVED:] Macro to replace text with incremental number
  60. VBA Macro code to get an alert message when a condition is met
  61. [SOLVED:] Cell displays an error unless the column is double clicked
  62. Listview control
  63. [SOLVED:] Excel - Increment to the Next Column Loop Counter
  64. Archiving Rows on Excel using VBA
  65. elements of array
  66. Creating a new "All Day Event" In Outlook Using Excel 2010
  67. VBA code to import .mdb file into excel 2013
  68. [SOLVED:] VBA Concatenate Counter With Text Constant
  69. Speed up VBA filtering
  70. VBA Macro - Extract Price and Flight Info from Skyscanner
  71. VBA code for saving xls.
  72. [SOLVED:] Help Please :)
  73. If, And, Or
  74. Need help about this question!
  75. [SOLVED:] Yahoo finance option quote - unable to parse data
  76. evaluate comma separated month in abbreviation with number in a cell
  77. [SOLVED:] Finding for duplicates in Column A
  78. excel as a search engine
  79. Column Charts - Dashboards
  80. [SOLVED:] Reformat Times
  81. Date / Business Date
  82. Excel 2013 Print Preview Code
  83. Help with FileFormat issue
  84. [SOLVED:] pivot table question
  85. Data validation formula rules
  86. [SOLVED:] Importing large text file, extracting lat-long, and converting to decimal
  87. Copying sheets using vba
  88. How do I paste an array of predefined ranges from excel into powerpoint as embed/link
  89. [SOLVED:] What is wrong with delete worksheet?
  90. [SOLVED:] MACRO - Create worksheet adding an apostrophe
  91. ComboBox_Click event is firing for any change on any worksheet
  92. Setting Default SaveAs Name Before Saving Workbook
  93. I CAN NOT ABLE TO DOWNLOAD STOCK DATA FROM YAHOO FINNECNE
  94. .dll documentation/learning material
  95. Autofilter date range from two cell values
  96. How to simplify vba code?
  97. [SLEEPER:] Change the outbound and return times on Skyscanner
  98. [SOLVED:] Excel VBA cut, paste, delete process.
  99. [SOLVED:] Search And Replace - Values into Next Worksheet Offset Columns
  100. [SOLVED:] Time Chart from Data
  101. Fixing Non numeric entry to numeric field
  102. [SOLVED:] Creating a Login page on Excel
  103. Copy Rows from two workbooks/sheets into one sheet
  104. [SOLVED:] Information compiling
  105. Macro not working properly and very slow which matching data between two workbook
  106. Naming Ranges Macro Run Time Error 1004
  107. [SOLVED:] Copy/Paste Based on Multiple Row Criteria
  108. Match 1 date against 3 col
  109. VBA - Copy based in a condition
  110. Make a command button self-distruct
  111. [SOLVED:] How do I make a command button move?
  112. VBA Code to Merge Workbooks in a Folder
  113. [SOLVED:] UserForm loses focus after an Application.InputBox
  114. How to use Redim
  115. [SOLVED:] Loop Through Workbooks in A Folder and Copy / Paste to Another Workbook
  116. [SOLVED:] Copy/Paste formula using lastcolumn
  117. Download File that requires user input beforehand
  118. Usng workbook/worksheet variable names
  119. [SOLVED:] Entering Fractions in Dimensions Calculator
  120. Pasting into first empty row in a specific range
  121. [SOLVED:] Copy Data / Paste Data with Value and Format
  122. Loop Through Multiple Workbooks and Worksheets Using An Array
  123. Create a log/journal about each table row?
  124. VBA code for matching and updating data across spreadsheets
  125. [SOLVED:] Add Header When Merging Data from Multiple Workbooks/Worksheets
  126. send Reminder Email to Outlook if cell value reached
  127. Copy three parameters/data from notepad to excel
  128. [SOLVED:] VLookup Not Posting Matching Results in Column
  129. Sequentially Number Placeholder in Cells
  130. Run time error "438" - Object doesn't support this property or method.
  131. [SOLVED:] Prevent editing the file after save
  132. Copy Data from Multiple Workbooks Using ADO Format Issue
  133. paste to another open workbook and return to original worbook
  134. [SOLVED:] Active Workbook Add Modules - From Array List
  135. Auto Fill Cells
  136. last 20-day average of numbers after updating everyday
  137. [SOLVED:] ListBox - Search Excel Range
  138. [SOLVED:] Assigning Keystrokes to Excel Macro
  139. Extracting data from PDF to Excel
  140. how to calculate the weekly average of the last completed week
  141. [SOLVED:] How can I make Ctrl + Z work in these simple color macros?
  142. Nested For Loop With Step Funtion Not Working
  143. [SOLVED:] Extract Filename without Path and Extension
  144. [SOLVED:] Conditional format - formula for dynamic solution
  145. Find lower and greater number
  146. How to hide page in form by selection of combo box?
  147. [SOLVED:] update status above tables
  148. VBA Combine multiple workbooks into one master HELP!
  149. [SOLVED:] Need to Create Macro to Convert Time Sheet into Calendar Format
  150. [SOLVED:] Select Cell Based on Length of Cell Value
  151. [SOLVED:] Data Tabulation
  152. VBA - Tick/untick the direct, 1 stop, 2+ stop checkboxes within Skyscanner
  153. [SOLVED:] test column if cell is within date range, if not delete whole line
  154. [SOLVED:] Auto Updating Links
  155. Partial workbook match
  156. [SOLVED:] VBA - Paste to First Empty Cell in Range
  157. Review Code for Efficiency
  158. [SOLVED:] Dynamic Range to accommodate data
  159. VBA - How to activate or select an internet explorer browser that is already open
  160. [SOLVED:] Multiple Ifs/Loops
  161. [SOLVED:] Compare VBA projects in different workbooks
  162. [SLEEPER:] Sum and merge offset cells, if duplicates are found in a certain column (range)
  163. [SOLVED:] Select Case - To Reduce Repeating Code
  164. Sleeper: Barcode in the standard EAN-128
  165. [SOLVED:] Word doc - Save & SaveAs from Excel
  166. [SOLVED:] List to Immediate Window - Worksheet Code Subs Procedures
  167. [SLEEPER:] EXCEL VBA StartDoc API Function
  168. Sum up the amount for unique records from multiple tabs
  169. having the average of last saturday to wednesday
  170. VBA Help copying and inserting into specific sheets & sections based on conditions
  171. [SOLVED:] code to get the correct charge based on weight and zone
  172. [SOLVED:] VBA Code to change file format .xlm to .xlxs
  173. [SOLVED:] VBA Code to replace action if MACRO is run again
  174. [SOLVED:] Hide Arrows in Table - Input Box
  175. [SOLVED:] Custom scale in chart
  176. How to Use Ctrl-Y (F4) Feature During Macro Running in Background?
  177. [SOLVED:] Create table for each teacher
  178. [SOLVED:] Rearrange a set of data - Nearly there but need help
  179. paste every time on the same row
  180. [SOLVED:] UserForm Running - While Jumping to Application GoTo Statement - Unload
  181. [SOLVED:] Average annual growth rate excluding non numeric values.
  182. can not be saved in a macro-free workbook
  183. [SOLVED:] Trouble with code to hide rows
  184. HOW TO CALCULATE SUM BETWEEN TWO GIVEN DATES
  185. [SOLVED:] hyperlink path with string
  186. Using ADO Connection to Copy Data From Multiple Workbooks Help
  187. Set Range Using Variables
  188. Finding Value Between Two Sets of Columns Plus Code
  189. Word Form to Excel
  190. Extracting Data from PDF Forms to Excel
  191. Help with ranges/skip hidden rows in VBA Code
  192. How to accept (Save) a file from IE 11?
  193. How to position charts and tables to outlook and how to resize charts so they have di
  194. How to read a notepad.txt file contents into an excel sheet using VBA
  195. [SOLVED:] copy specific cells from closed workbook
  196. VBA Code error from Macro Add-In
  197. [SOLVED:] Unique names
  198. Keeping active workbook open
  199. How to position charts and tables to outlook and how to resize different charts
  200. [SOLVED:] how to have a selection of last month
  201. [SOLVED:] VLookUp Error
  202. [SOLVED:] Fill cells
  203. [SOLVED:] VBA insert new row and paste data
  204. VBA Pastespecial only visible cells after filtering
  205. How I can Search on ListBox
  206. [SLEEPER:] Need to Add New Columns of Data in Existing Workbook Using Excel VBA Macro
  207. [SOLVED:] Using Refedit with range for sig testing macro
  208. Checkbox Help - In Word - Anybody? SamT
  209. VBA code to email the document
  210. Inputing data to Spreadsheet from Userform [Special Case] pls help me !
  211. [SOLVED:] Post filter using loops
  212. [SOLVED:] Copy from mutiple sheets paste to separate workbook
  213. Converts UK -> US Dates
  214. Excel 2010 Outlook Integration Issue
  215. VBA to select multiple web pages
  216. Forward Selected dates to another UserForm
  217. Macro Compatibility Issue between Excel 2003 and Office 365
  218. excel VBA data transfer from rows to multiple rows and columns
  219. Excel VBA macro for Lotus Notes
  220. [SOLVED:] SUMIFS help please
  221. [SOLVED:] Split text file by criteria
  222. [SOLVED:] Userforms - Textbox Autofill
  223. [SOLVED:] Prompt user to select file path and inserting name with vba
  224. [SOLVED:] AND(OR)) Formatting function troubleshoot
  225. [SOLVED:] Show Excel Worksheet from xlMinimized
  226. [SOLVED:] How to correct the VBA error
  227. how to get grid data from web page
  228. Setting Excel as the DataSource for Publisher 2007
  229. how i reduce size of the prodedure
  230. [SOLVED:] Insert Regex Formula into Column
  231. VBA IE Follow Second Link After went to a website or click a Secondary Button
  232. [SOLVED:] Merge two files and remove duplicates
  233. [SOLVED:] scripting.dictionary method
  234. Looking for a better way to write this code please
  235. Searching values in a database
  236. [SOLVED:] Excel Corruption - Broken Link Missing
  237. [SOLVED:] Delay calling a Macro
  238. [SOLVED:] One more scripting.dictionary question
  239. Deleting Text At Bookmark Along With The Paragraph Below It
  240. [SOLVED:] Clear rows based on cell value
  241. Splitting workbook into several files
  242. [SOLVED:] Excel VBA with Windows Media Player: Runtime error while getting video timecode
  243. Searching using mulitple comma delimited values
  244. [SOLVED:] Stop Row from being created
  245. [SOLVED:] Pivot Table Multiple Value Filter Help
  246. Need VBA code to total the cells above rolling the total to the next summation
  247. [SOLVED:] Extend Datalabel Range
  248. [SOLVED:] ComboBox not refreshing
  249. [SOLVED:] Need Help Wrting This. (If from list, Then, If blanks, New Column)
  250. VBA issue with date format