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