View Full Version : Excel Questions
- endless sub & inefficient VBA code
- How to retain text format?
- how to navigate from one workbook to another using macro
- Prevent duplicates between 2 sheets
- vba streamlining
- Delete specific VBA code lines
- Excel Cell Conditioning based on a value in cell
- Need Help Please
- Is this possible
- IF, Concatenate, look up - in VBA
- Sumif if it begins with a certain value
- Finding Multiple Problems With Code
- Check box error message vba
- Would this be VLOOKUP? Or no
- Executing VBA When Person Switches Active Sheets
- How to work out total as. Percentage in pivot table
- Round Up/Down to the nearest 10k, 100k, 1m, 10m
- if blank
- Change a cell Value based on its colour
- unable to record sum product formula
- Copy data from one workbook to another workbook
- Not quite right formula
- Macro delete row condition!!
- Printing Filtered Pages
- Excel 2010 Graph question
- Search Workbook
- Format pivot table
- Match first cell that has color
- Protect Sheet and Options
- Help if an IF statement
- Counting words in a column
- Column to table
- Text to numbers
- Using cell value as range
- Delete Hidden Filtered Rows
- copy and paste multiple sheets
- Create a pivot table from userform
- Calculating cells from one sheet to another
- Address reference
- Counting unique values
- Graph Showing Widening Ranges Over Time
- Convert a standard Cell formula to be used in VBA
- Problem with my code! Please help me fix!
- count months
- Converting Formulae into values?
- Move file to a diferent location
- Zodiac Sign ????
- Autosum without the Zero
- Pivot Table Formatting
- Pop-up message when using Ctrl+f
- Turn off auto correct ALL users/profiles? Excel 2010
- Using If statements to find 2nd place in a data series
- Can anyone help?
- Help Getting Started
- Auto-Fit Row Height Not Correct Printing
- Series .......
- Error with formula
- Excel shutting down on closing a workbook
- Select from drop down and create PRF
- View totals per person
- stuck with find and loop
- how do i get the macro to work on several worksheets?
- Weighted Average
- VBA 'Find' gives error message - is there a better way...?
- How to disable Macro & VBA?
- Emailing Colour Problem????
- Print Multiple Sheets from VLOOKUP results
- Updating Add-Ins
- VBA - input data in all worksheets
- [Help]Partial lookup[Help]
- Use Image as Background
- Combobox transfer selected to worksheet
- Changing Rows Based on Cell Value??
- open workbook macro
- Assign 1 beside transaction
- Asking for the impossible?!
- Show last date in range
- VBA Question
- If cell value matches workbook name - copy/paste values
- Edit Cell Below That Matches a certain Criteria
- How to hide cells with certain value
- Copy cells from one file and paste on another
- Stop cell reference changing
- Deleting Duplicate data from a formula containing MCONCAT
- Method available - search for a string in a range
- SaveCopyAs in password protected macro
- Checking for <<Escape>> press with InputBox
- COUNTIF with multiple criteria
- Userform on only Sheet1
- Inserting a character&number into cells
- fill a range of cells with x's and o's
- IF argument (s)
- Transpose Table Headers
- Design Question for multiple users
- Macro to open template and save template as?
- Code To Load Solver Add-In Automatically
- Concatenate() an expandable array with a string..
- Capturing Average of Moving Data Points & Ranges
- Formula Help
- userforms, drawn forms, macros, and protection
- How best to call a stored procedure?
- Copy Rows To Different Tab Per Value In Specific Column
- VBA Code stopping when doing another task
- Passing a Public Boolean Variable
- powerpoint - never been solved
- How would I write this countif formula?
- How to discount 3 percentages from an amount x
- Activate a tab on the 2007 ribbon
- Function help
- Sum Text Data in Row - Count
- Count Data in Columns on Two Sheets
- Pivot Table Substituting text "Row Labels" for Field Entry
- count data from two different sheets
- Invalid Characters or Filename Too Long
- Removing Input Box from Macro
- Help with Checkbox controlled hidden rows (with more checkboxes)
- Need a little Help
- Sum Text Data in Row - Count
- Multiple if statements with vlookup
- Combine Animation
- Merged cell problem
- Auto Recover?
- Cell updating
- Help Extract Data from a Text File
- Automated Email
- Copying one sheet to other Sheets
- Need some help/direction
- Highest and Lowest Values Appearing Twice in Dynamic Range
- Can you lock split rows?
- If statements/Conditions
- VBA to run Access Queries from Excel
- Adding rows of different lengths
- VBA Detecting Color Change
- Trying to apply a dropdown list but to exclude blanks in the source
- Launch an SQL query from Excel VBA
- SUM Visible Cells only
- Error 438
- Macro for loopting through rows and selecting specific range of data from columns
- AutoFilter PivotTable source data rather than ShowDetails?
- Vlookup or match table
- fmStyleDropDownList Error
- Alphanumeric Addition
- Using Filtered Rows as RowSource in ComboBox
- Screen Updating
- Formula Help
- Difficult (for me) sorting of multiple inserted spreadsheets
- combining 2 worksheet_change events
- Index
- Help - need to consolidate workbooks
- Multiple Macro buttons (radio buttons) help!
- Functioning not Cycling Tabs
- Parsing by Oring a Search
- Using a Variable to Change filtered PivotItem
- Delete ROWS IF Cell is Empty-Reff every rowcell
- relative column adress within User Defined Function
- Copy formulas down based on a cell
- Too many different cell formats
- Auto Fill User Name
- Need assistance modifying vba from bigresouce.com
- Hide columns with VBA
- Date formatting Issue
- Conditional Formatting a row, based off of another cell in that row
- Deleting all instances of # + 1-3 additional numbers accross a workbook
- match,lookup,tricky,daterange
- Retrieving names from multiple tabs in a workbook
- Excel Gantt chart using w/c horizontally and actual dates vertically
- Entering data from the top/beginning of a list
- find match and highlight
- Stepping through an Array of Worksheets
- VB Script IF field is blank
- If Function
- Nesting IF with IFERROR statements
- Sumifs to sumif using 2 criteria
- how to navigate from one workbook to another using macro
- Compare If Statement
- Get last modified date
- Buttons that scroll down the page as you scroll down
- Hotel Rooming chart function help
- Operation canceled due to restriction in effect on this computer?
- Auto select data on webpage using VBA?
- reselect active range
- Trap Pivot Creation *in any book*
- Creating a Consolidated Error Statement
- Solver Problems Calculate 1 out of 3 problems
- need a formula
- Find combobox row number, and copy row number for later use
- Text Truncating Problem
- vlookup- only sometimes returns a value
- date calculation issues - 2 problems
- Make a formula change across cells
- Vlook up without specific range.
- Hover text on mouse over on button
- How can I remove horizontal scroll bar from listbox?
- how to multiple paste
- No Work Necessary, Very Simple Q!
- userform
- disable error alert
- Match to the closest and Fetch Value
- Delete range on certain day.
- Conditonal Formatting Help
- search, filter and userform
- Find Cut (or Copy) Paste
- Text formating
- Text formating
- I keep getting an error
- Copy between different instances of excel
- 7-zip command line via Excel
- How to increment the value in one cell based on the value in another ?
- Help with Type
- Clean Spread Sheet
- filter using the userform combo boxes
- Time sheet Help
- VBA for empty space
- Resize / crop / move the PDF in VBA
- Large If
- Subscript out of Range
- conditional function
- Display a value ( or not display) based on cell contents
- Excel Problem
- fill blank cell automatically
- A function that automatically populates a range
- Dialog box to long like to split to 2 columns
- INDIRECT not working for dynamic named range in SUMPRODUCT
- tracking of product ordering
- write data into another sheet after calculation
- Copying a cell value on second sheet to text box
- Getting data from multiple sheets organised
- deleting duplicate entrys problem
- Index or some other function?
- Worbook takes long to load
- Expanding Rows
- sort unique names and count into one
- New Quarters Formula From Date
- changing cell format from number to string
- Example code dynamic chart range xy graph Excel 2010
- Excel 2010 VBA how to draw lines between cells with the same strings
- Need a Formula
- Need help making it work?
- IFERROR Error still remains in 2003
- =IF(OR) returns #VALUE! error?
- 1,000 missing survey data points to be fixed by interpolation
- List Index column sum value.
- Formulas dissapear
- data validation
- An extension of VLOOKUP Function to return a range of cells for a given cell value in the same row
- Problems in using Excel 2007
- urgent
- what is ?
- Update range with minimum values from two ranges?
- change ext to .zip to view xml no longer works
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.