View Full Version : Excel Questions
- Extract data from multiple spreadsheets
- Quickly remove all $ references from long formulas
- activeworkbook memory leak
- PDF to Excel
- Perform a function on a cell comment. Can it be done?
- Identifying task resource conflict
- How do i prevent problems occuring on a large, shared excel spreadsheet???
- Progress bar wihile macros are running
- Excel Formulas
- conditional formatting question!!
- Resume Next after error
- select specific cell from a range
- date extraction using left & find
- Pivot tables - multiple consolidation ranges
- auto populating a range of cells in a column
- Excel error
- PDF to Excel Converter
- IF THEN formula
- Creating a trendline excluding some data?
- Text to Excel
- Automatically append a graph when a cell changes and keep the history
- Recode Variables
- populate a range based on criteria
- Run time error 9: help with my code
- Shared workbook issues - Begging for general advice!!
- Time Covertion Problem
- Save As .xlsm ONLY
- 'dates' in excel / text to columns
- Recursive DIR Function and ZIP Files
- Understanding the event sheet
- Including 2 macros in the one sheet
- Automatic Email sending from Excel
- compilation of several codes in one single code
- quick question
- Quick question, please!
- Quicky: Help with 'Cells'
- Excel 07 Linking Issues upon conversion from Excel 2003 or below
- Conditional Formatting
- Create Hyperlink Query Error
- VBA/macro to collate data, what have i done wrong?!?!
- Timekeeping Across a Network
- vb 6.0 database question
- Resize
- Vlookup against SQL database
- Pull data from excel files into master file by row
- Shade entire row when cell selected
- Vlookup showing wrong results
- How to convert a PDF file into an Excel file?
- Using "Next" within an If statement
- VBA to change cell format query
- Hyperlink to attach file
- Importing an Access Database to Excel
- equals last one on a list
- Display cell info somewhere else when selecting a cell
- Highlight specific cells conflict
- Help with lookups and searches required.
- Formatting Labels!!
- Quick Listbox question--noob!
- Data Transformation
- Global tab home setting
- Sum the next "X" columns
- Find a phrase and insert text in a word document
- Beginner Question : Macro Code to Link Workbooks
- print scaling
- Multiple criteria List data validation
- Macro to copy data from multiple files
- Date lies between
- Folder size macro reaches a max (?) then crashes
- margins
- Need help with formula
- Making a Dynamic List from a Pivot Table
- Calculate the number of working days between two dates - as long as they occur within the past year
- Update value
- Userform entry to determine autofilter criteria
- Formula with IF statements
- Macro Help: Separate lines of one sheet to several sheets
- Conditional formatting, formula for the top 5 negative numbers for a row.
- Need Help with 3 Variables search.
- Insert File Seperators and Spaces for corret path to hyperlink
- Vlookup
- Formula to remove a character from several cells
- copy/paste range
- Monthly investment - calculate total invested for a given date
- Event if number ends in 3,6 or 9
- Little VBA help
- Loop statement giving Type Mismatch
- Please help locating source of Excel error!
- Calculate % change between values in 2 cells
- Eventdriven XML Export
- Hello All / Quick query...
- Error: Duplicate values in the index
- Referencing Columns to Rows
- Simple question
- Pivot Table Default - Sum Function
- Give cell value based on Today's Date....
- VLOOKUP Issue, HELP NEEDED FAST!
- VBA - Admin mode
- VBA DTPicker, and assigning columns
- Multi-Wookbook Macro
- If cell value = Variable name?
- Excel 2007 to Excel 2003 Compatibility Checker
- Small Changes
- Tracking Highest Data Point
- Vlookup question...
- VBA - Show Outlook Window
- Macro help
- Tricky formula
- need a formula
- Compounded interest in retirement calculator
- Range Values Not Updating
- Custom Function: Finding "Occurrence #"
- Looking Up Multiple Conditions and Returning a Date?
- Macro Loop
- Auto-Generate Number in Sequence
- Need PDF of 2 worksheets on 1 if possible
- VBA Code - Add To Range If Unique Value
- VBA Copying from text file to Excel sheet
- Sum Lookup Problem
- Excel 2003 vs 2007 formatting changes when printed
- Need help calculating time based on multiple scenarios
- Need help ASAP,pivot table or best option for data summary
- One to One matches for Arrays
- Macro find only present folder and rename it
- Date format problem
- Excel Text Box havoc!
- MACRO to launch on cell value
- between times
- Input box for criteria in autofilter
- Pivot tables, excel 2007: Unable to change all data fields form sum to average at the same time
- Message Box Help
- Macro to create files from a masterfile
- How to call macro located in another workbook?
- Max and Array Question
- VBA to find seccond or third etc. blank cell
- Disable copy on locked cells
- Bar graph driving me buts
- Converting numbers to dates
- Listbox - Hidden Column Causing Runtime Error '91'
- Macro/WBA for Word & Excel Mailmerge (2007)
- NumberFormat property of PivotField class
- Pivoting multiple colums to value rows
- Selecting cells that spreadsheet users can't access
- How to take out a range from another?
- formula help
- Delete or disable a macro button?
- SUMIF Help
- Advanced filter with two criteria (AND not OR)
- Formula/VBA to move rows if a match is found
- Please help! Need to tab inbetween control toolbox text boxes
- #N/A and trying to use SUM
- Erroneous Computation. How Possible?
- Automatically rename sheet to a date in that sheet
- Macro help
- macro to copy paste
- Copying Data from one Workshet to another using IF formula.
- =SUMIF question
- Vlookup with Sourcelist in VBA
- inserting Picture From File.
- Thermometer
- Formulas won't expand when database increases
- If statemet checking for Duplicates
- Formula's across multiple worksheets
- Sumproduct dilema
- Shared Work Book : Question
- Footing numbers - Accounting
- sumif unexpected results
- Help with a Formula
- copying rows into columns with a condition
- Another VLOOKUP question...
- VBA, Run-time error '424' object required, Inputbox Cancel
- Can't copy Formulas from one workbook to another
- Change Chart Sheet Name in VBA
- Changing cell colors as determined by a variable
- Autofill formulas
- Copying cells creates multiple conditional format entries
- dynamic average
- numbers importing into excel wrong
- Formatting Time
- comparing 2 columns of numbers... subtle difference
- Writing Macros in VBA
- complicated P&L Table How to convert sample reporting format
- Column Chart Question
- IF Statements
- need to be able to include text in data array and still average the data
- autofill formula in variable length col- need help fixing
- ?Dropdown Quandary?
- Changing the default settings on excel for pivot tables
- Converting Feet and Inches into Inches then convert to barrels of fluid
- Excel calendar
- Printing out formulas/calculations with the spreadsheet results.
- Get name of named range from value of cell
- Slow arithmetic -- can it be done faster?
- Advanced Email Code for sending specific text within Excel
- need macro for pivot table to auto select the range
- make my formula simpler
- symbol or character in Filename to stand for anything
- If combined with Sumproduct
- Export from EXCEL to CSV file
- Cell References
- Multiple If Conditions
- vba formula
- May be Countif and Sumif
- Excel regex
- Verifying range of bytes
- Problem with vba code with For Each Next
- Override conditional formatting
- Find & Replace through VBA
- display data from excel sheet on click of command button
- Gridlines in double X-axis
- Find and copy all duplicates
- IF function
- Create a go-to or look up search
- Converting filepath to UNC
- lookup range nested if ???????
- Displaying small and large values using a histogram
- "Enable Macro option button" disabled in Excel 2007
- I have killed Paste
- SUICIDE WATCH! – Copying Formulas
- Count Uniques based on criteria
- Copy Charts Macro works only in ActiveWorkbook
- VBA - Match to search in closed workbook
- how to copy all files name as fast as i can?
- sumif where date is empty or later than today
- Case Sensitive Lookup with isna
- Vlookup
- Updated to 2010 and lost Macros?
- Filter out a word?
- Control text box input
- Compare 2 worksheets of same size and highlight changes in different colour
- Join text, but not always...
- Gamers Dilema ! Count entry's in date range SINCE a date
- Formula to calculate hours
- Understanding How to Use Function “RGB” in VBA 2007
- getting a constant value from a warm link (by RTD)
- How to pass a VARIABLE to UBOUND.
- UDF's array to worksheet
- hiding chart
- If cell is blank cut adjacent cell over and paste
- reg conditional formating
- subscript out of range - when I don't have a range?
- Sorting contiguous blocks of data (VBA)
- Show hidden rows
- Excel adding apostrophes to FormulaR1C1
- Error message when I run 2 macros together
- shortcut key
- New search or find formula needed
- VBA help
- Single Click Combo Validation with Updating Source List
- UserForm Labels, TextBoxes, and ListBoxes pasted to Column B
- Join & Shift Cells left
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.