View Full Version : Excel Questions
- scientific calulations using scattter and trendlines
- sum into a table
- Restart Computer To get VBA working again
- Checkbox to run macro
- Complex If Then formula
- Dependent worksheet reference?
- Excel VBA script to vlookup from external file
- Macro to check 2 conditions then do something
- Excel 2007
- 2007-Current Auto-Filter to New Sheet
- Vlookup (But my lookup value isn't always in the same cell?)
- Conditional formatting for a cell with 5 conseq numbers of 60 or more
- Looping through a list that loops through a second list
- Preformated Text in Cell, using form input...
- VBA data dump clean-up
- Convert Open Office Basic Script to VBA
- VBA/function calculation
- Merge Spreadsheets
- Mouse is busy with timer delay macro
- Security Alert : Link "Automatic update of links has been disabled"
- Help! Need to reverse percentages.
- INDEX Question
- ComboBox question....
- measure Excel formula's speed
- Use a UDF
- find/copy/paste
- Sum above only to certain range...
- Compare two cells using VLOOKUP, FIND, and ISNUMBER
- Autofilter question - Way to filter out everything other than?
- Difficulties with the lookup...
- add hyperlinks to a range
- Set ListBox rowSource automatically when a new page is added
- If Statement with in a work book
- #VALUE! errors on PC but not w/ Nokia "quickoffice" program
- If something, Then Delete Cell content
- Averages question
- Find the largest time
- Embaded HTMLSelect1 control on worksheet
- Comparing cells ??
- Compile Error ...
- Help with userform?
- Update value in existing row by finding text value
- Updating 2003 macros now that I'm using Excel 2007
- Adding Option Buttons
- Sports Team W/L Counter.
- Formula for pricing discount
- Need help with formula - not sure what I need?
- Offset tricky FX conversion
- copying last row of a sheet to another sheet
- HLookUP & Table Array Not Working
- Code to find and del entire row
- merge text from rows
- creating TOC & numbering the pages of the sheet
- what is the formula
- SUMIF with a SUBTOTAL
- Calculate number of seconds from time - VBA
- Excel to MS Word Photo Merge
- Paste Clipboard Contents
- Problem using IF
- Sorting in Excel
- Macro to open specific files and copy data from week number sheets
- Changing a #N/A to a zero?
- Multiple strings in an array
- Go to 3rd non blank cell
- vlookup reads 0123 then barcode 123, where is 0?
- Populating array with a loop code but not able to sum Array
- shockwave
- Excel - How do I ....
- Excel If
- Adding/Removing Items Userform Listbox
- Code to copy formula down the list
- VBA - Selecting two columns based on variable
- Conditional Formatting ~ additional criteria
- save and exit button
- Opening Access from Excel and keeping it Open
- Look up question.
- Contents of Cells Issue
- using cell contents for range in vlookup formula
- vlookup copy offset
- show only the number
- Comments
- Copy Excel Graphs to Word Doc (Bookmarks)
- Chart Title
- Alphabetising a cell
- Calculating totals in unknown cell references.
- VBA equivalent of "INDEX"?
- Copy A/F Data to new sheet & retain Format
- Struggling with VBA to allow select cell
- find min value depending on range
- Conditional formatting with four conditions
- Simple validation in VBA
- Excel formula for Outlook 2003
- Complex lookup............maybe
- formating of data copied from site
- finding data between date range
- excel 2007 workbook by default
- Multiple worksheets
- Finding the address of a cell containing a value
- Mutiiple Data for Same Date
- Open Access from Excel and keep it open
- Calendar Control 11 Problem
- Two Workbooks, One data set
- Allocate numerical value to specific words found in spreadsheet
- Question regarding macro triggering, etc.
- Apply Filter and Copy data to new workbook
- Calculating day of week on a range of dates
- Certain clip art will be seen among all others base on cell value with formula!
- Formula question
- Date/Year - Schedule & Calculation
- Finding cells with a number and replacing with an "X"
- TRIM fx
- Deleting based on filters
- Macros: Compile Error: Syntax Error
- Macro / VBA help on copying and coloring
- Monthly Scrap Report
- strange gray area
- Excel 2007 filter dropdown: selecting a single value
- IF statement to look up different cells based on value
- Tablet Signature Userform
- Enabling Option Buttons based on a drop down selection
- Chart: Ignore zeroes. (#N/A doesn't work)
- Saving off column widths for use later
- Complicated sort problem
- Drop Down List Comparison
- Easy way to join two tables based on a field?
- SUM('end sheet:first sheet'!B129)
- extract some text from the cell
- Find -> Offset by -1 -> Select Sheet Value
- Show the values of cells separated by a + character or there is 1 value.
- Select case <> question
- exporting access data to excel pivottable
- Import indented txt to unique columns
- remove line and add to a userform
- Determining if a hidden worksheet exists in VBA
- Date Calculation
- Date problem while querying Access table from Excel
- Cell Reference for Headings
- Copy Data with IF Function
- Using VLOOKUP to retrieve multiple data for the lookup value
- Want to recognize contents not value to derive %
- Text instead of a cell reference
- GETPIVOTDATA #Ref
- Are all values the same.
- Return data from range
- Sumproduct help
- having problems
- Moving from the active sheet to another sheet in a loop
- Calculating Negative numbers
- Filter records based on the value of a cell
- An easy one hopefully!
- Help, Multiple Actions on IF (IF X=1, PERFORM TWO ACTIONS )
- Display value in text box and be able to change the value on a worksheet
- Macro Icon
- Hide blanks in userform combobox
- UDF Rounding Unexpectedly
- how to read Excel file
- Delete Row Depending on value
- How to find first empty cell in column, return value of previous cell in column
- Pivot table: Can I "Show Detail" in same sheet, not open a second sheet
- Triggering Macro When Drop Down List value is changed
- Extracting Hyperlingks from cells
- Rounding up/down to the closest 50
- Compile error
- Average Formula
- Compile range and offset
- Pivot Table
- Help with AdvancedFilter in VB
- Math equation in a Userform
- Why is my vlookup formula returning #Value!
- Minor issue in workbook with runtime error '1004'
- Inserting formula into dynamic column with dynamic rows
- Refresh Data
- MAX Value with Criteria
- Macro- Duplicate workbook on save
- worksheet merge /append 911
- Hyperlinks
- Multiple UserForms opening
- Screen Flashing
- Range 1st Empty Row Select
- reading value from a closed workbook
- Windows Rights Management Services Client
- Possible to extract Data from a Website?
- Copy and paste a row multiple times
- Small Scale Stock Sheet / Epos style spreadsheet. Possible?
- Vlookup table array argument as list box
- Offset compile error (sub or function not defined)
- Loop Through CodeName . .
- Sumifs with Or Conditions
- Autofill
- macro for new worksheet
- interest payment due
- Conditional Formatting
- Filter/Sort
- If value in range1 does not exist in range2 add entire row
- Snapping Button to Cell Size
- Expand (extrapolate) a column by a certain # based on column data
- allowing just numbers in cell
- copy data from one spreadsheet to another
- copying data from other sheets automatically
- Find a / in a string
- Limit line on excel graph
- Please help me
- Pivot Table in a Macro
- Clicking in source code
- How to Check for Duplicates between two columns
- Pivot Table calcuation between columns
- An explanation of how this loops, please?
- File to Folder Confirmation Macro
- Counting days
- Radio Button
- Setting out to learn VBA
- Syntax problem with ActiveChart.Location
- current weeknumber
- finding the first monday of the month with month (integer) and day integer
- Hide Zero or No Data Dates in Chart
- Protecting Issues
- Percentage formulas and #DIV/0! errors
- Reverse Two Way Lookup With Duplicates
- Please help..
- verify all cells in range have same contents
- IF, Then Formula Question
- Custom Table Numbering UDF Failure with CalculateFull on other Sheets
- Drop down list - auto fill capability?
- Macro To Add Rows When You Press A Button.
- Formula help
- Finding unique entries in a database
- Match and Return
- Copying to another workbook with line dropdown
- Math Question
- is this macro possible
- Formula to dicate link between checkbox and cell
- Multiple Conditions in IF Statements with Ranged Numbers
- Master Sheet/Consolidation
- Sort Problem with Macro
- LARGE of non-contiguous
- Place date in cell H6 automatically
- Referring to another workbook within a Function
- days between two dates
- Web Queries
- NWE changes to NEW when entered in cell
- help with a runtime error
- Networkdays passed, including holidays
- If Unsaved File is Open, Then...
- Remote File Type in Edit Links message box
- Offset?
- Formulas changing as I move columns around
- Need help to tweak a code
- How to find missing numbers
- Pivot Charts Format
- Print Macro
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.