Creating Shortcut key to merge cells Creating Shortcut key to merge cells Issue Solution Note Issue If there a shortcut to be pressed on the keyboard to merge cells in... Nov 6, 2009Office Software > Excel |
Excel Comparing cell A1 to entire A column in Sheet 2 Excel Comparing cell A1 to entire A column in Sheet 2 Issue Solution Note Issue I have been trying to compare sheet1 A2 to sheet2 A2... Nov 6, 2009Office Software > Excel |
Excel - IF formulas for Printing and Calculation Excel - IF formulas for Printing and Calculation Issue Solution Note Issue I am trying to get Excel IF formulas to print a text and... Nov 6, 2009Office Software > Excel |
Excel Macro for copy & paste selected range Excel Macro for copy & paste selected range Issue Solution Note Issue I have a summary of data by month in one sheet and the raw data... Nov 6, 2009Office Software > Excel |
Excel Total Range of Values Excel Total Range of Values Issue Solution Note Issue I'm trying to get a range of values totalled. I have one set of columns, lets... Nov 6, 2009Office Software > Excel |
Excel - Tasks to be performed automatically on particular dates Excel - Tasks to be performed automatically on particular dates Issue Solution Note Issue I have a huge spreadsheet and I am constantly... Nov 5, 2009Office Software > Excel |
Excel Macro to detect and hide blank rows Excel Macro to detect and hide blank rows Issue Solution Note Issue I want a macro to unhide about 20 blank rows copy values into the... Nov 5, 2009Office Software > Excel |
[Excel]changing cell formula to text [Excel]changing cell formula to text Issue Solution Notes Issue Consider that I have: In cell A4, it contains a formula... Nov 4, 2009Office Software > Excel |
[Excel]Reset/replace seconds to zero [Excel]Reset/replace seconds to zero Issue Solution Notes Issue I have an Excel 2007 file which has in sheet1 the time people connects... Nov 4, 2009Office Software > Excel |
Copy rows based on a condition Copy rows based on a condition Issue Solution Note Issue How can I have excel copy the entire row of data from worksheet Employee... Nov 4, 2009Office Software > Excel |
Repainting a cell using excel VBA Repainting a cell using excel VBA Issue Solution Note Issue I am writing a code in excel VBA to generate a report.I am totally new to... Nov 4, 2009Office Software > Excel |
How to Create a date from 3 different cells? How to Create a date from 3 different cells? Issue Solution Note Issue In excel I have date spread across 3 cells; 1 with the day (A1),... Nov 3, 2009Office Software > Excel |
How to Create Msg/Popup to notifications in Excel VBA? How to Create Msg/Popup to notifications in Excel VBA? Issue Solution Note Issue I need a Excel VB script to notify/popup a message... Nov 3, 2009Office Software > Excel |
Excel - Send value of cell to target Excel - Send value of cell to target Issue Solution Note Issue Is it possible to send the value of a cell (copy and paste special) to... Nov 2, 2009Office Software > Excel |
Excel How to extract partial data? Excel How to extract partial data? Issue Solution Note Issue I have an Excel spreadsheet that contains around 1500 html links. All... Nov 2, 2009Office Software > Excel |
[Excel]Clear the contents of specific cells. [Excel]Clear the contents of specific cells Issue Solution Notes Issue I have 6 cells with dropdowns list and they are selected each... Nov 2, 2009Office Software > Excel |
[Excel] Countif Formula [Excel] Countif Formula Issue Solution Note Issue I have one excel file in that Column "B" has the "pending or Closed" Status and... Nov 2, 2009Office Software > Excel |
Adding data from one column using another Adding data from one column using another Issue Solution Note Issue I am having a real problem with an Excel formula. I have a... Nov 1, 2009Office Software > Excel |
[Excel 2003] - IF Function using Dates & Text [Excel 2003] - IF Function using Dates & Text Issue Solution Note Issue I'm trying to write a function for a cell which refers to a... Nov 1, 2009Office Software > Excel |
[Excel] Running Macro Automatically [Excel] Running Macro Automatically Issue Solution Issue I have a macro in excel which needs to be run twice a day and I dont even... Nov 1, 2009Office Software > Excel |