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

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