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 174

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