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. Merging different workbook into one workbook in different tabs.
  2. Getting error 32809 - when ever we open our excel application
  3. Conditional Format with Date Stamp based on user input
  4. Separate data from Sheet1 to other Sheets based on filtering & conditional formating
  5. Split Excel worksheet into multiple workbooks
  6. New error in previously working VB code
  7. Fill the missing cells with date
  8. is there a way to combine these 3 macros into 1 macro ?
  9. Is there a Limit to where you can place a table to query it from ADODB?
  10. [SOLVED:] VBA - Run time error 1004: Application defined or Object-Defined Error
  11. The Userform getdata and edit/add macros for both Text and Comboboxes
  12. Data Merge
  13. Copy charts from Excel to Word using Late Binding
  14. object or with block variable not set??
  15. [SOLVED:] VBA to Highlight Rows based upon a Populated Cell
  16. My subtotal and sum
  17. [SOLVED:] Selected listbox items to worksheet not working
  18. Help with "OR" in VBA
  19. Copy data from sheet 2 variable range to sheet 3 fixed range and send it by email
  20. Subtract textbox value from cell value
  21. Using Loops do create emails from Excel
  22. MSComm RTU serial communication
  23. Excel Opening The Wrong File
  24. Hyperlink from cell to sheet
  25. VBA formula to populate from PDF?
  26. [SOLVED:] Help with Salesforce Login from Excel
  27. [SOLVED:] variable not defined compile error
  28. [SOLVED:] Rename Sheet Name on cell value condition
  29. How to get control of range input type from a webpage using VBA
  30. Importing multiple text files to Excel sheet and making on Excel sheet
  31. [SOLVED:] Excel Naming comvention.
  32. How export specific range to txt file
  33. Running Macro when a Dropdown Box Changes
  34. Run time error 438 - Hide Columns Macro
  35. AutoFill to dynamic Column range?
  36. Get data in listbox
  37. [SOLVED:] VBA to populate with cells from another sheet?
  38. [SOLVED:] VBA Linking cells within different sheets
  39. [SOLVED:] How to get relevant data
  40. Excel GIF storage - no external files
  41. New to VBA, struggling to write some simple codes
  42. Excel Data Fill on Folder Files availablity
  43. [SOLVED:] Function to return Boolean
  44. [SOLVED:] slight change to an existing routine has created problems
  45. [SOLVED:] VBA to Insert Blank Row Based on Two Conditions
  46. Want help on Select statement
  47. How to create a dynamic pivot table using macro in excel
  48. [SOLVED:] Runtime error opening workbooks
  49. Make changes to another workbook - Runtime error 9
  50. [SOLVED:] SUMIFS fomula
  51. Problem with display textbox when filter the data in listbox
  52. Generating a new Batch No as per the Creteria
  53. [SOLVED:] copy from excel 2010 to word 2010
  54. VBA Problem
  55. Possible Duplicate Warning issue
  56. Sleeper: Conditional formatting
  57. [SOLVED:] Array question
  58. Automate Saving and Closing Excel Workbook after 2 minsutes
  59. 1004 error while running the macro in VBA
  60. VBA on an old machine
  61. [SOLVED:] Ranking system depending on 2 variables
  62. Alert by cell color change
  63. Excel Macro to Add Footer Text and Page Numbers to Word
  64. Formula to put row number based on a date
  65. [SOLVED:] Need help with getting list of data from unique row
  66. sum of value from Center" Word
  67. [SOLVED:] SQL in excel VBA
  68. is there a limit to how many WHERE clauses you can have in an SQL statement?
  69. [SOLVED:] Help needed with some excel formula - hopefully someone can assist.
  70. [SOLVED:] Passing variables to run a macro on multiple tabs
  71. if there is text add conditional format and edges
  72. inkingstart macro
  73. Append to Access Table VBA
  74. Transpose the data from X Range.
  75. Display a list of the folders and subfolders in VBA
  76. getting data from Excel into SQL
  77. [SLEEPER:] compare names, substract values from one workbook to another
  78. [SOLVED:] Dates Used as Sheet Names
  79. [SOLVED:] Problems with dashboard VB code not working
  80. SelectionChange fail to work sometimes
  81. VBA code help [small code]
  82. [SOLVED:] VBA to move pivot table field name to rows
  83. [SOLVED:] help needed to write a vlookup or match formula
  84. Object variable or with block variable set
  85. Creating function with Ifs
  86. [SLEEPER:] Help needed for making a GUI form in Excel.
  87. VBA Event Change Using Dependents
  88. [SOLVED:] Run-time error '52'- Bad file name or number
  89. [SOLVED:] Run macro when selecting specific worksheet
  90. Macro to Send Multiple Emails with Attachment through Lotus Notes
  91. MAcro - Range Selection - Help
  92. Dynamic Lookup Function to match the data in two sheet and copy in one sheet
  93. [SOLVED:] Team ranking not working
  94. [SOLVED:] Modifying an existing time formula
  95. [SOLVED:] VBA to copy specific cells to specific columns in different workbook
  96. [SOLVED:] Simple VBA calculation
  97. [SOLVED:] Can't Get Find Method to Work
  98. Add multiple filtered row data to ListBox
  99. Active X controls
  100. Run-time error '9' Subscript out of range.
  101. Advanced Filtering of Large Spreadsheets
  102. VB calculations not working
  103. [SOLVED:] Copy data from one workbook into another with named rangs
  104. [SOLVED:] problem with closing WB when copying data from on WB to another
  105. how to make a range of names into a variable
  106. Help with Datepicker in Excel Form
  107. [SOLVED:] Concatenate a formatted number
  108. Sharing a Workbook with VBA
  109. [SOLVED:] How can I auto filter out "0:00" in excel 2010?
  110. VBA PivotTables "Unable to get the PivotItems of the PivotField Class"
  111. [SOLVED:] Is there a way to autofill macros?
  112. VBA - Extract 3rd Column value from Listbox
  113. [SOLVED:] How to paste a cell as special values from another sheet?
  114. VBA to obtain another workbook's worksheets into a drop down list
  115. Looping IF
  116. SPLITING A COLUMN OF DATA CLASSIFIED BY 2 VARIABLES INTO A 2 VARIABLE MATRIX
  117. [SOLVED:] Sending automatic emails
  118. Comparing 2 Lists and displaying all in New, Removed, Same
  119. How to display the output in a same worksheet?
  120. Inserting a new row and copy the data.
  121. [SOLVED:] Complicated Reverse-order lookups
  122. Filter 2 columns between 2 dates
  123. Help creating a macro for color blind user?
  124. Display values in User Form
  125. [SOLVED:] Run-time error 424: Object required
  126. Time exceptions within excel
  127. Help with date format
  128. is there a way to add to a list object?
  129. [SOLVED:] Using Hyperlink from Excel cell in an Email
  130. [SOLVED:] How do I add axis labels to bar chart bars?
  131. [SOLVED:] Automatic Friday Week Ending Dates
  132. VBA: Delete dublicate rows based on 3 different columns
  133. newly created sheet - assign module
  134. VBA For Each Loop just prompting one input
  135. Listing the files from a compressed zipped folders
  136. Need help on how to get previous matching row data!!
  137. [SOLVED:] VBA - automation error the object invoked has disconnected
  138. [SOLVED:] Copy data from a file based on comparison between two different workbooks
  139. [SOLVED:] Save E-mail Attachments
  140. [SOLVED:] How capture City and State values from one cell (with a delimeter character)
  141. Launching Excel from MS-Access / Detecting Excel to prevent multiple instances
  142. Need help to write a code
  143. SEARCH FOR DUPLICATE VALUES ACROSS NUMEROUS WORKSHEETS
  144. Copy Matching Data to Email
  145. [SOLVED:] Change value of a MS Word ActiveX Checkbox
  146. VBA Code - Set up Button (Form Control)
  147. olObject
  148. [SOLVED:] Print to last row, multipule columns.
  149. [SOLVED:] VBA to Insert Blank Row
  150. [SOLVED:] VBA Macro
  151. Excel2013 Macro- Run-time error '438': Object doesn't support this property or method
  152. [SOLVED:] Help
  153. Need a little help with my (working) code regarding putting headers into comments
  154. [SOLVED:] Want to use a different icon for an excel file
  155. Project VBA diplay Error94
  156. few datavalidated cells not working after after adding combobox. for INDIRECT formula
  157. [SOLVED:] Add items from column range A1:-> into a Combobox
  158. Sort from A4 to lastrow
  159. VBA: Delete duplicate productid when it finds 3 different criterias
  160. [SOLVED:] need help in code enhancement
  161. VBA DATE STAMP MODIFY
  162. [SOLVED:] Parent vs Worksheet
  163. Copying a cell, from one workbook and pasting in a another workbook...
  164. [SOLVED:] Selecting and sorting variable range
  165. [SOLVED:] Help to modify VBA Code
  166. [SOLVED:] Have a Label/Command Button Run a Spin Button (cross posted)
  167. [SOLVED:] Import from Access to Excel, auto select .mdb file from same folder path as Excel
  168. [SOLVED:] Conditional formating if the cell is empty.
  169. Help to create repeat macro until blank cell found
  170. [SOLVED:] Linear interpolation using VBA for empty cells in a row
  171. ADODB & Jet Engine VS Pure VBA - Performance
  172. Saving a file with previous day date in specific location
  173. Copy Multiple TextBoxes to Clipboard
  174. how to use conditional formatting in gantt chart
  175. [SOLVED:] Normal Distribution - how to calculate E(X|X>Y)
  176. [SOLVED:] Options List for Inputbox
  177. How to populate the other cells, as soon as values are selected from combobox?
  178. Running a .bat file from VBA
  179. [SOLVED:] Open a folder in Windows Explorer
  180. Vba open workbook and paste from another workbook
  181. Copy text in a column till last row based on adjacent column
  182. Vba open workbook and paste from another workbook
  183. Assistance With Simplifying getElementsByName Coding
  184. [SOLVED:] Modify code to search multi columns and return data
  185. [SOLVED:] VBA code chages - pick two cell instead of 1
  186. Textbox and the standard module
  187. Ranking using data from 2 colums
  188. [SOLVED:] VBA Cell Formatting Copy
  189. Date Prior to Actual Date
  190. [SOLVED:] Export column script
  191. Find a word in a cell and delete the rows which doesn't have the word
  192. [SOLVED:] Missing apostrophe
  193. Code Efficiency
  194. Drawing sample in Excel
  195. [SOLVED:] Copying specific cells to a new sheets also give sheetname
  196. Help with Userform
  197. [SOLVED:] Excel cells into publisher help
  198. Autosort vba problem
  199. Newbie Help with VBA I think
  200. [SOLVED:] how to see the first cell in a row also copy to a new sheet
  201. [SOLVED:] Vba code in excel to move doc files from one folder to another.
  202. ADDIN doesn't show when opening existing spreadsheet
  203. [SOLVED:] Selecting the next sheet and copying the previous
  204. Copying value from multiple workbook to one after every 60 mins
  205. Automate Vlookup in Excel spreadsheet
  206. Glossary of terms using excel vba
  207. [SOLVED:] COUNTIF(AND... Mulitple criteria
  208. [SOLVED:] Deleting rows where value in column B starts with specific letter
  209. [SOLVED:] VB Code for EXCEL 2010 - PLEASE HELP!!
  210. Highlighting a specific marker in a line chart
  211. [SOLVED:] Column "A", where the zero value where the column "B" must be delete in the Value
  212. [SOLVED:] I need help for Conditional Formatting.
  213. VBA - Combine two column value using Distance
  214. [SOLVED:] Remove the Index References table and continue to show the CF
  215. I need a formula..
  216. [SOLVED:] VBA - Find Specific words from Column "A" and paste to column "H"
  217. [SOLVED:] VBA Function - Search Min Value by length
  218. VBA to Restrict certain usernames.
  219. Small Help in this Code
  220. [SOLVED:] How to rename active workbook?
  221. Problems with nslookup function
  222. Beginner question
  223. [SOLVED:] Can you sort SpecialCells or other noncontiguous cells
  224. [SOLVED:] VlookUp not Working?
  225. [SOLVED:] Count formla for three criteria
  226. doubleclick doesn't work
  227. NEED VBA Macro
  228. [SOLVED:] Transpose 3 Columns (variable rows numbers) to 3 Rows
  229. Help with my code - I want to clear any formulas when pasting
  230. [SOLVED:] How to select just letters in the alert and also make a string
  231. [SOLVED:] Can't use Split correctly
  232. [SOLVED:] vba Linear Sort help
  233. Listbox using List of Hyperlinks to other sheets
  234. How to update an excel cell/column date everytime a change is made to its row?
  235. Excel table if update the row end of cell date cell should update accordingly
  236. Reg; Excell cell count according to the cell values
  237. Hyperlinks for Combo from Sheet Tabs
  238. [SOLVED:] Linking several workbooks to a master workbook
  239. Saving a value from a variable -- I'm missing something obvious!
  240. [SOLVED:] VBA help! copy and paste to database sheet
  241. change the date column
  242. [SLEEPER:] Formula - show unique value based on two condition
  243. CategoryNames or SetSourceData on Excel VBA 2013
  244. Function help
  245. values going below the ribbon
  246. Data Scrape from IE
  247. [SOLVED:] how to loop through all used cells in just row 1 and alert?
  248. Excel VBA Code HELP - email active sheet plus 1 other
  249. Sleeper: Storing and retreiving text from a separate workbook
  250. [SOLVED:] Delete Blank Columns and Delete Blank Columns