View Full Version : Excel Help
- Excel will lock specific area based on a date
- Find last match in date sorted list using index match with multiple conditions
- Sales in the fortnight
- [SOLVED:] Need help passing variable values to For Loop
- Need help: I am out of my depth.
- [SOLVED:] Copy-Paste cell text content + delete rows
- [SOLVED:] Need help modifying VBA code to suit requirements - Listing Uniques based on criteria
- Need Help - VBA HTML Wikipedia data
- Need Help: Import worksheets by name using an array of defined names
- [SOLVED:] Multiple Find/Replace At Once (Feeding From A Table)
- conditional format on a different column
- [SOLVED:] Need help creating a loop please
- Search for a word and get the (row, column) numbers, when the word is found.
- custom function in Excel VBA which takes an array as an argument
- Loading text file with specific name in excel
- Code Execution Speed
- [SOLVED:] Concatenate Date and Keep Formatting
- Need a Help to expand the data in HTML Page in Internet Explorer
- [SOLVED:] Conditional formatting of cells for 45 different cases with 5 criteria each
- Find Z value from given XY. Obtain plane from 3 coordinates VBA function
- Copy a varying range
- How to highlight cells with dependents in other worksheets?
- [SOLVED:] Array Index new with Criteria of Old Array
- [SOLVED:] Vlookup in VBA: lookup multiple values
- multiple vlookup formula is not working
- Excel VBA macro to copy specific rows and delete it
- capture specific records from multiple sheets to one sheet
- Find cell, make active cell and repeat
- [SOLVED:] VBA macro for filtering and copying duplicates
- [SOLVED:] Insert cell content in shapes VBA
- Help Deleting Rows with "If, then" statement
- How to simulate Brownian motion for multiple trajectories?
- Match same quote number and roll up
- Userform for Data Entry Into Several Different Worksheets
- [SOLVED:] Lookup Value in two columns and identify opposite values
- merge/join/combine multiple tables into one master table
- Search for files/folder based on excel list info and copy them to new destination fol
- [SOLVED:] Insert new row above specific text
- Excel Window - Automatically Resizes to Last Size
- Selection Clear Content
- Content in a range is not clearing when i using F5 key
- Outputing the time taken for a calculation
- [SOLVED:] Automatic Filter
- Combo Box linked with List box
- [SOLVED:] VBA macro for combining several cells into one
- [SOLVED:] Set File Path to Cell in a workbook
- [SOLVED:] VBA Combining tables into one - value paste needed
- exclude a row in code
- [SOLVED:] Simplify XY Scatter into short line segments, individually colored
- [SOLVED:] Embedding the most recent picture taken into a cell
- Copy multiple files from one folder to other using the file names given in excel.
- [SOLVED:] delete sign pilcrow in combobox
- [SOLVED:] Update Master File With Data From Open Workbook
- Help with a macro to check results and highlight future forecasts
- Error while connecting to Oracle database from excel macro
- [SOLVED:] Can this code be optimized with regard to the Do While...Loop?
- [SOLVED:] Report Generator Fix - Run-time error '1004': Doc not saved
- All pivot charts export at a time to folder doesn't work in excel 2016
- [SOLVED:] User Input to VLOOKUP a number in spreadsheet
- [SOLVED:] VBA text conversion into Number Help
- Add Zeros At End of String
- [SOLVED:] Excel chart problem's
- Check Number of rows and insert category name
- automatic removal of empty rows
- Macro for infinitely moving data to new location (need help).
- [SOLVED:] Changing source range of pivot table
- [SOLVED:] Lookup Max value on one sheet and populate on another in used range
- [SOLVED:] Need Help, How to Add more than 10 Columns ?
- Macro to check 4 columns to check for Unique combination & highlight dups
- Macro to Check For a Cell Value and Perform Null & Data Type Check for multiple Cols
- [SOLVED:] populating combobox from access table
- [SOLVED:] Adding a line to an acces table from a vba userform
- [SOLVED:] K-ESIMO MATRIX FORMULA
- Novice syntax question...if then statements...error 1004
- How do I make a data scraper [Copy and pastes multiple pages into excel]?
- convert alpha to numeric
- Break single row into multiple rows based on FORMAT
- [SOLVED:] VBA Compile Error "Else without if"
- [SOLVED:] Help storing values in Array and returning to 3 values
- VBA to Force the User to Enter Data into a Cell before moving to next cell
- Conditional formatting
- Load and Sort ComboBox with Dynamic Range From Sheet
- [SOLVED:] Assign each element of an array to a variable
- Error trying to attach file to email
- [SOLVED:] Search Column and skip hidden rows
- Need help .Range.AutoFilter multiple field
- Dynamic Userform for data entry
- Find variants of positions and value. Need help!
- [SOLVED:] Looking to code a function to efficiently remove multiple commas in a string
- [SOLVED:] Automating Copy And Paste
- Macro to copy non-blank cells in 2 columns and paste values into first blank cells in
- [SOLVED:] Odd scope of Workbook_WindowDeactivate?
- [SOLVED:] Code Products
- How to get data from 2 criteria (StartDatte to EndDatte)
- Textbox entry search populates into listbox I'm stuck on how to make the VBA code
- [SOLVED:] VBA search
- Need help with MSXML2.serverXMLHTTP request
- [SOLVED:] Printing multiple ranges/charts from different sheets at the same time?
- [SOLVED:] Need help with Multiple Pivot Table PivotField filters
- [SOLVED:] Remove numbers of a 1st column founded in a 2nd one
- [SOLVED:] Automatically readjusting a Pivot Table's data source range
- [SOLVED:] In a userform, applying results to a different workbook
- Need to consolidate comments across spreadsheets
- Excel eMail sending failure in Windows 10
- [SOLVED:] Using If function to separate data into multiple sheet
- Date generating
- Extracting and refreshing data set
- Choose date and calculate onwards
- count the number of changes in several cells
- [SOLVED:] Non-Printing Characters: Box with a Question Mark Unable to remove
- Excel VBA: limit file opening times, AND prevent copying. plus authorization code
- [SOLVED:] Macro to delete rows
- [SOLVED:] Delete row if it contains a certain criteria Please Help
- about Array
- VB Excel, increase factor in table
- [SOLVED:] Show Column Headings in PDF's to Be Emailed
- [SOLVED:] Adding A Reference
- Didn't work my macro to copy&paste only as formulas by default... can you give it a q
- Copy / Display row from another sheet
- Lookup Text Value
- [SOLVED:] Need to remove a certain part of cell Data
- Defining Name Ranges Using VBA
- Different custom ribbon for each sheet
- [SOLVED:] Copy/Paste unique rows based on multiple criteria
- Check if library exists
- [SOLVED:] Is there a way to add Arrow Keys to Excel's Quick Access Toolbar?
- VBA (Noob): Automatically select the next row
- VBA - Verification of the sheet > MsgBox
- [SOLVED:] Selecting pages to print within worksheet
- VBA code to delete row is value in column is less than a specific defined value
- How to add cells with Conditional Formatting
- Can i create a Licence to an excel vba solution !?
- sum if textbox <>""
- Ending a Sub on a Timer Loop
- [SOLVED:] 3 Contact Numbers along with , (coma) Too many arguments
- [SOLVED:] working with record sets
- Smartview connection issue
- VBA freeze / timeout when processing large data sets
- Find a name from a list of names
- inputBox default input in code, user not input
- [SOLVED:] Need a UDF to Identify and remove parts of Cell Data from a Range
- VBA to write PDF froms from Excel, Radio Buttons
- [SOLVED:] To Pull out Certain Set of Data from a Cell [ Urgent ]
- [SOLVED:] Please Modify this VBA for New Requirement Or Provide a New One
- [SOLVED:] excel 2010 dashbord to show totals
- [SOLVED:] Help with Filtering...(autofilter)
- [SOLVED:] VBA for Auto Filter and Copy/Past the Visible Cells at Destination Workbook
- [SOLVED:] Array Relative Erase Variables but Next
- Issues with VBA's vbModeless for programmatically-created userforms: they close
- wildcard character is not working while opening excel file
- i could not paste the copied data (VBA)
- VBA for sending Bulk Email with Unique Attachments in XLS to Unique Receipient
- Calculate months onwards from set date
- Adding Worksheets to an Array
- explore the land owner
- Using .Value fails when initialising a user form
- Autofill formula help
- Get a Cell into a Standard Format depending on its Contents - UDF/Formula Only
- [SOLVED:] Pull data from specific worksheet from multiple workbooks
- Get rid of extra row height with Word Wrap
- [SOLVED:] Looping through checkboxes in user form
- Data Entry from Excel or CSV to AS400 Emulator is possible or not?
- VBA code to create Indented BOM
- [SOLVED:] Macro to Autofill
- [SOLVED:] Extract Numeric Substring From longer String
- Copy Transpose and Paste Macro
- [SLEEPER:] How to make Total Row always at the Last Row / bottom of the Printed Page
- [SOLVED:] thisworkbook.path and dir function
- [SOLVED:] Image frame resolution
- drop down lists vba
- Help with populating a table with values on other sheets
- [SOLVED:] .pattern help please
- Add row to table refering to a Cell Value
- Adding prefix to cell in column as it is added
- VBA Autofilter 3 Criteria
- Automatically Converting Numbers stored as text to numers
- [SOLVED:] No response to change event
- calling inputbox if cell value is true
- Find DUP, remove both same entries
- [SOLVED:] autohide userform with active sheet modification
- [SOLVED:] Check value based on cell text and turn another cell Green if there is a match
- Userform Standalone/Hide Excel Application
- How to refer on a picture on a different worksheet
- Ask for Explanation
- List select and copy sheet from another location
- [SOLVED:] Stack bar chart configuration in Excel
- Reading a Text File into an Intermediate Window
- Changing a font style and color in VBA
- Reducing the need for Multiple hardline codes
- [SOLVED:] Applying Proper Case to Strings
- PivotSelect Question
- Invoke an .exe file using macro in excel
- [SOLVED:] How can I put the results of the Array back to the corresponding cells?
- Need to split sheets based on number of family members
- Issue creating SQL query from string in VBA
- Auto populating text fields on websites and scraping the web
- passing string from userform to public module variable
- Array Values filling specific cells
- VBA Newbie (Trying to write a code to copy and paste info from one sheet to another)
- Writing registry keys with API Calls
- [SOLVED:] VBA macro to order and delete information
- Iterating through Groupings using VBA
- Implementing Save As function in VBA code
- [SOLVED:] Reading in a text file and only printing certain lines
- The paste method of the _chart object failed
- [SOLVED:] Excel Select the Rows - Input Box - Save to Text Files
- [SOLVED:] OLE - Embedded Custom Icon won't stick
- [SOLVED:] Select next cell after dynamic range
- Accessing a network file that might already be open by another user
- evaluate a date with vba
- excel vba macros help needed
- [SOLVED:] Write from excel to text file format
- Excel Macro Find and Replace Functions within Cell Formulae
- Improving a Concatenate & Vlookup Process
- Outlook 2013 Global Address List Alias to Excel Document
- userform textbox test for format
- Convert Excel to Web Application
- InStr - Not operating
- Excel - how to hide columns but allow users to insert rows
- Download File from Website From Excel
- VBA for make resume by date (Unique & No Duplicate)
- Compare two images
- Pivotal Filter Selection Macro
- [SOLVED:] ndate returning time in Holland not London
- [SOLVED:] Clear Data Module - Clearing Header when No Data
- Automating Internet Explorer / Interacting with HTML class question
- Find Multiple String Variables in a different sheet
- Target.value
- [SOLVED:] Concatenate Rows Of Data
- [SOLVED:] Reference Another Workbook Using Relative and Fixed Cell References
- Navigate web pages until search complete
- [SOLVED:] Look for duplicates across 2 identical tabs, remove then merge remaining data
- Receipt Format
- [SLEEPER:] Macro to UnGroup and Group Based on Current Month
- [SOLVED:] Macro to Change all Date formats in workbook to 01/2017 to 01.2017 (and vice versa)
- VBA for Input Date
- saving selected worksheets into new file
- [SOLVED:] Send data from multiple worksheet to a summary worksheet
- copying all columns including hidden
- VBA Macro to combine workbooks in a folder into a "Master sheet"
- Macro encrypt-decrypt function in one
- Import Data from txt file in specific cells
- [SOLVED:] For loop very bad performance
- [SOLVED:] UserForm Update/TextBox DblClick
- help to fetch data from a closed file in excel
- If Statement Excel Macro
- Picturebox in Worksheet SetPixel
- ReadLine command for UNIX txt file
- Combo box data to select sheet
- copying data from worksheet to another
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.