View Full Version : Excel Help
- [SOLVED:] clear last but one line to a userform (12 replies)
- MoveLast ERROR (9 replies)
- VBA to make 1st column of a text to columns operation "CLEAN" (2 replies)
- Simplifying Code (7 replies)
- [SOLVED:] clear last line (2 replies)
- VBA - Copy and Paste Data Base into an existing Sheet (1 replies)
- Setting a Dynamic Table Range in a VBA (4 replies)
- [SOLVED:] VBA how to use date to write file name in PDF (13 replies)
- [SOLVED:] BUILD A SET OF DATA BASED ON SOME FILTERS (4 replies)
- [SOLVED:] Sum entire column by like IDs (3 replies)
- [SOLVED:] VBA - Copy Paste data to another sheet based on criteria (3 replies)
- Finding last cell in a column (2 replies)
- [SOLVED:] VBA - Concatenate columns with delimiter (7 replies)
- [SOLVED:] Adding odd numbers in VBA (2 replies)
- Discrete Time Conversion Problem (8 replies)
- [SOLVED:] Creating date and time stamp (5 replies)
- Sleeper: How can I automate arranging cell values by repeating and transposing values (8 replies)
- RE: Insert/Embed outlook mail using vba Excel (1 replies)
- [SOLVED:] RE: Excel Formula to update Account number based on signage using mapping key (8 replies)
- [SOLVED:] VBA help to move all images from a cell, not folder? (15 replies)
- How can I change the default chart callout color? - text & border? (2 replies)
- [SOLVED:] message appears in adjacent column when name appears in column A (10 replies)
- Selecting Sheets based on a VBA array (8 replies)
- [SOLVED:] VBA to Update Excel Workbook Properties (3 replies)
- VBA Macro: Text Split by defined # of characters - word dropping issue (7 replies)
- Object required error in dictionary (8 replies)
- VBA: What can cause of truncation of significant digits double precision variable? (17 replies)
- [SOLVED:] Need help with text to column like formulas (3 replies)
- Help! What is wrong? My code is not looping! (16 replies)
- Hello friends. Please help ! COUNTIF formula ? (3 replies)
- [SOLVED:] record # if data in other columns in same row (11 replies)
- Loop on Single cell (1 replies)
- Deleting duplicate values from two different columns (10 replies)
- Macro to consolidate data from different files in a folder (1 replies)
- Counting repetitions of string of words to counting group of words in one cell (1 replies)
- [SOLVED:] Geometric Brownian Motion Help (21 replies)
- [SOLVED:] Loop through inserting row from one sheet to another, at least 2 loops needed? (3 replies)
- [SOLVED:] Need code to copy data from closed workbook (2 replies)
- [SOLVED:] dependent dropdown list (4 replies)
- [SOLVED:] Insert a function to delete any words with less than 3 characters in a VBA code (11 replies)
- Add two arrays A and B with dimensions n×m. (2 replies)
- [SOLVED:] VBA find&replace with conditions (2 replies)
- Having a daily data entry sheet that autopopulates into a pivot table. (0 replies)
- a macro to Copy from multiple sheets to a new workbook without macro (4 replies)
- Comparing Two Workbooks Error (3 replies)
- [SOLVED:] Finding a specific file across several subfolders? (5 replies)
- SLOW VBA (20+ minutes) with many loops and VLOOKUPS. Help please. (17 replies)
- How to use part of filename without changing the filename (3 replies)
- [SOLVED:] Transposing a vertical table into a horizontal table (5 replies)
- sum columns form each sheets to one column in Main sheet (4 replies)
- Need help with NETWORKDAYS.INTL() (1 replies)
- Need help with TAT calculation (21 replies)
- Problem with Application.OnTime (5 replies)
- Sleeper: VBA function "sub not defined" (4 replies)
- [SOLVED:] loop sum (3 replies)
- [SOLVED:] Sorting sections within large table (54 replies)
- [SOLVED:] Loop through All worksheets and change to Proper case (7 replies)
- VBA Combine PNG/JPG to an animated Gif (3 replies)
- [SOLVED:] How To Save, Rename, and Send Multiple Sheets, As Separate Attachments In Outlook (4 replies)
- [SOLVED:] 2016 Excel VBA Code for Locking a Cell after Data Entry (4 replies)
- [SOLVED:] VBA to set Azure label (3 replies)
- [SOLVED:] VBA Runtime Error 9 - Trying to copy same sheet from multiple workbooks (6 replies)
- [SOLVED:] UserForm.Show method not supported? Created UserForm using code (4 replies)
- [SOLVED:] Add table from pdf to excel macro (2 replies)
- VLOOKUP with VBA to loop and paste multiple images in result table (2 replies)
- [SOLVED:] Autofilter and create new workbook loop (3 replies)
- Populating Content Controls in Word document from Excel workbook (same names) (3 replies)
- Excel to Word - Remove Pages where bookmarks are not used (5 replies)
- [SOLVED:] Find Empty Cell in Range From Bottom Up (3 replies)
- Data consolidation from multiple PDFs to excel (3 replies)
- [SOLVED:] getopenfilename path in listbox? (14 replies)
- [SOLVED:] VBA to modify another VBA (3 replies)
- [SOLVED:] Sum values in 1D arrays on different sheets - new sheets added annually (25 replies)
- VBA code does not perform any action (4 replies)
- Use VBA to PDF Multiple other files from Excel (1 replies)
- [SOLVED:] Error in finding last row with data (24 replies)
- copy cells from all sheets to one main sheet (11 replies)
- [SOLVED:] Creating a Message Box in Excel VBA (9 replies)
- [SOLVED:] Data Consolidation with VBA (24 replies)
- Identify combined and individual user codes and divide them in seperate cells - VBA (5 replies)
- [SOLVED:] Merge variable text (4 replies)
- [SOLVED:] VBA Help - Match x and y axis, and pull data (6 replies)
- Insert data at the end of page or last (2 replies)
- [SOLVED:] Macro Debug Help (2 replies)
- How to recall a VBA function in Power Pivot Model? (2 replies)
- [SOLVED:] Convert a formula (5 replies)
- [SOLVED:] Highlight row if two matches are found (4 replies)
- Issue: When selecting a ActiveX Checkbox my screen flickers. (0 replies)
- VBA for Excel Kanban tool (1 replies)
- [SOLVED:] Adding seven days to a specific date, but it must always be the following Monday (3 replies)
- [SOLVED:] Not Working: Code to Clear ActiveX Check Boxes (14 replies)
- Connection to DB2 DAtabase (0 replies)
- [SOLVED:] Question: Clear Data within Range VBA (14 replies)
- [SOLVED:] Unable to Run Macro for Excel Sheet to Format (15 replies)
- [SOLVED:] Transpose group of numbers from a column with guided logic by a second column (9 replies)
- multiple pivot tables to a worksheet using Excel (14 replies)
- Infinite FOR EACH loop when second application opened (4 replies)
- [SOLVED:] excel not multiplying correctly (10 replies)
- Macro creating Comma separated Key (11 replies)
- Ticked check boxes that create a new list - VBA? (4 replies)
- Add worksheet change event to all sheets during runtime_new (6 replies)
- [SOLVED:] Userform: Combining 2 values into 1 record (5 replies)
- How to Sort Excel File (2013) with 4 or 5 Keys in VBA (3 replies)
- [SOLVED:] For each sheet in between two sheets criteria - VBA (5 replies)
- Code for IF statement referencing two more sheets and color formatting (3 replies)
- [SOLVED:] Showing numbers in 1000's, but not rounded (2 replies)
- [SOLVED:] Copy Insert Row At Start End Or Middle with different Columns same row range (2 replies)
- Faster way to delete rows based on criteria? (9 replies)
- Combine Multiple Csv Files Into one Worksheets with file name as header (9 replies)
- [SOLVED:] apply distinct formulas to autocomplete different columns in a specific table (2 replies)
- VBA code to switch system language to English (0 replies)
- Count successful create blank row (1 replies)
- [SOLVED:] Merge two tables into one - VBA help? (11 replies)
- [SOLVED:] Autofill NOT COPYING formula (5 replies)
- Conditional Formatting (Macro) (1 replies)
- Coding help for a complete VBA Beginner (1 replies)
- VBA Code for Next Business Day (4 replies)
- [SOLVED:] Multiplier (VBA) (10 replies)
- Copy true number in another column (2 replies)
- How to return to the original active cell? (2 replies)
- VBA Code to Track Changes in Excel Sheet (1 replies)
- Copy rows according to value of cells selected according to the value of other cells (7 replies)
- [SOLVED:] EXCEL export creating double quotes (11 replies)
- Copy certain columns of data from 2 worksheets that are auto-filtered to 1 summary wo (1 replies)
- [SOLVED:] Compile Error Object Required (Excel VBA) (5 replies)
- [SOLVED:] Excel 365 - Forms Control (5 replies)
- Loping through each worksheet with an exception (12 replies)
- [SOLVED:] VBA function with 3 arguments in 3 cells to the left of entered cell (6 replies)
- [SOLVED:] Delete duplicate value for same date and other look up value. (6 replies)
- Force switch the language to ENG (0 replies)
- Running Total SUM Based on Criteria (2 replies)
- Workbook & Worksheet referencing (5 replies)
- [SOLVED:] ListBox mirror TextBox and Copy to Excel Table (3 replies)
- [SOLVED:] vba combobox list on Userform has blanks (9 replies)
- insert only the first 4 images from folder (3 replies)
- Copy column, copy list from another document and use that to replace multiple values (0 replies)
- VBA: concatenate multiple cell data (3 replies)
- [SOLVED:] Method value of object range failed. (4 replies)
- Take several screenshots one after another of a table (6 replies)
- [SOLVED:] Truncate number to two decimal places without rounding (6 replies)
- [SOLVED:] VBA Find string and add hyperlink (7 replies)
- Cannot use that command on overlapping selections- delete row code (1 replies)
- [SOLVED:] Highlight Pay Dates on Userform Calendar (14 replies)
- [SOLVED:] VBA: If number found in column B:C in excel sheet reduce numbers by -1 (3 replies)
- create treeview with 2 columns (1 replies)
- Add/Remove pivot fields via macro- Help req to change existing code (3 replies)
- Linear Interpolation (3 replies)
- [SOLVED:] Excel VBA if condition then copy other cells to another worksheet (8 replies)
- [SOLVED:] Using a function with part of an array (14 replies)
- [SOLVED:] No Intellisense for "Sheets" Object in Excel VBA? (6 replies)
- [SOLVED:] VLOOKUP Error : Need a VBA to copy matching row cell data in sheet1 from sheet2 (2 replies)
- vba add worksheet checkboxes (4 replies)
- Using VBA to copy data to new sheet and find data from other sheets (5 replies)
- [SOLVED:] VBA: Find the position of occurrence of text in sentence (9 replies)
- My script opens a large workbook - too slow - any fixes? (7 replies)
- [SOLVED:] How To Change VBA Copy Rows "X" Number of Times (4 replies)
- [SOLVED:] Intercept an splwow64.exe error (3 replies)
- [SOLVED:] How to save a macro excel? (2 replies)
- Tricky situation in excel ( (15 replies)
- [SOLVED:] tooltip macro (6 replies)
- How to use VBA for multiple rows? Now I have code for 1 row. (3 replies)
- [SOLVED:] Fiscal Date year changes automatically (9 replies)
- Looking to paste without changing the format of the cells pasted into (9 replies)
- Hello, I have tree macros and I want to link two of them: 1. The first one( Report m (2 replies)
- [SOLVED:] VBA comparison with ActiveCell.Offset (14 replies)
- [SOLVED:] Overflow Error Trying to Calculate Percentages (9 replies)
- [SOLVED:] Vlookup across Workbook (6 replies)
- Declare function no longer works (13 replies)
- VBA code to delete and replace this month's data (9 replies)
- [SOLVED:] Filter month based on file name contains months (5 replies)
- vba partial names variables (14 replies)
- [VBA - UserForm] Change "Status" cells in all duplicated rows at the same time (2 replies)
- How to replace specific formulas by values and then generate several xlsx/pdf filenam (5 replies)
- [SOLVED:] Sending and receiving ASCII commands in excel (14 replies)
- [SOLVED:] Merging Error (8 replies)
- How to Structure Conditional Statement for an Array (2 replies)
- Value out row based on a cell value (5 replies)
- [SOLVED:] Converter Function (3 replies)
- Important security change by Microsoft (2 replies)
- Getopenfilename - File dialog hidden (6 replies)
- ActiveSheet.Pictures.Paste runtime error (8 replies)
- [SOLVED:] VBA Loop through column, copy specific cells, and stop when i meets a red cell? HELP (14 replies)
- group by column (4 replies)
- One Macro for Copy/Paste, Formula, Colouring and Hyperlinking for at home (4 replies)
- I want to copy a value from a previous sheet, every day. (3 replies)
- [SOLVED:] VBA macro for print out (12 replies)
- Trying to find a way to find matching values, their row number and update whole rows (1 replies)
- Text file import texttocolumns vs querytable.add (5 replies)
- [SOLVED:] VBA Sort Data Descending Order in two tables (4 replies)
- Macro to compare sheetname from one workbook with another and take actions depending (3 replies)
- "Can't find project or library" error (5 replies)
- Daily Dose Of Excel (2 replies)
- VBA to Search More than One Worksheet in a Workbook (2 replies)
- Module to Calculate from Two Tables (2 replies)
- VBA Assistance needed - lookup, match and copy command (17 replies)
- Refer to Excel collections in VBA with a "variable" name? (11 replies)
- Excel Help - (0 replies)
- [SOLVED:] Make BackUps of files Using Excel List (6 replies)
- How to post predefined cell value to active cell (11 replies)
- [SOLVED:] SQL query using where with multiple criterias (3 replies)
- [SOLVED:] Userform command button does not respond when calling userform from custom ribbon (1 replies)
- [SOLVED:] Help with Find and replace code (4 replies)
- CommandButton Back Colour is not set on WorkBook Open (5 replies)
- [SOLVED:] Else statement in loop (3 replies)
- [SOLVED:] Filling array bas on vba formula (8 replies)
- [SOLVED:] How to convert Index(match.. (Left(Right...)..)..) into VBA (excel) (4 replies)
- How to use uppercase in an additional column? (4 replies)
- [SOLVED:] Change destination folder (2 replies)
- Copy the last category and insert custom text (2 replies)
- [SOLVED:] Extract files in a folder containing contents in column A and move them to own folder (7 replies)
- [SOLVED:] Dragging Formula down through merged cells (4 replies)
- scraping element in web page.... (0 replies)
- Compare Multiple Columns between two workbooks and update the values in the second wo (2 replies)
- [SOLVED:] Run time Error 1004 when assigning cell value (2 replies)
- [SOLVED:] Unexpected Numerical Value in Table When Adding Blank Line (5 replies)
- [SOLVED:] Include the exact name from one cell in to a formula in another cell (9 replies)
- Pivot filter by each item and copy to new sheet (3 replies)
- [SOLVED:] AVERAGEIFS formula - adjust to exclude values of 0 (14 replies)
- Save-As name based on cell value (2 replies)
- VBA: fetch data from cells and concatenate matching data heading in another sheet (6 replies)
- Roll column forward and hard paste previous (1 replies)
- [SOLVED:] Copy unique values from new data and append to existing list in another worksheet (7 replies)
- link pictures from Sharepoint to Excel macro (0 replies)
- VBA: Remove line in cell if substring present (1 replies)
- Combine these codes to one (5 replies)
- Finding minimum value Using VBA (3 replies)
- incrementing a set string by1 (1 replies)
- VBA creating relative references to table columns (5 replies)
- [SOLVED:] Unmerge Cells & Copy Cells Down to Next Line of Data (25 replies)
- Help fixing and cleaning up code (2 replies)
- Using VBA to rename or delete subfolders (8 replies)
- [SOLVED:] Remove part of a string (4 replies)
- [SOLVED:] Type Mismatch Error when Setting WorkSheets (4 replies)
- [SOLVED:] Error with progress bar chart (2 replies)
- What does line 7 mean (2 replies)
- [SOLVED:] Highest consecutive values in column (13 replies)
- [SOLVED:] How to move column of data down (shift it by 1 row) (2 replies)
- VBA Excel deleting duplicates (2 replies)
- VBA- No form on Mac (0 replies)
- Static cell (3 replies)
- Sleeper: Application FileSearch help (1 replies)
- giving a direction to VBA to open a specific file (1 replies)
- [SOLVED:] Why For each rw is empty? (6 replies)
- How to sort single column (selected)? (2 replies)
- [SOLVED:] How correctly check for error? (2 replies)
- [SOLVED:] Single workbook - Cannot run the macro... the macro may not be available in this work (2 replies)
- [SOLVED:] VBA to enter formula using variables: Error 438 (2 replies)
- Format Incremental Value as Two Digit String (8 replies)
- [SOLVED:] Delete multiple rows based on cell color (3 replies)
- Need help updating sort automatically, but only if a cell has a number (8 replies)
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.