View Full Version : Excel Questions
- counting unique items
- Problem with Loop
- Mode use with Text
- vbYesNo
- PIVOT TABLE SORT ISSUE
- formula help
- Extract date from a cell
- noobie questions
- Need help with find
- Comparing Data in Cells for similar values
- Automatically Come Up with Sub Totals
- If/Then with a range
- Copy and paste pictures with VBA
- Holiday Allowance Calculator - roundup/rounddown/floor?
- Conditional Sum
- If/Then Statement with dates
- comma shortcut
- msgbox upon workbook save
- If statement based on "contains" rather than equal
- Can anyone help on a macro error
- Average w/o DIV/0! error
- How do I compare just the first 4 characters in two columns
- Random Function always returns same numbers???
- Weird stuff happening on cut and paste
- can you automatically update a formula?
- Select Case
- Database Query Macro
- help
- Can anyone assist in how to delete rows
- Count Date/Time if equals date and user id question?
- making a sentance of variables
- VBA: Problem with local save
- F4 function
- Max date
- Can someone point me in the right direction? Arrays?
- Memory Error within VBA
- Copying formulas
- Deviation from 0?
- Way to VLOOKUP or FIND an array of values?
- vlookup
- COMMAND BUTTON
- Turning hour rate in excel
- real quick VBA question
- Formula Help!
- Unicode and Japanese
- Hide row based on Data Validation List
- Debug.Print Question
- Get formatting of a referenced cell/sheet
- Can anyone help with deleting cells
- Not sure why I get a #REF! error in my Future Value formula
- Using 5 days a week as the axis in a chart
- Need a macro to find a file by date in a specific folder
- Setting the cursor position in cell text using VBA
- Application.visible question
- SUBTOTAL & SUMIF
- COUNTIF ?
- Force Save with save disabled
- Before_Calculate
- Data Validation
- Selecting a range based on Date within that range
- combine "sum" formula and text
- Conditional format
- Comments are shrinking when copied
- Online data into excel
- Problem With IF & Wildcards
- Count one cell ?
- Runtime Error 1004 - select method of worksheet class failed
- date formatting
- Urgent - Please help !!
- Figures showing as Decimals problem - HELP!
- Identify a text string in cells
- Refering to a selected cell
- Calculating a z-score and standardized index within Excel
- Sort ComboBox Items
- Validation numbers
- Unchanging Balance
- Macro not working for anyone else
- Using DEC2BIN(A2,6) in VBA Code
- AverageIf - finding similar text
- Problem with OnTime
- Automated File Save Date
- Determining the command button
- please help resolve my macro issues Thanks
- Odd Command button behaviour.
- splitting up a worksheet
- Amendment
- Need a macro to prepare the report.....
- Pivot Table fields, based on column references? possible?
- Code to Create a Box in a Worksheet with Borders
- vlookup date with text
- urgent help pls!!!!!
- auto enable macros
- VBA custom menu
- Emergency
- Chart plotting?
- Date Driven Password
- SUMIF Problem???
- Simultaneous Countif function for two different criteria
- Summing a value (or time) over multiple sheets
- Moving rows (automatically)
- VBA LastRow Problems
- Filter query
- Count by Colour (Text) with other criteria
- type mismatch error HELP!
- Stacked Chart - HELP is it possible?
- creating a help guide within excel
- Running a macro in another workbook before copy and paste
- Cost Based Mark up--how to do it!!??
- cursor positioning
- Copying and Pasting.
- SUMIF within Vlookup - pop quiz hot shots
- Filtering/Modifying one column from another
- Vlookup #N/A problem
- HELP - DIFFICULT PROBLEM VBA GURU REQUIRED
- computing taxes
- How to add a space to text string?
- Pivot Table Columns
- CONCATENATE ATE MY DATE
- Need most recent date returned
- Formula for Ranking Data
- find column of last non-zero data in a row
- need help
- redim matrix - out of memory error
- Simple Excel to Word question
- Getting Rid of #N/A
- Print #2, For Next Loop
- Sheet disappeared
- Looping code that deletes all but oldest rows not working??
- Select a workbook
- Refresh Query Problem
- I need a Formula
- Help with Input Box/Msg Box
- Macro to name a range
- error 7866
- Nested "IF" function
- Navigation using combo boxes
- question about coloring text in a table cell
- Multiple Drop Downs
- Need to Create a Macro
- Macro to transfer data from open workbook to closed workbook
- Trouble using MATCH or Other?
- How To: Find the Last Value in a Row
- ADO connection
- Require a value in a cell
- Grouped Tabs - Setting Print Area
- help in excel 2000
- Number Problem
- Password Protect when saving as Excel 97-2003 Workbook
- Find most recent data?
- Pivot table question
- IF function
- GETPIVOTDATA, VLOOKUP help pls
- #Value! error with If Statement
- De-activate Form Button ?!
- Lookup issue
- Counting Uniques in Pivot Table
- Highlighting part of a row
- Auto Emailing Workbook
- Help deciphering my macro please
- Saving with a password
- Old Lotus files
- Need A Conditional Format Formula
- What function to use??
- i need help with Vlookup
- Need help rearranging cell data! (function? Macro?)
- Using VBA to Copy Cell Entries to New Sheet
- Unable to get the DrawingObjects property of the Worksheet c
- Assign a macro to a button, but run it conditionally
- mACRO TO MERGE FILES
- Macro not deleting entire rows
- deleting data with code
- Hiding macros from tools,macros
- Getting rid of Macro location display
- ISERROR formula not working - array formula?
- Strange problem when inputting text from file to worksheet
- Changing (lastname,firstname) to (firstname lastname)
- How to refer to a worksheet independently from its name
- Get partial data set from data table
- Changing the Shape of a Trapezoid Using VB
- How to ID by most recent transaction?
- User Defined Data Typed Constants
- MS XL translator error
- VBA Selecting Multiple Cells
- How can I get a vlookup to pull back 1st populated cell
- Excel 2003 or 2007
- Formula to express difference in dates as "xx Weeks xxD
- Excel Loop Question
- using VBA to hide rows in a pivot table
- Auto-populating worksheet tab 3 from worksheet tabs 1&2
- Date Function and Conditional Formatting
- Grouping colmns
- Code Help with Uniques
- Help with For Each, If, End if, Next
- Forms - Unified Change Event for Combo Boxes
- Need to chart zeros but not #N/A
- Order of Controls in Controls Collection
- Need to link two spreadsheet auto update.
- Need to find max value in a column
- Return last value of range
- Calculate Area based on GPS coordinates
- Autofiltering on cell change
- Required Margin calculation
- Pre vs Post calculations
- Need macro to add formulas for totals
- Excel 2007 and previous versions Analisys Tool Pak Function
- counter for checkboxes
- Linked Key
- adding $ signs to a column of numbers
- Data Validation using multiple lists
- DDE link with MS Word
- Run code according to countdown
- Subtotal and If formula
- Sum If w/ Index Match on vertical and horizontal match
- Help with Lookup formula
- use cell content to specify cell address column value
- Dynamic Range address
- Userform independent of Sheets
- RegSvr32 error message.
- VB code to prompt user and delete sheets
- Lost Password
- Dynamic print ranges become static
- MAX function in VBA
- Please help
- Merge spreadsheets together
- anything faster in XL-VBA than .Copy, .PasteSpecial ?
- Is it possible to filter based on comments content?
- Conditional Formatting - It's mean but not lean!
- if structure?
- How to attach sample worksheet to a thread ?
- Loop through 2 ranges, multiply each value together (vba)
- Big Find and replace knightmareorama
- Counting elements from a compound formula
- validation and default value
- Automating cell entry
- Auto-updated chart
- Variable Range
- SeriesCollection Properties
- Using Macro to add rows
- message box to shoe the regiater number
- message box to shoe the regiater number
- message box to shoe the regiater number
- calcuting very slow -- help
- Help counting cell values
- Calculate quarters from date field
- Problems with Find in excel
- Superscript & subscript
- OptionButton Caption Property
- RAND FUNCTION
- Sorting by colour
- Unable to Execute macro code on all sheets of workbook.
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.