View Full Version : Excel Questions
- select top 5 results
- Load XML data into XLS
- Summarizing open workbooks
- Summing columsn in different sheets
- help with separate Data
- Formula to return "Month"
- display more than value based on one value in excel
- If Function help
- Pointer Variable....
- Redim Array....
- amending outlook calender with excel import
- VB Password
- Could anyone help on this VBA code?
- Help Help me the copy and paste
- Formula help
- Excel formula that uses
- Copying and pasting only "Non-Hidden" Values
- pivot table and crosstab
- Microsoft Query - subquery alias
- Stupid Question maybe? Calling function from function
- How to Concatenate Bulk Text
- Split in excel
- Turning multiple columns into one list
- Third Quartile
- Sort function Excel 2007
- VBA Charts
- Hyperlinks in two sheets
- simple if question
- formula to show 1st of previous month
- Retry - I guess Friday PM isn't a good time!
- Pivotable VBA Help
- replacing a number
- How does Excel recognise a blank cell within IF function...
- VBA - Find value
- adjust a lookup function
- VBA if statments / loop
- How to set to 0 if a Pivot table field is missing?
- what is the difference Between "," and ";" in Formula
- Calculating working hours from two dates...also factoring in a working patern
- Can It possible convert CSV files to QBO Files via Excel
- Complete the Vlookup formula in VB
- Multiple Look Up?
- Drop down boxes
- formulas to summarise data stored on multiple sheets
- ISERROR Help
- Move Data With Code
- Creating a Search Box in Excel
- Rename using macro/array
- Move vertical page break using VBA
- flexible file name
- Why is this? I canīt use parameters
- Is this a pointless use of an array?
- Pivot Table Help Required
- Combining Conditional Formumla
- Worksheet Change, Get previous cell value
- Selecting next blank cell
- What we mean By ad hoc
- Link Pivot Table to Another Workbook?
- For Next Loop help
- Insert a row for every customer and further calculations
- Detecting and separating Integer
- Insert a blank row and calculations
- Help with Vlookup formula
- Macro Recorder help
- Multiple cell reference
- Last file Saved
- different types of spaces
- COUNTA/COUNTIF with dynamic range in VBA
- Random Draw
- Reducing Digits?
- Save from List
- sorting a list to another sheet with top 10
- Advanced filter with multiple criteria
- Last part of cell getting cut off
- Sync 2 pivot tables
- conditional formatting
- Find last cell when appending from one xls to another
- Need a Hand with Code . .
- Send Email Button
- IF formula?
- Tricky VBA Question
- Format filtered cells only in Excel 2007
- Conditional formatting on multiple ranges
- inherited old spreadsheet - xlm?
- csv data download question
- Excel/Powerpoint
- Excel multiply if's
- Adding a shaded area to an X-Y plot
- Autofilter with 2 criteria in userform
- Easy time formatting question for pros, hard for me.
- Really complex Matching and looking up
- Lookup
- recognising data entries by font colour?
- Count if value is greater than 11 but less than 20
- semi advanced macro help
- Protecting Sheets
- Error when Reusing Macro
- How do i Make a Matrix from 3 Columns of data?????
- VBA question
- Copy groups
- What to do if I have too many criteria in writing a VBA code???
- VBA - Make the order of fitting polynomial variable
- Produce Custom Error Msg when Cell is blank, or contains default values
- Formula to count # of specified chars in a range
- drop down list
- Subtracting Dates
- Is this a vlookup, or something else?
- Find text string within another text string
- Save as to set location & cell ref
- Find text string within another string
- A question about invoices
- vba removing menu
- Removing Duplicate Records with an '
- Find matching cell
- COUNTIF over multiple Sheets and Multiple Ranges
- VBA Argument Programming
- Download Files from Internet from Excel
- AAARRGGGHGH - VBA Help required!!!
- - before data
- matching information..
- How to color the cells to the left of activecell
- Page Set up for multiple pages using a macro
- Excel & HTML & Queries
- Custom formatting replaced by Special formatting
- VBA Question
- Excel Resources
- Formula Problem
- Hyperlink to specific sheet in EXCEL
- Yes/No option
- Directory Browser
- Pivot Table Data - Two Columns
- Autofill a column of variable length?
- Freeze Panes/Shared Workbooks
- finding the number that is used the most
- Display Range of Values based on user input
- Combine Pivot Tables
- Index and Match question
- Time
- Can you determine if hyperlink points to empty folder
- Syntax to select a block of data
- Linking between worksheets help
- Require cell entries before macro button is visible
- error (unable to get the insert property of the picture class
- Macro works when I step through it, but not at full speed
- Different text properties in same combobox?
- 03 vs 07 Application CopyHere
- A little help please
- Sequential workbook access
- Macros wont work anymore....
- Empty Row Between Pivot Table Field Values
- How to split single text cell into multiple rows, using a comma delimiter?
- sum every other column
- Excel unblock
- Excel Question
- Consolidate VBA Pivot Creation Code
- Word table coversion to excel
- Sum 4 cells in separate rows, then skip row and repeat
- Calendar Control returns dates in different formats
- 5 Minute Time Out on my query
- Please help!!!! Emergency
- Disable Macros in VBA
- Compare, and then get the text value
- Macros to control Java application
- Heirarchy for multiple sorts
- Need To Convert 2007 Formula to 2003
- advanced type of mid
- How Do You Lock Certain Cells
- How Do You Lock Certain Cells
- IF/AND VBA problem
- How to Combine Graphs
- Foot and inches
- Need help with large lookup table
- SUMIF based upon text condition
- Row numbering with insert
- change a chart source on worksheet_Change
- Conditional formulas
- counting strings of zero cells in between whole numbers
- Quick & Easy changing of Code?
- Using VBA to concatenate two columns
- Lookup help!
- I select some data no a different sheet and I don't want that sheet to display
- Why does find work for text, but not dates?
- Hyperlink To Cell With Same Value On A Different Worksheet, Different Column
- Excel and Access
- SUMIF based upon text condition
- Reminder code picking wrong dates.
- Worksheet Password Problems in Excel 2007
- TIME verification problem
- is there a simpler formula?
- using excel, with a userform open
- VBA: close a workbook and DON'T save changes
- Populate various data from multiple spreadsheets
- VBA Form - Visible
- <---[deleting the space]---> Before Words in a List
- I broke it - and I cant see why. ( macro )
- Comparing values & returning smallest one
- CommandBox code
- Need help on Workbook_SheetChange event
- on cell click, text will be put into cell.....
- Command Button
- Extracting surname from within cell
- Help please: Checking multiple column data across two worksheets and combining them into one
- Formula for payroll, possible?
- 1000 separator in textbox
- Can conditional sum calculate 2 different values from one cell?
- How to use Application.WorksheetFunction to generate a random number in a cell?
- add a marker to a timeline chart
- Lookup Next Highest Value
- Find the previous month names by minusing a number
- 3 dimensional sumif
- IF/THEN Sum Errors
- Matching Sales / Costs data by Model Code
- Hyperlink and Indirect (Named Range)
- Multiple worksheet entry
- Date
- Import fixed width text file into Excel
- User Form & List Box combo with restricted access to different data
- run a macro on a fixed time
- return file path
- How to get the original location of a data
- Using a standard Outlook signature with VBA
- #DIV/0 error in Pivot Table
- Calculating date and hours
- Open Website and save as
- make image appear in multiple cells?
- Count codes with frequency in the same column
- cond formatting & todays date?
- Auto save document VBA
- copying multiple rows from multiple sheets onto master sheet
- #VALUE! Help
- Only Allow Numeric Values in Cell
- Advanced Filter using a dynamic Date
- Copy dynamic data range
- IFERROR Function - Help Please
- Counting unique numbers in a column
- Open access database from excel 2007
- Application.EnableEvents best practice
- coding without activate
- SUMPRODUCT help
- ComboBox Question
- help! Convert weeknumer to date 15 years later
- How do to Count Number of Days Based Off Todays Date
- Using Insert instead of Copy
- Copying Conditional Formatting
- Pasting multidimensional array to worksheet
- Weighted Average + Lookup?
- Can you AVERAGE the results of a SUMPRODUCT
- tab delimited files and lsitboxes - not loading correctly.
- advice on chart
- VBA help please...
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.