The discussions
Date -time subtraction..
SolvedHello, hi again,need help i need a macro that will subtract date-time in column A with the Present Date-time and display the value as number of da...
How to get sub strings using delimiter
Solvedhi, i want to copy the part of the string in a particular cell to another sheet. e.g. the string is cell A1 is as below: EVENT_ID NUMBER(10) ...
Memory card password
Hello, pls help me retrieve my memory card password for nokia 5130.Iam highly waiting for your quick respons.Thanks Configuration: / Opera 9....
Change default number format
Hello, I use Excel a lot, but still trip up a lot too! Does anyone out there know if there is a way to change the default number format for all...
Hyperlink of pdf files to excel
Hello, I created hyperlinks of around 100 pdf files which is inside a folder say "Reports" to an excel file. But now I need to change the folder nam...
Conditionally pull data from another list
Dear All, I need help in the following matter urgently, please can anyone help? I have an Excel workbook containing a list of file names in Col...
Pull specific data from excel cell
Hello, Is there a way to pull specific data from one cell and then put that data in multiple cells following the original cell? For example, her...
Word 2003 macro - need save file path code
Hello, I have an awesome little macro that I found on the net that saves pages from a merged doc to individual files. Through my testing of it I've fo...
Highlighted cell on duplicate by multiple cln
SolvedHello, Configuration: Windows 7, MS Office 2007 Kindly help me i stuck in a problem, I have an Excel Sheet which contains Sales Figure an ...
Replacing cell values
SolvedHi, My requirement is to replace the cell values only for a given range. And my range is only the cell values in a given single column. Below is t...
Lost security lock password
SolvedHello, I have a nokia xpress music 5130-C. I set my security lock password as 55555. But now it is not taking the password. I tried the defau...
Create a infopath sheet
Hello, I want to make a file in infopath where we capture the service complains and generate the case id for different customer, every customer ha...
Question of ms office
Hello, dear sir , ms office 2007 Ki file ms office 2003 main kese khulagi. ...
Automatic mail notifier and sender
Hello, can any one help me! my problem is that i need to sent a mail after every hour with a same text but the time is different for the next...
Auto-formatting
Hello, all! I hope for some advice to a problem I've been stuck with to perform manually and getting rather sick of it. May I know if it is poss...
Vba macro help
SolvedHello, I have a report that I am using for a customer of mine that lists there kits in a matrix for me. Once in a while I find an error where a kit...
Vba problem
Hello, thanks foryour attention.infact I am working in a company where I have to enter the data on the daily basis.So sheet2 is changes.bu sheet o...
Vba problem
Hello, In sheet 2 ,I have these fields and in sheet1, I have these plus some more. Order # PO # Item # Description Lease Rate Rental Serial ...
Not able to respond to emails from outlook
Hello, I am having a serious problem responding to my emails from my inbox at outlook express !! Please help this is my business email and it is now a...
Software can not set password
Hello, Software from my drive was deleted by mistake . i copied it from other drive but does not work . I have 500 GB WD essential External HD . w...
Convert numbers to spelling
Hello, I would like know how am I to change the spell number with "ONLY" behind? Example:- 12,600.00 = TWELVE THOUSAND SIX HUNDRED ONLY Tha...
Calculations days hours minutes (dd mm:hh)
Hello, I used office 2003. In excell 2003 i used to format cells to dd hh:mm from dd/mm/yy hh:mm, in order to do calculations and i didn;t have a p...
Using baht() function
Hello, In all system i had used to change the number into text using =baht() function in excel i.e. =baht(a1) a1 = 1234...
How do i use vlookup to compare these numbers
Hello, I don't know how to use Vlookup and I need to compare these two sources of data. Could some please help me with results? Thank you soooo ...
Excel conditional formatting
Hello, I am working with a mid sized spreadsheet (around 500 rows) and Am trying to set the formatting so that if a date is earlier than today, it w...
Conditional formatting using dates
SolvedHello, I have a training spreadsheet which I enter the date someone has undergone training. I want a red, amber, green system to alert me when traini...
Excel 2003 vba-transferring selected data
ClosedHello, I want to create a macro that will take a record (a row (or rows)) that I've already selected into a new sheet (I'll call this spreadsheet ...
Macro for copy data for only two same column
ClosedHello, i want macro for copy data for only two same column in all worksheets to one new worksheet in a workbook , column name like B or F . in all t...
Password remove
SolvedHello, memory card password recovery software from nokia c2-00 Configuration: Windows XP / Safari 535.19
Split mutiple columns in sets of 40
SolvedHello, I have data in 3 columns A,B,C and it goes to 1000 rows, I want it to be splitted in sets of 40 each . Like first 40 then next 40 and so on...
Searching keyword
Hello, I hope I'm clear enough.... I was tasked to create a database of questions and responses in excel. What I'm trying to do is for the user...
Convert a text number col to text column
Hello, Pls could you help me with this. I have a column in number format. this column contains 'NULL' (literally 'NULL' populated) in some of the...
Copying from multiple wb in 1 folder to 1 wb
SolvedHello, You guys have been a great help for all my naive questions, so I have another for you. When it comes to architecting the layout of the cod...
Commission comparison table
Hello, Configuration: Windows 7 / Firefox 11.0 I have a commission table that is configured as such: A B ...
Copy cell and its formating in excel
Hello, One thing that I have not been able to figure out is how to Duplicate a cell and its current Highlighted color. For example: Shee...
How to format date
I copied transactions in Excel using CTRL C and CTRL V. I am trying to format the date e.g. 20/4/2011 to mm/yy (April 11) it is not formating. How d...
Excel 2010 - copy filled in cells
Hello, I have a Workbook that contains a number of worksheets related to estimating costs. On one worksheet I have a several sections that use dro...
Excle formula
SolvedHello, Dear People, I have a small Requirement in Excel. Can you please help me out? Problem Description: Content of Raw Material Prices are...
Excel 2010 date formula conditional question
Hello, I have a date a visa was issued. The visa expires 1 year from that date. I wish to highlight the relevant column in Red to mark that is d...
Forget password...?
SolvedHello, i use floder protect 1.9.2 unfortunately i forget my password so how can i know my password please help me.... Configuration: Windows XP...
Forgotten password for my acer 5315
SolvedHello I have an acer aspire 5315 and broke my charger, I have only just got it back on now and completely forgotten my password. I have treasured pics...
Dell im10-3354dd5 passwords don't work
SolvedHello, Dell inspiron iM10-3354DD5 ,service tag 9FK9QK1,need bios and HDd password . I hv all info on comp, receipt everything I wrote down passwor...
Read pdf on samsung
Hello, please help me how to open pdf on samsung E6112 Configuration: Windows 7 / Safari 535.19
Copy data from one sheet to another
Hello, Dear All, i am running a small business of mine and i want this working, let me tell you first all about it There are 100 people t...
Taking deflaut value as 10 in out put table.
Hello, I want to create a excel sheet in which there will be some column which will get the input in alphabets and numeric values. The last column...
Date format is not changed pivot table
Hello, i had change the date format from 20 May 2011 to May 2011 around 6000 rows but when i use pivot table the date format is not changed it wa...
Retrive value to empty cell
SolvedHello, Hope you can help me... The user select a value from a list (in Column B), then Excel need to find this value from a column (Column D) o...
Need help copying rows please
Hello all, I'm using Excel 2007 and I'm having trouble figuring out a way to move complete rows from one workbook to another. Currently I am utili...
How to calculate number of years between date
Hello, How do you calculate days or years between 2 dates that are in different centuries. Example: birth 4/16/1891 and death 5/23/1924? Conf...
Checking if a worksheet exists
Hello, I'm back again. I'm trying to determine if a worksheet exists in a workbook. If it does, I want to skip to the end of the code and do...
