View Full Version : Excel Questions
- protection
- Lookup Formula (VLOOKUP, INDEX, MATCH) Issues
- Deleting Rows
- Simple formula needed thanks
- Hide Worksheet by referencing a cell
- Autosum ... multiplying & dividing
- Colour in worksheets
- Parenthesis enclosing output of formula
- Really complicated IF statement
- Problem with Macro:counts same data cells & puts in dif
- time formula stamp and freeze
- Inserting column changes formulas
- VBA find and then sum values btw 2 headings
- Mail Merge problem with Excel - ghost process
- Formula works for numbers, but not text....
- please help: create summary sheet from different files
- Formula missing in one cell
- How to batch update external links in excel files
- combining two columns into one.....need a smart VBA code
- Linking Excel with Oulook
- mround problem
- Automatic generated date line
- macro to copy sheet and rename it
- Join Cells smallest first
- Copy values based on contents of two cells
- Vlookup - embedding an aurguement in the table array
- .Find Question (dot find)
- Validation Question
- Assign Macro to a shape but do not show hand on hover
- vba excel if...then...next
- Ignoring cells with a value of 0 when referencing a column
- Changing from Workbook to Worksheet in an Existing Macro
- Comparing values in a range of cells.
- Excel Spreadsheet In-Cell Dropdown Problems
- between (IF) formula
- How do I mulitply a time (in excess of 24 hrs) by a decimal?
- macro to copy and paste specific columns
- Conditional formatting for series of cells/row
- Data Validation defaults
- Area graph - negative values
- Cumlative charting pivot table...
- Drop Down Boxes
- Stupid data labels
- need a right click menu on the userform---> VBA
- Crude loops and sloopy range references, help me sort mylife
- Add unique entries only to combobox
- force cell reference in a formula to remain the constant
- conditional format 4 conditions? or twk 3
- change attributes of 'half' of a concatenated cell?
- Conditional formatting - Need help please!
- Lotus to Excel Conversion Problem
- Help needed to copy a range please!
- Ensuring a cell contains a specific character
- option buttons within a frame
- locking cells
- Locked/Unlocked
- Embedded cell comments: automatic header/title
- SUM Macro- Anybody did it before?
- Saving one instance of a linked spreadsheet
- Price list
- Date Formatting Issue?
- Full path in Excel footer
- Add-Ins
- Non printing X axis values
- Analysing Data in Excel
- Formula too long
- little but tricky
- Convert 2 lines text to 1
- COM based excell viewer without installing Excell (or Office
- Searching for an exact case
- CenterFooter with full path in PERL with OLE
- Nested IF statements with a range
- simple macro to list sheets
- Format a cell
- Out of Memory error setting Cell to a lengthy Formula
- Text validation in IF function
- Please help me with counters!
- Argh!! VBA Errors help?
- Excel Formula Possibly VBA Question
- Sheet tab views
- A message in a case of an error?
- Conditional Formatting
- Solver Formula?????
- Find a replace multiple columns.
- Re-order wkshts in wkbk to match sorted order of names?
- getting path of a FindFile
- Sort Error
- finding last used cell in a particular row
- Issue with XL97 on Win 95
- Keep combobox open?
- time sheet question
- Excel functionality I've never seen before... what is it?
- Creating Working Buttons on a Spreadsheet full of formulas
- =IF(AND(C4="b",I4<>"",),"both
- drop down box/window!!!!!!!!!!!!!!!!
- List Box Navigation Question
- hopefully simple formula addition
- invoice userform
- Pipe Delimited
- Need help on formula
- "If-Else search" question
- copying between workbooks with macro
- Conversion rates to primary unit
- Better way to do Vlookup?
- Add to subject line when sending
- Grouping Rows/Columns
- How can I consolidate this code?
- Calculations based upon different input
- need to use a variable in another userform?
- CHange phone number format
- Help using a combobox to replace values in a given row
- Image embedding
- User-defined currency symbol ?
- Hiding sheet tab names
- Auto enabling of macros
- Enabling the Form options in Excel.
- Textbox without using a command button?
- Using range in macros, but with formula not A1 notation
- mark duplicates
- Use Query, then Hyperlink
- Match/Index Formula to Date
- Integer Programming Problem
- Formula problem - It just won't work
- count number of text words in a row
- Macro Information from Excel to Word
- return a zero
- Need help in identifying top % for multiple columns
- Combine the VLookup and countA formulas in Microsoft Excel?
- Never been tried?
- Deleting a Range after Copying it
- Tough question - is it even possible?
- Set Cell Based on another cell value
- Is there really a bug with the Excel date function?
- How can I reformat rows
- Split date into separate cells
- retreve data from a cell in a differenent spread sheet file
- vlookup between 2 different files??
- Formula to calculate Vacation Accural
- IsEmpty(ActiveCell) doesnt work??
- Want add up a list of numbers which includes some #N/A value
- Something along the lines of Subtotal hiding?
- Need for Speed: Advice from any and all
- Track and Confirm using Excel can it be done?
- Create macro to change letter "D" to "C"
- Time formulas and formatting formulas
- excel worksheet and userform question
- Projected vs Actual
- lost all "names",all formatting,and one sheet with
- Combine Counta and Countif Functions in Nested Formula?
- Sorting problem, doubling up
- Sorting problem, doubling up
- count column with two criteria and one date field
- Can I show text in a pivot table rather than aggregates?
- First occurance of data
- SUM & VLOOKUP to calculate specific fields?
- How to turn certain work sheets to manual calculation?
- How do I compare dates?
- attaching an image to a row
- The array range- what is wrong here????
- VB Query
- Formula storing
- change the image in the treeview, when ever required
- Set Print Area button
- Drop down menus
- Export worksheet to access db
- Min Function Help
- comment arrow and triangle
- A Little help fine tuning some code
- Listting and testing of PC specific IDs in VBA
- How to autosum current and last week's data?
- logging data
- Importing 200 .txt files
- Using value in cell as a sheetname in formula
- DATE: count dates down a column to project training due eac
- Counting Text Help please
- Chart Data with a Scroll Bar
- Help to Create a summary page
- global format changes
- Macro to Obtain Data
- Converting text entries to upper case on change.
- Data Validation Question
- DialogSheets
- formulas in Microsoft Excel?
- Sorting Worksheets
- Lookup in Range, Countif, and sum on the columns and dynamic
- Sorting Names
- Row Reference dependant on another Range value
- can you help
- if then statement to calculate due time
- #N/A
- IF Statements! ERGENT
- dropdown list, lookup tables, help please.
- Referring to Cell's self
- How to combine a list of models on each WS into one sheet?
- question about userform
- searching a spreadsheet
- copy data into a spreedsheet
- Create ShowDesktop.scf
- Wait for button press
- Sunday Work Roster
- Blanks not adding up
- object variable error, variable not set ??????
- Excel start-up errors !
- Help: web and excel
- Worksheet Change Event
- Worksheet Protection - Disables Check Box Capability
- Question on Excel Windows in Task Bar
- A basic count using dates
- Question of efficiency.
- HELP on Combination Question PLEASE
- Count
- Sorting Simple Worksheet
- Yes No Button within Another Macro
- Need help with Vlookup tax table
- VBA Code to copy to copy a cell every 72 cells
- Temporary Lookup using a pivot table
- Activate macro when workbook opens to specific sheet
- SQL and Combo Boxes
- Relocate the fields
- Global color chagne can't be reset.
- text colour change
- rookie column macro
- Changing button text
- What other than Countif, Sumif or Sumproduct??
- Formula Needed ?
- Deleting a macro with another macro
- Don’t need it, actually just wondering is it possible???
- delete history
- Deleting some part of the code
- Vlookup problem! ERGENT PLEASE HELP!
- Call add-in function from Excel sheet on different pcs
- Finding the first day of a month in a timeserie.
- What does this mean?
- Open New File and Save in same directory.
- Data Validation - No in cell dropdowns ! HELP
- Ingoring Blank Fields
- Lookup a range of values?
- Paste range to ActiveCell?
- UK Date into a userform, not a US ?
- Trouble with IF
- Formula Problem
- Copying non duplicate data to another column
- Is there a way I can do this???
- buttons in excel
- Returning the Cell Address as the Result of a Lookup
- Character limit in a cell?
- If within if in VBA
- Using the Autofilter
- Unattended Auto-Save Macro not running
- FormulaBar integrated in custom menu
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.