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