View Full Version : Excel Help
- 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)
- 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)
- 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)
- 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)
- 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)
- 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)
- 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)
- Error in user form (5 replies)
- range sort horizontal range (5 replies)
- Filling out specific cells thanks to a UserForm (0 replies)
- How can I use the VBA-Excel function NORMINV with variables? (3 replies)
- help with UDF Function (35 replies)
- [SOLVED:] A simple VBA "for each" loop with "call" function issue (3 replies)
- [SOLVED:] Help : Replace O365 Dynamic Arrays Dashboard with VBA Codes (2 replies)
- How to search through multiple worksheets and display the results to your listbox (1 replies)
- Move Files from current folder to a new subfolder specified in a column (4 replies)
- RE: Pivot filter Month selection - Automatic Population in respective column (6 replies)
- VBA code to filter a specific column (0 replies)
- Paste data to another tab based on meeting criteria (3 replies)
- Automatic update of pivot table wiht error - EXCEL (0 replies)
- Blinking Cells when I reach a certain value (4 replies)
- Extracting specific lines from multiple text files and save it in a single excel shee (2 replies)
- Paste without source file name (4 replies)
- Data to blank cell (0 replies)
- Excel Macro help (2 replies)
- Copy Paste Selected Rows (1 replies)
- Left/Right formula not working (18 replies)
- [SOLVED:] Help : Stop Application.onTime before this workbook close (3 replies)
- [SOLVED:] Stop macro running if row empty (2 replies)
- Prevent VBA from activating the sheet when it updates a chart. (0 replies)
- [SOLVED:] Predict Date of Enlistment (53 replies)
- [SOLVED:] Copying Down Formulas to New Row (9 replies)
- Sleeper: Filtering by some specific value (0 replies)
- [SOLVED:] Advanced locked Filtering data (0 replies)
- I want to copy and paste a chart together with its linked-to data? (1 replies)
- Log the results (29 replies)
- Help to moving file to another folder, using partial filename (0 replies)
- [SOLVED:] Search worksheet for multiple strings of text, then delete those rows (29 replies)
- [SOLVED:] Extract Value from Text (3 replies)
- [SOLVED:] Condition Base Min & Max (2 replies)
- PasteSpecial options (2 replies)
- Populate fields based on the filter (8 replies)
- [SOLVED:] Need some help with the Regular Expression (2 replies)
- VBA form - Choose an item from 2 list boxes to select one row (0 replies)
- Count left alignment cell (2 replies)
- [SOLVED:] VBA Conditional Formating - Cell 1 format based on Cell2 <= other worksheet cell3 (14 replies)
- Adding and Compressing(SizeKb) Image to Comments Field (2 replies)
- Vba search function not pulling links through. (4 replies)
- [SOLVED:] Search for specific words in worksheet and make bold (1 replies)
- Web scrapping vba (0 replies)
- Macro to create a database (3 replies)
- [SOLVED:] Execute submacro a set number of times until criteria is met (4 replies)
- Convert numbers into words for printing checks (1 replies)
- Automatic changing of cell colors (1 replies)
- Need Help with VBA code - Excel (7 replies)
- Please Help ( vba combobox code ) (1 replies)
- [SOLVED:] Highlight Cell With Search Values (4 replies)
- [SLEEPER:] Found max number (1 replies)
- Help with some code? (1 replies)
- [SOLVED:] Passing variables between modules (8 replies)
- Copy data from folder and sub folder to master workbook base in sub folder names (0 replies)
- Advanced find mewthod with copying values (0 replies)
- How to parse json GET request with VBA? (3 replies)
- [SOLVED:] VBA code to speed up and automate multiple account, multiple site stock movements (26 replies)
- [SOLVED:] How to compare two arrays row by row? (16 replies)
- [SOLVED:] Help : Join String with Delimiter - need to have the option of downward or rightward (18 replies)
- Replace XML Null values (0 replies)
- [SOLVED:] Help : Apply formula to selected cells (2 replies)
- Limit Detailed amounts based on original balance (4 replies)
- [SOLVED:] Run Submacro If It Contains Data (23 replies)
- [SOLVED:] How far is the first occurrence of a coloured cell (2 replies)
- VBA Exponential Smoothing (8 replies)
- [SOLVED:] Left align text in joined cells (4 replies)
- [SOLVED:] Help Required : Highlight a part of text with in a cell (case sensitive problem) (2 replies)
- [SOLVED:] Run-time error '13' after several succes runs (3 replies)
- [SOLVED:] Help required in replacing InputBox with Select any one option (2 replies)
- [SOLVED:] Create a Hardcoded Workbook Copy (11 replies)
- amending code copy data from sheet to multiple without repeating (4 replies)
- Can’t find project or library - Microsoft Forms 2.0 ticked in error? (22 replies)
- [SOLVED:] Find each occurrence of a set of numbers in column and highlight the rows that contai (4 replies)
- sum only red fonts (5 replies)
- SUMIFS with Multiple criteria using Variables (4 replies)
- [SOLVED:] Difference between two 2D Arrays in VBA (10 replies)
- [SOLVED:] Fields mandatory (9 replies)
- [SOLVED:] Search Textbox (2 replies)
- COPY CERTAIN COLUMN IF ROW CONTAINS CERTAIN DATA FROM EXCEL TO WORD (1 replies)
- [SOLVED:] Looking in subfolders instead of root folder only (9 replies)
- [SOLVED:] filter and sum values based on three selection from dropdown (18 replies)
- [SOLVED:] Standard CTRL+C in ListBox (7 replies)
- [SOLVED:] VBA Macro - Import data from different excel file for a given value (3 replies)
- [SOLVED:] VBA for find values in range in multiple worksheets, copy values to UserForm (5 replies)
- automatic sort of a table, return to last used cell (2 replies)
- Delete Columns with blank or zero in total (2 replies)
- [SOLVED:] VBA Macro - pull two data sets, in the same column, to a separate spreadsheet (5 replies)
- [SOLVED:] Filter a txt file based on an Excel template (11 replies)
- VBA Help - Auto generate multiple rows base on cell value (3 replies)
- Help Required in Create and Open Folder and Track Changes (2 replies)
- VBA/Macro to insert rows based on drop downlist selection (4 replies)
- Finding the best rank of places to find the best path (using geographical coordinates (3 replies)
- [SOLVED:] VBA Check for multiple cell values and copy the cell in column A (6 replies)
- HELP!! CHALLENGING: FINDING BEST PATH TO TAKE (1 replies)
- vba help - show Top 3 performer (3 replies)
- [SOLVED:] Table Of Contents - Help required to customize the code (7 replies)
- Create user input box for range row in Excel (1 replies)
- VBA to search for different value in all worksheets and then write down where they ar (6 replies)
- [SOLVED:] Vba look for certain value and copy certain cell value in the same row (3 replies)
- Restrict Replace Module (12 replies)
- [SOLVED:] Requesting help to correct the codes (4 replies)
- Conflicting Code (Add Row & Move Row to another Worksheet) (5 replies)
- How to move data between date rows using VBA? (5 replies)
- [SOLVED:] Paste to next empty row in another workbook (3 replies)
- [SOLVED:] VBA to add new row above and include formatting (2 replies)
- save from template to range value name workbook (1 replies)
- Sum with integer (5 replies)
- [SOLVED:] Delete Hidden Rows when Filter applied (2 replies)
- [SOLVED:] VBA Sum function NOT calculating small values (3 replies)
- Converting three calculators in a workbook into one with a dropdown box (hardcoded) (7 replies)
- Disable SAVE/SAVE AS and Make Savable Again after Username and Password (12 replies)
- Array of unique values in a Column range (18 replies)
- VBA (1 replies)
- Formula Assistance Required (2 replies)
- [SOLVED:] Creating an 11 digit number (14 replies)
- Macro to copy a cell value and put in different worksheet (0 replies)
- What function should I use? (7 replies)
- Truncate Data in Excel VBA to prompt Pass or Fail (6 replies)
- Auto Filter Data from Multiple Worksheets Using only One Combobox (6 replies)
- Trouble sorting as part of a Macro (5 replies)
- Generating a table of events based on a calendar on a different worksheet (2 replies)
- Is there a way to protect or lock my macro? (2 replies)
- How to hide/unhide worksheets based on cell value? (0 replies)
- excel to pdf print (10 replies)
- [SOLVED:] HELP - Calculate Based on Dynamic Variables (What-if Scenario) (5 replies)
- [SOLVED:] Debugging VBA built on Excel2013 not working on v2016 (3 replies)
- VBA Code Copy&Paste Request (5 replies)
- [SOLVED:] RE: Pivot table creation in existing sheet- VBA issues (19 replies)
- VBA look for cell next to first blank, copy and paste (3 replies)
- Macro to find best way to combine numbers to equal a certain sum (3 replies)
- [SOLVED:] VBA code to calculate dates from an event (2 replies)
- [SOLVED:] Object Required Error in UnHiding rows (6 replies)
- Change alignment (4 replies)
- VBA code to open workbooks in a folder, create new sheet, paste headers and formulas? (4 replies)
- VBA Time Stamp for single cell entry (1 replies)
- Xlsm file problem (7 replies)
- [SOLVED:] Custom Sort On Column (7 replies)
- VBA Sum Array Formulas (13 replies)
- Sleeper: VBA Macros 438 runtime error (1 replies)
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.