View Full Version : Excel Questions
- dde link - grabbing realtime data for analysis
- Macros
- Using Match Function to Find Approximate Words
- Help with Formula to have text equal number
- copy info from other file
- Format a date in my macro?
- Data entry mask or data checking on a Userform Textbox (agai
- Charts - Displaying Two Charts
- Make my data horizontal instead of vertical...
- Count Number of Instances in Monthly Basis
- Naming Multiple selections
- drop down boxes and macros
- Query regarding primary key validation
- refer to a cell in VBA
- sorting months in a macro
- Eliminating duplicate records
- Total figures based on specific descriptors
- Date conversion problem when sorting on
- Links to other worksheets
- custom formatting
- Object not Supported
- Alternatives to Hyperlinks within WorkBook?
- reverse a number
- reverse a number
- VBA: F2 {edit} Home, Right 8, etc.......
- Help required for a macro pause
- Checking the data in a cell
- fill handle question/bug?
- Charts on website excel files: error 1004
- If Statement
- Pivot tables - showing text fields sensibly
- Array formula and User Defined Function (UDF)
- Match or lookup
- Pass criteria from worksheet to a PivotTable query
- Stock Options calculations - How to calculate Delta after a
- If then else
- lookup
- Worksheet _change event. Global way of calling?
- Insert sheet name
- Formula to know if a cell is bold formated
- FORMULA FOR DIFF BETWEEN DATES
- if stmnt with date
- Paste Text as Hyperlink
- follw up question for lookup
- TRYING TO CONVERT ENTER KEY TO TAB KEY
- Changing variables
- Deleting multiple rows
- .CSV
- Hiding / Unhiding Columns
- vlookup
- Pivot table with multiple ranges
- vlookup
- Excel memory
- Formulas for geting the NET INCOME
- Opposite of transpose.. or lots of copying!
- Help with an "IF" command
- Conditional format? Re: text/numerical alignment
- Page Setup Not Working!
- Use Excel to automatically update Powerpoint Charts
- Sumif
- VB...help!!
- naming properties
- Time query in Access
- question on combo boxes
- Creating a Log of Hyperlink Activity
- How to Loop?
- thanksgiving
- Random numbers / VBA
- Pivottabel -> kolomtable
- Database connectivity
- Comparing Worksheets and removing duplicated
- automatic deletion of unused rows
- Cursor key action
- finding duplicates
- random # generation
- Is there an easy way to find difference in two worksheets?
- Worksheet naming
- IF statement problem involving counting
- File Stopped Counting via AutoFilter????
- Day of Week
- Extract from 7 long string text or numeric!!
- moving a chart with a macro
- How to figure out the number of Mondays in a month
- Lottery on Excel
- problem with code
- I'm sure this is easy for you guys
- Merging Purging Please help!!!
- I need a formula to Chang time into fractions
- coverting date formats, please help
- Conditional format a cell based on a different cell
- Running a dos batch job from excel
- Error message after incorrect P/W in Macro
- Time
- pivot table date grouping issue
- Transparent Fill on Graphs
- Copy Formulas in all cells
- Macro needed to change column of "firstn lastn" to "lastn, f
- Reference using a variable
- excel.xlb file copied from work to home computer
- VBA name in a workbook
- Random Groups
- Prevent updating one cell if other cell is left blank
- Disalbe Macro message and search for links to other workbook
- conditional formatting
- Meaning of Code
- Formular :Counting of remaing months to maturities
- Pivot Charts
- VLookup question
- Help Cursor in VBA Highlights Characters
- When is Application.Stdev not Application.Stdev ???
- Overcoming Alerts using VB
- End Code
- Music Macro
- Vertical Text in a Userform ?
- Minimize, Maximize and close buttons on a userform.
- Browse for a new dircetory......
- Macro editing
- Macro won't run from a command button
- Copying without losing formatting
- macros
- Format of a combobox on a userform
- Copying wooksheet
- Incrementing numbers
- INCOMPATIBILITY in MACROS? XP vs Excel 97/2000
- Custome Menus
- Macro editing
- vlookup
- Why is my s/s so bloody big?
- horrid runtime error 1004
- closing all open workbppks on exit
- Am I using the correct function?
- Checking users viewing your VBA Code
- Macros
- Convert text date to normal date
- getting a zero value to show up
- web query problem
- DIGIT QUESTION
- Sorting problem created by if statement
- Paste rows over columns
- VBA if formula
- How to set up an Excel Template
- Subscript out of Range
- Counting formulas
- Find Max in a column, and change the number to bold text
- Subtracting scores
- VLookup code error
- Using Window's ALT-TAB to switch between workbooks does not
- Combo box / Macro
- Control seperate workbook VBA
- Open a PDF from Excel
- Excel Formula Glitch
- Send one worksheet without corrupting custom colors
- column charts
- Difference between xlVisible and xlCellTypeVisible
- Lookup?
- Unique invoice numbering
- Custom Menu
- probaly a simple question :)
- Reports from rows
- SORT
- i think i need an =IF.....
- what am I doing wrong
- PASTE FUNCTION
- sort numbers
- Operate a command button programmatically
- Buttons?
- Conditional Formatting and Sorting
- Converting words into single cells
- Error 1004 when trying to "Save As"
- blinking text
- Pharmaceutica Rx
- Validation Box Font Size
- Summing first 30 cells in column, then the next 30, then the
- create random numbers
- Freeze and split in sync
- formula
- Date Format
- Date Format
- Find & Select a cell at and row and column intersect...
- needed macro
- Add customer menu
- Cancel AutoSave VBA
- Really, really strange thing I noticed......
- How to auto lock a cell range after a new value is entered
- Remove the Zeros
- Keeping the user out of my area
- Custom Menus (part 2)
- is there a web board like mr. excel
- Button to other worksheet.
- SUMPRODUCT vs Array Formulas
- Multiple Consolidation Ranges
- Button to hide and unhide cells
- Option_Button's text
- Workbook Access
- Working on a file at the same time
- time
- Print Macro
- Creating "In progress" message box
- VLookup VBA Code
- Random numbers that cannot be repeated
- Button to Open another Workbook
- overriding clipboard in a macro
- INDIRECT function problem
- Passwords: Anyone experienced this before?
- arranging 4 bytes into Long data type
- Refrencing the Show All Data thingy, whatsy, bit...
- List Conditional Formats
- How to center over a text
- Menu Customization
- Calculating the number of observations that fit a range
- Why use LONG data type when SINGLE will do the same? (SOLVED
- Vlookup
- Error Message
- Replace
- Deleting a textbox value using VBA
- Using Find within an IF statement
- Controlling what is displayed in a macro generated pivot tab
- Finding duplicate records?
- Using a cell to define a sheet name
- File Reservation
- Help with Application.WorksheetFunction or something
- Auto highlighting
- IRR (Boffin required)
- Frozen panes and comment fields
- Something amiss with Ifs and Withs
- Possibly simple solution
- Charts within Macros
- The big picture
- Change Sort Order.....
- Data Table on chart
- Change Sort Order.....
- FORMATS AND COLORS
- Auto Filter
- Email Macro - CC?
- Formatting numbers in French
- #VALUE
- macro edit
- Copying Array Formulas to multiple cells
- web query
- Macro code
- If Statement? If cell is > 'XX' add this amount; if not,
- Count merged cells
- Goal Seek within a userform
- Summarising Worksheets
- hidden column
- Textbox in User Form
- Locked out of Excel
- removing the ' from a text list
- If and Countif together?
- Save As macro
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.