View Full Version : Excel Questions
- Shortcut for copying and pasting formula?
- Conditional Formatting based on Month
- Delete Rows that have a specific condition
- Need to delete last 4 digits in 10 digit string
- Conditional formatting
- Sub Workbook_Open() Issue
- Error upon running a recorded macro
- Conditional formatting with capital/small letters
- link cell to another worksheet
- Referencing Pivot data from one excel sheet to another through macro
- Round to end in 9 or 5
- Printing
- Import macro
- Worksheet_Change Question
- add powerpoint link with icon
- Calling all vba experts!
- help with formula
- macro help
- Evaluate 2 Columns and Report a List when criteria are met
- How can I use a range to define email recipients?
- Userform Spreadsheet Cell Format?
- Easy one
- Sorting dates into seasons and counting their occurences by year - Macro
- VBA Help
- eligibility date formula
- Combining row values in pivot table..
- Accessing IE's address bar
- Autocopy cell if new row information present
- Turn off auto calc for one tab
- #Div/0
- Format Number no longer working
- Non-stop Iteration Process
- VLookUp Not Displaying Result but formula
- Copy duplicate info in Excel on to another sheet
- Need code
- Conditional format
- String Replace to Int?
- Looking for Ideas to sort individual ranges
- AfterInsert in Excel?
- Problem with Cancel and InputBox
- only copy over todays information
- Delete If Condition Met
- Use VBA to insert special character as result of If statement
- Condition Met To Populate Cell
- Avoiding new row formation
- Find blank cell, insert formula to find median of above cell range, via macro
- Readability statistics in excel
- Changing Font on Email Signature
- Calculating Networkdays between four (4) dates.
- Excel Startup Issue
- Turning Cell values into percentages and keeping original value in same cell
- Please help
- Line & Column Graph Issue
- Determining range from formula contents in VBA.
- Need something like SUMIF but using MAX
- Spreadsheet problem with imported data, times and calculations
- Data elimination- resolution
- Formula needed please
- Workday function for 6 day workweek and negative/subtract workdays
- Don't want all data labelled on a chart
- Data base- arrange by brand
- Macro not running
- Formula Problems
- Smart Detection of missing data
- Stripping information form table
- Y-Axis, auto float?
- Question on comparing...Search came up with nothing
- Enable CommandButton
- Fill Handle does not work
- big font in small cell
- Showing the last day with a sale with a macro
- Change column in a range in vba
- I need some macro help.
- Disable Automatic Calcualtion does not work
- Lookup data from validation drop down and return multiple corresponding values
- Duplicate rows (three columns)
- Mystery calc error
- How to move a spreadsheet that will syn the formulas into a new file
- Remove everything after specified character.
- Format to force extra spaces between characters
- Extracting Embedded Excel in Word Document
- Formula
- Formatting Daets in headers
- Many (greater than) counts summed with just 1 formula?
- Ignore Userform VBA
- Writing to Quickbooks from Excel using QODBC
- Vlookup error
- Two different answers using rounding formulas
- Please help with Macro
- Multiple Crieria Summing with SUMPRODUCT
- display last date
- Slightly confused vlookup or match
- Sumproduct or index problem?
- Paste value only
- Comment height to neatly fit text??
- Banking, account categories, creating breakdown $ spent on each category
- Find and count duplicates
- value from combobox to excel function
- Persistant Public Data
- Count range of cell changes
- Can IF statements trigger values?
- export to new spreasheet
- External links - Price tracker
- Need help converting long time calculation to UDF
- Add new line using commandbutton
- Combo box value
- Comparing multiple types of data
- Creating Excel as a standalone application
- Sumproduct
- CheckBox Value
- Clean up My nested IF statement
- Operation of difference between rows
- Deleting content after a character
- Create a Excel file and Save based on cell value
- save an excel workbook as a standalone application
- How to move different data from a single excel column to other columns in proper order
- Multiple Substitute issue
- DBGrid connection through ADO (SQL)
- min is not £0.00
- Need Chart to be not clickable/selectable.
- Macro to transfer data from one sheet to another
- Macro to transfer data from one sheet to another
- Macro to copy data from one sheet to another
- Automatically find possible combinations
- Macro to copy data from one sheet to another
- Building Notify Msg
- I need some help in putting a list of letter in Alphabetical order in a single cell
- vlookup N/A
- excel to access
- How do I create a separate function to sum all the A1's? Below is an extract of my sub routine...
- Strange Problem with Recording Macro
- AutoFilter using Dynamic dates
- MSgBox dependent on drop down
- Copy TextBox as Picture - Failure
- Run time error '9', Subscript out of range!! Help Please!!!!!
- link two cells
- save an Excel Workbook as a Standalone Application
- Macro for Changing text colour !
- Filtering in Date Format
- All Duplicates in column
- covariance from spreadsheet
- Macro for validation.
- Suggestion Needed | Client report
- Adding Specific Numbers
- Array Multiple Date Columns
- Manipulating Web Query Results in VBA
- conditional formating vba problem
- Extract Data
- Vlookup two workbooks
- Save excel file name
- Highlight highest percentages
- Vlookup using VBA Constants
- Adjustment needed on import macro
- Error when Refresh All data connections used
- Modify default size of insert comment
- Help To Modify This Code To Include Column
- Cell Comparison
- problem with "vlookup" function
- VBA Userform coding...
- SUM data with 2 conditions?
- vlookup?
- UK Income Tax calculation problem
- Formula Question: Combining MAX w/ Other Functions
- Hide cell contents
- add new workbook and worksheet
- For Each loop syntax ??
- String work in VBA
- Condense rows add data to new columns?
- Date formula to Insert label and skip column
- Simple If statement using time (in seconds)
- Sorting Question
- Reference to Cell for External filter
- Project cells in one sheet to another as a picture
- Vlookup Help Needed
- Looping through a series of variables
- Remove Values from Combobox during runtime?
- Digitize a listbox
- Populate ComboBox (RowSource)
- vlookup formula
- check and delete
- Calling an Access macro or saved import from Excel
- Need to Automatically Number Rows
- Bucketing/sorting data
- VBA code for sum formula across multiple sheets
- Change Chart Height
- FileLen function returns negative value
- Allocating Data Evenly Throught the Column
- Currency doesn't change with Windows regional setting
- search and deliver cells to the left
- Vlookup Vba Code Help
- Selecting the cell in filter
- copy and paste help
- Help Regarding HasFormula
- Excel guru's Please help..
- Formula Assistance
- Figure location of cell after FIND...
- How to create formula to copy cell ?
- excel italics problem
- =LOOKUP function returning N/A?
- Need help with formula =IF(ROW()-1>MAX('All Fruit'!E:E),"",N(A6)+1)
- Stripping down a formula
- Give a sheet name from a Cell
- Count formula
- Help regarding Shortcut key or macro
- Copy text in another cell
- Intsert row
- Disable and Enable Comments.
- Extract numbers from text in cell e.g 1st 2nd 12t 9th
- Making first letter in a cell a Capital
- Removing blank spaces
- VBA - Send Attachments Via Email
- New sheet Help
- Delete Row and Column
- Putting Appropriate Data in Cells
- Creating a Zip file with VBA
- macros
- no block if / no For loop
- need help with calculating formula from multiple cells
- Is there a keystroke for...?
- Destinations cells
- Destination cells
- how to take a snap shoot of a excel tool bar
- Function to retrieve data from Access into Excel
- Why VBA is able to launch Internet Explorer faster?
- Unable to use cut/copy/paste function
- Vba
- Summarising variable Data
- Extract word/phrase(keyword) AND HitCount
- Paste Values no formatting
- Entire Row Line Border
- Help required in modifying a function
- VBA trying to use FIND
- Help appreciated (date ranges)
- Row and Column Intercect value
- pass word protection
- DATEVALUE Error for normal date format
- Conditional formatting - Simple?
- 'Now' cell
- Average puzzle
- Table Manipulation
- Display 24 hour clock
- Show TRUE in a cell if sheet is hidden
- Header in Excel Charts
- What's better than sum(if()) array formulas??
- Finding duplicate names
- VBA Coding.."Save" Command and Start up fix...
- Question about passing arguments back to the main sub
- Accessing Windows Search
- "dependant" dropdown boxes?
- Eleminate, Extract or Copy Cells
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.