The discussions
Formatting date in excel sheet
Hello, I am working in SAP wher i generate a report which download in excel sheet in dd.mm.yyyy format but i need convert it to mm/dd/yyyy format ...
Conditionally selecting a range of data
Hello, Could you please lend me a hand with conditionally selecting ranges within 2 columns in a excel file using a macro?I am new to writing macr...
To recover a forgotten password of a mobile p
SolvedHello, I have a Samsung GT-S5603 mobile phone. I have forgotten a user password, so I can't open it, now. Please, tell me how to crack this passwo...
Wd default password
Hello, Guys, my WD My Passport Essential has locked itself by creating a password on its own!!! No hints are available, which is another evidence ...
Vba-conditionally selecting and copying data
ClosedHello, I have a file with 5 columns. one with date, time, latitude, longitude and amplitude. I need to conditionally select data from the latitud...
How to copy data from one sheet to another
Hello, I am having a workbook. In sheet 1,m having store name in column A(A2:A9),in column B inventory for soap ranging B2:B9,in column C inventory...
How to get memory card sd password recover
Hello, i forget my memory card password plzzzz tell me how i m rocover the card Configuration: Windows XP / Internet Explorer 8.0
Internet connected but can't browse
ClosedHello, today I saw the 3g modem HUAWEI is connected, antivirus can update database but I can't browse the internet. I trid to delete Uniblue PowerSu...
How to change numeric to words in excel
Hello, I want to convert figures to words in excel. no need to show currency name like dollar example : 67,000 = thirty seven thousand only ...
Conditional copy and paste using macro
Hello, Just want to seek help to anyone about my problem about copying and paste multiple cells from sheet 1 to new sheet hru new sheet also with ...
Memory card password
Hello, i have noika 3110c and i had put a password for the memory card and my card is locked now i have forght the password so if u can help me. ...
Memory card password
Hello, i have noika 3110c and i had put a password for the memory card and now i have forght the password so if u can help me thank you
Match up names in excel or access
ClosedHello, I have a list in excel of of car types in column A and the owners in column B. A lot of owners have multiple cars of the same type making a...
Generating reports using macro in excel2003
Hello, Hello I have a task to be done once on every month-end. I am working in a private bank. I have a file called BaseFile. I need to generate re...
Is there a way to delete all dates in excel
Hello, Is there a way to delete all dates in an excel workbook without deleting the actual cell they are in? For example, I have some cells that s...
Ms office ms outlook
Hello, I have ms office 2010 installed, and I am now trying to install outlook 2010. I have the message that I have to remove office to install out...
Reading an excel and filter data and add.
Hello, I have an excel say Book1.xls. I will have data with 10 columns and 10 rows in it. I will have another sheet in the same excel. I will ha...
Find value between characters in one cell
SolvedHello, I get this report-list of personal information, in text format (TXT) Each area is separated by | Name|Experience|Age|Sex|Location|Contac...
Macros help
SolvedDear Friend i want to convert number to text in excel programme Example : ( 055555 : Zero five Five Five Five Five ) As This Format ...
Transfering data to a new sheet
SolvedI'm running excel 2007 on windows 7, if that's important. I'm trying to find a way to transfer data from a master sheet (or basically sheet 1) to...
Format data in excel for db transaction
SolvedHello, I have a simple question, I have a range of cells with numbers in each cell. I want to add a single quote or apostrophe in the start and end...
Spellnumber
Hello, how to convert number to words, eg. 225 [two hundred twenty five). not in rupees , dollar or cents, only in number, pls reply me
Forgot memory card password
Hello, Hello, sir madam i will forget my kingston memory card 2gb password please help me.
Memory card password
Hello, i have nokia 6303 classic mobile phone with 1 GB micro sd memory card .ihave forgot the password of memory card can any body tell me the meth...
Create macro replace blank cells with counta
Hello, I want to create a macro that will find a blank cell with Counta value of > 0 and delete that entire rows. Configuration: Windows XP / I...
Formula for every 200hrs cycle
SolvedHello, now i'm trying to do a schedule maintenance for one part.the hours for the parts will increase everyday.e.g today 240 hrs,tomorrow 256 hrs....
I'm from sudan need flashplayer plz
Hello, hi i'm from sudan i need flash player but i can't got it can you help me pleas
Getting prompt-name list while entering data
SolvedHello, I have a new question now. I will have traveller /passenger names who travel frequently (or having travelled atleast once by buying tickets...
My tally is not opened
SolvedHello, click the tally icon it shows problem with shortcut, the item tally9.exe that this shortcut refers to has been changed or moved, so this sh...
Find a word in excel
SolvedHello, I have set up a spreadsheet to keep track of my daily workouts. The spread sheet is set up as follows: Column A: Date Column B: Descrip...
Excel macro to copy text and append
SolvedHello, I recorded a macro in Excel where I copied the text from one cell and appended that text to the values in several other cells. The problem...
Using conditional formatting in excel to high
Hello, I want to highlight the row based on cell value. For example. If I put 10 in one cell, it should highlight 10 rows like that. please advise...
Cell reference to locate /store data in excel
SolvedHello, Hello , I am working for a newly started airline agency. I am enclosing my working file (for privacy sake , I have changed names and oth...
Emailing selected cell range using outlook
SolvedHello, Hi, I have one task. I need to email some of my invoices that I prepare on a daily basis. I have a .xls file with some work sheets. I have ...
Comparing two ranges of numbers
SolvedHello Everyone, Let me first say I'm very much an amateur with VBA code, but I have been using examples I have seen online to cobble together ...
Copy row in excel to specific tabs
Hello, I'm not very smart once I get outside of if-then formatting. I have an excel worksheet. It is used to track purchases for different divi...
Excel equation
Dear sir, I shall be much obliged if u solve this equation using excel formula is E = P×r×(1 + r)n/((1 + r)n - 1) (here n is power plz dont read i...
Average above "n" rows in blank row
Hello, I'm working on a dataset of historical price data. The set has dates in column A, and prices in column B. Through a macro I have inserted a...
Copying data from one sheet to another
Hello, Macro newbie here. I'm trying to copy 351 rows of data from one sheet and paste the data to every 14th line on another sheet. Help! DR ...
If statements in excel
Hello, I'm looking for some help with conditional coding in excel. If text is entered in one of eight specified cells, then I would like 1 added t...
If statement in excel looking for text
I have a column with 3 text labels (book, pencil, eraser). I want to create a new column where I can find cells in the original column that have eith...
Locating email server name and port
Hello, I am trying to link my Wisconsin roadrunner email to my new google email. During the set up process, it asks for the server name and the ...
Excel macro help
SolvedHi there, I am getting an error when I try and run the following macro. I am trying to find the value in one worksheet (final) in another worksheet ...
Copy cell content from row with latest date
Hello, please, can somebody help me how to get the copy of data from row which have the latest date to different table on another sheet. Namely I m...
Auto incrementing alphanumeric cell by 1
SolvedHello, I have an alpha numeric cell in excel sheet. for example IND/APR/6734/INV I am using it to give number to the invoce that I generate everyda...
2 sheets compare for differences
Hello, I have excel workbook with sheet1, sheet2 that have same data in column A. I need to find the difference in the 2 sheets. The records tha...
Lost windows password fix gone bad.
SolvedHello, My buddy changed his password on his computer. He forgot said password and tried all day to log in. He asked me for help and I found a progra...
Roman number series (macro)
Hey guys. I need to make macro witch makes series of Roman numbers (Similar to built in excel series- http://i63.photobucket.com/albums/h129/Edds87/...
Macro for printing in ms excel 2007
Hello, I have standardized reports that I create in MS Excel 2007 on a daily basis which must be printed under certain parameters. How do I creat...
Old toshiba 3480ct admin password
SolvedHey guys, I have an old Toshiba Portégé 3480CT and need to get past the admin password. I have no idea who would know it, it's been in our office ...
