Excel Forum
-
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 like to...
-
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 copy...
-
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 Configurati...
-
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 ('3') ...
-
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 is p...
-
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 color...
-
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, column ...
-
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 A9=(2017,9,9)...
-
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). I ...
-
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 today. H...
-
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 information,...
-
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 problem ...
-
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 form...
-
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 via ...
-
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. Financial ye...
-
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 and in...
-
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 re 1...
-
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 for ea...
-
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 been su...
-
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 soon....
-
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 link, an...
-
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 different da...
-
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 the ...
-
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-new...
-
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 goa...
-
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 (Colu...
-
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 the be...
-
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 the ne...
-
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 dat...
-
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 first...
-
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 seperate...
-
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 to tr...
-
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 i.e. Y...
-
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 other s...
-
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 show th...
-
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 : SHEET ...
-
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 the ...
-
Inserting and formating date with userform Closed
Hello, I am trying to Insert a date with a Textbox in a Userform. It should have this format: Friday, 18.08.2017. This entered Date is used...
-
Copying dates to another worksheet. Solved/Closed
Hello, I found this script from vcoolio, thanks for that! Sub Advise() Dim x As Integer Dim lRow As LonglRow = Range("E" & Rows.Count...
-
How to convert numeric into words in Excel Closed
What is the formula to convert numeric in words?
-
Excel formula - Add days to date based on drop down selection Solved/Closed
I want to add days to a date based on options selected from a drop down list. For example, if cell C5 reflects "New Hire" or "Post New Hire", I want ...
-
Comparing Two Excel Sheets and copying like data to third sheet Closed
Hi, In your below coding, I can copy paste the alike data from sheet 1 only, I need to copy paste both from sheet 1 and sheet 2 line by line matchi...
-
VBA: Cell Range Closed
Hello, I am a beginner with VBA and I have a question that might sounds stupid to some. I have created a function of IfElseIf and I want to run it...
-
Search for text , cut and paste into new work sheet Closed
Hi , can anyone help me with the below vba code : Logic Find text If next row starts with number Then - cut 1 row above text and 3 rows below ...
-
Dropdown menu disappears quickly before you can even choose Closed
My excel has been acting weird lately. All dropdown menu disappears quickly before you can even choose your choices. This happens in Data Filter fun...
-
Transfer data from one sheet to another Closed
Hello, i have started an inventory sheet on excel what I want to do is take the list of inventory and when it is sold, have it transfer to the second ...
-
How to compare two excel sheets and combine matching data Closed
Hello, I'm looking for a macro that will match data in column A from sheet 1 to the data in column A from sheet 2 and copy the corresponding rows f...
