View Full Version : Excel Questions
- Help Custom Color ScatterPlot Points with VBA
- ShortcutKey not working
- Input Box II
- Email Data
- Displaying Pivot Data
- Control Buttons Shift Positions
- copy and paste to existing tabs
- Macro - Identifying latest record within subset and displaying on seperate tab
- How do we get value assigned in a Sub from the calling Sub Procedure or Function?
- setting cell formula in VBA
- Random Sampling
- Automatically updating references from formula for re-ordered cells
- Scan a Worksheet....write to multiple sheets
- Separating long sequences of characters by space
- buy excel pdf book
- Extracting Page number
- Macro to find and replace text contents using the contents of other cells
- Pivot Table Questions. Weird Data
- Cross Reference using index/match functions
- AVERAGEIF is not equal to two values
- Lotus Notes Email using VB (Edit Text properties)
- Sorting Report Filters
- Simple Type Mismatch on Date
- How to write a IF THEN with Offset data
- Cursor jumps automatically to the next cell ?
- Lookup Value In Spreadsheet
- vba to ask user what sheet on another workbookthey want to copy from & then what cell
- Why? Getting 'command cannot be used on multiple selections" error?
- How to open a website address using a macro?
- How do we Increment Column Numbers?
- How to define a range based on the cell value
- IF(Or(And statement
- =IF(OR(AND Statement
- Defined name gets moved with cut and paste
- Help with averages/totals
- Find last col with data and last row with data then copy whole area.
- need help for random multi function in same column
- Worksheet_Change Event doesnt work after running Macro
- ComboBox Userform, Fill From Separate Worksheet
- Sodoku
- Workbook_Open not functioning
- counting when columns match
- Separate the amount of money to small unit.
- lookup text and return value
- Summarize 2 Different Workbook into 1
- Get.document(64) work 2003, but
- Inputting a value into a Chart Worksheet
- sending emails to gather
- I'm wondering how I can count added values in a single cell
- Hide Column When Printing
- Filtering Tables on Password Protected Sheet
- Shared Folder
- Userform textbox question?
- SUMIFS calculating INCORRECTLY
- How to insert rows dynamically with in group while creating macro?
- using the Pivot Table name in a formula
- Userform
- Colouring words in a text string
- Populate cell from data of another cell
- Remove Blank values from Unique List
- Questions on UK to US date conversion
- Pause macro1 when macro2 is called from button
- Concolidation Function in Excel 2007
- Calling a procedure when an object of unknown name is selected
- Vba send Email from excel
- Extract last weeks data
- Open positions count-Budget 2010 Vs 2011
- Stopping data being entered in a cell if data is not in another
- marco for making every blank row doubled.
- marco for divinding each group in 4 and adding blank row between each subgroup
- Shortening Code Help
- How does a Workbook_Open code execute?
- Finding the average, minus the smallest number, if greater than zero.
- Trying to Pass Sub Range Variable to Function, Error...
- Help with Plotting Graphs with Dynamic Data
- Watches & Local Window...What are the uses?
- If formula
- Array Formula to list common days in several overlapping date ranges
- Autofilling Horizontal Info to a Vertical Column
- Extracting data from similar cell in 720 excel files that in 12 folders
- making Pivots off master project data but choosing which projects get calculated
- VBA add signature to email
- vba if function
- worksheet change using ranges
- Reordering Cells
- countif reocurring header
- get number values only
- Problem
- need your help
- hiding a password during entry using ****
- Levels of Macro Password Protection
- Autohighlight text in text box on mouseclick?
- Autofill cells based on conditions
- Add an increased number in the .txt exported by a macro code
- How to add 2nd Series to step chart
- Automatically updating references from formula for re-ordered cells
- Macro effects my buttons
- Need help with 14 and 30 day totals.
- Shared Workbook
- compare excel sheets
- Test to see if value of textbox is a letter
- RTF File in a web browser control
- Sumproduct or similar
- ComboBox: How not to have default be bottom value?
- Perpetual Calendar Change
- Pasting Date from Textbox Value
- Can someone help me to correct it .....
- Freezing shapes
- Retrieving data from one sheet to another dependant on system clock
- Same Cell, Summary Report No Macros- Possible?
- A little help with code please
- multiple pivots in one tab; when I refresh, formatting gets weird
- External workbook links
- Macro to access Data sheet on hidden w/sheet
- Userform in Network connection..
- How to detect amount of changes in cell?
- ActiveX Control "OnAction" Property problem.
- Transfer Selected Data to another Sheet
- Automatically divide a cell
- Autofilter using values in a range
- Macro - find end of multiple columns then autofill.
- excel xml schema rounding off problem..
- Is it Possible to display Excel live data in webpage?
- need help
- excel2003 get data from the userRorm
- VBA Macro Code for Vlookup - Help!
- help with formulas
- protect sheet except for certain ranges
- calender
- Worksheet_Change()
- Can we get all the ShortCut keys associated with Macros ?
- Formula Help
- Help
- Setting the number of decimals depending on cell value using VBA windows XP Excel 2007
- Inserting Mod Statement
- Middle initial
- Saving a .xlsm file as .xlsx using VBA
- Macros slow in process
- beginner applescript question
- Automatically change sheet to be referenced in formula
- Scheduling
- Search in Excel Sheets
- Updating date
- VBA help transfer data to another sheet
- macro for deleting blank rows
- Pivot Table Divide By Grand Total
- Maximize validation string
- Looking for examples of complex charting, dynamic, Pivots, multiple series etc...
- question regarding variables
- How can i avoid this particular code from being runned into my sheet. Need help.
- Any help creating a pop up box?
- highest value with vlookup?
- Custom View and Sorting?
- footer flips
- Add excel filename in txt exported file plus save in custom directory, with macro
- Assigning Numeric Value to Cells Based on Content
- #Value Error Problem
- Excel file extention type where no more modification can be made to file
- VBA MMUlt
- Relative paths
- count unique frequencies col.A for spacific values col.b
- Data copied to different sheets
- number of values in one column based off criteria in adjacent column
- Hyperlinks won't keep references when Tab name changes
- string of fiscal year pie charts: how do I keep the colors the same?
- Press Enter in textbox, Userform
- Hide an Excel 2007 Chart
- Math
- Chart Data Labels
- Replace all sheet references
- autofill - dropdown menus
- Using VBA/Macro to remove Blank Cells
- Search cells for string and Copy Entire Row To New Sheet if data Is Matched
- Finding Repeating Numbers without using an array
- comparing values in cells but not as easy as you think..
- Macro - Filter unique values
- Application.FileSearch not in Excel 2010
- Automatic Filtering and formating for labeling system
- UDF and Pastespecial (at my googling end)
- =average help
- I need to reconcile an inventory! Help Feel like Dummy!
- Market Pricing v Actual Pricing - Determining the differential (correlation analysis?)
- How do I fill in fields with what's in the row above?
- Finding and highlighting a date in a data set
- Are dynamic lists of unique data possible?
- Excel 2010 - how to set format for horizontal axel in a diagram?
- excel2003 protection a sheet
- MsgBox to appear once only in loop
- Dynamic Dependent Lists
- Macro/VBA help transfer of data
- Averaging formula
- Modify Excel 2003 macro with Excel 2007 version
- Open PDF File And Copy Text From First Page
- Convert multi line horizontal records into a vertical list
- Formula for calculation of cost
- How to set a summary worksheet?
- Protect a single worksheet from viewing
- Load Combobox based on criteria in a sheet
- Ranking (lowest to highest)
- Vlookup from the Left?
- Tiered commission formula need with threshold...
- Pivot Table - more then one column to be convert 'SUM' instead of 'COUNT' in one shot
- Macro to track users
- Concatenate function
- what is the meaning of this command
- Run Time Error - 9
- Pivot Table remove #Value
- Windows activate using Variable
- use result from one formula in aother formula
- Count # of Sundays
- No prompt for macros
- Remember the lowest
- Hyperlinks, cells & text
- An issue with now()
- Macro to convert date
- Any circular reference gurus out there...?
- VBA : Solver,Markowitz ,MMult, Transpose
- Replace cell value
- Unexpected error using ActiveCell in vba macro, after Pasting
- Pivot Table help! 3 types available, only want analysis for 2
- Is MATCH the cause of the problem?
- How do I display negative value of a conversion
- Pivot table
- Autofill fails
- Excel 2007 - incorrect chart pasting into Word
- The If Function?!
- calculating t-values
- Prob With If statement
- Rolling Year - Sickness Tracker
- Easier way to write multiple SUM-IF statements??
- Adding to a very complex SUMPRODUCT formula
- Pivot table refresh empties table
- IF statement to find value
- Runtime error 1004 Document not saved
- Complex IF function
- MIN function problem
- Merging Tables
- Average for non empty cells in a row
- MAX value column A IF condition in column B
- Pivot chart, problem drilling through to underlying data.
- Autocomplete cells
- 30-60-90 DAYS OUT Formula
- Monday Morning Brain-dead
- Macro/VBA execute on list of worksheet names
- Toggle Button to hide/unhide rows
- Date Formatting
- I need to match and extract data by phone number
- excel2003 - group and outline
- Increase width worksheet named range
- Getting rutnimeerror 1004. unable to unhide...
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.