Excel Forum
-
create a formula such that each cell in a given column auto [Closed]
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...
-
highlight entries one list if they appear in an associated list [Closed]
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...
-
Excel Golf Skins Sheet [Solved/Closed]
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...
-
Need to merge data logically [Closed]
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...
-
Help to debug this sentence for me please ? [Closed]
Hi, Is there any way I can debug the sentence highlighted in yellow ? Thanks!
-
Copying formula from column to another [Closed]
Good afternoon, I have one calculation sheet with: - lines/column A: containing the items descriptions, - Column B: quantities - Column C: Unit ...
-
Transfer datas from one workbook to another [Closed]
Hello I need your exel help. I need ro transfer rows of datas for columns with values and not transfer those with -. Thank you
-
VB script to notify/popup [Solved/Closed]
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 ...
-
How can Copy one Excel Content to a new Excel File By Click Comm [Closed]
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,...
-
Excel - A macro to re-arrange cells [Closed]
I need your help to solve the following problem. I have files containing data about key contacts of company. Company Name,Concerned Person,Designat...
-
help in lookin up a value [Closed]
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 ...
-
lookuk a value in 2 columns and get value of third (help) [Solved/Closed]
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 ...
-
Remove duplicated data [Solved/Closed]
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...
-
How to use conditional format on another cell [Closed]
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 [Closed]
comparing two worksheets with different column values
-
Automation of pie chart using the values in excel [Solved/Closed]
Hi, Anybody knows how to convert values into pie chart using macros instead of the insert function? Thanks!
-
erosdrews [Closed]
where will I find a 25 letter product key?
-
Automatic transfer of data [Closed]
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 ...
-
microsoft excel large file [Closed]
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...
-
vba find replace adjacent cell and go to next find if not found [Closed]
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...
-
"COUNTIF" function for day of the week formatting [Closed]
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...
-
UserForm ListBox save data and modify [Closed]
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 "...
-
Automatically move a row to another sheet [Closed]
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...
-
Excel macro [Closed]
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...
-
Transferring Selected Data from Multiple Worksheets to One [Solved/Closed]
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 ...
-
Automatically insert multiple pictures in excel under 1 ref [Closed]
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...
-
More than one rule in excle [Closed]
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.
-
locking a range based on a value of a cell [Solved/Closed]
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 ...
-
Removing duplicate data [Closed]
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 ...
-
require help to count number [Solved/Closed]
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...
-
Grater then , less then with number range multiple [Solved/Closed]
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...
-
Macro-Microsoft Outlook-Export Subjectline, To:, cc: and Subject [Closed]
Greetings Kioskea Experts, It has always been a pleasure to approach Kioskea team who always welcome problems with open arms, that is not provided...
-
Relative worksheet reference in formula for chart data ranges? [Closed]
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...
-
converstion of xls file to xlsx format [Closed]
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...
-
Excel "If Then" Formula [Solved/Closed]
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-...
-
comparing three columns and giving back specified values [Closed]
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...
-
Search and transfer data between workbooks [Closed]
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...
-
Moving data from one spreadsheet to another on Excel [Closed]
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...
-
Need help comparing dates... [Solved/Closed]
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...
-
Grey out an entire row in Excel 2010 depending on a cell's value [Solved/Closed]
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 ...
-
automatic copy on excel [Closed]
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...
-
Excel 2003 Date format [Closed]
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...
-
Step by Step help creating a link [Closed]
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 ...
-
If function with dates in one cell and numbers in other one [Closed]
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 do I make relative worksheet references?-excel 2010 [Closed]
How can I reference the current sheet in a formula for a chart data range?
-
Reference the current sheet in a formula for chart data ranges? [Closed]
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...
-
Less than/greater than [Closed]
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...
-
Create a worksheet when information is typed in a cell. [Closed]
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 ...
-
Auto Generate a new worksheet from list in another worksheet [Closed]
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...
-
Automate Excel to shift data so the values in two rows match? [Solved/Closed]
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...
Subscribe To Our Newsletter!
