View Full Version : Excel Questions
- VLOOKUP over 2 files
- Unselectable Cells
- vlookup/lookup
- Copy VBA code to new workbook.
- Find Second, Third, Fourth etc match
- Overwriting another file
- Rolling averages across spreadsheets
- hh:mm to minutes
- Copy cell formatting thru formula
- macros
- Dialog Boxes
- Sort table to single column?
- Selecting the next/previous sheet in a book
- Project Locked
- Subtracting Times
- turning off the calculation in only one worksheet
- Merging Cells
- CommandBars - Check to see if they exist already ?
- ISNUMBER - ?
- advanced formatting
- Link Picture
- Place a Thin Line at PageBreak When Printing
- Dating a file name when saving please!
- Filtering only the first two digits and finding the frequenc
- Macro Button to print
- Previous Values and Server Date
- Merging Cells
- How can I create an invoice number for each invoice
- "CountIf" formula or something similar
- vlookup
- can data in a cell be changed
- want to project staffing based on existing data
- "For / Next" to modify date/time string until empty cell
- Passwords
- Can Palm run excel programs if VB modules are used?
- question on average values?
- Numeric Entry Not Recognized as a Number
- cell reference
- 3 textboxs
- duplicate workbooks
- Pivot Tables from 2000 to 97
- I need help on scatter graphs
- check for updates
- Summing by reference
- validate date
- naming modules
- COPYING
- average with a #div/0 in the range
- Figuring out if the USER has done a sort in VBA
- Macros: Lotus 1-2-3 to Excel VB
- Getting a Col Value for Offset from worksheet in VB
- Blank cells
- OR function inside VLOOKUP
- Suppress ReadOnly Warning
- Please.... Help Quick!
- User-Defined Add-In question
- Way to Force Auto-Recalc When Printing File?
- Excel, Zeros and Sig Figs
- autocomplete
- getting a value, out of seven cells
- Alternating Row Shading
- Alternating Row Shading
- 2 Qs about Breaking Links, ideall y in a Macro.
- Time
- change default comment font & get rid of default text entry?
- sort ascending...
- Auto hide of columns that are empty
- Subtracting time
- bypass a question
- identifying the active cell using a formula
- Must select value in Combo Box. no type over
- LookUp Functions -
- Opening Lotus Notes from Excel
- Anniversaries On Hold
- adding data to a chart
- Shading Rows
- Add data to a calender
- Help Please..... MessageBox Macro problem
- Using A Macro in more than one workbook
- Set Focus
- Changing the layout / Printing with header
- what exactly does the usedrange do?!@?
- Grabbing top values from column of UNSORTED percentages?
- excel template
- Sorting a spreadsheet without activating it
- Searching string in sub-directories
- e-mail from Excel
- Automatically open a sheet
- defined names list
- Automating Largest Column Width
- Automatic calculation
- macro to compute averages (rounds numbers when it shouldn't)
- Conditional formatting
- Conditional formatting
- Printing a form from Excel
- Format Zip Code in a text box
- filter for reports
- Primary Keys
- Last revised/edited file property - how to add to footer??
- filtering problem
- combo box in vb?
- Calculating time differences in minutes
- Repost: Combo boxes & dynamic ranges
- how to programmatically Import Text File without using Wizar
- Combination Bar/Stack Chart
- problems with list box and a formula from another cell
- Easy to Loop De Loop?
- Separate by comma
- Weird Problem
- Excel Lookup
- concatenate wierdness
- need help with sumif/ countif formula
- Delete Source File Link
- Deleting Pages
- Check boxes
- complex scatter graph
- Columns Keep Collapsing when I run maro
- carrage return
- Help with VBA concerning Find Method
- Forcing users to check at least 1 of 8 Check Boxes
- SORTING - more thatn 3 columns, can this code be improved?
- Deleting Spaces (=left?)
- Saving?
- Spreadsheet problem
- Scrolling to bottom of text box on userform
- Mail Error
- Extract data from an object within a group?
- counting text
- Replacing Null Characters (ASCII Value "0")
- VBA Code to take me back to the CELL I started on
- Non-zero min() with sumproduct instead of arrays... anyone?
- spreadsheet problem from earlier
- cut and paste shortcut
- Clearing FALSE from many cells
- convert 10/28/2003 to 20031028
- AOLGroups
- Using Hlookup
- How to link a cell to a combo box value?
- displays formula instead of results when cell is edited
- Error message when trying to copy a worksheet
- Getting a summary from order form
- using sheet name in formula?
- WeekNum Function?
- Worksheet Protection - Help!
- Conditional formula
- If statements with text from a textbox
- Splash screens
- userform help
- Text Color in a textbox when value is negative
- selecting the last cell that data was written to
- need help with mousemove event
- crash of excel
- whole number query
- counting entries of currency with 2 conditions
- Protect Method fails for Shared Workbook
- Is there an "ISDATE" type function in Excel
- roundup and if statement
- Include date in save name
- Creating an array from listboxes
- array formula minus text cells
- Mr EXCEL - this can be the monthly challenge
- need help with updating links
- Worksheet protection and access code
- Can autofilter show all cells in a group of merged cells?
- Using offset CMD in Chart to reduce wastage
- Locked VBA Project
- HELP!!!! ( running macro on zipped files )
- Rescue Workbook from "Too many different cells format" error
- First Day Of Week
- combobox with autocomplete feature
- Names contains forbidden character
- Sales Product Tracking
- (Variable ?)Criteria Range For Advanced Filtering?
- Macro help (inc. deleting it!)
- Can someone correct my code???
- Paste special
- Help if anyone can
- Automatically moving rows
- Please Help
- disable popup
- multiplying a time hh mm by a rate $
- Select from a list
- Arrays and stuff
- Listing Folders in XL 97
- Saving a file without saving the macro
- Testing to see if a file exists
- Help with a variable
- Perplexed code .value=.value
- Calculating Wholesale to Retail Prices
- Auto message confirmation while the macro is running
- pictures and charts
- Comparing Dates
- Macro - Updating Automatically?
- SheetReference from a cell in another sheet
- Show formulas
- shared folder
- Open workbook with a macro.
- INDEX function
- Email a single worksheet from a workbook
- TAX HELP
- if then statement? conditions for a newbie!
- Copy and paste from web to Excel
- Chart and savings calcuations?
- Highlighting Value If In List
- Concatenating with IF
- SAMPLE PRO-FORMA FINANCIAL STATEMENTS
- multiple stacked columns in Excel Chart
- Formula will not allow me to change it
- Files selection Tree??
- Setting limits on Excel
- Need code to copy sheet into new, clean file
- formula for pictures
- Ignoring zero points on graphs
- Ignoring zero points on graphs
- Fcurrent
- Ignoring zero points on graphs
- auto filter
- Formula problem
- Formula problem
- Copying code in VBA
- Automating Printing
- Formula problem Part II
- Formula problem Part III
- Counting Data
- Lookup? Index? Pivot Table? Which one? Help!
- Making Workshet tabs larger/colorful
- Formula problem Part IV
- Excel help
- Formula problem Part V
- If X is =0, do this, otherwise do this
- Inserting a row
- Formula problem Part VI
- How to? Lookup, Index, Pivot Table? Help!
- Formula problem Part VII
- repeating characters
- Average numbers greater than 0
- does anyone know why my posts are being truncated?
- More Help Reqd - Changing Macro Automatically
- Excel to Access
- Hide / Unhide with password protection
- Excel to Access
- How can I prevent a MsgBox from coming up twice when a Check
- Highlighting Value If In List
- match and index with sheet names?
- Pop Up Message......
- CONDITIONAL FORMATTING
- ALT codes for '97
- Help with a formula?
- is err
- is err
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.