View Full Version : Excel Questions
- Help w/date comparisons
- Update Rate Code List every day
- Copy and update a column every minute
- VBA - MATCH function with 2 criterias
- Self certification - digital signature
- Check if multiple workbooks are open
- Formula to distinguish between time of day - 24 hr clock
- userform show based on column visible criteria
- Multi-criteria vlookup within VBA
- limiting selections on an excel form
- putting 2 lines VBA together
- Time Question
- Populate comment based on info in another excel
- Indirect Question
- Separate numbers from text from a cell in excel
- Concatenation w/ multiple criteria
- Coding for Exit Command Button to close the workbook
- Use date range to add data
- Is there any way to find WAC in Pivot Table?
- Enter time via cell selection (almost there)
- Formula - Biggest Area# in a Region
- if statement formula
- SharePoint Checkin (still tryin')...
- Cannot Update links message
- Posting results in matched column, accordingly VBA
- On Error GoTo issue
- Pivot Table - using names vs. numbers
- Excel Form on Web
- AdvancedFilter Works day1, doesn't work day2?
- loop through combobox items
- Hopefully an easy one...
- Extracting Hyperlinks
- run macro when a data validation list is changed
- Need suggestions with my code to cut and paste the rows
- Help with linking to multiple password protected source workbooks.
- Identical rows based on column A.
- Allow users to edit range on worksheet
- Convert to just date
- Lock all cell references on page
- Find text in 2 columns, copy row to new sheet
- Validation and Vlookups?
- Dropping a resource into a category...
- Great Benchmark Idea gone Awry.
- Sorting horizontally and adding text
- Use ComboBox to Populate List Box
- Dropdown menu gone, WON'T COME BACK!?!?
- DTPicker 2010
- How to Detect Option Button Selection
- Need Help with multiple Sheets
- Excel for Mac
- Help: Combobox to change according to another conbobox
- french number conversion
- How do I get a list box to NOT display certain workbooks
- Summing numerous entries per department into one total...
- Formula change
- Creating new tab
- Pulling data from multiple files in multiple folders
- Close Connections
- If cell contains text found in list
- Custom Toolbar Buttons
- Obtaining NT Logon id to open
- VBA to remove any value of 0
- Stop Auto Convert of Value to Date
- Concatenate 2 cells and 2 strings
- Time format question.
- Can vba run a access query from excel?
- ADO Recordset Fails.....Query Too Big?
- Simple Import Data From Another WorkBook PLEASE HELP!!!
- Wheres My Macros Gone?
- Problem with storing date/time in a variable using VBA
- copy/paste special formula to new workbook
- help debugging code
- Error Message that I cant figure out
- Formula Help
- Merge 2 rows in same worksheet
- loop problem
- Finding 1st instance quickly
- Trouble with multiple Countifs, multiple criterias (possibly in VBA?)
- For Control Variable in use
- Circular reference iteration
- macro that extracts specific data from multiple worksheets
- Delete all custom menu created in addin and rightclick
- Sheet Name Formula (should be an easy one)
- Embedding a picture
- Show cell blank then no value in reference cell
- Allowing for Variable Pivot Fields in VBA Code
- Pivot table Information
- Sort, copy, paste
- Extract Comments
- Copying a Column of Colored Numbers
- Unique Value with multiple criteria form other columns
- hyperlink value vs. displayed text
- Macro matching question
- Macro to copy data (NOT formulas) from one sheet to another
- Realative cells
- Conditional Date and Time Change
- i want to loop through some worksheets and the do a loop in each work sheet
- List help
- Slight problem with macro
- scenarios
- Formating help with VBA
- Limit text to column to using only 2 columns
- Stacked bar chart, bar presentation problem
- Macro needs to automatically find the first blank line
- Determining what current custom view is
- Subtract 2 numbers from cell with text
- Averaging using the date instead of day of the week
- VBA Match Text in Different Worksheet
- Type mismatch when querying from ODBC table
- Clear data from hidden sheet?
- disappear
- How to limit alphanumeric data input AND/OR line spacing in a merged cell area. Data Validation or VB?
- Rearrange data from one sheet to another
- Flip long list in one column from bottom to the top
- tale of 2 combo boxes... I need help
- VBA Open, copy, paste, close
- Find the nth row that meets multiple conditions
- Birthday Paradox Simulation
- Worksheet variable question
- Conditional Custom Cell Format
- VBA Worksheet_Change dependent validation reset dependents to blank
- Math operators as buttons
- Recalc for a UDF a little perplexing
- Using numbers in column to reference tabs?
- Extracting data
- Need to make my delete row script loop and also remove blank rows
- Statement not working correctly
- Copy then paste special values to next empty row
- VBA macro to save file, appending Date & Time stamp to filename
- Sum in a date range
- How can blank be greater than zero and therefore return TRUE?
- Hlookup question
- Pivot Table - Last Row
- vlookup solution?
- Pivot Table - Formating resets all the time
- VBA Books
- Activating the Current ws in Array befor Calling Sub?
- interaction with other applications
- Code to copy data from many worksheets into one summary tab while adding additional cells
- Multiple Helps Needed Please
- Number after Hyphen
- Random sampling with excel
- Saving file to folder
- Hi am geting an error 1004 when i try to copy filtered rows?
- Select all non empty cells
- Add Date formula to Macro
- UserForms & Memory Management
- Macro New WS for each unique record
- Hide sheets using VBA
- Clear key buffer after issueing sendkeys command
- Can "sort" be used without named parameters?
- Running Solver for multiple rows in worksheet
- Userforms and ComboBox
- Sending row from excel as an attachement using outlook
- Selecting characters from a cell
- VBA Function
- Add color to Grand Totals sections of a pivot table
- Automaticly generating an excel database on one sheet from a static excel sheet
- Copy & paste question in macro's
- Populated list
- Mconcat...
- Explain what is what
- IF and AND formula
- Hyperlinks
- List of all non-zero value cells
- check range of data validation
- Copy title in cells
- Unhide module in excel
- Data Validation if in Range
- Check if array has contents
- Changing column width
- Help Required with Formula for Sales Comissions Please!
- Copying and pasting formulas across documents.
- Userform to be used to input figures
- Data conversion
- macro to simply close current open browser
- Message Box with 2 conditions...
- Changing the color index
- Array Error #N/A
- Macro to go to cell
- isolate row value to change font color
- Copy/Paste Defined NAMEs
- Macro To Concatenate
- Sum of values based on Adjacent Cell contents
- VBA to copy attachement to excel from Lotus notes email
- Update Data without repetition
- Conditional Formatting after a sum calculation problem
- counta or dcounta should be a simple one
- row count for tables
- how to count number of text entries in a range?
- Find first cell that contains a number.
- valuenumbers need to be pasted in a specific cell
- All cells = 0?
- Change text string order
- billion combinations of probabilities
- Separate initial from surname
- excel 2003 Drop down Calendar
- Automatically Paste Special Values and Proper Case
- Excel Hyperlink
- Hide a Formula (not Lock)
- Why use Choose instead of Lookup?
- how to filter/move rows based on worksheet names?
- Need help removing an array
- Unmerging cells
- How to learn Macros in excel?
- Using VBA .FieldNames in Excel 2007
- Multi-Level Category Labels
- Survey Spreadsheet problem
- change cell colour when other cell(s) are green
- How to not display Rows and Columns (not the Hide or Group function)
- Date Calculation
- Disable Message Workbook Contains Links
- VB Nested IF
- Help Required
- Vlookup Multiple Results
- Incement column in VBA
- Daily date log in
- Military Time
- ThisWorkbook1 ????
- Excel Newbie question
- Help with statistics
- Automatic Monthly Timesheet
- How do I write this OR Statement
- Pivot table Refresh On Enter
- Excel workbook test! help please
- Need access expert
- How do I set a number to nothing?
- sumproduct
- Modify macro to allow selecting a printer
- Function to return a specific number of message recipients
- Comparing Two Spreadsheets
- Asap help
- Issue refreshing linked spreadsheet
- Open more than 1 excel file begining with the name "abc"
- Excel stays open in Task Manager after closing (VBA)
- VBA to loop and copy
- Excel Userform
- Difference between Date and Time
- Locking sheet except for a few cells
- AVERAGEIFS using Date rage as a criteria.
- Dates in Pivot Table not in Order
- Excel 2003 problem executing macro
- Countif with the changing of column values
- finding complex duplicates
- Macro or formula
- Please explain this line of code
- countif + blank
- conditionl formating
- Need excel expert
- Converting Theme Colors to Customized Colors
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.