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. [SOLVED:] Run-time error '70': Permission denied ->when i run code (11 replies)
  2. Stop button from moving (1 replies)
  3. Shared workbook with specific sheets being read only if in use? (5 replies)
  4. Which is the best tool to repair Excel? (10 replies)
  5. Date type changing when moving cells from one sheet to another (3 replies)
  6. Using ShowDetail Causes Un-Grouping (2 replies)
  7. Show Item on special cell when click on each cell on column E (2 replies)
  8. [SOLVED:] Copy all text on Sheet2 and paste to the Last unused row on Sheet1 (3 replies)
  9. Consolidating Workbooks (2 replies)
  10. Search column for text match, if found add text into row (3 replies)
  11. [SOLVED:] Access array between different modules (16 replies)
  12. Excel VBA help! Duplicate orders with same customer ID totals? (2 replies)
  13. Sleeper: VBA assistance (9 replies)
  14. Sleeper: Excel SQL Query (6 replies)
  15. [SOLVED:] Excel VBA to What If Test (11 replies)
  16. [SOLVED:] Colours based on drop down (3 replies)
  17. Create Check Box before running Macros (2 replies)
  18. [SOLVED:] Paste copied info one row down daily (3 replies)
  19. [SOLVED:] Little help with VBA please and programming search in VBA (4 replies)
  20. [SOLVED:] ActiveX button VBA references contents of button sheet even after activating new one (3 replies)
  21. Adding a common value to a column using VBA (1 replies)
  22. [SOLVED:] Shape selection based on user input (9 replies)
  23. [SOLVED:] Custom Ribbon XML - Create a Dropdown with Additional SubMenu (2 replies)
  24. [SOLVED:] Excel 2010 Weekly Update Breaks Excel (6 replies)
  25. [SOLVED:] How to add table in the outlook via excel. (26 replies)
  26. [SOLVED:] Avoiding run time error '424': object required (3 replies)
  27. Macro to Create Multiple Pivot Tables in Multiple Sheets with Dynamic Data Filter (2 replies)
  28. Transferring Data from one Workbook to Another based on whether or not the cell is em (1 replies)
  29. [SOLVED:] Merging PDFs Based on Checklist Selection in Excel (12 replies)
  30. Match duplicates and copy updated cells from one worksheet to another (3 replies)
  31. Export Data from another program to excel (2 replies)
  32. Paste Excel Picture from Cell in to Word - Error 438 (4 replies)
  33. Get container and/or parent of dynamically created control (checkbox) (2 replies)
  34. vba to send email at the end of the day. (19 replies)
  35. Saving Using Path Definition (1 replies)
  36. VDA structure creating (5 replies)
  37. Toggle autofilter while sheet is protected (3 replies)
  38. [SOLVED:] Adding Sheets from array (3 replies)
  39. Tracking tasks. (0 replies)
  40. HTTTP Post Request Help Needed (1 replies)
  41. Duplicate Entire Row where Comma Exists (3 replies)
  42. [SOLVED:] COUNTIF - Alternate to count values in every third cell rather than full range. (2 replies)
  43. Insert Copied does not work when selecting Visible Cells Only (4 replies)
  44. Error 13: Type Mismatch Row Limit Restriction? (4 replies)
  45. vba for when data is changed to remove item from data validation list in another wksh (1 replies)
  46. Copy paste filtered range with criteria using VBA (1 replies)
  47. [SOLVED:] VBA code to quickly change dates and times in comments (17 replies)
  48. Using VBA to paste an Excel sheet as an image and keep conditional formatting (2 replies)
  49. [SOLVED:] I'm having trouble removing some shapes from my worksheet (16 replies)
  50. [SOLVED:] How to make Excel file only open in Excel 2007 (18 replies)
  51. Assign each trade a Trade ID (2 replies)
  52. Remove line breaks (2 replies)
  53. Sleeper: Select Case Statement Problem (2 replies)
  54. Looking to create a Outlook Task. Need VBA Template (0 replies)
  55. Insert file name and loop (0 replies)
  56. [SOLVED:] Formula help please (6 replies)
  57. Get all data from word table into excel (2 replies)
  58. [SOLVED:] VBA code to initiate search button on website (2 replies)
  59. IF Statement that will assign account types based on "account number" (1 replies)
  60. [SOLVED:] excel functions regarding text entries (5 replies)
  61. [SOLVED:] Array (6 replies)
  62. right-Click on image (1 replies)
  63. [SOLVED:] Macro that to transfer information sheets by product (12 replies)
  64. VBA macro to create pdf and folder based on cell values (18 replies)
  65. [SOLVED:] clear contents of adjacent cell(s) on change (8 replies)
  66. Workbook open fail problem (9 replies)
  67. click a button in a dropdown menu on webpage to download sth using vba (4 replies)
  68. [SOLVED:] Extracting Last name, First Name and sometimes Middle Name (3 replies)
  69. [SOLVED:] VBA check box used to change color of a cell not working (6 replies)
  70. [SOLVED:] Delete Rows Based ColA (multiple criteria)-Delete Rows based ColB (multiple criteria) (2 replies)
  71. [SOLVED:] VBA CheckBox issues (5 replies)
  72. Convert excel data to fixed width text file (2 replies)
  73. ByVal vs ByRef Question (12 replies)
  74. [SOLVED:] VBA Excel: Error 424 in "For Each" caused by FireEvent ("onchange") (4 replies)
  75. can't find my mistake to calculate target price (4 replies)
  76. Userform or InputBox appearing on screen connected via network (0 replies)
  77. VBA Excel: How to create file which will be crashed on precise date (8 replies)
  78. Finding the greater text value from several cells (6 replies)
  79. [SOLVED:] VBA - Random Comparison Columns (15 replies)
  80. Adding Columns into Excel with a Macro (5 replies)
  81. [SOLVED:] Time Format in a cell (14 replies)
  82. Loop Case Statement (3 replies)
  83. error msg box (2 replies)
  84. Menu shortcuts (7 replies)
  85. Get browser to update after changing drop down box value (1 replies)
  86. VBA help request: copy a range, add new data within the range and paste beneath data (3 replies)
  87. Mail Merge VBA + Excel + Word!? (3 replies)
  88. [SOLVED:] VBA creating, activating command buttons (3 replies)
  89. [SOLVED:] Tricky COUNT(IF(S)) problem (1 replies)
  90. Index function skips value in table. (12 replies)
  91. Double Click to insert Row (3 replies)
  92. Double numbers (9 replies)
  93. [SOLVED:] VBA to select first cell with data in a row (0 replies)
  94. Sine using Taylor Series (3 replies)
  95. [SOLVED:] Lock sheet-macro (4 replies)
  96. VBA_ How to download .xls file (which is created from javascript) from website (8 replies)
  97. Exit MsgBox If MsgBoxResult = Cancel (1 replies)
  98. [SOLVED:] Add "Print" button to my msg box (7 replies)
  99. Filter/Sort looping issue (0 replies)
  100. VBA - Hiding rows in worksheets with comments (3 replies)
  101. VBA Sharepoint Check out & Check in - Please help a newbie!! (0 replies)
  102. Why so hard to get a cell's formula dependents/precedents (2 replies)
  103. 3D garph help (5 replies)
  104. Problem with conditional selection (1 replies)
  105. Completing Data / Interpolation (1 replies)
  106. [SOLVED:] Copy Paste Formula in alternate Rows without breaking link (9 replies)
  107. Error 438 in VBA (2 replies)
  108. [SOLVED:] PivotTable copy certain sections and paste to another sheet (3 replies)
  109. VBA to change cell font if then not working (2 replies)
  110. Amendment (With exception) on the the created vendor macro file (0 replies)
  111. [SOLVED:] New Issue with SaveAs (2 replies)
  112. VBA to send Email from other users on shared WB (3 replies)
  113. [SOLVED:] Copy only borders of a range to new range (11 replies)
  114. [SOLVED:] Help to modify this lookup function (8 replies)
  115. How to bypass security warning sending emails from outlook using Excel VBA Code sampl (13 replies)
  116. Type Mismatch error because macro only applicable to .xls - files and not .csv (3 replies)
  117. [SOLVED:] Insert Row with formula on double click & delete last row within a defined Range (1 replies)
  118. Return Color of Individual Characters in Cell (2 replies)
  119. VBA separate range of dates in cells with duration (2 replies)
  120. [SOLVED:] Formula to return value in months in date range match (3 replies)
  121. Colour visible cells in a loop VBA (2 replies)
  122. Fetching datas from different sheets onto one sheet (1 replies)
  123. Save/Retrieve Image from database using excel vba (0 replies)
  124. VBA - struggling to calc and write StDev data into an array with a For Next loop (9 replies)
  125. Loop through and ignore hidden rows (1 replies)
  126. Identify cell formula changes in VBA (0 replies)
  127. AHT Calculation (11 replies)
  128. How to generate Crystal Report (SAP BO BI) using Excel VBA? (2 replies)
  129. Code for linking multiple check boxes with If then statements (9 replies)
  130. VBA - Search Loop Help (0 replies)
  131. Copy & Paste Based on Column Criteria (2 replies)
  132. If then Else to fill blank cells (2 replies)
  133. [SOLVED:] Mininum Maximum (18 replies)
  134. Keyboard shortcut to refresh the data in auto-filter column (7 replies)
  135. copying Data from multiple tabs of multiple files in master file (0 replies)
  136. COUNTIF (unique values only) (8 replies)
  137. [SOLVED:] EOF question (7 replies)
  138. Problem to calculate target price according to tree levels (2 replies)
  139. Date Picker Issue (11 replies)
  140. Combining duplicates based on several conditions (2 replies)
  141. [SOLVED:] Run-time error '1004': Application-defined or object-defined error (2 replies)
  142. [SOLVED:] Coordinate based query and data copy/paste/clear (13 replies)
  143. Export All Pictures in Spreadsheet as Filename in Cell Range (9 replies)
  144. [SOLVED:] code executing too fast? (1 replies)
  145. [SOLVED:] Cond Formatting (2 replies)
  146. Run-time error 13 - type mismatch- simple price time series calc not working on array (6 replies)
  147. vba to terminate Chrome Browser (1 replies)
  148. [SOLVED:] Find text in Row and use as criteria for search in column where text is found (23 replies)
  149. [SOLVED:] ADO Query of Excel Table is returning with incorrect Field Type (7 replies)
  150. Excel to Memories (1 replies)
  151. Excel traversing Array Uses lots of Memory (3 replies)
  152. [SOLVED:] Select Cell X, Filter cell Y, if cell Y meets condition Z -> Input into cell X (2 replies)
  153. [SOLVED:] Entering a value to a range of cells which are -1 column from cells selected (2 replies)
  154. [SOLVED:] Selecting numeric data in range if they start with 2 specified numbers (2 replies)
  155. Calculate BOM levels with target price (6 replies)
  156. How do I handle missing XML attributes? (0 replies)
  157. Is it possible to Insert Array into Excel Table (1 replies)
  158. Date Tracking NEW (2 replies)
  159. run-time error 91 (15 replies)
  160. Macro Inserts Lines, but disturbs referencing cells (1 replies)
  161. Tab behavior in user forms (2 replies)
  162. Date Data Tracking (11 replies)
  163. Delete table rows from different worksheets in excel (1 replies)
  164. Workday Friday changed to a Thursday (4 replies)
  165. Ranking and declaring winner and runner up (2 replies)
  166. Click in Image with iframe (1 replies)
  167. Macro to save a readonly copy of file with todays date (2 replies)
  168. Consolidating data (2 replies)
  169. [SOLVED:] Pre Typed Text Box Appear After Macro is Executed (15 replies)
  170. Two Sheets Exported to One File (1 replies)
  171. Excel Formula to determine winning teams (5 replies)
  172. [SOLVED:] Find Hidden cells in array and enable "Calculate used range" on all non hidden cells (8 replies)
  173. Excell (1 replies)
  174. Compare two columns varying in number of rows on different sheets (5 replies)
  175. Need help with creating references from one sheet to another in a more efficient way. (4 replies)
  176. Trouble with swimming time grading in excel (4 replies)
  177. xlSheetVeryHidden Does Not Work on Mac? (3 replies)
  178. Skipping Over If Statement (1 replies)
  179. Split cell contents (3 replies)
  180. [SOLVED:] Clean and Trim Text from Download (7 replies)
  181. Data Picking and placing to appropriate cell (1 replies)
  182. VBA substitute on Office RT? (2 replies)
  183. Maintain index table to show allocated numbers (12 replies)
  184. [SOLVED:] Count Cells by Color (19 replies)
  185. [SOLVED:] Delete rows ONLY IF duplicate value in column A + cell is highlighted Specific Color. (2 replies)
  186. [SOLVED:] Copy Data from one sheet to another IF cells are highlighted specific colors. (15 replies)
  187. User Form Code to Load Text Files (6 replies)
  188. [SOLVED:] Get Max value in a multpile term cell reference (6 replies)
  189. [SOLVED:] Insert Picture in Footer (2 replies)
  190. When PrintView button is clicked open the invoice in PDF format (10 replies)
  191. Hide Rows to variable specific criteria (4 replies)
  192. Document select, and move (5 replies)
  193. Date Filtering with VBA (2 replies)
  194. [SOLVED:] Subtotals several columns (30 replies)
  195. [SOLVED:] Wrapper for RtlMoveMemory (5 replies)
  196. [SOLVED:] Out of memory for below code (6 replies)
  197. Macro to copy data from one workbook to another. (7 replies)
  198. Need Help with Querying an Excel Table in VBA. ADO? (16 replies)
  199. select cells through loop (2 replies)
  200. EXCEL VBA: how to use vba fuction to translate the day format (3 replies)
  201. ScaleAxes with VBA problem (2 replies)
  202. [SOLVED:] Disable Send by Email (3 replies)
  203. With 2 sheets, if value not in one sheet AND column C = specific color, copy & Insert (0 replies)
  204. Sleeper: Creation macros (1 replies)
  205. Challenging issue when making alignment of datas into excel using vba (5 replies)
  206. [SOLVED:] List all Excel and Word files in a folder containing specific text (13 replies)
  207. [SOLVED:] have to delete one to one duplicate entry in muliple columns (3 replies)
  208. Select multiple cells in a range (9 replies)
  209. Computing Limitations for large VBA code (8 replies)
  210. Save a file as csv with date (6 replies)
  211. Fetch the data's from excel file and provide the CSV file as a output (5 replies)
  212. (*Challenging!*) Protect two range's data validation and change in priority order (13 replies)
  213. [SOLVED:] Help using Named Range in VBA tp pupultate a worksheet. (3 replies)
  214. Custom button sometimes won't load to ribbon through xml (2 replies)
  215. Case When error for set values (5 replies)
  216. Fill Down Data (5 replies)
  217. [SOLVED:] Macro that sorts a specific column by colors and value. (5 replies)
  218. Measure height of textbox (3 replies)
  219. [SOLVED:] Reformat Spreadsheet (3 replies)
  220. Moving Duplicate records from one worksheet to another (14 replies)
  221. VBA- copy/union certain cells (1 replies)
  222. Runtime error 1004 (4 replies)
  223. VBA Help, need this for school (7 replies)
  224. Macro/VBA to remove all text before hypens - Active X Combo Box (12 replies)
  225. Pivot Table - Hide Columns + Maintain Grand Total (2 replies)
  226. Most efficient way to copy array data (big amount of data) to a txt file (6 replies)
  227. macro to control visible tabs (12 replies)
  228. VBA code to transfer data to different workbooks (36 replies)
  229. [SOLVED:] CONCATENATE used with IF AND funtion (5 replies)
  230. Code takes action on multiple worksheets (6 replies)
  231. VBA Automatic Data Export from .Docx to Excel (2 replies)
  232. Optimize VBA code (10 replies)
  233. Pivot table priority issue (2 replies)
  234. Sleeper: Run time error 1004 file could not open (7 replies)
  235. Changing cell value from another workbook cell value in vba macro (1 replies)
  236. [SOLVED:] formulaArray resultat over Msgbox (3 replies)
  237. Pivot table format (0 replies)
  238. [SOLVED:] AUTOMATIC ROW NUMBER GENERATOR (4 replies)
  239. [SOLVED:] vba to generate XML file with different values (3 replies)
  240. Fill sheet 2 with details as froma table in sheet 1 (4 replies)
  241. [SOLVED:] Using DropDown list to navigate through Sheets - Help with Code size reduction (8 replies)
  242. Need to calculate sum & division till end of data in sheet1 (1 replies)
  243. VLOOKUP referencing table name (3 replies)
  244. Moving Rows Reversing Columns by VBA (4 replies)
  245. [SOLVED:] Listbox default tem when the list is made up of dates (4 replies)
  246. Modifying codes to add if-else statement (6 replies)
  247. [SOLVED:] Copy and paste data and format if values match between sheets (11 replies)
  248. [SOLVED:] Custom function not being able to record correct cell values - RANDOMLY??? (13 replies)
  249. [SOLVED:] Make macro timer a little bit more fancy (4 replies)
  250. [SOLVED:] How to insert rows in sheet1 based on sequence number. (4 replies)