Excel Forum
-
Due Date Reminder With An Email to the filtered list [Closed]
Hello, Here I have a filtered list from Master Sheet to DueReminder Sheet In which column I represents Email address Now my motive is...
-
Change date format using Excel Macro [Closed]
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...
-
Comparing Excel sheets with only a few overlapping records [Closed]
Hello, I have two worksheets (1 & 2) that have different info, with not many duplicate records. I need to identify the duplicate records. I...
-
Mtch formula required [Closed]
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...
-
How to make a cell flash using Excel 2011 for Mac [Closed]
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...
-
Find, copy, create a row under, paste, loop. [Closed]
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...
-
Excel - Merge several worksheets into a single one [Closed]
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...
-
Replace cell content in Excel 2007 [Closed]
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...
-
macros or vba for data validation [Closed]
Hi, I have a data in sheet1 with ID, name ,area, amount,January amt,February amt.....(below month column particular dates are mentioned) ...
-
1 time data entry [Solved/Closed]
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...
-
Add an X to cell if other conditions met [Closed]
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...
-
convert numbers to words in excel [Closed]
please clarify my problem "convert numbers to words in excel"
-
mm/dd/yy AND dd/mm/yy AND mm-dd-yy AND dd-mm-yy in one column [Closed]
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...
-
transferring data [Closed]
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...
-
Replacing duplicates [Closed]
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...
-
Notification popup every time a cell to change certain color. [Closed]
Hello, my English is not good, so I'm using google translator, sorry about that. I am creating a spreadsheet where is the organizational...
-
DUE DATE REMINDER IN EXCEL TO NEW SHEET? [Solved/Closed]
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...
-
Compare two sheets and copy cell if match found. [Closed]
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 ...
-
Copying a row to another sheet with a trigger [Closed]
Hi All, I was preparing an excel workbook, based on the sales pipeline. To simpify, The first sheet has company name and contact column....
-
To create new sheet every time new information is added [Closed]
I am currently creating a wage calculation template in excel. There are 3 sheets currently in my file. First is "employee information". Second is...
-
Excel transfer of comments [Closed]
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...
-
different colour for each formula result obtain in one cell [Closed]
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) ...
-
Format based on another cell with a letter. [Closed]
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...
-
Copy the whole column on to the another column master sheet [Closed]
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...
-
Regarding Pivot [Solved/Closed]
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...
-
Colouring the rows if some conditions are meeting [Closed]
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...
-
Paste at end of data [Closed]
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...
-
Need macro code [Closed]
Hi, I have a data in sheet1 with ID, name ,area, amount,January amt,February amt.....(below month column particular dates are...
-
Counting Words, Names as Number Values [Closed]
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...
-
Find the first available (empty) cell on a worksheet. [Solved/Closed]
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...
-
function for finding unique data in one spreadsheet to a second [Closed]
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...
-
Trying to see if I can even create a Macro! Please help! [Closed]
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...
-
Lookup problem. [Solved/Closed]
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...
-
copy row from sheet 1 to sheet 2 [Closed]
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...
-
Copy Paste Data in Same column for multiple time [Solved/Closed]
Hello, i need following manipulation.... Data Before Column "A" 123456 123456 123456 123456 123456 ( After )Column "A" (After...
-
macro [Closed]
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
-
How to change text color dep.on the value of another cell. [Closed]
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...
-
multiple IF functions with dates [Closed]
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...
-
compare a cell whit itself (conditional formating) [Closed]
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...
-
due date reminder ahead of one month and mail that to customers? [Closed]
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...
-
Replacing Duplicates [Solved/Closed]
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 ...
-
compare and copy in column [Closed]
I want to copy data in column 'B' when column 'A' is not blank. 'A' column has some blank rows. please give me solution!
-
Excel - Macro to highlight Rows with Duplicate values in a cell [Solved/Closed]
Geetings, Kindly help us in creating a macro that highlight rows based on duplicate values in a cell [this cell may contain Alphabets, Numbers...
-
KEY BOARD SHORTCUTS TO NAVIGATE ALONG AN EXCEL SHEET [Closed]
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...
-
Macro for copying data from multiple woorkboks in to single wrkb [Closed]
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...
-
IF function with DATE in Excel [Solved/Closed]
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...
-
How can I create worksheet as date from 1 Jan 15 to 31 Dec 15 [Closed]
Hello, I would like to create 365 worksheets with sheet name as date. Could anyone help me. Many thanks in advance. :))
-
Highlight duplicate rows based on selected columns - excel macro [Closed]
Hello All, Require a macro which could highlight the duplicate rows in excel. Duplicate is identified based on the selected columns. Table:...
-
function in excel that auto identify the words from the other s [Closed]
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...
-
Unprotect sheet greyed out [Closed]
Hello, i cannot unprotected my Excel sheet please help me with this problem. i appreciate your answers and thank...
