Log in

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 open workbook and paste from another workbook (1 replies)
  2. Copy text in a column till last row based on adjacent column (1 replies)
  3. Vba open workbook and paste from another workbook (23 replies)
  4. [SOLVED:] Open a folder in Windows Explorer (2 replies)
  5. Running a .bat file from VBA (4 replies)
  6. How to populate the other cells, as soon as values are selected from combobox? (0 replies)
  7. [SOLVED:] Options List for Inputbox (4 replies)
  8. [SOLVED:] Normal Distribution - how to calculate E(X|X>Y) (1 replies)
  9. how to use conditional formatting in gantt chart (0 replies)
  10. Copy Multiple TextBoxes to Clipboard (14 replies)
  11. Saving a file with previous day date in specific location (4 replies)
  12. ADODB & Jet Engine VS Pure VBA - Performance (3 replies)
  13. [SOLVED:] Linear interpolation using VBA for empty cells in a row (9 replies)
  14. Help to create repeat macro until blank cell found (8 replies)
  15. [SOLVED:] Conditional formating if the cell is empty. (2 replies)
  16. [SOLVED:] Import from Access to Excel, auto select .mdb file from same folder path as Excel (6 replies)
  17. [SOLVED:] Have a Label/Command Button Run a Spin Button (cross posted) (6 replies)
  18. [SOLVED:] Help to modify VBA Code (8 replies)
  19. [SOLVED:] Selecting and sorting variable range (4 replies)
  20. Copying a cell, from one workbook and pasting in a another workbook... (5 replies)
  21. [SOLVED:] Parent vs Worksheet (3 replies)
  22. VBA DATE STAMP MODIFY (2 replies)
  23. [SOLVED:] need help in code enhancement (4 replies)
  24. VBA: Delete duplicate productid when it finds 3 different criterias (5 replies)
  25. Sort from A4 to lastrow (3 replies)
  26. [SOLVED:] Add items from column range A1:-> into a Combobox (2 replies)
  27. few datavalidated cells not working after after adding combobox. for INDIRECT formula (20 replies)
  28. Project VBA diplay Error94 (3 replies)
  29. [SOLVED:] Want to use a different icon for an excel file (2 replies)
  30. Need a little help with my (working) code regarding putting headers into comments (5 replies)
  31. [SOLVED:] Help (11 replies)
  32. Excel2013 Macro- Run-time error '438': Object doesn't support this property or method (2 replies)
  33. [SOLVED:] VBA Macro (16 replies)
  34. [SOLVED:] VBA to Insert Blank Row (4 replies)
  35. [SOLVED:] Print to last row, multipule columns. (3 replies)
  36. olObject (1 replies)
  37. VBA Code - Set up Button (Form Control) (3 replies)
  38. [SOLVED:] Change value of a MS Word ActiveX Checkbox (13 replies)
  39. Copy Matching Data to Email (0 replies)
  40. SEARCH FOR DUPLICATE VALUES ACROSS NUMEROUS WORKSHEETS (2 replies)
  41. Need help to write a code (3 replies)
  42. Launching Excel from MS-Access / Detecting Excel to prevent multiple instances (4 replies)
  43. [SOLVED:] How capture City and State values from one cell (with a delimeter character) (2 replies)
  44. [SOLVED:] Save E-mail Attachments (2 replies)
  45. [SOLVED:] Copy data from a file based on comparison between two different workbooks (33 replies)
  46. [SOLVED:] VBA - automation error the object invoked has disconnected (5 replies)
  47. Need help on how to get previous matching row data!! (0 replies)
  48. Listing the files from a compressed zipped folders (1 replies)
  49. VBA For Each Loop just prompting one input (6 replies)
  50. newly created sheet - assign module (2 replies)
  51. VBA: Delete dublicate rows based on 3 different columns (0 replies)
  52. [SOLVED:] Automatic Friday Week Ending Dates (2 replies)
  53. [SOLVED:] How do I add axis labels to bar chart bars? (1 replies)
  54. [SOLVED:] Using Hyperlink from Excel cell in an Email (6 replies)
  55. is there a way to add to a list object? (2 replies)
  56. Help with date format (3 replies)
  57. Time exceptions within excel (1 replies)
  58. [SOLVED:] Run-time error 424: Object required (10 replies)
  59. Display values in User Form (0 replies)
  60. Help creating a macro for color blind user? (4 replies)
  61. Filter 2 columns between 2 dates (0 replies)
  62. [SOLVED:] Complicated Reverse-order lookups (7 replies)
  63. Inserting a new row and copy the data. (1 replies)
  64. How to display the output in a same worksheet? (3 replies)
  65. Comparing 2 Lists and displaying all in New, Removed, Same (0 replies)
  66. [SOLVED:] Sending automatic emails (1 replies)
  67. SPLITING A COLUMN OF DATA CLASSIFIED BY 2 VARIABLES INTO A 2 VARIABLE MATRIX (4 replies)
  68. Looping IF (2 replies)
  69. VBA to obtain another workbook's worksheets into a drop down list (0 replies)
  70. [SOLVED:] How to paste a cell as special values from another sheet? (2 replies)
  71. VBA - Extract 3rd Column value from Listbox (4 replies)
  72. [SOLVED:] Is there a way to autofill macros? (3 replies)
  73. VBA PivotTables "Unable to get the PivotItems of the PivotField Class" (2 replies)
  74. [SOLVED:] How can I auto filter out "0:00" in excel 2010? (8 replies)
  75. Sharing a Workbook with VBA (1 replies)
  76. [SOLVED:] Concatenate a formatted number (2 replies)
  77. Help with Datepicker in Excel Form (1 replies)
  78. how to make a range of names into a variable (3 replies)
  79. [SOLVED:] problem with closing WB when copying data from on WB to another (1 replies)
  80. [SOLVED:] Copy data from one workbook into another with named rangs (1 replies)
  81. VB calculations not working (0 replies)
  82. Advanced Filtering of Large Spreadsheets (1 replies)
  83. Run-time error '9' Subscript out of range. (4 replies)
  84. Active X controls (2 replies)
  85. Add multiple filtered row data to ListBox (3 replies)
  86. [SOLVED:] Can't Get Find Method to Work (1 replies)
  87. [SOLVED:] Simple VBA calculation (15 replies)
  88. [SOLVED:] VBA to copy specific cells to specific columns in different workbook (5 replies)
  89. [SOLVED:] Modifying an existing time formula (10 replies)
  90. [SOLVED:] Team ranking not working (4 replies)
  91. Dynamic Lookup Function to match the data in two sheet and copy in one sheet (1 replies)
  92. MAcro - Range Selection - Help (1 replies)
  93. Macro to Send Multiple Emails with Attachment through Lotus Notes (0 replies)
  94. [SOLVED:] Run macro when selecting specific worksheet (7 replies)
  95. [SOLVED:] Run-time error '52'- Bad file name or number (2 replies)
  96. VBA Event Change Using Dependents (1 replies)
  97. Help needed for making a GUI form in Excel. (2 replies)
  98. Creating function with Ifs (3 replies)
  99. Object variable or with block variable set (3 replies)
  100. [SOLVED:] help needed to write a vlookup or match formula (0 replies)
  101. [SOLVED:] VBA to move pivot table field name to rows (3 replies)
  102. VBA code help [small code] (5 replies)
  103. SelectionChange fail to work sometimes (6 replies)
  104. [SOLVED:] Problems with dashboard VB code not working (9 replies)
  105. [SOLVED:] Dates Used as Sheet Names (2 replies)
  106. [SLEEPER:] compare names, substract values from one workbook to another (0 replies)
  107. getting data from Excel into SQL (0 replies)
  108. Display a list of the folders and subfolders in VBA (6 replies)
  109. Transpose the data from X Range. (11 replies)
  110. Append to Access Table VBA (0 replies)
  111. inkingstart macro (2 replies)
  112. if there is text add conditional format and edges (1 replies)
  113. [SOLVED:] Passing variables to run a macro on multiple tabs (11 replies)
  114. [SOLVED:] Help needed with some excel formula - hopefully someone can assist. (0 replies)
  115. is there a limit to how many WHERE clauses you can have in an SQL statement? (0 replies)
  116. [SOLVED:] SQL in excel VBA (0 replies)
  117. sum of value from Center" Word (0 replies)
  118. [SOLVED:] Need help with getting list of data from unique row (6 replies)
  119. Formula to put row number based on a date (2 replies)
  120. Excel Macro to Add Footer Text and Page Numbers to Word (0 replies)
  121. Alert by cell color change (0 replies)
  122. [SOLVED:] Ranking system depending on 2 variables (6 replies)
  123. VBA on an old machine (5 replies)
  124. 1004 error while running the macro in VBA (5 replies)
  125. Automate Saving and Closing Excel Workbook after 2 minsutes (1 replies)
  126. [SOLVED:] Array question (8 replies)
  127. Sleeper: Conditional formatting (1 replies)
  128. Possible Duplicate Warning issue (6 replies)
  129. VBA Problem (1 replies)
  130. [SOLVED:] copy from excel 2010 to word 2010 (3 replies)
  131. Generating a new Batch No as per the Creteria (2 replies)
  132. Problem with display textbox when filter the data in listbox (0 replies)
  133. [SOLVED:] SUMIFS fomula (8 replies)
  134. Make changes to another workbook - Runtime error 9 (7 replies)
  135. [SOLVED:] Runtime error opening workbooks (13 replies)
  136. How to create a dynamic pivot table using macro in excel (6 replies)
  137. Want help on Select statement (5 replies)
  138. [SOLVED:] VBA to Insert Blank Row Based on Two Conditions (2 replies)
  139. [SOLVED:] slight change to an existing routine has created problems (2 replies)
  140. [SOLVED:] Function to return Boolean (3 replies)
  141. Excel Data Fill on Folder Files availablity (0 replies)
  142. New to VBA, struggling to write some simple codes (8 replies)
  143. Excel GIF storage - no external files (2 replies)
  144. [SOLVED:] How to get relevant data (20 replies)
  145. [SOLVED:] VBA Linking cells within different sheets (2 replies)
  146. [SOLVED:] VBA to populate with cells from another sheet? (2 replies)
  147. Get data in listbox (0 replies)
  148. AutoFill to dynamic Column range? (5 replies)
  149. Run time error 438 - Hide Columns Macro (2 replies)
  150. Running Macro when a Dropdown Box Changes (4 replies)
  151. How export specific range to txt file (3 replies)
  152. [SOLVED:] Excel Naming comvention. (8 replies)
  153. Importing multiple text files to Excel sheet and making on Excel sheet (0 replies)
  154. How to get control of range input type from a webpage using VBA (3 replies)
  155. [SOLVED:] Rename Sheet Name on cell value condition (6 replies)
  156. [SOLVED:] variable not defined compile error (3 replies)
  157. [SOLVED:] Help with Salesforce Login from Excel (8 replies)
  158. VBA formula to populate from PDF? (1 replies)
  159. Hyperlink from cell to sheet (2 replies)
  160. Excel Opening The Wrong File (10 replies)
  161. MSComm RTU serial communication (2 replies)
  162. Using Loops do create emails from Excel (11 replies)
  163. Subtract textbox value from cell value (1 replies)
  164. Copy data from sheet 2 variable range to sheet 3 fixed range and send it by email (5 replies)
  165. Help with "OR" in VBA (6 replies)
  166. [SOLVED:] Selected listbox items to worksheet not working (5 replies)
  167. My subtotal and sum (1 replies)
  168. [SOLVED:] VBA to Highlight Rows based upon a Populated Cell (6 replies)
  169. object or with block variable not set?? (7 replies)
  170. Copy charts from Excel to Word using Late Binding (1 replies)
  171. Data Merge (8 replies)
  172. The Userform getdata and edit/add macros for both Text and Comboboxes (0 replies)
  173. [SOLVED:] VBA - Run time error 1004: Application defined or Object-Defined Error (3 replies)
  174. Is there a Limit to where you can place a table to query it from ADODB? (3 replies)
  175. is there a way to combine these 3 macros into 1 macro ? (3 replies)
  176. Fill the missing cells with date (18 replies)
  177. New error in previously working VB code (18 replies)
  178. Split Excel worksheet into multiple workbooks (2 replies)
  179. Separate data from Sheet1 to other Sheets based on filtering & conditional formating (1 replies)
  180. Conditional Format with Date Stamp based on user input (6 replies)
  181. Getting error 32809 - when ever we open our excel application (8 replies)
  182. Merging different workbook into one workbook in different tabs. (2 replies)
  183. [SOLVED:] VBA IF Function for Digital Flip Flop (4 replies)
  184. VBA not on proper ActiveSheet (3 replies)
  185. [SOLVED:] Excel generate Outlook appointments (1 replies)
  186. [SOLVED:] Macro to take data from a file other than the current (7 replies)
  187. Excel IF formula for birth date range (0 replies)
  188. what's wrong with this code? (1 replies)
  189. [SOLVED:] Need Help on ADODB Query, need to convert field to int and order on it (4 replies)
  190. [SOLVED:] Random numbers with specific outcome (3 replies)
  191. Just Hallo (1 replies)
  192. Need to standardize 100s of excel files that have columns in the wrong order (8 replies)
  193. [SOLVED:] Need help removing unwanted commas that sometimes appear in rows in csv files (22 replies)
  194. Unhide and Activate a Worksheet using Radio Button on UserFrom (8 replies)
  195. Copy row to a new sheet if a cell in the row meets criteria (11 replies)
  196. Freeze panes shifting on worksheet (4 replies)
  197. Uploading not working (4 replies)
  198. [SOLVED:] Checking cell format (7 replies)
  199. How to save excel file in CSV with Comma delimited (*.csv) (1 replies)
  200. How to do web scraping from java based website (6 replies)
  201. [SOLVED:] Change Cells color based on cell and other cells value. (2 replies)
  202. [SOLVED:] Improve Performance of Insert (24 replies)
  203. Create sheets using data shown in filter (4 replies)
  204. [SOLVED:] Sort blocks independently (2 replies)
  205. Use check button enable/disable code lines (2 replies)
  206. follow hyperlink to location then delete linked file (2 replies)
  207. Sleeper: Combo boxes stopped working (1 replies)
  208. How to use the path of an excel filevariable in a formula? (1 replies)
  209. VBA for Row Difference (1 replies)
  210. [SOLVED:] Sum if (9 replies)
  211. [SOLVED:] Compile Errror: Can't Find Project or Library (3 replies)
  212. [SOLVED:] Update data fill down dynamically (3 replies)
  213. [SOLVED:] Copying Row Above Results In Zero Instead of Blank (3 replies)
  214. [SOLVED:] Modify Code to Include More Columns (1 replies)
  215. [SOLVED:] Copy & Paste Variable Range By Table Header (8 replies)
  216. Downlaod URL Data on disk based on criteria (0 replies)
  217. VBA script to extract/reduce data to certain parameters(columns) (9 replies)
  218. DAYS360 in VBA (3 replies)
  219. How to add date column in workbook files (5 replies)
  220. [SOLVED:] horizantal total (4 replies)
  221. Line intersection - with a difference (3 replies)
  222. [SOLVED:] Problem with Deleting Select Legend Keys (6 replies)
  223. Customize Error bars individually in a dynamic timeline chart (0 replies)
  224. How to set 2 condition in VBA (7 replies)
  225. [SOLVED:] Change tab color based on cell contents (3 replies)
  226. Runtime Errror 9 Subscript out of range (5 replies)
  227. vba to send appointment from excel to outlook (0 replies)
  228. Excel VBA to select first value in Validation list (2 replies)
  229. [SOLVED:] Function that finds number of Fridays in a particular interval date (13 replies)
  230. [SOLVED:] Copy Table from one Sheet to Another (2 replies)
  231. VBA Date Match Error (1 replies)
  232. [SOLVED:] Run-time error 424 issue (4 replies)
  233. [SOLVED:] Inserting a Row based on two conditions (4 replies)
  234. A few questions about DoEvents (43 replies)
  235. Ifs, ors, and nots (3 replies)
  236. vbCrLf and vbLf (3 replies)
  237. [SOLVED:] Operation must use an updateable query (5 replies)
  238. [SOLVED:] Need Code to copy Data to other sheets on condition (5 replies)
  239. [SOLVED:] Types of Data Distributions (3 replies)
  240. Running a Database Query (2 replies)
  241. [SOLVED:] Sorting by number of character in cell (4 replies)
  242. Run-time error '5' : From Excel Macro to AutoCad (5 replies)
  243. Worksheet Sheet ActiveX Controls Command Buttons Stopped Don't Work Working (1 replies)
  244. [SOLVED:] Object doesn't support this property or method (3 replies)
  245. Subtitle problem in embedded WMP control (3 replies)
  246. Special Characters (3 replies)
  247. Count button clicks and write them to a file or sheet with time and date index (2 replies)
  248. Automatic row addition (3 replies)
  249. VBA to Format Charts (6 replies)
  250. [SOLVED:] Compare comma separated numbers (16 replies)