View Full Version : Excel Questions
- move column into bottom cell of another column
- Addresses Transpose Macro
- Tricky Count of Unhidden Rows
- Problem with autofilter on imported data
- Open File Automatically
- vba to invoke macro
- Excel Unit Conversion
- Last Row Problems in Macros
- Lookup and paste special on multiple sheets
- VBA code runs too slow
- Need a vlookup I think
- help with automating a spreadsheet please!!
- The last used cell in column A
- Formula logic
- Got to Cell
- Do not allow printing untill required cells are complete
- Filter doesn't recognize value
- Runtime Error 1004: Hidden Property
- VLOOKUP, If Zero Skip to Next Result
- Help with a complex IF Formula
- Formula based on month for seasonal rates
- Macro to open existing WB, copy/paste into another WB
- Updating a price column from one file to another
- Entering Data into existing excel spread sheet, based on spread sheet data using a user form
- Pausing Macro
- split Excel file into multiple files
- Comments In Excel
- calculate combinations
- Macro to move duplicate rows to another sheet
- why doesn't this range work?
- disable save unless you are in the list
- Recent date
- Getting Emails (or at least subject line) into an excel file, possubly with SharePoint
- Missing VBA Userform Toolbox
- Converting a forumla into a macro function
- Move a row of Date
- VLOOKUP query
- How do I make cell result invisible until there's input
- Save routine message or progress indicator
- Nested If Statements
- Inserting Value of one cell into text of another.
- Disable save and close
- Problem adding hyperlink in VBA
- How to post code
- Conditional formatting errors
- Excel drinking games
- lookup
- Is it possible to define variables for one Macro in a seperate Macro?
- Need to create loop
- Filtered Results
- Excel auto-interprets dates - infuriating!
- MS Excel Macro: Dynamic Graphing using Named ranges
- Need assistance writing what should be an easy code
- Line Breaks on imported data
- USER32 Library
- Macro question
- Dynamically adding/removing rows
- ComboBoxes with shared LinkedCell's and click/change event code on two sheets set calculation to automatic
- Tricky Sum(IF(
- Problem w/ Formulas Updating
- loop problem
- Partial change font colour within cell - VBA
- Save to next available file
- Merging records grouped by variable
- Credit Hours Earned, Required Classes Completed
- Type in a word to make data appear in other cells
- Pasted values have 13 decimal places (instead of 1)
- code help
- Excel Invoice, Complex Forumla
- Excel macro to Transpose Column using VBA
- Multiple series to add in chart using excel vba
- Copy Paste range multiple times
- Dynamic formulas
- Help with date formatting please
- save register user id and password
- Odd question, probably easy answer
- Counting data from columns
- Link to module
- Image code
- How to apply a formula to visible cells only without using subtotal
- If ActiveSheet = Sheets("Matrix") Then
- Message Box Warning
- Reversed rowsource in combobox
- Excel question
- date
- how to save new file based on autofliterd value
- Complex Copy&Paste
- Counting data from columns
- create a button to take me to a certain cell
- Change figures from Column A to B, C..etc.
- How to sum alternative columns in excel... Please Help!
- To SUM dates (exclusive the duplicated ones)
- Autofill
- Listbox-Saving entered data
- Count Autofilter
- Comparison of two columns
- Custom Command bar options not working
- Worksheet_Change - Form Event
- VBA solution - Range?
- Weighted Average
- Insert alphabets into cell containing existing figures simultaneously
- Update Sheet From CSV Problem In Excel 2007
- Reduction of Massive Dataset
- Add special table
- Column navigation by headers
- Formual Help
- open multiple files as defined on sheet?
- Date format incorrectly copied using macro
- converting numbers to text
- vba to get name of series collection point on chart
- macro help needed
- Add Slider/Bar
- Compare 2 sets of 3 columns
- Potential Macro Query!
- macro to import file into specified sheet
- Forced save
- Adding Values Together Based on Business Type
- Toggle Formulabar On/Off
- Finding minimun from lap times
- Quick VBA question
- I have no idea which function would solve my problem...
- save as macro help
- Divorcing Input data from Programming
- Find next empty cell in row - query
- Splitting data into multiple columns
- Open Excel Template and Save
- Simple count formula thats doing my head in.
- Search Names problem
- Autofilter does not work
- Urgent Help Needed with Variable Range
- change cell value depending on current value
- analysing multiple references contained in one text string
- Num Format Issue...??
- Delete spaces from cells
- If function
- How do i kill a Delete prompt in Excel?
- If cell in Column e = B copy next 32 rows to sheet2 then loop
- Reset Internal Sheet Count
- Highlight changes every where
- Excel 03 - Stocktaking theory questions
- if statement that calculates between pecentages
- Probably a very simple thing....
- Weight of Evidence / Information Value
- vlookup
- Colour certain cells in selection
- Ranking Data within Excel
- finding similar records in excel
- Find with array
- Renaming Tab Based on Cell
- Insert File Name
- Folder Path & File Name
- Formula to count the number of calculations within a formula
- apend an access table from excel
- Streamlining Code - applying font changes
- Macro to not delete row if cell contains XX"Total"
- Help with a dynamic macro needed
- Missing Sheet Reference
- location of activex control
- A new day, a new problem... ;P
- array function: {=min(abs(column))}
- Combo Box
- Dealing with Time
- Problem referring to specific cells
- Excel 03 to 07 VBA Execution VERY SLOW...Need Help!!!
- Filename changed when mail recipient sent
- Error
- Parse string out to different cells
- drop down list paste problem? i think
- View data from last page, Row
- help on a formula
- Macro to Insert Row Every 40 Rows
- hiding rows of data
- Have i bitten off more tha i can chew?
- Linked cells lose their colours
- reverse concatenate?
- Preventing a Recursive Call of "SheetPivotTableUpdate"
- Setting .PrintRange using 2 variables
- Will VB mess with my links?
- Will VB mess with my links?
- Help with if statment
- Protect File
- Adding a tolerance figure into conditional formatting
- Calculate % in pivot table
- Find cells containing @
- Update current workbook after updating links
- Conditional Format With Dates
- pie charts
- Graphing Standard Deviation
- Clearig Data when a item changes
- loop is driving me "nuts"
- Automatically changing range in formula
- Probably a simple equation but I am new to excel
- Run Macros while staying on a Main page
- Excel 2007 Pivot Table Calculated Field
- excel help needed
- Code not working after SaveAs
- trouble with a text box
- Passing Array into a function
- Lookup and send data
- Vlookup
- VLOOKUP Function Problem
- Lookups
- Text Formula
- countif with date ranges of indeterminate length
- Can forumulas handle this? Want to display some items on one tab, others on another tab
- IF statement maybe ?
- Solver
- Date Triggered Decay
- Multiple IF statements help needed
- Excel Add-In Errors
- Macro to refresh hidden pivot table
- More hyperlink problems.
- Can you import ".frm" files?
- VBA Formula issue
- Formatting variable of type date to be used in a string
- User Forms - deleting data
- Form Check Box(TRUE/FALSE) Computes Either A or B formula
- Assign a variable to the result of a matrix
- How do i insert a map of North America into an excel sheet?
- Advanced Filter with dates in the criteria
- #VALUE should show full price
- Conditional Formatting
- Conceptual Help
- Position in column
- Markup Calculator
- Create Outlook Meeting Request from Excel
- Formula Help
- Help! Hide a picture using vba?
- Simple code to enter a number in a cell by button not working after copy worksheet
- Deleting Blank Lines After PasteSpecial
- Referencing an equation using vlookup/array
- Unhiding WorkSheets
- Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) Question
- Connection string for query table in loop error
- Select Range with Last Cell in Column with Data
- Another Formula Question
- Count characters in a cell
- Autofilter help
- writing outlook distribution lists through vba
- How do we fix a Column in Sheet 1?
- How to organize data for pivot table
- Converting PDF to XLS
- VLOOKUP To Find Last Match
- Allocate values from a central worksheet to defined worksheets
- Dynamic forumulas using VBA
- Simple Sum & Divide Formula
- Message box after a date is selected
- Unique Item Count with Multiple Criteria in VBA
- combining W-Sheets into one.
- Do I need a Sumif, HLookup, please say it's not a sumproduct
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.