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