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:] Need VBA to delete all link in sheet except sum formula (2 replies)
  2. Exel File Corrupt when opening (1 replies)
  3. [SOLVED:] Open File name contained in specific cell (4 replies)
  4. Random Selection in Excel using VBA (7 replies)
  5. [SLEEPER:] Cannot Find Source of Error 9 (3 replies)
  6. [SOLVED:] Change a Command Button Caption at certain conditions. (11 replies)
  7. [SOLVED:] Macro show/hide with show/hide zeros in cells (3 replies)
  8. [SOLVED:] Convert from Worksheet_Change to manual (4 replies)
  9. [SOLVED:] Summary to be generated from excel files in vba. (5 replies)
  10. intranet web site (0 replies)
  11. Loop through array of buttons on a Pivot table (1 replies)
  12. [SOLVED:] Obtaining password from worksheet range (5 replies)
  13. [SOLVED:] Message Box using vbYesNo (10 replies)
  14. [SOLVED:] Create new text files using Cell values as titles (3 replies)
  15. Help with Public Variable Not Retaining Value (6 replies)
  16. [SOLVED:] Help with parsing string from right.. (6 replies)
  17. Business System Ideas - Advice Needed! (14 replies)
  18. First two digits delete from text file by macro (0 replies)
  19. [SOLVED:] Link word table to excel (2 replies)
  20. macros code help ! (1 replies)
  21. Loops vs. Arrays (5 replies)
  22. [SLEEPER:] Three Dimensional Linear Interpolation UDF (14 replies)
  23. Copy Row to another Sheet By Value in Column (2 replies)
  24. Name & Save workbook from a specific sheet cell value (2 replies)
  25. How to protect excel sheet and formulas (1 replies)
  26. Macro limits saving of the data (30 replies)
  27. Macro adds a row up without data (2 replies)
  28. Compare and extract column (2 replies)
  29. Macro to Match Values on two sheets (3 replies)
  30. Appending files (16 replies)
  31. [SOLVED:] Can someone check these 5 lines of code? (9 replies)
  32. [SOLVED:] Macro to do one thing before 16:00 Hrs & something else after 16:00 hrs (2 replies)
  33. Less than or equal to code (1 replies)
  34. loop through multiple word files and import content control info to excel (8 replies)
  35. [SOLVED:] Position modeless userform to top right of Activewindow (10 replies)
  36. [SOLVED:] Modeless progress bar (6 replies)
  37. Activate DropDown List and Calendar when Cell Selected (5 replies)
  38. Copy Pasting Data across Excel Sheets using VBA (in background & without clipboard)? (2 replies)
  39. [SOLVED:] If Cell in range = 0 then three different scenarios (2 replies)
  40. [SOLVED:] Un-parallel lists - need HELP (3 replies)
  41. VBA function for mortgage calculations (3 replies)
  42. [SOLVED:] Transposing formulas (24 replies)
  43. [SOLVED:] Macro eliminates row and fix alignment (2 replies)
  44. [SOLVED:] Input mask percentages (4 replies)
  45. Macro detects data and paste into another spreadsheet (11 replies)
  46. SLA Response Formula for 2 diff SLA times (1 replies)
  47. [SOLVED:] Large-Scale Find/Replace In Word With Excel Lists (17 replies)
  48. [SOLVED:] Excel Macro - What am I missing? (3 replies)
  49. Algorithm For Compare Rows by Three Columns (4 replies)
  50. [SOLVED:] chr 10 (5 replies)
  51. [SOLVED:] Remove specific contains (3 replies)
  52. Guidance saught: Switching to/from excel using AppActivate (1 replies)
  53. use variable in formula (3 replies)
  54. Save invoice problem (3 replies)
  55. sum of 3 dates (3 replies)
  56. Formattung lost when copying/pasting into excel cell using VBa (2 replies)
  57. Run-time error 91 when trying to close workbook without saving (4 replies)
  58. [SOLVED:] Unhiding multiple sheet based on choice prompted after entering password (5 replies)
  59. Excel macro (3 replies)
  60. Sleeper: Access Textbox and Button inside the form of a frame of a webpage (0 replies)
  61. searching a string and adding to it (5 replies)
  62. [SOLVED:] dynamically display Activex control by the active worksheet (2 replies)
  63. [SOLVED:] For/Next for Blanking Fields (3 replies)
  64. Cell format changing when file open manually and VBA (3 replies)
  65. Copy data from one Excel sheet to another but on if data in to columns match (1 replies)
  66. [SLEEPER:] Copy a column from one tab to another using a column reference (5 replies)
  67. hi help me for my project (18 replies)
  68. Force marcos to be enabled and lock cells (2 replies)
  69. Button - Create/Fill/Export (1 replies)
  70. [SOLVED:] Including Special Characters (i.e. parenthesis) Within Text (2 replies)
  71. [SLEEPER:] How to insert any user name into a file path (2 replies)
  72. [SOLVED:] Format ActiveX Listbox for Currency (17 replies)
  73. BAR CODES IN EXCEL (2 replies)
  74. [SLEEPER:] application.filesearch not working in Excel 2010 (2 replies)
  75. [SOLVED:] VBA Consolidate Multiple Files (9 replies)
  76. [SOLVED:] Changes & creation of Code for hiding & unhiding columns & Sheet (18 replies)
  77. [SOLVED:] Macro adds a row and make a change (2 replies)
  78. [SOLVED:] Split String After 15 Characters (3 replies)
  79. [SOLVED:] Which Worksheet Event is best for calculations? (16 replies)
  80. Return corresponding match count (1 replies)
  81. NEED HELP : LOOKUP VBA CODING (1 replies)
  82. [SOLVED:] Pivot Table Creation with Optional Arguments (11 replies)
  83. Userforms (codes and formulas) (11 replies)
  84. VBA Pivot Table Update Run Time Error (0 replies)
  85. [SOLVED:] Textbox to regain focus (13 replies)
  86. [SOLVED:] Need input box when user does not enter a number or presses cancel (7 replies)
  87. Sort two columns - not working (4 replies)
  88. Word macro - need to run it from excel... (21 replies)
  89. [SOLVED:] Comparing Data & Marking Differences (6 replies)
  90. List Folder Names (3 replies)
  91. [SOLVED:] Highlighting cells different colors for pending expiration date (2 replies)
  92. Please Help me!! My Shift+Del recovered XLS file is having data in unknow language! (5 replies)
  93. Extracting data from html files (within certaing tags) into Excel file (0 replies)
  94. compare 2 list and find missing entry (2 replies)
  95. Data exctraction from one sheet to another (3 replies)
  96. VBA Script to import Sheet content from external workbook (4 replies)
  97. CSV files processing (7 replies)
  98. Open Password protected zip file using vba (5 replies)
  99. Paste as text not BMP! in lotus notes (2 replies)
  100. Update SharePoint List from Excel using VBA (1 replies)
  101. [SOLVED:] Excel 2013 - text box glitch - tiny cursor on entry, font size fine on exit (4 replies)
  102. [SOLVED:] excel userform calendar for leave tracking (10 replies)
  103. Macro to Clear Rows Not Containing a Particular Word/Text Across Worksheets (2 replies)
  104. Require macro for the attached scenario (1 replies)
  105. Shared document/Multiple Users - tops please :) (1 replies)
  106. Sleeper: Copy Data From INTERNET EXPLORER into Excel using vba (0 replies)
  107. total Fridays in a range (11 replies)
  108. [SOLVED:] Please help Chart data (9 replies)
  109. Bitten off more than I can chew. (5 replies)
  110. [SOLVED:] Using multiple if criteria in VBA (2 replies)
  111. Sleeper: Macro built on Win64 not running on Win32 (6 replies)
  112. [SOLVED:] Issues in conditional formatting (2 replies)
  113. Copy Columns With Specific Headers--Paste Into Separate Workbook Based On Header (3 replies)
  114. [SOLVED:] Re-Activating OnSave Macro (8 replies)
  115. [SOLVED:] Need Error Check (10 replies)
  116. [SOLVED:] Renaming a text file and extension from content (6 replies)
  117. [SLEEPER:] Run Access create table query from Excel with msgbox displaying records created (3 replies)
  118. [SOLVED:] Bypass Run-time error '13'? (3 replies)
  119. [SLEEPER:] Extract portion of web page to excel using VBA (0 replies)
  120. When choosing an image according to the number in a cell to show marked (6 replies)
  121. Re-Arrange Data based on FLAG (6 replies)
  122. [SOLVED:] How to Make Copy of Word Document (5 replies)
  123. [SOLVED:] Changing the Row reference of a formula (7 replies)
  124. Show Zero Value in Cell (3 replies)
  125. Excel 2010 huge file size (3 replies)
  126. INDIRECT() function doesn't work: "Can't Find Object or Library" (7 replies)
  127. Strange delay in execution of MailTo Macro code (4 replies)
  128. Help With Counting (4 replies)
  129. Prevent form from closing after programmatically adding code (7 replies)
  130. [SOLVED:] Paste a columns formats and formulas not its values (3 replies)
  131. Fastest way to temporarily store results for further analysis (23 replies)
  132. HELP : Extract value with criteria color (1 replies)
  133. [SOLVED:] Code Execution Interrupted when Reloading Userform (5 replies)
  134. [SOLVED:] Repeat a column Insert in the same position on two other sheets. (4 replies)
  135. Hello my fellow nerds (1 replies)
  136. [SOLVED:] InStr reading cells - doing something wrong (4 replies)
  137. VBA code to merge cells (7 replies)
  138. [SOLVED:] Macro code for matching and replacing the values (4 replies)
  139. [SOLVED:] time utilization (2 replies)
  140. [SOLVED:] Selecting Multiple Items in a Pivotfield, Hoping to be able to Toggle with a Hotkey (6 replies)
  141. Auto paste special on lookup formulas if value is found (1 replies)
  142. [SOLVED:] VBA Code to populate to end of data (4 replies)
  143. [SOLVED:] vba function to return random sign (2 replies)
  144. [SOLVED:] VBA MACRO CODE FOR REMOVING CELLS AND APPEARING IT CONTINOUSLY (2 replies)
  145. [SOLVED:] Sum Based On condition! (6 replies)
  146. Put Data On One Row in Excel With Many Forms (4 replies)
  147. Fill in InputBox using VBA (6 replies)
  148. [SOLVED:] VBA Coding to Repalce a List of Words with one word. (9 replies)
  149. Interpolation and calculation from table (6 replies)
  150. [SOLVED:] Worksheet focus change issues with userform(s) (13 replies)
  151. [SOLVED:] Calculating Min,Max,Quartile in dynamic ranges (22 replies)
  152. VBA: extract systematiically 5 rows and save them in a new excell file as .txt (4 replies)
  153. Object variable or With block variable not set error (1 replies)
  154. [SOLVED:] Check & Copy Data (5 replies)
  155. VBA Index/Multiple Match criteria (1 replies)
  156. [SOLVED:] Select Case nested in If Else... where's the break? (4 replies)
  157. [SOLVED:] Average times as long as between 2 dates (5 replies)
  158. [SOLVED:] Close a command button after it has been clicked (6 replies)
  159. [SOLVED:] Export embedded Word document and set data (2 replies)
  160. loop the wookbook with HPageBreaks and VPageBreaks. (0 replies)
  161. Calculate multiple sums depending on cells (8 replies)
  162. [SOLVED:] macro to repeat a value times in a column (6 replies)
  163. Sorting GPS Marks (18 replies)
  164. Excel 2010 Protect Existing Row, Allow New Rows (1 replies)
  165. Request Help for this Simple Macro (2 replies)
  166. How to paste a range of cells from excel to text field of a web page (1 replies)
  167. [SOLVED:] Find strings and delete (3 replies)
  168. Mass Pivot Table Changes (1 replies)
  169. Email Automation (1 replies)
  170. [SOLVED:] Need help with macro that clears out several different worksheets (39 replies)
  171. [SOLVED:] Delete Duplicate data on sheet2 and delete the row (2 replies)
  172. [SOLVED:] Loop Only Works on Active Sheet (4 replies)
  173. [SOLVED:] VBA Generate sheets with unique values (23 replies)
  174. Tips And Tricks (7 replies)
  175. Using inputbox to locate a range, and using 2 different locations to insert amounts (2 replies)
  176. Deleting repeated cells in two column table (text) (1 replies)
  177. help conditional formula if cell (1 replies)
  178. [SOLVED:] SetFocus on TextBoxes (3 replies)
  179. [SOLVED:] Insert blank row based on values in specified column (8 replies)
  180. [SOLVED:] VBA Code to parse boolean equations (27 replies)
  181. [SOLVED:] excel 2010 stops working when opening a userform (9 replies)
  182. [SOLVED:] VBA Format to Sheet Array (10 replies)
  183. Indexed Database Table in Excel for Lookup (7 replies)
  184. Need to link drop down list from range in xlsm (Add-In) (2 replies)
  185. [SOLVED:] Adding Values in a Userform (2 replies)
  186. [SOLVED:] Replace formula (8 replies)
  187. Can this be done with macro (7 replies)
  188. Object Variable or With Block variable not set (3 replies)
  189. Update Pivot Table filter by a value in another cell (1 replies)
  190. [SOLVED:] Dir function not working (8 replies)
  191. [SOLVED:] Deactivate Event Causing Error (12 replies)
  192. [SOLVED:] How to identify my version of VBA (2 replies)
  193. Getting "Subscript out of range" error (11 replies)
  194. Macro for adding variably named PDF in email from excel - (2 replies)
  195. Copy used cells and paste to master spreadsheet (3 replies)
  196. [SOLVED:] Multiply cell values using worksheet change event (12 replies)
  197. [SOLVED:] Userform listbox to range (3 replies)
  198. [SOLVED:] Set Range as a single cell relative to active cell (3 replies)
  199. Search column - move/copy entire row into another sheet. (3 replies)
  200. MAX MIN AVERAGE for situation (1 replies)
  201. Add New line above inlineshapes. (3 replies)
  202. Compare two columns to sheet3 based on condition (1 replies)
  203. [SOLVED:] Lotus Notes adding signature and attaching saved PDF (0 replies)
  204. [SOLVED:] Formulas to values with offset based on date > today (13 replies)
  205. whenever auto insert row than auto enter a formula in specific cell (6 replies)
  206. Set range and calculate sum problem (5 replies)
  207. typed and moving (9 replies)
  208. Macro not running properly on other systems (1 replies)
  209. Comma delimiters - Batch conversion of .csv to .xlsx (1 replies)
  210. [SOLVED:] Need to copy paste different cells to another file (files are same image) (5 replies)
  211. [SOLVED:] Export multiple worksheets into one csv file (27 replies)
  212. Adapt VBA Code With Adjusment Range (3 replies)
  213. [SOLVED:] vba textbox data valdiation (10 replies)
  214. [SOLVED:] Inquiry: VBA Code in Excel (3 replies)
  215. [SOLVED:] VBA Print function - want quotation marks in my text file (4 replies)
  216. [SOLVED:] Pivot Table Subtotals (1 replies)
  217. Sleeper: Open attached file from email in Lotus Notes in Excel (0 replies)
  218. [SOLVED:] Per hour result (5 replies)
  219. Sleeper: How to make Excel Start itself with a VBA Macro (5 replies)
  220. [SOLVED:] Passing Variables through VBA Excel - VBA Access (8 replies)
  221. Pivot table empty (0 replies)
  222. [SOLVED:] Ignoring comma when creating validation lists (13 replies)
  223. How to enter data in a specific cell (c8 in all sheets ) when data is on 1st sheet (9 replies)
  224. [SOLVED:] Tab order with VBA (21 replies)
  225. [SOLVED:] ComboBox: Possible to change Popout direction? (4 replies)
  226. [SOLVED:] check if listbox selected (4 replies)
  227. [SOLVED:] Pivot "For Each" Filtering Loop Failing (1 replies)
  228. Cells Clearcontents (1 replies)
  229. Insert blank rows based upon cell value with criteria (1 replies)
  230. Logic (7 replies)
  231. [SOLVED:] vba script to convert worksheets to pdf (8 replies)
  232. [SOLVED:] Identify value and automatically puts in another spreadsheet (1 replies)
  233. Macro to repeat merge, Filter, copy & paste to other sheet. (0 replies)
  234. Cut and Paste Rows from multiple Worksheets on to one summary sheet based on 1 condit (2 replies)
  235. enable and disable cells based on other cell value (0 replies)
  236. VBA concenate problem (9 replies)
  237. [SOLVED:] Sum the column (6 replies)
  238. Relative address rather than absolute address in VBA code (macro) (4 replies)
  239. CountIf with date (1 replies)
  240. Help Organising Data (2 replies)
  241. What to do when Text is found in a row? (1 replies)
  242. Search & Replace (2 replies)
  243. List Conditional Formatting on Separate Sheet (4 replies)
  244. VBA to Self Destruct File (16 replies)
  245. Find duplicates in each column, then delete rows containing only Subsequent duplicate (13 replies)
  246. [SLEEPER:] Multiplied of 2 column (1 replies)
  247. [SOLVED:] Transposing in VBA (10 replies)
  248. [SOLVED:] Paste data to another sheet and do sum and Multiply. (7 replies)
  249. Best approach to filter on a value, but showing all lines concerned by same object? (2 replies)
  250. [SOLVED:] Help transforming dates and rounding numbers using VBA (9 replies)