The discussions
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 ...
Excel date format
Hello, In the Excel sheet I have dates are in the format dd/mm/yyyy. How do I format it to be yyyymmdd ? . Your quick responce will be much ...
Add/remove month button for chart.
SolvedHello, My chart receives data from columns. Each column is a month. Now I want to create two buttons: First button to add a month and another...
I forget my memory password
Hello, i have nokia 5130 expressmusic mobile phone with 2 GB micro sd memory card .ihave forgot the password of memory card can any body tell me the...
Delete allowediteranges by vba
SolvedDear All, Can some-body help me to correct the following code: Private Sub CommandButton1_Click() Dim WS As Worksheet Dim aer As AllowEditRang...
Delete allowediterange by vba command
SolvedDear All, Can anyone help me to correct the following code: Private Sub CommandButton1_Click() Dim WS As Worksheet Dim aer As AllowEditRange...
Excel conditional formatting rows to columns
SolvedHello, I have a data set that looks like: A B 1 20 2 21 3 21 4 03 1 19 2 34 3 23 4 25 1 23 2...
Skip cell
ClosedHello, i need a help to solve this problem if a1=1 then skip the a2 cell and goto a3 cell autometically. any body help me Configuration: ...
Keyboard shortcut
Hello, what will be the keyboard shortcuts for the followings: 1. Change font color 2. Change background color 3. Merge cell Please help
Help about macro copy and paste
SolvedHello, Just want to seek help to anyone about my problem about copying and paste multple raw and column thru new sheet also with designated raw an...
Copy to first open cell in rowb/sheet 2
SolvedHello, Thanks for trying to help! I have a sheet as shown below. We do sales every day and would like the values/ estimates and sales that have...
Memory card password remove
Hello, i have a micro sd card in my nokia 2700-classic mobile phone it is password protected and I forgot the password please help me....... C...
Combination from .xls using unique identifier
Hello, I have 2 worksheets each with employee information. 1 has all new employees in a time period, and the other contains their personal detai...
Seperate data based on condition
Hi, I am trying to seperate data based on a condition.The data looks like below COLA BY TRANSFER-NEFT HDFC00010971097HF110...
Excel time clock spreadsheet
Hello, Can somone please try to help me? I have a Finger Print Time Clock. I am exporting the data into Excel, that looks like the first to rows, i am...
Formula
Hello, In Cell A3 There Is 1/2 In Cell A4 There Is 10/20 In Cell A5 There Is 100/200 Now I Want To Add Left Side Data And Right Side Data I...
Formula
Hello, In Cell A3 Dr. is written In cell B3 Name of Doctor is written. Now I want to paste the both the text written in A3 & B3 in C3. Can it ...
How to print excel data in form in excel 2003
Hello, I have lots of data in a excel sheet I want to print it in a particular form . pls some one help me how to print excel data in ...
Office for mac excel problem
Excel (Office For Mac) When trying to enter a date the letter "y" inserts itself into the date, no matter what format I use. I wish to enter the da...
Highlight all the rows containing same name
Hello, I have an excel in which one of the column(D) has duplicate entries for name.If clicked on a particular name, I want to highlight all t...
Vba - how to replicate the value n times
SolvedHello, I have to write in VBA a macro that allows to replicate value n times (input). Let's say, I have a list one two three and I have to re...
Forget micro sd card password
Hello, I have Nokia 5310. I had set a password for my memory card. Unfortunately I forgot it. Since I don't have any facility to check in C:/...
Help required in ms excel
SolvedHello, I have a list of text strings in rows separated by blank rows. For example: Row 1: Name of the publication Row 2: Authors Row 3: Organiz...
In outlook can i receive mail from one account but send mail from a diffrent acc
ClosedHello, I have an MSN email account and an Gmail account. and use outlook 2007. I have all mail forward from my msn account to my gmail account. N...
Stop duplication in excel worksheets
Hello, I have set up a workbook with multifple worksheets. Each worksheet will have different data. I created each worksheet from a copy of the ...
Check value in a cell vs mid value in another
SolvedHello, I have months in column A in number format. Single digit for the first nine months and double digit for the last 3 months. In column B, I...
How to compare columns of 2 different excel
SolvedI want to compare column named employeeid in two different EXcel sheets and have to retrive the rows with same employeeid ex: sheet1 emp name ...
Word 2007 page numbering. not printing
Hello, i have word 2007. page numbering shows up the entire time. Even when in print preview, but when the page gets printed. No page number is ther...
Vba module with checkboxes to use in excel
Dears, I will be very grateful if some one can help me in the following. I have excel file include 50 sheets for customers, in each sheet I have 2...
Delete data in excel with macro
Hello, plz can u sent coding for following matter: i want to use macro in exl which is find the total word & del all data from right side plz pl...
Mmc recovery password
Hello, I have nokis 2700 classic phone I have 2 gb mmc but I forget its password pls help me its urgent and my mmc can not open show pls enter pas...
Excel if then, create a new column
SolvedHello, I'm trying to write a VBA code, because I have too many factors to create a nested function. I can do it fine if there were less than 7 variab...
Remove my memory card password
Hello, i have a micro SD card for my phone5200NOKIA and its password protected and i forgot password i cant open it from my phone or from my comp...
Conditionnal formatting using macro
Hello, I am trying to create a calendar in excel in which certain days shoulded be marked with a colour. In my excel file, one day is one column ...
Vba to protect sheets & keep some options on
SolvedDears, I will be very grateful if some one can help me. I have excel file include 50 sheets, so I made one sheet that include all the basis info fo...