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...
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...
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...
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...
Hi I am trying to locate 7 digits after 'dell#' in one column and have it replicate those digits to another cell.
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') ...
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...
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...
I have unlocked the scroll lock, but no movement on arrows. I tried a Word Document, the arrow keys worked perfectly..Any ideas??
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 ...
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)...
Hello, I have a price book in Excel with multiple sheets. Sheets are formatted differently except for first three columns (QTY,PartNo,Price). I ...
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...
Hello, I originally posted this in 'Office Software', but since I am moving towards playing around with VBA code and not getting much information,...
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 ...
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...
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
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 ...
Hello, I have a spreadsheet for upcoming projects that will each have a figure budgeted in upcoming specific financial year or years. Financial ye...
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...
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...
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...
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...
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....
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...
Hello, I get large spreadsheets with thousands of lines with close to 200 patient names (one patient contains multiple lines for each different da...
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 ...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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 ...
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 ...
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...
Hello, I found this script from vcoolio, thanks for that! Sub Advise() Dim x As Integer Dim lRow As LonglRow = Range("E" & Rows.Count...
What is the formula to convert numeric in words?
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 ...
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...
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...
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 ...
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...
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 ...
DON'T MISS