View Full Version : Excel Questions
- Finding matching info in dif columns & rows - maybe the impo
- calculating overtime for timesheets
- Conditional Formating
- How to format a $ sign into a blank cell?
- How do you swap table axes?
- Make a string an object?
- Delete macros with VBA code?
- X to close UserForm problem (SOLVED)
- Formula
- Finding Next Available Sheet?
- linking data from one sheet to another
- Bullets within the worksheet
- Prompt for Data in Excel
- Custom views
- Combining Columns
- If Then Statement
- Macro to Delete Repeating Info
- MACRO DON'T WORK
- Summing! Need to sum text too!! The planetpj query
- Macro
- Tabbing Between Form Boxes
- Formula
- Dynamic Named Ranges
- Excel FTP
- A Challenge for Excel Gurus - Sumproduct does NOT work!
- Update SQL serve DB from EXCEL spread sheet
- How to keep track of the fresh rows in all the columns
- Problems with Marking cells as changed
- my spreadsheet keeps moving or replacing data when i try to
- Workbook Closes But I can Still See It
- SumProduct - based on more than one criteria
- What is the Cell character limit for Excel97?
- how is a macro made that totals, but needs to work with diff
- Find and replace, cells colors
- decimal to fraction conversion incorrect
- Weighted Averages
- how do i send a workbook without the vba (SOLVED)
- IF() Formula help
- Record Macro
- How Lock a single Cell from being modified
- Nseting VLOOKup and HLOOKup
- Excel, making PC beep
- IRR - limited to 45 cells?
- AutoRecover - auto disable
- YIKES! My CSE Formula went south on me
- SUM NOT WORKING WITH MULTIPLE CONDITIONS
- 97 vs 2000?
- PRODUCTSUM
- Numbering Invoices
- Locking format in 2000
- Custom formula
- Quick Userform question
- Television Time Code Program
- close macro
- 2 columns 1 is wrong
- Help on the best way to handle a project
- How do I save to multiple destinations automatically?
- userforms
- Comparing lists
- Help - My list validation has been breeched!
- How to retain the sheet index
- Today's Date
- Why does this code not work?
- Check to see if cell is in a range
- Cricket bating average
- Cleaners
- setting expiry date for worksheet
- Working hours
- timesheet in overtime
- Split Window Graph / Table
- MACRO HELP
- Sum only negative or positive amounts
- Formula for Pivottable data
- How to use Forecast?
- Save as
- New Help - Quick
- Interpolation
- No scroll bars wanted
- Extending Columns in Excel
- nedd some excel help please
- Disabling External Data (Query) Error Message
- VB Question
- Match invoice numbers in different columns and rows
- filtering lists
- Customer Database Help
- VLOOKUP
- combobox
- dynamic name
- Lookups
- One more question please
- Code for Dynamic Range
- Vlookup Error
- Ranking multiple data sets...?!
- Chart updates
- macro to send email
- Saving notification
- Asking George B
- MOVE TWO CELLS OVER MACRO
- Naked Worksheet
- Control
- Macro to locate next blank cell foot of column
- Cricket bating average per season
- Manual Recalculate
- format #
- Can Someone Check my Code Please
- Dim variable as range syntax
- copy /pasting
- For Experts: Do You now better ActiveX Controls as builtin M
- Creating an argument using text to give a numeric value
- help with a macro please
- macro question with degree of difficulty
- problem with textbox linked with a cell
- reached my limit .......
- Cursor runs off to other controls on the form
- Charting question
- VBA Help
- VBA Help
- send_mail function question
- VBA Commands
- VLookup with Multi Range
- Efficient way of removing lines?
- Changing the cell range
- Transferring stat data
- VBa Help
- Time expressed as a Decimal
- Vlookup and If Statement
- inserting spaces
- water mark
- Hours Calculation
- Counif or Sumif with more than 1 condition?
- CopyFile command
- ID/Password/URLs
- Conditional Formatting by Text and Colot
- I wanta be lazy with 01:30 &17:30 input time (Att: Steve) Wo
- Better than 20 Basic Macros
- background color
- How to change the size of just one cell and prevent a cells
- How to ensure no duplicates
- Emailing Single worksheets in multi sheet workbook
- Calculating Hash Total 11 digits long
- conditional formating
- Print Area Macro to allow for change in print area
- VBA
- Colouring of Cells.
- Referencing cells to/from workbooks`
- ordering non-similar data sets
- excel training
- Searching a range of dates for a match, then perform action
- Automatic numbering
- Stopping Hidden Cells being Conditionally Formatted
- get the active rows number in VBA
- Seaching Lists
- SELECT A PRICE FROM A PRICE GRID
- Using the 'Send To' menu in Excel to send to the floppy
- Save a stop save code
- email capabilities
- Cell date format
- Replacing the Microsoft Excel header....
- Autorun macro after Drop down selected
- CONDITIONAL FORMATTING
- Running an Access Query from Excel VB Macro
- wandering date format
- Multiple Users of Same Spreadsheet - random close behavior
- Formula Query
- VB search problem.
- Excel automation - useful link
- text across columns, or text across rows
- Function to calculate MAPE
- Make 2 columns from 1 column
- Write a formula depending on cell color
- % FORMULA
- THANK YOU !!!!!!!!!!!!!!!!!!!!!!!!!
- headers from cell value
- Text Box Value
- help with a macro please
- Display a date 2 days ahead of todays date
- Simple formula appers to work fine, then bongs!
- left justify with a listbox?
- Need some VBA help please
- vba /sendkeys ?
- Can this be done?
- Pivot Tables with VBA
- stock sheet
- sumproduct
- error message when inserting columns/rows
- Extract a zip code from string
- filters
- Countif Formula
- find max value from DDE stream
- identify specific text in a column then mark it in adjacent
- Removing Blank Rows From Large Spreadsheets
- Concatenate Trim??
- countif
- Web Query
- Carriage return & enter keys do not work
- Find value in any of 3 different columns and return value of
- Can formulas be too big for VB
- Link a form's position to a cell ?
- multiple addition / comparison
- Macro across multiple sheets
- inserting rows after value change
- running macros on multiple files
- Incorrect display in ColorIndex Help File
- How to sum numbers that form an integer
- dialogsheets
- How to Auto Update Excel Macros
- Moving Data from Rows to Columns? Copy and Paste?
- File protection
- assigning a macro to a shape
- VBA Lookup
- How do I create a drop down list like Autofilter does
- Insert a row in a protected worksheet
- Converting large number to individualized cells
- Task Bar Button
- automatically updating graphs
- Common Dialog...
- Bracketing numbers
- update particular row in Master workbook
- Help! selecting multiple criteria using custom autofilter
- Right Click & Copy Sheet
- Currency Converter in Excel?
- SUM only certain ones
- Add Sheets to Toolbar
- checking to see if a directory exists
- Answer to: conditional copy, push data, etc
- Selecting folder for file output in VBA
- Finding Last Cell's Address Using Formula
- Auto disable hyperlinks
- Need Excel equivalent to Lotus down, up, left right.
- lookup to another table
- Percentage
- Help me in Writing Formula.
- printing duplex
- offset
- Please Help
- Removing a macro when closing workbook
- Cell always AM or always PM
- Pivot Table Question
- Separate a string
- Shows dates but when I print it prints out #
- Adding a command button to a chart
- question on InputBoxes (SOLVED)
- Run Time Error '1004'
- can't sort past row 1847
- My chart will not show the results from an "if" statement
- filter and formula combination
- Replace a column of numbers with specific phrases
- excel and vb
- Need help with Copy and paste formula...
- "Save As" macro assistance needed
vBulletin® v3.8.4, Copyright ©2000-2009, Jelsoft Enterprises Ltd.