Excel Forum
-
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...
-
Excel 2013 to extract text in one cell [Closed]
Hi, I want to extract in the right column, a part of the left column, for instance: see below 2 lines for each line at the right column I want to ext...
-
how to transfer data from sheet to sheet 2 [Closed]
Hello, I have created an excel file which I need to track progress of each order, in the first sheet I have created the list of things that needs ...
-
IF statement [Solved/Closed]
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" ...
-
Dynamically Assign a Number in Data Set [Closed]
Hello, I have a large data set and need to assign a number to each row if the status changes. Is there a short cut / dynamic way that I can assign...
-
transfer data from userform to sheet with the same format of table [Closed]
hi, experts i have userform contains 3 textbox and sheet1 contains table i designed from 3 columns i would every time when fill data in userform ...
-
How to find the latest time per name in a table with names and times [Solved/Closed]
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...
-
Need to create linked sheets [Closed]
Hello, I have an excel sheet this is for a list of unavailable items however I need to create another sheet for 1 specific team. So my sheet is lik...
-
SUMPRODUCT Based on WBS [Closed]
-
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...
-
get help Macro sheet [Closed]
Hello, My name is vivekanandan i am try to create macro sheet like compare two different excel file and get the output in new excel file but i am ...
-
Spreadsheet help moving data [Closed]
So I'm trying to make a macro that moves data from an input sheet to the appropriate sheet based on information in a given cell that is being entered....
-
Excel vba to color row based on wbs level [Closed]
Hello I need a macro to change row color based on "Level" column. Thanks Ebti
-
Copy from one cell and paste to another sheet based on length of another column [Closed]
Hi I am using the code below to copy and paste from one column to another based on cells containing data in column A, what I need to do it copy data f...
-
Summarise hours incurred by month based on multiple criteria [Solved/Closed]
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...
-
Are you still taking questions? [Closed]
Hello, Are you still taking questions?
-
Message to appear when 5 cells uncolored cells contain values. [Solved/Closed]
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 ...
-
Code to move rows into another sheet based on certain values [Solved/Closed]
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). ...
-
create an ordering list for our consumables [Closed]
Hello all, New user here! I am new to coding in Excel (pretty much Excel itself) and do not have access to Access. I would like to create an orde...
-
False Value removal [Closed]
Hello, How to remove false value if I use below formula =IF($K4="Urban",IF(N4>0,1,0))
-
Checking the values in Sheet1 with multiple entries in Sheet2, Write the output [Closed]
Hello Experts I am having 3 different sheets: In sheet 1, I have columns A- K & Sheet 2, I have columns A-G. I need to find column H values from Sh...
-
Creating a data input sheet with excel [Closed]
Hi, So I am attempting to create a dashboard whereby data can be inputted in different categories and then once the data is submitted it is sent t...
-
Count cells containing text per row [Closed]
Hello, I am trying to figure out and if statement to add 1 if there is text in a row so that at the end of the row I will get a total for each time ...
-
Excel Formula to identify similar text [Closed]
Good day, I am looking for help with an excel formula to identify similar text within two columns. In column A there will be a specific word wit...
-
Search using variable [Closed]
Hello, I am trying to enter a value (name or partial name) and perform a search in the specified column. I can easily put a specific string in the ...
-
Auto-populate a sheet with data from different other sheets [Solved/Closed]
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...
-
Copy rows to other sheets based on value in column [Solved/Closed]
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...
-
transfer data from sheet1 to sheet2 [Closed]
Hello, i have data in sheet1 from range a1: f91 when i fill data and transfer to sheet2 it also transfer the empty rows here i wanna delet...
-
macro code vba exel sum dublicate data and delete [Closed]
hi, everybody i need help code vba exel i have data in sheet1 begening from cells a2:g100 many data are dublicateed i would the sum dublicate ...
-
Copy Template, Rename based on a reference list from a different spreadsheet [Closed]
Hello: I am trying to make copies of a template in a worksheet, and rename those worksheets from a list on a separate worksheet. Currently my templa...
-
Replace 'sheet' reference in a formula (not copy data, but get averages) [Solved/Closed]
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...
-
Copying Excel data from one sheet to another based upon contents of a cell [Closed]
Hi, I have a spreadsheet containing two sheets. Sheet 1 contains the following: Col A - username Col B - Full Name Col C - Email address Col ...
-
Am not too good on percentage calculation [Solved/Closed]
Hello please what is the 10 percent of,7200000000
-
How to duplicate rows x number of times [Closed]
Does anybody know how I can repeat rows in a spreadsheet by n number of times specified in cell B in that row ie from this table: Column A, Col...
-
Follow up Q to how to add a certain number of days to a date in excel [Closed]
Hello, Thank you for your article with the handy tip. What way would one make use of to fill the contents of a single row (or column, depending ...
-
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 ...
-
Compare sheets macro [Closed]
Can you please help me with the code for comparing two spreadsheets and giving the result in a separate sheet. The range may be different for the two ...
-
Which macro (of many) changes the data in my workbook [Closed]
I am working with an old macro enabled spreadsheet that has many tabs and many macros. On one tab I have a column that reports "yes" or "no" when the...
-
Formula to subtract one cell value from another. [Closed]
Hello, I am trying to do a formula that would subtract cell a2 from a1 if cell a3 has "Closed" in it. Is this possible?
-
Auto Transfer questioner with right answer to another sheet [Closed]
Hello, I have questioner list (yes or no) about 60question. I want to make it automatically transfer (all the row) to another sheet if answer is ‘N...
-
Insert Picture in Ms Excell [Closed]
Hello Friends, Please help me out, how I can insert the picture in front of the name automatically. Means I just select the images these pictures auto...
-
partial matches in lists of 6-digit numbers [Closed]
Hello! I have a list of ~500 6-digit numbers. They were all hand entered, and we want to proof the list and see if any of them were duplicated by typi...
-
Formula to create generations based on birthday [Closed]
I need a formula in excel that will indicate generations based off of a birthdate. Generations: Traditionalists (Prior to 1943) Baby Boomers (194...
-
Copy and paste selected cells a given number of times [Closed]
Hello, I had a quick course on macro and I would like to write my first one, but I would need some help with it. Id like a macro which copies t...
-
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 15...
-
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...
-
Getting multiple largest values with specified limits [Closed]
Hello, a1 is 110,a2 is 236,a3 is 175,a4 is 352,a5 is 257,a6 is 175.In b1 find value is greater than or equal to 400.i need all answers numbers not re...
-
Extract data from few XML file into Excel. [Closed]
Hello, i hope someone will be able to assist me, and i hope it is possible to do what i need. I need to extract specific data from a few XML files...
-
COMPARING 7 COLUMN [Closed]
HI I WOULD LIKE TO KNOW HOW TO COMPARE 7 DIFFERENT COLUMNS AND FIND COMMON VALUE IN NEW COLUMN I'M ATTACHING ONE SAMPLE HERE PLEASE CHECK AND...
-
Trying to insert multiple rows between rows in excel with copied data. [Closed]
Hello, I have used the two listed vba macros but i am having no luck combining the two. First one to add 13 rows between current data: data is on ...
Subscribe To Our Newsletter!
DON'T MISS
- How to Disabled Write Protection on a USB
- How to Create a Gmail Account
- How to Recover a Disabled Facebook Account
- How to Recover Your Yahoo Account
- How to Get Free Diamonds in Free Fire
- How to Install a VPN
- How to Get More Followers on Instagram
- Facebook Code Not Received
- How to Upload High Quality Photos to Instagram
- How to Fix a Blurry Snapchat Video
- Computer Boots to Black Screen