The discussions
Cells copying and pasting in a empty cell of another sheet
SolvedHello, One Excel file has 2 Sheets. First sheet called "source" and second one called "Bestand" In sheet "source" one cell (a1 for example) must...
Punching time
SolvedHi again! I have this task ofcalculating the punching time of our agents. I have 4 sheets in one excel. "Deliveroo Data" This is where the orders ...
Date am and pm but need the date to change
SolvedHello, 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...
Copy x rows y times and then insert customer id on each set of x rows
SolvedHello, 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 ...
Transferring data autonomously to another sheet with certain text
SolvedHello, I want to copy the words "Pending" and "Candidates" from my main sheet called 'Test Project' to my new sheet called 'Pending Test'. Bot...
Populate data from a column in one worksheet to a cell in multiple other sheets
SolvedIn 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...
Find out date filling cells
SolvedHi, 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...
How to hide text in a excel cell and display it when needed
SolvedHi 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 ...
Seperating time from text
SolvedHello, 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 ...
Vba: delete empty rows based on value of cells
SolvedHello, 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...
How to simply this excel formula
SolvedIs 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,"",...
How to check if a cell contains "%" and calculate accordingly.
SolvedI 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...
Vba copy/paste fixed range a number of times
SolvedHello 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...
Excel - if function with multiple words
SolvedHi 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...
Find a date in a range of dates
SolvedHi 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...
Unable to change date format in excel
Solved/ClosedHello, 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...
If statement
SolvedHello, 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" ...
How to find the latest time per name in a table with names and times
SolvedHello; 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...
Interest on term loan and working capital
Solved/ClosedDear 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...
Summarise hours incurred by month based on multiple criteria
SolvedHi, 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...
Message to appear when 5 cells uncolored cells contain values.
SolvedHello, 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 ...
Code to move rows into another sheet based on certain values
SolvedHello, 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). ...
Auto-populate a sheet with data from different other sheets
SolvedHello, 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...
Copy rows to other sheets based on value in column
SolvedHello, 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...
Replace 'sheet' reference in a formula (not copy data, but get averages)
SolvedHello, 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...
Am not too good on percentage calculation
Solved/ClosedHello please what is the 10 percent of,7200000000
Macro to copy/paste down x times (where x is the number of rows)
Solved/ClosedHello, 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 ...
Send mail if today is the birthday.
SolvedHello, I have a Excel sheet containg profile of some employee like this: Name ID Date of Birth Rahul 335221 15...
Comparing two excel sheets and copying like data to third sheet
Solved/ClosedHi, 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...
Using a named field for autofill
SolvedI 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...
Excel macro - set and autofill a range?
Solved/ClosedHello, 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...
Excel autofilter stops filtering
Solved/ClosedHello, 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...
If a cell contains any text then add a value
SolvedI 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...
Formula in excel to turn numbers into text
SolvedHello, 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...
Automatically update a cell with last modified date and time
SolvedI 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...
Vba find column by name and sort
SolvedHello, 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...
Copy x rows from a worksheet and paste x rows into another worksheet n times
SolvedHi, 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...
Create new sheets based on column a data.
SolvedHi, 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 ...
Arrow keys not working in excel
Solved/ClosedHello, 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...
I want to change date format in excel
Solved/ClosedHello, I want to change date format from SAP system i.e. 20.05.2010. When I apply thru format cell it doesn't work.
Automatically data to another sheet by adding new rows
SolvedHello, 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 ...
Creating search and update command buttons in a userform
Solved/ClosedI 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...
Compare 2 sheets with particular columns
SolvedHello, 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...
Add data to row that already contains data
SolvedI 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...
Automatically copy data from main sheet to child sheets.
SolvedHello, 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...
Copying formulas to multiple worksheets
SolvedHi, 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...
Copy data onto sheet only if cell has text
Solved/ClosedHello, 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...
Vba code to open non excel programs
SolvedHello, 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
Problem with copy in one sheet
Solved/ClosedHello, 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...
I need vba that creates a new sheet for every data entered in column d
SolvedHi, 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 ...
