View Full Version : Excel Questions
- What-If Analysis purposes
- Why developers not include the calendar in the program of excel?
- Find / Search Help
- Holiday Planner / Long Service
- Find duplicates and extract unique records
- Combining 2 cells to create a formula
- Weighted Return
- VBA - Open workbook - Which user has already opened it?
- Add space in cell
- Conditional formatting - range
- Data validation - Auto complete
- Help needed referencing a variable workbook in a VLookUp
- insert a column every 2nd, 3rd or 4th column
- Alternate result
- Applying a formula to a column except cells next to a populated cell
- Search Matching 2 keys
- sort and filter
- VBA Code to Hide Rows Dependent on Selection?
- How do I format chart legend colour so they stay consistent?
- Code and message box if Number is Negative
- Copying columns
- Mailing each worksheet in a Workbook
- average of non adjacent cells excluding blanks
- Compare new and old value of cell with Worksheet_Change sub
- =Row(Indirect())
- COUNTA Formula and INSERT Function Help!
- subtotals
- Delete row
- Change font size in cell depending on string length
- How to complie tabs from different workbook's to a single workbook?
- Extracting text from a string
- Saving As to more than one spreadsheet
- Hide Rows with #N/A error
- Text to columns converts data to dates
- Match 2 row by each cell and highlight
- Row overriden
- Sum of hours, converted to values
- Drop Down Box
- Select Worksheets by name to omit from Sub
- Blibk/Flash Cell based on specific word
- Very bizarre cell protection issue
- How to do a VLOOKUP with 1 criteria
- Macro for clubbing several sheet into one sheet
- macro help
- Return the Column Number for 1st non-blank cell
- Negative/Zero Values Display As #
- Using OR statements in Conditional formatting
- Negative/Zero Value Displays As #
- Excel 2007 File Protection While Enabling Sorting, etc.
- Excel - Embed object into protected sheet
- Sum cell to total
- how to avoid empty cells in excel when graphing
- Add values for each day
- Amend Macro help
- CONCATENATE forumla
- Code to check if a revese entry is already on sheet
- VBA to open, rename, close files in directory
- Dependent dropdown problem
- Find Criteria And Copy Column
- help with if/iserr/find statements in excel
- Macro to hide all but 3 sheets on close
- How to create a button to auto copy filtered data from a master sheet to other sheets?
- #Value!
- Filling Word Text using Excel datas
- Help breaking cells text into 2 different cells
- Copy & Paste
- Data range for graphs
- Macro to send each worksheet in mail attachment
- Adding values
- if less than 6 characters add a 0
- Undo function causing errors
- Invalid Procedure? Importing Text...
- Vlookup? for missing data
- Tried VLOOKUP - But Need Macro
- Macro to write paragraphs in email
- Need help building a search macro
- Excel not changing cell references when I insert a row and I need it to.
- Count Number of Time Value Occurs in List + Multiple Workbooks - Tricky!
- Total Mining
- Making sure that a sheet is open
- Windows 7 Active X component cant create object
- VLOOKUP Question
- VB Code for data removal from a group of cells when data is entered in another group of cells
- Code to keep data from being entered in a cell if the data ABOVE that cell matches a certain criteria
- VLOOKUP not finding correct data.
- Conditional formation between sheet1 and sheet2
- Formula to pick up new added value
- easy COUNTIF question
- Macro to input data to another sheet
- COUNTIF and INDIRECT Formula Problem
- Hyperlink Help VBA
- Graphs - Vertical bands in background
- vba for error
- Help needed with insurance commission calculator using Vlookup
- Rebase to 100
- copy and paste macro
- Multiple Dropdown list
- BORDER Formatting When Sorting Data
- Number Extraction
- Create batches of 500 records CSVs
- error message
- Mailing from worksheet
- Formula Needed Please
- Image vlookups without multiple choice
- Constantly Running Macro
- Check both Columns
- Extracting numbers (Coordinates) from string
- Auto Group of rows
- macro to change cell value
- Append Data Multiple sheets
- Track Changes with PivotTables
- Get rid of #VALUE!, need blank cell
- Need help on IF formula.......
- Lookup VBA
- Conditional Formating several sheets
- progress bar
- macro conver text to numbers
- Very tough weighted average/logic problem
- AutoFill
- Protecting cells
- Conditional Format for cell not equal to row above
- Averaging to Ignore Zeros
- SaveAS Command to overwrites a Excel File
- Excel/Access
- Macro Sumif logic error
- need a macro
- link modul to worksheet
- Multiselect listboxes
- Halt VBA Code while Data Query running
- VBA, multiple "not equal to" statements using "OR"
- Image insertion
- VBA Sorting using Variables instead of Cell References
- need a macro to goto last row and type
- the document has been modified. Do you want to save
- Excel 2010 Query Tables
- Mulitple worksheet pivotting error handling
- delete duplicate numbers from a cell
- Ordering
- List entry linked to option button
- Getting a sheet to show as the desktop
- Pivot Wizard Creation
- kind of sumproduct
- auto copy data from one sheet to another within a workbook
- Formula Help
- grab a column of data and paste it into another spreadsheet
- Problems linking cells from one workbook to another
- VBA Web Queries - Unique URLs
- Font Color Macro - Help Needed
- Intersect instead of loop
- Referring to #N/A
- Index Match Error
- VBA to Save As with current date
- Opposite formula of a lastname, first name concatenate
- Protect worksheet
- Add/Delete XP scheduled task
- Help to automate conversion of comma separated data file to XLSX
- Transfer format from one sheet to another
- Formula help
- Unique sorted list
- Changing the properties of a commandbutton
- Ending plot for a line graph
- Populating function
- linking to other worksheets
- FORMULA HELP: 3 Date Scenarios X<DATE, X> But < DATE, X>DATE
- formula works fine except in a couple of cells
- linear interpolation
- Time Stamp Issue
- Insert a row
- Question about Using Counter to Designate a Row Number
- Formula for adding a value to cells
- Retrieving values from different workbooks
- Opening and copying from another Excel file
- Wildcard error
- Value translation from one sheet to another
- Subtotalling contiguous numbers in a dataset
- Delete Rows based on multiple criteria
- Pivots in 2007 vs. Pivots in 2010
- autoscroll macro
- Make task bar icon show document name first?
- Format to allow date/number to span several cells?
- Search internet for website url's of companies listed in Excel sheet
- Subtract time to create minutes
- Delete rows 146 - 65,500
- mkdir problem
- Number of Days Between two dates
- Formula for last cell with data in column using line graph
- Active Chart Change Name
- Database info into VBA range or array
- Data disappears after conversion from Excel 2007 to Excel 2010
- Run Macro in Another Workbook - Syntax Issue
- Hyperlinks
- Autoshapes linked to cells not updating
- Insert Worksheet Menu is gone
- stacking columns in excel
- File extensions hidden vs. visible
- Macro To Look At Date And Remove Row
- Custom Chart Axis in Excel 2007
- Macro to paste and add title to it
- Pivot Table formatting
- Codes stop working?????
- VBA macro to move subtotal headings to top of section, more
- Formula Stops BV Code From Working
- Deleting everything after the first space in a cell
- #value! Error
- InputBox Problem
- Function Assistance
- Combine Two Worksheet_Change Macros
- Why does code need On Error Resume Next?
- Double "If" statement question
- Variation - huge database
- Run Macro in Another Workbook - Syntax Issue
- its been a while
- Remove VBA password BEFORE opening file?
- Selection pane doesn't list all objects
- Userform: Lock Position, Adapt Screen Size, Disable Close Button - Close but no cigar... help?
- Is there a way to find last empty cell from the name range?
- Returning a Rank within an array in VBA
- Transpose data?
- Macro to insert a row above any row that is = to 1
- Contact list duplicates
- Calculate trade Profit/Loss
- Data Validation over my network
- Question about connecting/locking cells
- Calculating Total of either highlighted cells, or cells with activated conditional formatting
- Update worksheets after current month
- Excel Formula Answer in Sheet 2
- GetOpenFilename for Excel 2007 files
- XLS TO XLSX Convertor
- Excel vba to minimize all windows
- Adapting array formula to detect an error
- Can "Then GOTO" in VBA be volatile or subjective?
- Comparing Two Columns
- Compare A List of Names in Two Workbooks w/ an Exception
- VBA to open Save As Dialog window
- Active Range with Variable Parameter
- Workbook linked to other data soures??
- download data from internet
- overtime calculation with different rate of pay
- Add rounding to formulas
- Get text to the right
- filtering for specific values of a pair of keys in a pivot table
- find row and delete rest of the rows.
- VB Editer / Macro Editer In MAC 2011 EXCEL
- Add value in one cell to another and copy row to blank line
- Macro to summarise data
- Finding a string and copying cells relative to its position
- Amortization schedule - calculates interest rate
- VBA - Workbook_Sheetchange Question
- Insert a new row at each change in an order number
- Scroll bar in bottom right is very small, want to return regular size
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.