- nested sum if.
- Dim a value???, PROBLEM SOLVED
- Count cells with Dates
- How can you copy one sheet over another sheet in VBA ?
- copying data from vertical to horizontal
- tracking accrued medical and sick leave
- Concatenate cells and hold onto conditional formatting
- Avoid "=" sign when putting formula
- a quick one
- calling all sheep
- Unique Format Requirements for Save As
- COMMANDBAR - CB ends up under Window Menu Bar ??
- Easy formatting question
- How can I restrict access to source code?
- mathematical analyse of data
- Need Help
- Adding time to a date format
- Weekly Data accumulate as ("Month/Qtr./Half Year")
- Paradox 5.0 & MS Excel
- Possible to MATCH names in matrix layout?
- lookup data from a lotus notes database view
- Parsing problem with downloaded data
- Optimalization: Making a squash competition
- Labelling Columns in Excel 97
- Can you show a form in Excel that is not Modal
- Saving an excel file by using a macro
- Warning Message
- Excel functions And & OR
- quick help
- Formula to obtain worksheet's name?
- how to group
- Date time Macro or Formula.
- Inserting paste values to a cell ref:-
- Searching for non-duplicate info
- Doing Time
- Importing CSV files into Excel
- Running a macro but no file to open?
- Rounding Question - Advanced?
- Opening A File
- error saving workbook
- Venn Diagrams - Link to data range?
- Bold a range if certain criteria is met.
- VLOOKUP
- Hiding Select Rows in Excel Using VBA
- TEMPLATE WIZARD DATA TRACKING
- Aladin Educate Me Need Some Theory on Sumproduct
- Combo Boxes
- How to Sort my worksheet in ascending order?
- Counting filtered sorts
- Font colours in formulae
- Column List of Formulas
- n-dimensional data clouds
- Launch macro when something is saved in certain directory.
- Macro to paste values transpose
- Mass removal of hyperlinks
- SORT
- Applying Filters?
- Excel97 -always asks if I want to save
- Workbook Events - how many workbook events needed to build o
- Conditional Formatting?
- Simple Query
- Match and N/A
- wren17
- ZIPCODES
- Conditional Sum
- Venn Diagrams (v2)
- Unique references (hopefully in the right board this time!)
- Array Formula Question?
- User Form Help
- Old Macro from Lotus to Excel 2000
- Firing off macros from Excel events
- Timestamping a task list
- "Out of Memory" in VBA/Excel
- targeting a printer
- baggarwal see this....
- shortest route
- End macro on cell that triggered macro
- Freezing Panes -- Basic Question
- command button hyperlink?
- Problem Naming Ranges
- Excel 97 vs Excel 2000
- How can I change the order of a cell conten?
- what's this error message?
- Toolbar/Options/Calculation
- import a tab separated file
- Payroll acumulation
- Protected sheets and spell check.
- Data Validation using VBA
- Making Repetative Charts
- Copy and paste a row of cells based on a number in a range
- Is there a way to get a macro to create a table of Names and
- sorting problems
- macro needed
- Can you make a "Sort By" link?
- Here's a tough one
- hotkey for selecting name box
- Combining text and results
- ToggleButton
- Saving tables to use for VLOOKUP
- Another Array Formula Question.....oops!
- compile error for Vlookup
- Getting the name of highlithed cell
- Time and date
- round to nearest 50
- Creating plots in VBA
- Last active cell in column
- convert data in row 2 column
- SEARCH-SUBSTITUTE against an array...need help!
- Fooling Excel
- Save Excel File into a Tab-Delimited File - by MACRO
- Cell view real time.
- ONGOING DATABASE ENTRY PROBLEM
- Find formatted cells and add row under each instance
- data matching
- Help with a conditional copy paste code
- Bell Curve in Graph formatting
- I need help calculating the total number of times a date is
- Remove "Minus's" From A Column Of Figures ??
- Lookup
- Need help to make this code easier.
- Columnar Chart with 3 parts
- naming a formula problem
- return value in column1 dependant on max value in column 2
- Nearest number
- Calculating overtime balances
- saving twice
- Protected sheet without fill color
- Nested functions limit
- Changing Interior of certain active cells (SOLVED)
- Way to calculate week number based on date?
- Custom Toolbars
- Audits
- Insert an entire row using variables.
- Cell returning my number divided by 100
- Insert variable name for external data importing
- I need help!!!Simple question
- VB: finding associated data in SQL?
- simple question on graph
- excel formula book suggestions???
- Select/Place graphic into sheet?
- conditional?
- Save only one worksheet from a file
- Control Characters
- Return the value of a Named Cell
- using excel formulas for coin analysis
- Scatter Plot over time
- yes/no decision making
- How to use brackets instead of minus figure for showing defi
- link to a dynamic range in another excel file
- Stacked columns in charts - can you do double columns?
- Select every 20th row in the workbook
- Return the name of the day from a date
- Visual basic error opening sreadsheet
- UserForms
- Numbers
- Check a FORM, if it is loaded or not?????
- Inserting a variable
- validation custom
- Aaron ICT- basic questions
- Error Message when help loads
- adjust the size from userforms
- Macro Copy & Paste?
- Index offset I think (Thanks In Advance)
- Formulas & templates
- conditional images
- Creating an archive sheet.
- non showing Components in Component Addin window.
- Microsoft has no support for LOTUS macros in EXCEL 2000
- Concatenate
- Old excel
- Lease Table
- Explanation a bit clearer..
- Sumif Vlookup (probably an easy question)
- Bizarre Problem
- Automatic Data transfer
- Reference error
- conditional formatting
- VBA Macro question
- Condittional Formatting a Row based on a Cell Value
- Protected Worksheet
- Totals When Filtered
- Exclude a range
- transparent VBA controls
- Automaticallly fill a worksheet template from another file
- Sort by Colour (color)???
- Change ODBC driver in EXCEL query
- Splitting Sentences
- Conditional Question
- Microsoft Access Query not running in Excel
- Is it possible to change color of message box and its text?
- File path in custom header.
- Whats the selected range ?
- How to Add an Item to a specific column to a ListBox using t
- Count if
- Visible Characters
- MsgBox to tell if worksheet is protected or not protected
- Quick Question
- Msg Box in macro
- Time
- Prevent renaming of sheet
- vlookup returns 0
- Formula request
- cell customizing
- Run a macro in another sheet from the one it was created in?
- Listing files in a MS Explorer folder in spreadsheet
- Listing files in a MS Explorer folder in spreadsheet
- Countif cell fall within date range
- Tangent, Slope, Best Fit?
- Arrow Problem
- struggling with row inserts in a macro...
- Print Range
- VB copy
- Returned value triggers macro - Worksheet change?
- Find formatted cells and add row under each instance
- Moving Cells from a horizontal base to a vertical list
- I want a sample macro
- conditional format non-blank cell
- conditional formatting
- Min Value
- Yet another Header/Footer question
- How to sort month?
- Finding a number(s)
- COUNTING FRQUENCY OF EVENTS IN A TABLE OF NUMBERS
- should I be using a loop
- need a formula
- Get a macro to edit cells
- How do I stop Automatic Updating??
- autofill question
- Macro help
- VBA Workbook Procedure
- Entering from one sheet to another problem
- Deleting a List
- FINDING MAX VALUES IN SELECTED ROW
- Switching Category and Value axes
- Renaming workbook in VBA & Sum function?
- Adding in a Column
- Counting blocks rather than amounts
- Active X Controls
- VB Equivalent to Caller
- Help writing a macro to filter
- how do i find blanks (in if statement)
- Conditional Formating
- real simple question one for scrolling left or right
- why won't VLOOKUP search entire word?
- Compressing Spreadsheet
- Splitting Last Name and First name
- Hyperlink Changes the Direction of Slashes
- " Colo's cool utility" - instructions
- Relative/Absolute References Across Files
- Sumif withVlookup or something different.