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 174
  1. Dynamic Lookup Function to match the data in two sheet and copy in one sheet (1 replies)
  2. MAcro - Range Selection - Help (1 replies)
  3. Macro to Send Multiple Emails with Attachment through Lotus Notes (0 replies)
  4. [SOLVED:] Run macro when selecting specific worksheet (7 replies)
  5. [SOLVED:] Run-time error '52'- Bad file name or number (2 replies)
  6. VBA Event Change Using Dependents (1 replies)
  7. [SLEEPER:] Help needed for making a GUI form in Excel. (2 replies)
  8. Creating function with Ifs (3 replies)
  9. Object variable or with block variable set (3 replies)
  10. [SOLVED:] help needed to write a vlookup or match formula (0 replies)
  11. [SOLVED:] VBA to move pivot table field name to rows (3 replies)
  12. VBA code help [small code] (5 replies)
  13. SelectionChange fail to work sometimes (6 replies)
  14. [SOLVED:] Problems with dashboard VB code not working (9 replies)
  15. [SOLVED:] Dates Used as Sheet Names (2 replies)
  16. [SLEEPER:] compare names, substract values from one workbook to another (0 replies)
  17. getting data from Excel into SQL (0 replies)
  18. Display a list of the folders and subfolders in VBA (6 replies)
  19. Transpose the data from X Range. (11 replies)
  20. Append to Access Table VBA (0 replies)
  21. inkingstart macro (2 replies)
  22. if there is text add conditional format and edges (1 replies)
  23. [SOLVED:] Passing variables to run a macro on multiple tabs (11 replies)
  24. [SOLVED:] Help needed with some excel formula - hopefully someone can assist. (0 replies)
  25. is there a limit to how many WHERE clauses you can have in an SQL statement? (0 replies)
  26. [SOLVED:] SQL in excel VBA (0 replies)
  27. sum of value from Center" Word (0 replies)
  28. [SOLVED:] Need help with getting list of data from unique row (6 replies)
  29. Formula to put row number based on a date (2 replies)
  30. Excel Macro to Add Footer Text and Page Numbers to Word (0 replies)
  31. Alert by cell color change (0 replies)
  32. [SOLVED:] Ranking system depending on 2 variables (6 replies)
  33. VBA on an old machine (5 replies)
  34. 1004 error while running the macro in VBA (5 replies)
  35. Automate Saving and Closing Excel Workbook after 2 minsutes (1 replies)
  36. [SOLVED:] Array question (8 replies)
  37. Sleeper: Conditional formatting (1 replies)
  38. Possible Duplicate Warning issue (6 replies)
  39. VBA Problem (1 replies)
  40. [SOLVED:] copy from excel 2010 to word 2010 (3 replies)
  41. Generating a new Batch No as per the Creteria (2 replies)
  42. Problem with display textbox when filter the data in listbox (0 replies)
  43. [SOLVED:] SUMIFS fomula (8 replies)
  44. Make changes to another workbook - Runtime error 9 (7 replies)
  45. [SOLVED:] Runtime error opening workbooks (13 replies)
  46. How to create a dynamic pivot table using macro in excel (6 replies)
  47. Want help on Select statement (5 replies)
  48. [SOLVED:] VBA to Insert Blank Row Based on Two Conditions (2 replies)
  49. [SOLVED:] slight change to an existing routine has created problems (2 replies)
  50. [SOLVED:] Function to return Boolean (3 replies)
  51. Excel Data Fill on Folder Files availablity (0 replies)
  52. New to VBA, struggling to write some simple codes (8 replies)
  53. Excel GIF storage - no external files (2 replies)
  54. [SOLVED:] How to get relevant data (20 replies)
  55. [SOLVED:] VBA Linking cells within different sheets (2 replies)
  56. [SOLVED:] VBA to populate with cells from another sheet? (2 replies)
  57. Get data in listbox (0 replies)
  58. AutoFill to dynamic Column range? (5 replies)
  59. Run time error 438 - Hide Columns Macro (2 replies)
  60. Running Macro when a Dropdown Box Changes (4 replies)
  61. How export specific range to txt file (3 replies)
  62. [SOLVED:] Excel Naming comvention. (8 replies)
  63. Importing multiple text files to Excel sheet and making on Excel sheet (0 replies)
  64. How to get control of range input type from a webpage using VBA (3 replies)
  65. [SOLVED:] Rename Sheet Name on cell value condition (6 replies)
  66. [SOLVED:] variable not defined compile error (3 replies)
  67. [SOLVED:] Help with Salesforce Login from Excel (8 replies)
  68. VBA formula to populate from PDF? (1 replies)
  69. Hyperlink from cell to sheet (2 replies)
  70. Excel Opening The Wrong File (10 replies)
  71. MSComm RTU serial communication (2 replies)
  72. Using Loops do create emails from Excel (11 replies)
  73. Subtract textbox value from cell value (1 replies)
  74. Copy data from sheet 2 variable range to sheet 3 fixed range and send it by email (5 replies)
  75. Help with "OR" in VBA (6 replies)
  76. [SOLVED:] Selected listbox items to worksheet not working (5 replies)
  77. My subtotal and sum (1 replies)
  78. [SOLVED:] VBA to Highlight Rows based upon a Populated Cell (6 replies)
  79. object or with block variable not set?? (7 replies)
  80. Copy charts from Excel to Word using Late Binding (1 replies)
  81. Data Merge (8 replies)
  82. The Userform getdata and edit/add macros for both Text and Comboboxes (0 replies)
  83. [SOLVED:] VBA - Run time error 1004: Application defined or Object-Defined Error (3 replies)
  84. Is there a Limit to where you can place a table to query it from ADODB? (3 replies)
  85. is there a way to combine these 3 macros into 1 macro ? (3 replies)
  86. Fill the missing cells with date (18 replies)
  87. New error in previously working VB code (18 replies)
  88. Split Excel worksheet into multiple workbooks (2 replies)
  89. Separate data from Sheet1 to other Sheets based on filtering & conditional formating (1 replies)
  90. Conditional Format with Date Stamp based on user input (6 replies)
  91. Getting error 32809 - when ever we open our excel application (8 replies)
  92. Merging different workbook into one workbook in different tabs. (2 replies)
  93. [SOLVED:] VBA IF Function for Digital Flip Flop (4 replies)
  94. VBA not on proper ActiveSheet (3 replies)
  95. [SOLVED:] Excel generate Outlook appointments (1 replies)
  96. [SOLVED:] Macro to take data from a file other than the current (7 replies)
  97. Excel IF formula for birth date range (0 replies)
  98. what's wrong with this code? (1 replies)
  99. [SOLVED:] Need Help on ADODB Query, need to convert field to int and order on it (4 replies)
  100. [SOLVED:] Random numbers with specific outcome (3 replies)
  101. Just Hallo (1 replies)
  102. Need to standardize 100s of excel files that have columns in the wrong order (8 replies)
  103. [SOLVED:] Need help removing unwanted commas that sometimes appear in rows in csv files (22 replies)
  104. Unhide and Activate a Worksheet using Radio Button on UserFrom (8 replies)
  105. Copy row to a new sheet if a cell in the row meets criteria (11 replies)
  106. Freeze panes shifting on worksheet (4 replies)
  107. Uploading not working (4 replies)
  108. [SOLVED:] Checking cell format (7 replies)
  109. How to save excel file in CSV with Comma delimited (*.csv) (1 replies)
  110. How to do web scraping from java based website (6 replies)
  111. [SOLVED:] Change Cells color based on cell and other cells value. (2 replies)
  112. [SOLVED:] Improve Performance of Insert (24 replies)
  113. Create sheets using data shown in filter (4 replies)
  114. [SOLVED:] Sort blocks independently (2 replies)
  115. Use check button enable/disable code lines (2 replies)
  116. follow hyperlink to location then delete linked file (2 replies)
  117. Sleeper: Combo boxes stopped working (1 replies)
  118. How to use the path of an excel filevariable in a formula? (1 replies)
  119. VBA for Row Difference (1 replies)
  120. [SOLVED:] Sum if (9 replies)
  121. [SOLVED:] Compile Errror: Can't Find Project or Library (3 replies)
  122. [SOLVED:] Update data fill down dynamically (3 replies)
  123. [SOLVED:] Copying Row Above Results In Zero Instead of Blank (3 replies)
  124. [SOLVED:] Modify Code to Include More Columns (1 replies)
  125. [SOLVED:] Copy & Paste Variable Range By Table Header (8 replies)
  126. Downlaod URL Data on disk based on criteria (0 replies)
  127. VBA script to extract/reduce data to certain parameters(columns) (9 replies)
  128. DAYS360 in VBA (3 replies)
  129. How to add date column in workbook files (5 replies)
  130. [SOLVED:] horizantal total (4 replies)
  131. Line intersection - with a difference (3 replies)
  132. [SOLVED:] Problem with Deleting Select Legend Keys (6 replies)
  133. Customize Error bars individually in a dynamic timeline chart (0 replies)
  134. How to set 2 condition in VBA (7 replies)
  135. [SOLVED:] Change tab color based on cell contents (3 replies)
  136. Runtime Errror 9 Subscript out of range (5 replies)
  137. vba to send appointment from excel to outlook (0 replies)
  138. Excel VBA to select first value in Validation list (2 replies)
  139. [SOLVED:] Function that finds number of Fridays in a particular interval date (13 replies)
  140. [SOLVED:] Copy Table from one Sheet to Another (2 replies)
  141. VBA Date Match Error (1 replies)
  142. [SOLVED:] Run-time error 424 issue (4 replies)
  143. [SOLVED:] Inserting a Row based on two conditions (4 replies)
  144. A few questions about DoEvents (43 replies)
  145. Ifs, ors, and nots (3 replies)
  146. vbCrLf and vbLf (3 replies)
  147. [SOLVED:] Operation must use an updateable query (5 replies)
  148. [SOLVED:] Need Code to copy Data to other sheets on condition (5 replies)
  149. [SOLVED:] Types of Data Distributions (3 replies)
  150. [SLEEPER:] Running a Database Query (2 replies)
  151. [SOLVED:] Sorting by number of character in cell (4 replies)
  152. Run-time error '5' : From Excel Macro to AutoCad (5 replies)
  153. Worksheet Sheet ActiveX Controls Command Buttons Stopped Don't Work Working (1 replies)
  154. [SOLVED:] Object doesn't support this property or method (3 replies)
  155. Subtitle problem in embedded WMP control (3 replies)
  156. Special Characters (3 replies)
  157. Count button clicks and write them to a file or sheet with time and date index (2 replies)
  158. Automatic row addition (3 replies)
  159. VBA to Format Charts (6 replies)
  160. [SOLVED:] Compare comma separated numbers (16 replies)
  161. [SOLVED:] Run-time error '70': Permission denied ->when i run code (11 replies)
  162. Stop button from moving (1 replies)
  163. Shared workbook with specific sheets being read only if in use? (5 replies)
  164. Which is the best tool to repair Excel? (10 replies)
  165. Date type changing when moving cells from one sheet to another (3 replies)
  166. Using ShowDetail Causes Un-Grouping (2 replies)
  167. Show Item on special cell when click on each cell on column E (2 replies)
  168. [SOLVED:] Copy all text on Sheet2 and paste to the Last unused row on Sheet1 (3 replies)
  169. Consolidating Workbooks (2 replies)
  170. Search column for text match, if found add text into row (3 replies)
  171. [SOLVED:] Access array between different modules (16 replies)
  172. Excel VBA help! Duplicate orders with same customer ID totals? (2 replies)
  173. Sleeper: VBA assistance (9 replies)
  174. Sleeper: Excel SQL Query (6 replies)
  175. [SOLVED:] Excel VBA to What If Test (11 replies)
  176. [SOLVED:] Colours based on drop down (3 replies)
  177. Create Check Box before running Macros (2 replies)
  178. [SOLVED:] Paste copied info one row down daily (3 replies)
  179. [SOLVED:] Little help with VBA please and programming search in VBA (4 replies)
  180. [SOLVED:] ActiveX button VBA references contents of button sheet even after activating new one (3 replies)
  181. Adding a common value to a column using VBA (1 replies)
  182. [SOLVED:] Shape selection based on user input (9 replies)
  183. [SOLVED:] Custom Ribbon XML - Create a Dropdown with Additional SubMenu (2 replies)
  184. [SOLVED:] Excel 2010 Weekly Update Breaks Excel (6 replies)
  185. [SOLVED:] How to add table in the outlook via excel. (26 replies)
  186. [SOLVED:] Avoiding run time error '424': object required (3 replies)
  187. Macro to Create Multiple Pivot Tables in Multiple Sheets with Dynamic Data Filter (2 replies)
  188. Transferring Data from one Workbook to Another based on whether or not the cell is em (1 replies)
  189. [SOLVED:] Merging PDFs Based on Checklist Selection in Excel (12 replies)
  190. Match duplicates and copy updated cells from one worksheet to another (3 replies)
  191. Export Data from another program to excel (2 replies)
  192. Paste Excel Picture from Cell in to Word - Error 438 (4 replies)
  193. Get container and/or parent of dynamically created control (checkbox) (2 replies)
  194. vba to send email at the end of the day. (19 replies)
  195. Saving Using Path Definition (1 replies)
  196. VDA structure creating (5 replies)
  197. Toggle autofilter while sheet is protected (3 replies)
  198. [SOLVED:] Adding Sheets from array (3 replies)
  199. Tracking tasks. (0 replies)
  200. HTTTP Post Request Help Needed (1 replies)
  201. Duplicate Entire Row where Comma Exists (3 replies)
  202. [SOLVED:] COUNTIF - Alternate to count values in every third cell rather than full range. (2 replies)
  203. Insert Copied does not work when selecting Visible Cells Only (4 replies)
  204. Error 13: Type Mismatch Row Limit Restriction? (4 replies)
  205. vba for when data is changed to remove item from data validation list in another wksh (1 replies)
  206. Copy paste filtered range with criteria using VBA (1 replies)
  207. [SOLVED:] VBA code to quickly change dates and times in comments (17 replies)
  208. Using VBA to paste an Excel sheet as an image and keep conditional formatting (2 replies)
  209. [SOLVED:] I'm having trouble removing some shapes from my worksheet (16 replies)
  210. [SOLVED:] How to make Excel file only open in Excel 2007 (18 replies)
  211. Assign each trade a Trade ID (2 replies)
  212. Remove line breaks (2 replies)
  213. Sleeper: Select Case Statement Problem (2 replies)
  214. Looking to create a Outlook Task. Need VBA Template (0 replies)
  215. Insert file name and loop (0 replies)
  216. [SOLVED:] Formula help please (6 replies)
  217. Get all data from word table into excel (2 replies)
  218. [SOLVED:] VBA code to initiate search button on website (2 replies)
  219. IF Statement that will assign account types based on "account number" (1 replies)
  220. [SOLVED:] excel functions regarding text entries (5 replies)
  221. [SOLVED:] Array (6 replies)
  222. right-Click on image (1 replies)
  223. [SOLVED:] Macro that to transfer information sheets by product (12 replies)
  224. VBA macro to create pdf and folder based on cell values (18 replies)
  225. [SOLVED:] clear contents of adjacent cell(s) on change (8 replies)
  226. Workbook open fail problem (9 replies)
  227. click a button in a dropdown menu on webpage to download sth using vba (4 replies)
  228. [SOLVED:] Extracting Last name, First Name and sometimes Middle Name (3 replies)
  229. [SOLVED:] VBA check box used to change color of a cell not working (6 replies)
  230. [SOLVED:] Delete Rows Based ColA (multiple criteria)-Delete Rows based ColB (multiple criteria) (2 replies)
  231. [SOLVED:] VBA CheckBox issues (5 replies)
  232. Convert excel data to fixed width text file (2 replies)
  233. ByVal vs ByRef Question (12 replies)
  234. [SOLVED:] VBA Excel: Error 424 in "For Each" caused by FireEvent ("onchange") (4 replies)
  235. can't find my mistake to calculate target price (4 replies)
  236. Userform or InputBox appearing on screen connected via network (0 replies)
  237. VBA Excel: How to create file which will be crashed on precise date (8 replies)
  238. Finding the greater text value from several cells (6 replies)
  239. [SOLVED:] VBA - Random Comparison Columns (15 replies)
  240. Adding Columns into Excel with a Macro (5 replies)
  241. [SOLVED:] Time Format in a cell (14 replies)
  242. Loop Case Statement (3 replies)
  243. error msg box (2 replies)
  244. Menu shortcuts (7 replies)
  245. Get browser to update after changing drop down box value (1 replies)
  246. VBA help request: copy a range, add new data within the range and paste beneath data (3 replies)
  247. Mail Merge VBA + Excel + Word!? (3 replies)
  248. [SOLVED:] VBA creating, activating command buttons (3 replies)
  249. [SOLVED:] Tricky COUNT(IF(S)) problem (1 replies)
  250. Index function skips value in table. (12 replies)