The discussions

Date am and pm but need the date to change

 Solved

Hello, I have 12 workbooks, what I am trying to figure out is I have the date and time in one cell. But I has it 1/1/2020 00:00 then them next lin...

2 replies Last reply on 14 Jan 2020 by
TrowaD

Copy x rows y times and then insert customer id on each set of x rows

 Solved

Hello, I have a set of criteria, 56 criteria as of now, and I have to check how many criteria each customer meets. In one tab I have the list of the ...

1 reply Last reply on 14 Jan 2020 by
TrowaD

Transferring data autonomously to another sheet with certain text

 Solved

Hello, I want to copy the words "Pending" and "Candidates" from my main sheet called 'Test Project' to my new sheet called 'Pending Test'. Bot...

2 replies Last reply on 17 Dec 2019 by
TrowaD

Populate data from a column in one worksheet to a cell in multiple other sheets

 Solved

In a workbook, I want to be able to copy all the cells in column B of sheet "Raw Data" into multiple copies of an existing template sheet correspondin...

4 replies Last reply on 11 Dec 2019 by
Vee1893

Find out date filling cells

 Solved

Hi, First of all thanks for your help I have a big excel file which I have been filling it for the last 2 years. There is a way to find out the da...

5 replies Last reply on 6 Dec 2019 by
Marcus

How to hide text in a excel cell and display it when needed

 Solved

Hi friends I have doubt in excel. I have a column called 'Status' and want to show the text either as 'Pending' or 'Completed' depending on the ...

1 reply Last reply on 25 Nov 2019 by
TrowaD

Seperating time from text

 Solved

Hello, I have a task in my office that i can't get done and it is very impossible to finish within 1 week as these are 14,000+ orders. The sheet ...

1 reply Last reply on 25 Nov 2019 by
TrowaD

Vba: delete empty rows based on value of cells

 Solved

Hello, my code works transfer my invoice from sheet1 to sheet 2 but my problem i would adjusted my code to become delete rows from a19: e32 i...

15 replies Last reply on 4 Nov 2019 by
TrowaD

How to simply this excel formula

 Solved

