View Full Version : Excel Questions
- Code Help Please
- Grouping
- select ranges based on cell criteria
- Copy one cell to the end of a list
- Count Data in last 6months
- Locking Cells
- Summing pairs of rows
- Make Table from Excel
- Vlookup
- how do I delete data that dosent come within a range
- Pull Data for VLookup or If from multiple sheets
- My Head Hurts!!
- pivot table layout question
- Help with same macros in different workbooks
- page number in Excel
- pivot table loses format when rows are grouped
- Trying to delete an object.
- Image backgrounds within cells?
- future date formula
- Paste data into spreadsheet
- In Cell Charting
- SUM of Nested IF
- VBA To Goto Website Form Field
- Populating a UF ComboBox with Info from a Sheet Coulmn
- Hex2dec of a cell
- VBA to return page number of cell or object?
- Password entry text box
- macro to fill color if cell is empty
- Speeding up excel macro
- File Correction
- Saving a sent image as a jpeg
- compare two arrays of different size.
- Linked Workbooks: zero placeholder
- Need Help With Formula
- Changing the userform background color via a checkbox
- Inserting Copied Row and summing newly created range
- Legal acknowledgment before using spreadsheet
- Value Field Settings - Pivot Tables
- Need HELP finishing a project - Managing images by clicking on cell/text ??
- Manual Data Labels
- Form Control Check box - very simple
- Data validation-add list item to dependent validation list
- Count between dates, again
- filter a text string
- Ask before doing
- Merging several worksheets: differentiating lists
- Excel 2003 - Crashes when Close_Workbook macro completes
- Using REPT() to line up in column data
- Is this possible with "The Solver" ?
- adding days to date getting 3/30/00
- Help required on conditional formatting
- Calculate based on last entered data in one of 4 cells
- Play sound if "True" in a range
- Adjust code
- Get Cumulative from a Pivot Table
- Formula Help
- Copy & Paste
- Formula assistance
- Sumproduct
- help debug loop
- Another time formula question
- Vlookup on Variable File Name
- Create a Zero Value if True
- Where I am going wrong?
- Pivot Tables
- No margin while adding items on ListBox1 from cells
- Resize Screen Help!
- Overflow Error
- Why do I get the 13 error
- Search blank row and delete all info above
- Logic Question - Worksheet_Change not triggering
- How to enter stopwatch times
- I don't want a DATE, help
- Error In Sort
- Find error
- Formula help
- Macro to Delete 4 Sheets
- how to sumif multiple columns? Array?
- Formula help
- macro on excel to exicute word mail merge
- Combining Data
- IF, AND, OR - returns incorrect value
- Need to Find multiple instances of a value
- Copy & Paste Values Problem
- any better idea for matching column ??
- Multiple Criteria COUNTIF
- calculate number per hour using total time divided by total number
- Use of Array in For Loop (VBA)
- nothing impossible with enough people!!! or is it?
- Help with IF Formula
- Sumproduct+ Vlookup issue
- How to send a mail to list of employee IDs maintained in an Excel sheet?
- What-If Analysis
- Copy data of a cell from one sheet to another
- any way to simplify this
- Transfer data to another workbook
- Combining digits into one cell
- Paste data in a file withouy opening it
- SaveAs from template
- runtime error 1004
- sum hours by dollars
- Cell comments referencing cells to obtain text to display
- VBA Question
- Simple Copy/Paste??
- Pivot Table - hide rows with 0 total
- Conditional formatting
- auto login if logged out of website code
- Pivot table help
- Copying and renaming links to other worksheets/cells
- Select all sheets then delete
- Macro to loop through files
- Len(Dir( vba script - Not functioning correctly??
- IF formula to show result as NA()
- If statement with conditional formatting
- Pie Chart and N/A ranges
- Sheet name invalid - vb coding
- Simple? add a horizontal line in a chart - I think not!
- Populate Userform combobox
- 58 file already exists - getaround?
- Insert/Delete rows based on selection
- Custom Funtion Color index
- hyperlink
- calculation with if
- Excel Links
- Workbook beforeclose macro
- How to insert value(Result) of Name in VBA
- Selecting Visible Cells only to copy and paste
- Vlookup within a sumproduct?/Double sumproduct
- Count a range coupled with Vlookup
- Grouping Dates in Pivot Tables on 2 sheets
- Formula Help
- Weighted average: how do you use sum product if your data is on different lines.
- sumproduct help
- Can I have a macro open another macro that isn't there at the start.
- Tagging unique IDs to columns
- Conditional Formatting order
- Displaying the date
- Couting Unique values in Columns
- Conditional format to turn other cells red?
- PivotTables on Excel 2000
- Pivot Table Field Names - Keep Field name even if no data
- Count within Date range
- Freezing Rows and Columns
- can anyone help on how to delete data if value =0
- Multiple stacked column
- VBA: Naming Worksheet with Cell Reference
- Cell colour change using VB
- On Error, Reset Program
- Excel 2007 Overlapping bars
- Probably really easy!!
- Why will 2003 macro run in compatibility mode, but not when converted to 2007?
- VB to hide columns based on text box colour
- vlookup function?
- Showing a chart on one sheet to another
- change the chart source based on the cell contains the named range
- search string forumal
- Delete all columns to the right and all rows below given cells
- Code for Index Statement
- Find twelfth from bottom
- Turn off auto filter before save
- Code for Status Update
- DIR function problem
- Grouping Problem
- insert a row using a macro
- Save as PDF in Excel 2007
- help Identifing code line
- SAP export to excel, negative numbers not recognized as numeric values
- Emailing Worksheets to People
- Frustrated! need guidance..
- Alphabet corresponding to the column
- Copy & Paste using a command button
- inserting columns to right of user selected column
- Select Range from an offset position
- formula for credit card statements
- Check for linked Excel-files
- How to make Workbook saved, to prevent message about saving?
- Macro switching between files to copy and paste
- Continuing Trends
- ActiveCell Offset in Loop -- Help
- VBA formula refrence
- Slow Operation wth Option Buttons
- Switching between workbooks
- countdown clock
- Custom User Form for editing database
- Auto Populate
- Read-Write Popup - File Now Available
- How to create Gant chart in Excel 2007
- Double click and single click on a commandbutton?
- vlookup to find format
- Yikes - Help Please . . .Modify Code
- Help!!
- Mouseover Label event
- How to loop through rows backwards
- Duplicates Counting/Summing
- Replacing #N/A message
- matching cells and returning values
- Not printing defined rows/columns if certain cell values=0
- Conditionally Format First Cell based on Values in the Row.
- Dynamic drive selection to update link
- Pivot Table: Calculating a product of two columns?
- Problem ranking formula results when there are #DIV/0! errors in results
- Wait for key press
- Displaying Japanese and Chinese Characters
- Question
- Comparing Two cell-Macro prob..
- Check box in an If/Else statement
- I'm missing something...
- help with code
- I thought this would be easier???
- Urgent Assistance Needed
- Deleting a row
- Clock in VBA
- excel links
- How do I use the SUM function with VLOOKUP? Desperate for help!
- Loop breaks at different points
- function to count numeric values embedded in text
- VBA Run-Time Error 5
- Possible Excel Rounding Error
- 2 columns lookup +
- Pivot table
- Edit UNC Path to Sheet Level
- Move different sheets from different files to one file
- selecting multiple rows in vb code
- No more than 70 page breaks?
- Deleting a workbook
- Macro returns error when used twice
- VBA Question
- Check For Conditional Format
- Relative Forumla Problem When Inserting a Line
- Filling Column Contents
- array help, beginner, real confused
- Print button with preferences on each sheet
- Refresh pivot table after adding additional columns from a DB crashes excel
- String functions and changing font size
- Closing mdb connection
- User form add picture from another sheet
- VBA to navigate in Pivot Table
- Lookup value on .scv
- Last cell of a spreadsheet (easy !)
- Keep userform in view
- Formula needed
- changing chart source data using named data ranges
- VBA to extract text?
- Sum with AND
- Retreiving Blobs/Clobs from MYSQL
- run time error 13 type mismatch ?????
- Importing external data from the web
- Select cells in new blank column from first to last row?
- Application.EnableEvents Help
- Looking up multiple values...
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.