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. [SOLVED:] Time Format in a cell (14 replies)
  2. Loop Case Statement (3 replies)
  3. error msg box (2 replies)
  4. Menu shortcuts (7 replies)
  5. Get browser to update after changing drop down box value (1 replies)
  6. VBA help request: copy a range, add new data within the range and paste beneath data (3 replies)
  7. Mail Merge VBA + Excel + Word!? (3 replies)
  8. [SOLVED:] VBA creating, activating command buttons (3 replies)
  9. [SOLVED:] Tricky COUNT(IF(S)) problem (1 replies)
  10. Index function skips value in table. (12 replies)
  11. Double Click to insert Row (3 replies)
  12. Double numbers (9 replies)
  13. [SOLVED:] VBA to select first cell with data in a row (0 replies)
  14. Sine using Taylor Series (3 replies)
  15. [SOLVED:] Lock sheet-macro (4 replies)
  16. VBA_ How to download .xls file (which is created from javascript) from website (8 replies)
  17. Exit MsgBox If MsgBoxResult = Cancel (1 replies)
  18. [SOLVED:] Add "Print" button to my msg box (7 replies)
  19. Filter/Sort looping issue (0 replies)
  20. VBA - Hiding rows in worksheets with comments (3 replies)
  21. VBA Sharepoint Check out & Check in - Please help a newbie!! (0 replies)
  22. Why so hard to get a cell's formula dependents/precedents (2 replies)
  23. 3D garph help (5 replies)
  24. Problem with conditional selection (1 replies)
  25. Completing Data / Interpolation (1 replies)
  26. [SOLVED:] Copy Paste Formula in alternate Rows without breaking link (9 replies)
  27. Error 438 in VBA (2 replies)
  28. [SOLVED:] PivotTable copy certain sections and paste to another sheet (3 replies)
  29. VBA to change cell font if then not working (2 replies)
  30. Amendment (With exception) on the the created vendor macro file (0 replies)
  31. [SOLVED:] New Issue with SaveAs (2 replies)
  32. VBA to send Email from other users on shared WB (3 replies)
  33. [SOLVED:] Copy only borders of a range to new range (11 replies)
  34. [SOLVED:] Help to modify this lookup function (8 replies)
  35. How to bypass security warning sending emails from outlook using Excel VBA Code sampl (13 replies)
  36. Type Mismatch error because macro only applicable to .xls - files and not .csv (3 replies)
  37. [SOLVED:] Insert Row with formula on double click & delete last row within a defined Range (1 replies)
  38. [SOLVED:] Return Color of Individual Characters in Cell (2 replies)
  39. VBA separate range of dates in cells with duration (2 replies)
  40. [SOLVED:] Formula to return value in months in date range match (3 replies)
  41. Colour visible cells in a loop VBA (2 replies)
  42. Fetching datas from different sheets onto one sheet (1 replies)
  43. Save/Retrieve Image from database using excel vba (0 replies)
  44. [SLEEPER:] VBA - struggling to calc and write StDev data into an array with a For Next loop (9 replies)
  45. Loop through and ignore hidden rows (1 replies)
  46. Identify cell formula changes in VBA (0 replies)
  47. AHT Calculation (11 replies)
  48. How to generate Crystal Report (SAP BO BI) using Excel VBA? (2 replies)
  49. Code for linking multiple check boxes with If then statements (9 replies)
  50. VBA - Search Loop Help (0 replies)
  51. Copy & Paste Based on Column Criteria (2 replies)
  52. If then Else to fill blank cells (2 replies)
  53. [SOLVED:] Mininum Maximum (18 replies)
  54. [SLEEPER:] Keyboard shortcut to refresh the data in auto-filter column (7 replies)
  55. copying Data from multiple tabs of multiple files in master file (0 replies)
  56. COUNTIF (unique values only) (8 replies)
  57. [SOLVED:] EOF question (7 replies)
  58. Problem to calculate target price according to tree levels (2 replies)
  59. Date Picker Issue (11 replies)
  60. Combining duplicates based on several conditions (2 replies)
  61. [SOLVED:] Run-time error '1004': Application-defined or object-defined error (2 replies)
  62. [SOLVED:] Coordinate based query and data copy/paste/clear (13 replies)
  63. Export All Pictures in Spreadsheet as Filename in Cell Range (9 replies)
  64. [SOLVED:] code executing too fast? (1 replies)
  65. [SOLVED:] Cond Formatting (2 replies)
  66. Run-time error 13 - type mismatch- simple price time series calc not working on array (6 replies)
  67. vba to terminate Chrome Browser (1 replies)
  68. [SOLVED:] Find text in Row and use as criteria for search in column where text is found (23 replies)
  69. [SOLVED:] ADO Query of Excel Table is returning with incorrect Field Type (7 replies)
  70. Excel to Memories (1 replies)
  71. Excel traversing Array Uses lots of Memory (3 replies)
  72. [SOLVED:] Select Cell X, Filter cell Y, if cell Y meets condition Z -> Input into cell X (2 replies)
  73. [SOLVED:] Entering a value to a range of cells which are -1 column from cells selected (2 replies)
  74. [SOLVED:] Selecting numeric data in range if they start with 2 specified numbers (2 replies)
  75. Calculate BOM levels with target price (6 replies)
  76. How do I handle missing XML attributes? (0 replies)
  77. Is it possible to Insert Array into Excel Table (1 replies)
  78. Date Tracking NEW (2 replies)
  79. run-time error 91 (15 replies)
  80. Macro Inserts Lines, but disturbs referencing cells (1 replies)
  81. Tab behavior in user forms (2 replies)
  82. Date Data Tracking (11 replies)
  83. Delete table rows from different worksheets in excel (1 replies)
  84. Workday Friday changed to a Thursday (4 replies)
  85. Ranking and declaring winner and runner up (2 replies)
  86. Click in Image with iframe (1 replies)
  87. Macro to save a readonly copy of file with todays date (2 replies)
  88. Consolidating data (2 replies)
  89. [SOLVED:] Pre Typed Text Box Appear After Macro is Executed (15 replies)
  90. Two Sheets Exported to One File (1 replies)
  91. Excel Formula to determine winning teams (5 replies)
  92. [SOLVED:] Find Hidden cells in array and enable "Calculate used range" on all non hidden cells (8 replies)
  93. Excell (1 replies)
  94. Compare two columns varying in number of rows on different sheets (5 replies)
  95. Need help with creating references from one sheet to another in a more efficient way. (4 replies)
  96. Trouble with swimming time grading in excel (4 replies)
  97. xlSheetVeryHidden Does Not Work on Mac? (3 replies)
  98. Skipping Over If Statement (1 replies)
  99. Split cell contents (3 replies)
  100. [SOLVED:] Clean and Trim Text from Download (7 replies)
  101. Data Picking and placing to appropriate cell (1 replies)
  102. VBA substitute on Office RT? (2 replies)
  103. Maintain index table to show allocated numbers (12 replies)
  104. [SOLVED:] Count Cells by Color (19 replies)
  105. [SOLVED:] Delete rows ONLY IF duplicate value in column A + cell is highlighted Specific Color. (2 replies)
  106. [SOLVED:] Copy Data from one sheet to another IF cells are highlighted specific colors. (15 replies)
  107. User Form Code to Load Text Files (6 replies)
  108. [SOLVED:] Get Max value in a multpile term cell reference (6 replies)
  109. [SOLVED:] Insert Picture in Footer (2 replies)
  110. When PrintView button is clicked open the invoice in PDF format (10 replies)
  111. Hide Rows to variable specific criteria (4 replies)
  112. Document select, and move (5 replies)
  113. Date Filtering with VBA (2 replies)
  114. [SOLVED:] Subtotals several columns (30 replies)
  115. [SOLVED:] Wrapper for RtlMoveMemory (5 replies)
  116. [SOLVED:] Out of memory for below code (6 replies)
  117. Macro to copy data from one workbook to another. (7 replies)
  118. Need Help with Querying an Excel Table in VBA. ADO? (16 replies)
  119. select cells through loop (2 replies)
  120. [SOLVED:] How to use vba fuction to translate the day format (3 replies)
  121. ScaleAxes with VBA problem (2 replies)
  122. [SOLVED:] Disable Send by Email (3 replies)
  123. With 2 sheets, if value not in one sheet AND column C = specific color, copy & Insert (0 replies)
  124. Sleeper: Creation macros (1 replies)
  125. Challenging issue when making alignment of datas into excel using vba (5 replies)
  126. [SOLVED:] List all Excel and Word files in a folder containing specific text (13 replies)
  127. [SOLVED:] have to delete one to one duplicate entry in muliple columns (3 replies)
  128. Select multiple cells in a range (9 replies)
  129. Computing Limitations for large VBA code (8 replies)
  130. Save a file as csv with date (6 replies)
  131. Fetch the data's from excel file and provide the CSV file as a output (5 replies)
  132. (*Challenging!*) Protect two range's data validation and change in priority order (13 replies)
  133. [SOLVED:] Help using Named Range in VBA tp pupultate a worksheet. (3 replies)
  134. Custom button sometimes won't load to ribbon through xml (2 replies)
  135. Case When error for set values (5 replies)
  136. Fill Down Data (5 replies)
  137. [SOLVED:] Macro that sorts a specific column by colors and value. (5 replies)
  138. Measure height of textbox (3 replies)
  139. [SOLVED:] Reformat Spreadsheet (3 replies)
  140. Moving Duplicate records from one worksheet to another (14 replies)
  141. VBA- copy/union certain cells (1 replies)
  142. Runtime error 1004 (4 replies)
  143. VBA Help, need this for school (7 replies)
  144. Macro/VBA to remove all text before hypens - Active X Combo Box (12 replies)
  145. [SLEEPER:] Pivot Table - Hide Columns + Maintain Grand Total (2 replies)
  146. Most efficient way to copy array data (big amount of data) to a txt file (6 replies)
  147. macro to control visible tabs (12 replies)
  148. VBA code to transfer data to different workbooks (36 replies)
  149. [SOLVED:] CONCATENATE used with IF AND funtion (5 replies)
  150. Code takes action on multiple worksheets (6 replies)
  151. VBA Automatic Data Export from .Docx to Excel (2 replies)
  152. Optimize VBA code (10 replies)
  153. Pivot table priority issue (2 replies)
  154. Sleeper: Run time error 1004 file could not open (7 replies)
  155. Changing cell value from another workbook cell value in vba macro (1 replies)
  156. [SOLVED:] formulaArray resultat over Msgbox (3 replies)
  157. Pivot table format (0 replies)
  158. [SOLVED:] AUTOMATIC ROW NUMBER GENERATOR (4 replies)
  159. [SOLVED:] vba to generate XML file with different values (3 replies)
  160. Fill sheet 2 with details as froma table in sheet 1 (4 replies)
  161. [SOLVED:] Using DropDown list to navigate through Sheets - Help with Code size reduction (8 replies)
  162. Need to calculate sum & division till end of data in sheet1 (1 replies)
  163. VLOOKUP referencing table name (3 replies)
  164. Moving Rows Reversing Columns by VBA (4 replies)
  165. [SOLVED:] Listbox default tem when the list is made up of dates (4 replies)
  166. Modifying codes to add if-else statement (6 replies)
  167. [SOLVED:] Copy and paste data and format if values match between sheets (11 replies)
  168. [SOLVED:] Custom function not being able to record correct cell values - RANDOMLY??? (13 replies)
  169. [SOLVED:] Make macro timer a little bit more fancy (4 replies)
  170. [SOLVED:] How to insert rows in sheet1 based on sequence number. (4 replies)
  171. [SOLVED:] Insert after (7 replies)
  172. [SOLVED:] Adding Number into the generated Report (7 replies)
  173. How to sort invocied by column based on sequence number provided in another sheet (3 replies)
  174. Output Unique Data To An Array VBA (3 replies)
  175. Problem solved? HLOOKUP/VLOOKUP question. (3 replies)
  176. [SOLVED:] Command execution VBA (3 replies)
  177. Customer-Data Tally work sheet Update Using VBA (17 replies)
  178. Maximum x-axis value of chart couldn't fit into the image control of userform (0 replies)
  179. [SLEEPER:] mousemove(drag and drop) for spreadsheet on vba userform (2 replies)
  180. Cannot Insert Image into Mac Excel 2011 UserForm (0 replies)
  181. Send Keystrokes Without Interrupting The User?? - There has to be a way (3 replies)
  182. [SOLVED:] Date keeps returning time, don't understand why (7 replies)
  183. [SOLVED:] VBA to lock specific rows when a worksheet opens (3 replies)
  184. [SOLVED:] append several sheets to a 'Results' sheet (4 replies)
  185. Dynamic Named Range used on multiple sheets (8 replies)
  186. Query Connections on a Mac (0 replies)
  187. Excel VBA for ammending outlook Signature template (1 replies)
  188. Need Help with Macro (3 replies)
  189. [SOLVED:] Multiple Criteria Duplicates (4 replies)
  190. AppActivate does not work (6 replies)
  191. Late Binding VBIDE (2 replies)
  192. text to number (3 replies)
  193. Can some one help on Saving multiple excel files from one excel data file (1 replies)
  194. (Bit Rusty, Need Help) Copy & Paste for Adjustable Cell Range (Horizontal to Stacked) (1 replies)
  195. Need VBA coding help for status bar and screenupdating (2 replies)
  196. How to Skip a column for every 2 columns while Paste the values? (1 replies)
  197. [SOLVED:] If variable 1 = 'this' then make variable 2 = 'that' (5 replies)
  198. [SOLVED:] How to get Tab-index from user form in ascending order (12 replies)
  199. [SOLVED:] Unqualified Error (7 replies)
  200. To Sum all columns to right (5 replies)
  201. [SOLVED:] VBA to populate a multicolumn listBox using Additem (4 replies)
  202. [SOLVED:] VBA Query to filter #N/A (2 replies)
  203. [SOLVED:] Printing only non-blank rows (0 replies)
  204. Move / copy to relevant cell matched with sheet name VBA excel 2010 (0 replies)
  205. [SOLVED:] Increase Target.Value By Percentage (2 replies)
  206. Sleeper: Creating Row and Column headers based on a formula and filling with formulas (0 replies)
  207. word doc with multiple tables to master excel spreadsheet (5 replies)
  208. Pick specific portions and make new lines (20 replies)
  209. Find particular text in a sentence in a cell and copy to adjacent cell (5 replies)
  210. [SOLVED:] Compare sheets macro (2 replies)
  211. [SOLVED:] Macro to match entries in column A on diff sheets (3 replies)
  212. creating report (5 replies)
  213. Simple macro - loop to write value from column to another cell, then save as PDF (1 replies)
  214. [SOLVED:] Extract unique Values by comparing Master list and copy full row to another sheet (5 replies)
  215. Need Help: Macro that can filter data and plot results on a matrix (0 replies)
  216. [SOLVED:] Copy interior Color to linked Worksheet (1 replies)
  217. Need Help on a macro...kind of desperate! (3 replies)
  218. Excel 2007 Code (9 replies)
  219. vlookup on an array (4 replies)
  220. [SOLVED:] VBA code that Unhides sheets that are hidden using sht.Visible = xlSheetVeryHidden (13 replies)
  221. [SOLVED:] Cells blocked with permission to change II (block full range) (9 replies)
  222. Need help seperating files (4 replies)
  223. VBA syntax error (2 replies)
  224. Find all values with curly brackets (6 replies)
  225. Help need to fix code (2 replies)
  226. Error: You must rely on system font, Adobe 10, windows 7, Office 2010 (4 replies)
  227. [SOLVED:] Change cell color based on text (4 replies)
  228. [SLEEPER:] Automatic Deleting complete excel sheet in 2 years (2 replies)
  229. Clean the Cells if cell does not start with ( (2 replies)
  230. [SOLVED:] Worksheet change help please (2 replies)
  231. Select last cell with the data in the column/range of cells - only visible datas (1 replies)
  232. One Checkbox to uncheck/disable all others in group (3 replies)
  233. Minor Flaw - Help and understanding required if possible (2 replies)
  234. [SOLVED:] Extract data between brackets (7 replies)
  235. [SOLVED:] Adding Page breaks every ninth row (6 replies)
  236. Analysing a Word Documents headings and write it in an array (3 replies)
  237. [SOLVED:] VBA macro help to find index match error (9 replies)
  238. Rename Picture to Value in a Cell & Copy to Worksheet (4 replies)
  239. [SOLVED:] propertrim() and lower() functions, manipulating ranges of cells (2 replies)
  240. [SOLVED:] Interactive userform please help (18 replies)
  241. [SOLVED:] deleting old ws (cycling sheets) (1 replies)
  242. [SOLVED:] vba module not reading the IF Statement (1 replies)
  243. Get data from HTML files (7 replies)
  244. [SOLVED:] Copy multiple cells on the same worksheet after a search (1 replies)
  245. Buttons often expand to fill the worksheet. Button Bug (3 replies)
  246. Automate Report (2 replies)
  247. [SOLVED:] Conditional Formating (modify) (2 replies)
  248. [SOLVED:] VBA Formual not working (1 replies)
  249. Using R1C1 formula referencing other WB and SH (1 replies)
  250. [SOLVED:] Writing formula at the end of selection (3 replies)