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:] No rush, just to improve myself
  2. Deleting Rows That contain specific content in two columns
  3. [SOLVED:] VBA: Export Certain sheets of a workbook as PDFs
  4. AverageIF function
  5. [SOLVED:] Run time error 52 - bad file name or number
  6. Can't locate bug of a Run-time error '438' message
  7. [SOLVED:] unmerge all cells a workbook from another workbook
  8. i want required vba. I am looking for a small value from the Range
  9. [SOLVED:] vba conditional formatting
  10. [SOLVED:] ByRef argument type mismatch
  11. [SOLVED:] Making multiple files.
  12. Macro update to copy data from sheet 1,2,3 into same sheet
  13. Shared Workbooks - against all odds...
  14. Print Results To Excel Worksheet
  15. Error bars on charts
  16. [SOLVED:] Wronf priority of events? picture in form not showing because heavy processing
  17. [SOLVED:] Make one loop with dynamic range (Find Last Cell)
  18. Combine Columns from different worksheets into one
  19. [SOLVED:] How do I update multiple worksheets based on one userform?
  20. [SOLVED:] Sub or Function not defined
  21. [SOLVED:] Working with "selection" instead of precise address= slow as a snail
  22. delete rows based on search criteria
  23. [SOLVED:] Splitting the content of a cell based on special characters
  24. Error 424: what am I missing?
  25. Help for using MID and INSTR in source code!
  26. VBA Dynamic Start Rows
  27. [SOLVED:] UF ComboBox Populate from Sheet
  28. [SOLVED:] Bypassing a dialog box
  29. VBA macro code to find and replace values in XMLfiles using Excel list
  30. [SOLVED:] error when vba editor opens by code 'not trusted'
  31. [SOLVED:] Workbooks object question
  32. Creating a master tracker to copy worksheets and perform tasks
  33. How do you extract only specific FormFields from multiple Word documents into Excel?
  34. Pivot data Filter VBA Code require
  35. Source code - Cant find something that ought to be there
  36. [SOLVED:] Extracting values from sheet 1 to sheet 2
  37. Activating multiple sheets with countifs function
  38. How to updated pivot tables on different tabs from user form parameters?
  39. ActiveWorkbook vs Application.Workbooks
  40. [SOLVED:] Serious trouble with running total calculations
  41. Find and replace words that are formatted with tags
  42. conditioned comboboxes
  43. What does '400' mean?
  44. VBC to highlight / select group of active cell
  45. VBA Get Data Java
  46. Assigning Headers
  47. [SOLVED:] UF Run Macro if LEN equals a number
  48. Max Frequency
  49. [SOLVED:] Getting values from merged cells
  50. Sleeper: Scaling chart based on values
  51. Create appointments on a shared Outlook calendar from Excel
  52. Help with Data copy from IE to Excel
  53. [SOLVED:] Getting values off another sheet by references!?
  54. [SOLVED:] insert name of tabs that had data copied in master tab
  55. [SOLVED:] Macro Button
  56. Run Macro Save AS
  57. [SOLVED:] Excel VBA to open a workbook that contains a string
  58. [SOLVED:] WorksheetFunction.HLookUP 1004 Error
  59. My greeting macro doesn't run automatically when I open Excel
  60. Custom Data Type - Dim Variable As CustomDataTypeName
  61. Extracting data, pivot tables, and maybe VBA help?
  62. [SOLVED:] Excel VBA to copy cells from password protected file into another file
  63. [SOLVED:] VBA Code for Combining Multiple Columns into One Column - Excel for Mac
  64. [SOLVED:] How to list all the files in a folder?
  65. First 6 minimum values of a row in an array
  66. Traffic lights - Increasing/Decreasing Trends
  67. [SOLVED:] Copy cells from password protected (to open) workbook into another file
  68. Calculation on matrix using formula
  69. [SOLVED:] Problem with Print All Sheets
  70. Help me tweak working VBA Code
  71. [SLEEPER:] Error 1004
  72. Put text in multiple cells
  73. [SOLVED:] VB to search for a key word in Column A, then copy it to column B for multiple rows.
  74. [SOLVED:] Help with array printing
  75. VBA code required to unhide multiple sheets
  76. Find maximum number of rows with text, then fill accordingly
  77. VBA code not finding values that contain numbers and letters....HELP!
  78. [SOLVED:] VBA code to track changes in workbook
  79. [SOLVED:] Userform with doubleclick filled with values of autofilter
  80. İf cell contains the number then copy certain cells to another book
  81. Run code every 24th hour for three days - fx?
  82. Is it possible to run code every 24th hour for 3 days?
  83. Re-Enabling Cut/Copy/Paste on Excel
  84. [SOLVED:] Conditional percentile calculation
  85. Sleeper: Adding a subroutine to a macro already done.
  86. Next loop without calling additional functions on error
  87. [SOLVED:] Create sub lists from main list
  88. Replace Query Database
  89. [SOLVED:] Using VBA in Excel 2010, need to change text of many cond formats, but how?
  90. Check if a text box exists in a webpage and if so then run code.
  91. [SOLVED:] prevent form to make the sheet scroll?
  92. Macros for saving the file with sertain file name
  93. [SOLVED:] VBA issue with renaming a file
  94. Create Button Shadow Effect
  95. Evaluate 3 columns of data and display 1 value in a 4th column
  96. Macro/VBA code help
  97. [SOLVED:] Help with syntax for nested dictionaries
  98. [SOLVED:] Error 1004 Application defined or object defined when code runs
  99. Write formula in VBA-'Error 13'
  100. Running a macro when double clicking a cell in another sheet
  101. Help with activating sheets
  102. [SOLVED:] Using stdev() function in VBA
  103. VBA Reference problem
  104. Copying formulas from 2 different workbooks
  105. Tweak VBA to Move SharePoint Files to a Folder in Same Location
  106. Quick question about my code that creates a 2D array
  107. how to grab filter list data
  108. [SOLVED:] VBA open password protected file in read only mode
  109. VBA to force paste special
  110. [SOLVED:] Anyone know how to - Range = typed array
  111. [SOLVED:] Selecting userform from cell content
  112. [SOLVED:] referencing a control type
  113. [SOLVED:] Macro recording gives different result in graph
  114. [SOLVED:] Return Column / Row name of active cell
  115. [SOLVED:] VLOOKUP Problem (duplicating lines)
  116. Excel vba string find and replace/change column value with a variable string
  117. reference combobox as a variable
  118. [SOLVED:] VBA Evaluate returns #VALUE for some expressions (SUMPRODUCT and IF)
  119. Sleeper: Help required regarding solving the excel problem.
  120. [SOLVED:] Need help with returning values from excel sheel to another using cell address
  121. BOM Challenge
  122. Filtering text data into n subsets then summing
  123. VBA to determine the rank of a matrix
  124. [SOLVED:] Match and copy.
  125. VBA Suchen und Ersetzen
  126. [SOLVED:] Find and copy from another sheet?
  127. [SOLVED:] Can VBA copy a table from Word and be pasted entirely into one single cell in Excel?
  128. [SOLVED:] Running a macro in a worksheet from a module
  129. [SOLVED:] vba to copy a content of cells marked green
  130. [SOLVED:] Pulling back Unique ID to excel
  131. Macro to copy information from the main worksheet by date and city criteria and paste
  132. [SOLVED:] Select specific sheets then run a copy row macro
  133. Macro SoS!
  134. Sleeper: Make macro more efficient
  135. Coding Assistance!
  136. [SOLVED:] find highest high and highlight it
  137. Using values from merged cells (VBA)
  138. [SOLVED:] 3D Z-Axis
  139. How to stop displayig a cell text in the formula bar?
  140. Hide columns based on cell value
  141. Help macro copying specific columns from one workbook and paste value .... in another
  142. Finding value in matrix
  143. Should I look for a solution?
  144. combox preload speed up
  145. [SOLVED:] Range of last used cell, Paste Data to last cell
  146. [SOLVED:] Make File Folders using data from column range
  147. [SOLVED:] Filter Data, Delete Rows, Then remove filter
  148. help me(filter in the listbox)
  149. [SOLVED:] Is there any event which catches an image being pasted into a workbook?
  150. [SOLVED:] Filter table for results within a date range
  151. [SOLVED:] sending email
  152. [SOLVED:] sending email
  153. [SOLVED:] working with Date&Time values / nested loops / Formatting
  154. Selection = <Type mismatch>
  155. Cannot surpress compatibility or auto calculate message..HELP!!
  156. Challenge... Very difficult coding HTML knowledge required Please Help!!
  157. Easy way to code all toggle buttons?
  158. VBA to Compare 2 Workbooks with Criteria and Paste Differences
  159. [SOLVED:] Exporting Single column as .txt file
  160. I need vba code Refresh all sheets and save
  161. VBA Code to search for value in worksheet and enter date into next column
  162. PLEASE help me with a VBA macro to filter data with mutiple criteria
  163. VBA Code is too long and slow to load data from on worksheet to another
  164. [SOLVED:] Replace only in text and numbers (not in formulas)
  165. Macro no longer works
  166. VBA S.O.S.
  167. I Need Help Conditional formatting in cell
  168. number of decimal (digits after dot) and other
  169. Sleeper: Download .xlsm from outlook
  170. What's the best way to create a custom user guide for a workbook?
  171. [SOLVED:] deleting empty lines in a word document after inserting text
  172. Pull innertext from 2nd and 3rd tables within each class name
  173. Delete some plot area
  174. Using VBA to change File Folder Properties
  175. [SOLVED:] VBA code skipping cells, not sure why?
  176. Do Until loop vs array
  177. Help needed!
  178. [SOLVED:] min value
  179. [SOLVED:] VBA Merge two tables into one
  180. Excel .xlsm + Run time error 1004 Initialization of the data source failed
  181. map xml to sheet whitout export
  182. [SOLVED:] Pivot Table Filter Macro Error
  183. [SOLVED:] For Loop with multiple conditions.
  184. Auto insert colon and decimal period
  185. [SOLVED:] Shell Command Duration
  186. Need your help!
  187. [SOLVED:] Macro that finds a semicolon, then copies and inserts rows, and removes some data
  188. [SOLVED:] Find and Replace in csv Files
  189. [SOLVED:] Find value of cell after filtering
  190. [SOLVED:] if sheet 9 exists, clear it otherwise create one
  191. Delete then restore all data tables in a workbook - fix for Excel 2010?
  192. If Statement ComboBox Value
  193. [SOLVED:] do until loop with if statement that applies on different columns (vba)
  194. Loop to set 250 strings to cell contents
  195. [SOLVED:] Checkbox - linked cells
  196. Cell values based on dropdownlist selection
  197. Combine Workbook_different worksheet(same Name) in one master workbook
  198. Replace content of column
  199. follow hyperlink change file location
  200. [SOLVED:] Copy paste help needed in macro
  201. [SLEEPER:] Delete Characters in a string
  202. [SOLVED:] Check Column N and if empty clean data on columns M,L,K
  203. dynamically inserting bars into a chart
  204. [SOLVED:] Clean the row if column F does not contain UDS or EUR
  205. VBA Code - Data from Access to excel
  206. Press ENTER instead of clicking on the button
  207. [SOLVED:] VBA Sum Records Which Match Monthly Column Heading
  208. Copy filtered records and paste another worksheet in Excel VBA
  209. [SOLVED:] Expiry date
  210. [SOLVED:] Formula Assistance Desperately Required
  211. [SOLVED:] Crossovers
  212. Find indices of value and return entire rows of these indices
  213. [SOLVED:] EXCEL FILE NOT SAVING IN VBS
  214. [SOLVED:] Shuffle Array VBA
  215. selecting ranges
  216. [SOLVED:] Conditional formatting
  217. [SOLVED:] Match Criteria on two Sheets and see if the Conditions are met
  218. [SLEEPER:] Unable to call Java web service via excel 2010
  219. For Each Loop Not Working
  220. Dates and Filters
  221. Find Values in Different Columns and Figure out where to place the values
  222. Subtotal in VBA with counta function
  223. How to find a string in excel VBA
  224. Lock changes to Pivot Table Rules
  225. Break/remove link
  226. Make conditional formatting (font color, number format) static
  227. Find or Match with alphanumeric fields?
  228. Colour Cell background based on cell values
  229. [SOLVED:] VBA to insert column and write concatenation formula
  230. [SOLVED:] Macro to Take a Worksheet from One workbook and Move it to Another
  231. [SOLVED:] Format Current Selection as a Table
  232. unique records to Main worksheet in Excel VBA
  233. Replace unicode charachters in a text file
  234. Selecting values from different rows in a table and merge them in order in one row
  235. How to split table into multiple worksheets based on one column and change its format
  236. [SOLVED:] where are these two excel workbooks coming from
  237. [SOLVED:] Automatically saving workbook containing macros as a macro-free workbook
  238. Get Data From Web Page
  239. help me with a webbrowser control please
  240. [SOLVED:] VBA Code - Set up condition to an Option Button
  241. Gaining Familiarity with VBA
  242. Print to txt file
  243. IF STATEMENT
  244. Pull Data from a closed/open excel workbook
  245. Copy cells from open or closed workbook
  246. [SOLVED:] Trouble getting word docs to print from Excel VBA
  247. [SOLVED:] Turning part of substring into capital for text data
  248. Generating sheets using several templates
  249. [SLEEPER:] Macro that Splits columns and creates .txt files with the data
  250. positioning charts