Excel Forum
-
Enter Data into main worksheet and have it update separate WS [Closed]
I have a workbook that I would like to enter all my data into one main worksheet "2017 Job Cost Analysis" and have that data automatically...
-
WHAT WILL BE THE FORMULA [Closed]
Hello, if A1>A2 THEN C1+C2 AND IF A1
-
Excel for Mac 15.37 copy row to another sheet [Closed]
Hi, Im sure this question has been asked before but I can see it anywhere, please accept my apologies if this has already been answered. I...
-
Lock a cell based on another Cell in the entire sheet [Closed]
Hello, I have drop down selection (Yes/No) in Column A, and I need to lock corresponding cell in Column B if the result is "No" in Column A....
-
How to get the yearly mileage and monthly avg from odometer only [Closed]
How can I get excel to calculate the yearly mileage and monthly avg by just monthly odometer readings? I Here is my...
-
Conditional formatting depending on another cell [Closed]
Hi! I have an excelsheet with a namelist in e.g. cell A2:A10 and next to it are numbers. I am looking for a way to format the namelist if B2:B10...
-
About Excel. [Closed]
Hello, Total number of 5 sheets in Excel should be counted on automatic 6th sheet.
-
Date of brith in words 05/06/2016 [Closed]
Hello, date of brith in words 05/06/2016
-
Update data from one sheet to the next. [Solved/Closed]
The macro I want just takes data from one tab and adds it to another like an update. i suspect that the macro will take some time to make as the...
-
Transferring data into separate work books [Closed]
Hello, I was hoping to get some advice on the best way to transfer data from one work book to another. Both works books are collecting the...
-
Inserted 5 cells in one sheet, automate it in 10 differen sheets [Closed]
Dear, I am a very beginner in Macros. Could you please help to automate my task. I have inserted 5 different cells in a sheet and would...
-
Transfer activity data to new sheet with yes/no criteria. [Closed]
Hello, I need to prepare the excel summary with the help of Master sheet. If the drop down in master sheet is yes, than that option should be...
-
Want the coding to paste some data to another sheet [Closed]
Hello, I want to copy one data to another sheet. But I want the data to be pasted one after another as many time I submit it System...
-
Locate 7 digits after 'dell#' in one column and have it replicat [Closed]
Hi I am trying to locate 7 digits after 'dell#' in one column and have it replicate those digits to another cell.
-
How to look up a value within only a subset of another column? [Closed]
Hello, Thanks in advance for any help! This is my data: X 1 3 X 2 4 Y 1 5 Y 5 4 Y 3 2 And I want to know, does the value in C1...
-
How to use X or Y as variable in particular cells [Closed]
Hello, i want use X or Y as variable or unknown, such that when i varies the value of X or Y it should automatically be updated in cells where it...
-
Google Sheets to keep up with High School Football Scores [Closed]
Hello, Ok I am creating a google spreadsheet to keep up with High School Football Scores. I would like help with a formula that allows me to...
-
Arrow keys not working on spreadsheet [Closed]
I have unlocked the scroll lock, but no movement on arrows. I tried a Word Document, the arrow keys worked perfectly..Any ideas??
-
Conditional formating - apply on more cells [Solved/Closed]
Hello, i'm not so familiar with conditional formatting, so I would like to ask something: I'm making a doc where Column A has number values,...
-
IF and OR Functions Using a Date [Closed]
Hello, I am trying to make a formula that says IF Cell is dateA then the answer is Blue If cell is dateB then answer is Green If...
-
Automatically transfer data from multiple sheets to one sheet. [Closed]
Hello, I have a price book in Excel with multiple sheets. Sheets are formatted differently except for first three columns (QTY,PartNo,Price)....
-
How to get the numbers of days a case has been open in Excel? [Closed]
I want show the number of days a case has been open in an Excel field. Example: a case was open in 01/01/2017 and has not been closed as of...
-
Transfering course information to a seperate tab in Excel [Closed]
Hello, I originally posted this in 'Office Software', but since I am moving towards playing around with VBA code and not getting much...
-
Date format not being accepted [Closed]
I have 2 date columns but no matter what I do they are not being acknowledged as being dates. I opened the same file on my laptop and had no...
-
Date format [Closed]
Hello, i downloaded one excel sheet containing dates in format December 13th, 2011 . i want to change its date format . i tried changing in...
-
Change date format [Closed]
How do i change the below date format into mm/dd/yyyy? 15-12-2015 22-07-2015 22-07-2015 your response is highly appreciated
-
Sending alerts from Excel for expired contracts to email [Closed]
hello, I have a excel sheet (Office 2016) where I register contracts, now I want to set an alert for expired contracts which will then be send...
-
Auto populate sheets dynamically based on specific criteria [Closed]
Hello, I have a spreadsheet for upcoming projects that will each have a figure budgeted in upcoming specific financial year or years....
-
Transferring data from one worksheet into another [Closed]
Hello, VERY new with Excel and have a question I'm sure you'll find basic. I have two worksheets. In one worksheet, column G has text in it...
-
How can decimal convert 0.50+ paise into re 1 in spellnumber [Closed]
Hello, i'm very much satisfied with given solution of amount convert into words. But I'hv question that, how can i change 0.50+ paise into...
-
Autopopulating course information for a Training Log [Closed]
I work in EMS and organize the training for everyone in our service. I'm working on a realistic way to track main categories and sub categories...
-
Macro to Create a New Spreadsheet Based on Another [Closed]
Hello, I have the following problem. I have a spreadsheet in which I record some information regarding an employee and all the exams he has...
-
How to change the date format in Excel 2007 [Solved/Closed]
Hello, i want to know that howcan I change the dateformat in excel 2007 worksheet if I want it like :- monday,1dec.2008 plz. answer me...
-
Change VBA code to get embedded image not link [Closed]
Hi everyone, I have a VBA code, which inserts image into excel based on the cell value entered in coloumn A. My problem is that image is a...
-
Macro to Create New Workbook and Copy Data at Each Change of X [Closed]
Hello, I get large spreadsheets with thousands of lines with close to 200 patient names (one patient contains multiple lines for each...
-
How to compare column and spot the difference [Closed]
Hi. I really need help to solve this problem. I have few hundred data in 4 columns as below. Is there's anyway I can use excel formula to find...
-
Macro to create new workbook and copy data [Closed]
Hello, I need help to modify the code which is already by rizvisa1 in reply to this thread http://ccm.net/forum/affich-286527-macro-to-create...
-
Convert date into Month and Year to use > < [Closed]
Hello, I have two sets of dates that I need to compare using ,=. One of my dates is formatted mm/dd/yyyy. the other date is mm/yyyy. The...
-
Excel macro to create new workbook and copy data [Closed]
In the example below, I want to create five new excel files with the same heading and the data should be copied based on the unique Line numbers...
-
Sentence peekaboo [Closed]
In excel. I am typing a sentence and as soon as I click in another cell half of my sentence disappears. Only to reappear when I click back into...
-
How to make workbook autocreate new sheet every month with data [Closed]
Hello, I am looking for some help, I am wanting my workbook to auto create a new sheet at the begging of every month and that when it makes...
-
Button/VBA to move rows one by one in the same row [Closed]
Hello, I need a button or something to move rows one by one (from 13 to 50) to the row nr. 10. Every row have the same style but different...
-
Copy names from one worksheet to another and copy [Closed]
Hello, I have an issue at work that a macro, if it is possible, would be extremely useful. I have an excel file with a list of hundreds of...
-
Excel help please! [Closed]
Hello, I am in the process of creating an action tracker so it has all the actions that come out of different meetings. Each meeting has a...
-
Macro to transfer column to row on another excel [Closed]
Hi All, Was stuck on this for a few hours yesterday. Read a few threads with solutions but I kept getting a debug popup window. I'm trying...
-
How format a cell that changes to "Complete" or "Incomplete" [Closed]
Hello, How can I format a cell that changes to "Complete" or "Incomplete" when another cell linked to it has a specific text written on it...
-
Excel macro [Closed]
Hello, I'm also very new to macro, so I don't know what I'm supposed to be adjusting! My main sheet is titled "Project Timeline" and my...
-
Copy hyperlink in another sheet when using vlookup [Closed]
Hello guya please help. I have little knowledge in vba. i have an employee details in sheet 1 and i have a vlookup fromula in sheet 2 to...
-
Macro that copies format in Sheet 1 to multiple sheets [Closed]
Hello guys, I need help with the creation of a Macro that is doing my head... Let me try to resume so it is super clear for everyone...
-
Search for input criteria, return designated cells. [Solved/Closed]
Hey all, I am trying to write a VBA command/macro that essentially takes a criteria input from the destination worksheet, searches and matches...
