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. Creating New File Off Template and then some EXCEL MACROS
  2. how do I work with objects (pass objects to objects?)
  3. [SOLVED:] One sub Button Two Macros
  4. Text populate containing more records based on date
  5. Macro to copy data from different cells and paste in new sheet
  6. [SOLVED:] Loop through a dynamic range and apply code in a seperate sheet
  7. Based on Condition Merge and CountIF & Apply
  8. [SOLVED:] Change 'Entire Row delete' to 'cells in columns A-G'
  9. Changing the value of a pivot item
  10. Finding First Value that Falls in a Range Across Multiple Columns
  11. [SOLVED:] Deleting positive values in 45,000 row database
  12. [SOLVED:] Macro to Consolidate multiple workbooks into new workbook based on criteria
  13. Macro has working very slowly; How to speed up this macro.
  14. [SOLVED:] Method Intersect Error
  15. add individual rows to outlook calender with button
  16. Copying part of a Text String of different lengths
  17. [SOLVED:] create a new checkbox and assign its ID?
  18. SAS add in Advanced VBA question
  19. [SOLVED:] VBA: Mixing Relative & Absolute References
  20. Importing Images Into Excel 2013
  21. [SOLVED:] Objects and invalid use of property
  22. [SOLVED:] Trying to check if a checkbox is checked
  23. Screen capture (print screen) to new Excel workbook or Word
  24. Arranging data datewise
  25. Print sheet after update shapes/images
  26. [SOLVED:] #REF!
  27. [SOLVED:] Selecting and deleting rows based on criteria
  28. [SOLVED:] Excel Save Error
  29. [SOLVED:] Supply one password to unlock all code in workbook
  30. OPEN: Excel Macro Save As with a new file name
  31. Formula for a table which does not exist
  32. How to Arrange telephone directory ocr image in excel, in table form
  33. combo box error
  34. select and replace cell
  35. [SOLVED:] Load a Multidimensional array
  36. VBA code to sort a sheet
  37. [SOLVED:] Detecting "Protected View"
  38. [SOLVED:] excel VBA - Listbox only populating one result!
  39. Return combinations of the most popular choices
  40. Call macro by typing "Enter"
  41. [SOLVED:] Add value to existing named range via inout box
  42. [SLEEPER:] VBA code for distributing available stock
  43. [SOLVED:] Need to combined 87 xlsx worksheets into 1 & append source filename to each record
  44. Grouping with Regular expressions in EXCEL 2010 VBA
  45. VBA problem with alternative to index match formula
  46. [SLEEPER:] Perdictive Pattern matching algorithm
  47. [SOLVED:] VBA Create Sheets and Add Formula To Each Cell In Range
  48. macro code working for 1 file but not when trying to apply for the range of files
  49. [SOLVED:] Rows to Column (Transpose) with one Heading
  50. Send Email Via Excel and store a copy in Excel
  51. Sort by second column in listbox
  52. macro causes Excel to 'crash'
  53. Categorising data by time
  54. Copy fields from active task to active worksheet
  55. Search Excel file
  56. MOving and Sorting Data Marco from master sheet
  57. Worksheetfunction.countifs not working
  58. Need help with VBA find match
  59. [SOLVED:] Display search terms in another cell
  60. [SOLVED:] Look for #N/A sign then copy paste
  61. [SOLVED:] Row count +1 on data import
  62. [SOLVED:] Populate form label with cell value
  63. VBA for multi-colored pivot chart bars?
  64. How to copy past only the cell marked in red
  65. [SOLVED:] Saving Symbols as a variable
  66. Search Folder looking for File Tags
  67. [SOLVED:] Return Multiple Values based on Lookup Value
  68. [SOLVED:] VBA Create Sheets & Copy Data
  69. Select or Filte Row Based on Single Cell Colour?
  70. CountIFs based on Data Validation boxes
  71. Display all matching values in one comma separated cell
  72. Modifying This Macro Slightly Please
  73. AutoSum >40
  74. VBA - phrase search and filtering
  75. How to create multiple buttons in excel linking to each row
  76. Script isn't copying all values in the criteria correctly and need help displaying
  77. Call Outlook Macro form Excel
  78. Not VBA, but a IF & AND problem
  79. How to Trigger an event
  80. combine 2 macro code in to one so that i can use it in single sheet....its urgentttt
  81. [SOLVED:] help with cell values -if same then mark as "duplicate"
  82. [SOLVED:] Copy PDF
  83. PivotTable: CD count not track count.
  84. Help needed to track user changes on a worksheet in different columns for each user
  85. [SOLVED:] Checking if cell value is within +-15 from next one.
  86. Help with creation of Word Document from Excel
  87. [SOLVED:] Searching for one of many text strings in a cell based on a text string lookup table
  88. Get the position of the data in the table
  89. [SOLVED:] What is happening with this function
  90. [SLEEPER:] Prefill cells with command line switches from a browser
  91. Break each external links in a cell and replace with the current value of each link
  92. attachment download from outlook
  93. Reply on open Outlook item by Excel VBA
  94. [SOLVED:] POP UP VBA!!
  95. Cell Values getting truncated when converting an excel 2010 file to dbf 5
  96. How do I disable auto text to columns with VBA?
  97. Help Subtract value and update cell in another workbook
  98. [SOLVED:] Grouping not working properly using slicer for pivot data
  99. How to rename cells
  100. Problem sharing program with another computer
  101. [SOLVED:] VLOOKUP only if #N/A found
  102. [SOLVED:] Creating excel file using VBA - File name to contain the current date and time
  103. What exactly is VBA?
  104. VBA Excel Help Selecting Multiple Pages
  105. [SOLVED:] VBA Automatic Rolling Column Headings
  106. [SOLVED:] Trying to solve count
  107. [SOLVED:] On Error GoTo ???
  108. selecting specific rows
  109. HELP- Vba to copy Word to Excel
  110. [SOLVED:] HOw to run a macro automaticcaly when open a workbook
  111. Sleeper: Macro to delete rows in result of advanced filter.
  112. Extracting 4 digit number from combobox, looking that up in a worksheet column etc.
  113. File attached
  114. ListBox.ListCount limit in Excel 2010, and/or previous years...
  115. Copying table from Excel, and saving error
  116. [SOLVED:] Reverse columns and Rows
  117. trying to copy a cell to a different cell automatically
  118. [SOLVED:] UF validation based on date
  119. [SOLVED:] How to jump next to column
  120. [SOLVED:] from a string, how to get the equivalent constant value?
  121. [SOLVED:] design ideas for UF and multiple users
  122. select the second row of the result of advanced filter.
  123. Code VBA checkbox and optionbox
  124. Formulas help
  125. Macro to find a cell containing text, select range offset, cut and paste to lower row
  126. VBA User form and Coding help
  127. VBA code edit to populate to end of data
  128. VBA code error
  129. Listbox Problem
  130. [SLEEPER:] Matching First Name & Name Text Boxes on Form with Corresponding Columns TROUBLESHOOT
  131. [SOLVED:] Before_Close Sub
  132. [SOLVED:] Pull Data from Sheet3 to Sheet1
  133. [SOLVED:] Delete a known named range from a known cell
  134. Password Protected code needs editing Employee no longer with Company
  135. [SOLVED:] Removing last six characters from a string
  136. [SOLVED:] First unhidden column
  137. How to find worksheet that contains an error (with 100+ worksheets in it)
  138. Pull Data From One Worksheet To Another
  139. [SOLVED:] Overwrite write reserved file with updated copy (same name; also write reserved)
  140. How to delete rows if a cell is red?
  141. macro to delete data based on time
  142. [SOLVED:] Search a string to contains....
  143. [SOLVED:] Variable coping
  144. macro to delete row if cell is empty
  145. [SOLVED:] Add to Column Next to Selection
  146. [SOLVED:] Running a script from a blank workbook and apply to specific files in specific folder
  147. macro opens the desired file and paste the information in a selected from me sheet
  148. Excel freezes after running Macro
  149. A macro that adds up prices and sorts them in categories
  150. [SOLVED:] Check Label for certain text
  151. Worksheet_change event executed on a wrong sheet?
  152. Multi Columns, Multi Listbox Form
  153. VBA Conditional Formatting Not Working Properly
  154. [SOLVED:] Name Splitter Help
  155. [SOLVED:] Look/Match specific text based on similar column criteria
  156. List view for VBA Excel Macro
  157. [SOLVED:] Extract 1st 4 letters of last name..ideas?
  158. Using a drop-list to categorize and insert cells
  159. [SOLVED:] Request to Modify Macro
  160. [SOLVED:] Delete Row if Cell Contains More Than 10 Characters
  161. [SOLVED:] VBA SUM question
  162. [SOLVED:] Formula be replaced with macro
  163. Macro speed
  164. [SOLVED:] Subscript out of range Multidimensional Array
  165. [SOLVED:] if does not find matched value data with data on cell delete the row
  166. [SOLVED:] Do While Loop will not execute
  167. Categories List
  168. Create Output File
  169. Evaluate content control title and move to correct column
  170. [SOLVED:] Copy row cells to powerpoint
  171. Normalise Pivot Table
  172. VBA Macro stops working after opening the VB Editor
  173. Redim Preserve array problem
  174. [SOLVED:] Multiple Goal Seek Code - Only Solves the First Row
  175. [SOLVED:] if cell start with 0 clean the cell from A to Z
  176. [SLEEPER:] Creating a macro for next empty row
  177. [SOLVED:] if find none numeric data on cloumn A just clean the column A
  178. [SOLVED:] Creating a combined formula with erow macros
  179. Conditional Min and max in a hour format
  180. [SLEEPER:] How do I delete something based on headers?
  181. [SOLVED:] "mypath" causing a problem in a network drive
  182. Not able to design pivot based on requirement
  183. Overflow error.
  184. if find the matched data in another workbook copy the complete row
  185. Worksheet to find values of a sheet and copy the column
  186. Fill in between the points on a scatter plot
  187. [SOLVED:] Unable to use Validation
  188. [SOLVED:] MID Formula help - when last digit value is 0
  189. [SOLVED:] Handling Strings with seperators
  190. [SOLVED:] Remove the limitation 65536 rows
  191. advanced replace macro
  192. [SOLVED:] Search all open workbook and if find the match data , clean the cell on Column A
  193. Combine macros
  194. date falls on monday display the date of saturday
  195. [SOLVED:] Using a Variable in creating a Validation List
  196. [SOLVED:] Working With Subset Of Data
  197. Use of operators in Text Boxes inconsistent?
  198. Using vba to populate data into a master workbook
  199. Simple excel macro help required
  200. Combo Box Data Validation Macro
  201. [SOLVED:] Find and replace question
  202. Excel 2003 Macro, no longer working in 2010
  203. [SOLVED:] Replace Cell Date with text
  204. vba macro code for finding the common entry names
  205. [SOLVED:] Macro in 2003 works, in 2010 doesnt work (part 2)
  206. [SOLVED:] What to do with my Excel .xml file
  207. [SOLVED:] Footers question in VBA
  208. [SLEEPER:] VBA and NumberFormat
  209. Updating Access from Excel UF
  210. Opening Excel Automatically
  211. [SOLVED:] UnProtect al files in a folder
  212. Setting print area and borders.
  213. I Need Eidt Code Copy And Paste
  214. [SOLVED:] Export and import CSV Date format proble in Excel2010
  215. [SOLVED:] Please help with my ListBox
  216. [SOLVED:] Delete File In Use error
  217. [SOLVED:] Merge and Combine data
  218. Filter specific data to a new workbook
  219. Need Help For Excel VBA Coding Convert to Addins (or) dll
  220. Can not run VBA use data from other excel file
  221. [SOLVED:] Check sheet1 Copy duplicate items rows on sheet2 to sheet3
  222. Help for transferring the raw computation to Excel VBA in financial situation
  223. [SOLVED:] Automatically give new sheet name (created frm template w/macro) the value of a cell
  224. find and move the duplicate values in another sheet
  225. [SOLVED:] Macros - dates in a column and display months in another column
  226. [SOLVED:] Removing web address references / placing ... on a cell after 397 characters.
  227. [SOLVED:] time calculation problem
  228. [SOLVED:] Referece to Formulas R1C1
  229. [SLEEPER:] Extracting Image information using Data Modified from Folders & Subfolders
  230. [SOLVED:] Automatically sum cell values from new sheets (that are not created yet)
  231. Select multiple worksheets using list contained in worksheet
  232. Barcode Scanner Excel Lookup
  233. vba excel populate textbox into listbox
  234. Closing Excel when UserForm closed (only if not an admin)
  235. Copying & pasting the Data from Multiple sources to corresponding multiple destinatio
  236. [SOLVED:] Function data type issue
  237. I Need Help Vba Code Automatically Sort Rows Largest To Smallest
  238. Run time error 424
  239. Is it possible to display information from 3 cells side by side in a single cell?
  240. [SOLVED:] Access records via Excel VBa between dates
  241. [SOLVED:] how to copy the visible cells of a table to another tab?
  242. [SOLVED:] Find vs Match
  243. [SOLVED:] In a workbook in several sheets - each sheet several macro at once
  244. [SOLVED:] range copy with paste
  245. VBA Change ODBC Connection String (Excel)
  246. VBA to change column to row and store the result in new column
  247. [SOLVED:] Open CSV File Automatic Separating Comma
  248. [SOLVED:] Automating Date Entry
  249. [SOLVED:] compare date in number and product
  250. search for data and delete rows containing it