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

  1. Is it possible to display information from 3 cells side by side in a single cell?
  2. [SOLVED] Access records via Excel VBa between dates
  3. [SOLVED] how to copy the visible cells of a table to another tab?
  4. [SOLVED] Find vs Match
  5. [SOLVED] In a workbook in several sheets - each sheet several macro at once
  6. [SOLVED] range copy with paste
  7. VBA Change ODBC Connection String (Excel)
  8. VBA to change column to row and store the result in new column
  9. [SOLVED] Open CSV File Automatic Separating Comma
  10. [SOLVED] Automating Date Entry
  11. [SOLVED] compare date in number and product
  12. search for data and delete rows containing it
  13. [SOLVED] Finding non-zero minimum in a dynamic array
  14. [SOLVED] Transfer values from sheet to textbox
  15. Using Min() in VBA
  16. Move various duplicate rows to new sheet
  17. Varible help?
  18. Copy range of cells between workbooks with same named sheets
  19. Excel VBA - vLook-Up if match first 2 characters of one column with another column
  20. Help on Shell and Class module
  21. [SOLVED] Updating sheet with data from another sheet
  22. Excel VBA - Delete last row containing data
  23. [SOLVED] VBA conditional formatting
  24. [SOLVED] Call Sub in module from userform
  25. Check 2 column and Combine Data
  26. savecopyas in event
  27. Filtercopy does not return records listed with criteria value below 7 characters
  28. [SOLVED] Consolidate spreadhseets
  29. [SOLVED] GetElementsByClassName With IE8
  30. Workbook -macros query
  31. Wrong line in the macro.
  32. [SOLVED] Adjust error calculation in VBA
  33. html problem with vba
  34. [SOLVED] Need: VB code to get values from different closed workbooks
  35. Copy & Pasting Overwrites My Data Validation
  36. if find string copy that cell to right column
  37. vba code move cell to next cell
  38. Worksheet change clears selection(s) on MultiSelect type listbox.
  39. Help to use an array for this little section of code
  40. Excel slideshow and data query help
  41. [SOLVED] Copy sheet into another workbook and put in alphabetical order
  42. Percentage Difference for Two Percentage
  43. Have Macro run when cell is updated
  44. VBA Script to Average Amplitude Values in Each Bin Range of a Frequency Histogram
  45. Information sheet or message in xlam?
  46. [SOLVED] Change the macro to search for a specific word (as written) and not close to it
  47. Call previous dictionary entry
  48. Rename buttons using loop and "i + 1"
  49. [SOLVED] RTE Error
  50. Unable to set FormulaArray Property of the Range Class - Using Replace Function
  51. [SOLVED] Ie Automation
  52. [SOLVED] Populating Listbox
  53. [SOLVED] Creating a unique id
  54. help with copy range
  55. Search for a string on all excel files inside a ZIp folder
  56. VBA Calendar
  57. Rename Code Modules Programmatically
  58. Extract values of a certain format
  59. How to copy format of a column using spin button
  60. Total data if salary each month is the same - VBA
  61. [SOLVED] 2013 CalcPad.xlsm in XLStart folder. Open Excel - "CalcPad.xlsm is already open."
  62. PivotFields class returns an error when .Function property is set
  63. Change Cell Color on Sheet "Statistic" if value is negative
  64. trasfer data from Lotus macro to Excal VBA macro
  65. blank row
  66. Barcode fonts
  67. [SOLVED] copy not contiguous cells via VBA
  68. [SOLVED] Date overlap
  69. Find a "zero" of an implicit function
  70. VLOOKUP returns #N/A
  71. [SOLVED] User input to delete value in named range:
  72. [SOLVED] Help with Loops
  73. Copy data from different workbook and consolidate into one masterfile workbook
  74. Fill a combobox with data found in a range based on worksheet chosen in another cbx
  75. Bill of Material
  76. [SOLVED] RunTime Error 53 : File Not Found error
  77. XML Data I/O
  78. Code to Group Worksheets when Printing and Print Preview - 2003 vs 2010
  79. Exel Crashes with Form Control
  80. [SOLVED] Sum from previous sum formula in a column to active cell
  81. Sumifs and dates
  82. [SOLVED] struggling with excel combo boxes macro
  83. Help with code
  84. [SOLVED] Range, Columns, and Copy
  85. find matching entry, then copy and paste
  86. Excel as Notify Icon
  87. [SOLVED] Help to Improve Double Loop Code
  88. Edit VBA to prevent paste but allow copy and save the file with a file name derived
  89. Create a simple chart in a sheet where a pivot table already exists
  90. Create Sheet if Workbook name contain some text
  91. [SOLVED] Need a little help with "totals"
  92. FORCE TO POPULATE CELL
  93. Copy Paste from multiple worksheets into one based on multiple criteria
  94. import txt. file to excel with vba
  95. [SOLVED] fill months following
  96. Loop through subfolders
  97. [SOLVED] VBA Auto SAVE - need help!
  98. [SOLVED] Error: Overflow
  99. [SOLVED] Parse Text And Read Into Cells
  100. [SOLVED] Allow only choose 4 colors
  101. Check whether numbers are sequential?
  102. Importing data from Header and table in Word to Excel.
  103. [SOLVED] Changing formatting by writing all cells to an array
  104. Help in VBA
  105. Hidden worksheet codes not working
  106. SaveasUI - Save as .xls not XLSM
  107. [SOLVED] Subscript out of Range
  108. VBA Auto generate numbering
  109. Trouble setting pivot page filter using VBA
  110. Merging Word Documents From VBA
  111. New to VBA Coding
  112. Excel record aggregation with VBA macro
  113. Runtime error 445, need help
  114. [SOLVED] VBA Scientific Format. Can I reduce a digit?
  115. Mathematical Excel Optimisation Challenge (production of units)
  116. [SOLVED] Increment Column Selection with InputBox
  117. Question regarding loops sum and average
  118. Sales Returns for FIFO
  119. [SOLVED] Kill Files that Begin With Something
  120. [SOLVED] Automatic Generate random unique time From 8 AM till 21 PM in range
  121. Format search results in a Multicolumn Listbox With Headings
  122. [SOLVED] Date range
  123. [SOLVED] Adding New Chart Series with Loop
  124. String length mismatch
  125. VBA - Change Decimal Separator
  126. Optimize a VBA loop
  127. [SOLVED] Creating an Array from a Table with only one row in it
  128. [SOLVED] Acceptable to use Goto
  129. Hiding Cols With VBA
  130. automation error
  131. Compiling and Exporting Information
  132. [SOLVED] Case Senerio and Offset That Creates A Data Validation Box
  133. Array for ActiveX Controls
  134. [SOLVED] Trying to find the next empty cell in a range Using With and Set method - Help
  135. [SOLVED] Increase number every nth year
  136. [SOLVED] macro button for copying excel data into multiple word docs
  137. [SOLVED] Directly Copy A Range from One Sheet to Another
  138. How to compare text in 2 cells and highlight incorrect text
  139. Excel VBA to Unhide rows with a specific value in a Range
  140. Printing an Selected Sheets
  141. How to add row into another worksheet based on multiple cell values?
  142. Multiple Column Listbox (with headers) = the bain of my existence
  143. How to Avoid Formatting Cells When Protected?
  144. Automating the use of translation.babylon.com
  145. VBA Userform (for Entering Data)
  146. Lookup column value and find value
  147. [SOLVED] Userform for Entering Data in Excel VBA
  148. Slow Import from Web
  149. How modal forms work
  150. [SOLVED] Print a changing range based on date values
  151. [SOLVED] Put data from userform into specific place.
  152. [SOLVED] ListView Run-time erro "13"; Type mismatch
  153. Run-time error when using OraOLEDB.Oracle Provider
  154. Autofilter based on content in cells
  155. [SOLVED] Writing and Reading the Same Set of Ranges
  156. How to send email from excel using VBA with Cell Range (Including Images) as Email Bo
  157. [SOLVED] Download file, how do I know when the file is downloaded?
  158. Issues getting data in PowerPivot from Access
  159. [SOLVED] Iterate values through cell using VBA and record result
  160. Iterate values through calculation using VBA and record results
  161. Runtime error copying value from one worksheet to another in same workbook
  162. [SOLVED] Trying to add variables into Worksheet statements and can't get the right syntax
  163. VBA combo boxes
  164. [SOLVED] When does a Chart object become a ChartObject object
  165. Userform submitting a date in format "mmm-yy", but a small problem arises.
  166. VBA - Rounding Goal Seek result
  167. I Can't change <SELECT> html tag using VBA
  168. remove an item from a combobox.
  169. multiple word files tables to excel vba
  170. [SOLVED] Need Help Removing quotes and double quotes from my Excel Spreadsheet
  171. Merged mulitple sheets of existing workbook into one sheet
  172. Excel 2003, worksheet_change to insert current date when a cell is colored yellow
  173. Merge Single Worksheets from Different Files into One Workbook AND Replace Formulas
  174. trouble selecting sheet
  175. [SOLVED] Remove Text
  176. VBA Code - Novice Here, Sorry!
  177. Searching information in different bases
  178. [SOLVED] Worksheet not updating with data from VBA
  179. Update workbook data from another workbook
  180. [SOLVED] Code works in Macro, but not in Function
  181. creating Parameters in Excel using VBA
  182. Help Require in VBA
  183. [SOLVED] Problem deleting a legendEntry
  184. [SOLVED] Runtime Error 1004 on 2nd run
  185. Automatically Inserting Rows with Date, Each Worksheet
  186. Help with VBA Events - some work and some don't
  187. [SOLVED] Help me improve some old code
  188. Clearing contents of all worksheets in a excel workbook
  189. [SOLVED] Find every instance of a word, then find previous instance of another word
  190. [SOLVED] Correct Row/Column Numbers with INDEX and MATCH
  191. [SOLVED] Help With Worksheet Change event
  192. Calculate sub shift hours
  193. Adding Item to Reference Library
  194. [SOLVED] Help with a msgbox :)
  195. [SOLVED] Userform doesn't open unless Excel is the active application
  196. Delete Powerpoint slide which contains zero values
  197. [SOLVED] Find and Match Formula
  198. EXCEL/Quickbooks HELP!!!
  199. Complex Filtering & Copying With VBA (Need Help)
  200. Finding duplicates and replacing.
  201. One rate sheet - multiple customers/multiple rates based on the one sheet
  202. Help jump Columns
  203. [SOLVED] De-Duplication & Merge with multiple criteria
  204. VBA Help please (Novice)
  205. [SOLVED] Delete duplicate rows Excel 2003
  206. [SOLVED] VBA MsgBox Width in WIN7
  207. [SOLVED] Excel Crashes when Saving workbook
  208. [SOLVED] FileSearch Macro error
  209. VBA Help Needed with Dynamic Sum Formula
  210. Utilizing Stored procedure parameters in VBA
  211. Annual Time Sheet (including flexi/TOIL) - Enter Negative Time/hours
  212. VBA / Excel / Formula / Examples
  213. count numbers that are in two sets of numbers
  214. Problem with ProgressBar
  215. [SOLVED] Rank/ Sequence of Repetition
  216. Copy and Paste if Value changes
  217. IE.navigate not working on VPN
  218. To obtain the coordinates
  219. How to create VBA Function from VBA Macro - Inverse of Matrix in Excel VBA
  220. [SOLVED] Formula Q: referencing first column number that meets specific criteria
  221. [SOLVED] Calling custom class method through variable
  222. Replace All fires WS_Change for every cell
  223. Check If Files In A Folder Are Open Without Knowing Name/File Type
  224. [SOLVED] Lookup up formula
  225. Setting a timeout for Excel workbook
  226. Import Sharepoint list into Excel
  227. Macro for inserting new rows conditionally.
  228. Help with code
  229. Copy cells from an open workbook to a closed workbook
  230. [SOLVED] Close workbook without save prompt?
  231. 2013 Slicer Events
  232. Excel functions
  233. [SOLVED] Is this efficient?
  234. Need Macro to Copy and Ignore Duplicate
  235. macro to find modified date of file
  236. [SOLVED] What does it mean to click on a cell?
  237. Possible to have a macro "Rewrite" another macro?
  238. Export / Print all Charts in Workbook to PDF
  239. [SOLVED] How to use the AddComment method of the range object
  240. Issues getting text into a text box on a website form
  241. Latest file name in the folder path
  242. file exists or not
  243. [SOLVED] Headings in formulas
  244. PowerPoint crashes while copypasting diagrams from Excel
  245. Login into intenet website not recognizing password via VBA code from excel
  246. Input date into input box on website not working correctly
  247. [SOLVED] Small Delay when showing Form
  248. [SOLVED] Ratio being force formatted into Time
  249. [SOLVED] Counting specific figures based on pivot table data
  250. [SOLVED] Wildcards with Replace in VBA