The discussions
Excel
Solvedhi i always make our employee salary in excel. this file is very big. every month I have to put only OVER TIME,WORKING DAY and ABSENT...and i make all...
Sony vaio vgn-tx16gp - bios password
Hello, Dear si r i have a sony viao laptop modal no.. is( pcg-4f9p) vgn-tx 16gp . i have no bios password and no recovery password .. m instoll w...
Can a macro add a number?
SolvedI am working on a excel project where I will be able to click a button and the result would be a number added on another cell. For example, counting a...
Contains & conditional formatting
I am having issues with highlighting certain words in a range of cells containing the phrase "intervention plan". Basically if the cell contains th...
Jen
Configuration: Windows Vista / Firefox 3.5.9 trying to use word, it's asking for a product key, can't locate key. Any suggestions?
Memory card password forgot
In Nokia 2730 having no filemanager... where can I get system file of 'MMCSTORE'? Configuration: Windows 7 / Internet Explorer 8.0
How to convert a numeric value into english w
How to convert a numeric value into English words in Excel Please provide software/or demo. best wishes, Rashid
Copy columns one below another
SolvedConfiguration: Windows XP / Internet Explorer 7.0 hi i have data in the following form a b c d 1 6 11 16 2 7 12 17 3 8 13 18 4 9 14 19 5 10 1...
Combining 2 cells to 1
SolvedHi, I have data like below in two column of excel sheet: 1-Jan | 2004 23-Jul| 2004 12-Feb|2003 ................ ......... Out out require...
Find a word in macro
Dear All, I have a excel sheet, it contains 100 rows value, now I need to find which are the rows has the word "apple", if it has it should return ...
Formulas for 1st and 2nd position in class
Closedi want to know the formulas for the students (20 students) who get the 1st and 2nd position in class Configuration: Windows XP / Internet Explorer...
Master password for advent 8111
i just realized that my computer asks me to enter a password soon after turning it on..no any other option is shown..i have tried almost various butto...
Dont have a password how to get pass that
I WAS GIVENA LAP TOP AND I DONT THE PERSON PASSWORD THAT HAD IT LAST WHAT DO I DO Configuration: Windows XP / Internet Explorer 6.0
How can i remove my password in memory card
Configuration: Windows XP / Firefox 3.6.3 my nokia 5130-c phone was restarted and it corrupted all my files. even my games in applications was also l...
Access reports dont display fully
Hello all, I have recently created a programme for use at work, and it works perfectly, all tested etc on my laptop, but when this is copied over t...
Excel
Example : I have column A' where i am entering a number and this number (given by the user) has to be multiplied by 10 and the value/answer should app...
Pop up reminder of expiry date
ClosedI need to set up pop up reminders in excel that open when the system is switched on (and irrespective of applications running). The reminder needs to ...
Page numbers
my document is only showing page numbers on the first page - please help! Configuration: Windows XP / Internet Explorer 6.0
Counting numbers in a very large poll.
I have a large workbook with numbers that range from 1 to 70. In the example I have attached, from column A to column AV.(I could have as many as 70 c...
Multiple conditional formatting
I have workbook that in column 'CD' contains name of various imports, exports. I would like to make all cells that contain the word imports to be a c...
Nested if statements going wrong
I have a spreadsheet of data I would like to reorganise in a certain way. The current format is: Client ID Client Name Employee Name Role Start D...
Need to find formula to say happy birthday
Configuration: Windows XP / Firefox 3.6.3 i would like to say happy birthday to each of my employees on there spreadsheets in excel 2007. I am hav...
Help excel: click & automatically copy paste
SolvedI need some help Let's say I have 5 different tabs named London, Paris,... Each tab contains different kind of information about the cities: popula...
Macro to allow users to modify?
Can anyone please create a macro that will give access only to few users to allow modifying data in an excelsheet.
Sorting and suming # in excel
Hello Everyone, I need your expertise in this. I want to do the following. In a list I input data consisting of Amounts, Expense Type, and Date...
To read records from excel file and the limit
I am preparing the code to read the records from the excel worksheet and convert the .txt file of that worksheet.. If i run my program than a .txt fi...
Conditions
Dear can you help me out to get "if" results to change colours, to higlight etc,
Ignoring blank cells
I have a formula along the lines of..... =IF((a1=b1),1,0) How can i get the formula to ignore blank cells? Configuration: Windows XP / Interne...
Need help sign on password recovery info
I HAVE A TOSHIBA SATELLITE A200 SERIES AND FORGOT MY FRONT SCREEN SIGN ON PASSWORD CAN ANYONE HELP I HAVE NO RECOVERY DISK OR ANY DISK THAT CAME WITH ...
Excel date and time issue
Hello All, I wanna subtract "12/05/10 08:29:25" from "12/05/10 08:48:31' . Please help me out. Thanks and Regards, Subramanyam T C, Bangalore.
Search and replace macro for microsoft excel
SolvedI have two workbooks with identical setup. item name address 1 address 2 address 3 x 12 34...
Excel macro formula for groups of numbers
I have strings of numbers in a column (n) I need help with a macro that will total the groups with the sum in column (o) right of the last row of the ...
Click a cell and insert a wingding
SolvedIn excel I am wanting to be able to click a cell to insert a Selected wingding from a list. But to also beable to click the cell a second time to cha...
How can i retrieve my emails from outlook bac
Hi, I just started using outlook and it started taking all the emails I had from hotmail and placed it into outlook BUT it did not copy the file --...
Copying specific data selection to new sheets
How can I select entire rows based on a specific value found in a column via a macro when the occurence of the specific value is variable? eg. My ...
Move text from cell to another
Dear all I would like to know if it's possible to move text from cell to another in excel 2007, Example ; I have IN colmun and Out colmun in one s...
Macro to make upper case lettersto lower.....
Please design a macro that will make the Name copied and pasted in all upper case, for example (KATIE) in the cell A1, when I run the macro I want KAT...
Excel 2007 vba #n/a lookup
I have a sheet receiving imported data and sometimes it does not come in correctly so I use Vlookup to verify it against the correct code as part of a...
Hide rows in multiple sheets
Please help me If I have data in range A1:D35 in every sheet of the 20 active sheets, so I want to write a macro to hide all the rows that have a z...
Excel - unique filtering
I have a two columns: Name and Amount. I want to apply a unique filter on the Name and retrieve the Sum of all the repeated Amounts. How do I do this...
Formulas
The formula's on my spreadsheet only calculate after you save it, this only started happening a couple days ago. Not sure what the problem is. Con...
Add cells with other identical attributes
SolvedI'm looking to create a formula which can be copied into other cells that will add numbers in one column, where their attributes in another column are...
Line to reflect a dash if no value
SolvedI am designing a check book registry, and I want the total column to reflect a - if there is no value from the formula. I had it this way in the past...
[excel] pastlink
Hi , could someone please help me with this problem I have . I need to pastlink values from sheet 1 columns A1 and column B1 ,column A2 and column B...
Help with excel data selection
SolvedI would like to take a worksheet and create new worksheets for each specific value in a column. for example, one of my columns is "customer". I want...
Compare values
i want to compare value of k6 to whole column c if one value in column c matches then subtract value in column d corresponding to c with value in l6
How to send an email through an outlook
I need to know please how to send an email message through an outlook thanks
Identify & mark the data
I have the data in 2 columns i.e A & B. In A column amounts are there(both positive & negative values) and in B column invoice no. are there. Every po...
Data entry
how do I take a row of information in one sheet to another sheet just by entering the info in the first column? Configuration: Windows Vista / Inte...
Excel formula problem
Hi there, Was hoping some one out there could help me with an excel formula problem... I have a Table ---- A B C ...
