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. [SLEEPER:] The number of users in the shared workbook (0 replies)
  2. [SOLVED:] Updating Win/Loss records with VBA Button (2 replies)
  3. [SOLVED:] Issue with VLOOKUP.....Working on 1 Cell but not the other cell.... (3 replies)
  4. [SOLVED:] Look up function vba? (10 replies)
  5. Select record and update (0 replies)
  6. After page break bottom border for all pages (0 replies)
  7. [SOLVED:] Move file by vba (3 replies)
  8. [SOLVED:] Arranging data that is in columns in a different dynamic way (31 replies)
  9. VBA Help (33 replies)
  10. Combobox's (39 replies)
  11. need macro for auto year workbook with auto months and dates (3 replies)
  12. Page break setup (3 replies)
  13. Clear the data (3 replies)
  14. Pulling data from MenaData and BioData in result sheet based on employee id (7 replies)
  15. VBA to use Format Painter from one row to another row (2 replies)
  16. hide/unhide column after criteria match (4 replies)
  17. filter data Automatically with wildcard characters string (2 replies)
  18. [SLEEPER:] Popup UserForm, the custom message box, is not closed. (12 replies)
  19. Formula by vba (16 replies)
  20. How to automate an email process –ideas and or advice (5 replies)
  21. How to Sum Variable Columns and Rows Using VBA (0 replies)
  22. VBA Sheet Linking Issue (1 replies)
  23. Add border top and bottom row for all pages (6 replies)
  24. Turn Multiple OptionButtons as False (6 replies)
  25. Userform Enter key (4 replies)
  26. Reference a person in e-mail from VBA (2 replies)
  27. If Column X Contains Specific Text, Copy to Col X cell & del (2 replies)
  28. [SOLVED:] Connecting to phpMyAdmin SQL DB through SSH (0 replies)
  29. [SOLVED:] Delete row (3 replies)
  30. User Form Shown when open VBE Editor (1 replies)
  31. Copy paste (6 replies)
  32. Unhide sheet with password protection (1 replies)
  33. Dlete row (7 replies)
  34. Delete Blank Rows and Add Borders on Last Row (9 replies)
  35. Suggestions for Creating Hundreds of Data Lines for Budget (13 replies)
  36. SQL query run on Excel VBA (0 replies)
  37. [SOLVED:] How do I avoid selecting Shapes? (2 replies)
  38. Scatter graph based on pivot table (0 replies)
  39. [SOLVED:] NEED HELP IN GETTING MACRO TO WORK NON SPLIT DATA MACRO (2 replies)
  40. Search for data in different wrsht and paste result to other column in original wrsht (2 replies)
  41. [SOLVED:] Refreshing linked cells to 3 workbooks on different pc's (2 replies)
  42. Concatenate Conditional Long String in Formula (5 replies)
  43. Drop-Down List to Display Different Pivot Tables (3 replies)
  44. [SOLVED:] Copy data based on a certain criteria (2 replies)
  45. [SOLVED:] String Array (7 replies)
  46. extract after multiple criteria (10 replies)
  47. Copy paste csv to xlsx (2 replies)
  48. Copy paste (6 replies)
  49. [SOLVED:] Assistance required to resolve ComboBox_Change issues (5 replies)
  50. Search for data based on cells in another worksheet and copy data to another wrksht (6 replies)
  51. Delete Partially Duplicate Rows based on Multiple Values (4 replies)
  52. Defining names in VBA using for loop (6 replies)
  53. Print multiple sheet as single pdf page (22 replies)
  54. [SOLVED:] How to Open a Picture using Windows Photo Gallery (2 replies)
  55. Inserting lines in text file according to a list (1 replies)
  56. [SOLVED:] Open File not working (2 replies)
  57. VBA code help - concatenation (1 replies)
  58. Pivot report filter with wildcard (4 replies)
  59. Move Filtered Data & Get series of Numbers (0 replies)
  60. Macro to parse a file and input in a spreadsheet the lines that match parameters (2 replies)
  61. VBA to load specific cells from one doc to another (0 replies)
  62. Stgange overflow error (3 replies)
  63. VBA Coding help please (2 replies)
  64. How to invert and copy data from a cell? (3 replies)
  65. Move all files on XX Folder to XX Folder based on excel. (5 replies)
  66. vba - Create subfolder as per monthwise and one Masterworkbook (1 replies)
  67. Fill down name according to column B (1 replies)
  68. I get the error with that if condition. (1 replies)
  69. [SOLVED:] Issue with Excel Division of Fractions..Not showing correct results (7 replies)
  70. I can't find a control (8 replies)
  71. Compare two sheet , i.e import sheet and htmlcopy sheet and give result in third she (1 replies)
  72. [SOLVED:] Renaming Word Document from Excel VBA (3 replies)
  73. [SOLVED:] VBA Code Require - Consolidate multiple sheets in 1 sheet when column Headin differs (27 replies)
  74. how to filter all dates between two dates (4 replies)
  75. Copy and paste in one worksheet by conditionqq (4 replies)
  76. Add In Preferences (1 replies)
  77. [SOLVED:] Counting letters and numbers separately in a single cell (1 replies)
  78. [SOLVED:] How to Combine Multiple Excel Workbooks into Existing Workbook (3 replies)
  79. Defining range to convert to CSV (2 replies)
  80. One workbook range data paste into another workbook range (0 replies)
  81. Calculating Max and Min Value of RTD without capturing them. (5 replies)
  82. internetexplorer from excel vba run time error 462 (1 replies)
  83. .CompareMode with Dictionary (3 replies)
  84. [SOLVED:] VBA code Function to check if date is weekday (2 replies)
  85. [SOLVED:] HELP Getting data to final sheet based on highlighted cells!!! (4 replies)
  86. [SOLVED:] Macro defaulting to original filepath after sheet extracted to new workbook (3 replies)
  87. [SOLVED:] How to force WorkSheet InputBox to accept currency or decimal value (6 replies)
  88. Insert new column with a Formula (11 replies)
  89. [SOLVED:] Justify text in a msgbox (11 replies)
  90. Word Document Vba Excel - Changing Information in Multiple Documents (3 replies)
  91. Copying with condition (1 replies)
  92. Creating Checkboxes that when click uncheck the other (11 replies)
  93. VBA PasteSpecial error (5 replies)
  94. Moving Sent Items To Another ARCHIVE Sent Folder. (5 replies)
  95. Find previous day balance. (2 replies)
  96. split text in different cells after each underscote "_" (9 replies)
  97. [SOLVED:] Very Complex excel formula required... (8 replies)
  98. Help to make VBA Model in Excel run quicker (6 replies)
  99. [SOLVED:] Copy and Paste (4 replies)
  100. [SOLVED:] Prompt user for date and user to Open file (2 replies)
  101. [SOLVED:] Sumif multiple criteria (2 replies)
  102. Starting from specific place in a row (3 replies)
  103. [SOLVED:] Need help getting results of macro displayed, starting at row 5 column B thru F (9 replies)
  104. [SOLVED:] .TextToColumns doesn't seem to work reliably. (8 replies)
  105. HELP! VBA Problems (1 replies)
  106. [SOLVED:] Edit textfile vba (6 replies)
  107. [SOLVED:] Countif and Count on visible rows (2 replies)
  108. [SOLVED:] how to use userform to operate pivot table (7 replies)
  109. Undo/Redo or CTRL+Z – CTRL+Y »» does not work for my own macros (1 replies)
  110. Find currency and add/debit according to amount (1 replies)
  111. [SOLVED:] VBA To Re-lock a specific cell after 30 seconds (8 replies)
  112. Using an addin to package all my source code (14 replies)
  113. Checking the values in Sheet1 with multiple entries in Sheet2, Write the output (1 replies)
  114. Copy last 20 rows (or all if less than 20) (4 replies)
  115. VBA - Open each file from directory in ascending Order (2 replies)
  116. How to backup settings of Microsoft Office which are in registry branches? (0 replies)
  117. [SOLVED:] Find All, Copy & Paste to Next Blank in Sheet (5 replies)
  118. How to adjust the size of the `Note` after opening it? (3 replies)
  119. [SOLVED:] Trouble Assigning Error Bars with Array (0 replies)
  120. Retrieving all files in folder or subfolder containing specific text (7 replies)
  121. [SOLVED:] i need Vba code that creates an input mask for a password ***** in an input box (3 replies)
  122. Defining range from First Cell to Last Used Cell (9 replies)
  123. Filter Data Based on Dates + other criteria & copy to another sheet (1 replies)
  124. [SOLVED:] vba tool for admin database maintain & analysis (2 replies)
  125. problems with printing (1 replies)
  126. How to pull data from a Sheet to create a Context Menu? How to combine two VBA codes? (0 replies)
  127. [SOLVED:] how to use both userform and other excel (3 replies)
  128. [SOLVED:] how to marge multiple sheet into one sheet (3 replies)
  129. [SOLVED:] how to make filter from data base and show count in VBA tool (1 replies)
  130. [SOLVED:] Find Function (7 replies)
  131. Excel file needs help (2 replies)
  132. [SOLVED:] Extracting 8 digit PO from Field (2 replies)
  133. Can I use vba to add hyperlink shortcuts to folders (12 replies)
  134. Trouble Changing Active Cell After Pasting To 2nd Workbook (2 replies)
  135. Get Unique list of cells in a Column for loading a Combobox (3 replies)
  136. VBA script/code to email range of data from an excel spreadsheet (0 replies)
  137. [SOLVED:] Deleting Queries and Connections not working in O365 version (8 replies)
  138. How to put a named range in one workbook to another and call a button VBA (4 replies)
  139. VBA - Copy Multiple Columns as per mapping sheet union help (5 replies)
  140. Suggestion for Best Practice (42 replies)
  141. Copy and Paste loop (7 replies)
  142. Search whole row for (6 replies)
  143. Coding Excel User Form (8 replies)
  144. IF LOOP FOR LOOP AND IMPORTING FROM ANOTHER WORKBOOK (2 replies)
  145. Pivot Table Creation Error (6 replies)
  146. [SOLVED:] Compare and copy (2 replies)
  147. [SOLVED:] Extract amounts from text strings using VBA (6 replies)
  148. Removing Rows Based On One or More Cell Values (1 replies)
  149. [SOLVED:] Find word and delete else exit Sub (3 replies)
  150. [SOLVED:] Help speeding up macro (2 replies)
  151. [SOLVED:] Increment number based on two criteria (2 replies)
  152. User form in PowerPoint to feed Excel database (2 replies)
  153. check macro execution / speen (0 replies)
  154. [SOLVED:] HELP GETTING SUM OF COLUMNS IN A RANGE (4 replies)
  155. [SOLVED:] Loop through all open Workbooks in all Instances (7 replies)
  156. Excel Hyperlink when click ,automatically compose a message in outlook (1 replies)
  157. [SOLVED:] If/Then/Else, Search & Set Active Cell VBA Help (3 replies)
  158. [SOLVED:] Formula to return two multiple lookups in one cell ? (2 replies)
  159. [SOLVED:] HELP NEED TO MAKE CODE GENERIC LOOPING THROUGH CELLS TO IMPORT DATA (5 replies)
  160. VBA help in creating a dependent and source views (2 replies)
  161. Can't calculate long recursion (5 replies)
  162. VBA to check for PR SAP attachment (0 replies)
  163. [SOLVED:] All VBA Worksheet_Change Events Not Working (6 replies)
  164. [SOLVED:] Overflow Error when using Format() (2 replies)
  165. Is there a way to write this "for" loop? (2 replies)
  166. Bold and color numbers in specific format with special character (2 replies)
  167. [SOLVED:] Dynamically passing value to Sub using buttons (1 replies)
  168. [SOLVED:] Userform TextBox Loop Syntax (3 replies)
  169. [SOLVED:] Modify a macro to remove blanks from a worksheet (14 replies)
  170. Scanning Input not considered a Change (3 replies)
  171. extract data from Excel Columns to an Output sheet (2 replies)
  172. [SOLVED:] Using a string in names of dublicates (3 replies)
  173. [SOLVED:] Data Comparison (3 replies)
  174. Conditionally put - sign (0 replies)
  175. VBA Merging duplicate -cells issue (2 replies)
  176. Summarized data based on timetable sequence (0 replies)
  177. [SOLVED:] Edit Excel Links in PPT Using VBA and Early Binding (6 replies)
  178. Several questions about the collection. (3 replies)
  179. Employee number according to timetable sequence (0 replies)
  180. I am having an issue with macro assigned shapes (0 replies)
  181. VBA: Copy and Paste if criteria met (8 replies)
  182. [SOLVED:] Vba to calculate the number of days from today to the 1st of the month. (2 replies)
  183. [SOLVED:] Loop sheets that begin with given chars (1 replies)
  184. Extra Screen for Laptop usinig Android Phone (4 replies)
  185. How to get msgbox output with spaces between every three numbers? (2 replies)
  186. [SOLVED:] Excel Freezing Up When I Run Sub (5 replies)
  187. Double data and runtime error when running macro (7 replies)
  188. Possible to clean up my formula (6 replies)
  189. Run time 424 object required (4 replies)
  190. [SOLVED:] Multiple drop down selections in the same cell (1 replies)
  191. [SOLVED:] Turning 100 Data points into 6000 using VBA HELP! (23 replies)
  192. Add current selection to filter in VBA (0 replies)
  193. [SOLVED:] “Application.Speech.Speak”, to announce the greetings. (5 replies)
  194. extract data from a row with a lot of data (6 replies)
  195. Copy paste the data by vba (5 replies)
  196. [SOLVED:] Need advice on VBA Conditional formatting Formula : Run-time error '5' (1 replies)
  197. Select and Edit certain type of ChartObject in VBA (3 replies)
  198. [SOLVED:] Perform calculations on a field that has already been added to pivot table (0 replies)
  199. Copy and paste if cell contains specific text (6 replies)
  200. [SOLVED:] How to create a public array in class module? (15 replies)
  201. [SOLVED:] Is there code similar to "If Not Application.Intersect" & "If Not Intersect(Target.. (8 replies)
  202. Send reminder emails based on date in column, after finding last email correspondance (15 replies)
  203. [SOLVED:] Progress bar...% (3 replies)
  204. Lock Cell/Cell Range based on Cell value (12 replies)
  205. [SOLVED:] Suggestions regarding speed and efficiency (21 replies)
  206. Run-time error code "438" (11 replies)
  207. [SOLVED:] Filter and Sort with Multiple Headers (8 replies)
  208. [SOLVED:] Attach event to multiple ComboBoxes (3 replies)
  209. [SOLVED:] Working with Dates in VBA (5 replies)
  210. Cant count integer partitions by recursive function. (1 replies)
  211. [SOLVED:] Comparison isn't finding as true; but values sent to MsgBox show it should be.... (1 replies)
  212. Transfer of data between two workbooks using name of worksheet? (0 replies)
  213. [SOLVED:] Trying to set color to a range (2 replies)
  214. VBA vlookup in file a with data from file b (0 replies)
  215. VBA to copy specific columns from word table to Excel (0 replies)
  216. Arrange Data Properly (6 replies)
  217. Excel Data Files (2 replies)
  218. Need to select a workbook which changes names everyday (1 replies)
  219. Search, find, hide columns - VBA (2 replies)
  220. [SOLVED:] Cross Referencing Filenames Using an ID and "Charting" Results Across Columns (1 replies)
  221. VBA Code Required to autosize image - I can pay via. Paypal or other method... (1 replies)
  222. Searchable dropdown list (data from two columns) (2 replies)
  223. [SOLVED:] Copy value of active cell to another worksheet (3 replies)
  224. INSERTING MULTIPLE PICTURES THAT MEET CRITERIA (18 replies)
  225. How to hide textbox in userform by option button? (3 replies)
  226. RUNTIME 438 ERROR WHEN CLICKING IMAGE (1 replies)
  227. Dynamically adding and positioning check boxes to wrap inside frame (1 replies)
  228. VBA Help: Email attachment via folder or direct-link (3 replies)
  229. '1004': Application-defined or object defined error (VBA) (3 replies)
  230. VBA - Textfile Skip line Help in Looping (1 replies)
  231. [SOLVED:] Merge specific word files from excel VBA (4 replies)
  232. [SOLVED:] Adding links of files, seperating filenames with Split() - Error: Object variable or (7 replies)
  233. [SOLVED:] Trying to code this VBA macro but it's beyond my knowledge (9 replies)
  234. Bug? with activeX combobox (7 replies)
  235. VBA sorting error (8 replies)
  236. Pass variable from module to the userform. (6 replies)
  237. [SOLVED:] conditional month() (2 replies)
  238. Get COM Addin list of functions (0 replies)
  239. [SOLVED:] need help with filtered table (7 replies)
  240. VBA - loop help in Seperating the data...... (8 replies)
  241. VBA - Select Case Error (6 replies)
  242. Multi Find and Replace VBA Script Macro Not Working (16 replies)
  243. [SOLVED:] Event Before refresh pivot cache (8 replies)
  244. Object required on .Find (2 replies)
  245. trying to count total rows based on group of values in another column (3 replies)
  246. [SOLVED:] Automated Login Results in URL Change After More Than One Use (0 replies)
  247. [SOLVED:] Help With VBA Document Counter (2 replies)
  248. VBA code (macros) understanding (3 replies)
  249. Can't start edit or remove macros (1 replies)
  250. [SOLVED:] HOW TO ADD 2D NAMED RANGES WITH SAME DIMENSIONS? (4 replies)