Excel Forum
-
If function date problem [Closed]
Hello, i am trying to use excel to give me two values depepnding if its a monday or a wednesday i have a date box so every week a person will pu...
-
Comparing two lists of names in Excel and then sorting them [Closed]
Hello, I am wanting to compare two columns of information containing names from two different excel sheets. Names that do not appear on both list...
-
Can I accomplish this with Conditional Formatting or another way [Closed]
Hello, I have two worksheets. I would like to enter values in a column of sheet 1. When any of those values match a value in a table on sheet 2, ...
-
excel [Closed]
Hello, I Want to change date format dd/mm/yyyy to dd.mm.yyyy in MS Excel 2003 Please solve my problem urgently
-
removing false in excel [Solved/Closed]
=IF(D5>=150000,D5*21/100,IF(D5>=100000,D5*15/100,IF(D5>=70000,D5*21/100,IF(D5>=50000,D5*7/1000)))) What,s wrong in this formula Please Help!
-
VBA UDF for Color [Closed]
Hello, I'm sure my question is simple to most of you as I'm new to UDF. I've created the following UDF but cannot apply it across columns when I us...
-
Increment a cell value - conditions applied [Solved/Closed]
Hello, I needed a formula to add a value to a cell when the cell next to it contains a value where that value is obtained by incrementing the value ...
-
Michelle [Closed]
Hello, I am Having enormous difficulty with my MAC keyboard operating in Excel. I feel i must have put the scroll lock on but cannot find any ...
-
want to copy sheet1 data to sheet2 [Closed]
Hello, hi there i am just new to excel and iam trying to understand by praticing by own i want to copy sheet1 data to sheet2 when im typing in she...
-
Apply a negative until 0 is reached in Excel [Closed]
I am trying to create either a formula or a macro (which I do not know how to create) so that the following rule works: (1) If last row of data (ie c...
-
How to merge the data from 2 different sheets into 1? [Closed]
I currently have 2 spreadsheets which show payments from 2 different companies. I'd like to be able to merge them into one spreadsheet which updates i...
-
Rating from Parameter Lookup [Solved/Closed]
Hi.. I have some data that reference parameter to fill Rating in my excel sheet. The problem is those parameter are in Text Type. Here is the e...
-
Nesting if() functions? [Solved/Closed]
Hey guys, I'm relatively new to Excel, so bear with me here. I'm making this spreadsheet to check if the payments of certain products are either la...
-
Excel macro create new sheet copy & paste cells [Closed]
Dear Sir I need help in a macro to create a new sheets with colum A name and copy row cells to the new sheet. Name Age Gender XX 25 M ...
-
automiatic email [Closed]
Hi all, I have used excel for years but never at an expert level. I am currently in a position where I need to view multiple tabs of data daily to...
-
transfer data [Closed]
I am working on a spreadsheet and I need to transfer the ending balance on one page to beginning balance on another page, for the entire tenant list. ...
-
Copy data from one workbook to another workbook using vba [Closed]
Hello, Good Afternoon, I need some help to be able to complete the below task. I need to be able to copy data for 2 different tabs in an wo...
-
HELP HELP HELP Excel Formula [Closed]
Hello, I really need help trying to figure out this formula, as I have tried so many different formulas and can't seem to find one that works. I nee...
-
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 to se...
-
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 displa...
-
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 can ...
-
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 maximum ...
-
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 apprec...
-
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 sho...
-
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 these...
-
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 table. Name_A Name_B Joe ...
-
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) Anybo...
-
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 enter...
-
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 are i...
-
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 nee...
-
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 1 th...
-
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 code...
-
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 chart of...
-
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 COLUM...
-
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 A ...
-
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. Titled "...
-
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 "emp...
-
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 abc.xls...
-
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 number? Example:...
-
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 exampl...
-
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 multiple ...
-
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 spreadsheet... ...
-
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 sheet ca...
-
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 mentioned) Anybod...
-
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 have ...
-
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 wor...
-
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 number i...
-
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 th...
Subscribe To Our Newsletter!
