View Full Version : Excel Questions
- Linking to Tabs on separate workbook
- Graphing the Mean and the Standard Error of the Mean
- SaveAs problem
- User form code
- Filename
- Built-in Footers
- Checking of Duplicate number in three worksheets
- Calculating hours between times
- Authorize.net text document converted to excel to Quickbooks
- Dates and sum
- Formula Dragging Problem
- Formula to ignore irrelevant entries in IF function?
- Random Passwords and usernames
- Linking an Excel Pivottable to a large Access database
- RETAINING COLUMN NAMES FROM MSQUERY
- deleting duplicate data
- Keeping Arrows on Drop down?
- Create workbook from an excel spreadsheet
- Hide row if . . .
- Autofill a range of cells (need my code amending)
- values of variables not showing when Stepping through code?
- TOUGH problem to solve.....
- Merging the contents of two cells
- Print Worksheet Question
- Conditional concatenation & pasting a copy of spreadshee
- Newbie Help
- Separate city, state zip
- How to send email using script
- I cannot figure it out...HELP
- Pop up error message based on if statement
- Why did I lose AutoFill?
- Does a macro in Sheet 1 module run in all sheets?
- MS Query Question
- Password protect cells & allow the Pivot Table to refres
- Complex Formula
- Bar chart of 4 different series on same graph
- Update pivot tables
- Dialog Box to password protect worksheet upon open
- pivot table calc % of subtotal
- Quick Syntax Question
- what am i doing wrong?
- Having an equation save as a number
- comparison graph
- Line Chart Question
- formula calculations
- Combining Autofilters
- can't Paste into Find command when creating macro
- Hyperlinks.Add
- Counting and summing text within a row
- Trying to speed up a report.
- Macro situation
- +GETPIVOTDATA driving me nuts
- Check Box and Enabled
- Data Logging efficiently.
- export to access one row at a time
- hellllllllllllllllllllp
- e-mail work books using outlooks distribution lists
- Question about how to move down some rows
- Data entry, automatic formula
- Cannot SendMail from Excel
- How to combine similar cells together?
- message box pop up based on if statement
- totals over a date range - month
- date calculation problem
- Extracting Text from a column
- Cell Formatting
- Conver cell value to the power of a reference cell
- Error when copying contents of a combo box
- VBA Chart Loop Problem
- Filter - Macro Code - Is ther an Excel Doctor in the house?
- Open new spreadsheet and get cell data macro -
- Lookup or Index or Match
- combo box
- Public Variable set on Workbook Open
- Leap Year Formula
- Mysterious Add-In Error
- average only certain products
- Simple lookups, but I can't figure out a way to overwrite...
- macro wont run on differnt computer
- Create Borders with RC-1 code ?
- Second Stage...
- Calculating hours
- Variable greenbar report
- Merging cells with VB
- quickly reverse the order in a list
- Outlook questions
- filter a set of data twice
- help on formula
- AAAAAAAAAAAAAAAAHHHHHHHHHHHHHHHH!!!!!!!!!!
- hide column if meets criteria
- Circular reference
- Identifying the first and last day of the month
- Autofit columns
- [b]Sub:Urgent- worksheet using iteration addition[/b].
- adding a HYPERLINK to a single word in a sentence in a cell.
- Copying Many different style sheets using VB
- Array formula with nested if statements - too many?
- Im Stumped
- Block If Stament???
- copying to a new spreedsheet...
- Multiply selected cells with an absolute reference (vb code)
- Macro Range Name Loop
- Named range available in all sheets
- Function using more than one conditional criteria
- Amend Shortcuts on Excel's Open/Save dialog boxes?
- remove duplicates
- Button > Function Wizard
- Advanced Filter Criteria to copy data for Non Blank cells
- multiple conditional sumation?
- unprotect file
- Nested Functions
- clear unlocked contents on a sheet with locked cells
- Question about command buttons
- select case
- Re-activating Excel
- format rows (one at a time) with macros....?
- Macros for attaching to Outlook Web Access
- dont want a conditional to......
- Merging multiple Excel files into one. How??!
- Pie chart values vanish when moved?!
- inactive cells
- Finding/recognizing a word from a sentence in one cell??
- Reloading a sheet
- Filter
- If Data Altered then trigger Message
- Retirement
- use cell contents as reference
- Custom Chart Formatting
- Automating Emails
- dates from a string of numbers...
- Refresh txt file
- Find and Copy Paste
- Pasting Data in VBA program
- Copy information
- need to search for a range....
- Deleting formula's
- Printing Output of Conditional Formatting
- Open All Text Files With Format Info' – Excel VBA
- Hi Folks, need to "validate" SSN's
- Inserting text (with formula results) into text box
- rows to column conditional
- Fire Macro immediatley after AutoFilter is used
- EnableSelection = xlUnlockedCells - is this Useless?
- "Unassign" a macro from an object
- Pointing to a different sheet within a workbook.
- Tough Excel question for you
- inserting vlookup in a vlookup
- Automatic incrementing
- Macro to delete rows if criteria is met
- Multiple Subtotals
- Worksheet_change Problem
- CODE - Validate cell, but ignore dec places
- Recording a macro to find ALL cells currently validated
- data validation
- IF Statements, AND Statements or What?
- Simple formula
- VBE Macro to auto size chart -PLEASE help
- Pivot Tables: getting the data
- number font
- Referencing Maximum Tabular Values
- Separate a number from a cell with text
- Formula, Macro or VBA script what will work for me??
- Please read...Help with Short MACRO
- Macros to change formulas using Edit/Replace
- Help with Too Many IF/AND Statements
- Macro Problem
- Cell Validation
- VBA to name ranges
- UserForm Help With Captions
- Code to insert text box text into cell
- VBA - Select Multiple Columns using Column Number
- sheet Protection
- Determining the occurrance of different numbers in a column
- incrementing columns via input box
- Vlookup
- Macro to change the position of a dash to a minus
- Crossing Worksheet Formula
- VBA Convert text into Time Value
- Drp-down button doesn't dissapear
- Strange problem, unexplained phenomena in Excel...
- IF Formula help
- Locked cells and lists
- Excel vs Access or Excel w Access
- Multiple Lookups
- Simple Percentage Formula
- Using Option Buttons to hide/Show ranges
- add to a cell reference
- Formula problem
- autosum while printing
- trouble copying every 3rd cell to new column
- Using Excel functions in UDF code
- picking entries from a list other in another column
- How to find object name
- checkbox control references issue?
- Sort & Total Routine For a Text File
- Automatically place square brackets around a number
- what is the...
- Reading Text Files Within Macros
- Creating Custom Reports
- Keyborad shortcut
- Macro for user selection of range
- Referring to a cell in a named range
- Why does text show up as ################
- Listbox question
- Importing Text File in to Excel, Character Limit
- Conditional Cell Locking?
- multi X-axis chart
- Color Coding elements of a list - VB Help
- Show Pages w/Pivot Table & Pivot Chart
- Sumif function across multiple tabs in another workbook
- New User - Help with Formula
- LOCKED FOR EDITING
- Transparent bars from VBA
- for loops
- Locking cells based on data when data is refreshed
- How can I divide a cell?
- switching cell contents and comments
- FORMAT QUESTION
- saving macro
- Buttons
- Chnage range if another range value is ""
- Excel Macro Command - Carriage Return
- Range or Cell Changes versus Worksheet_Change
- Need a formula for my payroll module
- printing multiple copies of same sheet with 1 date cell diff
- deleting contents based on color
- Is File Open?
- Formula HELP ! please
- formula dependant on entry
- Insert image into UserForm
- What is VLOOKUP ??? I am really new to this.
- Excel chart smoothing algorithm
- Need a Macro for Allocating Numbers
- Move or Copy 1 sheet many times
- excel help
- Problems with opening Access report in Excel
- Macro for user to click a button that will display text
- data validation & multiples
- Possible Glitch
- Conditional Cell Changes
- how to sum excluding subtotals
- sums, ifs and multiple conditions
- Hiding Columns/rows
- Need a date AND time picker control
- Userform crashes Excel?
- Calculating the difference between two times:
- Hidden rows; blue row numbers
- Where is the problem with this code for inserting values?
- Return Focus to Excel?
- Print invoice copies and mark "Copy" on the second
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.