Excel Forum
-
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 same da...
-
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 ...
Subscribe To Our Newsletter!
DON'T MISS
- How to Install a VPN
- How to Disabled Write Protection on a USB
- How to Fix a Blurry Snapchat Video
- How to Recover Your Yahoo Account
- Computer Boots to Black Screen
- How to Recover a Disabled Facebook Account
- How to Create a Gmail Account
- How to Get Free Diamonds in Free Fire
- How to Get More Followers on Instagram
- Facebook Code Not Received
- How to Upload High Quality Photos to Instagram