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. [SOLVED:] Need help passing variable values to For Loop
  2. Need help: I am out of my depth.
  3. [SOLVED:] Copy-Paste cell text content + delete rows
  4. [SOLVED:] Need help modifying VBA code to suit requirements - Listing Uniques based on criteria
  5. Need Help - VBA HTML Wikipedia data
  6. Need Help: Import worksheets by name using an array of defined names
  7. [SOLVED:] Multiple Find/Replace At Once (Feeding From A Table)
  8. conditional format on a different column
  9. [SOLVED:] Need help creating a loop please
  10. Search for a word and get the (row, column) numbers, when the word is found.
  11. custom function in Excel VBA which takes an array as an argument
  12. Loading text file with specific name in excel
  13. Code Execution Speed
  14. [SOLVED:] Concatenate Date and Keep Formatting
  15. Need a Help to expand the data in HTML Page in Internet Explorer
  16. [SOLVED:] Conditional formatting of cells for 45 different cases with 5 criteria each
  17. Find Z value from given XY. Obtain plane from 3 coordinates VBA function
  18. Copy a varying range
  19. How to highlight cells with dependents in other worksheets?
  20. [SOLVED:] Array Index new with Criteria of Old Array
  21. [SOLVED:] Vlookup in VBA: lookup multiple values
  22. multiple vlookup formula is not working
  23. Excel VBA macro to copy specific rows and delete it
  24. capture specific records from multiple sheets to one sheet
  25. Find cell, make active cell and repeat
  26. [SOLVED:] VBA macro for filtering and copying duplicates
  27. [SOLVED:] Insert cell content in shapes VBA
  28. Help Deleting Rows with "If, then" statement
  29. [SLEEPER:] How to simulate Brownian motion for multiple trajectories?
  30. Match same quote number and roll up
  31. Userform for Data Entry Into Several Different Worksheets
  32. [SOLVED:] Lookup Value in two columns and identify opposite values
  33. merge/join/combine multiple tables into one master table
  34. Search for files/folder based on excel list info and copy them to new destination fol
  35. [SOLVED:] Insert new row above specific text
  36. Excel Window - Automatically Resizes to Last Size
  37. Selection Clear Content
  38. Content in a range is not clearing when i using F5 key
  39. Outputing the time taken for a calculation
  40. [SOLVED:] Automatic Filter
  41. Combo Box linked with List box
  42. [SOLVED:] VBA macro for combining several cells into one
  43. [SOLVED:] Set File Path to Cell in a workbook
  44. [SOLVED:] VBA Combining tables into one - value paste needed
  45. exclude a row in code
  46. [SOLVED:] Simplify XY Scatter into short line segments, individually colored
  47. [SOLVED:] Embedding the most recent picture taken into a cell
  48. Copy multiple files from one folder to other using the file names given in excel.
  49. [SOLVED:] delete sign pilcrow in combobox
  50. [SOLVED:] Update Master File With Data From Open Workbook
  51. Help with a macro to check results and highlight future forecasts
  52. [SLEEPER:] Error while connecting to Oracle database from excel macro
  53. [SOLVED:] Can this code be optimized with regard to the Do While...Loop?
  54. [SOLVED:] Report Generator Fix - Run-time error '1004': Doc not saved
  55. All pivot charts export at a time to folder doesn't work in excel 2016
  56. [SOLVED:] User Input to VLOOKUP a number in spreadsheet
  57. [SOLVED:] VBA text conversion into Number Help
  58. Add Zeros At End of String
  59. [SOLVED:] Excel chart problem's
  60. Check Number of rows and insert category name
  61. automatic removal of empty rows
  62. Macro for infinitely moving data to new location (need help).
  63. [SOLVED:] Changing source range of pivot table
  64. [SOLVED:] Lookup Max value on one sheet and populate on another in used range
  65. [SOLVED:] Need Help, How to Add more than 10 Columns ?
  66. Macro to check 4 columns to check for Unique combination & highlight dups
  67. Macro to Check For a Cell Value and Perform Null & Data Type Check for multiple Cols
  68. [SOLVED:] populating combobox from access table
  69. [SOLVED:] Adding a line to an acces table from a vba userform
  70. [SOLVED:] K-ESIMO MATRIX FORMULA
  71. Novice syntax question...if then statements...error 1004
  72. How do I make a data scraper [Copy and pastes multiple pages into excel]?
  73. convert alpha to numeric
  74. Break single row into multiple rows based on FORMAT
  75. [SOLVED:] VBA Compile Error "Else without if"
  76. [SOLVED:] Help storing values in Array and returning to 3 values
  77. VBA to Force the User to Enter Data into a Cell before moving to next cell
  78. Conditional formatting
  79. Load and Sort ComboBox with Dynamic Range From Sheet
  80. [SOLVED:] Assign each element of an array to a variable
  81. Error trying to attach file to email
  82. [SOLVED:] Search Column and skip hidden rows
  83. Need help .Range.AutoFilter multiple field
  84. Dynamic Userform for data entry
  85. Find variants of positions and value. Need help!
  86. [SOLVED:] Looking to code a function to efficiently remove multiple commas in a string
  87. [SOLVED:] Automating Copy And Paste
  88. Macro to copy non-blank cells in 2 columns and paste values into first blank cells in
  89. [SOLVED:] Odd scope of Workbook_WindowDeactivate?
  90. [SOLVED:] Code Products
  91. How to get data from 2 criteria (StartDatte to EndDatte)
  92. Textbox entry search populates into listbox I'm stuck on how to make the VBA code
  93. [SOLVED:] VBA search
  94. Need help with MSXML2.serverXMLHTTP request
  95. [SOLVED:] Printing multiple ranges/charts from different sheets at the same time?
  96. [SOLVED:] Need help with Multiple Pivot Table PivotField filters
  97. [SOLVED:] Remove numbers of a 1st column founded in a 2nd one
  98. [SOLVED:] Automatically readjusting a Pivot Table's data source range
  99. [SOLVED:] In a userform, applying results to a different workbook
  100. Need to consolidate comments across spreadsheets
  101. Excel eMail sending failure in Windows 10
  102. [SOLVED:] Using If function to separate data into multiple sheet
  103. Date generating
  104. Extracting and refreshing data set
  105. Choose date and calculate onwards
  106. count the number of changes in several cells
  107. [SOLVED:] Non-Printing Characters: Box with a Question Mark Unable to remove
  108. Excel VBA: limit file opening times, AND prevent copying. plus authorization code
  109. [SOLVED:] Macro to delete rows
  110. [SOLVED:] Delete row if it contains a certain criteria Please Help
  111. about Array
  112. VB Excel, increase factor in table
  113. [SOLVED:] Show Column Headings in PDF's to Be Emailed
  114. [SOLVED:] Adding A Reference
  115. Didn't work my macro to copy&paste only as formulas by default... can you give it a q
  116. Copy / Display row from another sheet
  117. Lookup Text Value
  118. [SOLVED:] Need to remove a certain part of cell Data
  119. Defining Name Ranges Using VBA
  120. Different custom ribbon for each sheet
  121. [SOLVED:] Copy/Paste unique rows based on multiple criteria
  122. Check if library exists
  123. [SOLVED:] Is there a way to add Arrow Keys to Excel's Quick Access Toolbar?
  124. VBA (Noob): Automatically select the next row
  125. VBA - Verification of the sheet > MsgBox
  126. [SOLVED:] Selecting pages to print within worksheet
  127. VBA code to delete row is value in column is less than a specific defined value
  128. How to add cells with Conditional Formatting
  129. [SLEEPER:] Can i create a Licence to an excel vba solution !?
  130. sum if textbox <>""
  131. Ending a Sub on a Timer Loop
  132. [SOLVED:] 3 Contact Numbers along with , (coma) Too many arguments
  133. [SOLVED:] working with record sets
  134. Smartview connection issue
  135. VBA freeze / timeout when processing large data sets
  136. Find a name from a list of names
  137. inputBox default input in code, user not input
  138. [SOLVED:] Need a UDF to Identify and remove parts of Cell Data from a Range
  139. VBA to write PDF froms from Excel, Radio Buttons
  140. [SOLVED:] To Pull out Certain Set of Data from a Cell [ Urgent ]
  141. [SOLVED:] Please Modify this VBA for New Requirement Or Provide a New One
  142. [SOLVED:] excel 2010 dashbord to show totals
  143. [SOLVED:] Help with Filtering...(autofilter)
  144. [SOLVED:] VBA for Auto Filter and Copy/Past the Visible Cells at Destination Workbook
  145. [SOLVED:] Array Relative Erase Variables but Next
  146. Issues with VBA's vbModeless for programmatically-created userforms: they close
  147. wildcard character is not working while opening excel file
  148. i could not paste the copied data (VBA)
  149. VBA for sending Bulk Email with Unique Attachments in XLS to Unique Receipient
  150. Calculate months onwards from set date
  151. Adding Worksheets to an Array
  152. explore the land owner
  153. Using .Value fails when initialising a user form
  154. Autofill formula help
  155. Get a Cell into a Standard Format depending on its Contents - UDF/Formula Only
  156. [SOLVED:] Pull data from specific worksheet from multiple workbooks
  157. Get rid of extra row height with Word Wrap
  158. [SOLVED:] Looping through checkboxes in user form
  159. Data Entry from Excel or CSV to AS400 Emulator is possible or not?
  160. VBA code to create Indented BOM
  161. [SOLVED:] Macro to Autofill
  162. [SOLVED:] Extract Numeric Substring From longer String
  163. Copy Transpose and Paste Macro
  164. [SLEEPER:] How to make Total Row always at the Last Row / bottom of the Printed Page
  165. [SOLVED:] thisworkbook.path and dir function
  166. [SOLVED:] Image frame resolution
  167. drop down lists vba
  168. Help with populating a table with values on other sheets
  169. [SOLVED:] .pattern help please
  170. Add row to table refering to a Cell Value
  171. Adding prefix to cell in column as it is added
  172. [SLEEPER:] VBA Autofilter 3 Criteria
  173. Automatically Converting Numbers stored as text to numers
  174. [SOLVED:] No response to change event
  175. calling inputbox if cell value is true
  176. Find DUP, remove both same entries
  177. [SOLVED:] autohide userform with active sheet modification
  178. [SOLVED:] Check value based on cell text and turn another cell Green if there is a match
  179. Userform Standalone/Hide Excel Application
  180. How to refer on a picture on a different worksheet
  181. Ask for Explanation
  182. List select and copy sheet from another location
  183. [SOLVED:] Stack bar chart configuration in Excel
  184. Reading a Text File into an Intermediate Window
  185. Changing a font style and color in VBA
  186. Reducing the need for Multiple hardline codes
  187. [SOLVED:] Applying Proper Case to Strings
  188. PivotSelect Question
  189. Invoke an .exe file using macro in excel
  190. [SOLVED:] How can I put the results of the Array back to the corresponding cells?
  191. Need to split sheets based on number of family members
  192. Issue creating SQL query from string in VBA
  193. Auto populating text fields on websites and scraping the web
  194. passing string from userform to public module variable
  195. Array Values filling specific cells
  196. VBA Newbie (Trying to write a code to copy and paste info from one sheet to another)
  197. Writing registry keys with API Calls
  198. [SOLVED:] VBA macro to order and delete information
  199. Iterating through Groupings using VBA
  200. Implementing Save As function in VBA code
  201. [SOLVED:] Reading in a text file and only printing certain lines
  202. The paste method of the _chart object failed
  203. [SOLVED:] Excel Select the Rows - Input Box - Save to Text Files
  204. [SOLVED:] OLE - Embedded Custom Icon won't stick
  205. [SOLVED:] Select next cell after dynamic range
  206. Accessing a network file that might already be open by another user
  207. evaluate a date with vba
  208. excel vba macros help needed
  209. [SOLVED:] Write from excel to text file format
  210. Excel Macro Find and Replace Functions within Cell Formulae
  211. Improving a Concatenate & Vlookup Process
  212. Outlook 2013 Global Address List Alias to Excel Document
  213. userform textbox test for format
  214. Convert Excel to Web Application
  215. InStr - Not operating
  216. Excel - how to hide columns but allow users to insert rows
  217. Download File from Website From Excel
  218. VBA for make resume by date (Unique & No Duplicate)
  219. Compare two images
  220. [SLEEPER:] Pivotal Filter Selection Macro
  221. [SOLVED:] ndate returning time in Holland not London
  222. [SOLVED:] Clear Data Module - Clearing Header when No Data
  223. Automating Internet Explorer / Interacting with HTML class question
  224. Find Multiple String Variables in a different sheet
  225. Target.value
  226. [SOLVED:] Concatenate Rows Of Data
  227. [SOLVED:] Reference Another Workbook Using Relative and Fixed Cell References
  228. Navigate web pages until search complete
  229. [SOLVED:] Look for duplicates across 2 identical tabs, remove then merge remaining data
  230. Receipt Format
  231. [SLEEPER:] Macro to UnGroup and Group Based on Current Month
  232. [SOLVED:] Macro to Change all Date formats in workbook to 01/2017 to 01.2017 (and vice versa)
  233. VBA for Input Date
  234. saving selected worksheets into new file
  235. [SOLVED:] Send data from multiple worksheet to a summary worksheet
  236. [SLEEPER:] copying all columns including hidden
  237. VBA Macro to combine workbooks in a folder into a "Master sheet"
  238. Macro encrypt-decrypt function in one
  239. Import Data from txt file in specific cells
  240. [SOLVED:] For loop very bad performance
  241. [SOLVED:] UserForm Update/TextBox DblClick
  242. help to fetch data from a closed file in excel
  243. If Statement Excel Macro
  244. Picturebox in Worksheet SetPixel
  245. ReadLine command for UNIX txt file
  246. Combo box data to select sheet
  247. copying data from worksheet to another
  248. VBA - search and display the results from the websites
  249. VBA - Copy/Paste in new sheet + delete blank cells
  250. excel spreadsheet with macro to run without openning excel in specific time everyday