Excel Forum
-
Conditional formattingon Excel 2010 [Closed]
Can anyone please help me with this!! conditions are: If column A is between B+1 & B+2.5 then its green. If column A is > B+2.5 then its red. If ...
-
Transferring data from one worksheet to another [Closed]
Hello, I have a data dump where i need to run a macro which will segregate selected data to another worksheet: For e.g. Title Date/Time Resource...
-
Count a value change in cells [Closed]
Hi, I'm trying to count how many times did 1 cell from a row has been changed from 1 to 0 and then back to 1, how many times did this form of change h...
-
Conditional Formatting based of another cell [Closed]
Hello, I am attempting to do conditional formatting in Excel 2013. I am trying to make Cell C 3 turn red if cell 1 is 25% less or greater than cell...
-
How to create a file in makro and copy a row from other makro [Closed]
Hello, Please help me how to create a new excel file and copy data into this from other excel file. The new file filename will be a column.xls from ...
-
Transferring Data from one spreadsheet to Another [Closed]
Suppose i have a file name tan.xls and another file names rule.xls! then i want to copy all data in tan.xls file in cell D2 - D22 to rule.xls file in ...
-
Conditional formatting help please [Closed]
I need some help that could possibly save me a huge amount of time. I'm new to conditional formatting and am working on a new method to help my staff...
-
trfing data from master wks to another wks [Closed]
Hi all...I would to get help from here as I trying to input my project data into my Master list. When we select won or lost under the status for proje...
-
replacing a field with value. [Closed]
Hello, I hope someone could help me with this issue, i have a field TN1 and want to copy the one TN1 and replace the first TN1 with 375 and then rep...
-
Enter time in a column by click [Closed]
I'm trying to enter the time in a column by clicking
-
If logical test value [Closed]
Hello, I am trying to use a formula to only add the value of a certain cell (filled with a time unit)(A1), if the date mentionned cell (filled wit...
-
Compare two cells [Closed]
Hello, I am looking for a formula that compares a number in a cell with another number in a different cell on the same spreadsheet and insert the sm...
-
COMPARISON OF TWO CELLS [Closed]
Hello, I need a formula that compares two cells on the same page an inserts the smaller of the two into a third cell. Configuration: Mac OS X ...
-
populating a work sheet from excel based [Closed]
Hello, I need your guidance please: I've got a tall order :) I hope you can help me! I am trying to have a new worksheet created from a templa...
-
Excel sheet automation need help [Closed]
Hello, Dear Concern i am a new user of Microsoft excel. i need help from you. my case is below. in a excel file i have 4-5 sheets with same tab...
-
If Function using date ranges for Annual Quarters [Closed]
I'm trying to make a formula that says If the start date falls within this quarter, Divide the Revenue by the POP (12 months) times either 1, 2 or 3 m...
-
Excel If Function using dates and calculating values [Closed]
Hello, I'm trying populate sales by quarter with rows of business opportunities. I have a column for "Revenue" then a column for "number of Months"...
-
Automatic Transfer and Removal [Closed]
Hello, My first post here. I have a spreadsheet that I am trying to get as automated as possible. What I am trying to do is have a line of 6 cells...
-
Copy an entire row n number of times EXCEL [Closed]
Hi, I need a macro in EXCEL to repeat entire rows n number of times where n is in the row to be repeated. I have tried using answers already here b...
-
Pivot tables and ordering of dates [Closed]
Hello, I have converted standard dates into just a month and year, using the formula I found on this site. I have also sorted my original table of...
-
Insert images in cells [Closed]
Hello, Would anybody know how to change this macro https://ccm.net/faq/14170-excel-a-macro-to-insert-pictures-in-a-worksheet so that images are in...
-
if cell has value copy to the next vba code [Closed]
I'm searching a lot of forums but i cant find exact solution for this. my problem, i'm looking for a macro which will copy any cell in column A if th...
-
notification in excel [Closed]
Hello, How can I get a notification or alert to remind me a an event , per date in cell, is date + 335 days?
-
Different Formulas Based Off of Font Colors [Closed]
I have a cell with a date that the font color is either black or green. I need another cell to recognize the color and use a specific formula to calc...
-
Conditional formatting with range [Solved/Closed]
Hello, I have a little bit of a problem, I want to mark a cell in a range that is equal to another cell in different range, I can't figure it out....
-
If formula using dates [Closed]
I have a spread sheet using projected dates for next training. I'd like to run an "if" formula that would fill the cell red when dates are past due (...
-
Macro for copying 1st 4 rows from 1 worksheet to other worksheet [Closed]
Hello, I have a set of agencies and each agency having a spreadsheet with some details. Every time the 1st four rows are copied and pasted in new...
-
IF/OR Formula [Solved/Closed]
Help please I need to look up a cell and if it =1 return 1, =2 return 0.6, =3 return 0.4, = 4 return 0.2, if >4 return 0.0 for example A B ...
-
Copy Data from Main sheet to another Sheet [Closed]
Hello, I have a document that has a quote on the first sheet. What I want to do is if the code in column C meets a certain criteria, it will auto...
-
Conditional formatting [Closed]
Conditional format A2 if either H2 or I2 is not blank.
-
Partial Match two columns of Data [Closed]
Hello, So I have a Column with the MPN and then another column with the Image location. The image contains the MPN as well as info, but the image c...
-
display value in a cell A7 which is refered to the value in A6 [Closed]
Hello, I want to display value in a cell A7 which is refered to the value in A6 which shows the average of A1:A5 and the value of A6 satisfies the...
-
Script [Closed]
Hi Joe here, Sheet 1 Data A B 1001 HE 1002 SHE 1003 HIS 1004 HERS When I type t...
-
How to save a data excel to non data spreadsheets to excel [Closed]
Hello, I have a question? How to save a data excel to non data spreadsheets to excel Configuration: iPad / Safari 8.0
-
Excel, changed format Tue, 11 Nov 2014 08:14:09" to dd/mm/yyyy [Closed]
Hello, I'm looking to convert the following excel format of "Tue, 11 Nov 2014 08:14:09" to dd/mm/yyyy. Thanks in advance for your answers. j...
-
Identify same values in Column A [Closed]
Hello, I have an excel sheet with too many rows. But in Column A, I have many values which starts with XYZ. I have to identify them and need to use...
-
Inserting different photos into cells- macro [Closed]
Hi, I am not a super savvy programmer, but looking for a Macro that might automate inserting a photo (so user selects image) and then re-sizing the ph...
-
how we can convert number to word in excel [Closed]
how we can convert number to word in excel?
-
Need to create a macro [Closed]
i have no clue on how to create a macro.i need to copy all items in sheet 1 rows to columns in sheet 2 every time its updated. sheet one will change ...
-
Shape not showing Text in excel [Closed]
I moke a shape in excel I wrote text in shape but when I click on another cell the text disappears. Please Help!
-
If Function [Closed]
Hello, I'm having a bit of a trouble working the If Function in excel. Here's my problem: My manager asked me to find the commission fees to cha...
-
Number that turns in to date. [Closed]
Hello, hi I'm Nokuthula. I want to ask why when I try to put a number it turn and become a date. Why is that ? Configuration: Windows 7 / C...
-
How to repeat a row 4 times, while increasing sequence [Solved/Closed]
Hello all, I need help on the best way to repeat this 4 times, and then increase the number at the end. I need this: Column A AAA_BBB_0002135 ...
-
Using one cell to refer to many [Closed]
Hello, I'm trying to do something I'm not sure is possible. I have a spreadsheet to keep track of receipts and group items by category. In one column ...
-
Creating a task reminder for all tasks for that day [Closed]
I'm hoping someone will be able to help me. I need to attempt to create a task reminder pop up that will list all tasks that need to be done today. An...
-
Converting rows of data in notepad to columns [Solved/Closed]
Hello, Needing help please. From a pdf data base supplied, I have copied the contents over onto notepad. The data within this notepad contains firs...
-
Excel [Closed]
Hello, How to copy data from one sheet in a row containing formulas to another sheet in a column but not in a row still have the same data with it...
-
conditionally copy columns [Solved/Closed]
Hello, I have a table with thousands of rows of text. Column B has errors in the data which I have fixed in column C (has many blank cells). I would l...
-
convert Nov-11-2014 to dd/mm/yyyy in Excel [Closed]
Hello, I need assistance, Need to convert the following date of "Nov-11-2014" to dd/mm/yyyy Configuration: Windows 7 / Firefox 35.0
-
find word on Sheet1 move all adjacent column values to sheet2 [Closed]
Hello, I have a list of accounts and information on items inside the accounts along with the account owner. It goes like this, A= account number, B...
Subscribe To Our Newsletter!
DON'T MISS
- How to Fix a Blurry Snapchat Video
- How to Recover Your Yahoo Account
- How to Disabled Write Protection on a USB
- Computer Boots to Black Screen
- How to Create a Gmail Account
- How to Install a VPN
- How to Upload High Quality Photos to Instagram
- How to Get Free Diamonds in Free Fire
- Facebook Code Not Received
- How to Recover a Disabled Facebook Account
- How to Get More Followers on Instagram