Hello, Is there a way to create a formula such that each cell in a given column automatically calculates a specific percentage of the value in the...
I wish to highlight entries in one list if they appear in an associated list: I chose to do this by using a modified COUNTIF function, which I had te...
I need a micro that will highlight the cell with the lowest unique value in each individual column. It would not highlight anything if there were m...
Hello, I want Macro for below example, SUBACC STMTPG OPBALDT OPBALTP CLBALDT CLBALTP 123abc 1 04-07-2014 04-07-2014 123abc 1 05-07-2014 05...
Hi, Is there any way I can debug the sentence highlighted in yellow ? Thanks!
Good afternoon, I have one calculation sheet with: - lines/column A: containing the items descriptions, - Column B: quantities - Column C: Unit ...
Hello I need your exel help. I need ro transfer rows of datas for columns with values and not transfer those with -. Thank you
I was having a difficulty in notifying my co-worker to print all the sheets on a workbook. I a thinking if it's possible to have an pop-up message to ...
Hi dears, i am new user in this site So i hope you will find my requst as well I want to copy the filtered data to my excel file (my excel (Sheet,...
I need your help to solve the following problem. I have files containing data about key contacts of company. Company Name,Concerned Person,Designat...
Hello, I need help in getting a formula in excel i have two sheets the fisrt sheet is the refrence sheet the second sheet is where i write my ...
Hello, I have a question I need to lookup a value of col A1 of sheet 1 in col A of sheet 2 and if it matches it gets the corresponding value ...
Hi, How do I remove duplicated data from 3 different worksheets in excel ? Like I have a column of client names on each worksheets. I need to com...
I want to format a cell using 2 conditions from a another variable cell. Example The cell i want to format is A1 using D1. when D1 is between 0....
comparing two worksheets with different column values
Hi, Anybody knows how to convert values into pie chart using macros instead of the insert function? Thanks!
where will I find a 25 letter product key?
Hi. I would like to know if there is a possibility of an automatic data transfer when using specific phrase. For example, this is what we put to each ...
Hello, Im working on huge file of excel. I have many different collums and rows. What i need: I need to copy all data from on generated excel fi...
Hi, I am trying to write a code to find REO in column A and if found replace cell in column B with "(((". Then I want to find AAA in column A and i...
Hello there, Please help! I have a column of dates, where the formatting I've set for "Day of the week, month, day, year". How would I run a C...
Hi, I'm new to this forum and certainly new to VBA. I have a UserForm with 4 listbox. The users select items from the first listbox, they press an "...
Hello, I have a sheet named SENT SMS with information about clients, the service they got, price, if paid or not. In the column P named PAID , if it...
Hi, I'm doing a project which requires excel macros but I'm not familiar with it. There are 2 worksheets 'AMBS Master' and 'fy2013'. The data betwe...
My team uses an excel to track our projects. We have many tabs (8) , but on each tab on Column A, we have a drop down menu that we can select if it's ...
Dear all, I hope to find some help here as I would really like to find an easier way than just insert each picture manually. I am not a pro in VBA...
From the image posted I want to be able to highlight the row when the done column is empty and is not today's date.
Hello, first I would like to thank every one working at kioskea my issue is , I want to lock a set of cells ( A2:M2) if the cell M2="app" and ...
A call for urgent help to anyone out there. In capturing data from archived files I saved this both on my laptop as well as on a plugged in memory ...
1652 1646 1650 1658 1622 1651 1659 1582 1599 1606 1611 1657 1745 1937 1936 1648 1666 1656 1636 if i type like this in diffrence cel...
if the numbers cell A110 means the cell B1 have to calculate the C1 cell and if A1 20 means the cell D1 have to calculate ...... please let clear...
Greetings Kioskea Experts, It has always been a pleasure to approach Kioskea team who always welcome problems with open arms, that is not provided...
Hello, I am working on a project and was hoping for some help any and all excel wizzes if you have the time. Does anyone know how or if one can re...
Hi I had recovered my lost xls format file and tried to open it with excel 2010 version. how can i view it in the new version. Is it possible to tran...
I am looking to create a "If Then" formula for Excel that can put an "X" in the cell if the date I am reffering to (Cell A6) is 0-5 days, next cell 6-...
I want search for strings I have in source(A) in both source(B) and source(C) and when it finds those documents give them the three revisions I ha...
Looking at reviews, I know this request will have a simple answer. I am new to Excel, and I need help on this spreadsheet. I have workbook open. On...
I really need to be able to set up a macro & formula so that once I pick an option from a drop down list on my work book, that will automatically plac...
I have dates in one column, I want to enter a $0 value in another column if that date is >= 5 years in the past. Obviously, I'm a relative newbie with...
Hi all, I am trying to grey out an entire row in excel 2010 depending on a cell's value. Each cell has a drop down list: Yes, No, Maybe etc ...
hi sir/mam, i want to automatic copy a data from sheet to another. all those qty on out column in big warehouse sheet must be copy to small warehou...
Hello, Excel 2003 Date format yymmdd I use Excel 2003 (because I like it) and use the International date format yymmdd (it is the shortest versio...
Good afternoon all, I would like to create a link in a cell that will create a new worksheet in the same workbook. I am new to VBA and Macros so I ...
Is it possible to use if function for following: I have dates in on cell and numbers in other one. Dates are for the whole month and numbers are betwe...
How can I reference the current sheet in a formula for a chart data range?
How can I reference the current sheet in a formula for a chart data range? I am making a large number of graphs; each one references data on the sa...
I need a formula that will allow me to show if any cells in a range have a greater value than 100,if so show "YES". If not, have cell remain blank. I...
Hello, I am trying to have a new worksheet created (from a template) when I type information in a cell. For example, if I type Ellen McKay in ...
How can I automatically create and name worksheets in a workbook based on a list that exists in another sheet "Summary" in the workbook? The list begi...
Hello! Please help me with this quandary for my internship. I would greatly appreciate it :) Here is my problem: I want to match ID numbers in two co...