View Full Version : Excel Questions
- Nested List Box Enquiry
- If/match/vlookup?
- Runtime Error 13 on pasting multiple items
- 2007 Pivot Value Filter problem
- Sum a column if another cell in the same row contains a defined text string within the text
- using (Range) with .FormulaLocal
- Data Bars - coditional formatting error
- Concatenate Time & AM / PM to 24hr format
- Disable 'PasteSpecial' & 'Formats'
- Hiding Cell Fill Colors in Printing
- SUM values into 1 cell
- How to make a listbox backcolor transparent?
- Array formula
- Consolidate/Link workbooks together
- How can I return the month name by using =month formula & lookup
- copy+paste special, then copy and paste again loop macro
- Use of Macro to insert a new line in a table
- Reducing a file size
- IF statement, output text.
- Latest date formula
- Wait
- Get pivot data and max
- Top 10 Pivot Table Query
- using excel sheet1 to input data to sheet2
- formula to take data from sheet1 line1 and add it to sheet to next avaliable line please!
- vba vbs print setup takes too long
- Difficult .. isn't it ?
- Date issues with Autofilter
- Manual calculation on Open
- Excel - word - macro
- Advanced CountIF
- Excel Wizard Required - Please Help Me With My Formula
- Excel 2002 to 2003 VBA problem
- VBA Selection Resize by One Col Right
- Import data from Website
- runtime error 13 type mismatch
- Clicking a link using VBA
- merge numbers of two cells into one.
- xlsm macros not working
- Checking if a file is open before running a macro
- Macro to make my life easier
- Macro help re email solution
- Charting only the months I have data for
- VBA - elseif or if many ifs question. Please help
- adding unique identifier to like values
- stop process without closing out excel
- change the font in the formula bar
- How can i copy rows containing certain email addresses onto another worksheet
- Speed up formula fill in vba?
- Collating information from individual spreadsheets
- VBA Code
- VBA open workbook, copy, paste, close workbook
- countif a number > a number
- Continuing a loop after finding data
- Limiting further filters based on pre-selected filters
- Macro to extract worksheet
- Format cell as Currency or Number based on value of another cell
- Preventing Duplicate entries in Column of Excel(during Copy/paste)?
- Complete compare XLS Files, help updating code from another post please! Most amazing question ever!!!
- Reiterative "Vlookup" of sorts..
- How to exclude an emtpy cell
- Can't Disable Workbook Link to Internet
- formulas suddenly stopped working
- Possible to email saved file via excel
- Extracting string from a cell
- Link Finder
- Autofilter character limit in cell to search?
- VbyesNO....need more help. Add few more line..Thanks
- Link with drop downs
- Excel Macros > Word
- Hidden Tabs in 2007 causing Macro not to work
- Multiple File Opens
- If iserror using averages of formulas
- Check Box Questions
- Lookup with multiple outcomes
- Range Selection
- Copy more than 9000 filtered rows to another sheet
- Find value in a listbox and update info
- Vlookup with 2 numbers
- List Box Justification
- Email the last saved file as an attachment - HELP NEEDED!
- Complicated VLOOKUP array?
- Skip macro when target cell contains value
- Summing the Best 10 out of 15?
- BarCode For Keyboard Buttons
- Rounding up to 4's
- Help with Vlookup function
- Delete Row Macro
- Grouping Option Buttons on a worksheet
- Disable 'Drag' & 'Drop'
- Parsing Macro
- calculation with named range col but same return col number instead of values
- Excel 2003 and XML extracts
- Staff Calender
- Taking JUST last two digits off a number?
- Ch = Chr$(13)
- SUMIF question
- SUM IF has a Match
- Flatten all excel linked objects in powerpoint
- Is there a global setting for formatting?
- Left string function quit working after adding a library reference to Reflection for UNIX and OpenVMS
- Dynamic range for chart on cursor
- Formula help needed
- Linking Data
- If function date
- limit to number of workbooks allowed to be linked?
- Doing a Vlookup using indirect. Broke
- Excel to PDF
- Lost work days chart
- Keep Total in Cell?
- Proably too easy but I need help
- Conditional Vlookup Help
- How to move a row based on a condition
- Increasing Maximum on an IF/Then calc
- ignore cell with #DIV/0! in subsequent formula
- Sum Range Data
- Excel into Word/Email?
- #VALUE! Error Help
- Macro to save file name as Cell Contents
- Lookup
- Macro to Copy and Paste Values to File Based on Tab Name
- Copy paste hyperlink of a cell value.
- V lookup
- Issue Unlocking Text in Excel Text Box after saving
- Autofilter to filter data with null date fields.
- Drop-down list
- Ranking, vlookup
- Deleting rows without data
- Help, Lookup up info for closest date
- Absolute cell references for a block of cells?
- Absolute cell references not working
- Message Box Query
- Determine If Active Sheet is Chart
- Help with multiple IF's in formula
- HELP - Formula Needed
- Duplicate Address Deletion
- Count
- Dynamic Floating Range
- Formula: Row Selection
- loop and wait for button push
- Compile Error help
- Clone worksheet from one workbook to another?
- VBA formatting to last non-blank cell
- Find end of worksheet and add a row
- Auto refresh if less than now()
- Find duplicate rows of data across 4000 rows
- Naming range of cells
- City and State Match
- Best Way to Protect a Dashboard???
- Query Excel Page from Web Page
- VBA radar plot creation
- If Then Statement for cell with drop down menu
- Formula
- cut row based on a criteria
- Row 8 as constant Header
- VBA to rename only certain pictures in worksheet
- Unique values in column B for each unique column A
- Macro on one worksheet doesn't run the same when ran from Personal.xls
- Copy sheets to new workbook without buttons?
- 3rd Time asking, without response on 1 and 2
- Declaring Dynamic Arrays with Unknown Size
- Copy Paste Macro Help
- Loop through select rows and start at next column until empty column
- Lock cell after first edit on shared workbook
- Flashing text
- Iteration macro
- A formula to add a date based on a day
- Automation Error - Catastrophic Failure
- Adding to total by clicking button
- Can I Concatenate two cells and keep superscript?
- Help with copy/paste code
- Emailing from data in a spreadsheet
- Finding # of days between dates
- Things to keep in mind for Excel Mobile
- DDE link excel
- Using Range(Cells(
- event vba not working. Need help. Thanks
- VB: default cell formula
- Tab => Boxes of question marks - What's wrong?
- Copy Multiple Rows only increase formula by 1
- Formula to assign numeric valves
- If a1 is not equal to b1 then highlight..How do you set that up?
- How to control focus when alternating a user form with a sheet
- Count formula help
- Macro to disable external connections
- Summing up assigned values
- Need help to rearrange cells
- Color Coding (7 values)
- Data Table only Calculates with button
- ComboBox / Listbox Update Question
- Substituting only for a specific value
- Collecting values
- Hyperlink to Specific Worksheet
- Macro for sorting through negative profit
- Hide rows based on cell formula output
- Popluating blank cells with values above them
- scanerio using dropdown box or combo box.
- Function execution on click?
- Consolidating my VBA code
- Help, I Need Some Code!!
- Copying/Pasting Next Row Down after Text Search
- where are the old auto-save docs
- Combine Rows of Data Based On Cell Content
- Excel Graph
- Rounding down a date to the nearest HOUR
- What is the best command for bond yield? What is the difference between Yield formula and YieldMat
- getting SQL right for simple Excel query of Access Database
- Assign a value to the second highest
- Column formatting
- How to Ignore Blanks in an If Statement
- AutoFilter Error
- Autoinsert multiple rows
- Populate range of cells based on user input
- Web Import, SQL Table mess
- Charting help: Series colour from None to anything
- Help with Hyperlinks
- Help with Indirect Reference
- Assigning Numeric Value to Text
- Complicated Project Planning Graph
- Chart disappears when outline collapsed
- Mass copy worksheets
- removing excess number in a cell
- Need Imeddiate help with excel formula question for work
- Change Password using Macro
- Link for no.of Password attempts
- Disabling the VB script
- vba - need to refresh SPECIFIC pivot table
- Minimum and Maximum value of a range
- Looking for help with combinations problem in Excel 07
- VBA code to clear all filters in pivot table fields
- SUMIF, unless adjacent range has numbers.
- Averages for a row excluding one cell...
- Lookup? Match? Taking data from one column to another based on select criteria.
- referencing sheets
- Using LOOKUP functions to give AVERAGE range
- comparing trends of numbers in a column
- Summing based on value
- logical test problems creating formula
- Not sure what I need, any opinions?
- Pivot Table | Values Default to Euro Currency
- Editing Cells above freeze panes area
- Pivot Table | Values Default to Euro Currency
- Formula needed for address list
- Freeze Bottom Row?
- Toglge button linked cells
- Setting work time at Excel
- Help with a swing trading ss
- An Excel question
- VBA - Macro Send Email (from:)
- Help - Validating excel
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.