Forum
- Solved
-
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...
-
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...
-
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...
-
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...
-
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....
-
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...
-
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...
-
Copy rows to other sheets based on value in column [Solved]
Hello, System Configuration: Windows / Chrome 75.0.3770.142 I have copy and pasted the code used to solve the problem for the question which...
-
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...
-
Am not too good on percentage calculation [Solved/Closed]
Hello please what is the 10 percent of,7200000000
-
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...
-
Send mail if today is the birthday. [Solved/Closed]
Hello, I have a Excel sheet containg profile of some employee like this: Name ID Date of Birth Rahul 335221 ...
-
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...
-
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...
-
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...
-
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,...
-
If a cell contains any text then add a value [Solved/Closed]
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...
-
Formula in Excel to turn numbers into text [Solved/Closed]
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...
-
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...
-
VBA find column by name and sort [Solved/Closed]
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...
-
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....
-
Create new sheets based on Column A data. [Solved/Closed]
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...
-
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 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.
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
Copying data from one Excel sheet to another. [Solved/Closed]
Hello, Newbie here. Okay, I have an Excel workbook that houses a form on the first sheet. What I'm trying to do is to automatically copy...
-
Copying formulas to multiple worksheets [Solved/Closed]
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...
-
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...
-
VBA code to open non excel programs [Solved/Closed]
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
-
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...
-
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...
-
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...
-
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...
-
VBA to compare column E from 2 sheets and copy entire row to sheet 3 [Solved]
Hello, I have a worksheet where I want to compare values from sheet 1 and sheet 2 and if values in column E (both sheets) are the same to...
-
Excel formula to track accrued vacation [Solved]
Hello, I need help writing a formula in excel to track accrued vacation / personal time. During our employees first year of employment they...
-
Copy rows based on a condition [Solved/Closed]
Hi How can I have excel copy the entire row of data from worksheet Employee Inventory to another worksheet called EEs if column Q contains...
-
How to merge data from different Excels [Solved]
Hello, My name is samar. I have a master sheet which cakculates all oaraneters for my team . To calculate this some raw data is needed . I...
-
Recalculation of dates [Solved]
Hello, Hello, I'm trying to write a formula that will recalculate a date based on a fixed number of days. For example I have 2/1/19 in cell...
-
Populate separate worksheets with data from main worksheet based on criteria met [Solved]
Hello, I'm making an accounting workbook and I've run into a problem. On the first sheet "Sales Log" I input all of the transactions that...
-
Paste value on filtered cells [Solved]
Hello, i was trying to "pasted value" on a filtered cell. but it seems to be pasting it to all cells... im using a "=concatenate" on several...
-
Formula I should use [Solved/Closed]
I am so confused on what formula should i be using for my work...? Which should be ending up like this...
-
Comparing two columns using partial match logic [Solved/Closed]
I need a bit of help please. I have 2 columns of data that I am doing a partial match compare (first 15 positions) using a formula in column AA....
-
Copy rows to rows on another worksheet if " ✔ " [Solved/Closed]
Hi everyone, Ultimate greenhorn here. I have just recently discovered the " Conditional Formatting " as well as VBA function on excel a week ago...
-
VBA command button [Solved]
Hi Everyone, I need help creating the following: I want to create a CommandButton that when clicked it will check column "CB" for "YES" and...
-
Count total quantity by date into month [Solved]
Hello, Good Day~ Kindly help to correct the formula for below, I had wrote a formula that to calculate the quantity by month to the order...
-
Google Play Store (APK)
-
Minecraft
-
xVideoServiceThief
-
TubeMate YouTube Downloader for Android
-
Instagram for PC
-
Microsoft Office 2010
-
Truecaller: Caller ID & Dialer for Android
-
Adobe Flash Player
-
Facebook Lite for Android
-
YouTube Downloader HD