Hello, I am creating a macro and what i want to to do is to find the word "Tylenol" and then go to the cell beside it and i want to put a formul...
Hello, I have created a calendar in excel, it can update automatically once the year is entered. I have another sheet "Customers" with "customers li...
Hi, Basically I have a document that is 30,000 lines long showing data in 1 second intervals. I would like to delete all the data so that I have in...
Hello, I have salary sheet for different months for different workers. Some of them are not in one month and another new worker are add in new mon...
Dears, I would be very grateful If someone can help me. I have several sheets in one excel file. I need one command button when pressed to set 4...
Hello, dear all, I have an invoice template in the range b6:f57 in one sheet.. I want to select only some cell contents like c17, f17, f 19 , f 32, ...
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 ...
Hello, I have a file with 5 columns. one with date, time, latitude, longitude and amplitude. I need to conditionally select data from the latitud...
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...
Hello, 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...
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 ...
Hello, 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...
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...
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...
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...
Dear Friend i want to convert number to text in excel programme Example : ( 055555 : Zero five Five Five Five Five ) As This Format ...
I'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...
Hello, 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...
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...
Hello, 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...
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...
Hello, 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...
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...
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...
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...
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 ...
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...
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...
Hi 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 ...
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...
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/...
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...
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 ...
Dear All, Can some-body help me to correct the following code: Private Sub CommandButton1_Click() Dim WS As Worksheet Dim aer As AllowEditRang...
Dear All, Can anyone help me to correct the following code: Private Sub CommandButton1_Click() Dim WS As Worksheet Dim aer As AllowEditRange...
Hello, 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...
Hello, 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...
Hello, 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...
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...
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 ...
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...
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...
Hello, 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...
Hello, 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...
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 ...
I want to compare column named employeeid in two different EXcel sheets and have to retrive the rows with same employeeid ex: sheet1 emp name ...
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...
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...
Hello, 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...
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 ...
DON'T MISS