Hello, Here I have a filtered list from Master Sheet to DueReminder Sheet In which column I represents Email address Now my motive is to se...
Hello, In SAP BI I have created a BEx Query. We can see BEx reports in MS Excel. Date format in the report is DD/MM/YYYY and I want it to be displa...
Hello, I have two worksheets (1 & 2) that have different info, with not many duplicate records. I need to identify the duplicate records. I can ...
Hello, In one column - A i have name for eg -Anuj Muchhala and another column B - Anuj & column C - Muchala - I want to know how to match maximum ...
Hello, I have Excel 2011 for Mac. Is it possible to make a cell flash using the Mac version of Excel 2011? If so, how is it done? I would apprec...
Hello, I would like to ask for a macro (as I was unfortunate to experiment with a lot of them and none of them worked as I'd like). What it sho...
I use Excel to store information about several users and their cars information and have a different worksheet for each month. How to merge all these...
Hello, I've two columns like below and i'd like to replace the one in 1st column with the one in column B in another table. Name_A Name_B Joe ...
Hi, I have a data in sheet1 with ID, name ,area, amount,January amt,February amt.....(below month column particular dates are mentioned) Anybo...
Hello, is there any way that make a condition for a cell which don't let to any body change the cell after they enter the date. i mean when i enter...
Hello, I've got a list of products for an e-commerce site. What I'm trying to do in Excel is flag any items that have a quantity of zero AND are i...
please clarify my problem "convert numbers to words in excel"
Hello, I have the problem of having all the 4 date formats in the very same column: mm/dd/yyyy dd/mm/yyyy mm-dd-yyyy dd-mm-yyyy I would nee...
Hello, Dear to whom it may concern, I want the data in sheet 1 to automatically export the data in sheet 3 and when the row is empty in sheet 1 th...
Hello Trowa Sorry to bother you again but a problem has arisen. Everything was working OK until I tested "Pair names 4" Column Q. When I ran the code...
Hello, my English is not good, so I'm using google translator, sorry about that. I am creating a spreadsheet where is the organizational chart of...
Hello, I Have a problem in this code =INDEX(Master!$B$3:Master!$B$1067,MATCH(TODAY()+30,Master!$H$3:Master!$H$1067,0)) HERE I HAVE COLUM...
Hi guys. I have two sheets and would like to compare sheet2 with data in sheet1 and copy a cell data from sheet1 to sheet2. Eg: SHEET1 A ...
Hi All, I was preparing an excel workbook, based on the sales pipeline. To simpify, The first sheet has company name and contact column. Titled "...
I am currently creating a wage calculation template in excel. There are 3 sheets currently in my file. First is "employee information". Second is "emp...
from excel file to excel file, how can I get comments updated automatically, similar to vlookup or hlookup? i.e. comment in cell c4 of file abc.xls...
Hello, In Excel , I want different format for formula result in one cell. A1=0 & A2 = THANKYOU =if(A1=0,"OK","NOT OK")&RIGHT(A2,5) ----...
Hello, I would like to know if there is a way to apply a format formula to a cell but to use a letter as criteria instead of a number? Example:...
Please help. I want to make an excel sheet in which i can copy one whole column onto the another column in all my sheets of master sheet. For exampl...
Hi I am doing Pivot for multplie data . In the Value field ( bottom right ) , I need SUM as default instead of count . I have to drag multiple ...
I am trying to create a macro of some sort to do some checks to make sure everything is populated correctly. Here is an example of the spreadsheet... ...
Hello, I'm trying to write something that will copy and paste cells AC10:AQ15 from a sheet called "Format" to the end of column AC on the sheet ca...
Hi, I have a data in sheet1 with ID, name ,area, amount,January amt,February amt.....(below month column particular dates are mentioned) Anybod...
Hi, Ive been searching for a way to count a list of names as a number. I currently have to place a 1 in a column next to the list of names. And have ...
As a newbee to VBA, my boss has given me an impossible task ... Basically I need to be able to enter one cell worth of data from one sheet of a wor...
Hello, I have a spreadsheet of 500 rows. Each row contains on unique "item Number". I am looking for function that will locate the unique number i...
I want to know if its even possible to create a Macro whenever I copy/paste information that is provided to me weekly, which in this case is in th...
I have a column of 20 dates in col. B spaced by 2 or 3 weeks, and a number beside each one in col. C. In cell C24 I need a formula that returns the v...
Hello, Please help as this is doing my head in.... I Have two worksheets, for arguments sake "sheet 1" and "Sheet 2" within my workbook, I wish...
Hello, i need following manipulation.... Data Before Column "A" 123456 123456 123456 123456 123456 ( After )Column "A" (After copy p...
hi friend, i have txt files in folders i want to cumulate all txt files in single file and import data to excel please provide macro for this
Hello, I have 2 questions: 1. I'd like to change one's name color to red if that is in debt. 2. want to count a. all names (number of all people); b...
Hello, I am rather new to creating Excel formula I want to create the following rule working with dates: IF date in A1date in A2, then date ...
Hello, i want to know is that possible to compare a value of a cell with itself. for example i enter "10" in cell B2 tomorrow i want to change it...
dear sir/madam Here there are 6 columns with 'n' number of rows. Column 'E' represents DUE DATE of particular 'Sol ID' and this date is common...
My Excel spreadsheet is set out as follows: A B C D E F 1 2 14 0 14 14 2 1 13 0 13 13 3 4 4 1 4 4 4 3 3 1 3 17 ...
I want to copy data in column 'B' when column 'A' is not blank. 'A' column has some blank rows. please give me solution!
Geetings, Kindly help us in creating a macro that highlight rows based on duplicate values in a cell [this cell may contain Alphabets, Numbers or ...
Hi all, I would like to know if there is a keyboard shortcut to navigate from, for example sheet 1 to sheet 2 on the same excel file without using th...
Hi All, I need to copy data from 20 workbooks and save in the single workbook, by using condition like, " Date " so if run the macro all the workbo...
Hi, hope someone can assit. I need to create a sheet where I must take the current date and add a fulle week or two weeks to the date by selecting an ...
Hello, I would like to create 365 worksheets with sheet name as date. Could anyone help me. Many thanks in advance. :))
Hello All, Require a macro which could highlight the duplicate rows in excel. Duplicate is identified based on the selected columns. Table: C...
I would like to know if there is any function in excel that auto identify the words from the other sheets and apply the formula on that specific cell ...
Hello, i cannot unprotected my Excel sheet please help me with this problem. i appreciate your answers and thank you. Configuration: Wind...
DON'T MISS