View Full Version : Excel Questions
- Copy and Paste Cell Value Only - Not Formula - from one sheet to another sheet
- Group rows in a protected worksheet
- Concatenate a with conditional formatting
- Sum in Pivot table returns not precise number
- Average Time Difference Formula
- Merge Data
- Sumproduct problem
- VBA copy and edit w/o naming specific cells?
- Change event question?
- Loop until the end of spreadsheet
- Populating textbox based on dynamic range & combobox
- Excel 2007 Chart Question
- 35 hour week showing as 840 - why?
- Checking if a workbook is open
- General Help
- Changing date format in entire column
- Sort and Match VBA help
- Change functions default values
- Query on selecting value in a Validation List & it automatically updates other cells with data from a table
- Reference Column
- Lookup Values based on Min, Max of a defined list
- Different repeated rows in different pages
- trivial question
- Change Autofilter located on Tab2 from Tab1
- Attachments
- Referring to current Command Button
- Real average rate of return on IRA investement
- Formatting WordArt in Excel 2007
- How to perform average with sumproduct in a formula?
- Code for SORT is not working
- How to auto sort based of off one column and take the data adjacent with it
- Help using Excel VBA to control Explorer
- Macros for inserting cells and deleting cells
- Query a pivot table?
- VBA trying to VLOOKUP in multiple cells in range
- Macro mystery
- Data Validation to Limit Total for Range
- Searching Multiple Sheets
- "Show only greater than" on Pivot Table
- put extra value in data label of the chart
- Question on how to get around concatenate
- Count cells only with data
- Make Directory and then name the path using the new dir
- Real quick: How do I reference a cell containg text with a space?
- Event triggered when a shape is moved
- How to resize sections in footer
- Big macro needed
- Excel cannot complete this task...
- Adjacent cells content
- How to use data in one spreadsheet in a seperate spreadsheet
- Can a macro create a pivot
- Old file and formula structure as default
- Modifying the pathway in Excel
- Easy question
- Search Question
- Hyperlink to a secure website; VBA Object which holds the password and username
- Formula IF(OR
- Dim Array as Sheets
- Need to Recognize Month in Dif Formats
- When Copying a Workbook how do I keep a handle on the new sheet?
- Help with this formula?
- conditional formatting on multiple worksheets?
- delete a cell if it doesn't start with a letter
- Checkbox
- Copy sheet multiple times, rename to months of year
- Find Function: Text Sting Next instance
- populate team roster with raw data
- merging duplicate cells
- Need to Embed a Sound File & Create a Macro to Play it..
- Substitute and Vlookup formula
- Rounding Hours on Employee Time Sheet
- Array formula?
- Text formating in a cell
- VB Case Copy and Paste
- Copy one worksheet to a different workbook without Named ranges
- Conditional Formating an entire row
- how to change color of red comment indicator?
- Finding the length of time in hours between two times/dates
- Conditional Sum Macro for Stocks
- Axis Labeling Problem
- max statement question
- sumproduct with search function
- OFFSET and VLOOKUP function
- Reworking a code
- It's the easy stuff that gets me
- Determining true averages
- Auto-Fill versus On Double-Clk Evt Macro
- Input box assistance
- hiding a row based on a value
- Format Cells - Custom
- Multiple Criteria Multiple Workbooks
- searching a DB from a form
- SUMIF Issues with Zero, Negative, and Positive values
- Formula passed by Macro
- Formula Question
- Macro To Import Data
- Message Box command
- Sum based on condition
- data validation from column of information
- Bypassing #N/A's and using SUM's
- BeforePrint for Worksheet not Workbook
- Formula Questions-Help Please!
- a sum based on two columns
- Creating a pivot table from multiple worksheets in one workbook
- Can you copy cells with their formatting when concatenating?
- Grouping Pivot Table using VBA
- macro to delete rows with data only
- Deleting rows by criteria from a table
- Super Tricky = mid ( maybe )
- Conditional formating doesn't work
- Lookup/If Statements to Find Sums
- Selecting Cells for email macro
- VBA pivot table Excel 2007 help
- SQL Syntax - VBA
- VBA to lock cell and insert formula
- IF all possible Values are True THEN
- Merging worksheets in Excel
- Exporting to a new worksheet in a directory / google search
- Drop Down Menu
- Counting Data
- Copy data from Sheet1 to Sheet2 based on last row
- Sumif formula in excel '07
- Conditional formatting when 3 conditions are true
- Count words in a column
- Report from Wookbook with multiple Tabs
- How to show progress while macro is running?
- Excel formula
- Thanks and help!!
- Autofill Question
- Text copy formula assistance
- Only adding last characters from a Data Validation list
- Concatenating Month from one cell with link
- Returning date value from an integer RELOADED
- formula to show a dash if value in cell is 0
- Sumproduct only visible cells
- Copy/paste quicky
- How do I sum this?
- Iserror
- Lookup same value
- Formula for changing format of adjacent cells depending on result of another cell
- How To - info from 1 cell to another cell in different worksheets
- How to express simple formula correctly
- Conditional Formatting including adjacent cells
- Joanne1789
- Sum based upon monthly data across multiple years
- Weeknum + left = wrong result???? Help
- Index/Match function in array? I'm stuck!
- Build a hyperlink using VBA to a variable location
- Excel shuts down
- date functions using entered year only
- Can I create multiple pivot tables in the same workbook?
- Bruce Lister
- Looping on IE instances freezing up
- zip codes
- conditional formating not working
- How to display decimal as time
- Reducing figure by a weighted amount.
- Editing a range that pivot chart is referencing
- formula
- Formula/Function: Group of Cell Values = Name
- Can't fully copy links with dashes in them
- Help with filter criteria
- Make formula into a Function
- EXCEL SOLVER CHALLENGE (RE: Production Planning)
- Using SUMPRODUCT function - downside
- Lookup failed any other ideas?
- Formual Vlookup - customizing false reustl
- Formual Vlookup - customizing false reustl
- Formula Vlookup - Customizing false result
- how to preserve a variable when PC turned off
- What is the best way...
- Help with if, and, or function
- how to go to a particular tab in a excel sheet directly
- working with dates
- Which is better for this job: Access 2007 or Excel 2007
- Get Data As Per Req. Count
- VBA Challenge - my programming skills are rusty!
- usedrange count
- Macro Recording Pivot Tables - no can do!
- Script to copy formula to last row of data
- CountIfs For criteria in range
- Dynamic Range going nuts!
- HELP NEEDED in EXCEL!!
- Help getting totals based on criteria
- Need code to refresh the Pivot automatically
- Cell Value
- Simple $ Cell lock question
- MsgBox with Cell value in the message
- Countif and Highlight
- Determine the area a user selection
- Cascading comboboxes selection problem
- Comparing lists of names, totally baffled!
- Data Validation with RC notation
- Calender Problem
- Support with WTD, MTD & QTD figures.
- EXCEL (Office 2008) running slowly, freezing?
- Conditional formatting multiple cells based on one cell
- vba send worksheet .. but if not there... stop sending the whole workbook .. eeek
- countif problem
- Input Error
- Week Number for a Saturday to Friday Working Week
- excel 2007 =picture does not print??
- Save PDF and mail macro? (Excel 2003)
- Help with Index Function
- Error in IF formula
- picture is too large
- Conditional Formatting formula problem
- Excel calender
- Formula solution
- Help needed! Macro to change chart source data.
- VLookup (again)
- A VBA Conditional Formatting Question
- VBA Hide Rows on (before) close
- Changing chart series colours in VBA
- Looping through worksheets
- Highlight Cell to be used.
- converting to html with links but removing windows formating
- Copy sheet - issue with named ranges
- Code to lock/unlock, clear and color for certain cells
- VBA - Adding Hyper link to cell doesn't work
- Date format is worng
- List Validation
- Use VBA to chnage the color of font in a cell
- Help Needed
- V.Lookup function with variable parameter?
- Form Control Increment Change
- VBA to allow user to select where to add line with formulas
- Can you mix If(And with VLOOKUP?
- F1 Spreadsheet
- What functions to use?
- Data from mutiple files to one master file.
- Complicated date extraction?
- Change Format of entire colunm
- Custom format for comments and hyperlinks
- How to Include Saturday in Formula Workdays
- Excel Help
- Select unique and max date
- How to determine if a chart is embedded or not
- Using Forms and AutoCorrect (data entry issue)
- VBA scripting in CMS
- Copy/Paste Macro from one file to another file, multiple tabs
- Urgent: Percentage calculation in pivot table
- How to Calculate if a Range of Times Falls Between two Date/Time Stamps
- Get only filename
- changing numbers to dollar amounts
- show value
- Is it possible to hide a sheet and have a macro copy it to a new workbook unhidden?
- Count Numbers
- Double Vlookup?
- Conditional Formatting - if a value is changed to a lower number!
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.