View Full Version : Excel Help
- Create a loop in VBA to copy data out of different files (11 replies)
- [SOLVED:] Not Working : Sum of Hours (6 replies)
- [SOLVED:] Change format of ConvertDegrees function (11 replies)
- VBA Command (6 replies)
- product csv from sheets (1 replies)
- [SOLVED:] Searching for multiple texts within a cell (InStr) (7 replies)
- VBA help to stop one code from affecting another (6 replies)
- [SOLVED:] Comma separated list from columns (7 replies)
- [SOLVED:] Formula to collect charges (4 replies)
- [SOLVED:] Superscript in a Function (4 replies)
- Excel 2019: Range.Find(Number) Trouble (5 replies)
- VBA Help with Multiple If conditions (14 replies)
- Print sales transaction receipt error (0 replies)
- [SOLVED:] Trying to allow a TextBox entry on UserForm store in variable (10 replies)
- Autofilter help needed - encountering Autofilter method of range class failed error (0 replies)
- [SOLVED:] Not Working : Opening an Excel workbook from SharePoint in edit mode from a user form (1 replies)
- [SOLVED:] How to do sequencing number after rows duplicated (12 replies)
- [SOLVED:] VBA Text Comparisons Identifying Differences (2 replies)
- Office 365: Application.CommandBars("Workbook Tabs").ShowPopup issues (5 replies)
- [SOLVED:] Highlight Matching Text in different cells (3 replies)
- [SOLVED:] Request help to find missing dates in a date range for the user (12 replies)
- [SOLVED:] Search column for specific value, then delete rows found, leaving the first instance (6 replies)
- [SOLVED:] Trying to make specific cell contents bold (5 replies)
- VBA and Excel Formula (0 replies)
- Collecting Data From Multiple Users (2 replies)
- Import, Filter and Sort Multiple Columns (2 replies)
- Excel VBA shift selected cells in various columns up/down for a specified number cell (3 replies)
- [SOLVED:] Not Working : Worksheet_Change Event (7 replies)
- Find Specific Word from the cell by referring a list (VBA) (3 replies)
- Rows to hide and unhide based on two columns (2 replies)
- Find the duplicate from one work book and remove the duplicates in another workbook (10 replies)
- Help : Date Picker in VBA user form and view data from data entry wb (2 replies)
- How to read in server name, software name and version from a text file (6 replies)
- [SOLVED:] editing VBA code (10 replies)
- How to Handle Blank cell value in VBA (2 replies)
- [SOLVED:] Pivot Tables: error in 'Field.CurrentPage = NewCat' (31 replies)
- Loop through column, range.copy to another sheet based on cell value (1 replies)
- vba for mac book pro (0 replies)
- [SOLVED:] Difficulty Changing Data with a Hyphen "-" (4 replies)
- With PivotTable: Count consecutive days that meet a criteria (6 replies)
- Not Working : VBA : Create folder and access files from One Drive (1 replies)
- [SOLVED:] error 1004 - VBA Delete column (4 replies)
- Axis Ticklables to ObjectThemeColor (0 replies)
- delete blank cells in every row individually (2 replies)
- [SOLVED:] UCase Help (3 replies)
- [SOLVED:] search files across multiple sheets and open & highlight (2 replies)
- Search for a file in folder and subfolders (mac version) (2 replies)
- [SOLVED:] help for VBA conditional formating count on correct color (8 replies)
- Import Second Excel file (1 replies)
- VBA - seet 1 cell value (H2) to copy paste in activecell column c sheet 2 (0 replies)
- Update a new sheet from Userform (4 replies)
- [SOLVED:] create sheets based on extensions files and copy to each months (27 replies)
- [SOLVED:] Help : Compare texts in two columns in the same row and get the similarity percentage (11 replies)
- Help with VBA Macro (5 replies)
- [SOLVED:] Can you lock one filter in a pivot table? (19 replies)
- How to move data from one variable to another (5 replies)
- VBA - conditional copying different column ranges (2 replies)
- [SOLVED:] Hyperlink formulas in VBA code - one is working and one is not (4 replies)
- Extracting data from json api (5 replies)
- [SOLVED:] Move Duplicates to Result Sheet (2 replies)
- UP/DOWN/INSERT/DELETE macros part of line (14 replies)
- Problem with Charts (3 replies)
- Hi. Need to copy/cut rows from sheet to another at top of dataset (9 replies)
- [SOLVED:] Hide rows when check box selected (4 replies)
- VBA to open excel-sheets, updating link, saving and closing (0 replies)
- A function that crashes: Compile Error: Procedure too large (19 replies)
- [SOLVED:] Merge Workbooks into one - Help in Folder Picker (7 replies)
- Swap last and first word in a sentence in an excel column (7 replies)
- Transpose using VBA (1 replies)
- [SOLVED:] Macro help - matching times to periods (4 replies)
- [SOLVED:] How to know form Option button name or number (4 replies)
- Export to CSV with New Name and Time Stamp (1 replies)
- Nested classes with dynamic array (2 replies)
- regexp to find multiple instances of the same structure term? (1 replies)
- [SOLVED:] Hide rows with option buttons (29 replies)
- Read all Excel files in a folder and edit them via UI (2 replies)
- [SOLVED:] SharePoint and SaveCopyAs method (1 replies)
- [SOLVED:] Cell is equal to another cell until you write something in it (50 replies)
- Help needed for layout display after calculation. (7 replies)
- [SOLVED:] Fill in a row until bottom of the table (2 replies)
- [SOLVED:] Extract dates from a cell containing a string of data (10 replies)
- lookup between different worksheet. (2 replies)
- Need Help Creating a Macro (11 replies)
- Why will macro will move pdfs and xlsxs but not msgs? (2 replies)
- VBA-Import text file of yesterday's date which is the file name (1 replies)
- [SOLVED:] VBA to Limit what Columns a User can View--Question about Security (2 replies)
- date Macro (7 replies)
- [SOLVED:] Splitting large range of data into multiple cost center outputs in txt-format (11 replies)
- help with vba code (9 replies)
- [SOLVED:] File Format and Extension Don’t Match (7 replies)
- [SOLVED:] Count based on two criteria from different columns (8 replies)
- [SOLVED:] Loop thru validation list - filter multi sheets - generate individual files (2 replies)
- fastest way to copy multiple range to multiple sheets (25 replies)
- Copy Rows with Certain Values (0 replies)
- [SOLVED:] VBA Help - Run-time error '-2147417848 (80010108)': Method 'Value' of object 'Range' (6 replies)
- [SOLVED:] Add extra worksheet (5 replies)
- [SOLVED:] Code only copies certain column. (6 replies)
- Excel 2016 VBA on MAC to Open A File (0 replies)
- Password to save worksheet as new workbook (2 replies)
- Copy & Append Paste from various workbooks into one master (0 replies)
- Need Help Highliting Some String in Cell and Columns With Macro! (2 replies)
- [SOLVED:] Function to Pass Workbook and Worksheet objects giving Type Mismatch Error 13 (7 replies)
- [SOLVED:] TRANSACTION RATE NOT SHOWING (7 replies)
- [SOLVED:] Code not Executing in Immedate Window--Copy and Paste are Disabled (4 replies)
- Excel Maximum Rows (6 replies)
- VBA script to insert new rows based on data in other cells, then rearrange data (3 replies)
- [SLEEPER:] Userform refresh after change source cell (3 replies)
- Transaction Rate show up (0 replies)
- [SOLVED:] VBA Help in Cash flow forecast (9 replies)
- Autofilter in Multiple sheets - copy to new workbook - save workbook by field name (0 replies)
- HIDE UNHIDE automatically in others sheets (14 replies)
- Help with Excel Macro to computer investment return (2 replies)
- Excel VBA Code help (2 replies)
- [SOLVED:] Run time error 424 object required (1 replies)
- [SOLVED:] run time error 1004 Pastespecial method of range class failed (3 replies)
- [SOLVED:] run time error 13 Type mismatch (8 replies)
- C# to VBA macro in excel (4 replies)
- [SLEEPER:] ReTry (3 replies)
- [SOLVED:] Runtime Err 91 (3 replies)
- [SOLVED:] Flag if Value (2 replies)
- [SOLVED:] Run-time error 438: Object doesn't support this property or method (5 replies)
- [SOLVED:] How to refer to an existing Worksheet Name (9 replies)
- Can anybody please show me how to loop the following macro until a cell is empty (4 replies)
- [SOLVED:] VBA code for deleting "FALSE" functions (16 replies)
- How to copy values from multiple cells into one row in SAP (1 replies)
- Help me to pull random samples from the data source using VBA (1 replies)
- [SOLVED:] check calculation state on workbook open (6 replies)
- HMAC SHA1 algorithm (4 replies)
- Dependant ActiveX comboboxes filtering multiple pivot tables Issue (9 replies)
- Importing csv data from multiple source files into a master workbook into resp sheets (11 replies)
- VBA XLOOKUP to use text before semicolon (2 replies)
- VBA Calender - Add Date to Text Value instead of Activecell (5 replies)
- [SOLVED:] ActiveX Option Buttons No Longer Function After Hide Then Unhide Rows (5 replies)
- extracting a string from a line of text (13 replies)
- [SOLVED:] Pop-up Message Box when certain values are inputted in Column A (5 replies)
- vbModeless question (2 replies)
- [SOLVED:] Round Up the answer to a calculation which is being performed in VB (5 replies)
- [SOLVED:] Best way to use lookup to find last value in column of another sheet (3 replies)
- add a new row based on selected on combobox and copy data (0 replies)
- IF Then ElseIf Else Statement macro (17 replies)
- [SOLVED:] Several Groups of ActiveX Option Buttons - How to Identify Selected Button in Each (5 replies)
- [SOLVED:] Adding on to existing macro, Need IFS function and filter (0 replies)
- VBA Edit Links (34 replies)
- [SOLVED:] Is there a way to insert a permanent VBA userform to excel (4 replies)
- VBA Excel paste special speed reduces over time while looping (0 replies)
- [SOLVED:] Subscript error when finding next blank row in added worksheet (3 replies)
- Multiple conditions for 3 consecutive ListBox - How to make it work? (5 replies)
- Email Active workbook with updates made (1 replies)
- [SLEEPER:] Vba To Refresh Specific External Connections (3 replies)
- Conditional Format Macro help (2 replies)
- Change Pivot Table Date Filter to Cell Reference (2 replies)
- Newbie needs help please (1 replies)
- fifo vba code please (9 replies)
- [SOLVED:] Transpose Data In Columns (8 replies)
- [SOLVED:] LISTING FILES IN FOLDER - INCORRECT ORDER (17 replies)
- [SOLVED:] two way dependent dropdowns.. possible? (2 replies)
- VBA Help - Reference to a Table & Vlookup (3 replies)
- Based on the Location & Quantity, Locations to be grouped & corresponding sum (1 replies)
- Type mismatch when using Application.WorksheetFunction.Match (9 replies)
- [SLEEPER:] Combine recursive listing with excluded code (124 replies)
- Help with weighted averages for scorecard (10 replies)
- Graph two data tables in one graph (1 replies)
- Why Excel commandbutton macro is too slow? (8 replies)
- [SOLVED:] Loop through column and conditionally subtract (9 replies)
- Copy data from one sheet to new - but paste only values without formating and links (4 replies)
- [SOLVED:] Audit plan for next 3Yrs : Mark X based on audit frequency and previous audit quarter (9 replies)
- [SOLVED:] Excel Chart. Display rows based on check boxes (2 replies)
- Subtracting a cell from hard coded values (on weekly basis) (5 replies)
- [SOLVED:] Please Help with Code (15 replies)
- [SOLVED:] Search string multiple sheets copy row to new sheet (2 replies)
- Identify / return name of Visible Chart Only (0 replies)
- how to get value of page, where exact cell is? (0 replies)
- EXCEL VBA to show images as comments (19 replies)
- [SOLVED:] SEARCH COPY AND LINK THE RESULT (0 replies)
- [SOLVED:] Trying to create a Macro to filter a set of data for streamlined work (See descpt) (3 replies)
- Copying information from listbox into textboxes in new form (5 replies)
- [SOLVED:] Macro to match cells in a range with those in another column. (2 replies)
- [SOLVED:] Load Item In Combobox with Diffrent color (Depended cell Color) (2 replies)
- [SOLVED:] Split words from text string and count occurrence of each word in a range in excel (20 replies)
- [SLEEPER:] WHat I am doing wrong.... (10 replies)
- Saving file in specific location (2 replies)
- Converting / reading a cell while filtering ( double .. Ccur ... ) (12 replies)
- Copying Data Between Sheets (2 replies)
- [SOLVED:] Formula help to list items based on criteria (4 replies)
- Input box and sheet (3 replies)
- [SOLVED:] Create a list in column G if specific text found in cells in column A (3 replies)
- VBA Split Cell to Array + VLookUp for Array (9 replies)
- [SOLVED:] Determing if a time of day falls between time of shift (4 replies)
- SUM multiple COLUMNS DATA with common HEADER NAME (5 replies)
- [SLEEPER:] Hidden rows (5 replies)
- [SOLVED:] Split number from an alpha numeric invoice reference and highlight duplicate (2 replies)
- VBA userform multiple textbox (2 replies)
- Data validation - does not save =OFFSET(lista_rep!$C$5,0,0,COUNTA.... (10 replies)
- VBA Excel - Filter selection “wrong” row (1 replies)
- VBA - Macro - EXCell getting it to insert a formula (offset) (6 replies)
- [SOLVED:] How to Create UDF (12 replies)
- [SOLVED:] Date Entry Not Being Correctly Interpreted (21 replies)
- Merge different Excel worksheet from different workbooks into one workbook (3 replies)
- CLEARING A LISTBOX AND PRINTING LISTBOX CONTENTS (1 replies)
- VBA to add prefix in Human Interface Device RFID tag reader (0 replies)
- [SOLVED:] exclude folder paths list (37 replies)
- Calling a macro within a macro (2 replies)
- VBA to Insert a character in a specific position in a cell (13 replies)
- Excel - Formula to stop counting based on another cell (2 replies)
- VBA for copying values with ActiveCell.Offset (9 replies)
- [SOLVED:] Find And Replace with Increment Number Excel VBA (3 replies)
- Filter data - date range and customer (5 replies)
- Custom Dialog Box "Show" method causes runtime Error on some Excel installations (14 replies)
- Last row is not advancing in worksheet (4 replies)
- Copy cells in col. B, D and F if there is contents in cells in col. D (1 replies)
- VBA editing automatically comments in protected sheet (1 replies)
- VBA Excel - Update Data using UserForm (0 replies)
- VBA Excel - Use UserForm even if the sheet is protected (5 replies)
- [SOLVED:] Multiple textboxes that only accepts numeric value (7 replies)
- how to make '"table" stay in the same page? (0 replies)
- [SOLVED:] VBA for create new folder based on multiple cells values (0 replies)
- VBA UDF required (4 replies)
- [SOLVED:] Want VBA Textbox information to show VBA MsgBox (2 replies)
- Create a procedure with combination of keys (0 replies)
- remove rows and columns (6 replies)
- [SOLVED:] Check if data is already exist before adding a new data (3 replies)
- AN error 481: Invalid pictur (1 replies)
- [SOLVED:] A Dashboard with my first independent codes - Request for review by other members (8 replies)
- [SOLVED:] with VBA create a function that accepts arguments in an excel sheet (1 replies)
- Blinking Cells when I reach a certain value (0 replies)
- [SOLVED:] Unchecked checkbox if cell is blank (2 replies)
- dividing a number into a given range (4 replies)
- Userform Dependent List Boxes (9 replies)
- [SOLVED:] Search data on another sheet using VBA (5 replies)
- Slow code (5 replies)
- [SOLVED:] How to Create Interactive Dashboard Tiles (5 replies)
- [SOLVED:] how make rowsources for multiple combobox from multiple sheets in the same colums (12 replies)
- Creating new Files based on some excel columns values (0 replies)
- [SOLVED:] Change column (5 replies)
- [SOLVED:] Is it possible to make it faster? VBA copy and paste when condition is met (5 replies)
- Delete duplicates from VBA Combobox (3 replies)
- Array loop through multiple rows/columns, find result, then repeat.. Help Needed! (1 replies)
- [SLEEPER:] Basic VBA code Help (1 replies)
- Help - Macro to add data to workweeks (1 replies)
- [SOLVED:] Target.Cells.Count - Change to Read a Range - VBA (1 replies)
- [SOLVED:] macro to fill a form and save one file per row in document (3 replies)
- [SLEEPER:] 2019 VBA: How to move files based on first or first two characters (6 replies)
- help debugging macro for my daily time tracker - copy/paste sheet at front of wk_book (0 replies)
- Help required for the mentioned modification in the attached code -Manpower scheduler (1 replies)
- compatibility vba 2016 VS vba 2019 (4 replies)
- How can I add a condition in my loop that does not work? (0 replies)
- VBA Dynamic Loop in Columns and Rows to find and copy values (1 replies)
- [SOLVED:] Search in multiple columns while Autofiltering - Excel VBA (2 replies)
- Need help with loop, concatenate and trim in Excel, VBA (5 replies)
- [SOLVED:] Smaller font size for a part of the cell value in loop (7 replies)
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.