View Full Version : Excel Questions
- Dynamic sub-table with multiple search criteria
- Count instances of text on a different worksheet
- VBA error, stuck and lost
- Extracting specific data from a text file
- Custom Footers
- Need help modifying a macro made in 2003 for 2007
- XL 2003 VBA: Code For Executing Macro on ActiveSheet?
- Set chart axis values via cell values
- Short cut key
- VBA to sort data
- Print All Records from Database
- text string to character array
- Passing variables...not understanding...
- Counting cells on two separate files
- Tab and/or enter order: VBA or otherwise
- Print To single PDF, multiple Files, No Distiller?
- variance
- Need help with complex lookup table.
- Macro Error
- How to hold link in indirect formula? Help!
- Use enter key to start macro
- Updation of formula and reference in different Workbook
- how to display value of next cell based on a formula
- Update 'old list' from 'new list'; Match entries; Copy data across
- Setting Variable as a text string
- offset and match formula in excel 10
- vba code for printing hyperlinked documents
- Excel 2010 Close without being prompted to save
- Using a spreadsheet for data entry in a user form
- Simple find command
- Pivot Tables: Adding a cross column calculated field?
- Select a Range with Shift + Click: Problem!
- Can you change the size and position of the plot area on a chart using VBA?
- Macro: I can delete, now want to add formulas
- Sequential forumula to add a number in the cell below to data
- Sum, Merge, Delete Duplicate Rows -- HELP!!
- Summing with Errors
- Code to move to cell A after data entered into cell E?
- Change of name situation
- Extract the vendor # & use it within another formula
- next larger number for a specific rown in array of data
- Conditional Format Table
- scripting.dictionary
- Populate Cells based on another cell value
- CountIF? IF?........???
- Find Top 3 and Add Values to the Right
- font size change in macro
- How do I apply this Macro to more than one selected Cell
- Data Validation Pull down tab
- VBA Help Suddenly Stopped Working
- Remove the part that beginning with ...
- Word to Excel VBA??
- Public Variables
- Create macro to move formulas 1 column to right?
- Excel 2010 View cell from a different tab
- Use a Macro to enter a value in a protected cell
- recognizing patterns
- macro trusted sheet
- shortcut alternative for alt-e-s
- default directory
- increment
- Offset and sumproduct function
- HELP with Formula
- Code Trouble
- Drop Down List linking to other data - Novice
- Problems with Dynamic Page Setup/Page Breaks
- Problem with Interactive Graph with Rollover Hyperlinks and UDFs
- Faster more efficient way to sumproduct in VBA?
- Worksheet_Change DEAD
- Auto Refresh Cell in 2007 (non external data)
- sum formula function!
- Clone neighbour cell if blank; remove hyphens if leading cell char is P
- Find fails with variable in range
- Insert Picture In Comment Excel 2010
- Excel deleting characters automatically?
- Productivity formula
- Pulling specific data from cell
- turning off update values dialog box
- Search and import
- bypassing
- Add Decimal to Existing Number?
- data label in the xy chart
- Formula to compare and sum last 4 quarters possible?
- Using Option Box and Hyperlink with Protected sheet
- Search and match
- Macro find variable in one column then prompt what to rewrite in same cell in another column
- duplicating/moving cells containing functions
- Appropriate chart to include following info. Idea!
- VBA error in 64-bit Windows 7
- Macro to delete blank rows & columns from files
- Count Duplicates
- Variable Date Dependent Cell
- schedule worksheet help
- Hyperlink Question
- Vlookup within a vlookup? Is there such a thing?
- Simple Formula error
- Hiding and Unhide Columns Based on Displayed Columns
- SUMIF and SUMIFS not working in Excel 2010
- Save workbook structure
- Can anyone correct my 3liner of codes?
- Not able to delete column because of merged row in between
- Vlookup help
- what else can be used than a vlookup?
- Normalize values weekly to show weekly upward trend
- Normalize values weekly to show weekly upward trend
- Blank Date fields
- Blank Date fields
- Shared Workbooks - creating a button using a macro
- Easy Array question
- Help solving Run Time error 9
- Pie Chart Slice Colours
- Compare and merge issue
- Triggering worksheets events with changes in pivots
- Automatic updating of Hyperlink to a variable sheetname
- convert countifs to sumproduct
- Code Failing in Win7/Excel 2010, Works in XP/Excel 2007
- Alternative to 'ActiveCell.CurrentRegion'?
- Help - Pie Chart slice colours
- set range with .Cells.SpecialCells(xlCellTypeLastCell)
- Create Array via function - how do I make this work?
- Debug my code
- De Activate Button
- Need Help with numerous conditions/criteria
- PLs help!
- Slow loading excel file
- Two lined cell into two separate rows?
- Call a sub or function using a cell value
- calculate time taken for a job to complete
- Macro that looks at cell contents
- Poker table...
- Error setting value in 2 pivot tables
- VBA show a Dialog Box in another Workbook
- Saving an excel on webserver
- Very specific dynamic range requirment
- VBA Code Help
- Worksheet Doesn't Activate
- saveas dialog not working
- Query on table
- VBA Coding
- Idle Time
- VBA for each function
- .Formula = cells(.Row, .Column).Value
- Block users from saving document
- How to improve my INDEX & MATCH combo on text searches?
- Foreign Excel Issue?
- Esthetical problem when printing
- End sub if the next cell contains text
- Dynamic Select Case routines
- SUMPRODUCT(MAX( Question
- LOOKUP Issue and #####
- Listbox Preselection Based on other Listbox and Range
- Inserting data
- Count Time Entries VBA
- Count same values in collumn
- If statements
- Sum values across after comparing three columns
- Logical Tests
- Loop until the end and more eloquent way to write this code
- UserForm Listbox Not Displaying
- Do it again and again
- Can I completely protect a worksheet that has unprotected cells?
- weight tracker help
- Date & Time formatting - Change any date / time entry to standard format used by conditional formatting (VBA)
- Combobox With Variable ListFillRange
- XL 2003 VBA: Protection Does Not Allow Row Deletion
- Display values when 2 worksheets match in a cell.
- Macro Code required to Filter data
- RANDBETWEEN Query!
- Data Validation query
- Data extract adding header and finding text value
- Userform under different DPI
- colour cell if the equation is zero
- Macro to move an existing formula down one row
- VBA Formula Has Issue
- Highlight a row based on cell content
- if statement help
- How to I blank out cells that I don't need printed
- Conditional Formatting VBA Code
- Unlock cell in E based on value in Col D. HOW?
- Summarizing multiple sheets onto a coversheet
- Automated email with signature
- VBA String Issue
- VLookup Won't Work unless Pressing Enter in Cell
- Using Left function, returning numbers rather than text
- How to find duplicates
- Some Users Unable to Expand Pivot Table
- How to clear out this code?
- Perfectly functioning macr in 2003 is nor running on 2010 version.
- Insert column and equation range changes
- How to find duplicate in excel
- Trouble opening file
- Count content of cell based on background colour help please
- How to check/prevent duplicate data entered into cells
- VBA code for command button
- VBA Macro
- Help editing macro
- Pivot Table Row & Column Totals
- using multiple criteria in an If-then statement
- Is there any way to shorten the amount of lines in this border formatting code?
- Is there any way to shorten the amount of lines in this border formatting code?
- Delete Rows based upon text values in a column
- Why am I getting these #####
- Protected Worksheets Query
- Best Practices: Identify New or Changed Records
- if (date....issue
- Validation VBA function
- Highlight a row based on cell content
- Cell Resizing with Images
- SumProduct Formula Giving Zero Value
- why is this not formatting as expected
- Condense specific matrix data to seperate list
- Code Help
- Vlookup a bit modified
- Automatic/forced check-out for SharePoint links
- Do While/ Formula Visible Cells
- Open,RunMacro,Close a Closed Workbook
- Assign multiple macros to one button
- Loop code to delete all blank cells in multiple worksheets
- date offset
- Macro's
- Must be a simple way to do this ...
- Find theme path from workbook/vba XL2010
- Index&Match?
- Generating multiple results
- Pie Chart Label Help!!
- If statement for a range
- Number rating
- Blank cell
- Filtering on a highlighted cel
- How can I list all of the properties of Conditional Formatting on a cell?
- Formula Help! If statement??
- Help with filter
- Error in finding value on column
- vlookup compare 2 fields
- Lookup 3 values? Table
- Code Help
- finding duplicates
- Matching
- ADO, SQL, etc...
- Alternative to Index Match
- Copy & Paste Macro (Buttons) into new worksheet
- Extract combination number from the result
- Help with Formula
- reconciling invoices to a payment
- define column as an object
- Sumproduct or count problem
- Document not Saved
- Displaying Unique Values From A List
- Convert Date to YYYY.MM Number
- Create a new worksheet from a sheet
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.