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. 3D Lookup - using sumproduct / offset functions? (1 replies)
  2. Solved: Need to sum column totals for month. - My Code seems to be rounding cell values. (3 replies)
  3. Non Excel Application Status (1 replies)
  4. Macro to delete entire Row on Sheet 1 if values found on Sheet 2 matches (14 replies)
  5. Solved: Help Required - Checking formats of cells (2 replies)
  6. Solved: Passing Value back to userform (2 replies)
  7. Pivot table Items (1 replies)
  8. Copy details from the uploaded input file and paste in destination file (0 replies)
  9. GetValue work with UNC? (5 replies)
  10. Open each excel file and then close it. (1 replies)
  11. Differentiate between sources of results on cells (3 replies)
  12. FUNCTION to return values from a closed workbook (10 replies)
  13. Hidden Workbook - Now Cant Get Back! (2 replies)
  14. Print result in different worksheet with different number of rows (3 replies)
  15. Conditional Format question (10 replies)
  16. [SOLVED:] Color Row (2 replies)
  17. Using StringIndexOf to return two values (5 replies)
  18. Programmatically updating VBA macros in old spreadsheets (4 replies)
  19. Solved: Chart Series only use last 4 rows (2 replies)
  20. Solved: Merging a specific worksheet from multiple workbooks into one (21 replies)
  21. write the name of all excel file in a folder in an excel file (1 replies)
  22. Populate UF Listbox then send to Spreadsheet (4 replies)
  23. [SLEEPER:] Condition copy based on list from different sheet (12 replies)
  24. [SOLVED:] Restore Cell colores from saved information (5 replies)
  25. Solved: Unhide last row in auto filtered data (3 replies)
  26. Import CSV file data and export it in sql file (1 replies)
  27. [SLEEPER:] deleting hidden rows or columns that have no data in a specified cell. (2 replies)
  28. Solved: Sum of sales in a Week (3 replies)
  29. DTPicker has gone AWOL ??? (4 replies)
  30. Solved: Formatting Text /Numbers in a Textbox of a Userform (3 replies)
  31. unload userform if greater than certain row (2 replies)
  32. how to store comments in a string? (3 replies)
  33. Assigning Autofilter values to a variable (4 replies)
  34. Solved: Illusive Macro (26 replies)
  35. Cell Identification (9 replies)
  36. Display text on cell selection (7 replies)
  37. Compare the columns in two files and results in a separate column (2 replies)
  38. Email with Glitches (2 replies)
  39. Solved: Correct File Selected (2 replies)
  40. Solved: New to VBA - How do I open WORD? (3 replies)
  41. User form "X" button to call Exit button (2 replies)
  42. Help with a simple Macro (3 replies)
  43. Solved: Playing Embedded Wav File (4 replies)
  44. Solved: Need the Root Directory of Thisworkbook (3 replies)
  45. [SOLVED:] save/paste column (3 replies)
  46. Solved: events problems (2 replies)
  47. Routine cycling data after automatic database sorting (25 replies)
  48. Solved: empty cells not allowed (6 replies)
  49. Help required: segregation of data (4 replies)
  50. Vlookup using VBA (3 replies)
  51. Removing vbcrlf with a macro (1 replies)
  52. VBA code to change font for email (2 replies)
  53. how to pick last -1 value of the column (1 replies)
  54. Solved: Named Ranges (2 replies)
  55. [SLEEPER:] Select and activate ComboBox entry by macro code (3 replies)
  56. count no. of matching data in two excel (4 replies)
  57. VBA code giving error on some system (12 replies)
  58. Excel Vba Code (1 replies)
  59. Delete duplicate merged rows. (8 replies)
  60. reference named range (2 replies)
  61. VBA Excel Copy cells within one sheet (3 replies)
  62. Copy one excel file into another one row at a time (13 replies)
  63. Rectification of VBA script (5 replies)
  64. Solved: macro to import data from text file to excel worksheet (5 replies)
  65. macro problem please help (1 replies)
  66. vlookup (1 replies)
  67. [SLEEPER:] Run time error #13 while macro runs (2 replies)
  68. Get page count of pdf files (11 replies)
  69. Solved: Delete only today comment? (5 replies)
  70. SaveAs on 2 Cell Based (Path) (2 replies)
  71. Solved: Naming inserted pictures (3 replies)
  72. Solved: PrintArea and Pagebreak woes (8 replies)
  73. [SLEEPER:] Import closed workbook - there are lots of methods but which is best? (15 replies)
  74. Create email with filtered data (5 replies)
  75. Problem programming routine for conditional copy/paste (3 replies)
  76. Manipulating Excel cell comments in VBA and with DB Data (2 replies)
  77. Solved: Help Required - Audit Trials using VBA (5 replies)
  78. Tab Order (2 replies)
  79. Solved: Inserting a Specific Date (2 replies)
  80. List ALL Formulas & Conditional Formatting in a WorkBook (10 replies)
  81. Macro to import/export data (10 replies)
  82. Solved: Copy Worksheets Based on "View" (14 replies)
  83. Sort columns based on named range (8 replies)
  84. Sleeper: Conditional VBA solution for moving data as per diffrenet cell value (4 replies)
  85. Solved: Returning a value into a textbox without Decimal Places Shown (4 replies)
  86. Count no. of item copied. (2 replies)
  87. Solved: How to have function run on both tabs (3 replies)
  88. =today(),now() (1 replies)
  89. Recquired Conditional VBA solution for moving data as per diffrenet cell value (1 replies)
  90. Macro Menu (7 replies)
  91. Inside ListBox Sorting Problem.. (2 replies)
  92. Restrict two macro run at same time (3 replies)
  93. filter, select and mail search results (0 replies)
  94. lookup or match (4 replies)
  95. Solved: Action code 2 only in cells (4 replies)
  96. Multiple Sheet Consolidator into one MasterSheet (6 replies)
  97. Need help with VBA code for hiding across multiple ranges (5 replies)
  98. Solved: VBA code for removing blank cells in a list (17 replies)
  99. Solved: Syntax Rectification Required (17 replies)
  100. "Freeze" some rows with highlighting (2 replies)
  101. Top 20 (2 replies)
  102. [SOLVED:] Regular Expression Replace (13 replies)
  103. [SOLVED:] Text to Columns or something similar (2 replies)
  104. Help Me!!! (1 replies)
  105. Userform Dynamic TextBoxes/Labels/Checkboxes and SQL Insert (1 replies)
  106. Add new items to list (5 replies)
  107. Initialize Multiple Textboxes (16 replies)
  108. [SOLVED:] Need to extract a few items from 250 XML Files in a Tree View, to a Spread Sheet (4 replies)
  109. Solved: IsNull Function Not Functioning (4 replies)
  110. Solved: Reference a Range in a different Worksheet (10 replies)
  111. Solved: Simpliest Way to Reconcile Checkbook (8 replies)
  112. Delete blank row after words and print in pdf (1 replies)
  113. Variable question (5 replies)
  114. Delete the last row that was filled (0 replies)
  115. Solved: Populate Combo box with shortened list (4 replies)
  116. Solved: Creation of Pivot Tables has errors ): (2 replies)
  117. Solved: Dynamic Drop Down List Freezing (4 replies)
  118. Solved: sumproduct question 2 (4 replies)
  119. Solved: Instructions Following a Called Script (5 replies)
  120. Solved: VB to keep all border (6 replies)
  121. Solved: Painting cells meeting conditions VBA (2 replies)
  122. error code, run time error '424 (4 replies)
  123. Solved: Exclude Sheet names from list (5 replies)
  124. Solved: sumproduct question (2 replies)
  125. Automating IE to get data from a website (5 replies)
  126. password protection difference (5 replies)
  127. Delete all hyperlinks and the associated sheets (6 replies)
  128. Hyperlink to folder (2 replies)
  129. running some macros automatically (7 replies)
  130. Solved: Hyperlink to folder (5 replies)
  131. Solved: unable to get the transpose property (2 replies)
  132. Worksheet_Change and RTD Link (4 replies)
  133. Summary (4 replies)
  134. highlight activecell in combo box (2 replies)
  135. Multiple Row Totals Based On Pivot Table (0 replies)
  136. Move data from world to excel (5 replies)
  137. Mark cell as complete (15 replies)
  138. index match example (0 replies)
  139. Return Value from Dialog (6 replies)
  140. append text file (1 replies)
  141. Solved: Phantom Pictures/Images (4 replies)
  142. Link Excel cell text to autocad text by VBA (0 replies)
  143. Solved: Does this make sense? (1 replies)
  144. Last cell in range (0 replies)
  145. Solved: Delete sheets (7 replies)
  146. Sorting a Listbox Data in VBA (7 replies)
  147. REAL VALUED ROOT OF A POLYNOMIAL_newton raphson algorithmn_VBA (0 replies)
  148. Solved: check number of words (5 replies)
  149. Excel to Auto cad block attributes (0 replies)
  150. how to make an "isletter" class in vba? (12 replies)
  151. Error Handling Stuck in a Loop (5 replies)
  152. CODE FOR JOB (10 replies)
  153. [SOLVED:] Deleting text from right side of an individual cell (3 replies)
  154. Solved: Insert New Range Name (7 replies)
  155. Find Contents of cell (3 replies)
  156. Hyperlink and copy sheet based on specific criteria (0 replies)
  157. UserForm text box info passing to cells (2 replies)
  158. Solved: date format question (4 replies)
  159. Urgent Help - Macros to Insert Rows in 2 Sheets simultaneously (0 replies)
  160. How to access the literal content of a cell, regardless datatype (1 replies)
  161. How to make an Excel Macro globally available? (2 replies)
  162. Solved: Use cell value in formula as Dynamic Range (7 replies)
  163. Solved: Extract words (2 replies)
  164. Pasting excel tables one after another in word file using VBA (2 replies)
  165. Check Range (2 replies)
  166. Append text from adjacent cell to an existing cell for all rows in worksheet (3 replies)
  167. Solved: copy reference without link from copyed file (6 replies)
  168. Excell-PPT shape handling problem (12 replies)
  169. Worksheets problem (17 replies)
  170. Prob with vba code in 2007 and giving error after i installed 2010 (0 replies)
  171. [Q] Save Sheet Box prompted (2 replies)
  172. how to get unmatched records from database tables ? (0 replies)
  173. Click Listbox how to show more picture ? (8 replies)
  174. Pivot table filtering according to current year (0 replies)
  175. Solved: Tab sheet Name In the Sell (7 replies)
  176. Solved: Listbox, should be simple! (3 replies)
  177. VBA: Msg Error if Duplicate (6 replies)
  178. Runtime error (3 replies)
  179. Can I use MD5 encryption in my Excel VBA Project? (1 replies)
  180. Solved: Search, Edit and Re-insert (2 replies)
  181. Solved: create worksheets from column values (7 replies)
  182. VBA Code to copy only the Pivot Data from a Pivot Table with out Grand Totals (2 replies)
  183. Excel-VBA (4 replies)
  184. click a link in a webpage (0 replies)
  185. VBA to change content at the click of button (2 replies)
  186. Attached sheet as Email Body (1 replies)
  187. UI and Cell Event Routines? (2 replies)
  188. Solved: inputbox not keying value (3 replies)
  189. Solved: paste to match destination formatting (2 replies)
  190. [SOLVED:] If file is open or if file exist (7 replies)
  191. Solved: Take Userform data to new worksheet (1 replies)
  192. Solved: help on tranposing data from column (4 replies)
  193. Calling a Stored Proc from VBA (4 replies)
  194. Loop Thru Textboxes - Help.... (9 replies)
  195. Look up for a value in a worksheet and store it in a variable (3 replies)
  196. CountIf and only different values (7 replies)
  197. Pivot Table Help (2 replies)
  198. merging worksheet with forced repetition (0 replies)
  199. csv import (8 replies)
  200. Is it possible to migrate data using visual basic in excel with other systems? (1 replies)
  201. search a specift text and concatenate with another row (11 replies)
  202. Copy into new workbook based on cell info and other questions (9 replies)
  203. Solved: vlookup problem (5 replies)
  204. data validation (1 replies)
  205. Formting and Adapting (1 replies)
  206. calendar?? (1 replies)
  207. Array Help2 (1 replies)
  208. Group cells (12 replies)
  209. Strange behavior for my VBA code (HELP) (8 replies)
  210. How to exclude hidden rows/columns while executing a VB code (4 replies)
  211. Importing and formatting text files (2 replies)
  212. find end of the... (4 replies)
  213. Solved: code to work for 12 TextBoxes of a form (5 replies)
  214. Selection criteria (3 replies)
  215. dropdown menu (4 replies)
  216. Putting values on cell based on cell colors (3 replies)
  217. VBA events part 2 (8 replies)
  218. Excel VBA code to Correct Day ? (4 replies)
  219. Solved: Take User form data to new worksheet (13 replies)
  220. Posting value to Cells from VBA, where Cell are protected? (2 replies)
  221. Adding a ScrollBar to a dynamic UserForm (13 replies)
  222. Check date is between 2 dates (2 replies)
  223. Solved: Array Query (2 replies)
  224. Solved: msgbox display (5 replies)
  225. Passwords part 2 (5 replies)
  226. Solved: Passwords part 1 (3 replies)
  227. Solved: Rename worksheets based cell value (9 replies)
  228. Solved: Automate Several Sheets (13 replies)
  229. VBA form events (8 replies)
  230. Copy Paste sheet Range to another worksheet (7 replies)
  231. Solved: vlookup skip blank or 0 cells and find match (4 replies)
  232. renaming all files in folder & subfolder with name & date (3 replies)
  233. VBA: create separate sheets based on cell value (1 replies)
  234. code Transpose whole workbook (13 replies)
  235. can this be simplified with a loop? (1 replies)
  236. Solved: Sync Loading Bar with actual Process (1 replies)
  237. Organizing People Using VBA / Excel? (2 replies)
  238. Solved: vba : Syntax modification help required (2 replies)
  239. vba cell format strikthrough and red (2 replies)
  240. Can you intercept a keystroke during a long loop (4 replies)
  241. Automatically choose which file to open? (1 replies)
  242. Error Handling in VBA (9 replies)
  243. Solved: division with zero (1 replies)
  244. Password TextBox in UserForm (5 replies)
  245. IsFileOpen Error "53" in 2003 (2 replies)
  246. creating a Copy/paste macro from one sheet to another assigning buttons (1 replies)
  247. VBA Error Handling Help (10 replies)
  248. conditional column range (1 replies)
  249. Count the Cells (3 replies)
  250. Highlight the columns being used to AutoFilter a range (1 replies)