View Full Version : Excel Help
- If Checkbox is checked, display message... If checkbox is unchecked, do nothing (4 replies)
- [SOLVED:] loop through range inserting sum formulas based on start and end indicators (text) (1 replies)
- Updating VBA code to Paste Values only (2 replies)
- [SOLVED:] Loop Vlookup for each cell in range from another worksheet (2 replies)
- [SOLVED:] Highlight minimum value ignoring 0 (7 replies)
- Error checking on existing roster (4 replies)
- [SLEEPER:] Folder and cell value (0 replies)
- XML Map Export and Save (0 replies)
- transfer if there are no blank cells (0 replies)
- Assistance needed for converting formula in Array VBA. (2 replies)
- vlookup from Last Modified File in Folder (0 replies)
- Refresh item data in IRibbon combo box (0 replies)
- [SLEEPER:] Worksheet object onClickEvent with changing cells issue (1 replies)
- [SOLVED:] Help to amend vba to highlight any cells where file paths do not exists (2 replies)
- Dynamic dropdownlist from productlist (2 replies)
- Insert Multiple Picture into excel thru vba (3 replies)
- Copying vales with their number format from Excel into a word table (0 replies)
- [SOLVED:] Using Application.Run (4 replies)
- [SOLVED:] sum data based on dates from sheet to another (4 replies)
- How do I link a cell to 2 non-bold cells and 1 bold cell and keep that formatting? (13 replies)
- Excel pivot fields recognition issue (0 replies)
- Convert Excel range into HTML table (2 replies)
- Automatically Printing Autofilters / loop through all filter values then print vba (1 replies)
- Advice needed to speed up Painting code based on defined colors. (12 replies)
- Index Match to Determine Paste Location (1 replies)
- [SOLVED:] Object Required Error when Selecting Range (1 replies)
- [SOLVED:] Anomaly With Formula (1 replies)
- User Form error (4 replies)
- VBA Help (0 replies)
- [SOLVED:] copying images from one folder and pasting in another based on schedule in excel file (4 replies)
- Combine specific sheets from multiple workbooks into 1 workbook. (12 replies)
- [SOLVED:] 3 columns matched create report (1 replies)
- [SOLVED:] Dynamic Array not Resizing (3 replies)
- [SOLVED:] VBA to Find Maximum Value in a Range (3 replies)
- [SOLVED:] Formula assistance required. (8 replies)
- [SLEEPER:] Adding a sum total to a Ron de Bruin VBA to email workbooks (1 replies)
- Copy data range to a new workbook (2 replies)
- OLAP pivot table vba filtering using VisibleItemsList (1 replies)
- [SOLVED:] Changing numbers with scientific notation (E+) in pivot table created by VBA (5 replies)
- [SOLVED:] Find column header (1 replies)
- VBA Copy paste Images from one cell to another cell on a different sheet (0 replies)
- Duplicating Multiple sheets to all workbooks in folder (1 replies)
- VB on Time (3 replies)
- [SOLVED:] VBA -Identify blank fields for user form before submitting -Force User to add data (7 replies)
- Transpose 1 Column to Multiple Rows/Columns (2 replies)
- Put NA on week dates IN RANGE (0 replies)
- Roster Automation (0 replies)
- VBA - Opening File with Yesterday's Date (1 replies)
- Count number of users active each mont (0 replies)
- Text Wrapping - Stuck for a solution (1 replies)
- VBA to arrange response value in large database (4 replies)
- [SOLVED:] Return to Cell in Column A after entering value in Column Z (2 replies)
- Validata Lists using offset, match and counta formulas - Different Sheets (0 replies)
- Does Excel 2007 SP3 work without issue on Windows 10? (2 replies)
- create uninterrupted sequences of 2,3,4,5,6,7,8. from 01 to 25 goal. (3 replies)
- How to subtract number of hours from 24 hour timezone in alphanumeric format (9 replies)
- VBA Code to pull data dynamically from multiple sheet tabs (0 replies)
- Looking to condense data with quantity totals (5 replies)
- Sleeper: Compare two sets of data with multiple conditions (0 replies)
- [SOLVED:] Excel VBA to create a series of new pivot tables (3 replies)
- Search in Excel specific word, delete all rows who does not have that word (1 replies)
- Transfer the values from one sheet to another by adding them to below of previous row (1 replies)
- Single & Double-Click a Shape Object (2 replies)
- [SOLVED:] transferring a column from sheet to sheet with the help of button (3 replies)
- Perform action with dynamic ActiveX button (0 replies)
- Assigning a value to the specified cells? (1 replies)
- Change all Workbook Connection Strings (4 replies)
- [SOLVED:] Stacked Chart Percentages (1 replies)
- Convert a formula to UDF Function (17 replies)
- Sleeper: Copying a Value to an Addess Reference which is Nested in Another Cell (8 replies)
- [SOLVED:] Calculating between 2 worksheets (7 replies)
- [SOLVED:] How to remove rows based on filters? (5 replies)
- Excel VBA problem on application.inputbox that returns range (4 replies)
- [SOLVED:] VBA - hiding column based on value of cell (2 replies)
- [SOLVED:] adjusting code search files into folder and sub folder (22 replies)
- Filter based on two columns (2 replies)
- Total dummy when it comes to VBA, so hoping someone can help! (15 replies)
- Calendar to bring the Leave Type from Leave Data to Calendar (3 replies)
- [SLEEPER:] Last update field formula on Google sheet (1 replies)
- VBA - Count # of cells in Column B that are greater in value than in Column A (2 replies)
- [SOLVED:] Value from UserForm to Worksheet - Accounting format - (How to?) (8 replies)
- find replace (5 replies)
- Hundreds of sheets, trying to loop through and extract specific columns (12 replies)
- Need help to Code VBA using the combination of text and date format (2 replies)
- [SOLVED:] How to copy the most current file from one folder to another (5 replies)
- text in cell in condition (1 replies)
- Put NA on cells with dates before indicated start week (5 replies)
- Insert new row for breakdown detail data (1 replies)
- CommandButton1_automatically update the date in ("A") column (3 replies)
- Finding Keywords from Text String - Formula (3 replies)
- [SOLVED:] if cell value in range = "code" then copy paste value to last used row another sheet (17 replies)
- fixing show message when open workbook from dialog to copy data (6 replies)
- [SOLVED:] VBA error: Run time error "424":Object require(pull data from HTML Element) (2 replies)
- [SLEEPER:] Hilbert Curve VBA (1 replies)
- [SOLVED:] RE: VBA auto filter Iterate through each criteria (1 replies)
- [SOLVED:] Sorting one Column in a Table (9 replies)
- Maximum Limit for MMULT() (4 replies)
- Sum function in other sheet (3 replies)
- How to a reference to a new sheet in same workbook (4 replies)
- Listbox and name manager comparison (2 replies)
- Arrays in VBA errors (2 replies)
- Searching for Macro (5 replies)
- Userform problem : makes excel crash (2 replies)
- [SOLVED:] Userform textbox skipped in tab order after re-enabling - unwanted behaviour (8 replies)
- [SOLVED:] ComboBox Function Lost (6 replies)
- Target cell vs specific cell (1 replies)
- Link organs in an array to shapes as they are created (0 replies)
- [SOLVED:] Loop through UserForm Controls and perform Different actions depending on ... (9 replies)
- vba help - to make sumifs formula dynamic (0 replies)
- Move files from different folders to single folder and delete the original files (5 replies)
- [SOLVED:] Display count of months in year which has 31 days in Message Box (3 replies)
- Excel 2007 VBA: Having trouble ungrouping a newly loaded object (9 replies)
- VBA Code will not update as target cell is updated using a formula (3 replies)
- [SOLVED:] VBA progress bar help (5 replies)
- Set statement (4 replies)
- copy paste the data if condition matches (0 replies)
- Cant get VBA Code to work. Would appreciate help. (7 replies)
- Need help with Objective Type questions (Quiz) (3 replies)
- AutoFill Only Specific Cells (0 replies)
- Select last empty row with header (3 replies)
- split counting (4 replies)
- Using Find function in VBA (7 replies)
- Getting Key value from last occurrence of another table (5 replies)
- Deleting Duplicates based on Active condition (1 replies)
- Copy specific data from a row based on value in column A (6 replies)
- Use VBA code in a locked worksheet (3 replies)
- refreshing sheet "under" modally shown useform (3 replies)
- [SOLVED:] Check if Value Exists in Another Sheet (6 replies)
- [SOLVED:] Formulas: If(AND( , OR(NOT(COUNTIF now working correctly (6 replies)
- inputbox vs excel shift + space shortcut (2 replies)
- [SOLVED:] Clear all items in listbox column (2 replies)
- [SOLVED:] Excel 2007: Trying to change images' rotation after loading without selecting first (4 replies)
- copy and paste value with condition (7 replies)
- Help with vba chart (0 replies)
- [SOLVED:] VBA 2007: How to get object name when inserted in order to delete later (14 replies)
- copy and rename a folder and its contents based on a cell value. (2 replies)
- [SLEEPER:] VBA multiple SQL queries (2 replies)
- Data separation (9 replies)
- [SOLVED:] Excel filter not working due to blank values in the column (3 replies)
- [SOLVED:] COPY/PASTE SPECIFIC DATA INTO GROUPS ON NEW SHEET (4 replies)
- Macro Undo Command (9 replies)
- Chart legend entries delete reappear (0 replies)
- Click Login button using VBA (0 replies)
- Replace kill command with save command and be able to format date (0 replies)
- Import .txt File with normal Space Delimiters (9 replies)
- Filter Specific data (0 replies)
- [SOLVED:] Master file detail list (5 replies)
- [SLEEPER:] Revising A VBA Code (1 replies)
- Generate Condition CSV File (2 replies)
- [SOLVED:] Invalid picture (0 replies)
- Reading text files and assigning values (2 replies)
- [SLEEPER:] VBA Macro to add values by date (2 replies)
- Improve Efficiency of VBA Code (21 replies)
- [SOLVED:] Change Excel's own user forms, is it possible? (2 replies)
- Save multiple ListBoxes to PDF (3 replies)
- [SOLVED:] Automatic Timestamp Insertion Application.Undo (3 replies)
- RC FORMULA HELP (2 replies)
- HELP with Conditional VLOOKUP (1 replies)
- Excel chart links in office 2007 (0 replies)
- Decipher Macro (1 replies)
- Sleeper: Gantt...mouse over (0 replies)
- How to Copy-Paste from a dynamic range to fixed one based on cell value using VBA? (3 replies)
- Making new EXCEL file with value only by copy from other excel (3 replies)
- export and print multipe specific sheets as pdf (15 replies)
- get Sunday's date between 2 dates (2 replies)
- Command button to go to another sheet with drop button click (1 replies)
- [SOLVED:] vba code for an interface (4 replies)
- Applying VBA code written in module to all sheets in workbook (3 replies)
- Computing Monthly Weighted Average (10 replies)
- Header/Footer sticking to other ranges (1 replies)
- Save As function randomly replaces my file path, Error 1004 (4 replies)
- Worksheet Change event not working unless cell is manually changed (1 replies)
- Simple If Statement: Comparing function argument (1 replies)
- Workbook.SaveAs function, appends number to similar named files (1 replies)
- [SOLVED:] error on Password User form by workbook Entry (9 replies)
- Creating a Pivot Table Based on Two Tables (2 replies)
- Return specific cell in that row using row number (3 replies)
- [SOLVED:] loop and sum (8 replies)
- [SOLVED:] Changing Data Layout Excel VBA (2 replies)
- [SOLVED:] Searchable listbox - Multi column - additem to second column only works first time (5 replies)
- PDF Merger Sequence (0 replies)
- Vba, How can code the excel file to save as only and disable to save directly file (2 replies)
- Macro works via step through but does not on button click (2 replies)
- Getting selected items in embedded listbox (3 replies)
- [SOLVED:] Progress Bar VBA (24 replies)
- [SOLVED:] simple password protection with User Form, with possibility user can change Passwort. (0 replies)
- Importing files will format data (5 replies)
- VBA - Search For Value Across Multiple Worksheets (83 replies)
- Using userforms (14 replies)
- [SOLVED:] Delete worksheet activex listbox (12 replies)
- Problem comparing dates in VBA (1 replies)
- Graphical hiearchy (7 replies)
- Calendar with userform input stores irrelevant data to its table (5 replies)
- Sorting Help (2 replies)
- [SOLVED:] Conditional Formatting on a table based on a different table VBA (16 replies)
- [SOLVED:] VBA - Disable/ activate command button depending on Text box value (3 replies)
- [SOLVED:] Delete rows when copying table (7 replies)
- [SOLVED:] Ordering worksheet tabs in a specific order (6 replies)
- VBA to make formula for parent child (7 replies)
- User Form (2 replies)
- Rename the add-in caption on menu bar (0 replies)
- [SOLVED:] Get All Most Recent Dates per Month in a Single Column VBA (16 replies)
- [SOLVED:] Loop through listbox to insert to sheet (6 replies)
- I need help on scrolling down web pages through vba query tables (0 replies)
- [SOLVED:] PIVOT TABLE TROUBLES - Code runs on one workbook but not the other (2 replies)
- Sleeper: Importing multiple files to excel (0 replies)
- VBA Newbie looking for linear or polynomial fit to missing dats (19 replies)
- [SOLVED:] find listbox column Average (2 replies)
- [SOLVED:] sum digits (9 replies)
- [SOLVED:] update listbox (4 replies)
- PDF to excel (1 replies)
- [SOLVED:] Issue creating pivot table from table data (2 replies)
- [SOLVED:] Autofit last column in a table (6 replies)
- VBA Help using value in sheet 1 to hide unhide row in sheet 2 (9 replies)
- [SOLVED:] Excel - Edit contents of a string (7 replies)
- [SOLVED:] Excel - Make user opened file the active workbook (13 replies)
- [SOLVED:] select next emtpy column (10 replies)
- [SOLVED:] Find Last Value (not first) (9 replies)
- [SOLVED:] Hide specific rows in various worksheets depending on Summary worksheet cell value (3 replies)
- Duplicate Values in Data Validation (7 replies)
- VBA Pasting from table to different sheets without using sheets("x").Select HELP!!! (3 replies)
- Building up sentence variable within cells (4 replies)
- [SOLVED:] concatenate variable values (1 replies)
- [SOLVED:] Hide textbox with selected item in combobox (5 replies)
- 3 Reference Formulas Not Returning a Result (14 replies)
- Hyperlink warning message (9 replies)
- [SOLVED:] Complete data of a master table without overwriting given data (12 replies)
- Text in textbox only updates once (1 replies)
- [SOLVED:] How to set currency with different starting values (68 replies)
- Writing array to sheet (10 replies)
- After clicking the linked cell to move back linked cell without using F5+Enter (2 replies)
- Split comma to rows (15 replies)
- [SOLVED:] Insert Picture from Directory on Cell Value Changed by Formula (20 replies)
- VBA script to search a text in google maps (0 replies)
- Add Table to Data Model (Pivot Table) (0 replies)
- Trim rows in multiple sheets (2 replies)
- Conditional Formatting using formula as condition (4 replies)
- [SOLVED:] How to pull XML data into another excel sheet using VBA? (54 replies)
- Cut Data Once It Has Been Selected (3 replies)
- [SOLVED:] index/match based on variable range (2 replies)
- [SOLVED:] Change font size of rows in a range with bold letters (20 replies)
- [SOLVED:] Data Validation based on Condition(s) in Excel VBA (15 replies)
- [SOLVED:] Write part of 2D Array to Sheet (3 replies)
- [SOLVED:] Putting a time limit on QueryTable.Refresh (1 replies)
- [SOLVED:] Part of a string (7 replies)
- [SOLVED:] Formula to fill down used range (5 replies)
- Only the string (3 replies)
- [SOLVED:] Excel Formula to compare between actual values and target values (3 replies)
- sumifs filtered data (4 replies)
- Basic VBA Function to calculate the volume of a cone (5 replies)
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.