View Full Version : Excel Questions
- Learn to create your own Login+Password
- Find matched string between 2 columns
- Excel : AND Operator
- Conversion of data in rows to data in columns???
- Text Box / Formula / Chart
- help with Vlookup in an OLAP cube
- VLOOKUP
- Assigning macro to a button with VBA
- Help, trying to use data from 1 sheet, to find total Cost.
- Grab the Last Cell with a Value
- Cut/Paste and delete Rows that meet Cond. - help needed
- RE: COMMAND BUTTONS
- Combine 2 conditions in a worksheet
- Automatic update of data in Sheet2, based on sheet1 data
- cell returns wrong value
- List printers
- Automatic Customer Ref
- Somewhat complex function
- Making documents idiot proof
- HELP! How can i extract certain data from my excel document?
- Sumif with colour criteria
- Deleting row when date is less than 01/01/2006
- Run time 1004 error
- ways to execute macro codes
- Select a range from cell found by End(xlUp)
- Drop-down menu
- Unhiding a row
- Delete Rows On Selected Text In A Column
- Opening a Application file
- VBA Code Needed
- Clearing the Sort Dialog
- Ranges
- Filenames
- Insert symbol via VBA
- File is in use by me
- Different cell color = different value?
- Simple Question - Hopefully, Simple Answer
- Print sheet from userform without activating sheet? SOLVED!
- Duplicate entries (not so simple) - help appreciated!!!
- Extract of specific Cell information
- Creating Back-ups of Files
- Conditional Hyperlink
- AutoShape Text
- Sum Values is a range that includes #N/A
- Macro running problem in Shared Workbook
- Dependent validation and error alerts
- Merging cells
- LIST FORMULA
- Sorting a column with date ranges and specific dates
- Count unique entries in a list
- Change Column Headers
- change statistics in my table.
- Question about charts.
- Copy entire workbook code
- Running Access Macro from Excel
- Showing Unique Values in a list
- Perform VBA excel code on different files
- Dropdown List
- Finding Hyperlink Targets in Excel
- macro to compare lists, help!
- Line graph
- Hyperlinks that reproduce
- macro to unhide several sheets
- ROUND Function in VBA
- links
- code to copy and paste 4000 times
- VBA Tab Control - Non-Form
- converting 4 rows & 6 columns into 1 row & 24 column
- Secret formulae...
- Help with mail merge needed Please
- Counts with multiple criteria
- Weighted average- please help!!!
- Linking question
- Prompt requiring specific action before opening a file
- Bubble Charts: Bubbles hiding behind other bubbles
- Adding days depending on start date
- Lookup query
- "Block Copy" function in Excel?
- setting Text Box text
- Restricted characters in sheet name portion of named range?
- save as UTF-8 or UTF-16
- Graphing Question
- Matrices
- Multiple xl sheets open
- Better VBA for selecting worksheets
- Arrays
- form
- Move Pivot Fields
- Automatically entering/fill data in cells
- Array/lookup Formula??
- Array/lookup Formula??
- VLOOKUP to open a certain workbook?
- Dynamic pivot table question
- Sort data and copy to new sheet Macro
- VBA Code to add/delete a command button
- Linking Worksheets
- Available Resources
- E-Store and Excel Spreadsheet
- Graphing relationship between 3 variables
- Text in a merged cell being cut off
- convert from unicode to UTF-8
- Help with code efficiency - grabbing data from the web
- Help with VB
- Searching text and the OR function
- Trouble with counting values with multiple requirements
- Graph Labels
- =INDIRECT, SUMPRODUCT, SUMIF......
- How to use a cell for chart value (Y) axis scale ?
- Grouping Unknown Number of Shapes
- Macro Buttons
- Help with Macro using TODAY()
- Merging 2 spreadsheets
- TIME AND USER STAMP MACRO
- Password Problems
- Weekly Summary
- hide/unhide sheets VBA using True/False
- Primary School teacher needs some help
- Primary School teacher needs some help
- Primary School teacher needs some help
- copy formula to the right x times
- AutoShapes - FollowHyperLink & Text Searches
- Here's a doozie!....good luck!
- =now()
- Need solution to insert a row after each unique entry?
- Year to Date calculation
- email attachments 2
- Deleting Spaces After text
- Vlookup across multiple tabs?
- Delete all sheets but Sheet1 Macro
- Using SEARCH function with OR function
- Using Left function in VBA Macro
- Weird dates from SQL SERVER... Can you help?
- merging information from partial duplicate rows
- How to delete rows - in a macro
- filling in cells until you hit a cell with data.....
- Simplify navigating in a template for users
- Changing data source in pivot tables
- search-copy-paste question
- Manipulating data that has already been sub-totalled
- This should be easy
- Formating data - Consolidating and coping rows
- ROUND function
- Help needed with If and AND formulas
- is there some kind of active-user-form registry?
- Open a text file into an array only
- Vlookup ???
- Passing value from user form entry to module
- Validation in-cell drop down menu gone!
- External Links
- Can't edit formula created with conditional sum wizard
- Macro for user defined avg of range
- Place cell values into an array
- Excel averaging formula
- crashed excel spreadsheet
- Combining Workbook, could not find this yet
- Please stop erasing my cell borders, Target.Interior.Color!!
- Compound "If" Statements
- Keyword Macro search
- index question
- More Help please........
- modify code
- Find the cell address relative to a shape object
- Copying and Dragging Cells in a "Transpose" Fashio
- Translating graphs into excel spreadsheets
- Macros
- Modify Email Code
- Sorting querry
- Dealing with duplicates or ties using RANK, 2 columns
- UnConcatenate?
- value changes with # of digits ??? (leading zero's)
- Insert text from a cell into Macro
- Format ratios as general number types?
- Utility to color xlColumnStacked consistently
- "Please enable Macros" Page
- Transferring data from a listbox
- Validating length of Concatenate using Or?
- Find a “Postion” relative to a shape object
- Workbook Freezes on Opening
- Newbie; Is Excel the right choice here ?
- help please.......CMD
- Beginner trying to build a macro
- Formula to count # of cells of a particlar color
- quick compatibility question
- Sort rows by date, pushing todays date to top
- Cell content - blank
- My menu is disabled!
- Date Auto-fill issues
- Testing for blank autofilter result
- Copying a range from another sheet based on cell value
- Rename Worksheet to range of each sheets
- more dicreption
- Copy and Paste times 5 in a column
- Link to External Document Macro
- Converting a whole number into hours
- AutoFill
- How Can I extract date from text string?
- Excel Crashes When Print Previewing Sheet with Merged Fields
- Too many nested functions
- two vlookups...
- HTML Jibberish when viewing posts with Spreadsheets
- If statement nightmare!
- multipage events and stuff
- Transpose 1000+ rows (5 cells per row) to a single column
- Delete rows if cells on some columns emtpy
- Trace dependents multiple selections
- generate a Randomized list
- Listing out Formula Components
- Unable to view code in the forum
- Saving to multiple network locations
- Content in worksheets depend on 2 user inputs
- damn IF statements!!
- For Next loop not working..
- Beginning of Month
- AVERAGE(Address:Address)
- Manual Loop
- Help with AND
- Protect sheet with macro so only able to select unlocked
- IF function
- email groups
- Creating an interface to search for a record
- Separating a Number Into Digits in Excel (row wise)
- How to capture tab name in a cell
- Charts in VBA
- Sorting rows to seperate sheet depending on data
- Open / Save Outlook Attachment
- Macro help
- File Locked When Opening Excel
- Calcualte Top X% of a Column of Values
- Making one column two different widths depending on position
- VLOOKUP 2 values
- Color change based on Formula results
- Resetting an in-cell listbox
- VB Passwort Request when hitting Button
- (n)th question around dups rows deletion - sorry
- Adjust page margins vba
- Import file With ActiveSheet
- Pleas Help!!
- CountIf Question
- TextBox created on the fly, how do I extract the data
- Using If function to quantify yes/no responses
- BeforePrint?? If statement, nested If statement??
- SUMIF with a Date Criteria
- link worksheet A & B
- Formuale in Pivot Tables
- OPEN WORKBOOK MACRO
- "=ISNA(VLOOKUP(),0,VLOOKUP())" is there a better w
- Excel 2003 - creating cascading filters
- How to open external program by VBA
- two Questions
- Excel book > email attachemnt
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.