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:] How to insert rows in sheet1 based on sequence number. (4 replies)
  2. [SOLVED:] Insert after (7 replies)
  3. [SOLVED:] Adding Number into the generated Report (7 replies)
  4. How to sort invocied by column based on sequence number provided in another sheet (3 replies)
  5. Output Unique Data To An Array VBA (3 replies)
  6. Problem solved? HLOOKUP/VLOOKUP question. (3 replies)
  7. [SOLVED:] Command execution VBA (3 replies)
  8. Customer-Data Tally work sheet Update Using VBA (17 replies)
  9. Maximum x-axis value of chart couldn't fit into the image control of userform (0 replies)
  10. mousemove(drag and drop) for spreadsheet on vba userform (2 replies)
  11. Cannot Insert Image into Mac Excel 2011 UserForm (0 replies)
  12. Send Keystrokes Without Interrupting The User?? - There has to be a way (3 replies)
  13. [SOLVED:] Date keeps returning time, don't understand why (7 replies)
  14. [SOLVED:] VBA to lock specific rows when a worksheet opens (3 replies)
  15. [SOLVED:] append several sheets to a 'Results' sheet (4 replies)
  16. Dynamic Named Range used on multiple sheets (8 replies)
  17. Query Connections on a Mac (0 replies)
  18. Excel VBA for ammending outlook Signature template (1 replies)
  19. Need Help with Macro (3 replies)
  20. [SOLVED:] Multiple Criteria Duplicates (4 replies)
  21. AppActivate does not work (6 replies)
  22. Late Binding VBIDE (2 replies)
  23. text to number (3 replies)
  24. Can some one help on Saving multiple excel files from one excel data file (1 replies)
  25. (Bit Rusty, Need Help) Copy & Paste for Adjustable Cell Range (Horizontal to Stacked) (1 replies)
  26. Need VBA coding help for status bar and screenupdating (2 replies)
  27. How to Skip a column for every 2 columns while Paste the values? (1 replies)
  28. [SOLVED:] If variable 1 = 'this' then make variable 2 = 'that' (5 replies)
  29. [SOLVED:] How to get Tab-index from user form in ascending order (12 replies)
  30. [SOLVED:] Unqualified Error (7 replies)
  31. To Sum all columns to right (5 replies)
  32. [SOLVED:] VBA to populate a multicolumn listBox using Additem (4 replies)
  33. [SOLVED:] VBA Query to filter #N/A (2 replies)
  34. [SOLVED:] Printing only non-blank rows (0 replies)
  35. Move / copy to relevant cell matched with sheet name VBA excel 2010 (0 replies)
  36. [SOLVED:] Increase Target.Value By Percentage (2 replies)
  37. Sleeper: Creating Row and Column headers based on a formula and filling with formulas (0 replies)
  38. word doc with multiple tables to master excel spreadsheet (5 replies)
  39. Pick specific portions and make new lines (20 replies)
  40. Find particular text in a sentence in a cell and copy to adjacent cell (5 replies)
  41. [SOLVED:] Compare sheets macro (2 replies)
  42. [SOLVED:] Macro to match entries in column A on diff sheets (3 replies)
  43. creating report (5 replies)
  44. Simple macro - loop to write value from column to another cell, then save as PDF (1 replies)
  45. [SOLVED:] Extract unique Values by comparing Master list and copy full row to another sheet (5 replies)
  46. Need Help: Macro that can filter data and plot results on a matrix (0 replies)
  47. [SOLVED:] Copy interior Color to linked Worksheet (1 replies)
  48. Need Help on a macro...kind of desperate! (3 replies)
  49. Excel 2007 Code (9 replies)
  50. vlookup on an array (4 replies)
  51. [SOLVED:] VBA code that Unhides sheets that are hidden using sht.Visible = xlSheetVeryHidden (13 replies)
  52. [SOLVED:] Cells blocked with permission to change II (block full range) (9 replies)
  53. Need help seperating files (4 replies)
  54. VBA syntax error (2 replies)
  55. Find all values with curly brackets (6 replies)
  56. Help need to fix code (2 replies)
  57. Error: You must rely on system font, Adobe 10, windows 7, Office 2010 (4 replies)
  58. [SOLVED:] Change cell color based on text (4 replies)
  59. Automatic Deleting complete excel sheet in 2 years (2 replies)
  60. Clean the Cells if cell does not start with ( (2 replies)
  61. [SOLVED:] Worksheet change help please (2 replies)
  62. Select last cell with the data in the column/range of cells - only visible datas (1 replies)
  63. One Checkbox to uncheck/disable all others in group (3 replies)
  64. Minor Flaw - Help and understanding required if possible (2 replies)
  65. [SOLVED:] Extract data between brackets (7 replies)
  66. [SOLVED:] Adding Page breaks every ninth row (6 replies)
  67. Analysing a Word Documents headings and write it in an array (3 replies)
  68. [SOLVED:] VBA macro help to find index match error (9 replies)
  69. Rename Picture to Value in a Cell & Copy to Worksheet (4 replies)
  70. [SOLVED:] propertrim() and lower() functions, manipulating ranges of cells (2 replies)
  71. [SOLVED:] Interactive userform please help (18 replies)
  72. [SOLVED:] deleting old ws (cycling sheets) (1 replies)
  73. [SOLVED:] vba module not reading the IF Statement (1 replies)
  74. Get data from HTML files (7 replies)
  75. [SOLVED:] Copy multiple cells on the same worksheet after a search (1 replies)
  76. Buttons often expand to fill the worksheet. Button Bug (3 replies)
  77. Automate Report (2 replies)
  78. [SOLVED:] Conditional Formating (modify) (2 replies)
  79. [SOLVED:] VBA Formual not working (1 replies)
  80. Using R1C1 formula referencing other WB and SH (1 replies)
  81. [SOLVED:] Writing formula at the end of selection (3 replies)
  82. Search folder -> find excel in folder and copy data (3 replies)
  83. [SOLVED:] if find less that six numeric value clean the cell (2 replies)
  84. Workbook Not Saving (4 replies)
  85. [VBA] Changing to directory with variable that was read from a text file (5 replies)
  86. [SOLVED:] Find and copare value afte fill cell (2 replies)
  87. [SOLVED:] How to automatically rotate through task (3 replies)
  88. How to grab particular data and output data? (4 replies)
  89. vba macro splitting string/text (7 replies)
  90. Create a combobox (1 replies)
  91. Protect Range of columns (3 replies)
  92. [SOLVED:] Alert/Message Box (8 replies)
  93. [SOLVED:] Insert row and paste data into (modify code) (4 replies)
  94. [SOLVED:] Sorting Simplification Problem (7 replies)
  95. [SOLVED:] Problem wih logical es formula (2 replies)
  96. [SOLVED:] Difference between carriage return and linefeed? (2 replies)
  97. Worksheet sheetchange -out of stack (6 replies)
  98. [SOLVED:] Consolidate two reports based on multiple criteria (0 replies)
  99. Runtime error 1004 - paste method of worksheet class failed (5 replies)
  100. Organizing Data with many categories (4 replies)
  101. Not Saving (3 replies)
  102. Choosing ranges/cells between sheets! (5 replies)
  103. VBA codes find multiple data using multiple criteria (0 replies)
  104. [SOLVED:] Surveys in Excel! (3 replies)
  105. Right click on the tab: Enable (7 replies)
  106. Open and close multiple workbooks - out of memory (3 replies)
  107. Select Column with VBA and come up 3 rows from bottom (1 replies)
  108. Sleeper: Nested if VBA (16 replies)
  109. Filtering by InputBox date entries and using Autofilter with 3 criteria (3 replies)
  110. Copying data down the column til then "nth" row (2 replies)
  111. How can I speedUP my events based procedure? (6 replies)
  112. [SOLVED:] Change the range to all data range in column (2 replies)
  113. [SOLVED:] go to worksheet depending on Cell value (6 replies)
  114. Dependent (conditional) combo box without creating UserForm (2 replies)
  115. Open file from FTP: "Excel cannot access" error (8 replies)
  116. Count if - cell color index & cell value (range of value) (5 replies)
  117. excel vba to sum textbox values inside a userform frame (7 replies)
  118. #Click in Botton of Web Site whith VBA Excel 2007 (5 replies)
  119. I Need Help Vba Code Disable Key F12 (5 replies)
  120. length of a minimum of a range defined by a variable (1 replies)
  121. External reference help (1 replies)
  122. [SOLVED:] Formula to calculate how many circles fit in a larger circle (2 replies)
  123. inserting a pdf as ole object into word doc from excel (4 replies)
  124. onAction refreshing ribbon macro (3 replies)
  125. using pointer in VBA (4 replies)
  126. Excel and Word (0 replies)
  127. Read Only Files (8 replies)
  128. Save image from computer to worksheet via userform (1 replies)
  129. [SOLVED:] Beginner's attempt at VBA!! Not sure what is going on!! (6 replies)
  130. Macro which copy cells if other cell have specific value (1 replies)
  131. Need macro to check data from workbook to another workbook (5 replies)
  132. dual search criteria over two ranges (ie column) (1 replies)
  133. Need macro to update cell that linked to another program (1 replies)
  134. How to disable Clipboard Section (Cut, Copy, Paste) under Home Tab - Excel 2007 (2 replies)
  135. marco in Excel - loop probably (2 replies)
  136. IE automation - tricky - how to give the script a file path then click OK ? (1 replies)
  137. Application-defined or Object-defined error (4 replies)
  138. Excel 2010 VBA and Speech Recognition... (1 replies)
  139. Protect spesific columns from deleting (2 replies)
  140. How to move column?moving is possible,if so will it affect formulas? (15 replies)
  141. VBA to copy worksheet and insert at the end all worksheets (1 replies)
  142. defining a range as a string (3 replies)
  143. Workbook.Open Opens a Dialogue Box Instead of the Specified file (3 replies)
  144. fixe through the win7 date windows and get information by retrun,!!! (1 replies)
  145. Refresh ribbon with code (3 replies)
  146. How to make the values in larger font for the cells with datavalidation? (12 replies)
  147. Variable column reference for a formula (3 replies)
  148. [SOLVED:] searching a range alphabetically (3 replies)
  149. [SOLVED:] *variable* in .AutoFilter Criteria (4 replies)
  150. Adding attachment to the lotus notes via evcel VBA (3 replies)
  151. Kick off macro when a cell is double clicked? (5 replies)
  152. [SOLVED:] initialize all DTPicker same CustomFormat in UserForm (11 replies)
  153. IF function (4 replies)
  154. [SOLVED:] macro in excel (36 replies)
  155. [SOLVED:] Macro that copies data and format Worksheet to worksheet (4 replies)
  156. Insert Image to Specific Page using APPWD (3 replies)
  157. Chart color palette sync issue (9 replies)
  158. Code That Works on PC but not Mac (4 replies)
  159. how to set function( input range )and (array output)!! (2 replies)
  160. Please help - pivot drilldown macro (3 replies)
  161. Vlookup from external file (3 replies)
  162. [SOLVED:] Two macro button but in a double action (33 replies)
  163. [SOLVED:] Filter data to pages based on number format (2 replies)
  164. How can I see the code used on another form? (6 replies)
  165. [SOLVED:] exporting chart as image on a mac (1 replies)
  166. Trying to create Submit button that will attach the form created in Excel via Lotus (2 replies)
  167. [SOLVED:] VLookup Formula (7 replies)
  168. Compare two sentences and highlight in different color (17 replies)
  169. [SOLVED:] Change VBA from AutoFill to FillDown (4 replies)
  170. What method do I use? (4 replies)
  171. [SOLVED:] Dynamic hyperlinks? (1 replies)
  172. [SOLVED:] Run Crystal Report from Excel VBA (3 replies)
  173. [SOLVED:] Unprotect a merged cell (2 replies)
  174. [SOLVED:] SQL Syntax help (2 replies)
  175. Extracting a number from text using a vba function (4 replies)
  176. Macro that updates a workbook using an old workbook (1 replies)
  177. How to Convert XML text intoe Array (5 replies)
  178. skip zeros for chart range (2 replies)
  179. Select picture shapes (7 replies)
  180. Extra lines at the botom of notepad when opening CSV (5 replies)
  181. [SOLVED:] PLEASE HELP ME WITH MONTHVIEW (2 replies)
  182. The specified Dimension is not valid for the current chart type (9 replies)
  183. [SOLVED:] Update Cell Based Off TickBox Value (4 replies)
  184. Merge multiple workbooks with multiple worksheets into one (4 replies)
  185. Relative selecting to the right (or left)? (3 replies)
  186. positioning charts (1 replies)
  187. Macro that Splits columns and creates .txt files with the data (5 replies)
  188. Generating sheets using several templates (9 replies)
  189. [SOLVED:] Turning part of substring into capital for text data (3 replies)
  190. [SOLVED:] Trouble getting word docs to print from Excel VBA (7 replies)
  191. Copy cells from open or closed workbook (2 replies)
  192. Pull Data from a closed/open excel workbook (3 replies)
  193. IF STATEMENT (7 replies)
  194. Print to txt file (10 replies)
  195. Gaining Familiarity with VBA (2 replies)
  196. [SOLVED:] VBA Code - Set up condition to an Option Button (7 replies)
  197. help me with a webbrowser control please (1 replies)
  198. Get Data From Web Page (14 replies)
  199. [SOLVED:] Automatically saving workbook containing macros as a macro-free workbook (10 replies)
  200. [SOLVED:] where are these two excel workbooks coming from (6 replies)
  201. How to split table into multiple worksheets based on one column and change its format (0 replies)
  202. Selecting values from different rows in a table and merge them in order in one row (1 replies)
  203. Replace unicode charachters in a text file (6 replies)
  204. unique records to Main worksheet in Excel VBA (5 replies)
  205. [SOLVED:] Format Current Selection as a Table (1 replies)
  206. [SOLVED:] Macro to Take a Worksheet from One workbook and Move it to Another (5 replies)
  207. [SOLVED:] VBA to insert column and write concatenation formula (2 replies)
  208. Colour Cell background based on cell values (9 replies)
  209. Find or Match with alphanumeric fields? (6 replies)
  210. Make conditional formatting (font color, number format) static (7 replies)
  211. Break/remove link (5 replies)
  212. Lock changes to Pivot Table Rules (7 replies)
  213. How to find a string in excel VBA (3 replies)
  214. Subtotal in VBA with counta function (1 replies)
  215. Find Values in Different Columns and Figure out where to place the values (0 replies)
  216. Dates and Filters (19 replies)
  217. For Each Loop Not Working (5 replies)
  218. [SLEEPER:] Unable to call Java web service via excel 2010 (0 replies)
  219. [SOLVED:] Match Criteria on two Sheets and see if the Conditions are met (2 replies)
  220. [SOLVED:] Conditional formatting (8 replies)
  221. selecting ranges (1 replies)
  222. Shuffle Array VBA (6 replies)
  223. [SOLVED:] EXCEL FILE NOT SAVING IN VBS (3 replies)
  224. Find indices of value and return entire rows of these indices (3 replies)
  225. [SOLVED:] Crossovers (17 replies)
  226. [SOLVED:] Formula Assistance Desperately Required (4 replies)
  227. [SOLVED:] Expiry date (2 replies)
  228. Copy filtered records and paste another worksheet in Excel VBA (0 replies)
  229. [SOLVED:] VBA Sum Records Which Match Monthly Column Heading (9 replies)
  230. Press ENTER instead of clicking on the button (1 replies)
  231. VBA Code - Data from Access to excel (3 replies)
  232. [SOLVED:] Clean the row if column F does not contain UDS or EUR (5 replies)
  233. dynamically inserting bars into a chart (0 replies)
  234. [SOLVED:] Check Column N and if empty clean data on columns M,L,K (6 replies)
  235. Delete Characters in a string (6 replies)
  236. [SOLVED:] Copy paste help needed in macro (2 replies)
  237. follow hyperlink change file location (6 replies)
  238. Replace content of column (2 replies)
  239. Combine Workbook_different worksheet(same Name) in one master workbook (3 replies)
  240. Cell values based on dropdownlist selection (5 replies)
  241. [SOLVED:] Checkbox - linked cells (7 replies)
  242. Loop to set 250 strings to cell contents (5 replies)
  243. [SOLVED:] do until loop with if statement that applies on different columns (vba) (8 replies)
  244. If Statement ComboBox Value (5 replies)
  245. Delete then restore all data tables in a workbook - fix for Excel 2010? (4 replies)
  246. [SOLVED:] if sheet 9 exists, clear it otherwise create one (15 replies)
  247. [SOLVED:] Find value of cell after filtering (6 replies)
  248. [SOLVED:] Find and Replace in csv Files (13 replies)
  249. [SOLVED:] Macro that finds a semicolon, then copies and inserts rows, and removes some data (2 replies)
  250. Need your help! (1 replies)