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

  1. Create Combined Table from 2 Tables
  2. [SOLVED] Using Items sequence numbers in order
  3. match multiline textbox item to coumn B3 in excel
  4. Write a total number of hours each month into appropriate cell
  5. On Error Issues
  6. Run-time error '429': ActiveX component can't create object
  7. [SOLVED] Is Variable Allocated
  8. [SOLVED] Macro needs to recognize existing filename
  9. Looping through and Deleting data in Pivot chart
  10. [SOLVED] Extracting values from cell where total has been rounded
  11. [SOLVED] Code Not Iterating Each Worksheet
  12. Sheet Reference error
  13. [SOLVED] Tab Button Control
  14. [SOLVED] Formula
  15. Writing a loop with an offset and storing value in code while summing
  16. [SOLVED] Count functions, mostly at COUNTIF() Question
  17. Cant access functions from a VBA add in
  18. Web Service Call and Authentification
  19. [SOLVED] FileDateTime Question
  20. How to apply the colour of a cell to another when its an exact duplicate
  21. Automate copying rows based on counter number increment
  22. Hi there
  23. Strange behavior of for... next loop
  24. 'Double' Random Selection in VBA
  25. Efficiency Help
  26. VBA for Import worksheet Selected Range Data from Another Closed workbook
  27. [SOLVED] Diary System - automation
  28. Extract specific data from a website
  29. Read Data From Excel File W/O Opening
  30. Add-in uninstalls after running on a CSV file
  31. [SOLVED] Sending OutLook message no Attachment
  32. Sheet Reference based on a Cell Value???
  33. [SOLVED] Looping through cutting and pasting values between two dates
  34. [SOLVED] Splitting first, middle initial, and last name
  35. (VBA) Conditionnal formatting with multiple conditions
  36. Help! Error whilst record Macro ""Too many line continuations"
  37. [SOLVED] Show userform without showing excel
  38. SQL Server Connection problem
  39. Help Getting Started (New Project)
  40. VBA code finding duplicates in two Excel column.
  41. VBA Code for VLOOKUP
  42. VBA codes to draw charts with data from multiple sheets
  43. [SOLVED] Looking for similar value
  44. Regex expression to retrieve data from HTML
  45. How to make print area fit entire page?
  46. [SOLVED] Fill Userform textbox after clicking in sheet (return column number)
  47. scheduled task & can't create outlook object
  48. Funny Formating
  49. Excel crashing every time I run my macro
  50. Delete all Datalabels on Chart Except Current Dates
  51. Need help improving this VBA Code to make it run faster
  52. New to VBA! Code for a sales calculator, how to output tables to user interface?
  53. [SOLVED] Link to Word document
  54. Macros/VBA to do a loop and insert text
  55. Chart pop up
  56. [SOLVED] VBA Timer?
  57. VBA dropdown help
  58. [SOLVED] Weeks and Months
  59. [SOLVED] Connecting to Access 2010
  60. populating dynamic arrays from a dynamic array
  61. VBA Small Weather Forecast Spreadsheet
  62. Excel VBA Multiple Automatic Goal Seek Required Please Assist us
  63. Real-Time plus Countdown Timer
  64. VBA for calculations
  65. VBA to run formula on Selected cells
  66. [SOLVED] Help need to inser Carriage return in chart series name.
  67. HELP! application.filesearch wont work in excel 2010
  68. Enhancement of "Find text in Workbook and create link to cells"
  69. [SOLVED] Generating formula for summing time / date values.
  70. Highlight Adjacent Cells Above Highlighted Cell
  71. Clear styles error
  72. HELP - SUMIF more than 3 conditions + operations in the sum
  73. Which copy/paste option
  74. Compiling data questions
  75. Reoccurring Data Transfer
  76. Issue with pictures upload using vba code into excel- they disapear
  77. Change value of adjacent cell if field in form matches
  78. [SOLVED] Failing miserably at populating combobox
  79. Vba to copy excel worksheet orientation to word document
  80. Checking in a Document in SharePoint from Excel Macros
  81. [SOLVED] REFERENCING A VARIABLE FORM NAME
  82. Searching for multiple values in string
  83. VBA script to help sort and distribute data
  84. [SOLVED] Excel VBA - Open Word template and create bulleted list based on cell values
  85. [SOLVED] Scoring data by finding duplicate names.
  86. [SOLVED] Look For Sheets Wildcard no Loop
  87. Opening multiple doc/html files into excel worksheets within a single workbook
  88. [SOLVED] Help with vba Code
  89. TimeSerial does not reflect Windows Regional Settings
  90. Calculating difference between months
  91. Save As PDF in a particular order
  92. VBA Code Help Needed. Lookup Value Ranges
  93. [SOLVED] How to make Todays Date visible on Pivot Table Filters
  94. VBA to stop dsiplaying the debugging option on pressing CTRL+Pause Break
  95. Paste values copied from a webpage
  96. [SOLVED] Find and extract information from multiple excel files
  97. Please help spot the error!!!
  98. VBA-code Import from website to excel
  99. calculate data and find outliers
  100. [SOLVED] Extract numbers from text string
  101. [SOLVED] splitting a range to a variable number
  102. Index Match Match
  103. VLOOKUP with a SUM
  104. Filter dates and blanks
  105. [SOLVED] if find the spicify word copy data
  106. User-Defined Type Not Defined Error
  107. Looping and combining macros - help needed
  108. Almost there: Loop to search website
  109. [SOLVED] Find the last cell in a column conditionally formatted
  110. How to find certain cells and add up adjacent cells
  111. BOM Compare - compare between tow versions of data
  112. formatting numbers extracted with a web querry
  113. [SOLVED] interpolate value Every at Chainage 1750
  114. Search for and extract data from one Excel workbook and paste in another Excel workb
  115. [SOLVED] Count distinct values in an array
  116. Minimizing error to fit numerical data points into categories.
  117. VBA: Workbook re-open after closing
  118. [SOLVED] Move Pivot Table row to end automatically
  119. [SOLVED] Counting Names in List that have completed any one of a Number of Courses
  120. Find All files in a Folder that were created and/or Modified after a set date (x), Op
  121. variations on import vba
  122. Permutation List Code
  123. [SOLVED] Overlaying Shapeor Picture based on contents of a cell
  124. loop to go through a list find an empty cell and then place something in the cell
  125. Find date and return value
  126. [SOLVED] vba to keep the focus on userform last used textbox
  127. Open PDF file after creating multiple pages into one PDF
  128. [SOLVED] Excel loop
  129. VBA help loop search and check status of item
  130. [SOLVED] is sheet selection by variable possible?
  131. [SOLVED] Identifying mixed Managers
  132. Access different tabs in Excel forms
  133. Macro to save in txt format web pages
  134. [SOLVED] Range selection fail when integrating with PowerPoint
  135. VBA, retreive information from a word document and store it in the Excel
  136. keyboard shortcut to copy the url of a cell
  137. VBA code required:Compare sheet1 with sheet2 and copy the difference
  138. [SOLVED] Fast compare values of Non-Contiguous Cells row in two different workbooks
  139. Search a table on a website for a word & extract the 3rd cell to the Right of it.
  140. #Value error msg in VBA code
  141. Formula won't work past a certain date
  142. How to add alternate column in worksheet
  143. Send Macro cell rang as attachment to outlook with default signature
  144. [SOLVED] Cell formating
  145. [SOLVED] SendKeys really working
  146. [SOLVED] Macro to compile a list in another workbook
  147. Setting column number and row number to variables leads to lots of issues
  148. Modifying excel data through VBA
  149. Creating letters quicker from spreadsheet
  150. Hi
  151. Default Cumulative Cost Curve (VBA)
  152. Macro Keeps changing date to American format
  153. VBA - the lowest number not working
  154. Problem solved - sorry
  155. Save as user form
  156. [SOLVED] How to enable macro
  157. MacBook Pro Comparison
  158. Runtime error 462
  159. CountIf Help
  160. scrape excel sheet embedded in an intranet page
  161. Used Opentext command, - How do i select the pop-up Workbook?
  162. Weather Forecast Spreadsheet User Form Help
  163. Update variabel to be = string, specified in a cell?(Splitting a cell and distribute)
  164. Tracking old & new formula changes & other changes w/ links to original cells
  165. [SOLVED] Time/Date Formula for Analysis
  166. Halp! Excel data exporting
  167. Table of content or Hyperlink for different Table Name in work-book
  168. [SOLVED] Summing of sheets macro needed.
  169. Enlarge and restore an embedded chart from a group of charts
  170. [SOLVED] Show in Label value in cell specific column (everey minute)
  171. can anyone see an isue with this line? object defined error
  172. Match words in 2 cells
  173. VBA - importing all excel files in subfolders
  174. [SOLVED] Copying to another sheet.
  175. Return data from different sheets and variated cells Macro
  176. Linking numerical value occurrence to a date
  177. [SOLVED] Loop in VBA
  178. [SOLVED] Find and replace macro bugging out with finding #VALUE!
  179. Calendar not linking to Userforms.
  180. [SOLVED] KB: Group All Command Buttons on a Userform
  181. Automated Data import from website
  182. Vlookup through VBA: Dynamic Range
  183. Excel - Send sheet & use range as body
  184. Export Excel 2010 to Project 2010 VBA adding columns to Project
  185. Create a Stopwatch for time study
  186. [SOLVED] eliminate question mark box when enter key is pressed
  187. [SOLVED] If Condition returns Formula
  188. search rows in VBA
  189. How To Create Macro To Pull Tables From SQL Server
  190. [SOLVED] How to produce two workbooks from a larger workbook
  191. [SOLVED] Current Code works, then when I add a line, Excel Crashes
  192. VBA Code Cannot Access Database In SQL Server
  193. Any 64-bit Office users?
  194. [SOLVED] trouble viewing code
  195. Insert data inside filed form in WEB
  196. Macro to sum between headers
  197. Enable Maximize button and change userform size by manually dragging borders. VBA
  198. VBA - Excel/Word 2007 - Using excel to compile a report in word
  199. [SOLVED] Clean the row if column B to O is empty
  200. [SOLVED] Referencing a subset of text within a cell
  201. [SOLVED] How to search values in external workbook and pull out information from the same line
  202. Find 2 identical values in 2 columns - looking for error message
  203. Run time Error on Save Data
  204. use arrow in vba formula?
  205. Need help with VBA passing an argument
  206. [SOLVED] Clear worksheets from list
  207. Syntax to identify if something does NOT match a Wildcard?
  208. Create individual folders for next day
  209. HELP: How to format certain texts enclosed by specific characters
  210. Excel vba jump to specific row in worksheet
  211. NEED CORRECTION IN MACRO
  212. [SOLVED] Optimizing VBA code so that it can execute on a workbook of 50,000 rows w/o crashing
  213. Need a VBA coding
  214. sortind dates
  215. help me please
  216. [SOLVED] VBA - Determine cell value of specific column and row in userform
  217. [SOLVED] VBA Sorting multiple rows
  218. Various items - exporting to various .txt files where duplicates
  219. Excel vba copy paste with formulas
  220. [SOLVED] Showing help on object elements from a form?
  221. [SOLVED] Combi Box disappearing from the screen.
  222. [SOLVED] Summing of multiple totals.
  223. Combine data from many worksheet into one worksheet
  224. VBA for Page Headers
  225. How to save each change in list in new workbook
  226. Remove Duplicate macro, modify to delete adjacent cell
  227. VBA Match & Copy
  228. [SOLVED] What did I miss? (get constant value from the string text)
  229. Printing Visible Data Only
  230. How can I fill Database with VBA on Mac?
  231. Moving duplicate and unique values from one sheet to another.
  232. [SOLVED] Pivot table not showing the selected items when filter added
  233. Recognizing linked changes, Worksheet_Change(ByVal Target As Range)
  234. Validation Of Names Required from given List :confused
  235. Macros - Upgrading from Excel 2003 to Excel 2010
  236. Help sorting data
  237. User must fill in certain cells before they can close the workbook
  238. allocating the totals - to numbers equally
  239. VBA Creates Pivot Table Except when Row 1 is blank
  240. VBA help: Copy, offset, add cells, repeat, all on one button?
  241. Excel VBA user form
  242. Getting 1004 Error from sorting a range and cannot figure out why.
  243. opening a word document
  244. Syntax to selecting multiple columns/particular column with its contents in Excel VBA
  245. ActiveCell.Offset(1, 0).Range("A1").Select?
  246. VBA Type Mismatch Error on Pivot Table Creation
  247. [SOLVED] Problem Copying two Sheets from one workbook to another workbook
  248. VBA assistance required for copy values
  249. Need Help: Changing Date Formatting, Filter Unique Value, Sort
  250. [SOLVED] Looping Through Calculations