Excel Forum
- Solved
-
If/Then Formula Help [Solved/Closed]
Hello, I could use some help on the formula below. I need cells in one column (Y) to show specific text ("SEND") if cells in another column (G)...
-
date format [Solved/Closed]
Hello, i am trying to create a report which will show me the first date and last date of the previous month. I need first date in one field and...
-
EXCEL 2013 :Searching for text and display a different value. [Solved/Closed]
I am fairly new at this, but I work in excel files that are extracted from out problem management system. I created a formula that will look for a...
-
Building a new spreadsheet using information from another [Solved/Closed]
Hello everyone, I'm new to the forum and VBA and would like to thank you in advance for your assistance. I have received a spreadsheet that...
-
Run macro automatically [Solved/Closed]
Hello, I wrote a macro and I want to run it automatically if one special cell change but have problem, because contents cell change by formula in...
-
Macro copy and paste in next blank cell [Solved/Closed]
Hi guys, I need some helping in excel macro. I have two sheets in a workbook. Sheet1 is for summary and Sheet2 is for the raw data. I need to...
-
automatically copy the values from the active row from sheet [Solved/Closed]
Hello, Struggling already for a couple of days.... so a help would be more than welcomed Need to write a macro in Excel which...
-
Macro to copy entire row to next workbook [Solved/Closed]
Hello, Configuration: Windows 7 / Firefox 50.0 I have the following macro to copy entire row when the column has a capital X. I would...
-
A and B column query to provide Sum of column C [Solved/Closed]
Hello and thank you for your help. Please use this scenario for reference: - A B C 1 abc x 1 2 abc y ...
-
search, find & display [Solved/Closed]
Hello, I have been manually filling out the week no's, in a budget sheet, but want to try and auto populate. I have a table with dates and...
-
Change cell color based on another column [Solved/Closed]
Hi All, I am not very good at excel, however I am looking for a solution for the following problem. There are two columns (Column A and...
-
Best resources to learn about PowerPivot? [Solved/Closed]
Hello, I'm expected to use PowerPivot extensively - meaning with complex data models. What would you recommand for a newbie who wants to learn?
-
How To Make an Excel Sheet Equal to Another [Solved/Closed]
Hi, I'm new in Excel, and what I'm trying to do is this: I want to make an entire sheet equal to another, except for one cell, so if I change...
-
Copy paste Rename based on cell value [Solved/Closed]
Hello I have a worksheet named template. I need a VBA code which would copy "template" automatically into a new worksheet and rename the new...
-
Searching for values and creating a list [Solved/Closed]
Hi there, I hope you can help me, so far I have managed to create a formula which searches a range of data (SKU’s) and returns a count of the...
-
how to find value from a column with unique random values [Solved/Closed]
Hello, I need a formula that can get me a value from a column that has unique values and return another cell from that row, can someone help...
-
Auto Generate workwheet from a list and from a template workshee [Solved/Closed]
Hello All, At the moment, I found out how to auto generate worksheet from a list. However, the generated ones are blank worksheets. May I...
-
Excel - A macro to rename existing worksheets based on a list [Solved/Closed]
I have a P.O. spreadsheet with a summary page. Every year we need to create a new file but I would like to create a template that would just...
-
Inserting image in a particular cell in VBA [Solved/Closed]
Hello All, I wanna insert an image into the Activecell but the image is getting inserted into the same default area. Kindly help me regarding...
-
IF statements with dates and criteria [Solved/Closed]
Hello, I needs assistance with "If "statements and criteria within the statement . Column A has a set of start dates Column B has a set...
-
duplicate values in multiple columns [Solved/Closed]
Hello, I'm looking for a formula for a case mentioned below: Consider we have values in three columns I need to find a formula which...
-
Copy data of one sheet to other sheets [Solved/Closed]
Hello, I want a VBA code or excel formula that automatic copy of data from one sheet to another sheets(either sheet 2 or sheet 3...etc)..suppose...
-
Copying & pasting data in next available row in same worksheet. [Solved/Closed]
Hello, I would really like assistance to write a vba code for a macro (using a drop down list) that copies data from A4:E4 and pastes it down...
-
Value from matrix table [Solved/Closed]
Trying to get rate in G14 that comes from the matrix E14 is a list of A3:A10 F14 is a list of B2:J2
-
two tables values with diffrent order and number of values [Solved/Closed]
Hello, I have 2 tables of products (diffrent number of products). 1st table contains: all products (name, SKU): NAME |...
-
calculate my Service Expense as % [Solved/Closed]
Hello, I would appreciate if someone can help me with this problem solving question. I would like to know how to calculate my Service Expense...
-
Error "Range of object Global failed" [Solved/Closed]
Hello Everyone, Kindly check my code for mistakes. I am getting an error in this part of my code as "range of Object _Global failed". Dim...
-
Excel- if this, than return that? [Solved/Closed]
Background: I work for a Recruiting Group & we have a list of candidates in Excel with all mailing info, including the County they live in. I...
-
Trying to concatenate a letter with a date [Solved/Closed]
Hello, I'm trying to keep a date in a recognisable format and precede it with a character. e.g. I want "D" and 27 July 2015 to appear as D...
-
Insert Picture in Excel macro, after crop it, save it to a file [Solved/Closed]
Hello friends, I need to open a macro, after place the name in A1 cell, push a button to insert a picture, base on A1 name, then, after crop it...
-
Find words within cell & put text and color in adjacent cell [Solved/Closed]
Hi there, i'm trying to search for certain word(s) (i.e. "reply??" or "remind") in a cell with a sentence in it, and place a specific text on a...
-
Macros: Copy Invoice Details From One Sheet to Another [Solved/Closed]
Would be very grateful for help with this one I have set up a macro that will print and generate the next reference for my invoices raised in...
-
Calculation of positions in excel [Solved/Closed]
Hello Hello, sir/madam...i am doing some work with the students result in excel...but I faced a problem..it is simple but I havn't got dat in my...
-
Excel Macro's copy data from one sheet to another [Solved/Closed]
Hey Everyone ok, so, I have a document with multiple sheets one of the sheets is a reporting sheet what i am trying to accomplish with not...
-
Get a value from Col A based on the max value found in Col B [Solved/Closed]
Hello, Get a value from Column A based on the max value found in Column B display in Column C. I need to get value Jill in Column...
-
Comparing dates in multiple columns and using one that matches [Solved/Closed]
Hello, I have a table with multiple columns of date values and need to check whether a date in a certain column is less than that date and...
-
Macro to insert a number into cell A11 for 180+ excel files? [Solved/Closed]
I used the macro below to merge a bunch of files but it cut off the last row of data. It looks for the first A cell with nothing in it to end it...
-
Create & name worksheets from a list and copy data [Solved/Closed]
Hi Guys Really new to this and thanks to previous posts on here I have managed to create code to complete the first part of my jigsaw, just...
-
Formula Question: "IF" function with date [Solved/Closed]
I am attempting to create a formula that will enter "Yes" into cell P1 if: the date in Cell E1 is before 07/31/16 AND the date in cell B1 is after...
-
Highlight cells with Text that match data validation menu [Solved/Closed]
I see several similar questions on the forum but not quite the same and the answers don't seem to extend to my situation. I have an Excel sheet...
-
macro to create new workbook and copy data [Solved/Closed]
Hello I am looking for macro to copy rows based on partial cell content of a column. I have an excel spreadsheet called "arc.xlsx" from which I...
-
Compare values in two columns and return the value from third [Solved/Closed]
Hello, I've a table containing four columns. If the values in the first two columns match to particular value (eg. A1="xxxx" and B1="yyy"), I...
-
Place specfic text in cell based on text in an adjacent cell [Solved/Closed]
Hello Folks, Per the preface, I have a cell that has validation rules of "Concur, Non-concur". If the user selects "Non-concur" for that...
-
Adding points from one sheet to another [Solved/Closed]
Hello, I'm trying to record points that students accumulate in a club. In a GoogleForm, I check off the students (Estudiantes) that earned...
-
trying to create an order sheet [Solved/Closed]
Hello, I am trying to create an order sheet in Excel. I have an inventory list with various information. One of the cells is where I input how...
-
Exporting data [Solved/Closed]
Hi am so excited to join this forum!!! Pls I need help. I have 14 sheets on a workbook (for 14 of the company's locations in Canada). The...
-
Conditional format to highlight cell based on date [Solved/Closed]
hi guys! I need some help. I'm creating a spreadsheet to show when car MOT expires. I have a column (F) which has MOT expiry dates...
-
VBA search column for matching string [Solved/Closed]
I am trying to write a script in VBA for excel. For an entire column of data in sheet 2, for each individual cell in a column, I need to search...
-
negative cells [Solved/Closed]
Hello, Please would someone help me with what I think is a simple problem. I have a range of cells which decrease in value and some become...
-
calculate no of days left from today to a future specified date [Solved/Closed]
Hello, How to calculate no of days left from today to a future specified date Configuration: Windows 7 / Chrome 52.0.2743.116
