View Full Version : Excel Questions
- Array formula help.
- Simple if statement
- conditional delete row, and more
- If Blank formula
- help with VLOOKUP
- Setting up an Invoice to print only the inputted data
- Autosort after tabbing through column
- delay timer
- if fuction help
- A way to Copy and Paste?
- Sum extracted data
- Adding sound to a result from a formula
- Help with extracting characters from cell
- Excel Reference Material Question
- My code falls over when it encounter merged cells
- Autofill column with data from a row?
- Any one prepared to check my formula manipulation please?
- Do icons change but keep the same faceid on differing Excel versions
- Tuning millions into thousands
- 500,000 dependencies causing calc probs
- VBA Macro To Find Value & Copy Corresponding Cell
- Set built in properties of workbook
- how i compile the matter in one excel file
- HELP ME TO CONVERT EXCEL FORMULA TO vba
- While create array, out of range error.
- match text in two columns, return a numerical value when the match is found
- Separate terms
- Report with more than two criteria
- Sort Columns by Double Click
- Getting rid of blank cells in a column???
- first letter capitalisation
- Do not run Macro if worksheet name is.
- How to select common value from three rows???
- inputbox
- MMULT Count Matched Scores 2008 greater than 2007
- How do you divide a Number by Time?
- Autofit
- Using a pivot table as a template
- Macro to save data then clear/reset option buttons
- Formulae that needs shortening
- 4 button msgbox
- Vlookup when change made in autofilter
- Round Square Root
- VLOOKUP with a unique variable requirement?
- Index/Match functions with #/NA error
- Can Excel Count Cells in a Color Range?
- Has there been a Service Pack that has affected Plotting
- Lost VBA References
- finding the second result from another sheet
- Charts function different in Excel 2007 than 2003
- Insert cell contents into an expression?
- Rounded to one.
- Lookup code Optimization
- how can i make a chart from multiple worksheets ?
- Modifying Formula
- vba ? from a greenhorn
- Help with Comments please :)
- Get a range loop get the next range
- Imported CSV Files Do Not Open Properly
- How to get a macro to run every time someone clicks on a sheet
- Search for specific Characters in a range of cells
- Range from name
- VBA range offset
- Filtering using VBA Issue
- Error Trap when file does not exist
- Help adjusting absolute references to relative
- Nesting a conditional and math formula together
- Formula to ID cells containing a formula
- excel online
- Meeting more than criteria
- Autofill & Cell and Range Reference
- Syntax issues with Excel import data macro
- vb question
- Chart To Find BreakingPoint
- Macro to extract data from one sheet to another sheet
- Need help converting a date
- Progress indicator
- Grouping
- Drag cell content
- Need Help with Code Optimization for an UDF
- Hide Sheets, then need password to unhide
- Who's up for a challenge? ...Inventory of Materials
- Rounding Error
- Calling Sub from Sub
- Extract Right Text from variable Path
- Lookup a value in a 4 column range
- Variable ranges and variable start points between sheets
- Showing Tabs based on Ranged Values..
- Exclude Value in Rank Formula
- Locking Cells
- excel working
- search for file VBA
- Repeated items - code
- Excel sheet to PDF using a Macro
- how to avoid #REF when column in deleted
- Copy format and value of cell in macro function
- macro to update time contineously
- how to SUMIF at this problem
- special sum-formule (should be simpel)
- Sheet References Within Formulae
- A formula req
- copy, paste cell with spaces but keep integrity
- Server Based Excel Deployment
- How to display last 40 in a chart?
- on Error go to code
- VBA read rows from another workbook
- How to add 2 numbers together
- Cell merge
- = to the sum, but cannot be great than
- Image effects without VBA
- Using a FIND formula in an IF statement
- Option buttons to show different frames?
- Polar charts
- VBA - selecting the last cell in a column with data
- Lookup Master Code and Paste a value in the next empty cell
- Rounding a number down
- Inventory Managment updating balance
- conditional formatting
- Opening chosen password protected file through macro
- Creating summary table
- text2cols worksheet function and hex values
- .Formula changes ; into ,
- open doc file in excel - not working!
- Need Help in Find An replace
- Auto Run Macro
- Change VBA Decimal Separator
- Formulas with words
- Stopping a counting process in dice simulation
- Reference a cell containing a circular reference
- hiding rows in shared protected workbook at intervals
- Macro failing after workbooks.open
- Help with Lookup Formula
- Date search macro runs, but returns no results
- code to fill out unique number
- Sorting an array - what is the most efficient way?
- Extract Cell Value from Closed Workbook, report to master list
- Excel 2003 Not calculating
- copy 30 cells then paste consecutively.
- Excel Query
- Automatic colour change of row when cell in different worksheet colour changes
- too many cell formats
- Summing Data
- Formula error
- Unprotect / Protect code with macro
- Subtotals - Help
- Help with Chart
- Return a value from a table, within a specific range of numbers
- How to move info from one workbook to another
- place command button based on cell value
- Sumif cells non-empty
- Address in formula
- Mouseover effects
- Conditional Formula
- Deleting Rows
- Return latest date within a range
- VB working for some not all
- Replacing the contents of a table
- SumProduct w/ Massive Data - Faster Calc?
- Sumproduct Max Characters/Soultion?
- How can I get my Excel 2003 groups to behave the same in Excel 2007?
- Excel Combo Box question
- Select Cells
- Deleting Row where total appears
- Picking Values from a row with blanks?
- Harlan Grove Pull Function
- Error on Changing Scale on a Chart
- copying cells in a column to another workbook
- Hide sheet but not affect macro
- Multiple Data
- Copy Cell if certain conditions are met.
- Stop macro until calculations complete?
- Quick pivot question
- Present value
- Subtotals - Lose Details
- Comparing two sheets in the same workbook
- Max and Min Conditional
- Copying values over
- Message Box Help
- Custom Menu modification
- Manually update Excel to Word table links
- How to use "*" with unknown text ?
- Files
- Circular Argument
- Convert to columns of data to single column
- VBA: Calculating the joint variance of two distinct cell ranges
- Range lookup and get upper / lower cell value
- Creating pivot table from a variant
- Reverse name in a cell
- drop down box
- Excel 2003 - cell reference problem
- Excel to Word...same formatting...
- clocks on userforms
- Each cell prints to individual page
- Delete Row if Cell Value is not Number
- Data List From Pivot Table
- A little help for a newbie please
- Cannot move to different cells using arrow keys!
- Not sure if it should be SUMIF or SUMPRODUCT
- Following linked excel data in linked worksheets
- Custom Help File
- X/y sum....?
- Macro for Sumproduct
- copy part of text string to another column
- explain this if statement to me please
- best way to do this
- SendKeys gone wrong ...
- Excel & Access Newbie question
- alhabetical sort
- Formula - only SUM based on criteria
- quick macro row selection question
- Beginner: Missing series lines?
- In Middle of executing a macro it jumps to combo box change sub
- Time rounding Macro
- Calculation Problem - UDF doesn't give expected result - Please help
- Date into day
- Question about the MOD function with respect to returned datatype.
- How to Hyperlink Charts/Graphs
- Datasheet control in Excel VBA
- Macro For Auto Filling Data into Blank Cells
- stopwatch registring multible times
- Count after Certain Date
- Wierd SQL/Macro issue
- Formatting issue that involves using the "SUM" function
- looking up by reference
- Trying to change the formula in a dynamic named range
- referencing other excel workbooks with unknown names
- Formula based on formula to ignore subtotals
- Scan and copy particular columns who satisfy two criterions
- Macro - Move info in a cell to different cell and delete.....
- Leave cell blank until formula gives value
- Vlookup from 2 sources & auto fill-in to vlookup formula
- Multi criteria conditional dsum ?
- Can Excel simulate a financial calculator?
- Excel graph
- Auto-open Userform?
- Private Sub Worksheet_Change??
- IF statements in pivot table
- VBA for Reference Number
- Change sum to count in Subtotal
- Re-Format List
- Round time to nearest 15 minutes
- Chart/Graph Scale Changes
- count if error
- Task Pane Help needed.
- simple 'For Each Cell' question
- Excel formatting problem
- Can I link a cell to a new sheet in the same file?
- Simple Dumb ? for newbie re: Match and Offset
- Help with Info repeated in any array
- Complex Countif Function?
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.