View Full Version : Excel Questions
- Link to a number entered in a cell!
- Searching strings for patterns.
- DLL Problem
- vlookup with multiple lookup values
- Restricting input to a user
- if year=2002 then display "blablabla"
- Is it possible to create a button that launches the Find box
- Returning numbers separated by commas
- is there VBA Master of excel
- Something funky with Arrays - Can it be done?
- Need to create a formula that deals with time
- association with macro
- Object required
- 3 stackbars side by side
- IsString?
- display formula in a cell instead of the result
- How do I insert a (-) into a cell with text
- Link between two .xls files
- Alternative to VLOOKUP
- Workbook.Close on Worksheet_FollowHyperlink
- optionbuttons - strange behavior with controlcource
- How do I delete named sheets within a work book
- Enabling Multiple buttons
- "Find" a tab in a sheet, instead of having to loop
- VB code Find a variable value
- Counting unique entries in several ranges
- Image File Errors - Trapping them with VBA
- Hide Formulas and display values
- Combobox Form Help
- Result needed
- Removing a 1st initial
- Protection and Inserting Comments
- is # instring
- Print Macro for pivot tables
- Excel Distance between cities
- Formatting a row
- Creating an Entry Form to append the data in a given sheet.
- CountIN
- Trendline option not an option
- Recalc questions
- Create a folder
- Hide title bar in User Form
- how do you find external links in a multi-workbook file?
- Formula help please
- 3D Pie Graph formatting
- CONTROL SHIFT ARROW- NEED HELP
- change data's view
- Two series column chart with % as data label
- Why can't I shade a cell when the sheet is protected?
- Tracking text box changes
- Convert a number to a hour
- Formula Assistance, Por Favor!
- Picklist - Data Validation
- Create my own Reusable AutoFormat
- HELP!!!!Calculating Character Values From A To B
- Counting the number of letters in a string?
- The GetOpenFilename stuff
- GetOpenFilename - a strange stuff
- GetOpenFilename - a strange stuff
- SUMIF help please
- VBA - adjust to not delete all sheets
- unique entry lookup in large table
- Reduce duplicates vba code with variables
- How to check if excel is open?
- Looking for Pivot Table Help
- Hiding Rows based on cell value
- Date format coverntion
- Create a task in excel
- Check For File
- conditional format for pivot chart
- change format based on other columns
- Concatenate data into one cell and format numbers
- Fractions
- getting a variable from its pointer.
- How to stop FLASH in Excel.
- Searching a table
- IF formula - combining with AND?
- Advanced Conditional Formatting? Is VBA the answer?
- Can a Microsoft Word file be linked in a Microsoft Excel?
- Taking Macros into other workbooks
- Filtering Duplicate Rows based also on a variable condition.
- Inserting Symbols
- Delete data in userforms
- Help! Conditional Formating Formula
- SEPARATING ALPHANUMERIC DATA WHEN PATTERN IS IRREGULAR
- macro to take info from Word to Excel
- Help on a formula with 2 criteria’s, involving dates.
- Userform help!!!
- column formatting with Vlookup
- Closing/ending an external program
- Number of decimals
- Adding a row between 2 rows with all caps
- =IF MACRO
- Remove comments from tooltip insert value into adjacent cell
- Merge Formatting
- Sum varible range
- delete entry in userform
- Break links
- How? Deleting Non Recurring Data
- Selecting Cells
- Adding a comma and space
- Printing Internal & Boundary Borders
- Pls Help, newbie need assistance in excel formulas
- Using AVERAGE within nested IF function (or vice versa)
- how to refer to a non active workbook in VBA???
- Is this Tricky calcualtion Possible?
- Stacked chart doesn't work with trendline
- defining the header row & "end" of spreadsheet
- Pivot Table Help - PLEASE! (I'm Stuck and Starting to Panic)
- Conditional Print Macro II
- ColorFunction, modified
- Write MP3 Tags back to file
- Import and transpose a large CSV in Excel
- Inserting a row...I want the formula to change...
- Need help with this type of FUNCTION
- VBA to capture selected range
- Rounding averages
- Help Cleaning up and DeBugging Macro
- Dates and SMALL Formula
- Drop Down List help
- Macro to AutoFill DIFFERENT rows each week
- Sort left to right on five cells in a row, then next row
- Cumbersome formula
- Displaying rows last 5 values in a listbox
- customizing trendlines - square root function?
- Hidden Rows/Columns
- vlookup for data in 2 columns but same row
- Dates with Business Days.
- Still Need Pivot Table Help (3rd Post)
- For Norie: I like the Formula Question Topic...
- using two formulas
- Reversing name
- How do I use user input from different module?
- Pivot Table from multiple sheets
- Problem with ROWS in VBA
- help...new to mr. excel, how do you input a code?
- more then 1 day
- VBA: Copy sheets from separte files into another workbook?
- Excel multiple look ups
- converting text to numeric
- Formatting a number within concatenation
- Display data based on criteria (e.g month reporting)
- Complex Reformatting
- Manipulating data
- Lotto Question...
- Pivot Table - large data rows of text need to be counted
- lock cells and run macro
- Formula help
- Shading entire rows based on a condition
- Pivot table data source order
- Sendmail funtction
- what day is it
- HELP! - Hiding colums Macro
- Returning a value in a table
- Macro for Excel
- Advance Pivot Table issue
- SUMPRODUCT QUESTION
- Printing problem
- VBA String Value Error
- Play a sound after sheet calculation
- Run a macro in another book
- Worksheet won't save
- Referecing a range in another workbook in vlookup
- Pivot table creation via Macro: a greyed rectangle appears
- Text Import Wizard - Text Qualifier?
- Use of "IF" formual to show correct answer
- Can you help me with ANOVA
- seperate values from a column of values
- Sheet tab name appearing in a cell
- Capturing Range for Pivot table
- How to have the data dynamically updated in another monitor?
- data valadition
- using the large function, row and column function together
- range problem with code
- [SOLVED] Timescale chart interpreting dates wrong
- Named formula length
- Convert ASCII file to an excel spreadsheet
- Combo Box Question
- Time Formats using the now() function
- Trouble with VBA sort. Too many columns?
- SAVING CELL VALUES AS DIFFERENT FILES WITH CELL VALUE ASNAME
- Window scroll issue
- alternative ways to closing a workbook
- Looping problems
- Black and white unintentionally
- dialog update links yes/no
- Reformatting data
- Additional Controls
- Is it Possible?? Please help
- Notification of a new file in a folder?
- Counting! Sumproduct? ? Help!
- Formula help please
- Conditional Formating
- Copying parts of a line
- VB controls
- Submiting A Excel using enter
- Formatting not working
- How to populate a userform by highlighting a row? (Excel 97)
- Set Print Area conditionally?
- Extract only some numbers from cell
- find a particular date in another sheet
- auto copy of info to other sheets
- Scroll area lock not working ?
- How to check the sheet is still valid and exist ?
- cumulative data in a column
- looping
- copy paste 2 xl files
- salect USer and sum points
- An Introductory MessageBox on loading of Excel
- Alphanumeric Logical Sorting
- ?NAME#
- security always going to medium
- Copy method of Worksheet class failed. WHY????
- Option Buttons
- Split Lastname, FirstName into two cells
- Converting a file to PDF using code.
- turn off entire cell contents
- How do I fill blanks with the entry in the cell above?
- How to take data from Excel and create Outlook Event
- help with dissecting a cell
- help with dissecting a cell
- Updating links between workbooks
- Last Items in a Growing List
- If statement
- Copying rows onto new sheet
- Indent based on criteria question
- Closing Grouped columns
- Execute any type of file from excel vba
- Data Validation, the use of ranges restricts error alerts
- Saving to a different name
- Code that inserts rows based on cell value
- Sum if
- macro question
- Mark up by percentage
- HELP...not sure how to do this
- Macro to copy and paste in new line.
- select column
- Excel Form Validation Using VBA
- VB code for printing a worksheet in black and white only
- For each next loop
- removing and disabling hyperlinks in excel cells??
- Speficy cell in VBA using column letter and a row number
- VBA selection question
- My form doesn't close when I press the 'X' - SOLVED
- bar charts
- VBA MATCH WITH COPY AND PASTE
- Need help with creating a formula
- Make all references floating
- Userform controls visited question
- Using Filters
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.