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. Create multiple workbooks (2 replies)
  2. link two workbooks (5 replies)
  3. matching with a particular error (6 replies)
  4. Solved: only partly activity in Evene_Change (2 replies)
  5. TAB Order Workbook on KB (2 replies)
  6. Solved: Export a column to text file of certain name (7 replies)
  7. txt to xls excel macro help (1 replies)
  8. Solved: Error on VBA Code in 600000 Row (12 replies)
  9. Solved: Emailing by broker (12 replies)
  10. 255 Character Limit when copying worksheet (1 replies)
  11. Solved: macro doesn't work anymore (7 replies)
  12. How to automatically create excel templates and send via email (1 replies)
  13. Solved: Calculate the cell type that value to calculate (11 replies)
  14. [SOLVED:] Counter in Range (9 replies)
  15. move rows to another worksheet (2 replies)
  16. Solved: nasted if/sumproduct help (10 replies)
  17. PDF into Exce. KB doc (5 replies)
  18. Split a cell into multiple cells (11 replies)
  19. Excel add-in problem, workbook. (4 replies)
  20. Solved: Inserting new rows (13 replies)
  21. Solved: sumif/countif for 'older' (11 replies)
  22. Bi-Monthly date calculation and results as the column header (0 replies)
  23. Macro to Paste Cells when Column A=0 (1 replies)
  24. For/Next and custom formatting (4 replies)
  25. VBA Form Opt. buttons scoring (3 replies)
  26. Solved: Why am I getting an error? (5 replies)
  27. Excel 2007 - export data from Excel to Word 2007 (0 replies)
  28. vba to find data in excel (2 replies)
  29. prevent your from changing filter (3 replies)
  30. Autofiltered values to a new sheet (4 replies)
  31. Vba send outlook email (1 replies)
  32. Question about Sort Events (2 replies)
  33. Solved: VBA and Email (17 replies)
  34. Solved: Change text string (2 replies)
  35. Track changes insert column/row (1 replies)
  36. Help , copy cells with condition (3 replies)
  37. Solved: Set a permanent reference to powerpoint (10 replies)
  38. open cash drawer using USB printer (0 replies)
  39. ms progress bar 6.0 (3 replies)
  40. Calculate a week later and then to fall always on Monday. (8 replies)
  41. Solved: not finding workbook (2 replies)
  42. Need VBA Code rectification (4 replies)
  43. Open external file as administrator (0 replies)
  44. Solved: Filter using dates (4 replies)
  45. Solved: Color on userform (11 replies)
  46. Solved: Invalid cell references generated from macro (4 replies)
  47. newline data entry (2 replies)
  48. Solved: Loop just in activesheet rather than all worksheets (3 replies)
  49. Microsoft Office Excel has encountered a problem and needs to close... (4 replies)
  50. Loop not working (3 replies)
  51. userform search (19 replies)
  52. Date validation in VBA (1 replies)
  53. VBA Web Query (0 replies)
  54. [SOLVED:] Combine Formula (6 replies)
  55. Macro to copy and paste in another Worksheet (6 replies)
  56. Excel not picking libraries from where it is instructed to pick from (1 replies)
  57. Reduce the size of macro enable file (7 replies)
  58. [SLEEPER:] control wordpad from Excel using VBA (7 replies)
  59. Need formula to arrange column data into different rows (1 replies)
  60. Solved: 6 month moving tracker (9 replies)
  61. Solved: running dynamic data range from xml workbook into specific worksheet (6 replies)
  62. Solved: VBA to Zip a file (1 replies)
  63. Sleeper: Combine data from several worksheets into one with conditions (5 replies)
  64. Automation of outlook mails based on the excel list (1 replies)
  65. Split the Files based on a Cell Ref - Problem (1 replies)
  66. Use logical OR in ADO parameters (7 replies)
  67. Colour cells using VBA (7 replies)
  68. problem with date formula (3 replies)
  69. Concatenate two columns in a sheet (19 replies)
  70. [SOLVED:] Linear Interpolation (5 replies)
  71. Inserting Row above filtered data (1 replies)
  72. vlookup, find and relace the column headers (4 replies)
  73. Solved: producing multiple records from a list (4 replies)
  74. Update Master File from other workbook (9 replies)
  75. Getting Password Prompt while exiting vba project.. (7 replies)
  76. [SLEEPER:] Pass Range param from custom function (4 replies)
  77. [SLEEPER:] Macro value "Text" linking to input cell value of another sheet (0 replies)
  78. Programme in VBA, help (3 replies)
  79. VBA Internet Explorer Radio Button Help Needed (1 replies)
  80. Insert colums and fill down - Variables (1 replies)
  81. Solved: Explicit Range References Keep Changing (6 replies)
  82. Create macro that inserts variable number of rows into tables (2 replies)
  83. Copy 2 sheet from 1 workbook to another workbook (0 replies)
  84. why cant i see the message box on screen? (34 replies)
  85. Subscript out of range (Error 9) (4 replies)
  86. Create Outlook email to send out (5 replies)
  87. VBA Error when inserting file into Word (4 replies)
  88. Special characters on macros (3 replies)
  89. Solved: code to insert data to cell (8 replies)
  90. Custom filters (1 replies)
  91. Solved: Prep many tabs for new year of data (2 replies)
  92. VBA Prevent Duplicate Entry via Input Box Help (1 replies)
  93. Hyperlinks and Cell references (2 replies)
  94. Create formulas using multiple pop-up input boxes? (6 replies)
  95. Solved: simple If statement help (5 replies)
  96. Solved: AutoRun the script (14 replies)
  97. Solved: Hide Rows under the criteria above (6 replies)
  98. Solved: Convert String? (5 replies)
  99. VBA Script to get Commision Amt (8 replies)
  100. Solved: Question about User Defined Functions (13 replies)
  101. Solved: how to prevent macro name visible to user. (3 replies)
  102. Code need help ... thanks (0 replies)
  103. Solved: Replace part of a formula with its calculated value (7 replies)
  104. Crystal Reports (1 replies)
  105. Solved: Converting Strings to Conditions (3 replies)
  106. Solved: Copy the latest row of sheet A to another sheet (2 replies)
  107. Find and replace text in Powerpoint from Excel (8 replies)
  108. VBA Macro for copy dates in new sheet(s) (3 replies)
  109. Solved: Delete same rows (5 replies)
  110. Return Lowest Value of Row = todays date. (3 replies)
  111. Solved: Delete Column if row is blank (8 replies)
  112. VBA for Outlook (1 replies)
  113. Solved: VBA to select Filter Criteria (3 replies)
  114. String Variable - Compile Error Expected End of Statment (1 replies)
  115. copy data to another sheet (2 replies)
  116. right formula (1 replies)
  117. use vba to copy a chart in excel to ms paint (2 replies)
  118. [SOLVED:] Formulas and Conditional Formatting (2 replies)
  119. Solved: VBA EXCEL - Best way to add, divide, subtract and multiply. (10 replies)
  120. Sorting multiple rows in descending order with their respective columns (4 replies)
  121. Solved: Detect when VBA code has finished (7 replies)
  122. Solved: Problem in using Custom Format through VBA (6 replies)
  123. macro not working in 2007 (working in 2010) (3 replies)
  124. Hi guys can you correct my code here? (4 replies)
  125. Hide popup when saving as PDF (6 replies)
  126. Solved: Filtering with DTpicker (5 replies)
  127. Letter Template database in Excel Forms. (0 replies)
  128. Append the values to the master sheet from pivot results (4 replies)
  129. values based on the datetime stamp given by the user (7 replies)
  130. Java Code to VBA (2 replies)
  131. Solved: macro to call "paste special" (2 replies)
  132. use excel vba to input data into MYOB (1 replies)
  133. Solved: Adding Values in VBA but from a dynamic data query (18 replies)
  134. Solved: Row Count / Loop (5 replies)
  135. VBA Concatenate based on another cell value (3 replies)
  136. MSQuery Pass Variable (5 replies)
  137. Emulation question (7 replies)
  138. Solved: Paste Special problem in found solution (5 replies)
  139. Solved: Sort,format to report sheet (2 replies)
  140. Dynamic VBA Generation (7 replies)
  141. Allow cell entry only by shortcut key (12 replies)
  142. Solved: Sort will NOT Sort (5 replies)
  143. Solved: Amend and Move (52 replies)
  144. How can sort Ascending for data in a Cell (1 replies)
  145. Change image when different cell is selected (2 replies)
  146. Change in a cell text, inserts an X in another cell (5 replies)
  147. Solved: Loop is not going through all worksheets (2 replies)
  148. Re-arranging the columns as per columns given in another worsheet (2 replies)
  149. Delete rows (3 replies)
  150. [SLEEPER:] Taking input from another worksheet cell in excel 2007 (1 replies)
  151. [SOLVED:] Identify String or Numeric Value in a Textbox (2 replies)
  152. Need color of source text in concatenated cell (15 replies)
  153. What can be done to "clean" the palette (such as remove cell headers) (1 replies)
  154. Solved: Click a command button to get the name of the previous button clicked (2 replies)
  155. How to paste from module to worksheet (3 replies)
  156. Pivot Table code that worked in 2003 not working with 2010 (5 replies)
  157. sorting into different worksheets (4 replies)
  158. Lock Row on Cell input. (2 replies)
  159. Solved: Problem with Formula (2 replies)
  160. Trouble with 64-bit VBA? (1 replies)
  161. VBA Message box help (6 replies)
  162. Copy and Paste Code (16 replies)
  163. Multiply selection by a variable (2 replies)
  164. Solved: CONDITIONNAL FORMAT OR MACRO (8 replies)
  165. Handling large amount of data in one excel sheet (8 replies)
  166. Internet explorer automation/vba (2 replies)
  167. Solved: Code to lookup values from sheet and automatically enter in another (4 replies)
  168. Date Population (5 replies)
  169. create a new workbook and then move a sheet to there (2 replies)
  170. Changing Sort Options (25 replies)
  171. Solved: Bulk assignment to VBA arrays (7 replies)
  172. Retrieve the file name if I specify the extension. (2 replies)
  173. Time card workbook - need advice/help please (1 replies)
  174. Solved: Array Problem (7 replies)
  175. Setting Print area (0 replies)
  176. Background (2 replies)
  177. Sum Up Multiple Workbook (1 replies)
  178. sumif vba (8 replies)
  179. create new sheet based on another sheet filter (0 replies)
  180. Stuck with macros (3 replies)
  181. Match "2" values before marked as Duplicate (17 replies)
  182. Solved: Worksheet Change? (3 replies)
  183. Grid of Buttons - Sizing and Positioning (4 replies)
  184. Arrange data sheet wise (2 replies)
  185. [SOLVED:] Format line based on condition (4 replies)
  186. 4 conditional formats based on dates (4 replies)
  187. Solved: Can the Text in a Form Control Button Be Read into VBA? (7 replies)
  188. Make VBA Cell a Formula (3 replies)
  189. Excel to find value and return multi values based on that (2 replies)
  190. Accessing X-Axis in a line graph (1 replies)
  191. Solved: Merge and Delete duplicate in 2 column (4 replies)
  192. Autofill to the last Row (6 replies)
  193. insert the worksheet if the sheet is missing (1 replies)
  194. Help with vba macro (6 replies)
  195. VB Code To Normalize Big Dataset with One Value (3 replies)
  196. VBA code to check if file exixt and if yes than overwrite and no than exit (2 replies)
  197. Solved: Problem with compare and deleting in 3 column (2 replies)
  198. Solved: Context Menu Control ID's (5 replies)
  199. VBA MAcros for Calculation of multi columns (6 replies)
  200. Macro to merge data from 100 worbooks in a folder (3 replies)
  201. don’t want the message box when delete a sheet (2 replies)
  202. [SOLVED:] Loop routine only finds first instance (7 replies)
  203. Solved: if match column A and B move the row to another sheet (2 replies)
  204. Solved: check the A Cloumn and copy to aother sheet (15 replies)
  205. Get Max Value - Compare cloumn with condition (2 replies)
  206. How to stop following start-up message? (5 replies)
  207. Data extraction Automation via VBA (1 replies)
  208. Solved: Identify which Excel version via Code (5 replies)
  209. Bloomberg BDH Formula and VBA (1 replies)
  210. Solved: VBA Conditional Formatting Range (4 replies)
  211. Show calculation progress of a data table (1 replies)
  212. Retrieve Selected Items from Multiselection List as String (2 replies)
  213. VBA Importing all sheet data from a closed excel workbook (0 replies)
  214. Trial period for spreadsheet (1 replies)
  215. How to pass the active workbook to a function, getting subscript out of range error (0 replies)
  216. [SLEEPER:] Search for text in every sheet] (2 replies)
  217. If Sat or Sun, then Monday (4 replies)
  218. plz Help: allow certen sheet to be printed with condition (3 replies)
  219. hiding data using other cells as reference (4 replies)
  220. Solved: 64 Bit Excel (4 replies)
  221. Solved: Method 'Range' of object '_Global' failed (6 replies)
  222. Problem (6 replies)
  223. Solved: vba - detect "+" and "-" keys (4 replies)
  224. Solved: Return result up to a maximum (4 replies)
  225. VBA code for saving csv file to certain path (2 replies)
  226. Macro assigned keys (3 replies)
  227. VBA XML/XSD DOM Method to Retrieve Attribute Restrictions (0 replies)
  228. [SOLVED:] Run-time error '1004' in protected sheet (2 replies)
  229. I need Help (6 replies)
  230. Solved: Retirement Spreadsheet Help (4 replies)
  231. prevent shape flickering (7 replies)
  232. paste from clipboard into active window (10 replies)
  233. Name and Delete Shape (3 replies)
  234. Naming and Deleting Shape (6 replies)
  235. Close multiple workbooks (3 replies)
  236. Automate Filter (1 replies)
  237. Solved: Hyperlinking problem (5 replies)
  238. Solved: Delete plus Trim word (3 replies)
  239. VB Code to Sort by Last Column With Date Not Including Headers (12 replies)
  240. VB Script to display cell dependent references (7 replies)
  241. formula (8 replies)
  242. Unzip the zip folders and rename the .gif files (8 replies)
  243. Reformatting Data Error (1 replies)
  244. Filter Data in Sheet to ListView (5 replies)
  245. F8 keeps running my whole code instead of stepping through it (4 replies)
  246. 3 Inputs, 3 different Sounds (1 replies)
  247. VBA code to count record (1 replies)
  248. URLDownloadToFile (0 replies)
  249. My first request! VBA help (3 replies)
  250. Find active IE tab (8 replies)