Excel Forum
-
need a formula [Closed]
on 1/1/16 (a1) , John (b1) told me he'd pay me $1 in 30 days. i want a formula that will automatically add 30 days from (a1) in date form in another...
-
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 positive n...
-
Extract data from specific cells and paste into a row [Closed]
Our sales department has been using an Excel spreadsheet template to update product specifics, then printing it out and sending to our typesetting dep...
-
code for transferring data [Closed]
i Have an excel workbook with different sheets. In sheet 1, i have date picker, where i select date and enter all the data for that particular date. T...
-
Excel Calendars and how to modify them [Closed]
Hello, I am doing a Calendar for my work. It will include 3 tabs. Tab 1 will be a list of events going on and the date that event will take place....
-
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
-
compare two sheet on weekly to see if any data is missing [Closed]
I have two excel work books which we update daily. Since the sheets are used by multiple users, it is difficult to know if we miss any lines . Is ther...
-
Merge Rows and Seperate Data with Semicolon [Closed]
Hello, I am hoping to merge rows in an Excel document based on shared Names (listed in a single column) and then consolidating the remaining data ...
-
adding new sheets based columns and moving rows to sheets [Closed]
I am new to Excel and need some assistance. Summary: I need to distribute cases to investigators from a raw data list. I would like to create a...
-
Copy data different sheet with multiple columns with same header [Closed]
Hi, I am new to Macros I have situation where some column headers are repetitive like column Header XYZ repeats n times and column header ABC rep...
-
Selecting all colored cells VBA [Closed]
Hello, i want to create a button that once i click it, all colored cells RGB (255,178,178) will be selected. i don't want to fill them or anything...
-
Formula zero return [Closed]
Hello ~ How can I get a zero return instead of a FALSE statement with the following formula? =IF(F4>E4,(F4-E4)*24,IF(F4
-
help regarding a pricing sheet [Closed]
Hello, I'm looking for help regarding a pricing sheet I'm trying to create on excel. I have my quantity in C5 = 2500 and cost in C15 = 75,000 if C...
-
Changing colour of cell once multiple other cells contain text [Closed]
Hello, I would like to indicate in a cell at the beginning of a row whether multiple 'mandatory' cells within the row contain text. Red for incomple...
-
Count if formula [Closed]
Hello, I have a Excel file where i have specific paths of the files and i Need a formula where it should reefr that cell path and Count the rows w...
-
format the color font depending on the value of another cell [Closed]
Im new to Excel. Is there away or formula to change the color font of a cell depending on another cell? I want my text in colum A B C to be the font ...
-
VBA looping/range [Closed]
Hello, im attempting to run this but I want to add in separate loops that search for certain keywords. currently this successfully will find one and m...
-
how do you custom sort data in a pivot table [Closed]
Hello, I need to sort the largest amount in a pivot table how is this done ? Configuration: Windows 7 / Mozilla 11.0
-
excel formula to move a word from one cell to another [Closed]
Hello, Hi what is the formula to move anything that begins with "other: " to the adjacent cell Advocate at Home Advocate at Home Other: Bria o...
-
Creating Remarks from grades [Closed]
How do I create corresponding remarks against letter grades?
-
insert row based on criteria in EXCEL [Closed]
hi friends, i'll get same data in two different sheet with a small changes, i will compare sheet one and sheet two, to create new sheet eg. (...
-
Creating a GANTT Chart with Calendar List of Tasks [Closed]
Hello, Need help in creating a GANTT chart with a calendar function. For example, if according to the GANTT Chart Task 1 is due on the 25th of Octo...
-
Macro to make the same graphs on multiple sheets [Closed]
Hello I have multiple sheets of data, all with the same formatting (although different numbers of data sets) formatted as a table. I am trying to ...
-
Insert 1 result if a cell contains one of several possibilities [Closed]
Hi All, I am new to this level of excel - but what I need is a formula that does the following : Insert if an adjacent cell contains one of up ...
-
Copy values only when using a filter [Closed]
Hello, VBA below, this is doing exactly what I want... however I can not get it to copy values only...not the formulas and a list which is in a co...
-
Preparing a commission worksheet from an excel spreadsheet [Closed]
Hello, I am a payroll specialist. Every two weeks I run a report for all employees who have funded loans. I copy that information into another w...
-
Macro [Closed]
Hello, in excel 2013 I have column of cells a:2:a4955 of the cell.interior.colorindex = 3 then I need to return "red" I can't get his to work.
-
copy paste data from one sheet to another automatically [Closed]
Hello, First of all thanks for your wonderful site. I have a large set of information on one sheet. Column b has the name of the sheets in the ...
-
Copy and paste [Closed]
Hello, i haven't done much lately with VBA so need some help please Copying from Sheets("Input (2)") to Sheets("New Items Added") The rows o...
-
Create Duplicate Sheet [Closed]
Hi all, Is it possible to create a worksheet automatically in the same excel workbook. For e.g i have a sheet "1" with some content (includes f...
-
Auto-copy rows from one tab to another based on cell value [Closed]
Hello! I'm really hoping this works to get a response because I am stumped. I've read a lot of sites and lot of similar posts but nothing seems to...
-
Nested if functions using time values [Closed]
Hello, I have an excel formula here, but it wont work. =IF(AND(G2>=TIMEVALUE("06:00:00"))*(G2=TIMEVALUE("00:00:01"))*(G2
-
Auto Fill in for List - based on another cell's value [Closed]
Hi! I have different sections of an excel document that feature the same lists over and over again. Sometimes the values selected will be different...
-
Copying data from 1 sheet to another using a macro [Closed]
Hello, I am trying to copy data from a specific cell on one sheet (Invoice) to the next blank cell in another sheet. My macro was working well in ...
-
Cut paste data into the left cell of the row below [Closed]
Hello, I have a worksheet with hundreds of thousands of rows and its conditionally formatted to show 2 different colors. Here is a screenshot of ...
-
how could I do automatically find the price [Closed]
Hello, I have question for Excel, it is small hotel booking system? If I have for example 6 rooms, and they have all different prices, i.e. 1...
-
Copy row if criteria is met macro [Closed]
Hello, I am looking to make a macro that will copy the entire line from sheet 1 to sheet 2 if criteria from column H is met. Essentially if th...
-
Starting new sheet from info gained in sheet one [Closed]
Hi I am trying to replace a hard cover book and a manually written piece of paper with the spreadsheet. I work in the building industry doing insu...
-
copy range of cells and paste them multiple times [Closed]
Hi all, My VBA / Coding skills are basic and I've been googling to try to find an answer to my question to no avail. I'm trying to copy a range of...
-
Compare columns and create list of duplicates [Solved/Closed]
Hello I am a complete newbie when it comes to VBA code but I tried to set up a macro with examples I found online. Let me explain my needs. I have a ...
-
Auto Generate a copy of a Template Worksheet and rename each [Closed]
Hello, I am very new to Excel and VB and am trying to create a macro that will do the follow; 1. Create a copy of a template worksheet (named Tem...
-
Conditional Formating of cells [Closed]
Hello, I am trying to set up the conditional formats of cells as follows :In column D place the company name - have the next 13 cells to the right t...
-
help need sample of master sheet [Closed]
hi can give a sample of using excel in exam committee
-
Copy data from one sheet 1 to sheet 2 only if text [Closed]
Hello, I have sheet 1 tracking a lot of different information (Client name, date in, date put etc...) for 2 machines. (Machine A & Machine B) N...
-
need help to macro my invoice number [Solved/Closed]
Hello, I wish to increment my invoice number everytime I open my invoice....format is 1-2015-001 and increment by one 1-2015-002 should be the next...
-
Alphabetical arrangement [Closed]
What formula do you use to arrange items or values in alphabetical order in Excel?
-
Pivot table help [Closed]
Hello, I really hope someone can help me out with this. I would like to know how can I get excel to automatically fill the data (I specified wi...
-
Excel Macro Copy if Criteria is met in a column [Closed]
Hello, I have two sheets and the plan is after the "TotalScores" sheet is filled out, the second sheet "NOPA" will be filled with a macro. For...
-
search value error [Solved/Closed]
HI, The value for false refuses to come up as a blank cell in my formula to find and copy a cell if it contains certain initials, or leave it blank i...
-
Selecting the different Range of cells based on values [Closed]
Hi all, consider the Excel sheet A B C D 1 NAME CITY AGE CLASS 2 ALEX NEWYO...
Subscribe To Our Newsletter!
