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:] Check if weekend exist in date range
  2. VBA code for sorting(descending or ascending users preference)
  3. Lock/Unlock cells based on values in parent cell
  4. Copy value to next empty cell in same row and return average.
  5. NEW TO VBA NEED HELP PLEASE!! thank you :)
  6. VBA to Select 2nd Outlook Account and Download attachments
  7. Auto-Expand Table and Add Row Below
  8. Dynamically add column to right of last column
  9. [SOLVED:] Trouble With If/Else using Find and Replace In Specified Range of Cells
  10. Advanced Filter and Multi Graphing
  11. i have a vba for outlook tha must be chanced in lotus
  12. Split row to column with insert
  13. Excel formula to combine
  14. Problem with code to edit existing data on Access database
  15. Excel VBA to copy and paste in vertical
  16. [SOLVED:] Help with COUNTIFS please
  17. VBA on Virtual private server
  18. How to check a HTML Checkbox without ID or name using VBA
  19. Automatically change size of pivot chart based on the number of filtered results
  20. Need Help Expanding Conditional Formatting Code via VBA
  21. VBA to lookup a value, paste different value in appropriate cell
  22. Merge contents of rows if criteria is met
  23. Need Macro to paste to the next free line
  24. [SOLVED:] Finding and highlighting text in a word document
  25. Align Text/Caption to Checkbox
  26. [SOLVED:] Method 'Range' of object '_Worksheet' failed error
  27. Add a Argument to Specific Formulas VBA
  28. [SOLVED:] named range cell counting for calendar miss counting december
  29. Excel 2013 Too Bright
  30. [SOLVED:] Filtered Range only copy and pasting once and not offsetting.
  31. Highlighting(Colour) cells problem in VBA excel
  32. Create Pivot table using VBA
  33. [SOLVED:] Using VBA to format multiple cells of a sheet based on the cells value of another she
  34. Possible to Disable/Enable Plugins Quickly in VBA?
  35. Object Required - range
  36. excel vba needed
  37. Get Administrator Rights excel 2013
  38. [SOLVED:] compare between worksheets and write into cell
  39. [SOLVED:] Rounding to a Fraction
  40. [SOLVED:] Formatting Cell Borders if Not Blank
  41. Hide workbook
  42. [SOLVED:] Excel Macro to save with Current Date?
  43. [SOLVED:] Search Cell values after change in second Sheet
  44. if column D on sheet1 has data copy to sheet2 on columns A-B-C
  45. [SOLVED:] Stop macro if cell is blank
  46. [SOLVED:] Outlook Email code only sends one email
  47. How to forward or reply email from lotus notes using VBA/ VB script
  48. VBA macro need for linear Interpolation
  49. Count Unique
  50. Macro to create new sheets based on values available in a particular column
  51. Wrong Msgbox displaying
  52. Using VBA/VB.net to access an open instance of Excel
  53. Excel 2013: handle Excel warning @ workbook opening: circular references
  54. Conditional Formatting
  55. Help with Arrays
  56. [SOLVED:] VBA to paste to new sheets if column is blank
  57. VBA to format selected range
  58. If %tage are same club the data
  59. [SOLVED:] Macro to paste data in next blank cell?
  60. Short cuts to files
  61. Sleeper: Formula Help
  62. append csv file with multiple csv files
  63. [SLEEPER:] Pull Data From Microsoft Word Form to Microsoft Excel
  64. Delete Row A if Row B Contains
  65. [SOLVED:] Stopping a macro that uses a list
  66. VBA to test if particular measure exists in pivot table (PowerPivot Pivot Table)
  67. Populate Word bookmark into excel
  68. Consolidating Workbooks Using List
  69. [SOLVED:] VBA to delete rows if font colour is Red?
  70. I need help with multiple combo boxes in the same sheet
  71. [SOLVED:] Paste to row problem
  72. Move data without deleting rows
  73. Organize all Pivot table in all sheet in a workbook
  74. Sum ranges from multiple workbooks VBA
  75. [SOLVED:] filtering data based on one column through macro buttons
  76. vba copying and paste pivot tables fields
  77. Ghost button until valid entry
  78. Get Range from Listbox selected items
  79. Copy selected items from Listbox to multiple ranges
  80. Automating Userform
  81. Date Picker Problem
  82. VLOOKUP or INDEX NATCH
  83. "uncontrollable columns
  84. Spreading (Distribution) numbers randomly problem with VBA excel
  85. Worksheet, Warehouse work attendance with barcode scanning
  86. Cant send to multiple recipient using Lotus Notes VBA. Please help
  87. [SLEEPER:] Randomly distribution a number into a range of cells in VBA
  88. [SOLVED:] Recreate code
  89. How to filter multiple values
  90. Help needed Adding, Updating Records on Database through Network.
  91. Find and replace lines in csv files with a excel sheet
  92. Excel Heat Map with VBA
  93. [SOLVED:] Find and show another sheet (adaptation)
  94. [SOLVED:] find occurences
  95. Populate combobox only with values that column cell is empty
  96. Error trap
  97. [SOLVED:] make another loop outside
  98. [SLEEPER:] Randomly distribution a number into a range of cells in VBA
  99. [SOLVED:] Login to Website and Click Link
  100. Selenium Wrapper VBA Help
  101. Calculate difference between working hours and sometimes dates - Formula Please
  102. Copy Particular data and display from other XL file without opening
  103. [SLEEPER:] Selenium Wrapper VBA Help
  104. Help on updating info based on date
  105. [SOLVED:] SUMIFS Formula to pull data from next tab
  106. Macro for Descriptive Statistics fun! (calling ATPVBAEN.XLAM)
  107. Fill values in another sheet based on the for the cells coloured in one color
  108. [SOLVED:] build userform calendar using "cell counting" method looping named labels (SamT)
  109. [SOLVED:] offset in for each loop
  110. How to use MS Word Spell checker to spellcheck Excel Textbox
  111. Modify cells using userform
  112. [SOLVED:] Combining Counts and Sum from two columns
  113. [SOLVED:] copy listbox value(2 of 3 columns) to a listbox that name matches day value (3rd col)
  114. [SOLVED:] #VALUE error
  115. XML data with variable filenames
  116. [SOLVED:] copy paste after the lastused row of another sheet excluding the headers
  117. autofilter each value in a column and campare with another column
  118. copy data from sheet 1 to sheet 2 when data entered in sheet 1
  119. keyword search
  120. Pivot Refresh
  121. [SOLVED:] static today date function based on 2 criteria
  122. [SOLVED:] Enter Date After copy filtered data
  123. Macro Help
  124. How to save as CSV file with the filename being dynamic and worksheet name static?
  125. [SOLVED:] Trouble with Comboboxes
  126. [SLEEPER:] Calculate hours between two times
  127. Looking for a old members post
  128. Finding and renaming files from spreadsheet list
  129. result of filter
  130. Using Cell Value in VBA
  131. [SOLVED:] VBA formula help
  132. VBA Coding help to cut rows & paste to "archive" tab
  133. Help with calling Access Database for data?
  134. Excel Name Ranges
  135. VBA - Delete Entire Row if Cell contains Text variable
  136. [SOLVED:] Deleting rows based on 2 column citeria
  137. Multiple Controls on a Form
  138. [SOLVED:] VBA to insert PART of a recset into a named range?
  139. [SOLVED:] Index Match a col of long text stings to find short text strings and return adjacent
  140. textbox with date variable?
  141. Making an array that selects an increasing number of objects
  142. input text in to htm page using vba from excel
  143. Simple if statement
  144. Saving a copy with date problem
  145. Help with looping/dumping recordset
  146. Offset one column
  147. Copy Template and Move Data
  148. Code to extract Html from deeper than I am able to
  149. Inserting Column Based On Text
  150. Function "&" with 2 columns
  151. [SOLVED:] Show value of cell above
  152. Subscript Out of Range
  153. Setting text format for a textbook on a form
  154. [SOLVED:] Expected end of statement error
  155. Operator <= doesn't seem to work!
  156. HELP: input text into htm page textbox using vba from excel
  157. VBA Excel help
  158. Exam setting plan got :confused: need improvement
  159. [SOLVED:] Runtime Error 91: Object Variable or With Block Variable not Set
  160. [SOLVED:] How do I get the total from all array elements
  161. [SLEEPER:] Excel Vba textbox userform Vlookup give missmatch error
  162. Cut copy and Paste permanently disabled in all workbooks help
  163. vba code to calculate time difference
  164. Need to specify columns to be copied in this VBA code
  165. [SOLVED:] simple MATCH function - need help
  166. Sleeper: Help with VBA Excel tool to create MS Project Plan
  167. [SOLVED:] Create multiple workbooks from a filtered list
  168. vbYesNoCancel
  169. Couple of Simple VBA Questions
  170. Am I duplicating my rules
  171. MACRO modification
  172. Match/Index VBA for UserForm with multiple criteria
  173. run time error 1004 in pivot table wizard
  174. Copy Excel Tables To Word
  175. Add an appointment to a collegues calender
  176. [SOLVED:] Run-time error '13': Type Mismatch -- HELP
  177. [SOLVED:] 2 D array assignment
  178. copy column to row on new worksheet based on cell values in column A
  179. Macro code for copying Data to next row after a certain period
  180. Counting Unique Value Pairs in 2 Columns
  181. Can I use VBA with this problem?
  182. [SOLVED:] From Excel create a footer in Word
  183. Removing duplicates if certain conditions match
  184. [SOLVED:] Nested Statement Help for Time Calculation.
  185. Someone help me for this encode or decode in excel
  186. Delete Rows And Rename Headers
  187. Delete Columns Based On Text
  188. Email VBA code that CC's sender?
  189. [SOLVED:] Can someone explain these CF formulas to me
  190. Copy specific values
  191. Create Sub Sheets From Master
  192. Looping through rows and copy cell values to another worksheet
  193. Inser a row based on the cell value in a column
  194. Problem with VLookup code - Need assistance Please!!
  195. No of records for each person 90 days old
  196. [SOLVED:] HOW TO STRIP OUT ONLY RELEVANT DATA FROM A STRING BY USING FORMULA OR VBA
  197. Put extracted news into a scrolling box in Excel Sheet.
  198. Modify macro so it searches files in subfolders
  199. Excel not responding while running VBA
  200. [SOLVED:] VBA- Inex Matchdex Match?
  201. Sleeper: Extract cell info from specific column selected out of Named Range
  202. Find/Replace in Specific Workcheet
  203. Looping through rows and copy cell values to another worksheet
  204. Rearranging data based on counter using VBA code
  205. Problem with code
  206. Copy data to cells not working
  207. [SOLVED:] Trying to drag cells down and $ keeps reapplying even after deleted
  208. Problem with Printout Code
  209. Print title + Dynamic range until empty row
  210. Can I keep an API from updating?
  211. [SOLVED:] change function add and remove rows
  212. Add a worksheet based on cell content
  213. sendkeys works once only despite time frame
  214. [SOLVED:] Match NOW() with cell formatted as date
  215. [SOLVED:] amend excel VBA for powerpoint
  216. Items frequently bought together
  217. copy Formulas instead of Text values
  218. [SLEEPER:] Column to be cut and pasted with values in different column
  219. Looping thru rows and copy cell values from "Inputs" sheet to "Output" sheet
  220. Excel Export Cells to PDF Forms (fillable)
  221. [SOLVED:] Looping Through Checkboxes?
  222. Q: Create Macro to Archive and then Clear Specific cell. Clearing Issue.
  223. [SOLVED:] Populating ActiveX Drop List from Cell Values
  224. [SOLVED:] Make my Code work faster
  225. VBA Table
  226. Macro to insert row and text above cell
  227. [SOLVED:] Sorting all worksheets but exclude 3 worksheets
  228. [SOLVED:] Importing data from one Workbook to another
  229. Copy data from a range of cells and sheets in a closed workbook
  230. VBA: Macro for multiple charts creation with predefined settings
  231. Using a variable value to select a range when creating a chart
  232. Need to copy address to next sheet in a database manner
  233. [SOLVED:] VBA to keep format when concatenating
  234. [SOLVED:] Loop through Columns - Copy & Paste
  235. Plot area resize to fit the entire chart area
  236. Create a Code to update Date
  237. Calculate the product of two matrices
  238. create path to .pdf and extract sheet size
  239. lock workbook
  240. [SOLVED:] Loop down vba Help
  241. [SOLVED:] Formula/Macro to only display figures in a cell if a certain condition is met.
  242. Wildcard issues
  243. [SOLVED:] Delete row with condition
  244. Spreading numbers problems in VBA code
  245. [SOLVED:] Long length value convert to determine set length
  246. [SOLVED:] Pivot in single sheet one below the other
  247. Help in Userform and data
  248. [SOLVED:] Deleting rows older than 3 months
  249. Adding and Deleting a Sheet Dependent on Cell Content
  250. Listbox Not Populating - Source is dynamic named range