Excel Forum
-
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...
-
Change a range dynamically - VBA script. Solved/Closed
Hi everyone. I am stuck on a small problem with writing a Macro in Excel and would appreciate some help. I have the following script: For...
-
logging Closed
I have a form that we have to manually insert data into. And I would like to log the data in a sperate workbook of list of 200 people. Logging it i...
-
copying info Closed
Hello, How do I get information in one cell to two there sheets with out copy and paste. The info in the cells are the same on all three sheets bu...
-
If formula Closed
This formula is killing me! I have a column of numbers E3:E12. These are dollar amounts of bills that have been paid. E13 contains the sum of t...
-
details to another worksheet fr main worksheet using macro Closed
Hi, I trying to input my project data into my Master list. When we won or lost the project, the data will auto disappear and transfer to the Won list ...
-
Date not showing up as a date??? Closed
Hello, I have entered & formatted a column as a date but shows up as a 5 digit number. I followed your instructions and it still showing up as a 5 ...
-
Ms. Closed
working with several worksheets in one notebook, how do I get amounts from sheet 1 plus sheet 2 plus sheet 3 etc. to total to the final total sheet? ...
-
Conditional Formating Closed
I have several rows of data and a legend which needs to apply based on the mutiple values. The idea is that D1/D2 equals a % if that percentage is a...
-
Macros code Closed
My excel depends on date column.... I have used macros to calculate all my required columns. So when I generate data for today or tomorrow I get on...
-
Macro for transferring data from one excel to different excel Closed
Hi I need macro for transferring data from one excel to different excel. Here I want to transfer data from "Book" = "temp", "Sheets" = "auditreport...
-
Looking for help with a macro/vba for find/copy/paste Closed
I have a lot of data in column A of a spread sheet. I would like to "search" for part of a string, and then copy the row of the cell with this data in...
