View Full Version : Excel Help
- VBA current cell value = another cell value if criteria met (5 replies)
- [SOLVED:] Array formula? (7 replies)
- Combo box Duplicates (5 replies)
- [SOLVED:] Need a help with loading data using class module (Derivative & Portfolio) (4 replies)
- Help with creating duplicate sheets, combo box are linked together (0 replies)
- [SOLVED:] Finding the length of elements in a 2D array (3 replies)
- [SOLVED:] Edit new code to allow update of posiitional references to be edited by user. (2 replies)
- [SOLVED:] Need an advice for searching function (28 replies)
- [SOLVED:] Excel Userform Directory - search button using checkboxes (5 replies)
- VBA: Copy row to the last line of data (4 replies)
- Copying a section if item from a drop down list is selected (16 replies)
- problem with data extraction with VBA from Web site (2 replies)
- Run-time error 1004 (4 replies)
- [SOLVED:] Need help with VBA conditional VLOOKUP on another file (3 replies)
- Sumproduct across ranges with varying sum values (4 replies)
- sub that creates two arrays month and dayslnMonth (14 replies)
- Remove Duplicate VBA (5 replies)
- Export to XML (2 replies)
- [SOLVED:] VBA Copy formula x times to the right based on value in cell (3 replies)
- Application Error (10 replies)
- Project Explorer taking up full screen (3 replies)
- Merge Multiple Workbooks into One (3 replies)
- VLOOKUP to the left (2 replies)
- the color of cells (5 replies)
- [SOLVED:] Detect the same value on cell and merge them (6 replies)
- [SOLVED:] About WorkSheet_Change Event VBA (1 replies)
- [SOLVED:] Best way to hide rows depending on cell value? (16 replies)
- Dynamic diagramm (14 replies)
- [SOLVED:] Date Series Fill (13 replies)
- VBA please Support (12 replies)
- VBA to create-rename new sheets in a workbook and export them individually as CSV (6 replies)
- VBA: Copy and Past between different instances (7 replies)
- Help create Macro remove multi-lines duplicate characters (1 replies)
- [SOLVED:] Using String variables within a formula in VBA (7 replies)
- Macro breaking when any edits to sheet are made (4 replies)
- [SOLVED:] Combining multiple Named Ranges into one (8 replies)
- [SOLVED:] Need an advice for Insert new Row in other Sheet in VBA (2 replies)
- User form Help (5 replies)
- Formula for counting most frequent values (1 replies)
- VBA how to: Multi line text in cell to column (7 replies)
- [SOLVED:] Linear interpolation. retrieving the wrong data. (2 replies)
- [SOLVED:] Form Control Listbox help (12 replies)
- Use VBA to send XML API (0 replies)
- Search for file name in all drives (9 replies)
- [SOLVED:] Macro to update macro buttons (3 replies)
- Macro captures scrap and submits it to another book. Please Help improve. (1 replies)
- [SOLVED:] Email Range in Body of Email - Not pasting the data (9 replies)
- VBA Code required to see if workbook is opened or not. (5 replies)
- Need an advice for VLOOKUP function in VBA (2 replies)
- Looping through code (7 replies)
- how to move xls files in same named folders by vba (1 replies)
- [SOLVED:] Need VBA Help! (3 replies)
- DropBox getting dropdown menu from filtered table (2 replies)
- VBA that allows sorting of data by user (2 replies)
- Copy to new WorkSheet and name as specific dates (5 replies)
- Search and replace (1 replies)
- Filter the microsoft date and time picker control output (3 replies)
- [SOLVED:] VBA for Excel: automated correction of wrong decimal separator (8 replies)
- [SOLVED:] Assistance with bringing specific items from text file into Excel (2 replies)
- VBA to insert SUMIFS formula with row number updated when inserted (2 replies)
- Median with a Condition on Text Selection that Differs Only by Ending Number (4 replies)
- Copy selective columns from one worksheet to another in the same workbook (2 replies)
- Search Matching Value (1 replies)
- [SOLVED:] Set Columns Names in ListBoxes (2 replies)
- Userform Listbox Filter using comboBox (29 replies)
- CHOOSE with HLOOKUP (3 replies)
- [SOLVED:] Insert picture into image control (8 replies)
- insert formula - Run-time error '1004' - Application defined or object-defined error (17 replies)
- HELP: VBA Listbox - highlight selected states of AU and display some basic info (12 replies)
- [SOLVED:] VBA for picking only one value from an SQL base (2 replies)
- Re: Track Changes - Text and Formulas with user name and time stamp (1 replies)
- Display Data from Two Sheets (0 replies)
- Coloring range of cells under colored cels (15 replies)
- Restrict entry to textbox (9 replies)
- Excel VBA Listbox with additional item number column (11 replies)
- [SOLVED:] Index/Match with multiple criteria (4 replies)
- [SOLVED:] Help! edit multi-cells with conditions. Thank all of you! (3 replies)
- [SOLVED:] Clear cell after Worksheet_Change Analysis (4 replies)
- VBA/Excel Workbook Help (2 replies)
- VBA - copying & pasting data using file path (11 replies)
- from a formula to a macro (1 replies)
- Referencing List, how can i find the closest match? (4 replies)
- [SOLVED:] VBA Lookup, how to return multiple columns? (2 replies)
- [SOLVED:] generate random and unique value of cells (3 replies)
- [SOLVED:] Rearranging Words within a Cell (15 replies)
- VBA pull first 4 digits until the bottom of the data (1 replies)
- Create a list of unique values from multiple workbooks (1 replies)
- Copy rows and column headings to new workbook based on cell value (7 replies)
- Dataset updates changing the pivot table (1 replies)
- VBA Code optimization- Speed up this Macro (2 replies)
- [SOLVED:] Change Textbox and Combobox Back Color (7 replies)
- [SOLVED:] Sorting Rows by certain columns using VBA (or not?) (2 replies)
- Addition of cells as path (1 replies)
- Filter Value from Column and paste selection as value in another Sheet VBA (2 replies)
- [SOLVED:] Linear interpolation (9 replies)
- [SOLVED:] Pivot Table grouping (4 replies)
- Graph Data Labels - how to avoid line break (1 replies)
- Copy whole frame content to worksheet (3 replies)
- [SOLVED:] Help with limiting VBA range (4 replies)
- [SOLVED:] Copy column from one sheet to another then sort and remove multiple delimiters (7 replies)
- [SOLVED:] Copy + Paste to Last Row based on Last Row of adjacent Column (2 replies)
- VBA: Folder & File Lister (1 replies)
- Attendance Spreadsheet - Custom point reduction (8 replies)
- Find list of words occurred (7 replies)
- [SOLVED:] Adding new lines in multiple spreadsheets (5 replies)
- [SOLVED:] Condensing code - Using Arrays for Loops (5 replies)
- VBA Code to link spreadsheet data (12 replies)
- Reverse INDEX and MATCH (2 replies)
- Sleeper: Converting Index Match function to VBA code (1 replies)
- [SOLVED:] Create a Project Scheduler With Excel (44 replies)
- [SOLVED:] automatically consolidate data from different sheets to 1 combined sheet (4 replies)
- VBA Get a value from a cell and compare to multiple conditions ElseIf (4 replies)
- Method 'Copy' of object'_Worksheet' failed PROBLEM (6 replies)
- [SOLVED:] BeforeSave loops and workbook closes (2 replies)
- Generating an array, and using Vlookup to loop through this array (VBA) (40 replies)
- [SOLVED:] Time Conversion (20 replies)
- VBA to copy range from one sheet to another. (1 replies)
- [SOLVED:] Looking for help to identify matches across multiple columns (5 replies)
- VBA macro to set up dynamic print area (6 replies)
- Allocation of Data - URGENT HELP (2 replies)
- [SOLVED:] Format Shape menu appears after a printpreview. (3 replies)
- [SOLVED:] Move matching rows to existing sheets (9 replies)
- code for copying from multiple files and paste in master file (1 replies)
- Excel Threads in Windows (3 replies)
- [SOLVED:] Populate ListBox from Multiple sheets (13 replies)
- [SOLVED:] Help with paste special (2 replies)
- vba for keeping first 4 characters and removing duplicates (2 replies)
- Copy, paste and sum data from multiple worksheets to one worksheet (8 replies)
- VBA Code to link to Oracle (1 replies)
- Dynamic pivot table (3 replies)
- [SOLVED:] Splitting data from one column into other 4 columns in excel (15 replies)
- Public Variables in Object Modules (14 replies)
- Graphing on a MAC With VBA (9 replies)
- Compare a column of data on one ws to another ws and append non-match data (7 replies)
- Comparison for Reconciliation (10 replies)
- VBA - Macro has to run twice for it to work. (1 replies)
- Joint different set of data (6 replies)
- Filtering Column with Multiple Criteria (5 replies)
- How to set cookies using web browser userform (0 replies)
- [SOLVED:] Delete row if cell is not a number (6 replies)
- Check if Attachments was added (3 replies)
- ExportedUI File to EXE File. (1 replies)
- [SOLVED:] Address SPLIT (11 replies)
- [SOLVED:] VBA Code to open a folder when ctrl + right click is pressed (19 replies)
- [SOLVED:] If statement with non numeric cells (7 replies)
- [SOLVED:] SUMIFS with sum range dependent on another cell value (6 replies)
- VBA: Copy Cell to another and remove last 2 characters (3 replies)
- VBA To Combine A Combination of Values To Get One Target Value (6 replies)
- VBA Lookup? (13 replies)
- VBA code help (current code too slow and freezes) (6 replies)
- [SOLVED:] Detecting Duplicate entries (10 replies)
- [SOLVED:] Display Print Dialog with "Selection" as Default (4 replies)
- Error Message: Cannot open file -- File Format/Extension Error -- Troubleshooting (2 replies)
- Linked tables and Slicer in Excel (2 replies)
- [SOLVED:] Copy Paste Values from multiple workbooks to multiple sheets in one workbook (10 replies)
- Macro for form control/LOCKED CHECKBOX FOR CERTAIN DOMAN USER (1 replies)
- VBA for color coding a cell based on values in other cells (2 replies)
- [SOLVED:] Please Help. trying to check for specific text in cell value :S (2 replies)
- Code for pasting as per criteria (9 replies)
- Use Getopenfilename function to browse the file. (1 replies)
- how can i open external excel file by using button in userform (12 replies)
- application.windows object (4 replies)
- Unique ID for new userform's entries (27 replies)
- ListBox dependent on 2 ComboBox (ComboBox1&2) selections (1 replies)
- Color chart caption with VBA (6 replies)
- [SOLVED:] Userform output range (5 replies)
- [SOLVED:] how can do this: if any userform closed(x) then mainform.show (19 replies)
- Some VBA help please (20 replies)
- [SOLVED:] Help with Index Match function! (3 replies)
- Handle Spelling Errors (11 replies)
- Sort Text and Consolidate (4 replies)
- [SOLVED:] Individual zoomfactor for each sheet (5 replies)
- [SOLVED:] Help on filtering an excel based Column C and send email for every filtered item (8 replies)
- Any ideas on how to improve this Userform (1 replies)
- [SOLVED:] Matching a string with a partial string using match function (4 replies)
- Disable New Excel Auto-save Feature(Not auto recovery) (5 replies)
- Convert to PDF, SaveAs, Attach to Outlook Email (1 replies)
- Compile Error: User-defined type not defined (6 replies)
- Code to update a KPI based on a worksheet (5 replies)
- [SOLVED:] Code for pasting according to criteria (4 replies)
- OCR Data extraction with VBA from Web site HELP! (0 replies)
- VBA userform combobox and vlookup to fill another cells (1 replies)
- CX-Server CDMDDE Visual Basic Macro Errors (6 replies)
- [SOLVED:] concatenate formula (2 replies)
- VBS Program Debug (1 replies)
- table and charts in full screen (1 replies)
- [SOLVED:] In Automatic Calculation Mode, spreadsheet still does Manual Calculation?? (8 replies)
- Simple EXcel Macro help (3 replies)
- [SOLVED:] Using a Variable in a named range (8 replies)
- Replace a text with a future data (6 replies)
- VBA - update entry in other workbook if ID matches (3 replies)
- Exporting excel worksheet to word keeping exact formatting (1 replies)
- [SOLVED:] VBA Help with Macro to autofit visible columns starting at row 4 (2 replies)
- [SOLVED:] Results of OptionButtons by GroupName (21 replies)
- Import data from excel files with specific file name into another excel sheet (8 replies)
- Named Ranges.! (7 replies)
- Unable to click on button HTML (0 replies)
- [SOLVED:] Excel Slow performance (71 replies)
- Web Vba issue (0 replies)
- Pivot table help (12 replies)
- [SOLVED:] Query Table - Extract Data From Text File by Column - TextFileColumnDataTypes (3 replies)
- Sending Email with Email body in a cell keeping the formatting. (11 replies)
- [SOLVED:] Copy Paste to visible cells only with different sheets / workbooks (3 replies)
- Error copying multiple worksheets using VBA (3 replies)
- [SOLVED:] Filter On Date With Headers (7 replies)
- VBA to stop pivot tables refreshing before power queries with autorefresh (1 replies)
- Compress four rows into one row (8 replies)
- [SOLVED:] Table transpose (5 replies)
- Web scraping with complex chronological events (0 replies)
- [SOLVED:] Format data in Excel with subtotal (15 replies)
- [SOLVED:] One Row.Delete works, another doesn't (5 replies)
- Macro to Convert Flat Data to Database - Amendment to existing code required (0 replies)
- index match between 2 workbooks (3 replies)
- Using checkboxes to copy rows from one sheet to another in the same relative order (1 replies)
- Writing a macro to capture values on a spreadsheet and add them to totals on another (2 replies)
- VBa code to transfer rows base on a sequential number (9 replies)
- [SOLVED:] Excel VBA to Transpose lists (4 replies)
- VBA Function - Last Row (19 replies)
- [SOLVED:] Coloring rows through value in column (6 replies)
- Hide Worksheets dependant on domain name (16 replies)
- [SOLVED:] VBA to operate on an external drive + files dispatching in folders (20 replies)
- Rewriting Referenced Data for VBA Pivot Table (3 replies)
- A neat timesaver for Immediate ("debug") Window - abbreviations (2 replies)
- Need code to merge PDF files in a folder using adobe acrobat (2 replies)
- Cell locking macro not working (1 replies)
- [SOLVED:] combine selected worksheet into one worksheet (4 replies)
- Using RANK on a range of data - need an exception (1 replies)
- select radio buttons in IE (0 replies)
- Encrypt password for database access (2 replies)
- Subscript out of range and SaveAs Method error (Revised) (9 replies)
- [SOLVED:] VBA check if a specific value has been entered into range (3 replies)
- [SOLVED:] Selection not displayed when combobox item is selected (14 replies)
- [SOLVED:] Insert Pics Macro Not Working on All Cells unless name manually typed in (7 replies)
- [SOLVED:] VBA code to paste data to a row with today's date in column A in another sheet (12 replies)
- [SOLVED:] Blank cell (3 replies)
- [SOLVED:] IF then (1 replies)
- [SOLVED:] Countif using arrays (5 replies)
- Parsing data to several sheets (6 replies)
- [SOLVED:] how can i save userform settings (12 replies)
- [SOLVED:] Help with formula please (3 replies)
- Vba code for partial transpose (3 replies)
- What are your favorite Excel VBA automation success stories? (0 replies)
- [SOLVED:] How to display a chart on a certain position (e.g. centre of screen). (7 replies)
- [SOLVED:] Monitoring Remote Workbook for Changes (2 replies)
- Dividing data records fairly into clients based on categories and amounts (10 replies)
- VBA Code to Run Other VBA Codes in Multiple Workbooks (8 replies)
- [SOLVED:] For Loop does not seem to be working (8 replies)
- [SOLVED:] FileSystem Object, Folder.Files.Count Does Not Match Files.Item Count (10 replies)
- VBA code to delete rows based on value (7 replies)
- Getting Problems in Making a Query from SharePoint (0 replies)
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.