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