Is there a way to make this formula simpler? =IF($K9=0,"",SUM($L9*$L11)/R9+IF($K9=0,"",SUM($M9*$M11)/$R9+IF($K9=0,"",SUM($N9*$N11)/$R9+IF($K9=0,"",...

3 replies Last reply on 28 Oct 2019 by
TrowaD

How to check if a cell contains "%" and calculate accordingly.

 Solved

I am wondering how to do that? I learnt no basics, just went on by myself trying to figure out things and so here is what I am trying to do.. Ba...

7 replies Last reply on 18 Oct 2019 by
Saurabh

Vba copy/paste fixed range a number of times

 Solved

Hello Team, I'm looking for a VBA code to copy the three rows and with input box paste based on the times, I entered in the input box. FOr ex...

6 replies Last reply on 15 Oct 2019 by
TrowaD

Excel - if function with multiple words

 Solved

Hi I'm trying to write a formula to produce a yes/no answer depending on whether the data in a previous cell in the same row contains any of the wo...

14 replies Last reply on 8 Oct 2019 by
user

Find a date in a range of dates

 Solved

Hi All. Another silly Macro question that I cant seem to find an answer for ... As my wife does silly shift at work I have developed an excel sp...

4 replies Last reply on 2 Oct 2019 by
BrianGreen

Unable to change date format in excel

 Solved/Closed

Hello, I have an excel worksheet with a date column, the format is set to dd-mmm-yyyy but the dates in the columns display as mm/dd/yyyy. If I doubl...

39 replies Last reply on 6 Sep 2019 by
Tobby

If statement

 Solved

Hello, I am really struggling to get the correct formula for below situation: example: Cell A2 is a "due date" Cell B2 is a "completion date" ...

4 replies Last reply on 30 Aug 2019 by
ac3mark

How to find the latest time per name in a table with names and times

 Solved

Hello; I have a sheet with a list of "use name" and "time" (which is a login date). I need to find for each user the latest date . But users have sev...

11 replies Last reply on 27 Aug 2019 by
TrowaD

Interest on term loan and working capital

 Solved/Closed

Dear CCM, I dont know "interest on term loan and working capital, profit before taxes and profit after taxes""..etc anybody can help me to solve...

1 reply Last reply on 24 Aug 2019 by
ac3mark

Summarise hours incurred by month based on multiple criteria

 Solved

Hi, I want to summarise hours incurred mthly (from the time_converted column) based on the grade and agency but can't seem to get the below formula...

4 replies Last reply on 19 Aug 2019 by
Micwhsct

Message to appear when 5 cells uncolored cells contain values.

 Solved

Hello, A macro using excel that can return a message when 5 uncolored cells that are in a range of colored and uncolored cells contain values. The ...

1 reply Last reply on 13 Aug 2019 by
TrowaD

Code to move rows into another sheet based on certain values

 Solved

Hello, I'm having trouble figuring out how to do something! I have a sheet (Design) with work order details on it (columns A-J will have data in). ...

6 replies Last reply on 13 Aug 2019 by
vcoolio

Auto-populate a sheet with data from different other sheets

 Solved

Hello, I have been having problems with having a general data sheet in my workbook. My problem is as follows: I have 3 different sheets, all of w...

59 replies Last reply on 29 Jul 2019 by
ac3mark

Copy rows to other sheets based on value in column

 Solved

Hello, I have copy and pasted the code used to solve the problem for the question which began this thread. I have 6 tabs into which I want to...

16 replies Last reply on 26 Jul 2019 by
vcoolio

Replace 'sheet' reference in a formula (not copy data, but get averages)

 Solved

Hello, I'm working with a precipitation data base of multiple sheets. Each sheet is a year of measurements. The thing is that I'm trying to ge...

5 replies Last reply on 13 Jul 2019 by
vcoolio

Am not too good on percentage calculation

 Solved/Closed

Hello please what is the 10 percent of,7200000000

1 reply Last reply on 10 Jul 2019 by
kieferschild

Macro to copy/paste down x times (where x is the number of rows)

 Solved/Closed

Hello, I could sure use some help on a Macro. I need to copy the value in E1 and paste down to all cells in column E (E2 to E??) The issue ...

41 replies Last reply on 8 Jul 2019 by
TrowaD

Send mail if today is the birthday.

 Solved

Hello, I have a Excel sheet containg profile of some employee like this: Name ID Date of Birth Rahul 335221 15...

11 replies Last reply on 19 Jun 2019 by
bkdroid13

Comparing two excel sheets and copying like data to third sheet

 Solved/Closed

Hi, I'm trying to compare two sheets in excel and have matching column data copy the entire row into a new third sheet. Ex: Compare Sheet 1 column...

11 replies Last reply on 18 Jun 2019 by
TrowaD

Using a named field for autofill

 Solved

I am performing an Autofill using a macro. Is there a way to enter the ranges using a "Named Field" in the macro without having to hardcode them in t...

2 replies Last reply on 12 Jun 2019 by
excel987

Excel macro - set and autofill a range?

 Solved/Closed

Hello, I am creating an excel macro to reformat a CSV file. In doing this, I need to select a column (F) and replace the values in that column with a...

28 replies Last reply on 11 Jun 2019 by
excel987

Excel autofilter stops filtering

 Solved/Closed

Hello, I am working with Excel 2003 professional and just yesterday after entering a bunch of records to my file, which has about 19,000 rows, I di...

45 replies Last reply on 11 Jun 2019 by
thankful

If a cell contains any text then add a value

 Solved

I hope someone can help me with this...I've done this before but can't remember how. I have a list of names (for an attendees list) and I need to s...

20 replies Last reply on 5 Jun 2019 by
Pharmanumbers

Formula in excel to turn numbers into text

 Solved

Hello, I found formula but sir I want at last as per below. As per formula =words(1234) = one thousand two hundred thirty four But sir I wan...

4 replies Last reply on 31 May 2019 by
venkatesan

Automatically update a cell with last modified date and time

 Solved

I am maintaining a Test Environment Catalogue, with various users editing it. It is change controlled in SharePoint, however, I'd like to insert a cel...

2 replies Last reply on 16 May 2019 by
NazCarr

Vba find column by name and sort

 Solved

Hello, I am trying to make a code that should: - Go to the first worksheet - Find the first column with header "sku" - Sort this column ascen...

4 replies Last reply on 30 Apr 2019 by
bOFILL

Copy x rows from a worksheet and paste x rows into another worksheet n times

 Solved

Hi, I am struggling to create a macro that can copy an excel range of data (A1:B50) from sheet 1 and paste into sheet 2 for 4000 times. Currently, sh...

20 replies Last reply on 29 Apr 2019 by
TrowaD

Create new sheets based on column a data.

 Solved

Hi, Is there a way to create a new tab based on column A? For example: I want to create a new tab for each vehicle, copy and paste all of vehicle ...

4 replies Last reply on 26 Apr 2019 by
Jay

Arrow keys not working in excel

 Solved/Closed

Hello, I am using Excel 2000. I am tring to move from one cell to another in Excel by using the arrow keys on my keyboard but nothing happens. I wa...

59 replies Last reply on 15 Apr 2019 by
Nelson

I want to change date format in excel

 Solved/Closed

Hello, I want to change date format from SAP system i.e. 20.05.2010. When I apply thru format cell it doesn't work.

13 replies Last reply on 2 Apr 2019 by
mohammed

Automatically data to another sheet by adding new rows

 Solved

Hello, I have created a "request form" - the form is not designed in VBA - it is simply a spreadsheet using Column B, only, and each row has either ...

9 replies Last reply on 26 Mar 2019 by
TrowaD

Creating search and update command buttons in a userform

 Solved/Closed

I have created a userform for inputing new records in an Excel spreadsheet. I have written the code for the Save Record and Close Form command button...

19 replies Last reply on 24 Mar 2019 by
ShezzyWiggle

Compare 2 sheets with particular columns

 Solved

Hello, hear is the situation, sheet1 is having "item code (ex. 150007) in column A", and "Rack ID in column B (ex. AA001)" & other side in she...

2 replies Last reply on 5 Mar 2019 by
SunilD

Add data to row that already contains data

 Solved

I want to enter data for the same product but it needs to be done on different days, with two different entry forms, so the row will already contain d...

2 replies Last reply on 1 Mar 2019 by
aileen

Automatically copy data from main sheet to child sheets.

 Solved

Hello, I know this question was asked in another thread (https://ccm.net/forum/affich-800808-need-to-automatically-copy-data-from-one-sheet-to-ano...

5 replies Last reply on 1 Mar 2019 by
vcoolio

Copying formulas to multiple worksheets

 Solved

Hi, I have a workbook that contains 32 worksheets. 31 identical sheets that are basically days of the month. Last one is a summary sheet. I have t...

11 replies Last reply on 2 Feb 2019 by
subodh

Copy data onto sheet only if cell has text

 Solved/Closed

Hello, I need to copy formulas and data from a selection of cells in a worksheet (Figures) onto a seperate sheet (summary). I would like the inf...

17 replies Last reply on 29 Jan 2019 by
checjb

Vba code to open non excel programs

 Solved

Hello, I need vba code to open other documents besides excel doc's e.g open a word file, access file etc.. Can anyone help?? thanks PM

10 replies Last reply on 7 Jan 2019 by
Billybob

Problem with copy in one sheet

 Solved/Closed

Hello, There is a table on sheet1 for example. A B C D E 1 2 3 4 5 In cell A1 I drag the data from sheet2 cell A10 In cell A2 I drag t...

26 replies Last reply on 4 Jan 2019 by
ac3mark

I need vba that creates a new sheet for every data entered in column d

 Solved

Hi, I need a formula that create a new sheet for every data in "D" column cells and sheet name is like the cell ,also add that cell whole row data ...

3 replies Last reply on 26 Dec 2018 by
ac3mark

Budgeting forumla in excel

 Solved/Closed

Hi! So I'm trying to write a budget for my household. Payments are made from different accounts. I've included an example. If anything in Colu...

2 replies Last reply on 22 Dec 2018 by
nfez

Copy rows n times in excel

 Solved

Hello, I Need to copy from rows from A1:AY39 and need to insert in A41 and the same as be pasted on next 38 Row from A41 and it as to be done for ...

8 replies Last reply on 20 Dec 2018 by
vcoolio
Results 151 - 200 out of a total of 1,686