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. Determining if 'End Mode' is on (4 replies)
  2. Solved: Button movement (0 replies)
  3. Trouble creating a macro for multiplying matrices (6 replies)
  4. Need Help Searching Folder/SubFolder, then Copying to different Folder (2 replies)
  5. text format cells be treated as text (1 replies)
  6. Trigger macro when user opening any excel file (3 replies)
  7. Row index and first three characters in VBA (0 replies)
  8. Collation of error. (9 replies)
  9. Macro for CheckBox (3 replies)
  10. Solved: Find cells that contain a string, extract it, then cocatenate to value in Col 15 (27 replies)
  11. PDF Tracker Help! (1 replies)
  12. Solved: Re-arranging Data (2 replies)
  13. Parse data from Excel to IE using VBA (0 replies)
  14. Creating a detailed pivot from an existing master pivot (9 replies)
  15. Reply to Closed Thread! (0 replies)
  16. Delete Rows In A Sheet (8 replies)
  17. Needed help on copying the data from .csv file to another excel sheet (1 replies)
  18. Protect created or saved file as encrypt documents with my user name only (1 replies)
  19. Solved: Befuddled (4 replies)
  20. Solved: Label and textbox on microsoft Forms 2.0 Frame (1 replies)
  21. Solved: Copy Xrows from WrkBk to New WrkBk (3 replies)
  22. File Browse InitialFileName not working on one Excel 2007 machine only (0 replies)
  23. Need help to create a series of covariance matrices in my worksheet (4 replies)
  24. Custom Get Open File Dialog (4 replies)
  25. Checking URL's (1 replies)
  26. updata e graph in ppt with excel data using vba in ppt (0 replies)
  27. UK Date Format not US (5 replies)
  28. Solved: Compare the active row, to row 10 (10 replies)
  29. Sleeper: Compare Column Value copy cell (0 replies)
  30. Solved: Copy Some cells from row 10 depending on which cells are selected in the active row. (2 replies)
  31. Solved: Clear Content of a4:q900 if=0 (2 replies)
  32. Returning Maximized WindowState with QueryClose_ (0 replies)
  33. Need Help using array(i) with user form label (5 replies)
  34. [SOLVED:] Criteria based counting (9 replies)
  35. Solved: Need Help Hiding Columns (2 replies)
  36. Quick Find of most recent date/time without having to sort. (2 replies)
  37. total value of a column in all the sheets to be consolidated in another worksheet (18 replies)
  38. Importing data from XL file has two sheets (0 replies)
  39. VBA Project - Registration process (6 replies)
  40. Solved: copy the first row on sheet to lastest blank row of another Sheet . (13 replies)
  41. Multiply (5 replies)
  42. Append rows to existing workbook in different folder and save in different location (0 replies)
  43. Macro to search for string in multiple worksheets and display results (1 replies)
  44. Delete rows based on dynamic data range (4 replies)
  45. [SOLVED:] Text in a Triangle Drawing Object (2 replies)
  46. Solved: problem with array loop (5 replies)
  47. Solved: Set Font Color of Cell(s) (1 replies)
  48. save combobox list to array (5 replies)
  49. Solved: Spreadsheet not updating when I open it daily? (3 replies)
  50. Solved: Delete Dash on each cell (5 replies)
  51. Solved: Vlookup in other workbooks fail (5 replies)
  52. delete rows that do not contain a defined set (8 replies)
  53. Solved: Insert Delete Rows Help. (2 replies)
  54. Problem on Merging (8 replies)
  55. Solved: Error Message when trying to highlight specific cell (4 replies)
  56. Import Active X fields in word doc to Excel (2 replies)
  57. Gathering data from one book for summary in another (2 replies)
  58. Solved: Merging Duplicate (4 replies)
  59. [SOLVED:] 65536 Row Problem (2 replies)
  60. Problem with UDF (8 replies)
  61. Code Optimisation: Name new sheets from a merge after the filename? (1 replies)
  62. Error 642 in Word Automation and Style that is not applied (2 replies)
  63. Anyone see the compile error? (1 replies)
  64. Search another spreadsheet to populate userform (3 replies)
  65. is there an opposite of 'selectedsheets' (5 replies)
  66. VBA Basics - automating the process of running commands down thousands of rows (6 replies)
  67. Solved: if its not broke... recreate it, using userforms (14 replies)
  68. Solved: How to comparing two columns (14 replies)
  69. compare few columns of data (0 replies)
  70. Excel Wont Open Full Screen (1 replies)
  71. Conditional Formatting in VBA (6 replies)
  72. Solved: VBA Coding Question (2 replies)
  73. How can I formate the date in a text box on a user form. (4 replies)
  74. Solved: what are these filter things called and how do you add them (5 replies)
  75. highlight Cell (2 replies)
  76. Updating my CSV File (4 replies)
  77. External Links issue (0 replies)
  78. Solved: Modifying code to select specific data (4 replies)
  79. [SOLVED:] For Loop help (2 replies)
  80. request formula (10 replies)
  81. Create multiple workbooks (2 replies)
  82. link two workbooks (5 replies)
  83. matching with a particular error (6 replies)
  84. Solved: only partly activity in Evene_Change (2 replies)
  85. TAB Order Workbook on KB (2 replies)
  86. Solved: Export a column to text file of certain name (7 replies)
  87. txt to xls excel macro help (1 replies)
  88. Solved: Error on VBA Code in 600000 Row (12 replies)
  89. Solved: Emailing by broker (12 replies)
  90. 255 Character Limit when copying worksheet (1 replies)
  91. Solved: macro doesn't work anymore (7 replies)
  92. How to automatically create excel templates and send via email (1 replies)
  93. Solved: Calculate the cell type that value to calculate (11 replies)
  94. [SOLVED:] Counter in Range (9 replies)
  95. move rows to another worksheet (2 replies)
  96. Solved: nasted if/sumproduct help (10 replies)
  97. PDF into Exce. KB doc (5 replies)
  98. Split a cell into multiple cells (11 replies)
  99. Excel add-in problem, workbook. (4 replies)
  100. Solved: Inserting new rows (13 replies)
  101. Solved: sumif/countif for 'older' (11 replies)
  102. Bi-Monthly date calculation and results as the column header (0 replies)
  103. Macro to Paste Cells when Column A=0 (1 replies)
  104. For/Next and custom formatting (4 replies)
  105. VBA Form Opt. buttons scoring (3 replies)
  106. Solved: Why am I getting an error? (5 replies)
  107. Excel 2007 - export data from Excel to Word 2007 (0 replies)
  108. vba to find data in excel (2 replies)
  109. prevent your from changing filter (3 replies)
  110. Autofiltered values to a new sheet (4 replies)
  111. Vba send outlook email (1 replies)
  112. Question about Sort Events (2 replies)
  113. Solved: VBA and Email (17 replies)
  114. Solved: Change text string (2 replies)
  115. Track changes insert column/row (1 replies)
  116. Help , copy cells with condition (3 replies)
  117. Solved: Set a permanent reference to powerpoint (10 replies)
  118. open cash drawer using USB printer (0 replies)
  119. ms progress bar 6.0 (3 replies)
  120. Calculate a week later and then to fall always on Monday. (8 replies)
  121. Solved: not finding workbook (2 replies)
  122. Need VBA Code rectification (4 replies)
  123. Open external file as administrator (0 replies)
  124. Solved: Filter using dates (4 replies)
  125. Solved: Color on userform (11 replies)
  126. Solved: Invalid cell references generated from macro (4 replies)
  127. newline data entry (2 replies)
  128. Solved: Loop just in activesheet rather than all worksheets (3 replies)
  129. Microsoft Office Excel has encountered a problem and needs to close... (4 replies)
  130. Loop not working (3 replies)
  131. userform search (19 replies)
  132. Date validation in VBA (1 replies)
  133. VBA Web Query (0 replies)
  134. Solved: Combine Formula (7 replies)
  135. Macro to copy and paste in another Worksheet (6 replies)
  136. Excel not picking libraries from where it is instructed to pick from (1 replies)
  137. Reduce the size of macro enable file (7 replies)
  138. control wordpad from Excel using VBA (7 replies)
  139. Need formula to arrange column data into different rows (1 replies)
  140. Solved: 6 month moving tracker (9 replies)
  141. Solved: running dynamic data range from xml workbook into specific worksheet (6 replies)
  142. Solved: VBA to Zip a file (1 replies)
  143. Sleeper: Combine data from several worksheets into one with conditions (5 replies)
  144. Automation of outlook mails based on the excel list (1 replies)
  145. Split the Files based on a Cell Ref - Problem (1 replies)
  146. Use logical OR in ADO parameters (7 replies)
  147. Colour cells using VBA (7 replies)
  148. problem with date formula (3 replies)
  149. Concatenate two columns in a sheet (19 replies)
  150. [SOLVED:] Linear Interpolation (5 replies)
  151. Inserting Row above filtered data (1 replies)
  152. vlookup, find and relace the column headers (4 replies)
  153. Solved: producing multiple records from a list (4 replies)
  154. Update Master File from other workbook (9 replies)
  155. Getting Password Prompt while exiting vba project.. (7 replies)
  156. Pass Range param from custom function (4 replies)
  157. Macro value "Text" linking to input cell value of another sheet (0 replies)
  158. Programme in VBA, help (3 replies)
  159. VBA Internet Explorer Radio Button Help Needed (1 replies)
  160. Insert colums and fill down - Variables (1 replies)
  161. Solved: Explicit Range References Keep Changing (6 replies)
  162. Create macro that inserts variable number of rows into tables (2 replies)
  163. Copy 2 sheet from 1 workbook to another workbook (0 replies)
  164. why cant i see the message box on screen? (34 replies)
  165. Subscript out of range (Error 9) (4 replies)
  166. Create Outlook email to send out (5 replies)
  167. VBA Error when inserting file into Word (4 replies)
  168. Special characters on macros (3 replies)
  169. Solved: code to insert data to cell (8 replies)
  170. Custom filters (1 replies)
  171. Solved: Prep many tabs for new year of data (2 replies)
  172. VBA Prevent Duplicate Entry via Input Box Help (1 replies)
  173. Hyperlinks and Cell references (2 replies)
  174. Create formulas using multiple pop-up input boxes? (6 replies)
  175. Solved: simple If statement help (5 replies)
  176. Solved: AutoRun the script (14 replies)
  177. Solved: Hide Rows under the criteria above (6 replies)
  178. Solved: Convert String? (5 replies)
  179. VBA Script to get Commision Amt (8 replies)
  180. Solved: Question about User Defined Functions (13 replies)
  181. Solved: how to prevent macro name visible to user. (3 replies)
  182. Code need help ... thanks (0 replies)
  183. Solved: Replace part of a formula with its calculated value (7 replies)
  184. Crystal Reports (1 replies)
  185. Solved: Converting Strings to Conditions (3 replies)
  186. Solved: Copy the latest row of sheet A to another sheet (2 replies)
  187. Find and replace text in Powerpoint from Excel (8 replies)
  188. VBA Macro for copy dates in new sheet(s) (3 replies)
  189. Solved: Delete same rows (5 replies)
  190. Return Lowest Value of Row = todays date. (3 replies)
  191. Solved: Delete Column if row is blank (8 replies)
  192. VBA for Outlook (1 replies)
  193. Solved: VBA to select Filter Criteria (3 replies)
  194. String Variable - Compile Error Expected End of Statment (1 replies)
  195. copy data to another sheet (2 replies)
  196. right formula (1 replies)
  197. use vba to copy a chart in excel to ms paint (2 replies)
  198. [SOLVED:] Formulas and Conditional Formatting (2 replies)
  199. Solved: VBA EXCEL - Best way to add, divide, subtract and multiply. (10 replies)
  200. Sorting multiple rows in descending order with their respective columns (4 replies)
  201. Solved: Detect when VBA code has finished (7 replies)
  202. Solved: Problem in using Custom Format through VBA (6 replies)
  203. macro not working in 2007 (working in 2010) (3 replies)
  204. Hi guys can you correct my code here? (4 replies)
  205. Hide popup when saving as PDF (6 replies)
  206. Solved: Filtering with DTpicker (5 replies)
  207. Letter Template database in Excel Forms. (0 replies)
  208. Append the values to the master sheet from pivot results (4 replies)
  209. values based on the datetime stamp given by the user (7 replies)
  210. Java Code to VBA (2 replies)
  211. Solved: macro to call "paste special" (2 replies)
  212. use excel vba to input data into MYOB (1 replies)
  213. Solved: Adding Values in VBA but from a dynamic data query (18 replies)
  214. Solved: Row Count / Loop (5 replies)
  215. VBA Concatenate based on another cell value (3 replies)
  216. MSQuery Pass Variable (5 replies)
  217. Emulation question (7 replies)
  218. Solved: Paste Special problem in found solution (5 replies)
  219. Solved: Sort,format to report sheet (2 replies)
  220. Dynamic VBA Generation (7 replies)
  221. Allow cell entry only by shortcut key (12 replies)
  222. Solved: Sort will NOT Sort (5 replies)
  223. Solved: Amend and Move (52 replies)
  224. How can sort Ascending for data in a Cell (1 replies)
  225. Change image when different cell is selected (2 replies)
  226. Change in a cell text, inserts an X in another cell (5 replies)
  227. Solved: Loop is not going through all worksheets (2 replies)
  228. Re-arranging the columns as per columns given in another worsheet (2 replies)
  229. Delete rows (3 replies)
  230. Taking input from another worksheet cell in excel 2007 (1 replies)
  231. [SOLVED:] Identify String or Numeric Value in a Textbox (2 replies)
  232. Need color of source text in concatenated cell (15 replies)
  233. What can be done to "clean" the palette (such as remove cell headers) (1 replies)
  234. Solved: Click a command button to get the name of the previous button clicked (2 replies)
  235. How to paste from module to worksheet (3 replies)
  236. Pivot Table code that worked in 2003 not working with 2010 (5 replies)
  237. sorting into different worksheets (4 replies)
  238. Lock Row on Cell input. (2 replies)
  239. Solved: Problem with Formula (2 replies)
  240. Trouble with 64-bit VBA? (1 replies)
  241. VBA Message box help (6 replies)
  242. Copy and Paste Code (16 replies)
  243. Multiply selection by a variable (2 replies)
  244. Solved: CONDITIONNAL FORMAT OR MACRO (8 replies)
  245. Handling large amount of data in one excel sheet (8 replies)
  246. Internet explorer automation/vba (2 replies)
  247. Solved: Code to lookup values from sheet and automatically enter in another (4 replies)
  248. Date Population (5 replies)
  249. create a new workbook and then move a sheet to there (2 replies)
  250. Changing Sort Options (25 replies)