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:] VBA - Filling Master Template (3 replies)
  2. Formula/vba - Summary Report without Pivot (4 replies)
  3. Like expression with AND or OR (3 replies)
  4. [SOLVED:] Finding cells formatted with colour gradients of various colours (7 replies)
  5. Help VBA search (3 replies)
  6. Using non-contiguous ranges in Solver VBA (1 replies)
  7. Solver in Userform Linked in Excel (2 replies)
  8. Convert Binary to decimal on and vice versa on VBA (15 replies)
  9. auto fit cell height for merged cells in sheet that has protected (locked) cells (4 replies)
  10. Replacing Date with Period Based on Matrix (7 replies)
  11. Sleeper: AdvancedFilter - Unique Column 1, Greater than 0 Column 3 (3 replies)
  12. [SOLVED:] Transferring selected cells to a new sheet (13 replies)
  13. Publish to Sharepoint (5 replies)
  14. Search for a string in text files. (3 replies)
  15. [SOLVED:] Delete text line with specific word from multiline cell (12 replies)
  16. [SOLVED:] Part of a string (5 replies)
  17. EXPORTING DATA TO MS ACCESS FOR SIMULTANEOUS MULTI USER (1 replies)
  18. [SOLVED:] copy multiple rows of numbers to new location on same sheet. (24 replies)
  19. Check if labels are visible (3 replies)
  20. [SOLVED:] How to define range based on the value of another cell (2 replies)
  21. [SOLVED:] I want my reset button on VBA userform to do nothing if "no" is selected (4 replies)
  22. VBA to check if object is inside or outside of freeform area (6 replies)
  23. Help!! Merging multiple Excel workbooks into one master sheet. (5 replies)
  24. Advice on comparing excel workbooks (2 replies)
  25. Please help VBA Coding for Repeat Task for Step 2 to Step 6 (1 replies)
  26. [SOLVED:] question re "for each range in target" (4 replies)
  27. [SOLVED:] Highlight cells that contain specific words (8 replies)
  28. VBA code to copy to new workbook and insert pivot (4 replies)
  29. [SOLVED:] help adjusting code delete empty rows based on condition from sheet1 to sheet2 (9 replies)
  30. [SOLVED:] Add Roundup formula to VBA button (9 replies)
  31. UserForm to Return the MAX date in a TextBox resulting from VLOOKUP in ComboBox (26 replies)
  32. [SOLVED:] vba sum format number with currency (20 replies)
  33. Formulas no longer work in Excel for Office 365 (2 replies)
  34. [SOLVED:] Extract numbers starting with 07 (2 replies)
  35. Multi-use UForm - can it be improved upon? (4 replies)
  36. [SOLVED:] How to Log Changes on Sheets! (5 replies)
  37. vba copy paste (1 replies)
  38. VBA Macros to Copy Data to Another Workbook (10 replies)
  39. Copy data between sheets (18 replies)
  40. VBA Error 'Range of object worksheet failed (5 replies)
  41. [SOLVED:] Reformat a table (3 replies)
  42. [SOLVED:] Identify missing numbers in sequence (8 replies)
  43. [SOLVED:] Finding/Changing Default Printer (7 replies)
  44. Require VBA Code for filter Data after criteria match (5 replies)
  45. VBA Validation Fields and Date and Time Picker (0 replies)
  46. [SOLVED:] VBA from text to number (14 replies)
  47. Pull from Table1,Table2, Test Data, Then place in Table3 (1 replies)
  48. [SOLVED:] VBA Code not running if sheets are protected (11 replies)
  49. Customize ribbon 2013 excel (3 replies)
  50. vba advanced_Filter help (1 replies)
  51. help adjusting code combine two tables from two sheets to another sheet (10 replies)
  52. Keep userform open when opening or closing other workbooks (3 replies)
  53. Selecting (copying) specific rows up to the last column (6 replies)
  54. How to share an Excel file containing a macro on the network (4 replies)
  55. Input box to display as ****** (5 replies)
  56. VBA: Input cell data outout in three ways (3 replies)
  57. If cell is Empty! (2 replies)
  58. Pull data from one table to another (0 replies)
  59. VBA Search form (1 replies)
  60. [SOLVED:] Make Array with Full Paths to PDF Files in Parent and Subfolders (24 replies)
  61. small with condition (1 replies)
  62. [SOLVED:] User type not defined error trying to merge pdfs (0 replies)
  63. Update chart after cell gets updated (2 replies)
  64. [SOLVED:] VBA SPLIT into cells and reshape into table (11 replies)
  65. How Can I Build Chat with Vba? (0 replies)
  66. macro to save cells to another sheet (0 replies)
  67. [SOLVED:] Populate multiple textboxes (0 replies)
  68. VBA R1C1 help on vlook up (2 replies)
  69. [SOLVED:] Removing extension (.xlsm) when converting to PDF (4 replies)
  70. Using a loop to run through Adding Freeform Nodes (1 replies)
  71. Database Style (3 replies)
  72. Copy and paste images from excel to word with VBA (1 replies)
  73. VBA: Copy and paste row data in multiple column if Sheet1 ID matches with SheetY ID (10 replies)
  74. [SOLVED:] How to count, sum and subtotal values in a filtered listbox? (3 replies)
  75. VBA TextBox Upon Opening, Adding Userform, Not Prompted After Initial Save (11 replies)
  76. How are these things done inside VBA Excel? (2 replies)
  77. Open specific folder based on cell value or create folder (14 replies)
  78. Extract Data from PDF to Excel in a format (2 replies)
  79. VBA Change FileName with Numbers sequentially (1 replies)
  80. Populating listbox with selected columns (19 replies)
  81. [SOLVED:] Duplicate Entries in Excel (7 replies)
  82. VBA to execute filter for future date ranges (6 replies)
  83. VBA for highlight & extract cells addresss where harcode mannual entry (8 replies)
  84. 'Send e-mail' bolt-on to existing VBA code (2 replies)
  85. [SOLVED:] EXCEL VBA - Open the Specific file and copy the Data by Vlookup and Offset (1 replies)
  86. Horizontal cell data to Vertical cell data excel formula (5 replies)
  87. VBA Countif help Passing Criteria through Array (1 replies)
  88. [SOLVED:] UserForm Label Text Direction (3 replies)
  89. Vba to execute what was done with conditional formatting (8 replies)
  90. Userform Textbox Number format (13 replies)
  91. [SOLVED:] Different granularity for dashboard (28 replies)
  92. [SOLVED:] combine macros and have access from my personal workbook (12 replies)
  93. Filtiring Dates in Listview (3 replies)
  94. [SOLVED:] RANGE OF CELLS TO IMAGES (1 replies)
  95. Copy and paste filtered rows (1 replies)
  96. String Manipulation to Sentence. (1 replies)
  97. [SOLVED:] Create copy button on userform that autofills information already entered on userform (9 replies)
  98. questions about ranges and refedit. (4 replies)
  99. VBA Pivot Grouping help (4 replies)
  100. Mismatch data - Dates issue for certain range (7 replies)
  101. [SOLVED:] Write array to row (not column) (7 replies)
  102. [SOLVED:] Transfering Values From Textbox to Textbox (14 replies)
  103. [SOLVED:] Formula to look for a cell phrase and add a cost (3 replies)
  104. SQL on Excel Table (5 replies)
  105. vba using on android (2 replies)
  106. Problems with Object Variable or With block variable not set (9 replies)
  107. Next without For error (39 replies)
  108. copy cell value from one sheet to another sheet (1 replies)
  109. [SOLVED:] How to get name of Option Button created dynamically (7 replies)
  110. Update Sheet2 based on date/time values in sheet1 (1 replies)
  111. Reference large spreadsheets without opening them (1 replies)
  112. Copy and paste a row in a new worksheet VBA (4 replies)
  113. Vlookup Choose for 3 table after criteria macth (5 replies)
  114. add a new event to an event change macro (7 replies)
  115. Create Bookmarks from cell names when saving as pdf (2 replies)
  116. Runtime Error (2 replies)
  117. Clear cell data that does not contain specific value (11 replies)
  118. Open latest, partial named file in folder. (4 replies)
  119. [SOLVED:] Save as pdf's (15 replies)
  120. How do you write to worksheet in Excel 2007 (4 replies)
  121. [SOLVED:] AdvanceFilter- Multiple Criteria in one Cell (7 replies)
  122. VBA - Find and find next and sum their value help. (3 replies)
  123. Update Shopping list Fills by looking up on another workbook Using VBA (2 replies)
  124. Prevent to modify file extension (3 replies)
  125. [SOLVED:] Hide and unhide columns according to number of days in my calendar (5 replies)
  126. [SOLVED:] VBA update and clear the value without delay (9 replies)
  127. [SOLVED:] ADODB not getting all the data from one field (18 replies)
  128. VBA Browse multiple workbooks how to short the code.... (3 replies)
  129. Pass parameter into SQL statement in Power Query (1 replies)
  130. Duplicate the sheet and updte the Master (2 replies)
  131. Copy Sheet to New WB but Macros still point to sheet in WB (1 replies)
  132. Paste contents into cell that has color (7 replies)
  133. [SOLVED:] How to unhide Sheets based on 3 cell values (5 replies)
  134. How to have excel add any new data in a pivot automatically (1 replies)
  135. Extract author and date from web page (3 replies)
  136. VBA open another Workbook copy and paste if condition is met (0 replies)
  137. [SOLVED:] Check if Plink.exe is active (1 replies)
  138. [SOLVED:] Shell( .exe with input files) (9 replies)
  139. logic operator bug, I've never had anything like this (2 replies)
  140. Sleeper: file with macro button to import and split the data in to multiple work bo (0 replies)
  141. Copy/Transpose/Paste Vertically Breaking on Blanks Macro (2 replies)
  142. [SOLVED:] crieria item in list to replace in another column (3 replies)
  143. Make Directory and File If doesn't exist? (4 replies)
  144. How to extract all data with same name (0 replies)
  145. If condition for stop printing sheet (1 replies)
  146. Lookup closest value azimuth (0-360°) value in specific range and return over 360° (0 replies)
  147. [SOLVED:] VBA coding help (7 replies)
  148. VBA - How to Cycle through Workbooks to Paste Columns To a Matching Worksheet (2 replies)
  149. % variation between two cells (0 replies)
  150. Change cell color based on other cell value (0 replies)
  151. VBA CODE for Subtract two cells (3 replies)
  152. Need to be able to move things in order based on sequence of events. (4 replies)
  153. Best VBA process for extracting data (2 replies)
  154. Refer to cells instead of hardcoding text and numbers (1 replies)
  155. [SLEEPER:] How to fixed box text in the excel? (1 replies)
  156. Copy all of the sheets in an array to a new workbook (5 replies)
  157. Complex Netting of Amount Against An Array (0 replies)
  158. Update Calendar Fills by Revolving Sequence Using VBA (21 replies)
  159. Popup to display warning message (7 replies)
  160. [SOLVED:] open worksheet from different worksheet cell (3 replies)
  161. Please help (7 replies)
  162. Extract unique text from cell - excel formula (11 replies)
  163. Copy from another program and past to Excel sheet (0 replies)
  164. [SOLVED:] VBA command button to auto generate outlook email (3 replies)
  165. VBA - Set background color (and text) according to column in another dataset (0 replies)
  166. Change the copy order in this VBA code (5 replies)
  167. Vba process entire row delete (11 replies)
  168. Opening XLSM file with Excel 2007 does not display content (13 replies)
  169. Debugging Offset within a Range? (5 replies)
  170. Searchable Drop-Down List Stops Working when Sheet Protected (0 replies)
  171. How can I paste specific rows and replace specific rows (10 replies)
  172. [SOLVED:] Change Value on Multiple Pivot Tables at Once (10 replies)
  173. Best way to handle duplicate records.... (2 replies)
  174. [SOLVED:] Select Current Row when a Condition is True in a For Each Loop (9 replies)
  175. [SLEEPER:] The number of users in the shared workbook (0 replies)
  176. [SOLVED:] Updating Win/Loss records with VBA Button (2 replies)
  177. [SOLVED:] Issue with VLOOKUP.....Working on 1 Cell but not the other cell.... (3 replies)
  178. [SOLVED:] Look up function vba? (10 replies)
  179. Select record and update (0 replies)
  180. After page break bottom border for all pages (0 replies)
  181. [SOLVED:] Move file by vba (3 replies)
  182. [SOLVED:] Arranging data that is in columns in a different dynamic way (31 replies)
  183. VBA Help (33 replies)
  184. Combobox's (39 replies)
  185. need macro for auto year workbook with auto months and dates (3 replies)
  186. Page break setup (3 replies)
  187. Clear the data (3 replies)
  188. Pulling data from MenaData and BioData in result sheet based on employee id (7 replies)
  189. VBA to use Format Painter from one row to another row (2 replies)
  190. hide/unhide column after criteria match (4 replies)
  191. filter data Automatically with wildcard characters string (2 replies)
  192. Popup UserForm, the custom message box, is not closed. (12 replies)
  193. Formula by vba (16 replies)
  194. How to automate an email process –ideas and or advice (5 replies)
  195. How to Sum Variable Columns and Rows Using VBA (0 replies)
  196. VBA Sheet Linking Issue (1 replies)
  197. Add border top and bottom row for all pages (6 replies)
  198. Turn Multiple OptionButtons as False (6 replies)
  199. Userform Enter key (4 replies)
  200. Reference a person in e-mail from VBA (2 replies)
  201. If Column X Contains Specific Text, Copy to Col X cell & del (2 replies)
  202. [SOLVED:] Connecting to phpMyAdmin SQL DB through SSH (0 replies)
  203. [SOLVED:] Delete row (3 replies)
  204. User Form Shown when open VBE Editor (1 replies)
  205. Copy paste (6 replies)
  206. Unhide sheet with password protection (1 replies)
  207. Dlete row (7 replies)
  208. Delete Blank Rows and Add Borders on Last Row (9 replies)
  209. Suggestions for Creating Hundreds of Data Lines for Budget (13 replies)
  210. SQL query run on Excel VBA (0 replies)
  211. [SOLVED:] How do I avoid selecting Shapes? (2 replies)
  212. Scatter graph based on pivot table (0 replies)
  213. [SOLVED:] NEED HELP IN GETTING MACRO TO WORK NON SPLIT DATA MACRO (2 replies)
  214. Search for data in different wrsht and paste result to other column in original wrsht (2 replies)
  215. [SOLVED:] Refreshing linked cells to 3 workbooks on different pc's (2 replies)
  216. Concatenate Conditional Long String in Formula (5 replies)
  217. Drop-Down List to Display Different Pivot Tables (3 replies)
  218. [SOLVED:] Copy data based on a certain criteria (2 replies)
  219. [SOLVED:] String Array (7 replies)
  220. extract after multiple criteria (10 replies)
  221. Copy paste csv to xlsx (2 replies)
  222. Copy paste (6 replies)
  223. [SOLVED:] Assistance required to resolve ComboBox_Change issues (5 replies)
  224. Search for data based on cells in another worksheet and copy data to another wrksht (6 replies)
  225. Delete Partially Duplicate Rows based on Multiple Values (4 replies)
  226. Defining names in VBA using for loop (6 replies)
  227. Print multiple sheet as single pdf page (22 replies)
  228. [SOLVED:] How to Open a Picture using Windows Photo Gallery (2 replies)
  229. Inserting lines in text file according to a list (1 replies)
  230. [SOLVED:] Open File not working (2 replies)
  231. VBA code help - concatenation (1 replies)
  232. Pivot report filter with wildcard (4 replies)
  233. Move Filtered Data & Get series of Numbers (0 replies)
  234. Macro to parse a file and input in a spreadsheet the lines that match parameters (2 replies)
  235. VBA to load specific cells from one doc to another (0 replies)
  236. Stgange overflow error (3 replies)
  237. VBA Coding help please (2 replies)
  238. How to invert and copy data from a cell? (3 replies)
  239. Move all files on XX Folder to XX Folder based on excel. (5 replies)
  240. vba - Create subfolder as per monthwise and one Masterworkbook (1 replies)
  241. Fill down name according to column B (1 replies)
  242. I get the error with that if condition. (1 replies)
  243. [SOLVED:] Issue with Excel Division of Fractions..Not showing correct results (7 replies)
  244. I can't find a control (8 replies)
  245. Compare two sheet , i.e import sheet and htmlcopy sheet and give result in third she (1 replies)
  246. [SOLVED:] Renaming Word Document from Excel VBA (3 replies)
  247. [SOLVED:] VBA Code Require - Consolidate multiple sheets in 1 sheet when column Headin differs (27 replies)
  248. how to filter all dates between two dates (4 replies)
  249. Copy and paste in one worksheet by conditionqq (4 replies)
  250. Add In Preferences (1 replies)