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:] Copy PDF (6 replies)
  2. [SOLVED:] help with cell values -if same then mark as "duplicate" (19 replies)
  3. combine 2 macro code in to one so that i can use it in single sheet....its urgentttt (3 replies)
  4. How to Trigger an event (9 replies)
  5. Not VBA, but a IF & AND problem (3 replies)
  6. Call Outlook Macro form Excel (1 replies)
  7. Script isn't copying all values in the criteria correctly and need help displaying (21 replies)
  8. How to create multiple buttons in excel linking to each row (1 replies)
  9. VBA - phrase search and filtering (1 replies)
  10. AutoSum >40 (6 replies)
  11. Modifying This Macro Slightly Please (1 replies)
  12. Display all matching values in one comma separated cell (2 replies)
  13. CountIFs based on Data Validation boxes (1 replies)
  14. Select or Filte Row Based on Single Cell Colour? (6 replies)
  15. [SOLVED:] VBA Create Sheets & Copy Data (27 replies)
  16. [SOLVED:] Return Multiple Values based on Lookup Value (3 replies)
  17. Search Folder looking for File Tags (2 replies)
  18. [SOLVED:] Saving Symbols as a variable (4 replies)
  19. How to copy past only the cell marked in red (45 replies)
  20. VBA for multi-colored pivot chart bars? (2 replies)
  21. [SOLVED:] Populate form label with cell value (3 replies)
  22. [SOLVED:] Row count +1 on data import (4 replies)
  23. [SOLVED:] Look for #N/A sign then copy paste (2 replies)
  24. [SOLVED:] Display search terms in another cell (14 replies)
  25. Need help with VBA find match (2 replies)
  26. Worksheetfunction.countifs not working (1 replies)
  27. MOving and Sorting Data Marco from master sheet (6 replies)
  28. Search Excel file (3 replies)
  29. Copy fields from active task to active worksheet (3 replies)
  30. Categorising data by time (7 replies)
  31. macro causes Excel to 'crash' (6 replies)
  32. Sort by second column in listbox (4 replies)
  33. Send Email Via Excel and store a copy in Excel (7 replies)
  34. [SOLVED:] Rows to Column (Transpose) with one Heading (2 replies)
  35. macro code working for 1 file but not when trying to apply for the range of files (7 replies)
  36. [SOLVED:] VBA Create Sheets and Add Formula To Each Cell In Range (3 replies)
  37. [SLEEPER:] Perdictive Pattern matching algorithm (6 replies)
  38. VBA problem with alternative to index match formula (4 replies)
  39. Grouping with Regular expressions in EXCEL 2010 VBA (5 replies)
  40. [SOLVED:] Need to combined 87 xlsx worksheets into 1 & append source filename to each record (13 replies)
  41. [SLEEPER:] VBA code for distributing available stock (4 replies)
  42. [SOLVED:] Add value to existing named range via inout box (1 replies)
  43. Call macro by typing "Enter" (7 replies)
  44. Return combinations of the most popular choices (25 replies)
  45. [SOLVED:] excel VBA - Listbox only populating one result! (3 replies)
  46. [SOLVED:] Detecting "Protected View" (3 replies)
  47. VBA code to sort a sheet (3 replies)
  48. [SOLVED:] Load a Multidimensional array (6 replies)
  49. select and replace cell (3 replies)
  50. combo box error (4 replies)
  51. How to Arrange telephone directory ocr image in excel, in table form (3 replies)
  52. Formula for a table which does not exist (7 replies)
  53. OPEN: Excel Macro Save As with a new file name (5 replies)
  54. [SOLVED:] Supply one password to unlock all code in workbook (9 replies)
  55. [SOLVED:] Excel Save Error (12 replies)
  56. [SOLVED:] Selecting and deleting rows based on criteria (62 replies)
  57. [SOLVED:] #REF! (2 replies)
  58. Print sheet after update shapes/images (1 replies)
  59. Arranging data datewise (3 replies)
  60. Screen capture (print screen) to new Excel workbook or Word (11 replies)
  61. [SOLVED:] Trying to check if a checkbox is checked (3 replies)
  62. [SOLVED:] Objects and invalid use of property (2 replies)
  63. Importing Images Into Excel 2013 (8 replies)
  64. [SOLVED:] VBA: Mixing Relative & Absolute References (6 replies)
  65. SAS add in Advanced VBA question (6 replies)
  66. [SOLVED:] create a new checkbox and assign its ID? (2 replies)
  67. Copying part of a Text String of different lengths (16 replies)
  68. add individual rows to outlook calender with button (5 replies)
  69. [SOLVED:] Method Intersect Error (3 replies)
  70. Macro has working very slowly; How to speed up this macro. (2 replies)
  71. [SOLVED:] Macro to Consolidate multiple workbooks into new workbook based on criteria (3 replies)
  72. [SOLVED:] Deleting positive values in 45,000 row database (9 replies)
  73. Finding First Value that Falls in a Range Across Multiple Columns (4 replies)
  74. Changing the value of a pivot item (3 replies)
  75. [SOLVED:] Change 'Entire Row delete' to 'cells in columns A-G' (3 replies)
  76. Based on Condition Merge and CountIF & Apply (0 replies)
  77. [SOLVED:] Loop through a dynamic range and apply code in a seperate sheet (5 replies)
  78. Macro to copy data from different cells and paste in new sheet (5 replies)
  79. Text populate containing more records based on date (6 replies)
  80. [SOLVED:] One sub Button Two Macros (6 replies)
  81. how do I work with objects (pass objects to objects?) (5 replies)
  82. Creating New File Off Template and then some EXCEL MACROS (3 replies)
  83. [SOLVED:] Need help to calculate average of those cells between two blank cells (4 replies)
  84. 400 Error (1 replies)
  85. [SOLVED:] I am Having a challenge with ThisWorkbook.Close (29 replies)
  86. xml download "argument not optional" (2 replies)
  87. [SOLVED:] Cannot get xlSaveDialogAs or GetSaveAsFilename to work as required (15 replies)
  88. compare 2 sheet and all column if find duplicate will delete on sheet 2 (2 replies)
  89. [SOLVED:] When running a macro, Excel suddenly stops responding (5 replies)
  90. [SOLVED:] if find the matched data in another work workbook copy the complete row (1 replies)
  91. [SOLVED:] clean a row if it doesn't start with a number except _ (3 replies)
  92. [SOLVED:] When does a Workbook become a member of the WorkBooks Collection? (11 replies)
  93. [SOLVED:] Convert Cell Value in a range of cells (12 replies)
  94. Sleeper: Look up & return (7 replies)
  95. [SOLVED:] Linking/merging two worksheet_change functions (4 replies)
  96. [SOLVED:] Create a Loop - Help! (9 replies)
  97. [SOLVED:] Referencing a Userform in a module (4 replies)
  98. Excel CalCulation Issue (7 replies)
  99. Ribbon Change which works as an ADD-IN (1 replies)
  100. [SOLVED:] Conditional Compilation Quick Question (Well, at least hopefully) (17 replies)
  101. Find a unique value with a condition across 2 lists, add it to the less complete list (1 replies)
  102. Function isn't working on button click (10 replies)
  103. [SOLVED:] help needed to adjust a macro (4 replies)
  104. Who has ever met this? (5 replies)
  105. [SOLVED:] Find Method w/ VALUE error (19 replies)
  106. Input Box is popping too much. (2 replies)
  107. [SOLVED:] Get an automatic sequence in a formula (2 replies)
  108. VBA Conditional formatting if one cell equals another cell in value (3 replies)
  109. Requesting a macro for printing an Excel sheet automatically as PDF on daily basis. (1 replies)
  110. New to VBA. Getting a Compile Error. Please help. (4 replies)
  111. [SOLVED:] Problem Word Wrapping VBE Code (3 replies)
  112. Unlocking all Excel (2007) cells by default (2 replies)
  113. Automatically generating custom timeline on separate tab (Excel 2010) (6 replies)
  114. [SOLVED:] Moving automatically generated page breaks (2 replies)
  115. [SOLVED:] List all Open Window titles in column A (4 replies)
  116. How to use vlookup and countif together in one formula? (9 replies)
  117. extract data from txt file (9 replies)
  118. HELP - Copy Variable Sheet Range from multiple sheets to Summary Sheet (2 replies)
  119. [SOLVED:] Strange behaviour ListBox.Selected(index). (31 replies)
  120. If no error, write the word "ok" to a cell? (3 replies)
  121. [SOLVED:] Use Contents of ComboBox in Vlookup and Save to Data Table (4 replies)
  122. VBA Code to change Color in range of Cells. (3 replies)
  123. Best Tutorials / Courses / Reading to Master Excel (3 replies)
  124. Web Query refresh issue (0 replies)
  125. Compare 2 sheet and paste the resault on sheet3 (6 replies)
  126. [SOLVED:] hrefs from an ordered list <ol> on a webpage in Internet Explorer (3 replies)
  127. [SOLVED:] Lookup value in table with two criteria in rows (10 replies)
  128. Paste data from word table into excel sheet while skipping hidden columns (8 replies)
  129. [SOLVED:] Macro works in Excel 2003 but not in Excel 2007/2010 (2 replies)
  130. Excel VBA with Pivot Table (15 replies)
  131. Why a variable of type Range does not accept Nothing when cutting range of cells? (24 replies)
  132. macro to lookup record on current row and mark completion date to corresponding recor (8 replies)
  133. Import External Data (0 replies)
  134. Free Standing Alternatives to Excel Database (13 replies)
  135. Help with "Array fuctioons" (5 replies)
  136. VBA userform - decimal separator (5 replies)
  137. Unique Rank Question (2 replies)
  138. [SOLVED:] CDATA with values from the active worksheet (2 replies)
  139. [SOLVED:] VBA code works in office 2007 not in office 2010(embeds an attachment in excel) (25 replies)
  140. [SOLVED:] Problem with move more thab 65536 (8 replies)
  141. [SOLVED:] Weird Cell formatting (10 replies)
  142. [SOLVED:] Special Characters (6 replies)
  143. [SOLVED:] Copy to the latest blank row (2 replies)
  144. How to create a formula for a drop down list?? (2 replies)
  145. VBA chess game, userform (19 replies)
  146. [SOLVED:] Intersect - very basic problem (2 replies)
  147. [SOLVED:] VBA IF functions (Help) (10 replies)
  148. [SOLVED:] Change Row Color based on Cell String Match (7 replies)
  149. [SOLVED:] Where To Put Code (12 replies)
  150. Need help creating a loop macro that spits out a master data file (12 replies)
  151. [SOLVED:] Merging Duplicate in Column A (4 replies)
  152. [SOLVED:] Similarly named textboxes - loop (5 replies)
  153. Monitor Folder code goes into a loop (24 replies)
  154. Open an email Lotus notes and copy the content to excel (7 replies)
  155. Need Help on : Application.Filesearch (2 replies)
  156. [SOLVED:] Comparing lists of values, & adding unique values to the 1st blank cells of a range (5 replies)
  157. [SOLVED:] add header/footer to new word document from excel (3 replies)
  158. Sleeper: Tricky For Loop Code (4 replies)
  159. Comunicate between 2 userforms (3 replies)
  160. VBA LOOP Macro (13 replies)
  161. [SOLVED:] Delete duplicates (based on the same line multiple columns) (13 replies)
  162. I Need Vba Code Copy Of Cell And Paste To Other Cell (11 replies)
  163. COPY AND PASTE VALUE - CELLS WITH SPECIFIC VALUES USING A MACRO (8 replies)
  164. Get list<T> from c# dll and access to its items (1 replies)
  165. [SLEEPER:] Resize userform VBA (8 replies)
  166. [SOLVED:] need help with counting sheets with specific names plus adding sheets after them (6 replies)
  167. [SOLVED:] Inaccurate results from formula (3 replies)
  168. [SOLVED:] StopWatch or Timer Class Module (2 replies)
  169. Excel - Use Dropdown menu populate a column (3 replies)
  170. Automate calculation using First in First Out way (13 replies)
  171. [SOLVED:] Using VBA With OOo (2 replies)
  172. [SOLVED:] Have I got the wrong documentation? (3 replies)
  173. Replacing text with a image (4 replies)
  174. [SOLVED:] Count textbox values greater than 0 (2 replies)
  175. [SOLVED:] How make defined range move upon sort? (15 replies)
  176. Randomly Select 4 Column Ranges and Copy and Paste to Another Worksheet (17 replies)
  177. compare columns of two workbooks and add to master workbook (23 replies)
  178. [SOLVED:] Multiselect Listbox Help (15 replies)
  179. [SOLVED:] Saving Files As Read-Only (0 replies)
  180. [SOLVED:] Macro exits sub after calling macro from another workbook (Application.Run) (9 replies)
  181. [SOLVED:] Applying icon to commad BAR not button (user defined add in) (5 replies)
  182. Macro for drop down menu based message box (4 replies)
  183. Macro for drop down menu based message box (1 replies)
  184. [SOLVED:] InStr exact match (5 replies)
  185. Sorting GPS marks (42 replies)
  186. [SOLVED:] Find VBA Multiple criterias (17 replies)
  187. if Dependent is not on the same sheet, then the cell will be given red colour (9 replies)
  188. Advanced Formula (2 replies)
  189. Slow (1 replies)
  190. Userform in VBA and DATEDIFF function (8 replies)
  191. [SOLVED:] Using excel to connect to ERP SOAP webservice (10 replies)
  192. dynamic range lookup (1 replies)
  193. [SOLVED:] Separating Names From this dynamic list and summing them into Preset Cells VBA Excel (4 replies)
  194. [SOLVED:] Inserting a new Column (2 replies)
  195. Copying data from another Workbook row wise (1 replies)
  196. [SOLVED:] Looping through shapes by Name VBA Excel (12 replies)
  197. lookup word then apply formula (1 replies)
  198. [SOLVED:] Issue recording Pivot tables (3 replies)
  199. Importing Data From Web Page (4 replies)
  200. Force Macros Enabled And Close When Idle (6 replies)
  201. [SOLVED:] Naming A Shape and Connector Line After Its Creation"runtime" Excel VBA (2 replies)
  202. Using Excel to Connect to Oracle (5 replies)
  203. Changing font on certain letters (7 replies)
  204. [SLEEPER:] .xml to excel conversion using vba (1 replies)
  205. On change event issues (1 replies)
  206. Choose Sheet AddIn (1 replies)
  207. Excel 2013: First Sheet and Last Sheet (3 replies)
  208. [SOLVED:] Show a message only once, using Application.OnTime (2 replies)
  209. [SOLVED:] Subtotal multiple blocks of data (2 replies)
  210. Hyperlinking (1 replies)
  211. INFINITE LOOP PROBLEM!!! (6 replies)
  212. Import Word document file name into Excel (9 replies)
  213. Randomize/shuffle a list of names (8 replies)
  214. Macros with buttons, spin buttons, scroll buttons, etc. (4 replies)
  215. Guidance on VBA Rota/Scheduler procedure/algorithm (1 replies)
  216. How to grab data from the site? (0 replies)
  217. [SOLVED:] Macro deletes text only in No Fill cells (8 replies)
  218. Excel 2013 erro 13 message (5 replies)
  219. [SOLVED:] To enter one space after single digit (6 replies)
  220. Dynamic Dependent ActiveX Dropdown from Column Data (1 replies)
  221. Cube Values Timing Out When Batch Printing PDFs (6 replies)
  222. [SOLVED:] Variable reference cell value (7 replies)
  223. Referencing multiple userforms (6 replies)
  224. Find Missing VBA Project References Code (10 replies)
  225. [SLEEPER:] Absolutely no help the way this system works (4 replies)
  226. Using Macros to change data in a spreadsheet. (7 replies)
  227. [SOLVED:] How to use user defined function (bucket) (4 replies)
  228. Dowload outlook email attachment to my pc folder (0 replies)
  229. Compare 2 columns and remove matching duplicates in both columns when found (3 replies)
  230. [SOLVED:] Create a List of Pivot Table Report Filter Selections on Worksheet (3 replies)
  231. [SOLVED:] Quality check of data in InputBox (5 replies)
  232. [SLEEPER:] activate an already open workbook or open if not open (5 replies)
  233. Specify Columns for HTML export (5 replies)
  234. Need code to run across an Array of sheets (1 replies)
  235. [SOLVED:] Copy Worksheet with Embedded Chart Object to New Workbook - values and formats only (2 replies)
  236. [SOLVED:] Combobox decides the picture to show (4 replies)
  237. [SOLVED:] Repeat 12 time the data on column A to column B (2 replies)
  238. [SOLVED:] Non-VBA question : Using OR criteria in an IF statement (7 replies)
  239. Array Param Problem with AutoFilter (2 replies)
  240. Auto Copy a website table into excel (2 replies)
  241. [SOLVED:] docking code pane (4 replies)
  242. [SOLVED:] Importing CVS files in to a worksheet (3 replies)
  243. Extract Hyperlinks from Word into Excel (8 replies)
  244. Getting a compile Error, Please help! (1 replies)
  245. [SOLVED:] quick help on using a variable to define a range (5 replies)
  246. RowNext starting from a certain Row (1 replies)
  247. How to make a list of Files and folders of a directory in excel (1 replies)
  248. Add on additional range in Loop (1 replies)
  249. help! i need a good soultion to a project i just got in school (5 replies)
  250. Worksheet Function In VBA (4 replies)