View Full Version : Microsoft Excel
Pages :
1
2
3
4
5
[
6]
7
8
9
- Help with IF statement in cells
- Multiple VLOOKUP Capability
- how can i calculate rating from marks sheet
- Automated importing process
- Save some selected colunm values from sheet1 to sheet 2 as new rows
- Check if Column Exists in Range
- Timed Message?
- Printing Members of an object
- Sheet Protection
- Range of Combobox in Excel
- Finding the Next Available Row
- Countif()
- Finding next avaialbe row in multiple sheets
- Another probbly easier problem
- Counting row
- Loop help
- Delete contents from cells
- Running a Macro in a locked worksheet
- Can I do this with Excel?
- check if excel is already open
- Still having trouble running macro in locked worksheet
- dividing one cell into multiple cells, possible?
- Date created from file
- How can i do it??
- Turn off autoformatting in MSQuery?
- How can you automate export to Access
- HELP[Urgent!!]how to fix the color of the pie slices?
- importing from excel
- Dynamic Named Range Problem
- Sumif with multiple criteria possible???
- MS Query security
- Excel macros - assigning to cell change?
- Last Updated cell
- Advanced filter
- VBA Code for Selective formula writing
- looping rows and matching it with an array
- loop for i = 2 to ???
- VLookup -failing to find a match
- Compare data in two columns
- files exported to excel
- Determine cell font color
- error in cells.find
- Opening a CSV gives me no options
- Need Version issues
- Maybe This is Simple... I need help
- daily values,
- Procedure
- Query table information
- Macro and Worksheets issue
- Finding Cells
- Replacing a cell if it is empty by the value in another cell
- Bank money in,out
- Menu ??
- Emailing Excel Tabs
- File error - Excel export
- OLAP - Pivot Question
- Need Help With Excel/Access
- Data logging snap shot
- Cell character limit
- Application.WorksheetFunction.find
- Losing My Tabs
- mouse scroll
- Merging Cells via VB and Zooming
- Trouble opening an excel file
- run-time errors 32809 and 57121
- How to surpress OLEDB error
- Using an Excel File as an online db
- Excel, Access, SQL or other?
- Complicated Query
- Using VLOOKUP to get at another workbook.
- Replacing the blank cell by value in VBA
- Is it possible
- full name separate into 3 fields
- Color space conversion from RGB to CMYK
- Pie Chart question
- Specified sizing for a Pivot Table.
- Global or Workbook level variables.
- IF function
- Fastest Way to Sort Rows
- Format error message when opening xls file
- vb/excel question
- Data Validation problem.
- Range Names - creating a list of
- text as an argument of SUM function
- Vlookup on more than one column?
- Search Text - Change Color of Text
- overwrite prompt.. how do I stop it?
- QueryTables
- vba loop query
- Replace C/R with @@@
- Doing a for each for a whole bunch of cells
- OLE control button
- If and function
- import into combobox
- chart or spreadsheet on userform
- Extracting data within Excel
- Find a column
- Remove the minus sign
- Conditional SUMIF???
- field Names
- importing XML
- Money Rounding Problem
- Sumif Limitation problem
- Deleting extraneous rows in text file
- billions,trillions..
- Formatting a cell based on the condition of another cell
- VLookup data update request is processing before WorkBook_Open event.
- Excel Error on data refresh to other workbooks.
- Mail Merging Redundant Rows
- Show only required data and transfer to MS Word
- EMail Warning Box
- Status Bar message
- Help needed separating data
- Inserting comment in a locked cell
- Formulas changing when copying to another cell
- Disable user interface
- Visual studio tools for office?
- Select Range questions on a macro
- Find the lowest number and place the number and Column name into in Field
- Linking Cells
- Showing One Cell for Each Value
- Copying and pasting cells in Excel using vba
- filtering data, extract 2 colms to the right
- Simple problem
- copy range from different workbook
- CommandBars OnAction Property Fails
- Most recent file list
- Keeping recordset open after code execution stops
- Pivot Table Data Items
- Calculated Fields in Pivot Table
- Need HELP
- Sorting Issue while protected
- Problems Installing MS Office 2000 Professional
- Microsoft Excel 2000 and a .mdf
- Want to move to another sheet on doubleclicking a cell
- user defined import maps
- Making a command button work
- using pickists
- Linking cells/adding users to it
- Concerting cells to html
- reducing file size
- Excel date calculation...
- Help with the INDIRECT function.
- Filling out through ADO...speedier?
- Shading cell with VBA
- Linking cells: open source to update values
- Question about Set = for split ranges.
- Help needed, creating a fixtures, results and league sheet
- Data transfer between excel files automatically
- Checking if any fields is linked to another
- Export from Excel to .pdf format?
- Excel Generating Errors - Recover and Repair
- If Statements in Excel macros
- csv file dropping leading zeros
- Send chart
- Send chart
- Summing duplicate values
- Distinct list of values, and MS Graph sux.
- VBA Code
- Copy contents if.......
- Problem connecting to database with ADO
- Delete record if cell is empty
- ADO DataSet to Excel
- VLookup
- get source data from Pivot- excel 2003
- division
- Simple question- Comment font size
- confused
- Why does #VALUE! show when adding blank cells?
- How to make a macro a personal macro
- Run a Windows Application from Excel VBA?
- HELP on protecting a worksheet
- File open question
- heirarchical menus help
- Changing Font colour conditionally
- Excel / Word Automation Help
- Excel Checkbox transfer
- dlookup in excel vba....
- New Sheet
- Excel's legend additions
- How to remove a comment in a cell in Excell
- Comment
- Excel, Comment
- Change the shape of the comment
- Launch IE from Excel & control scroll bar
- Create crosshairs on top of form using VBA
- Word Forums?
- Printing custom views
- Programatically change name of worksheet
- Conditional format colors for multiple cells in VBA
- Excel Linked to access
- pivot tables.
- Excel 97/Macro 4.0
- Is there a function that can 'find' text within a cell?
- Is there a way to manually sort fields in a Pivot table?
- refresh chart data.
- Problem with VBA in Excel
- TabStrip
- Excel Price Lists into a Database
- pick userform by searched column location
- search only one column
- Change tab color with conditional formatting
- question about deleting an excel connected to anothers cell formula
- Entering data from a drop-down list
- Copy Data
- Dealing with Seconds in Excel
- Rounding & Truncating
- Display Message when Cell Changed
- Capturing Open and Close events in Excel.
- share txt file as database
- Calculating minutes formula in EXCEL
- Where is toolbar info stored ?
- Change cell color based on values of multiple cells
- Calculate the equation
- Close App after certain period?
- Call to open specific file
- Getting Values from Closed Books
- Dash problem in Microsoft Query
- is it instr??
- Excel function or sub routines available to all excel present and furture
- Programmatically adding hyperlinks
- last day of month?
- each named range in ??? Ranges
- =product(indirect(address((row(j$35)+1-$ai20),column(j$35),true)):j$35)-1
- Select method of range class failed
- using named ranges for easy to read code
- Change datasource for exsting Pivot table
- repeating Macro on selected rows
- Variable cell refernces
- Use MS Excel to Realtime Edit MS Access DBTable
- Variable conditional formatting
- Place Data from MultiSelect Listbox
- sort by month of date
- Multi Select ListBox does not post 1 selection
- modulus
- Cannot Find Blank Cells
- Exporting to text
- A macro for All worksheets.
- Cell size (string length)
- How can I turn of warnings
- truncated rowsource for combobox
- Sharpe ratio for investments
- Create array name dynmamically in Excel VBA
- dynamic drop down list from one or more files
- matrix multiplication in VBA using arrays
- Is that a way to backup a mdb file on a given time?
- hyperlink issue
- using vba for a formula in xl
- tab names and updates
- SETting a Range object
vBulletin v3.5.3, Copyright ©2000-2008, Jelsoft Enterprises Ltd.