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. [SOLVED] Vlookup and Type mismatch error
  2. Clear contents in multiple range and multiple sheets
  3. [SOLVED] select the first value from data validation list
  4. help to Write a code to put value copy two tyms and columb values to row
  5. need help to copy rows to a new sheet depend on a cell value
  6. copy paste macro
  7. Prompt for narrative on saving spreadsheet
  8. VBA and SQL - help with update statement
  9. checking for duplicates and deleting duplicates
  10. [SOLVED] Copy data to other sheet
  11. consolidate data from multiple excel files into single file
  12. [SOLVED] Look for specific date
  13. VBA Multiplication Formula
  14. VBA Code to select value from Popup dropdown
  15. Window 8 PutInClipboard error
  16. [SOLVED] Macro running but populaing wrong cells
  17. Can not run SQL update statement
  18. (Help) Moving row with the macro
  19. [SOLVED] SUMIF formula
  20. [SOLVED] IF / AND within VLOOKUP formula
  21. [SOLVED] manipulating bmp files
  22. Excel Crashes and macro runs slow
  23. [SOLVED] Data connections have been disabled
  24. Saving A Excel Macros File
  25. Copy data to other sheet
  26. RETURN COLUMN SUMPRODUCT
  27. Generate number when userform information is submitted
  28. [SOLVED] vba macro code for counting total days above 32 degrees, 33, 34, and goes on..
  29. [SOLVED] Compare/match name list in sheet with sheet names and delete extra names from list
  30. Help with ActiveX installs (date picker)?
  31. [SOLVED] Vlookup: Wildcard in Reverse
  32. want to compel user to enter data to both col B and then col C if data is in col A
  33. Display a simple Access Database onClick
  34. Sending emails with attachments from excel
  35. Help please
  36. [SOLVED] Need code to merge PDF files in a folder using adobe acrobat X
  37. [SOLVED] VBA Create Unique Distinct List From Three columns
  38. [SOLVED] Set a variable based on another variable
  39. Excel weird behavior when connecting through ADODB
  40. Dumb question - onLoad?
  41. Create Time Log Based on Workbook.Activate/Deactivate events
  42. VBA runtime crash - Listrows.add
  43. Displaying an SQL Select Statement Help
  44. Clear contents
  45. help with uniquevalue function
  46. Run macro from an already open workbook
  47. I need good examples how to traverse xml file
  48. [SOLVED] Excel data import once only and save as new file
  49. Listing folder names in a column
  50. User form, VBA and timediff
  51. [SOLVED] Working With Specific Named Ranges
  52. Count Number of Targets Reached
  53. Import Table With No ID From Internet
  54. Run Access Macros in Excel
  55. [SOLVED] Match numbers and highlight
  56. [SOLVED] Force user to save as new file and NOT overwrite MASTER file
  57. SumIf Dynamic Range
  58. [SOLVED] On Error Close Worksheet
  59. [SOLVED] Chart title not updating
  60. [SOLVED] update pivot dynamically based on range in separate worksheet
  61. [SOLVED] selecting the newest date
  62. Simple Link to Access code
  63. [SOLVED] Mismatch error
  64. What's the best approach: Need multiple queries displayed on Excel on the same page
  65. VBA To Send Warning When The User Hasnt Worked In The Workbook For X Minutes
  66. Pasting into cell changes format - can this be stopped?
  67. Running Macro when Data Valaudation Cell Changes
  68. Navigate Webiste and click on link/button using vba
  69. [SOLVED] Why is this loop not working?
  70. Sending email from Excel
  71. Can Excel run this big SQL?
  72. [SOLVED] R1C1 and using variable in array formula
  73. Excel dashboard based on Outlook data with events
  74. VBA getElementsByTagName Issues
  75. [SOLVED] Loop Data validation list item and generate PDF for each
  76. Error code 438
  77. Search for a string with " char.
  78. [SOLVED] VBA Separate monthly data into weekly data
  79. [SOLVED] TextBox Editor
  80. [SOLVED] dayly data to weekly data
  81. [SOLVED] delete all sheets and charts except "Input"
  82. Using datevalue with different languages
  83. [SOLVED] Proper syntax to sort columns (only identified in variable)
  84. [SOLVED] vba macro code for filtering from the given numbers.
  85. VBA merge without creating new sheet
  86. Macro for copying specific values from one excel file to another
  87. VBA- Skipping word in column of data and displaying result in other sheet
  88. Copy my files + Date
  89. Macro to find a word and select a range based in their position
  90. Scrolling down flowchart
  91. Copying a (variable) range from multiple worksheets to a summary worksheet
  92. [SOLVED] Count filled Cell where having number Only
  93. Generate path of a file in column and send email as attachment based on a cell value
  94. combobox to populate listbox
  95. [SOLVED] copy entire row to another sheet if cloumn A contains numeric data on Cloumn A
  96. Offset command for specific row display
  97. My code works for a single row, but how do I make it work for all rows?
  98. Opening multiple files and applying a macro to all of them
  99. [SOLVED] Plz help, Macro needed for If the file opened from folder, do this
  100. VBA: Change conditionally highlighted rows from current date to 24 hours
  101. [SOLVED] Duplicate Master from Brettdj
  102. [SOLVED] VBA Black Scholes w/Greeks and Conditional Formula
  103. Excel Macro help with Outlook email
  104. [SOLVED] Help transforming dates and rounding numbers using VBA
  105. Best approach to filter on a value, but showing all lines concerned by same object?
  106. [SOLVED] Paste data to another sheet and do sum and Multiply.
  107. [SOLVED] Transposing in VBA
  108. [SOLVED] Multiplied of 2 column
  109. Find duplicates in each column, then delete rows containing only Subsequent duplicate
  110. VBA to Self Destruct File
  111. List Conditional Formatting on Separate Sheet
  112. Search & Replace
  113. What to do when Text is found in a row?
  114. Help Organising Data
  115. CountIf with date
  116. Relative address rather than absolute address in VBA code (macro)
  117. [SOLVED] Sum the column
  118. VBA concenate problem
  119. enable and disable cells based on other cell value
  120. Cut and Paste Rows from multiple Worksheets on to one summary sheet based on 1 condit
  121. Macro to repeat merge, Filter, copy & paste to other sheet.
  122. [SOLVED] Identify value and automatically puts in another spreadsheet
  123. vba script to convert worksheets to pdf
  124. Logic
  125. Insert blank rows based upon cell value with criteria
  126. Cells Clearcontents
  127. [SOLVED] Pivot "For Each" Filtering Loop Failing
  128. [SOLVED] check if listbox selected
  129. [SOLVED] ComboBox: Possible to change Popout direction?
  130. Tab order with VBA
  131. How to enter data in a specific cell (c8 in all sheets ) when data is on 1st sheet
  132. [SOLVED] Ignoring comma when creating validation lists
  133. Pivot table empty
  134. Passing Variables through VBA Excel - VBA Access
  135. How to make Excel Start itself with a VBA Macro
  136. [SOLVED] Per hour result
  137. Open attached file from email in Lotus Notes in Excel
  138. [SOLVED] Pivot Table Subtotals
  139. VBA Print function - want quotation marks in my text file
  140. Inquiry: VBA Code in Excel
  141. [SOLVED] vba textbox data valdiation
  142. Adapt VBA Code With Adjusment Range
  143. [SOLVED] Export multiple worksheets into one csv file
  144. [SOLVED] Need to copy paste different cells to another file (files are same image)
  145. Comma delimiters - Batch conversion of .csv to .xlsx
  146. Macro not running properly on other systems
  147. typed and moving
  148. Set range and calculate sum problem
  149. whenever auto insert row than auto enter a formula in specific cell
  150. [SOLVED] Formulas to values with offset based on date > today
  151. [SOLVED] Lotus Notes adding signature and attaching saved PDF
  152. Compare two columns to sheet3 based on condition
  153. Add New line above inlineshapes.
  154. MAX MIN AVERAGE for situation
  155. Search column - move/copy entire row into another sheet.
  156. [SOLVED] Set Range as a single cell relative to active cell
  157. [SOLVED] Userform listbox to range
  158. [SOLVED] Multiply cell values using worksheet change event
  159. Copy used cells and paste to master spreadsheet
  160. Macro for adding variably named PDF in email from excel -
  161. Getting "Subscript out of range" error
  162. [SOLVED] How to identify my version of VBA
  163. [SOLVED] Deactivate Event Causing Error
  164. [SOLVED] Dir function not working
  165. Update Pivot Table filter by a value in another cell
  166. Object Variable or With Block variable not set
  167. Can this be done with macro
  168. [SOLVED] Replace formula
  169. [SOLVED] Adding Values in a Userform
  170. Need to link drop down list from range in xlsm (Add-In)
  171. Indexed Database Table in Excel for Lookup
  172. [SOLVED] VBA Format to Sheet Array
  173. [SOLVED] excel 2010 stops working when opening a userform
  174. [SOLVED] VBA Code to parse boolean equations
  175. [SOLVED] Insert blank row based on values in specified column
  176. [SOLVED] SetFocus on TextBoxes
  177. help conditional formula if cell
  178. Deleting repeated cells in two column table (text)
  179. Using inputbox to locate a range, and using 2 different locations to insert amounts
  180. Tips And Tricks
  181. [SOLVED] VBA Generate sheets with unique values
  182. [SOLVED] Loop Only Works on Active Sheet
  183. [SOLVED] Delete Duplicate data on sheet2 and delete the row
  184. [SOLVED] Need help with macro that clears out several different worksheets
  185. Email Automation
  186. Mass Pivot Table Changes
  187. [SOLVED] Find strings and delete
  188. How to paste a range of cells from excel to text field of a web page
  189. Request Help for this Simple Macro
  190. Excel 2010 Protect Existing Row, Allow New Rows
  191. Sorting GPS Marks
  192. [SOLVED] macro to repeat a value times in a column
  193. Calculate multiple sums depending on cells
  194. loop the wookbook with HPageBreaks and VPageBreaks.
  195. [SOLVED] Export embedded Word document and set data
  196. [SOLVED] Close a command button after it has been clicked
  197. [SOLVED] Average times as long as between 2 dates
  198. [SOLVED] Select Case nested in If Else... where's the break?
  199. VBA Index/Multiple Match criteria
  200. [SOLVED] Check & Copy Data
  201. Object variable or With block variable not set error
  202. VBA: extract systematiically 5 rows and save them in a new excell file as .txt
  203. [SOLVED] Calculating Min,Max,Quartile in dynamic ranges
  204. [SOLVED] Worksheet focus change issues with userform(s)
  205. Interpolation and calculation from table
  206. [SOLVED] VBA Coding to Repalce a List of Words with one word.
  207. Fill in InputBox using VBA
  208. Put Data On One Row in Excel With Many Forms
  209. [SOLVED] Sum Based On condition!
  210. [SOLVED] VBA MACRO CODE FOR REMOVING CELLS AND APPEARING IT CONTINOUSLY
  211. [SOLVED] vba function to return random sign
  212. [SOLVED] VBA Code to populate to end of data
  213. Auto paste special on lookup formulas if value is found
  214. [SOLVED] Selecting Multiple Items in a Pivotfield, Hoping to be able to Toggle with a Hotkey
  215. [SOLVED] time utilization
  216. [SOLVED] MACRO CODE FOR MATCHING AND REPLACING THE VALUES
  217. VBA code to merge cells
  218. [SOLVED] InStr reading cells - doing something wrong
  219. Hello my fellow nerds
  220. [SOLVED] Repeat a column Insert in the same position on two other sheets.
  221. [SOLVED] Code Execution Interrupted when Reloading Userform
  222. HELP : Extract value with criteria color
  223. Fastest way to temporarily store results for further analysis
  224. [SOLVED] Paste a columns formats and formulas not its values
  225. Prevent form from closing after programmatically adding code
  226. Help With Counting
  227. Strange delay in execution of MailTo Macro code
  228. INDIRECT() function doesn't work: "Can't Find Object or Library"
  229. Excel 2010 huge file size
  230. Show Zero Value in Cell
  231. [SOLVED] Changing the Row reference of a formula
  232. [SOLVED] How to Make Copy of Word Document
  233. Re-Arrange Data based on FLAG
  234. When choosing an image according to the number in a cell to show marked
  235. Extract portion of web page to excel using VBA
  236. [SOLVED] Bypass Run-time error '13'?
  237. Run Access create table query from Excel with msgbox displaying records created
  238. [SOLVED] Renaming a text file and extension from content
  239. [SOLVED] Need Error Check
  240. [SOLVED] Re-Activating OnSave Macro
  241. Copy Columns With Specific Headers--Paste Into Separate Workbook Based On Header
  242. [SOLVED] Issues in conditional formatting
  243. Macro built on Win64 not running on Win32
  244. [SOLVED] Using multiple if criteria in VBA
  245. Bitten off more than I can chew.
  246. [SOLVED] Please help Chart data
  247. total Fridays in a range
  248. Copy Data From INTERNET EXPLORER into Excel using vba
  249. Shared document/Multiple Users - tops please :)
  250. Require macro for the attached scenario