View Full Version : Excel Questions
- concatenate variables
- User Form with Check Boxes
- Pivot last refreshed function.
- call macro with validated dropdown menu
- VBA to Print First Page Only
- Finding a value
- OFFSET,COUNT formula for current month?
- multiple if statement formula help
- Using the same variables for multiple macros
- Named range question
- Match Code VBA
- Query Table, Excel 2003, Insert/Name/Define, Added Spaces
- Conditional Formatting Help
- Sending an Email with Excel File Using VB/ And help with Looping
- VBA SQL Help with Dates - Excel 2007
- Column to a row and repeat!
- Need to use array formula average(if( for 2003 instead of averageif( but can't get formula to update relative addresses
- Sorting on one column without compressing data in following row
- Using variable for "libname" in Declare statement for DLL function
- Lookup, Copy, Replace
- Disallow switching worksheets by clicking on a worksheet tab
- Sum or sumproduct of multiple columns based on the text contents of a cell in the column.
- How do you control the scoll bar?
- How to make a reporting-sheet user friendly?
- Help with IF statement
- Removing equal signs.
- VBA, Copy a Row based on value of A Cell.
- Find the last date of Annual Leave for person
- using a formula in VBA
- bypassing an error with find function
- Add the total of column C in the 'NEW' sheet
- conditional format
- Repeating 10x
- selecting sheets with the keyboard on a Mac
- Sorting data based on drop down list selection.
- Macro to split worksheet by date
- Math Genius? Formula to figure price
- VBA: Loop thru column & replace null values
- sumif
- Assign macro to control button
- Compile error with Do Until Loop query.
- copy paste value best practice
- Custom Format Question
- Find Time VBA
- excel vba for open, copy multiple workbooks then paste all in a new workbook sheet1
- Evaluate cell with alphanumeric
- forms (input data)
- Vlookup with base data tothe left
- Whats wrong with my loop code here?
- Renaming worksheet in VBA
- Fastest way to delete rows based on cell
- Conditional formatting problem
- If and elseif
- Determining Runs and Trends in SPC Chart
- worksheets declaration
- sum values in red cells only
- Pivot Table: Using the Grand Total to calculate
- advanced filter
- VBA Piecewise Functions
- Count unique dates (irrespective of year) via Pivot Table
- Only show unique values
- Text box to list box population
- What would be best method for deconstructing an Ebay Variation: i.e. How can I convert an Item number to the corresponding item numbers
- Value Error Question
- Not able to open Excel file
- Countif problem
- determine the price based on the code
- Rating System
- Vlookup not returning value correctly ....
- Macro to check data entry before opening next worksheet in a workbook
- Need some macro
- How to identify the last thursday of any month
- Onkey method to call Label click event
- User-Defined Data Type
- VBA Formatting
- data dependant drop down menu's
- Global variable
- allow only numbers in a textbox1
- Macros for data transfer - one sheet to another
- VBA for conditionally formatting several sheets the same
- Enter to call command Button click event instead of focusing it
- Vlookup and Combo box
- Vlookup Help
- Copy a Cond Format in Excel 2007
- [VBA] Adding data to ListObject fails
- Embarrassed - Where Do I Put This Code?
- Prevent duplicates in a range
- Make code run across multiple sheets
- Pls Help
- Find error, Do action, find another error, do same action and loooooop
- Find error, Do action, find another error, do same action and loooooop
- If statement within a loop
- DOWN key
- How to not get #NUM #N/A Errors using arrays.
- Mandating Form-Field entry depending on Option Button selected
- conditional formating how to change the colour of lots of formula at the same time
- Query table name persists after deletion
- Macro Print/Page breaks
- Multiple Lookups HELP PLEASE
- HELP with Complex formula to derive MAX value in column based on multiple conditions.
- alpha numeric check in a cell
- Copying a Formula down - increasing letters
- Populate data from userform to excelsheet
- multiple validation help
- Change Connection.OLEDBConnection.CommandText
- VLOOKUP looking for +/- differences
- How to delete Sheets?
- Macro to consolidate 20 workbook sheets into one sheet.
- Trim text with VBA
- Returning SQL Error Codes back into Excel
- For each X, repeat Y times
- My first post ! Formula problem
- filter checkbox inside listbox
- Forumla to Copy multiple Cells
- Between Dates issue
- Need a SUM function with a formula
- finding the rightmost zero
- Drop Down List Box Sub Menu
- Using a temporary list and searching for entries
- IF - Colour Cell
- SUMPRODUCT using AND + OR
- Building data base
- Double click Copy / Paste to Website
- generate unique identifier with duplicates
- Excel 2010: Loss of Legend/Axis data
- User input - Query Box - Dialogue Box
- Action on insert/deleting rows
- Macro to Check For Duplicates in multiple columns
- run time error fix
- Excel vba Shapes.addshapes
- Transferring cell values from worksheet to another
- VBA code for summing an already selected range of cells
- Countif for two text criteria
- A stable custom KeyPres event for worksheet cells
- Macro help required
- Macro help required (Urgent)
- timeline
- Excel Extracting Dates
- sumif with multiple criteria
- Easy formula request
- Can I specify a margin of difference when comparing cells?
- Applying a loop to part of a macro
- Tooltip Adjustment: Please Confirm this information is Accurate: Photo Popup with External Link Through Comments
- Cannot change date format
- Last used index in an array
- Looking and replace value in a column.
- sorting many worksheets
- Hide Row based on, if condition formatting = True ?
- If, ElseIf, End If Problem
- help defining a trade rule in excel!!
- Changing Colors
- Getting rid of #DIV/0!
- using vba to extract characters within a string
- Macro To Add 'FA'
- Formula to count filtered cell with "0"
- VBA to count data and echo into another cell
- Loop to condense code
- if help
- Concatenate If...
- Search all sheets in workbook
- Code does not work
- Lookup tied to a maximum sum value
- multiple criteria sumif
- Worksheet change event
- Worksheet change value, monitoring multiple cells against a list
- Email attachments using macro
- Hide/Unhide check box macro
- Excel VB Looping and e-mailinh
- Whats wrong with this code?
- Run-time error '3251':
- Pivot Table
- Dynamic named ranges and countif
- Help with pivoting a table
- Copy Rows based upon Month
- Autofill until column (dynamic) is empty
- macro help...
- VBA - Loop through Columns
- Data Arranging
- Refreshing the desktop
- Select random cells from range and copy to sheet 2
- Import if font is a certain color & vlookup
- Listing columns with multiple data
- Trying to sort strings in two-dimensional array VBA
- Page Break Problem
- Macro not working in 2007
- Consolidating text ranges
- Pulling Info from Filename into Cell
- hide macros
- Re-jigging data help
- excel file use by multi user same time
- Use VBA to update Pivot filter and record result
- Reporting Outlook Distribution List Members to a Spreadsheet
- How to select a range of rows from the current cell?
- Sum Data with Column & Row Conditions
- Why is this inconsistent - referencing a cell in multiple worksheets?
- macro for put data from other excel file
- VBA Data Connection Help
- combo box with date that changes multiple pivot tables
- conditional formatting based on other cell (over multiple cells)
- Negative hh:mm to Decimal format
- Error 400 Appears and Then Goes Away On Its Own
- Network Days Calculation
- Date format
- calling JAVASCRIPT form to VBA
- Goal Attainment Formula
- Price / Volume / Mix Calculation
- Sum formula based on additional rows inserted.
- save xml file to gcode
- VB Code to save as XML Spreadsheet
- =if(iserror(lookup(9.99999999999999e+307
- Simplify this checkbox code
- Remove First Digits From Column?
- problem with replace
- Error 400
- Puzzling IF Statement
- Finding like data in other workbook
- adjust macro for colors other than Excel 56 index colors
- pivot table dates to months
- Replacing leading zeros with space
- Multiple Dates in a Cell
- 5 Weeks in a Month Not 4
- Referencing named ranges in procedures- excel2007
- Copy from one named range to another
- Checking for words and multiplying by a cell
- Which video would you recommend for my issue?
- refreshing a querytable connection on opening a worksheet VBA
- Double Vlookup
- VBA - how to use a cell value to filter a PivotTable with a macro
- Rename excel files in a folder
- Select Case Question...
- Possible to add 'ISNA' to =IF(ISERROR(VLOOKUP string?
- Making a graph to track attendance
- Worksheet change event
- return max date not working correctly
- Hiding rows with a macro
- mp3 attachment to cell/hyperlink
- Export File to .xml?
- Exporting formula from Crystal to Excel
- can a userform be a child object of a chart
- Slight change of formula
- If/Then using dates
- csv opens in one column on new computer
- Looping and offset
- Macro For Deleting Rows When Certain Number/Text Appears In Certain Cell
- Unable to resolve $0.00 from being displayed
- Save Worksheet based on Form Selections and Replace existing copies
- Formatted Scatter Plot
- INT Function Usage
- Sum Product perhaps?
- save Excel files ast gcode type files??
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.