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

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