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

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